test admin

How to use password file authentication method for connecting a database

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 ...

Why oracle user Rom db?

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, ...

how to turn on the tracing?

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 ...

the problem of database links

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 ...
Recent
Recent Entries
Tag Cloud
Random Entries
Latest Comments