Login to Oracle as sysdba in one command June 20th, 2009
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 end 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;
courtesy http://www.tech-recipes.com/rx/226/login_to_oracle_as_sysdba_in_one_command/
