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 !

Report message to a moderator

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: 1736
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

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 05:17:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.