ROAD-2-ORACLE : Oracle 11.2.0.3 g on IBM-AIX-7.1

1. Login the root user

If you are not logged in as the root user, then enter the following command to switch user to root:

$ su - root

password:

2. To determine the physical RAM size, enter the following command:

gpfs.base 3.3.0.11 or later

bash-3.2# /usr/sbin/lsattr -E -l sys0 -a realmem

The following table describes the relationship between installed RAM and the configured swap space requirement:

Available RAM Swap Space Required

Between 1 GB and 2 GB 1.5 times the size of the RAM

Between 2 GB and 16 GB Equal to the size of the RAM

More than 16 GB 16 GB

3. To determine the size of the configured swap space, enter the following command:

gpfs.base 3.3.0.11 or later

bash-3.2# /usr/sbin/lsps –a

** Change the Swap Size

4. To determine whether the system architecture can run the software, enter the following command:

gpfs.base 3.3.0.11 or later

bash-3.2# /usr/bin/getconf HARDWARE_BITMODE

Note:

This command displays the processor type. Verify that the processor architecture matches the Oracle software release that you want to install. If you do not see the expected output, then you cannot install the software on this system.

The expected output of this command is 64. If you do not see the expected output, then you cannot install the software on this system.

5. To determine if the system is started in 64-bit mode, enter the following command:

gpfs.base 3.3.0.11 or later

bash-3.2# bootinfo -K

6. At least 1 GB of space in the /tmp directory

To determine the amount of disk space available in the /tmp directory, enter the following command:

gpfs.base 3.3.0.11 or later

bash-3.2# df -k /tmp

7. To determine the amount of free disk space on the system, enter the following command:

gpfs.base 3.3.0.11 or later

bash-3.2# df -k

The following table describes the disk space requirements for software files for each installation type:

Installation Type Requirement for Software Files (GB)

Enterprise Edition 7.8

Standard Edition 7.5

8. Operating System Requirements

The following, or later versions, of the operating systems are required for Oracle Database 11g Release 2 (11.2):

To determine the distribution and version of AIX installed, enter the following command:

gpfs.base 3.3.0.11 or later

bash-3.2# oslevel –s

• AIX 5L V5.3 TL 09 SP1 ("5300-09-01"), 64 bit kernel

