Problems starting one of two databases on same server
I have created two Oracle 9i databases on a Sun SPARC machine, and both the
databases reside on the same server. One database name is OraSun and
the other database name is OraTest. Now to start the OraSun database I just
issue a command STARTUP and then OraSun starts, but when I
try to start the other database, OraTest, on the same machine with the
startup command I receive the following error:
ORA-01081:Cannot start already running ORACLE shut it down first.
Please explain to me what to do. Should I configure the .profile
file or oratab file or do I have to set the Oracle environment correctly or set Oracle sid?
Please help me to solve the issue.
You need to make sure your ORACLE_HOME, ORACLE_SID, LD_LIBRARY_PATH and PATH environment variables are set correctly. The LD_LIBRARY_PATH env var should contain the $ORACLE_HOME/lib directory. The PATH env var should contain the $ORACLE_HOME/bin directory. Since both your databases are the same version, they are probably using the same $ORACLE_HOME directory, therefore $ORACLE_HOME, $LD_LIBRARY_PATH, and $PATH do not need to change for each of the databases. However, you will need to change your $ORACLE_SID env var. Simply set $ORACLE_SID to ORATEST and when you fire up SQL*Plus and issue "connect / as sysdba." You will now be connecting to that database. Setting the env var depends on your shell.
For C Shell:
setenv ORACLE_SID oratest
For Korn Shell:
set ORACLE_SID oratest
This was first published in October 2005