CODEWITHSUNDEEP
oracle-databaseoracle11gsqlplus
sam
sam

Reputation: 2616

oracle can not connect to system user as sysdba?

I am facing weird problem when trying to connect to the system user using sqlplus (running as administrator) as below:

conn system/system@JDT as sysdba

But I get message that says:

ERROR:ORA-01017: invalid username/password; logon denied

When I connect as below, it is connecting normally

conn system/system@JDT

I tried to access the same user using toad as sysdba and normal, and I can connect with no problems... Why am I just not able to connect to system user as sysdba only through sqlplus?!

Upvotes: 0

Views: 4913

Answers (2)

sandman
sandman

Reputation: 2118

I don't get why you would want to give any other user sysdba privileges. SYS and SYSTEM have different functions in oracle. However, if you really have to, then you can do:

grant sysdba to system

and then you should be able to connect.

We normally connect SYS as SYSDBA or / as SYSDBA (with OS authentication) but only when we have to.

Upvotes: 2

Amatya Annamaneni
Amatya Annamaneni

Reputation: 27

When you execute conn system/password as sysdba, Oracle won't even check the user and password

Check http://docs.oracle.com/cd/B28359_01/server.111/b28310/dba006.htm#ADMIN11046

Upvotes: 0

Related Questions