Monday, April 18, 2016

Oracle DB Installation Checklist

Task ID Task Items Completed By Date Completed Comments
1 Review Oracle Installation guides:      
1.1      http://docs.oracle.com/database/121/nav/portal_11.htm      
2 Hardware and Memory Requirements:      
2.1      RAM Size           /usr/sbin/lsattr -E -l sys0 -a realmem                
2.2      Swap Space      /usr/sbin/lsps -s      
2.3      CPU                 lsconf|grep Proces      
3 Storage Miniumum Requirements:      
3.1      Software Installation Size      
3.2      Verify Mount Point has enough space for Install files      
3.3      Sizing for file system based Oracle Environment:      
3.4           /u01 Binaries      
3.5           /u02 Data      
3.6           /u03 Backups      
3.7      Determine if minimum amount of /tmp space is available      
4 Operating System Requirements:      
4.1      Determine version of AIX installed   oslevel -s      
4.2      Verify that the required packages are installed      
4.3      Determine the supported kernel mode      
4.4      Determine an APAR is installed      
4.5      Verify required Operating System Groups and Users      
4.6      Configure Shell Limits      
4.7      Configure System Configuration Kernel Parameters      
4.8      Confirm the aio_maxreqs value      
4.9      Enable the "iocp" option      
4.10      Creating Required Directories      
4.11      Port Requirements (OEM requires specific ports to be open)      
5 Database Requirements:      
5.1      Oracle Parameters      
5.2      PGA/SGA      
5.3      Database Storage - Data, Backup, Logs      
6 Install GRID Infrastructure: (Only if ASM is to be configured)      
7 Install 12c Database Binaries:      
7.1      Running the rootpre.sh Script      
7.2      Start CYGWIN      
7.3      Insall 12c Binaries      
8 Create Database using DBCA      
8.1     Refer to the Database Requirements while creating the new database      
9 Post Installation Tasks      
9.1      Update .profile      
9.2      Verify /etc/oratab      
9.3      Setup RMAN Backups      
9.4      Setup Crontab entries      
9.5      Update TNSNAMES.ORA      
9.6      Change email identifier from oracle to <HOSTNAME>      
9.7      Setup TDP for RMAN backups      
9.8      Setup Startup scripts      
9.9      Review and verify oracle parameters      
9.10      Alter DEFAULT profile in new database to unlimited      
9.11      Configure trace file retention policy using ADRCI      

No comments:

Post a Comment