Direct NFS client:
mount point entry wordt gelezen uit
1. $ORACLE_HOME/dbs/oranfstab
2. /etc/oranfstab
3. /etc/mtab (wordt gevuld door fstab)
Enable
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dnfs_on
Disable
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk dnfs_off
views
v$dnfs_servers
v$dnfs_files
v$dnfs_channels
v$dnfs_stats
SQL> SELECT svrname, dirname FROM v$dnfs_servers;
SVRNAME DIRNAME
------------- -----------------
nas1 /shared_data
SQL>
===========================================
[l6nfs1]oracle@L6LODB002=x86_64:~
sp
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jan 10 16:29:34 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from v$dnfs_servers;
no rows selected
SQL> select * from v$dnfs_stats;
no rows selected
SQL> select * from v$dnfs_channels;
no rows selected
SQL> select * from v$dnfs_files;
no rows selected
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/data/ora01/L6NFS/datafile/o1_mf_system_9f03v98w_.dbf
/data/ora01/L6NFS/datafile/o1_mf_sysaux_9f03vr45_.dbf
/data/ora01/L6NFS/datafile/o1_mf_undotbs1_9f03w38g_.dbf
/data/ora01/L6NFS/datafile/o1_mf_users_9f03wgsp_.dbf
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
cd $ORACLE_HOME/rdbms/lib
[l6nfs1]oracle@L6LODB002=x86_64:/data/app/oracle/product/11.2.0.4/db_1/rdbms/lib
make -f ins_rdbms.mk dnfs_on
rm -f /data/app/oracle/product/11.2.0.4/db_1/lib/libodm11.so; cp /data/app/oracle/product/11.2.0.4/db_1/lib/libnfsodm11.so /data/app/oracle/product/11.2.0.4/db_1/lib/libodm11 .so
[l6nfs1]oracle@L6LODB002=x86_64:/data/app/oracle/product/11.2.0.4/db_1/rdbms/lib
sp
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jan 10 16:32:32 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2235208 bytes
Variable Size 281019576 bytes
Database Buffers 780140544 bytes
Redo Buffers 5541888 bytes
-- blijf hangen en geeft melding
Direct NFS: please check that oradism is setuid
rechten oradism moet waorden aangepast met
cd /data/app/oracle/product/11.2.0.4/db_1/bin
L6LODB002:/data/app/oracle/product/11.2.0.4/db_1/bin # ls -ltr oradism
-rwxr-x--- 1 root oinstall 71758 Sep 17 2011 oradism
L6LODB002:/data/app/oracle/product/11.2.0.4/db_1/bin # chmod 4755 oradism
L6LODB002:/data/app/oracle/product/11.2.0.4/db_1/bin # ls -ltr oradism
-rwxr-xr-x 1 root oinstall 71758 Sep 17 2011 oradism
Helaas kan s niet zetten in permissies, iets mis met mount options van /data/app
de mount opties zijn aagepast door infra "optie nosuid uitgezet voor het betreffende volume."
Nu de permissies voor de oracle binaries goedzetten:
-rwsr-x--- 1 root oinstall 71758 Sep 17 2011 oradism
-rws--x--- 1 root oinstall 47157 May 17 2013 nmo
-rws--x--- 1 root oinstall 73044 May 17 2013 nmhs
-rwsr-s--x 1 oracle oinstall 72583 May 17 2013 emtgtctl2
-rwsr-x--- 1 root oinstall 46122 May 17 2013 jssu
-rwsr-x--- 1 root oinstall 1255205 May 17 2013 extjob
-rws--x--- 1 root oinstall 41014 May 17 2013 nmb
-rwsr-s--x 1 oracle oinstall 233052883 May 17 2013 oracle
chmod 4755 oradism
chmod 4710 nmo
chmod 4710 nmhs
chmod g+s emtgtctl2
chmod +s emtgtctl2
chmod 4710 jssu
chmod 4710 extjob
chmod 4710 nmb
chmod g+s oracle
chmod +s oracle
ls -ltr|grep rws
Nu kunnen we de database weer starten
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2235208 bytes
Variable Size 281019576 bytes
Database Buffers 780140544 bytes
Redo Buffers 5541888 bytes
Database mounted.
Database opened.
Nu controleren of DNFS geactiveerd is
SQL> l
1* select * from v$dnfs_servers
SQL> /
ID SVRNAME DIRNAME MNTPORT NFSPORT WTMAX RTMAX
---------- -------------------- -------------------------------------------------- ---------- ---------- ---------- ----------
1 10.10.10.11 /vol/nfsfast001_nfs_2 4046 2049 65536 65536
2 10.10.10.11 /vol/nfsfast001_nfs_3 4046 2049 65536 65536
3 10.10.10.11 /vol/nfsfast001_nfs_1 4046 2049 65536 65536
SQL> select * from v$dnfs_files;
FILENAME FILESIZE PNUM SVR_ID
------------------------------------------------------------ ---------- ---------- ----------
/data/ora01/L6NFS/controlfile/o1_mf_9f03v30q_.ctl 9748480 12 1
/data/ora02/L6NFS/controlfile/o1_mf_9f03v375_.ctl 9748480 12 1
/data/ora01/L6NFS/datafile/o1_mf_system_9f03v98w_.dbf 734011392 10 1
/data/ora01/L6NFS/datafile/o1_mf_sysaux_9f03vr45_.dbf 629153792 10 1
13 rows selected.
SQL> select * from v$dnfs_channels;
PNUM SVRNAME PATH LOCAL CH_ID SVR_ID SENDS RECVS PINGS
---------- -------------------- -------------------- ----- ---------- ---------- ---------- ---------- ----------
7 10.10.10.11 10.10.10.11 0 1 0 0 0
Comments
Post a Comment