connecting as sysdba

[Sonia]

hi folks,

SQL> connect sonia/sonia as sysdba;
Connected.
SQL> show user;
USER is "SYS"


SQL> connect sonia as sysdba
Enter password:
SQL> show user
USER is "SONIA"


Why does this happen; ie., when i give the password along
with the connect clause it works; but not when i give
separately

Regards
sonia

[hrishy]

Hi sonia

sqlplus is just a oci application it is not doing anything different..it just queries username from v$session and throws it to you..

regards
Hrishy

[akalsingh]

Hi,

Yah I agree Sqlplus is just throing the o/p. but both the connected sessions can perform the same task? like Startup & shutdown. I think its No.

see sonia, actually to operate the Database Startup, shutdown and other Admin activities remotely using like RMAN, OEM or for any other tool they have to be connected as SYSDBA to the database. for connecting as SYSDBA you had both ways.
1) you can use the Orapwd file passwd and connect using sqlnet. or
2) yah, using connect command at SQL prompt. but, when you use (username/password) it reads the remaining argument like "as sysdba" b'coz I think the code is like that it needs "/" and later some value as password...... But, if their is no "/" after username then its reading only the 1 value and prompting for password, its like a normal connectivity....

Have you tried like this also. Is their any difference......???
SQL > CONNECT SONIA/SONIA AS SYSDBA
SQL > CONNECT SONIA/SONIAAA AS SYSDBA
SQL > CONNECT SONIAAA/SONI AS SYSDBA

Have you found any thing...??

Regards,
Singh.