Login to Oracle as sysdba in one command

Contributor Icon Contributed by jshcenck  
Tag Icon Tagged: Oracle  

Log into the database via sqlplus with sysdba priv’s with a single command. This can be setup with an alias, if you’d like


1. Log into the server as the oracle user and ensure you have the effective group of the appropriate DBA group. Typical unix installations have the OS user as ‘oracle’ and the dba group as ‘dba’ (not to be confused with the ‘oinstall’ group).

2. Check your account with the unix ‘id’ command. Make sure your environment variables are set to the appropriate database:

$ id
uid=510(oracle) gid=500(dba)
$ env | grep ORA
ORACLE_SID=TESTDB
ORACLE_HOME=/opt/app/oracle/product/9.2.0

3. connect to the database

$ sqlplus "/ as sysdba"
SQL>

4. that’s it! be *very* careful!

you might want to make sure you are really in the instance you expect

SQL> select name from v$database;

 

4 Comments -


  1. alex said on December 22, 2008

    on 10g you can log in with:

    sqlplus / as sysdba

  2. Eziafa said on April 9, 2009

    I just started using oracle in Nigeria and we are not yet connected to the world grid. I do not know if I will make it here or go abroad to study it.

  3. Anonymous said on November 20, 2009

    my scott/tiger is not working…how can i login in oracle 8i?

  4. Anonymous said on January 12, 2010

    hello u first get connected with sysdba
    conn/as sysdba;
    later
    alter user scott identified by password;
    it wil work fine then

    Regards,
    Rajesh.N

 

RSS feed for comments on this post. TrackBack URL

Leave a comment -