DBA-Philiac

Create user: oracle Create group: oinstall,dba Add oinstall,dba to user oracle groupadd oinstall groupadd dba useradd oracle -g oinstall -G dba passwd oracle [ for OSDBA select dba group, OS users under this group will get SYSDBA privilege for OSOPER select oinstall group, OS users under this group will get SYSOPER privilege ] chown oracle /opt/oracle/ chgrp dba /opt/oracle/ increase "tmpfs(/dev/shm)" to >= "memory_max_target" (If use autometic memory management) unzip two disks in the same folder like below, o therwise some .ear file missing error may occur: ---------------------------------------- unzip linux_11gR2_database_1of2.zip unzip linux_11gR2_database_2of2.zip cd database ./runInstall ---------------------------- append below lines in file:/etc/sysctl.conf # Controls the maximum number of shared memory segments kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 6815744 fs.aio-max-nr=1048576 net.ipv4.ip_local_port_range=9000 65500 net.core...

1 Upgrade Oracle Database from 10.2.0.4 to 11.2.0.1 1.1 Pre-installation Tasks - Upgrade 10.2.0.1 to any upper version (we upgraded to 10.2.0.4) - Install Oracle Database 11gR2 software (only binary, no database and must be in different ORACLE_HOME ): 1. In our case we install in in same ORACLE_BASE but Different ORACLE_HOME 2. on RHEL5R4 some kernel parameter value needed to be changed and some rpm needed to be installed. Change those and use sysctl –p (from root) to reload kernel parameters. 3. In case of installing unix-ODBC and unix-ODBC-devel rpm, first install unix-ODBC and unix-ODBC-devel to avoid dependency warnings. 4. ./runinstaller (install Software only) 5. After resolving all requirements use check again button to recheck. 6. Press Next and complete SW installation process. 7. Incase of running $ORACLE_HOME(new)/root.sh accept all default values. - Run the Pre-Upgrade Information Tool 1...