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
ganesh_gvn
Messages: 28
Registered: February 2012
Location: PUNE
Junior Member

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.

thanks.
Ganesh
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: 59199
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.

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


Current Time: Tue Sep 23 13:35:02 CDT 2014

Total time taken to generate the page: 0.14162 seconds