Hi All,
Here is the situation .
I have a Unix user called oracle on a Sun Solaris box.
I created the user called ops$oracle by using the following syntax.
CREATE USER OPS$ORACLE PROFILE DEFAULT IDENTIFIED
EXTERNALLY DEFAULT
TABLESPACE USERS TEMPORARY
TABLESPACE TEMP ACCOUNT UNLOCK;
GRANT CONNECT TO OPS$ORACLE;
Now I login to Unix box as oracle(Unix user), set up the Oracle
environment(ORACLE_SID, ORACLE_HOME etc).
Then try to login to sqlplus but It prompts for password or it says invalid
username/password.
I am under impression that I should be able to login to Oracle without specifying the
Oracle password as described below. But I am not able to do so as shown below. Could
you please tell me what am I missing and how can I log into oracle through the Unix
user without specifying the password as it should be identified externally.
Thanks,
Ashoke
Unix> sqlplus /
SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 6 10:40:59 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
I also tried
Unix> sqlplus ops\$oracle
SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 6 10:44:27 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Enter password:
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandal, Ashoke
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
