enigmacmpr
asked on
Oracle 11g - ORA-01017 error: invalid username/password; logon denied
Hi,
I downloaded and installed Oracle 11g on windows 2003. Ran through the wizard and accepted all defaults including creation of ORCL database. I then went through the DB configuration wizard and created a new db, tablespaces and users. Connected through sqlplus and ODBC no issues.
I then created another db and added new users for the 2nd db and I am unable to connect to the 2nd database with the new userid/pwd created. I am also unable to connect to the new database with sys as sysdba. All of them are giving ORA-01017 error: invalid username/password; logon denied .
regards,
Kashyap
I downloaded and installed Oracle 11g on windows 2003. Ran through the wizard and accepted all defaults including creation of ORCL database. I then went through the DB configuration wizard and created a new db, tablespaces and users. Connected through sqlplus and ODBC no issues.
I then created another db and added new users for the 2nd db and I am unable to connect to the 2nd database with the new userid/pwd created. I am also unable to connect to the new database with sys as sysdba. All of them are giving ORA-01017 error: invalid username/password; logon denied .
regards,
Kashyap
You need to set ORACLE_SID at command/shell prompt and then sqlplus /nolog and then try to connect from SQL prompt. In SQL*Plus, from whatever is configured in Net 8, you need to give <user name>/<password>@net8alias for SID/Service. The first database work okay since ORACLE_SID is set by default. It is when you add additional databases that this problem crops up.
ASKER
I have a followup question. The two databases that are setup are being used by different applications. I am essentially trying to establish connectivity from another server. In the services I see both services and the listenerservice are started and is using default port 1521.
What do I need to do so that both databases are accessible?
What do I need to do so that both databases are accessible?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Never both the services use same port. If u chk again the 2nd db may be using 1522 port as per my understanding.
Set env variables Oracle_HOME and ORACLE_SID to which u trying to connect and try again.
Set env variables Oracle_HOME and ORACLE_SID to which u trying to connect and try again.
Possible Causes and Remedies in:
http://www.cryer.co.uk/brian/oracle/ORA01017.htm
http://ora-01017.ora-code.com/
Specific solutions in:
http://www.dbmotive.com/oracle_error_codes.php?errcode=01017
http://forums.oracle.com/forums/thread.jspa?threadID=348017
http://sap.ittoolbox.com/groups/technical-functional/sap-basis/ora01017-invalid-usernamepassword-logon-denied-493730
http://www.orafaq.com/forum/t/54844/0/
https://forums.sdn.sap.com/message.jspa?messageID=7164752
http://dbaforums.org/oracle/index.php?showtopic=2108
http://www.cryer.co.uk/brian/oracle/ORA01017.htm
http://ora-01017.ora-code.com/
Specific solutions in:
http://www.dbmotive.com/oracle_error_codes.php?errcode=01017
http://forums.oracle.com/forums/thread.jspa?threadID=348017
http://sap.ittoolbox.com/groups/technical-functional/sap-basis/ora01017-invalid-usernamepassword-logon-denied-493730
http://www.orafaq.com/forum/t/54844/0/
https://forums.sdn.sap.com/message.jspa?messageID=7164752
http://dbaforums.org/oracle/index.php?showtopic=2108