<11/18> Luv

compatible version을 alter system set compatible로 11.2..0.4로 바꾼 후 downgrade를 시도하면 error가 발생한다.

PL/SQL procedure successfully completed.

 

 

Function created.

 

SELECT version_script AS file_name FROM DUAL

       *

ERROR at line 1:

ORA-39707: compatibile parameter 11.2.0.4.0 too high for downgrade to

10.2.0.5.0

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.VERSION_SCRIPT", line 31

 

SQL> alter system set compatible = '10.2.0.1.0' scope=spfile;

 

System altered.

 

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

 

Total System Global Area 1219260416 bytes

Fixed Size                  2252744 bytes

Variable Size             385876024 bytes

Database Buffers          822083584 bytes

Redo Buffers                9048064 bytes

ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version

10.2.0.1.0

ORA-00202: control file: '/u01/app/oracle/oradata/orcl/control01.ctl'

 

 

SQL> create pfile from spfile;

create pfile from spfile

*

ERROR at line 1:

ORA-32012: SPFILE format is inconsistent with value of COMPATIBLE parameter

 

서버 프로세스의 3가지 상태

Idle : 작업이 발생할 때까지 대기(휴식중)

코드 실행 중 : CPU를 사용하거나 실행 큐에 있음

대기 중 ( 차단 됨 )

 - 리소스를 사용할 수 있을 때까지 대기

 - 요청한 작업이 완료될 때까지 대기

 

orcl@SYS> select rownum, class from v$waitstat;

    ROWNUM CLASS

---------- ------------------

         1 data block

         2 sort block

         3 save undo block

         4 segment header

         5 save undo header

         6 free list

         7 extent map

         8 1st level bmb

         9 2nd level bmb

        10 3rd level bmb

        11 bitmap block

        12 bitmap index block

        13 file header block

        14 unused

        15 system undo header

        16 system undo block

        17 undo header

        18 undo block