1) Create a password file: [oracle @ test dbs] $ orapwd file = orapwtestdb password = admin entries = 5 Note: This file the default file name is orapwSID, for other file names are not identified. At the same time must be set to the value of remote_lo ...
Recently, when connecting to the database using sqlplus encountered a problem: With non-oracle user can connect to db: [root @ test ~] # sqlplus root @ testdb SQL * Plus: Release 10.2.0.1.0 - Production on Thu Aug 20 05:44:00 2009 Copyright (c) 1982, ...
When I use the lsnrctl status query db port status, it was found that: [Oracle @ test admin] $ lsnrctl status testdb LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-AUG-2009 01:27:27 Copyright (c) 1991, 2005, Oracle. All rights reserved. Con ...
Recently found the time to connect a database problem, when I connect from the local time when there is no problem with it: oracle @ test admin] $ sqlplus / nolog SQL * Plus: Release 10.2.0.1.0 - Production on Thu Aug 6 03:17:04 2009 Copyright (c) 19 ...