Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Ora-01017: invalid username/password: logon denied
Oraclelearner
post Jun 10 2008, 10:03 AM
Post #1


Advanced Member
***

Group: Members
Posts: 152
Joined: 6-May 08
From: 99324
Member No.: 22,933



Hello,

I am having a problem logging in to one of my databases as the SYS user. I have reset my password for this account in OEM. However, when I try to login to this account, I am getting the following error:

ora-01017: invalid username/password: logon denied.

Can anyone tell me how to resolve this error even after resetting the SYS password?

Thank you,
OracleLearner
Go to the top of the page
 
+Quote Post
dave
post Jun 10 2008, 10:35 AM
Post #2


Advanced Member
***

Group: Members
Posts: 5,207
Joined: 8-October 04
Member No.: 785



being flippant - but put the right person in

What you set it to either isnt what you think it was or you are in a completely different database
Go to the top of the page
 
+Quote Post
burleson
post Jun 10 2008, 03:33 PM
Post #3


Advanced Member
***

Group: Members
Posts: 11,706
Joined: 26-January 04
Member No.: 13



>> resolve this error even after resetting the SYS password?

You won't get this error if you use the correct password.

http://www.dba-oracle.com/t_ora_01017.htm

Checklist for ORA-01017 errors:

- Check that user ID exists

- Check grants

- Check your environmental parameters ($ORACLE_SID), e.g.:

- If using external authentication (ops$) verify that os_authent_prefix=ops$ and remote_os_authent=true your initialization/spfile.

- Check tnsnames.ora to ensure the the service name points to the correct server and instance name.


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Jac
post Jun 10 2008, 04:16 PM
Post #4


Advanced Member
***

Group: Members
Posts: 80
Joined: 23-February 07
Member No.: 7,138



QUOTE (Oraclelearner @ Jun 10 2008, 07:34 PM) *
Hello,

I am having a problem logging in to one of my databases as the SYS user. I have reset my password for this account in OEM. However, when I try to login to this account, I am getting the following error:

ora-01017: invalid username/password: logon denied.

Can anyone tell me how to resolve this error even after resetting the SYS password?

Thank you,
OracleLearner




did you use orapwd or you used alter user command? check oracle sid is set properly.
Go to the top of the page
 
+Quote Post
Madrid
post Jun 13 2008, 07:25 AM
Post #5


Advanced Member
***

Group: Members
Posts: 31
Joined: 24-March 08
From: New York City
Member No.: 19,793



Are you providing the SYSDBA role at connection time? Do you have your oracle password file configured? And are you referring to the 10g EM DB Control or to the 9i OEM? There are differences between them.


--------------------
~ Madrid

hrivera99.blogspot.com
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd November 2014 - 04:23 AM