New answers tagged oracle-11g
No, you have to upgrade in stages, which wouldn't actually be possible now because Oracle 8.x and 9.x are now unsupported and the software is unavailable (unless you have an Oracle support contract and ask them for copies of the software). Read the Oracle® Database Upgrade Guide 11g Release 2 (11.2) for more information. Your best bet, assuming you have ...
The error you encounter can have many causes. One is an incorrect environment. For Oracle, the variable ORACLE_HOME is very important. Start with setting that to where you installed your Oracle software. Next make sure that PATH points to %ORACLE_HOME%\bin After that, set the variable ORACLE_SID to the sid of your database instance. (The sid is part of the ...
For your database to open and mount, first ensure that you are logged in as the user oracle Then start by checking whether your listener has been started, using the command lsnrctl status Also, please provide the details of the environment in which you are running Oracle, i.e as an active/standby in dataguard, or standalone, and also what version of Oracle ...
set ORACLE_SID=database set TWO_TASK= sqlplus /nolog CONNECT /@database as sysdba startup
Top 50 recent answers are included