Skip to main content

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

By
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 respective mount point

#zfs set mountpoint=/oraclebin data/oracle-bin
#zfs set mountpoint=/u01 data/u01
#zfs set mountpoint=/arch data/arch
#zfs set mountpoint=/backup data/backup

Now we have mounted the files system

4.-Create user and group for the database

#groupadd -g 1000 dba
#useradd -u 100 -g 1000 -m -d /oraclebin/oracle -s /bin/bash oracle
80 blocks

5.-Generate a project for the user oracle that will be used to manage the database

I have a previous template I will edit the /etc/project file and copy and paste the info below

#vi /etc/project
system:0::::
user.root:1::::
noproject:2::::
default:3::::
group.staff:10::::
group.oracle:200:Oracle Default:oracle::process.max-sem-nsems=(privileged,256,deny);project.max-sem-ids=(priv,100,deny);project.max-shm-ids=(privileged,256,deny);project.max-shm-memory=(privileged,1073741824,deny)

6.-Validate the project created

#projects -l

group.oracle
        projid : 200
        comment: "Oracle Default"
        users  : oracle
        groups : (none)
        attribs: process.max-sem-nsems=(privileged,256,deny)
                 project.max-sem-ids=(priv,100,deny)
                 project.max-shm-ids=(privileged,256,deny)
                 project.max-shm-memory=(privileged,1073741824,deny)
    
The project.max-shm-memory is the maximum quantity of memory that project can be use   
 
7.-When you created the user in the step 4, the user oracle was created belonging to Default Project, now you need to change this and assign the user to group.oracle Project

$id -p
uid=100(oracle) gid=1000(dba) projid=3(Default)

Add the user to the "group.oracle" project as root you need to use the usermod command as below

# usermod -K project=group.oracle oracle

Login to oracle and with the id command you can check that you belong to the "group.oracle"

# su - oracle
Oracle Corporation      SunOS 5.11      11.3    October 2015oracle@~$ id -p
uid=100(oracle) gid=1000(dba) projid=200(group.oracle)

8.-Set the correct permission for the files system created "oracle user" and "dba group"

#df -h | egrep "oraclebin|u01|arch|backup"

data/oracle-bin
                       488G    32K       394G     1%    /oraclebin
data/u01       488G    31K       394G     1%    /u01
data/arch      488G    31K       394G     1%    /arch
data/backup    488G    31K       394G     1%    /backup
data/oracle-bin/oracle
                       488G    35K       394G     1%    /oraclebin/Oracle

# chown oracle:dba /oraclebin /u01 /arch /backup /oraclebin/Oracle


9.- Verify that you have installed the following packages, if you do not have them installed perform as root user the following command (You will need to have access to internet)

#pkg install top xterm xclock motif xauth x11-info-clients library/motif libxp make developer/assembler

Aditionally install the compatibility with ucb command (Berkley Software Distribution)

#pkg install compatibility/ucb

 

ORACLE BINARIES INSTALLATION 

Oracle Database 11g Release 2 (11.2.0.1.0) for Solaris Operating System (SPARC) (64-bit)


10.-Upload to the server the installation packages and uncompress them (we uploaded them to /oraclebin)

solaris.sparc64_11gR2_database_1of2.zip
solaris.sparc64_11gR2_database_2of2.zip

#unzip solaris.sparc64_11gR2_database_1of2.zip
#unzip solaris.sparc64_11gR2_database_2of2.zip

11.-We will use the MOBATERM for installation process that help with Export Display
You can download it from the following page:
http://mobaxterm.mobatek.net/download.HTML

or you can export the display as below

#export DISPLAY=<REMOTEIPADDRESS>:10.0

12.-Go to oraclebin/database directory and execute "runInstaller" as Oracle
:/oraclebin/database$ ls -ltr
total 46
-rw-rw-rw-   1 oracle   dba         5399 Nov  4  2009 welcome.html
-rwxr-xr-x   1 oracle   dba         6513 Nov  6  2009 runInstaller
drwxr-xr-x  14 oracle   dba           30 Nov  6  2009 stage
drwxr-xr-x   2 oracle   dba            3 Nov  6  2009 sshsetup
drwxr-xr-x   2 oracle   dba            2 Nov  6  2009 rpm
drwxr-xr-x   2 oracle   dba            5 Nov  6  2009 response
drwxr-xr-x   4 oracle   dba           14 Nov  6  2009 install
drwxrwxrwx  11 oracle   dba           13 Nov  6  2009 doc

