Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sys login as sysdba fails in OEM

474556Dec 6 2005 — edited Dec 7 2005
System: Oracle Database 10g 10.1.0.2.0 with Oracle Database 10g Patch 10.1.0.4.0 on a SUN Solaris 9 SPARC machine.

Background:I've made a whole database backup and been trying to recover it back again. First i've tried that with RMAN but i didn't got all my data back in place.
Now i'm trying to run the recovery via the Enterprise manager. I create a job for it, my databases shuts down and I get the possibility to "perform recovery"

Problem:When i'm on the login page to continue with the recovery i have to fill in the Host Credentials and the Database Credentials as sysdba.
I know for sure that what i fill out in those fields is correct. The problem is that i can't login.
As Database Credentials do i fill in for username: sys and password: the correct paswd. It says that the Role = SYSDBA.
the error message: Unable to connect to the database.
ORA-01017: invalid username/password; logon denied
Neither can i log in with sys, password as sysdba via the Enterprise Manager when the database is up and running.

Things i've tried:login with sqlplus works fine
sqlplus "/ as sysdba"
SQL> connect sys/<paswd> as sysdba
Connected.
SQL> show user
USER is "SYS"

Question:How can I solve the problem so i can log with sys users as sysdba with the Enterprise Manager?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 4 2006
Added on Dec 6 2005
2 comments
1,658 views