This content has been marked as final. Show 3 replies
ravi02 wrote:It is happening because you are logged into the o/s using an account that is a member of the dba o/s group.
When I issue the following commands in sqlplus in oracle 11g Rel2 in solaris
connect sys/wrong password as sysdba
connect ja;dslfjas;dfjas;/kj;asdkjf;asdk as sysdba
it is connecting both at idle state as well as at open state also.
Why it is happening so and how to rectify this problem.
It is not a problem to be rectified. It is working as designed.
Rob's pointed you to the docs and Osama's solution will necessitate a valid username/password to be used. This means that the following will no longer work:
SQL> connect / as sysdba
That may be what you want or not. But, as I said initially, things are functioning as designed it's a matter of configuration.
Edited by: Mark Williams on Feb 1, 2013 12:57 PM
Read the documentation about [url http://docs.oracle.com/cd/E11882_01/server.112/e25494/dba006.htm#sthref74]authentication for SYS user
to prevent this add the below line to sqlnet.ora