/oraclebin/database$ ./runInstaller
Starting Oracle Universal Installer...
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 180 MB.   Actual 37716 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 39903 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-06-03_10-12-08AM. Please wait ...







uncheck the checkbox "I wish to receive security updates via My Oracle Support".


Click Next

Ignore this messages and click "YES"


We will only install the Oracle binary, select the second option "Install database Software Only" then click NEXT

We will install the binaries for single instance then click NEXT

Click Next

Choose the Enterprise Edition Option and them click on NEXT



We did choose the Oracle Base and the Oracle Home as showed above and click Next


We Selected as Database Administrator and Operator the DBA Group, then click NEXT



Finally you can see the summary of the  binaries installation, you can save a Response File if you want in order to have all the configuration for the binaries installation process. Click FINISH


At this point the installation is in progress ....


Ask to the SysAdmin run the following command as root user


#  /oraclebin/oracle/product/11.2.0/dbhome_1/root.shRunning Oracle 11g root.sh script...
The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /oraclebin/oracle/product/11.2.0/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.


 At this point we have finished the Oracle Binaries Installation


On other hand is recomendable to have the last SRU for the Solaris OS, in order to have updated the OS.

You can check the post Updating Solaris 11.X to 11.3 and SRU to 11.3.2.4.0

http://unixaddiction.blogspot.com/2016/05/updating-solaris-11x-to-113-and-sru-to.HTML





ORACLE DATABASE  INSTALLATION 


#cd $ORACLE_HOME
#./dbca


Click Next


Select Create DataBase and Click Next 

Select the fist options (For transaction Database)

Set Global DataBase and SID


Uncheck Enterprise Manager


In our case we specify the same password for system and sys, because we are doing a testing, however you can set a different password for user


Set the DataBase Files Location in our case we will set /u01/data/oratest as the instance name 


 Specify the Flash Recovery Area and If you will have the DataBase in Archive Mode

You can specify if you need to add the Sample Schemas or Not

Set the SGA and PGA Values in our case we will set 4G 

Define the Control File Directory  

Define Data Files Directories  

 Define Redolog and Size for them

Create the DataBase and click Finish



We have done the OS configuration, Binaries and Database Installation.
 
 
LISTENER CONFIGURATION ORACLE 11G
 
 
Finally you will need to configure in the .profile in our case the environment variables.
 
Edit the .profile and add the lines with the correct information ( ORACLE HOME, ORACLE BASE, SID and PATH )
 
export ORACLE_HOME=/oraclebin/oracle/product/11.2.0/dbhome_1
export ORACLE_BASE=/oraclebin/oracle
export ORACLE_SID=ORATEST
export PATH=$ORACLE_HOME/bin:$PATH
 
Now Installing Listener, we will use the port 1530
 
As Oracle User
 
$cd $ORACLE_HOME/bin
$./netcat
 



 



 
 
$lsnrctl start LISTENER
 
$netstat -an | grep 1530  | grep LISTEN
      *.1530               *.*                  0      0  128000      0 LISTEN

Regards
Roger




Labels:

Comments

kadhir said…
Please post for rac installation also for 11g and 12c.
June 8, 2016 at 8:37 PM
Agu Mayqueltoren said…
Muy bueno che! Gracias!
June 29, 2016 at 6:02 PM
Unknown said…
Excelent post, thanks Roger, regards.
September 12, 2016 at 5:18 PM
Post a Comment

Last Week Topics

