SQL> SHUTDOWN IMMEDIATE; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup; ORACLE instance started.
Total System Global Area 1.6034E+10 bytes Fixed Size 2244192 bytes Variable Size 1.0133E+10 bytes Database Buffers 5838471168 bytes Redo Buffers 60059648 bytes Database mounted. Database opened. SQL> startup ORA-01081: cannot start already-running ORACLE - shut it down first SQL> select userenv('language') from dual;
USERENV('LANGUAGE') ---------------------------------------------------- AMERICAN_AMERICA.AL32UTF8
SQL>
rac node 2的操作,其中关机是一开始操作的,启动是最后操作的。
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1.6034E+10 bytes
Fixed Size 2244192 bytes
Variable Size 1.0167E+10 bytes
Database Buffers 5804916736 bytes
Redo Buffers 60059648 bytes
Database mounted.
Database opened.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1.6034E+10 bytes
Fixed Size 2244192 bytes
Variable Size 1.0167E+10 bytes
Database Buffers 5804916736 bytes
Redo Buffers 60059648 bytes
Database mounted.
Database opened.
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.AL32UTF8
SQL>