Home » RDBMS Server » Enterprise Manager » Not allowing connection as SYS, but can connect as SYSTEM / Normal (ORA-28009: connection as SYS should be as SYSDBA or SYSOPER )
Not allowing connection as SYS, but can connect as SYSTEM / Normal [message #448126] Fri, 19 March 2010 11:50 Go to next message
playitsafe
Messages: 19
Registered: January 2009
Location: NJ
Junior Member
Cannot connect as sys with SYSDBA or SYSOPR in the Enterprise Manager.

The windows user has domain admin privilege, and is part of the Ora_DBA group.

I can connect as following from command line with no problem:

sqlplus sys/password@power.test.com:1521/power as sysdba

All the oracle Services in Windows connect as "Local System".

The password for the sys account has never changed since inception. I have had this problem since we changed the login account for the Windows login. We created another account (thanks SOX !) with better naming convention,and the same privileges. Since then, cannot log in to EM using sys as sysdba or sysoper.

Help !
Re: Not allowing connection as SYS, but can connect as SYSTEM / Normal [message #448859 is a reply to message #448126] Thu, 25 March 2010 07:06 Go to previous message
babuknb
Messages: 1733
Registered: December 2005
Location: NJ
Senior Member

Have you added new user account In Local Policy -> Log on as a batch job & Log on as a service ?

Babu
Previous Topic: Getting java.lang.Exception: Exception in sending Request :: null Error
Next Topic: Error: Java.lang.Exception: Exception in sending Request::null
Goto Forum:
  


Current Time: Thu Oct 23 15:26:56 CDT 2014

Total time taken to generate the page: 0.09999 seconds