Skip to main content

Posts

Showing posts from June, 2016

HOW TO INSTALL ORACLE BINARIES AND ORACLE DATABASE 11gr2 IN SOLARIS 11.3 WITH ZFS

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