Oracle 11g - ORA-01017 error: invalid username/password; logon denied


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 .


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
enigmacmprAuthor Commented:
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?

You have to ensure in LISTENER.ORA entries for the both databases
to make them visible for the Listener.

For STATIC registration of the Oracle service to the Listener:

Go to the remote 10g installation where the Oracle server resides.

Backup LISTENER.ORA file!!!!!!!

In ...\network\admin open listener.ora


    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Ora10g)
      (PROGRAM = extproc)
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)

Add the entry
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
with regard to the particular Oracle Home and SID Name.

Restart the Listener.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day 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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.