Home » Other » 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: 39
Registered: February 2012
Location: PUNE
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: 68775
Registered: March 2007
Location: Saint-Maur, France, https...
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: Sat Feb 14 06:18:29 CST 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.