Link to home
Start Free TrialLog in
Avatar of enigmacmpr
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
Avatar of k_murli_krishna
k_murli_krishna
Flag of India image

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.
Avatar of enigmacmpr
enigmacmpr

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?

ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.