How to Force The Database Open With `_ALLOW_RESETLOGS_CORRUPTION

By
This is an internal note from Oracle. Forcing The Database Open With `_ALLOW_RESETLOGS_CORRUPTION` with Automatic Undo Management ( Doc ID 283945.1 ) Warning The following instructions should only be used under the explicit direction of Oracle Support. These steps should only be used when all other conventional means of recovering the database have failed. Please note that there is no guarantee that this method will succeed. IF THE STEPS BELOW DO ALLOW YOU TO OPEN YOUR DATABASE THEN IT IS ESSENTIAL THAT THE DATABASE BE REBUILT AS IT IS NO LONGER SUPPORTED. FAILURE TO DO SO MAY LEAD TO DATA DICTIONARY INCONSISTENCIES, INTERNAL ERRORS AND CORRUPTIONS. ** Note: The steps here apply to Oracle 9i or higher and only and when Automatic Undo Management is being used. ** Steps to attempt to force the database open: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 1) Backup the database while the database is closed. THE INSTRUCTIONS HERE ARE DESTRUCTIVE. YOU ARE STRONGLY A
Post a Comment
More Information »

HOW TO ENABLE A VIRTUAL INTERFACE (VNIC) SOLARIS 10

By
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    
Post a Comment
More Information »

How to reorganize tables with brspace commands.

By
Brspace use internally Oracle DBMS_REDEFINITION. If you have SAP with Oracle, this is a very fast way to reorganize object in Oracle Database. In this example we will organize simultaneously S562,MLPPF and MLCRP tables. Important : If you want to reorganize various tables and indexes, these must reside in same tablespace. 1- Tables reorganization. brspace -p /oracle/PRD/102_64/dbs/initPRD.sap -c force -s 20 -l E -f tbreorg -a reorg -s PSAPSR3 -o SAPSR3 -t "S562,MLPPF,MLCRP" -n PSAPSR3 -e 16 -p 16 -m online *  /oracle/PRD/102_64/dbs/initPRD.sap : SAP Parameter file * PSAPSR3 : Source tablespace * SAPSR3  : Table owner * PSAPSR3 :  Destiny tablespace. * -e 16 -p 16 -m :  It indicates how many parallel processes that will perform the operation,in this case are 16. * online : It indicates that the reorganization of the tables will be made ONLINE 2- After tables reorganization you will need to rebuild the S562,MLPPF and MLCRP indexes tables . brspac
Post a Comment
More Information »

How to break a bonded network interface red hat

By
1.- Bonding device called bond0 which aggregated by eth0 and eth1 # ifconfig bond0     Link encap:Ethernet  HWaddr 44:a8:42:5d:6d:5d           inet addr:192.168.1.51  Bcast:192.168.1.255  Mask:255.255.255.0           inet6 addr: fe80::5054:ff:fe4d:9004/64 Scope:Link           UP BROADCAST RUNNING MASTER MULTICAST  MTU:1500  Metric:1 eth0      Link encap:Ethernet  HWaddr 44:a8:42:5d:6d:5d           UP BROADCAST RUNNING SLAVE MULTICAST  MTU:1500  Metric:1 eth2      Link encap:Ethernet  HWaddr 44:a8:42:5d:76:29           UP BROADCAST RUNNING SLAVE MULTICAST  MTU:1500  Metric:1           RX packets:6 errors:0 dropped:0 overruns:0 frame:0 # cat /proc/net/bonding/bond0 Ethernet Channel Bonding Driver: v3.6.0 (September 26, 2009) Bonding Mode: fault-tolerance (active-backup) Primary Slave: em1 (primary_reselect always) Currently Active Slave: em1 MII Status: up MII Polling Interval (ms): 50 Up Delay (ms): 0 Down Delay (ms): 0 Slave Interface: eth0 MII Status: up Speed: 10000
Post a Comment
More Information »

HOW TO SHARE SAMBA SHARE FROM WINDOWS TO SOLARIS 11

By
SHARE WINDOWS FOLDER WITH SAMBA IN SOLARIS 11 OPEN THOSE PORT IF YOU HAVE A FIREWALL BETWEEN SERVERS PORT    STATE SERVICE 135/tcp open  msrpc 139/tcp open  netbios-ssn 445/tcp open  microsoft-ds 137 UDP 138 UDP INSTALL SAMBA PACKAGES #pkg install samba ENABLE EACH SERVICES AFTER INSTALLING SAMBA AND CONFIGURE THE SMB.CONF #svcadm enable idmap #svcadm enable smb/client #svcadm enable samba root@:/# vi /etc/samba/smb.conf [ftps]   path = //april.domaintest/FTPS   realm = april.domaintest.com   netbios name = april   passdb backend = YourSharingPassword   guest account = SAMBAUX   log file = /var/samba/log/%m.log   load printers = No   wins server = YourWinServer    winbind trusted domains only = No   workgroup = domaintest.com   hosts allow = 192.168.1.10    TEST THE CONNECTION WITH WINDOWS SAMBA SERVER SHARE     root@:/#  smbclient -L //april/FTPS/ -s /etc/samba/smb.conf -N Anonymous login successful         Sharename       Ty
Post a Comment
More Information »

OSWatcher analysis Solaris/Oracle Linux for DataBases

By
ORACLE DATABASE 10 or greater ORACLE SOLARIS SPARC 1.  As "root" use create  OSWatcher startup/stop script (startOSWbb.sh) # uname -a SunOS solaristest  5.10 Generic_150-400 # pwd /etc/init.d # cat OSW_init.sh  OSW_SRC_DIR= <<<<----- Modify this to reflect your OS Watcher source directory echo $OSW_SRC_DIR echo "******************************************************" >> $OSW_SRC_DIR/init_osw.log case $1 in 'start') echo "...Starting OSWBB from init at `date` " >> $OSWBB_SRC_DIR/init_osw.log cd $OSWBB_SRC_DIR; ./startOSWbb.sh ;; 'stop') echo "...Stopping OSWBB from init at `date` " >> $OSWBB_SRC_DIR/init_osw.log cd $OSW_SRC_DIR; ./stopOSWbb.sh ;; *) echo "Usage: $0 start|stop" >&2 exit 1 ;; esac exit 0   2.  Add "execute" permissions on this script: #chmod +x OSW_init.sh 3.  Create a soft link to this script fr
Post a Comment
More Information »

How to install Oracle Directory Server 11 Solaris 10

By
Createl DSCC Registry that is   Directory Server Manager for LDAP server administration root@ldapserv1:/opt/ODSEE_ZIP_Distribution/dsee7/bin# ./dsccsetup ads-create Choose password for Directory Service Manager: Confirm password for Directory Service Manager: Creating DSCC registry... DSCC Registry has been created successfully Deploy the directory server root@ldapserv1:/opt/ODSEE_ZIP_Distribution/dsee7/bin# ./dsccsetup war-file-create Created /opt/ODSEE_ZIP_Distribution/dsee7/var/dscc7.war 1636 /opt/dsInst Choose the Directory Manager password: <Password Directory Manager> Confirm the Directory Manager password: <Password Directory Manager> Starting the instance created with dsadm Use command 'dsadm start '/opt/dsInst'' to start the instance oot@ldapserv1:/opt/ODSEE_ZIP_Distribution/dsee7/bin# ./dsadm start '/opt/dsInst' Directory Server instance '/opt/dsInst' started: pid=19325 Create the suffix   and port that will be used,
Post a Comment
More Information »

HOW TO CHANGE HOSTNAME RED HAT LINUX

By
HOW TO CHANGE HOSTNAME RED HAT LINUX 1.-Validate Hostname and host file that you need to change #hostname rhel #cat /etc/hosts 127.0.0.1  localhost 192.168.1.13  rhel 2.-Edit the following file in order to change HOSTNAME #vi /etc/sysconfig/network NETWORKING=yes HOSTNAME=TEST GATEWAY=192.168.1.1 3.-When you are ready and you save the information you will need to edit the hosts file #vi /etc/hosts 127.0.0.1  localhost 192.168.1.13  test 4.- Finally you will need to restart de network services #service network restart #hostname test
1 comment
More Information »

FAN Fully Automated Nagios monitoring tool

By
If you need install an application to monitor, with a simple installation and no many configuration or compilation, you can use FAN versión 2.1 We have a tool that is integrated with Nagios, Centreon, Nagvis and DocuWiki OS Centos 5.9 Centreon 2.4.1 Nagvis 1.7 Nagios and DocuWiki You can download the ISO and Documentation from the following link, it is a very easy software to install in order to monitor the servers. http://www.fullyautomatednagios.org/
1 comment
More Information »