How To Install Oracle 10g RAC On Solaris 10 - Part 4 of 4

RDBMS Build & Post-Installation Tasks

BACKGROUND & OVERVIEW

The following documentation provides instructions for building an Oracle Real Application Cluster (RAC) database residing on a Sun Solaris 10 (Version 5.10) operating system.

This document is Part 4 of a 4-Part Installation Guide.

ASSUMPTIONS & PRE-REQUISITES

This document expects and assumes the following:

  • Part 1, Part 2 and Part 3 of the How To Install Oracle 10g RAC On Solaris 10 guide have been completed successfully.
  • The instructions are carried out by a qualified DBA, fully conversant with Oracle, including RAC.
  • Access to the internet is available.
  • All necessary client software, e.g. Telnet and X-Server is available.
  • The necessary RAC software has been installed under /u02/SOFTWARE.
    • The guide assumes sub-directories of CLUSTER, COMPANION, DATABASE and OPATCH exist.
  • The resultant database will be part of a RAC configuration.
  • All references to SIDxx should be replaced with correct database name.
  • All $variable references assume the .profile as described in the File Listings section has been implemented and run.
  • All root.sh references are used to indicate a script to be submitted as root has to be run. The exact name of the script may vary depending upon which piece of software is being installed or patched. The exact name of the script to be used will be displayed by the GUI.
  • The screen shots displayed are for guidance only, the values displayed on them do not necessarily correspond to the values used in the worked examples.

SETTINGS USED FOR THE WORKED EXAMPLE

  • The following settings and values have been used in the example:

IP ADDRESSES & HOST NAMES

Node 1 Host Name : HOST1
Node 1 IP Address : 192.168.1.1
Node 1 Oracle VIP Host Name : HOST1-vip
Node 1 Oracle VIP IP Address : 192.168.1.2
Node 1 Heart-beat Host Name : HOST1-hb
Node 1 Heart-beat IP Address : 192.168.2.1
Node 2 Host Name : HOST2
Node 2 IP Address : 192.168.1.3
Node 2 Oracle VIP Host Name : HOST2-vip
Node 2 Oracle VIP IP Address : 192.168.1.4
Node 2 Heart-beat Host Name : HOST2-hb
Node 2 Heart-beat IP Address : 192.168.2.2

SOFTWARE VERSIONS & LOCATIONS

Clusterware Source Software : HOST1:/u02/SOFTWARE/CLUSTER/10.2
Clusterware Source Patch Software : HOST1:/u02/SOFTWARE/CLUSTER/PATCHES
Node 1 Clusterware $HOME : HOST1:/u01/app/crs/product/10.2.0
Node 2 Clusterware $HOME : HOST2:/u01/app/crs/product/10.2.0
ASM Source Software : HOST1:/u02/SOFTWARE/DATABASE/10.2
ASM Source Patch Software : HOST1:/u02/SOFTWARE/DATABASE/PATCHES
Node 1 ASM $HOME : HOST1:/u01/app/asm/product/10.2.0
Node 2 ASM $HOME : HOST2:/u01/app/asm/product/10.2.0
Database Source Software : HOST1:/u02/SOFTWARE/DATABASE/10.2
Database Source Patch Software : HOST1:/u02/SOFTWARE/DATABASE/PATCHES
Node 1 Database $HOME : HOST1:/u01/app/oracle/product/10.2.0
Node 2 Database $HOME : HOST2:/u01/app/oracle/product/10.2.0
Node 1 OPatch Location : HOST1:/u02/SOFTWARE/OPATCH/OPatch
Node 2 OPatch Location : HOST2:/u02/SOFTWARE/OPATCH/OPatch

DISK INFORMATION

OCR Location : /dev/rdsk/emcpower0a
Voting Disk Location : /dev/rdsk/emcpower0b
Redundancy Method : External
ASM SPFile : /dev/rdsk/emcpower1a
ASM Password File : /dev/rdsk/emcpower1b
Database SPFile : /dev/rdsk/emcpower2a
Database Password File : /dev/rdsk/emcpower2b
Database Primary Disk Group : /dev/rdsk/emcpower3a - +DATA
Database Recovery Disk Group : /dev/rdsk/emcpower4a - +REC

CLUSTER, INSTANCE & DATABASE NAMES

Cluster Name : CRS_NAME
Node 1 Instance Name : SID01
Node 2 Instance Name : SID02
RAC Database Name : SID00
ASM Name : ASM_NAME
Node 1 ASM Instance Name : +ASM1
Node 2 ASM Instance Name : +ASM2

