Re: Oracle User identified EXTERNALLY
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).
RE: Oracle User identified EXTERNALLY
Did you set the init.ora parameter for external authentication? Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, September 06, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: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: [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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen 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).
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: [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).