• AIX 6.1 TL 02 SP 1 ("6100-02-01), 64-bit kernel

• AIX 7.1 TL 0 SP 1 ("7100-00-01"), 64-bit kernel

9. The following operating system filesets are required for AIX 7.1:

bos.adt.base

bos.adt.lib

bos.adt.libm

bos.perf.libperfstat

bos.perf.perfstat

bos.perf.proctools

xlC.rte.11.1.0.2 or later

gpfs.base 3.3.0.11 or later

To determine if the required filesets are installed and committed, enter a command similar to the following:

bash-3.2# lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat \

bos.perf.libperfstat bos.perf.proctools

Fileset Level State Description

----------------------------------------------------------------------------

Path: /usr/lib/objrepos

bos.adt.base 7.1.2.15 COMMITTED Base Application Development

Toolkit

bos.adt.lib 7.1.2.15 COMMITTED Base Application Development

Libraries

bos.adt.libm 7.1.2.0 COMMITTED Base Application Development

Math Library

bos.perf.libperfstat 7.1.2.15 COMMITTED Performance Statistics Library

Interface

bos.perf.perfstat 7.1.2.15 COMMITTED Performance Statistics

Interface

bos.perf.proctools 7.1.2.15 COMMITTED Proc Filesystem Tools

Path: /etc/objrepos

bos.adt.base 7.1.2.15 COMMITTED Base Application Development

Toolkit

bos.perf.libperfstat 7.1.2.15 COMMITTED Performance Statistics Library

Interface

bos.perf.perfstat 7.1.2.15 COMMITTED Performance S

10. To determine the supported kernel mode, enter a command similar to the following:

bash-3.2# getconf KERNEL_BITMODE

11. To determine whether an APAR is installed, enter a command similar to the following:

bash-3.2# /usr/sbin/instfix -i -k "IV11460 IV11991 IV11988 IV11455 IV23735"

All filesets for IV11460 were found.

All filesets for IV11991 were found.

All filesets for IV11988 were found.

All filesets for IV11455 were found.

All filesets for IV23735 were found.

12. Before jump to create Oracle User & her group just check the Partitions

bash-3.2# df -i Ig

Filesystem GB blocks Used Free %Used Mounted on

/dev/hd4 2.00 0.21 1.79 11% /

/dev/hd2 5.00 2.41 2.59 49% /usr

/dev/hd9var 2.00 0.38 1.62 20% /var

/dev/hd3 40.00 0.13 39.87 1% /tmp

/dev/fwdump 1.50 0.00 1.50 1% /var/adm/ras/platform

/dev/hd1 85.00 0.01 84.99 1% /home

/dev/hd11admin 0.50 0.00 0.50 1% /admin

/proc - - - - /proc

/dev/hd10opt 0.50 0.27 0.23 54% /opt

/dev/livedump 0.50 0.00 0.50 1% /var/adm/ras/livedump

/dev/u01lv 100.00 0.02 99.98 1% /u01

/dev/var1lv 50.00 0.01 49.99 1% /var1

/dev/dev1lv 95.00 0.01 94.99 1% /dev1

13. Creating Required Operating System Groups and Users

bash-3.2# mkgroup - 'A' id='401' oinstall

bash-3.2# grep oinstall /etc/groupdba

bash-3.2# mkgroup -''A'' id=''4'0'2'' dba

bash-3.2# mkgroup -'A' id='402' dba

bash-3.2# grep dba /etc/group

bash-3.2# mkgroup -'A' id='402' dba

bash-3.2# grep dba /etc/group

dba:!:402:

bash-3.2# id oracle

3004-820 User not found in /etc/passwd file

bash-3.2# useradd -d /home/oracle -m -u 401 -g oinstall -G dba oracle

bash-3.2#

bash-3.2# passwd oracle

Changing password for "oracle"

oracle's New password:

Enter the new password again:

bash-3.2# smit chuser

bash-3.2# grep dba /etc/group

bash-3.2# /usr/bin/getconf HARDWARE_BITMODE

bash-3.2# booty info -K

bash-3.2# df n -k

bash-3.2# /usr/sbin/no -a | fgrep ephemeral

tcp_ephemeral_high = 65535

tcp_ephemeral_low = 32768

udp_ephemeral_high = 65535

udp_ephemeral_low = 32768

13. Hostname Setting for Oracle User.

->bash-3.2# /etc/hosts

->bash-3.2# hostname

DCDB1

bash-3.2# ORACLE_HOSTNAME=DCDB1

bash-3.2# export ORACLE_HOSTNAME

bash-3.2# echo $ORACLE_HOSTNAME

DCDB1

bash-3.2# mkgroup -'A' id='401' oinstall

bash-3.2# mkgroup -'A' id='402' dba

bash-3.2# mkgroup -'A' id='403' oper

bash-3.2# mkgroup -'A' id='404' osoper

bash-3.2# passwd oracle

bash-3.2# grep oinstall /etc/group

oinstall:!:401:oracle

bash-3.2# grep oinstall /etc/group

dba:!:402:oracle

bash-3.2# more /etc/oraInst.loc

/etc/oraInst.loc: A file or directory in the path name does not exist.

bash-3.2# smit security

+------------------------------------------------------+||+------------------------------------------------------+

| Initializing SMIT ... +------------------------------------------------------+||+------------------------------------------------------+

| Processing data ... +------------------------------------------------------+||+------------------------------------------------------+

| Processing data ...Security & Users

Move cursor to desired item and press Enter.

UsersGroups

Passwords

PKI

LDAP

Role Based Access Control (RBAC)

Trusted Execution

Cluster Security

F1=HelpF2=Refresh F3=Cancel F8=Image

F9=ShellF10=Exit Enter=Do +------------------------------------------------------+||+------------------------------------------------------+

| Processing data ... Users Add a UserChange a User's Password

Change / Show Characteristics of a Userck / Unlock a User's Account

Reset User's Failed Login Count

Remove a User

List All Users

F3=Cancel Enter=Do bash-3.2# smit security

+------------------------------------------------------+||+------------------------------------------------------+

| Initializing SMIT ... +------------------------------------------------------+||+------------------------------------------------------+

| Processing data ... +------------------------------------------------------+||+------------------------------------------------------+

| Processing data ...Security & Users

Move cursor to desired item and press Enter.

UsersGroups

Passwords

PKI

LDAP

Role Based Access Control (RBAC)

Trusted Execution

Cluster Security

F1=HelpF2=Refresh F3=Cancel F8=Image

F9=ShellF10=Exit Enter=Do +------------------------------------------------------+||+------------------------------------------------------+

| Processing data ... Users Add a UserChange a User's Password

Change / Show Characteristics of a Userck / Unlock a User's Account

Reset User's Failed Login Count

Remove a User

List All Users

F3=Cancel Enter=Do Add a User

Change a User's Password

Change / Show Characteristics of a User

Lock / Unlock a User's Account

Reset User's Failed Login Count

Remove a User

List All Users

+------------------------------------------------------+||+------------------------------------------------------+

| Processing data ... +------------------------------------------------------+||+------------------------------------------------------+

| Running command...COMMAND STATUS

Command: runningstdout: nostderr: no

Before command completion, additional instructions may appear below.

yes

root0/

daemon 1/etc

bin2/bin

sys3/usr/sys

adm4/var/adm

uucp5/usr/lib/uucp

guest 100/home/guest

nobody 4294967294/

lpd9/

lp11/var/spool/lp

invscout6/var/adm/invscout

snapp 200/usr/sbin/snapp

ipsec 201/etc/ipsec

nuucp 7/var/spool/uucppublic

pconsole8/var/adm/pconsole

esaadmin10/var/esa

sshd203/var/empty

oracle 401/home/oracle

+------------------------------------------------------+||+------------------------------------------------------+

| Processing data ...COMMAND STATUS

Command: OKstdout: yesstderr: no

Before command completion, additional instructions may appear below.

root0/

daemon 1/etc

bin2/bin

sys3/usr/sys

adm4/var/adm

uucp5/usr/lib/uucp

guest 100/home/guest

nobody 4294967294/

lpd9/

lp11/var/spool/lp

invscout6/var/adm/invscout

snapp 200/usr/sbin/snapp

ipsec 201/etc/ipsec

nuucp 7/var/spool/uucppublic

pconsole8/var/adm/pconsole

esaadmin10/var/esa

sshd203/var/empty

oracle 401/home/oracleF1=HelpF2=Refresh F3=Cancel F6=Command

F8=ImageF9=Shell F10=Exit /=Find

n=Find Next

bash-3.2# cat /etc/security/limits

14. Verify that the value shown for Maximum number of PROCESSES allowed per user is greater than or equal to 16384.

.Enter the following command:

bash-3.2# smit chgsys

To monitor the number of AIO server processes that have started, enter the following:

bash-3.2# ps -ek|grep -v grep|grep -v posix_aioserver

15. Creating directory for Oracle user and provide permission

bash-3.2# mkdir -p /oracle/product/11.2.0/db_1 cd cd /u012

bash-3.2# ls

lost+found

bash-3.2# mkdir –p /u01/oracle/app/product/11.2.0/db_1

bash-3.2# ls

lost+found oracle

bash-3.2# cd oracle/product/11.2.0/db_1/

bash-3.2# pwd

/u01/app/oracle/product/11.2.0/db_1

bash-3.2# chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/db_1

bash-3.2# chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/db_1 ls -ltr

total 0

bash-3.2# ls -ltr rt

total 0

bash-3.2# pwd

/u01/app/oracle/product/11.2.0/db_1

bash-3.2# cd ..

bash-3.2# ls -lrt

total 0

drwxr-xr-x 2 oracle oinstall 256 Jan 29 17:15 db_1

bash-3.2# chmod -R 775 /u01/app/oracle/product/11.2.0/db_1

bash-3.2# ls -lrt

total 0

drwxrwxr-x 2 oracle oinstall 256 Jan 29 17:15 db_1

bash-3.2#

bash-3.2# su - oracv le

$ bash

bash-3.2$ cd /home/oracle/

bash-3.2$ ls -al

total 16

drwxr-xr-x 2 oracle oinstall 256 Jan 29 17:17 .

drwxr-xr-x 5 bin bin 256 Jan 29 16:27 ..

-rwxr----- 1 oracle oinstall 254 Jan 29 16:27 .profile

-rw------- 1 oracle oinstall 8 Jan 29 17:17 .sh_history

bash-3.2$ cat .profile

16. Creating the Profile for Oracle user as a Oracle User

bash-3.2$ vi .profile

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.

export PATH

export TMPDIR=/tmp

export TEMP=/tmp

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

export ORACLE_SID=rashel

export PATH=$ORACLE_HOME/bin:$PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

#if [ -s "$MAIL" ] # This is at Shell startup. In normal

#then echo "$MAILMSG" # operation, the Shell checks

#fi # periodically.

bash-3.2$ cat .profile

PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.

export PATH

export TMPDIR=/tmp

export TEMP=/tmp

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

export ORACLE_SID=rashel

export PATH=$ORACLE_HOME/bin:$PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

#if [ -s "$MAIL" ] # This is at Shell startup. In normal

#then echo "$MAILMSG" # operation, the Shell checks

#fi

bash-3.2$ . ./.profile

17. For AIX, it is the ulimit settings that determine process memory related resource limits. Verify that the shell limits shown in the following table are set to the values shown.

Shell Limit (As Shown in smit) Recommended Value

Soft FILE size -1 (Unlimited)

Soft FILE size [2097151]

Soft CPU time -1 (Unlimited)

Note: This is the default value.

Soft DATA segment -1 (Unlimited)

Soft STACK size -1 (Unlimited)

Soft Real Memory size -1 (Unlimited)

Processes (per user) -1 (Unlimited)

Note: This limit is available only in AIX 6.1 or later. Refer to "Configure System Configuration Parameters" for information on configuration of processes per user limits.

To view the current value specified for these shell limits, and to change them if necessary:

Enter the following command as root user:

bash-3.2$ smit chuser

18. Just befor u go to install DB SOFT export display

# bash # set DISPLAY=10.40.40.100:0.0

bash-3.2# export DISPLAY=10.40.40.100:0.0

bash-3.2# echo $DISPLAY

192.168.10.1:0.0

19. Then just connect server using XMANAGER to install oracle. Follow the same step what u did to install her in WINDOWS,LINUX,SOLARIS,ORACLE-LINUX.

Oracle Installation Using Xmanager:

For Oracle Installation we use Xmanager

$ cd database

$ ./runInstaller &

Description:- Un-check to receive updates via Mail notification.

Description:- Click on Yes option.

Description:- Select option Install database software only. Since we will be creating the Database via DBCA.

Description:- Select option Single Instance Database Installation.

Description:- Select language English and Click on Next.

Description:- Select the Enterprise Edition option and Click on Next.

Description:- Ensure the value given here for ORACLE_BASE and ORACLE_HOME are same as bash Profile.

Description:- Provide 'dba' to Database Administrator group and 'oper' to Database Operator.

Description:- Click Finish.

Description:- No inputs here.

Description:- Run the scripts from root user.

$ su – root

# sh /oracle/app/oraIventory/orainstRoot.sh

# sh /oracle/app/oracle/product/11.2.0/db_1/root.sh

DataBase Creation Using Xmanager:

$ dbca

Description:- Click on Next.

Description:- select Create Database Option and Click on Next.

Description:- Select the Option General Purpose or Transaction Processing.

Description:- Un-check the option Enable Automatic Maintenance Tasks.

Description:- Uncheck the Configure Enterprise Manager also.

Description:- I have set the same password for SYS and SYSTEM Accounts.

Description:- Select option Storage type as File system, and Storage Location as Use Database file location from Template.

Description:- Select the Specify Flash Recovery Area. {oracle_base}/flash_recovery_area

/u02/oracle/rashel/FRA

Description:- Set the Character set as WE8ISO8859P15 -ISO 8859-15 West European, National Character set as AL16UTF16-Unicode UTF-16 Universal Character Set.

Description:- Give the location for control file in three different places.

Control_file Location:

/u02/oracle/rashel/CONTROL_FILES/control01.ctl

/u02/oracle/rashel/FRA/sonalicbs/control02.ctl

Description:- Location for the Redo log group 1 and Redo log member with each size 50MB.

Description:- Location for the Redo log group 2 and Redo log Member with each size 50MB

Description:- Location for the Redo log group 3 and Redo log Member with each size 50MB

/u02/oracle/rashel/REDO

Description:- Towards better performance of the database we have shuffle the main files in different location

/u02/oracle/rashel/oradata/system01.dbf

/u02/oracle/rashel/oradata/sysaux01.dbf

/u02/oracle/rashel/oradata/undotbs01.dbf

/u02/oracle/rashel/oradata/users01.dbf

/u02/oracle/rashel/oradata/TBACNTS.dbf

Description:- Check “Create Database” & Press Finish

Description:- No inputs here

Listener Configuration

$ netca

Description:- Select option Add and Click on Next.

Description:- Listener name – 'LISTENER', Click on Next

Description:- Select TCP and Click on Next.

Description:- Select option Use the standard port number of 1521 and Click on Next.

Description:- Select option No and Click on Next.

Description:- Click on Next.

Registering the Database for the Listener (Using Net Manager)

$ netmgr

Description:- Expand the tree under Local on the left side of the console. you can see Listeners and click on it.

Change the Listening locations to Database Services and Click to Add Database and give the host name and port Number

Changing the Default Port ….Here we use 1521 .

Description:- After changing to Database Services, Here we have to Register the Oracle Home and the

Database Name. Give the Oracle home as the Home Path of the Patch Location.

TNS Service Configuration Using Net Configuration Assistant

$ netca

Description:- Select option Local Host Service Name Configuration and Click on Next.

Description:- Provide the Service Name as rashelDC and Click on next.

Description:- Provide the Host Name and Port number details and Click on Next.

Description:- Select Option Yes perform a test and Click on Next.

Description : Provide the user name and Password and check whether the test is successful.

Description:- Click on Next.

Here Net Service Name :rashel

Description:- Click on Next.

Description:- Select option No and Click on Next.

Description:- Click on Next.

Description:- Click on Finish

ROAD-2-ORACLE

Tuesday, 12 August 2014

Oracle 11.2.0.3 g on IBM-AIX-7.1

No comments: