DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: connecting as sysdba

  1. #1
    Join Date
    Feb 2002
    Posts
    267

    connecting as sysdba

    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

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    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

  3. #3
    Join Date
    Jan 2003
    Location
    India
    Posts
    7
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width