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
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.