STEP-BY-STEP GUIDE

  1. Configure the DISPLAY variable, if not already set.
  2. Start x-server, if not already running.
  3. Start RDBMS build…
  4. Run dbca and follow the instructions as demonstrated in the Example RDBMS Build section below.
    • On HOST1
      • export ORACLE_BASE=/u01/app/oracle
      • export ORACLE_HOME=/u01/app/rdbms/product/10.2.0
      • cd /u01/app/oracle/product/10.2.0/bin
      • ./dbca
      • Required answers and actions - see the Example RDBMS Build section for the detailed plan:
        • OraAsm10g_home1
        • /u01/app/asm/product/10.2.0
        • ASM SYS password
        • ASM disk group name
        • ASM disk path name(s)
        • Run root.sh on each node.
  5. Run post-installation steps.
    • On HOST2
      • vi /var/opt/oracle/oratab
      • Add line SID02:/u01/app/oracle/product/10.2.0:N
      • mkdir -p /u01/app/oracle/DBA/SQL
      • mkdir -p /u01/app/oracle/DBA/SCRIPTS
      • Copy all required DBA SQL scripts to /u01/app/oracle/DBA/SQL
      • Copy all required DBA Unix scripts to /u01/app/oracle/DBA/SCRIPTS
      • . oraenv
      • SID02
      • sqlplus / as sysdba
      • SHUTDOWN IMMEDIATE;
      • EXIT;
    • On HOST1
      • vi /var/opt/oracle/oratab
      • Add line SID01:/u01/app/oracle/product/10.2.0:N
      • mkdir -p /u01/app/oracle/DBA/SQL
      • mkdir -p /u01/app/oracle/DBA/SCRIPTS
      • Copy all required DBA SQL scripts to /u01/app/oracle/DBA/SQL
      • Copy all required DBA Unix scripts to /u01/app/oracle/DBA/SCRIPTS
      • . oraenv
      • SID01
      • sqlplus / as sysdba
      • CREATE TABLESPACE tools DATAFILE '+DATA' SIZE 100M AUTOEXTEND ON;
      • ALTER SYSTEM SET COMPATIBLE='10.2.0.4' SCOPE=spfile;
      • ALTER SYSTEM SET CLUSTER_INTERCONNECTS='192.168.2.1' SCOPE=spfile SID='SID01';
      • ALTER SYSTEM SET CLUSTER_INTERCONNECTS='192.168.2.2' SCOPE=spfile SID='SID02';
      • ALTER SYSTEM SET db_recovery_file_dest_size=10G SCOPE=spfile;
      • ALTER SYSTEM SET dispatchers='' SCOPE=spfile;
      • ALTER SYSTEM SET remote_listener='' SCOPE=spfile;
      • ALTER SYSTEM SET log_archive_dest_1='LOCATION=+REC/SID00' SCOPE=spfile;
      • ALTER SYSTEM SET sga_max_size='8G' SCOPE=spfile;
      • ALTER SYSTEM SET sga_target='8G' SCOPE=spfile;
      • ALTER SYSTEM SET shared_pool_reserved_size='80M' SCOPE=spfile;
      • ALTER SYSTEM SET shared_servers=0 SCOPE=spfile;
      • SHUTDOWN IMMEDIATE;
      • STARTUP
      • ALTER SYSTEM SET db_cache_size=4G SCOPE=spfile;
      • SHUTDOWN IMMEDIATE;
      • STARTUP;
      • EXIT;
    • On HOST2
      • . oraenv
      • SID02
      • sqlplus / as sysdba
      • STARTUP;
      • EXIT;
  6. Check CRS functionality.
    • On HOST1 as root.
      • cd /u01/app/crs/product/10.2.0/bin
      • ./crsctl stop crs
      • ./crsctl start crs
    • On HOST2 as root.
      • cd /u01/app/crs/product/10.2.0/bin
      • ./crsctl stop crs
      • ./crsctl start crs
  7. Check server restart functionality.
    • On HOST1 as root.
      • sync; sync; reboot
  8. Check server restart functionality.
    • On HOST2 as root.
      • sync; sync; reboot
  9. The RDBMS build is now complete. Configure ARCHIVELOG mode as required and begin installation of any applications. It is also recommended that the steps listed in the Security Compliance section are completed.

SECURITY COMPLIANCE

The following steps should be performed once the database has been built to ensure that the environment conforms to Oracle's Best Practices and also ensures that it doesn't fall foul of any Internal Audit.

  1. Remove the GRANT EXECUTE TO PUBLIC privilege from potentially harmful packages.
    • sqlplus '/ as sysdba'
    • revoke execute on utl_file from public;
    • revoke execute on dbms_random from public;
    • revoke execute on utl_http from public;
    • revoke execute on utl_smtp from public;
    • revoke execute on utl_tcp from public;
    • exit
  2. Ensure the following user-ids' passwords, where applicable, have been changed:
    • SYS
    • SYSTEM
    • DBSNMP
    • OUTLN
    • CTXSYS
    • PERFSTAT
  3. Adjust the database DEFAULT TABLESPACE settings so that the SYSTEM is not used inappropriately.
    • sqlplus '/ as sysdba'
    • alter database default tablespace users;
    • Correct any users that already have SYSTEM as their DEFAULT TABLESPACE:
      • select username, default_tablespace from dba_users where default_tablespace = 'SYSTEM';
      • alter user <user name> default tablespace <non-SYSTEM tablespace>;
    • exit
  4. Lock and expire potentially harmful built-in user-ids.
    • sqlplus '/ as sysdba'
    • alter user outln password expire account lock;
    • alter user dbsnmp password expire account lock;
    • exit

EXAMPLE RDBMS BUILD


RDBMSBuild_01.jpg
  • Click Oracle Real Application Cluster database.
  • Click Next.

RDBMSBuild_02.jpg
  • Click Create A Database.
  • Click Next.

RDBMSBuild_03.jpg
  • Click Select All.
  • Ensure ALL nodes in the cluster are highlighted.
  • Click Next.

RDBMSBuild_04.jpg
  • Select Transaction Processing template.
  • Click Next.

RDBMSBuild_05.jpg
  • Enter Global Database Name - SID00.
  • Enter SID Prefix - This is the Global Database Name without the trailing 0 - SID0.
  • Click Next.

RDBMSBuild_06.jpg
  • Select Configure the Database with Enterprise Manager.
  • Select Use Database Control for Database Management.
  • Click Next.

RDBMSBuild_07.jpg
  • Select Use Same Password For All Accounts
  • Enter Password.
  • Confirm Password.
  • Click Next.

RDBMSBuild_08.jpg
  • Select Automatic Storage Management (ASM)
  • Click Next.

RDBMSBuild_09.jpg
  • Select DATA from Available Disk Groups list - only select the group(s) required for the database and NOT the recovery area.
  • Click Next.

RDBMSBuild_10.jpg
  • Select Use Oracle Managed Files.
  • Enter +DATA for Database Area.
  • Click Next.

RDBMSBuild_11.jpg
  • Select Flash Recovery Area.
  • Enter +REC for Flash Recovery Area.
  • Enter <FRA Size> for Flash Recovery Area Size.
  • Click Next.

RDBMSBuild_12.jpg
  • Click Next.

RDBMSBuild_13.jpg
  • Click Next.

RDBMSBuild_14.jpg
  • Select Typical
  • Click Sizing Tab.

RDBMSBuild_15.jpg
  • Enter <No. of Processes>.
  • Click Character Set Tab.

RDBMSBuild_16.jpg
  • Select Use Unicode.
  • Click Connection Mode Tab.

RDBMSBuild_17.jpg
  • Select Dedicated Server Mode.
  • Click Next.

RDBMSBuild_18.jpg
  • Review Summary.
  • Click Next.

RDBMSBuild_19.jpg
  • Select Create Database.
  • Select Generate Database Creation Scripts.
  • Enter <full path name to scripts directory>.
  • Click Finish.

RDBMSBuild_20.jpg
  • Click Save as HTML.

RDBMSBuild_21.jpg
  • Enter <full path name to scripts directory>.
  • Enter <file name>.
  • Click OK.

RDBMSBuild_20.jpg
  • Click OK.

RDBMSBuild_22.jpg
  • Wait for approx 2 mins…

RDBMSBuild_23.jpg
  • Click OK.

RDBMSBuild_24.jpg
  • Wait for approx 10 mins…

RDBMSBuild_25.jpg
  • Ignore error message.
  • Click OK.

RDBMSBuild_26.jpg
  • Click Exit.

RDBMSBuild_27.jpg
  • Click Yes.

© copyright 2001-2014 ABCdba.com | all rights reserved