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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 24 06:43:45 CDT 2013

Total time taken to generate the page: 0.33365 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.