Unix Addiction

As root execute the following Create the pool #zpool create ztemp c0d0 Create ZFS  #zfs create ztemp/temp Mount ZFS  #zfs set mountpoint=/temp ztemp/temp Share ZFS with the option "sharenfs=on" #zfs set sharenfs=on ztemp/temp Share and Select the PATH and SERVERS that you need that mount the ZFS from the NFS Server in our case the servers are oracle1,oracle2 and oracle3 with Read and Write Options #zfs set share=name=temp,path=/temporario,prot=nfs,anon=0,rw=oracle1:oracle2:oracle3 ztemp/temp

The issue is generated due to ZFS bug present in version lower than 11.3.2.4.0, those symptoms produce that some errors related with IO wait are generated in the trace log file of the Oracle Data Base, shutting down the mmon process as you see below Trace log example: Thu Sep 01 08:51:11 2016 WARNING: aiowait timed out 2 times Thu Sep 01 08:57:38 2016 minact-scn: got error during useg scan e:12751 usn:4 minact-scn: useg scan erroring out with error e:12751 Suspending MMON action 'Block Cleanout Optim, Undo Segment Scan' for 82800 seconds Thu Sep 01 09:01:11 2016 WARNING: aiowait timed out 3 times Thu Sep 01 09:07:20 2016 Suspending MMON action 'undo usage' for 82800 seconds Thu Sep 01 09:11:11 2016 WARNING: aiowait timed out 4 times Thu Sep 01 09:12:03 2016 Shutting down instance (immediate) Stopping background process SMCO Thu Sep 01 09:12:34 2016 Background process SMCO not dead after 30 seconds Killing background process SMCO Shutting

HOW TO INSTALL ORACLE BINARIES AND ORACLE DATABASE FOR 11gr2 IN SOLARIS 11.X, AND PREVIOUS PREPARATION FOR THE OS ENVIRONMENT Preparing the Solaris 11.3 OS for database installation 1.-Create Zpool and ZFS Files system Create Zpool #zpool create data c5t025340000233000865d0 Create ZFS Files System #zfs create  data/oracle-bin  (For Install BINARIES) #zfs create  data/u01        (For Install DATABASE) #zfs create  data/arch        (For REDOLOG) #zfs create  data/backup      (and RMAN BACKUP) The number one rule for setting up an Oracle database on ZFS is to set ZFS recordsize equal to the database block size for the file systems that contain the Oracle data files. recordsize = db_block_size 2.-In this case we are installing a OLTP Database, we will set the File System Recordsize to 8k, as zfs recommend #zfs set recordsize=8k data/oracle-bin #zfs set recordsize=8k data/u01 #zfs set recordsize=8k data/arch 3.-Mount ZFS files system in the res

  How to add entries in nsswitch.conf/resolv.conf Solaris 11 1.- Add entries in the ipnode and hosts in the nsswitch.conf to use dns after check files # svccfg -s name-service/switch svc:/system/name-service/switch> setprop config/host = astring:"files dns" svc:/system/name-service/switch> setprop config/ipnode = astring:"files dns" svc:/system/name-service/switch> exit # svcadm refresh name-service/switch # svcadm restart name-service/switch 2.- Add DNS entries 10.0.0.4 and 10.0.0.5 with domain example.com on the server # svccfg -s dns/client svc:/network/dns/client> setprop config/nameserver = net_address:  (10.0.0.4 10.0.0.5) svc:/network/dns/client> setprop config/domain = example.com svc:/network/dns/client> listprop config config                      application config/value_authorization astring     solaris.smf.value.name-service.dns.client config/nameserver          net_address 10.0.0.4 10.0.0.5 config/domain            

1.-Download from Oracle Support MOS the patch 22783063 and unzip and run the command below p22783063_8111638_SOLARIS64.zip #./install_stb.sh -verbose Extracting the STB payload ... Determining the check sums ... Sourcing STB library file ... List of Services Tool Bundle Components:    Oracle Explorer Data Collector 8.11    Oracle Serial Number in EEPROM (SNEEP) 8.11    Service Tag (ST) packages    Oracle Autonomous Crashdump Tool 8.17 (ACT) Would you like to (I)nstall, (X)tract, or (E)xit ? (I by default) X  <-----Select Extract (X) Extracting components for Solaris 11/sparc ...  Extracting IPS repository  Extracting SVR4 packages for Service Tag (ST) packages  - Package 5.11_sparc/SUNWsthwreg.sparc.5.10.pkg extracted Extraction to /var/tmp/stb/extract done Removing STB installation area ...   2.- Now you have in the directory "/var/tmp/stb/extract" de ipsrepo  # cd /var/tmp/stb/extract rwxr-xr-x   3 102      staff          4 Mar  8 11:28 ipsrepo -rw-r--r-- 

HOW TO ENABLE A VIRTUAL INTERFACE (VNIC) SOLARIS 10 1.-Verify the interfaces on the server that you need to add the ip in this example 10.1.1.8 # dladm show-phys LINK CLASS MTU STATE OVER bge0 phys 1500 unknown -- bge1 phys 1500 up --    2.-Now you need to create a virtual network interface or VNIC on the server #ifconfig bge1:1 plumb #ifconfig -a 3.-Finally you can add the new ip address and add on the server in /etc/hostname.bge1:1 the IP or the name that you defined on the hosts file with that ip #vi /etc/hostname.bge1:1 10.1.1.8 #ifconfig bge1:1 10.1.1.8 netmask 255.255.255.0 broadcast 10.1.1.254 up Regards Roger    

HOW TO INSTALL RSYNC 3.1.1 SOLARIS 10 1.-Download the following packages   libintl-3.4.0-sol10-sparc-local.gz rsync.3.1.1.SPARC.32bit.Solaris.10.pkg libiconv.1.14.SPARC.32bit.Solaris.10.pkg   2.-Once you have the packages on the server you can do the following steps   libintl-3.4.0-sol10-sparc-local.gz rsync.3.1.1.SPARC.32bit.Solaris.10.pkg libiconv.1.14.SPARC.32bit.Solaris.10.pkg    3.-  Unzip the packages that are compressed and install them with pkgadd. #gunzip libintl-3.4.0-sol10-sparc-local.gz #pkgadd –d libintl-3.4.0-sol10-sparc-local   #pkgadd –d  rsync.3.1.1.SPARC.32bit.Solaris.10.pkg #pkgadd –d libiconv.1.14.SPARC.32bit.Solaris.10.pkg And now you can use the rsync Regards Roger