pat98's always & forever

11.2 버전은 기본으로 disable 되어 있다.

How To Verify If DNFS Is Enabled (“ON”) Or Disabled (“OFF”) Before The Database Instance Is Started In 11.2 Release? (Doc ID 1551909.1)

SQL> shutdown immediate

oracle kernel level 에서 DNFS 옵션 enable

oracle 계정에서

1. id 

2. cd $ORACLE_HOME/rdbms/lib

3. 
make -f ins_rdbms.mk dnfs_on

아래와 같은 메세지만 썰렁하게 보인다.
rm -f /oracle/product/11.2.0.4/lib/libodm11.so; cp /oracle/product/11.2.0.4/lib/libnfsodm11.so /oracle/product/11.2.0.4/lib/libodm11.so

make -f ins_rdbms.mk dnfs_off
      
마찬가지로 아래와 같은 메세지만 썰렁하게 보인다.   
rm -f /oracle/product/11.2.0.4/lib/libodm11.so; cp /oracle/product/11.2.0.4/rdbms/lib/libodm11.so.dummy /oracle/product/11.2.0.4/lib/libodm11.so

4. 
이렇게만 나오기 때문에 적용되었는지 확인할 방법은 아래와 같다.

방법 1) 적용이 안되어 있으면 아래와 같이 ODM ERR: Calling stubbed version 메세지가 보인다.

[oracle:/oracle/product/11.2.0.4/rdbms/lib]#strings /oracle/product/11.2.0.4/lib/libodm11.so | grep -i odm
odm_deregisternic
odm_registernic
odm_destroy
odm_deregistermem
odm_registermem
odm_mname
odm_resize
odm_cancel
odm_ioerror
odm_io
odm_cleanup
odm_unidentify
odm_reidentify
odm_identify
odm_delete
odm_abort
odm_commit
odm_create
odm_error
odm_fini
odm_init
odm_discover
ODM ERR: Calling stubbed version
Stubbed ODM Library, Version: 1.0

적용이 되어 있으면 아래와 같이 ODM ERR: Calling stubbed version 메세지가 없다.
[oracle:/oracle/product/11.2.0.4/rdbms/lib]#strings /oracle/product/11.2.0.4/lib/libodm11.so | grep -i odm
kgodm_deregisternic
kgodm_registernic
kgodm_destroy
kgodm_deregistermem
kgodm_registermem
kgodm_mname
kgodm_resize
kgodm_cancel
kgodm_ioerror
kgodm_io
kgodm_cleanup
kgodm_unidentify
kgodm_reidentify
kgodm_identify
kgodm_readlink
kgodm_readdir
kgodm_fsinfo
kgodm_fsstat
kgodm_setattr
kgodm_getattr
kgodm_rmdir
kgodm_mkdir
kgodm_delete
kgodm_abort
kgodm_commit
kgodm_create
kgodm_error
kgodm_fini
kgodm_init
kgodmfhtr_
odm_registerthread
kgodm_discover
nfs odm heap
kgodm event %u set to level %u

방법 2)

5. SQL> startup

6. alertlog 메세지 확인

적용이 되면 파라미터 화일을 읽고 바로 그 아래에 ODM Running 되었다는 메세지를 확인 할수 있다.

  audit_file_dest          = "/oracle/admin/TEST/adump"
  audit_trail              = "DB"
  db_name                  = "TEST"
  open_cursors             = 300
  diagnostic_dest          = "/oracle"
Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 3.0 
Tue May 07 22:08:18 2024
PMON started with pid=2, OS id=1964 
Tue May 07 22:08:18 2024
PSP0 started with pid=3, OS id=1966 


Direct NFS: channel id [0] path [celntap3-bc] to filer [celntap3-bc] via local [] is UP
Direct NFS: channel id [1] path [celntap3-bc] to filer [celntap3-bc] via local [] is UP

7. DNFS 설정값 확인 view (RAC 인 경우 gv$DNFS_* )

1) select * from V$DNFS_SERVERS; Shows a table of servers accessed using Direct NFS.

2) select * from V$DNFS_FILES; Shows a table of files currently open using Direct NFS.

3) select * from V$DNFS_CHANNELS; Shows a table of open network paths (or channels) to servers for which Direct NFS is providing files.

4) select * from V$DNFS_STATS; Shows a table of performance statistics for Direct NFS.