1. Su Oracle
2. sqlplus/logon
3. Connect test/test as sysdba (test/test is an oracle user and password)
4. startup
5. LSNRCTL Preferred database startup
Su-Oracle
Sqlplus/nolog
Conn/As sysdba
Startup
Then start the listener:
Go to/opt/Oracle/product/9.2.0/bin/
LSNRCTL start Run the shudown command to close the database.
[Oracle @ Wing/Oracle] $ sqlplus "/As sysdba" // log on to the database as a sysdba user
SQL> Shutdown Start Oracle 9i Database
[Oracle @ wing bin] $ sqlplus "/As sysdba"
SQL> startup Start the Oracle 9i listenerProgram
Oracle listeners provide interfaces for client connection.
[Oracle @ wing bin] $ LSNRCTL
LSNRCTL> Start Disable the Oracle 9i listener
[Oracle @ wing bin] $ LSNRCTL
LSNRCTL> stop Check whether the oracle_sid environment variable is set correctly.
9i:
$ Sqlplus/nolog
SQL> connect/As sysdba
SQL> startup
$ LSNRCTL start 8i:
$ Svrmgrl
Svrmgr> connect internal
Svrmgr> startup
$ LSNRCTL start
Where is the error reported ??
Generally, you only need to set these two places ~
/Etc/oratab
Ora2:/Oracle/APP/Oracle/product/8.1.7: Y
/Etc/inittab
Oralce: 2: Wait:/bin/su-Oracle-c '/Oracle/APP/Oracle/product/8.1.7/bin/LSNRCTL start'
ORACLE: 2: Wait:/bin/su-Oracle-c '/Oracle/APP/Oracle/product/8.1.7/bin/dbstart' Start procedure: Su-Oracle [Oracle @ websvr1 Oracle] $ sqlplus/nolog SQL> connect/As sysdba SQL> startup SQL> quit [Oracle @ websvr1 Oracle] $ LSNRCTL start Use [Oracle @ websvr1 Oracle] $ LSNRCTL status to check whether the listener has been started. Close steps: Su-Oracle [Oracle @ websvr1 Oracle] $ LSNRCTL stop [Oracle @ websvr1 Oracle] $ sqlplus/nolog SQL> connect/As sysdba SQL> shutdown immediate SQL> quit
|
