Log into your database via sqlplus with sysdba priv’s with a single command. You may set up an alias if you wish.
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!
To make sure sure you in the correct instance enter:
SQL> select name from v$database;
