ORACLE startup instance switching command

ORACLE startup switch instance command start other server instances export ORACLE_SID = database instance name sqlplus/nolog conn/as sysdba select name from v $ database ;! Lsnrctl status; view the instance listener startup Oracle operation command # sqlplus/nolog> connect system/system as sysdba> startup open app (Instance name) stop> connect system/system as sysdba> shutdown immediate www.2cto.com start oracle to listen to su-oracle> lsnrctl status view status> lsnrctl start connect to oracle Database # sqlplus user/pasword @/ip: port/instance name example: # sqlplus system/system@11.12.13.50: 1521/app // view instance status> select instance_name, status from v $ instance restart Server Then, let the database instance start automatically: 1. Use oracle user> vi/etc/oratab 2. Modify the last letter N of these statements to Y. App:/opt/oracle/app/oracle/product/11.2.0/app: N 3. Switch to root. Vi/etc/rc. d/after. local
4. Add: su-oracle-c '$ ORACLE_HOME/bin/lsnrctl start 'sleep 2 s su-oracle-C' $ ORACLE_HOME/bin/dbstart' 5. Execute chmod + x/etc /rc. d/after. after local www.2cto.com completes these operations, it will restart the server, and the oracle listener and instance will be able to automatically get up! # Sqlplus/nolog> connect system/system as sysdba> startup open app (Instance name) stop> connect system/system as sysdba> shutdown immediate start oracle listening su-oracle> lsnrctl status view status> lsnrctl start