Check for os_authent_prefix (I think) in init.ora. Should be set to OPS$.
Some people set it to a null string so that they can avoid using the OPS$
prefix. But the advantage to using a prefix is that you can connect
locally without a password and remotely with a password.
-- Philip
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 06, 2002 12:53 PM
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Philip Douglass
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).
