Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Oracle User identified EXTERNALLY
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: ashoke.k.mandal_at_medtronic.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Fri Sep 06 2002 - 11:53:32 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |