Delete RMAN Backupset

• Check RMAN default device type.
• RMAN > show all;
• RMAN > configure default device type disk;
• RMAN > show all;
• RMAN> delete noprompt backupset 9836; 

Oracle 11g Release 2 (11.2.0.4.0) Client Installation on HP-UX Itanium (11.31) Server

This Document shows the step by step of installing and setting up Oracle 11g Release 2 (11.2.0.4.0) client on HP-UX Itanium (11.31) server.

The Installation is divided into three parts:

1.       Pre-Installation Tasks

2.       Installation of Oracle 11g Release 2 (11.2.0.4.0) Client

3.       Post-Installation Tasks

  1. Pre-Installation tasks.

  1.1. Patch Requirement Check

-Login as "root" user
The following are operating system patches for HP-UX Itanium (11.31):
PHCO_43503 11.31 diskowner(1M) cumulative patch
PHCO_41479 11.31 Disk Owner Patch
PHKL_38038 VM patch - hot patching/Core file creation directory
PHKL_38938 11.31 SCSI cumulative I/O patch
PHKL_40941 Scheduler patch: post wait hang
PHSS_36354 11.31 assembler patch
PHSS_37042 11.31 hppac (packed decimal)
PHSS_37959 Libcl patch for alternate stack issue fix (QXCR1000818011)
PHSS_39094 11.31 linker + fdp cumulative patch
PHSS_39100 11.31 Math Library Cumulative Patch
PHSS_39102 11.31 Integrity Unwind Library
PHSS_38141 11.31 aC++ Runtime
PHSS_39824 - 11.31 HP C/aC++ Compiler (A.06.23) patch

Check Patch:
swlist -l bundle |grep QPK 
swlist -l patch |grep PHCO_43503*

<<<Use full Command>>

    #/usr/contrib/bin/machinfo | grep -i Memory   [Memory Check]

    #/bin/getconf KERNEL_BITS  [System Architecture Check]

    # /usr/sbin/swlist -l bundle |grep QPK [Patch bundle requirement check]

    # uname -a  [Operating system Check]

    # bdf [disk space check]

    # bdf /tmp [TMP space check]

    # swlist -l patch |grep PHCO_43503 [Individual patch Check]

    # grep dba /etc/group   [Group Check]

  1.2. Create required Groups and  user.

  -Enter the following commands to create the oinstall and dba groups (from "root" user):

    # /usr/sbin/groupadd oinstall

    # /usr/sbin/groupadd dba

    # /usr/sbin/groupadd oper

  -Complete the following actions to create oracle user (from root user):

   # /usr/sbin/useradd –m –u 108 –g oinstall –G dba,oper –d /home/oracle oracle

   

   # passwd oracle

   #chown oracle:oinstall /home/oracle

   $chmod -R 777 .profile  [Login as "oracle" user]

  1.3. Create required Directories:

-Login as "root" user

mkdir -p /u01/app/oracle

mkdir -p /u01/app/oracle/product/11.2.0.4.0/client_1

chown -R oracle:oinstall /u01/app

chown -R oracle:oinstall /u01/app/oracle/product/11.2.0.4.0/client_1

chmod -R 775 /u01/app

chmod -R 775 /u01/app/oracle/product/11.2.0.4.0/client_1

  1.4. Create oracle user environment.

-Login as "oracle" user

$ vi .profile

umask 022

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4.0/client_1

export PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_HOSTNAME=dcpweb02

TZ=GMT6

export TZ

$. ./.profile   [To run Profile]

$echo ORACLE_HOME  [To check profile variable] 

  2. Installation of Oracle 11g Release 2 (11.2.0.4.0) client

-Login as "oracle" user

-xmanager3 for GUI

$ cd /tmp/soft

$./runInstaller

a.select option 'Administrator' and click 'next >'

b.select option 'Skip Software Update' and click 'next >'

c.To confirm English as selected language and click 'next >'

d.Specify path for oracle base(ORACLE_BASE) and location where we want to store the software (ORACLE_HOME). Click ' Next>'

e. Specify path for oracle Inventory and Click 'Next >'

f. Summary after pre-requisite check

g. Install Product

h. Root.sh Script Execute  

i. Installation Completed

  3. Post-Installation tasks

-Login as "oracle" user

>>Create tnsnames.ora file

>>use DNS Scan 

RACDB=

 (DESCRIPTION =

  (ADDRESS = (PROTOCOL = TCP)(HOST = dcpdb-scan.xxx.com)(PORT = 15xx))

    (CONNECT_DATA =

      (SERVICE_NAME = dcpdb.xxx.com)

    )

  )

>>[OR] Direct tns connection

RACDB =

  (DESCRIPTION =

      (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.xx.xx)(PORT = 15xx))

                  (ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.xx.xx)(PORT = 15xx))

                        (LOAD_BALANCE = yes)

                            )

                                (CONNECT_DATA =

                                      (SERVER = DEDICATED)

                                            (SERVICE_NAME = dcpdb.xxxx.com)

                                                  (FAILOVER_MODE =

                                                          (TYPE = SELECT)

                                                                  (METHOD = BASIC)

                                                                          (RETRIES = 10)

                                                                                  (DELAY = 5)

                                                                                        )

                                                                                            )

                                                                                              )