Oracle 11G DB creation

(1)

Oracle Database 11g Software Installation

&

Database Creation

NAME : SURESH.V

PLATFORM : ORACLE ENTERPRISE LINUX 5.x 64bit VERSION : 11.1.0.6.0

(2)

Oracle 11g Software Installation

Server Configuration

Operating System : Oracle Enterprise Linux 5.5 x86_64

RAM : 8GB

Hard Disk : 1TB

Swap : 10GB

Server Name : of80.orafact.com IP Address : 192.168.1.80 Reference Documents

Books are downloaded from our intranet site http://connect.orafact.com Release Notes for Linux ( B32001.pdf )

Database Quick Installation Guide for Linux x86-64 (B32285.pdf) Software

Softwarw downloaded from http://connect.orafact.com (V14230-01_1of2.zip & V14230-01_2of2.zip) [root@of80 ~]# cd /stage/

[root@of80 stage]# mkdir -p suresh/11.1.0.6 [root@of80 suresh]# ls

11.1.0.6

Enable the host to display X applications Login as root user and issue the below command [root@of80 ~]# xhost +

access control disabled, clients can connect from any host /etc/hosts file

[root@of80 ~]# vi /etc/hosts

127.0.0.1 of80.orafact.com of80 localhost.localdomain localhost 192.168.1.80 of80.orafact.com of80

Hardware requirements Memory Requirements

[root@of80 ~]# grep MemTotal /proc/meminfo MemTotal: 7971364 kB

[root@of80 ~]# grep SwapTotal /proc/meminfo SwapTotal: 10088780 kB

(3)

Filesystem Size Used Avail Use% Mounted on tmpfs 3.9G 0 3.9G 0% /dev/shm

System Architecture [root@of80 ~]# uname -m x86_64

Disk Space Requirements [root@of80 ~]# df -h /tmp/

Filesystem Size Used Avail Use% Mounted on /dev/sda7 5.0G 215M 4.5G 5% /tmp

[root@of80 ~]# df -h /d01/

Filesystem Size Used Avail Use% Mounted on /dev/sda8 767G 19G 710G 3% /d01

Software Requirements

Operating System Requirements [root@of80 ~]# cat /etc/issue

Enterprise Linux Enterprise Linux Server release 5.5 (Carthage) Kernel \r on an \m

[root@of80 ~]# cat /proc/version

Linux version 2.6.18-194.el5 ([email protected]) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-48)) #1 SMP Mon Mar 29 22:10:29 EDT 2010

[root@of80 ~]# uname -a

Linux of80.orafact.com 2.6.18-194.el5 #1 SMP Mon Mar 29 22:10:29 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux Package Requirements [root@of80 ~]# rpm -qa binutils-2.17.50.0.6-2.el5 elfutils-libelf-0.125-3.el5 elfutils-libelf-devel-0.125 glibc-2.5-12 glibc-common-2.5-12 glibc-devel-2.5-12 glibc-headers-2.5-12 gcc-4.1.1-52 gcc-c++-4.1.1-52 libaio-0.3.106 libgcc-4.1.1-52 libstdc++-4.1.1 make-3.81-1.1

(4)

[root@of80 ~]# rpm -Uvh *.rpm compat-libstdc++-33-3.2.3-61.x86_64.rpm libaio-devel-0.3.106-3.2.x86_64.rpm numactl-devel-0.9.8-7.el5.x86_64.rpm sysstat-5.0.6-3.i586.rpm sysstat-7.0.2-3.el5.x86_64.rpm unixODBC-2.2.11-7.1.x86_64.rpm unixODBC-devel-2.2.11-7.1.x86_64.rpm Creating OS Group and User

[root@of80 ~]# groupadd dba

[root@of80 ~]# useradd -g dba suresh [root@of80 ~]# passwd suresh

Changing password for user suresh. New UNIX password:

Retype new UNIX password:

passwd: all authentication tokens updated successfully. [root@of80 ~]# id suresh

uid=501(suresh) gid=501(dba) groups=501(dba) Configuring Kernel Parameters

[root@of80 etc]# vi sysctl.conf fs.file-max = 6815744 kernel.shmmax = 68719476736 kernel.shmall = 4294967296 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 1024 65500 net.core.rmem_default = 4194304 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 [root@of80 etc]# sysctl -p

Setting SHELL Limits for the User [root@of80 ~]# vi /etc/security/limits.conf suresh soft nproc 2047

suresh hard nproc 16384 suresh soft nofile 1024 suresh hard nofile 65536 [root@of80 ~]# vi /etc/pam.d/login session required pam_limits.so

(5)

[root@of80 ~]# vi /etc/profile if [ $USER = "suresh" ]; then

if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi

Creating Required Directories [root@of80 ~]# cd /d01/

[root@of80 d01]# mkdir oracle11g

[root@of80 d01]# chown -R suresh:dba /d01/oracle11g/ [root@of80 d01]# chmod -R 775 /d01/oracle11g/ Configuring the User’s Environment

[root@of80 d01]# su - suresh [suresh@of80 ~]$ echo $SHELL /bin/bash [suresh@of80 ~]$ umask 0022 [suresh@of80 ~]$ vi ofdb.env export ORACLE_BASE=/d01/oracle11g export ORACLE_HOME=/d01/oracle11g/11.1.0.6 export ORACLE_SID=ofdb export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib Installing the Oracle Software

[suresh@of80 ~]$ cd /stage/suresh/11.1.0.6/ database/

[suresh@of80 database]$ ls

doc install README response rpm runcluvfy.sh runInstaller source stage upgrade welcome.html [suresh@of80 database]$ ./runInstaller

(6)

Select the Oracle Database 11g and Click Next

Select the Basic Installtion

Enter ORACLE_BASE & ORACLE_HOME Installation Type - Enterprise Edition

Unix DBA group - dba Click Next

(7)

Enter the Oracle Inventory directory & group and Click Next

(8)

Click Install

(9)

Execute the scripts as root user and Click OK

[root@of80 ~]# /d01/suresh/oraInventory/orainstRoot.sh Changing permissions of /d01/suresh/oraInventory to 770. Changing groupname of /d01/suresh/oraInventory to dba. The execution of the script is complete

[root@of80 bin]# /d01/suresh/oracle/product/11.1.0/db_1/root.sh Running Oracle 11g root.sh script...

The following environment variables are set as: ORACLE_OWNER= suresh

ORACLE_HOME= /d01/suresh/oracle/product/11.1.0/db_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin ...

Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by 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.

(10)

Oracle 11g Database Creation

Setting Environmental variable

[suresh@of80 ~]$ . ofdb.env [suresh@of80 ~]$ dbca

Database Configuration Assistant Welcome screen Click Next

(11)

Select General Purpose or Transaction Processing and Click Next

(12)

Select Configure Enterprise Manager and Click Next

(13)

Network Configuration Assistant

Use netca utility to configure the listener from another terminal [suresh@of80 ~]$ . ofdb.env

[suresh@of80 ~]$ netca

Select Listener Configuration and Click Next

(14)

Type Listener name and Click Next

(15)

Select the Use the standard port number of 1521 and Click Next

(16)

Listener configuration is complete and Click Next followed by finish

By default Listener will be started automatically. Verify by using LSNRCTL Utility [suresh@of80 ~]$ lsnrctl status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=of80.orafact.com) (PORT=1521)))

STATUS of the LISTENER

---Alias LISTENER

Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production Start Date 29-JUN-2010 15:01:17

Uptime 0 days 1 hr. 57 min. 19 sec Trace Level off

Security ON: Local OS Authentication SNMP OFF

Listener Parameter File /d01/suresh/oracle/product/11.1.0/db_1/network/admin/listener.ora Listener Log File /d01/suresh/oracle/diag/tnslsnr/of80/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=of80.orafact.com)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Services Summary...

Service "ofdb.orafact.com" has 1 instance(s).

Instance "ofdb", status READY, has 1 handler(s) for this service... Service "ofdbXDB.orafact.com" has 1 instance(s).

Instance "ofdb", status READY, has 1 handler(s) for this service... Service "ofdb_XPT.orafact.com" has 1 instance(s).

Instance "ofdb", status READY, has 1 handler(s) for this service... The command completed successfully

(17)

Go back to the warning window and click OK. Set Password for all accounts and Click Next

(18)

Select Use Database File Locations from Template and Click Next

(19)

Click Next

(20)

Select the security settings as below and Click Next

(21)

Click Next

(22)

Click OK to Confirm

(23)

After successful completion of Database creation below screen will be displayed. Click Exit

Database creation completed successfully.

Launch browser and connect to URL https://of80.orafact.com:1158/em Enter user name as sys and password, connect as sysdba and Click login

(24)

Home Page of Oracle Enterprise Manager(OEM)