Home » SQL & PL/SQL » Client Tools » login with SYSDBA (11GR2.Redhat 5.5)
login with SYSDBA [message #546513] Wed, 07 March 2012 04:33 Go to next message
Messages: 39
Registered: February 2012
Location: PUNE

Dear All,

I am issuing following command to connect to oracle

HOME-oracle:/home/oracle>sqlplus anything/anything as sysdba

when i am using above command then I am able to connect to SQL prompt Also when I am trying to use xxxx/yyyyy as sysdba,
still it is connecting to sql prompt

I have noticed that whatever user/password is use and try to connect with SYSDBA , it is connecting.

What is the key role SYSDBA is playing here.

I have read the password file management but not got tooo much from there . Even I have not understood the OS authentication and DB authentication .'

please need comment on above.

Re: login with SYSDBA [message #546518 is a reply to message #546513] Wed, 07 March 2012 04:42 Go to previous message
Michel Cadot
Messages: 67235
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is time to read:
Database Concepts
(search for "Connection with Administrator Privileges" and follow the links).

Note that this is a FAQ and you should find the answer using the "Search" link above.

Previous Topic: Unable to use isqlplus
Next Topic: Script to compare two schemas from different instance of DB
Goto Forum:

Current Time: Wed Jul 08 17:32:41 CDT 2020