How to Install Oracle 11g on Linux with ASMFoldTable of ContentsBackground & OverviewAssumptions & Pre-RequisitesUseful InformationStep-By-Step GuideHow to Disable Oracle HASSecurity ComplianceRegressionFile Listingsoracle .profileoratablistener.oraASM Parameter FileinitSID.oracreatedb.sqltnsnames.oraFile SystemsExample ASM InstallExample Database InstallOther ReferencesKnown IssuesORA-7445 [kokscold()+849]DescriptionFixRunning root.sh on the DatabaseDescriptionExample OutputMiscellaneousOS Packages for Oracle Enterprise Linux v5Removing an 11g DatabaseDeinstalling Oracle 11g Binaries and DatabaseStep-by-StepExample Output

Background & OverviewThe following documentation provides instructions for building an Oracle 11g database with ASM residing on an Oracle Linux Server (Version 5.3, Kernal version 2.6.18). Use the commandlsb_release -idto check the Oracle Linux OS version anduname -rto check the Kernal level.Further reference documentation about Oracle 11g and Oracle Linux is detailed in theOther Referencessection below.

Assumptions & Pre-RequisitesThis document expects and assumes the following: The instructions are carried out by a qualified DBA. Access to the internet is available. All necessary client software, e.g. Telnet and X-Server is available. The resultant database will be standalone, i.e. not part of a cluster or failover configuration. Documentation for clustered (RAC) configurations can be found here. -Add link when documentation available_ Documentation for failover configurations can be found here. -Add link when documentation available All references toSIDshould be replaced with correct database name as derived using a suitable database naming standard. All$variablereferences assume the.profileas described in theFile Listingssection has been implemented and run. There is onlyONEdatabase installed on the server.Useful InformationThis section outlines useful information and changes to previous 10g documentation found on this site. Some have been made for cosmetic reasons, others for more practical considerations. A new deinstallation tool is used for deinstalling Oracle software and databases. SeeDeinstalling Oracle 11gsection below. On Linux theorataband theoraInst.locfile is kept in directory/etc. A new directory structure exists.See below. A newinit.oraparameter calleddiag_desthas been set and maps to thediagdirectory in the new directory structure mentioned above. Alistener.orafile has a new parameter calledADR_BASE_LISTENER. This maps to thebaseof thediagdirectory. There are a number of new maintenance jobs in 11g. These will be turned off as part of this step-by-step guide. In order to get the database working withASM,Oracle Grid Infrastructurewill need to be installed. This should not be mistaken forOracle Grid Control. The following guide explains how to installOracle Grid Infrastructureand any pre-requisite packages likeASMLIB. Read theKnown Issuessection below. At the time of writing this guide there are no supportedVeritas Clusteragents for database version 11.2.Step-By-Step Guide1. Get aUNIX administratorto check the followingMetalinkarticle169706.1to ensure that the SE Linux build meets Oracle's requirements.2. Ensureoracleaccount anddbagroup exists.3. Ensure theOracle Linuxversion is5.3or higher. lsb_release -id4. Ensure theOracle LinuxKernal version is2.6.18or higher. uname -r5. Ask a UNIX administrator to check that the correctOSpackages have been installed as detailled in thePackages for Oracle Enterprise Linux v5section below.6. Ensure thatSHMMAXis set to4Gbminus1 byte. This is to accomodate feature/bug detailled in Metalink nore 567506.1. grep -i shmmax /etc/sysctl.conf7. Ensurenet.ipv4.ip_local_port_rangeis set to9000 to 655008. Get a Unix administrator to set the machine to permissive mode. setenforce 09. Check the machine is in permissive mode. getenforceNBThis is required due to a bug/feature in Oracle.10. Ensure/dev/shmis large enough. It should be set to the size of the physical RAM minus 4GB. (or an appropriate amount reserved for the OS) cd /dev/shm df -h .11. Ask a Unix administrator to installASMLIB. At the time of writing this guide, the following Linux package had been identified by the Unix team,oracleasm-2.6.18-128.4.1.0.1.el5-2.0.5-1.el5.x86_64.rpm. This will install the follwingASM 2.0libraries oracleasmlib-2.0 ~ The ASM libraries oracleasm-support-2.0 ~ Utilities needed to administer ASMLib oracleasm ~ A kernel module for the ASM library12. Ask a Unix administrator to create a single partition on each device to be used byASM. fdisk /dev/mapper/< alias > kpartx /dev/mapper/< alias >< partition >13. Ask a Unix administrator to create theASMdisks oracleasm createdisk < disk label > /dev/mapper/< alias >< partition >14. Create and run.profile- seeFile Listingssection below.15. Ensure the database file systems have been created with correct permissions and have been sized appropriately for the application. - seeFile Systemssection below.16. Download the latest oracle binaries fromOTN. For example:Enterprise Edition for Linux Operating System (64-bit)linux.x64_11gR2_database_1of2.zip : 1,239,269,270 bytes; cksum - 3152418844linux.x64_11gR2_database_2of2.zip : 1,111,416,131 bytes; cksum - 3669256139linux.x64_11gR2_grid.zip : 1,052,897,657 bytes; cksum - 336967639817. Unzip the downloaded files using the following commands cd /u01/app/oracle/software/ unzip 18. Configure theDISPLAYvariable.19. Unset theORACLE_HOMEandTNS_ADMIN unset ORACLE_HOME unset TNS_ADMIN20. Set theORACLE_BASE export ORACLE_BASE=/u01/app/oracle21. EnsureORACLE_HOME/binisNOTin thePATH22. Startx-server.23. Start the installer. cd /u01/app/oracle/software/grid ./runInstaller24. Follow the instructions as demonstrated in theExample ASM Installsection below.Before continuing apply any oneoff patches or patch bundles or CPU patch bundles recommended by Oracle or the application vendor.25. Create additionalASM Disk Groups sqlplus '/ as sysasm' SQL>create diskgroup FRA EXTERNAL REDUNDANCY SQL>disk 'ORCL:asm disk label' ; SQL>exit;26. Create theADM aliases sqlplus '/ as sysasm' SQL>alter diskgroup DATA add directory '+DATA/'; SQL>alter diskgroup FRA add directory '+FRA/< SID >'; SQL>alter diskgroup FRA add directory '+FRA/< SID >/arch'; SQL>exit;27. Alter the disk group attributes to 11.2 compatability. sqlplus '/ as sysasm' SQL>alter diskgroup DATA set attribute 'compatible.asm'='11.2'; SQL>alter diskgroup DATA set attribute 'compatible.rdbms'='11.2'; SQL>alter diskgroup FRA set attribute 'compatible.asm'='11.2'; SQL>alter diskgroup FRA set attribute 'compatible.rdbms'='11.2'; SQL>exit;28. Disable the high availability services. crsctl disable has29. Create theASMinit.ora. Usingvicreate file$ORACLE_HOME/dbs/init+ASM.oraas defined in theASM Parameter Filesection below.30. Create apassword fileforASM cd $ORACLE_HOME/dbs rm orapw+ASM orapwd file=orapw+ASM password=password31. Shutdown ASM sqlplus '/ as sysasm' SQL>shutdown immediate SQL>quit32. Startup ASM on the newpfileand create anspfile sqlplus '/ as sysasm' SQL>startup pfile='$ORACLE_HOME/dbs/init+ASM.ora' SQL>create spfile='+DATA' from pfile='$ORACLE_HOME/dbs/init+ASM.ora'; SQL>shutdown immediate SQL>quit33. Remove oldinit.orafiles cd $ORACLE_HOME/dbs rm init.ora rm init+ASM.ora34. Startup ASM on the newspfile sqlplus '/ as sysasm' SQL>startup SQL>quit35. Enable, Stop and Start the High Availability Service. crsctl enable has crsctl stop has crsctl start has36. Configure theDISPLAYvariable.37. Unset theORACLE_HOMEandTNS_ADMIN unset ORACLE_HOME unset TNS_ADMIN38. Startx-server.39. Start the installer. cd /u01/app/oracle/software/database ./runInstaller40. Follow the instructions as demonstrated in theExample Installsection below.Before continuing apply any oneoff patches or patch bundles or CPU patch bundles recommended by Oracle or the application vendor.41. Configure/etc/oratabfile and test using. oraenvcommand - seeFile Listingssection below.42. Configure$ORACLE_BASE/admin/SID/create/createdb.sqlfile, adjusting parameters accordingly - seeFile Listingssection below.43. Configure$ORACLE_BASE/admin/SID/pfile/initSID.orafile, adjusting parameters accordingly and create symbollic link to it from$ORACLE_HOME/dbs- seeFile Listingssection below.44. Remove templateinit.orafile from$ORACLE_HOME/dbs.45. Configure Oracle environment variables using the following commands: . oraenv SID46. Set-up a$ORACLE_HOME/network/admin/listener.orafile as detailed in theFile Listingsbelow.47. Start the listener using the commandlsnrctl start.48. Build the embryo database using the following commands: cd $ORACLE_HOME/dbs orapwd file=orapwSID password= cd $ORACLE_BASE/admin/SID/create sqlplus '/ as sysdba' SQL>@createdb.sql EnterSYSpassword. EnterSYSTEMpassword. EnterSIDname. Wait for database to build - this may take up to 30 mins Confirm there are no unexpected errors in$ORACLE_BASE/admin/SID/create/createdb.log. SQL>connect / as sysdba SQL>CREATE SPFILE='/u01/app/oracle/admin/SID/pfile/spfileSID.ora' FROM PFILE='/u01/app/oracle/admin/SID/pfile/initSID.ora'; SQL>shutdown immediate SQL>exit rm initSID.ora ln -s /u01/app/oracle/admin/SID/pfile/spfileSID.ora spfileSID.ora sqlplus '/ as sysdba' SQL>startup SQL>quit49. Disable the default11gmaintenance jobs. sqlplus /nolog SQL>connect sys as sysdba SQL>BEGIN SQL>dbms_auto_task_admin.disable(client_name => 'auto optimizer stats collection', operation => NULL,window_name => NULL); SQL>dbms_auto_task_admin.disable(client_name => 'auto space advisor', operation => NULL, window_name => NULL); SQL>dbms_auto_task_admin.disable(client_name => 'sql tuning advisor', operation => NULL, window_name => NULL); SQL>END; SQL>/50. Confirm database has been recognised by the listener using the commandlsnrctl status- this may take a minute or so to occur.51. Remove unwanted files cd $TNS_ADMIN rm -rf samples52. Configure$TNS_ADMIN/tnsnames.orafile, adjusting parameters accordingly - seeFile Listingssection below.53. Confirm connections viaSQLnetare working using the following commands: sqlplus system/@SID SQL>exitHow to Disable Oracle HAS1. DisableOracle HAS crsctl disable hasSecurity ComplianceThe 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 Internal Audit.1. Remove theGRANT EXECUTE TO PUBLICprivilege from potentially harmful packages. sqlplus '/ as sysdba' SQL>revoke execute on utl_file from public; SQL>revoke execute on dbms_random from public; SQL>revoke execute on utl_http from public; SQL>revoke execute on utl_smtp from public; SQL>revoke execute on utl_tcp from public; SQL>exit2. Ensure the following user-ids' passwords, where applicable, have been changed: SYS SYSTEM DBSNMP OUTLN CTXSYS PERFSTAT1. Adjust the databaseDEFAULT TABLESPACEsettings so that theSYSTEMtablespace is not used inappropriately. sqlplus '/ as sysdba' SQL>alter database default tablespace users; SQL>alter user sys default tablespace system; SQL>alter user system default tablespace system;2. Correct any users that already haveSYSTEMas theirDEFAULT TABLESPACE sqlplus '/ as sysdba' SQL>select username, default_tablespace from dba_users where default_tablespace = 'SYSTEM'; SQL>alter user default tablespace ; SQL>exit3. Lock and expire potentially harmful built-in user-ids. sqlplus '/ as sysdba' SQL>alter user outln password expire account lock; SQL>alter user dbsnmp password expire account lock; SQL>exitRegressionTo restore the environment back to its initial state, perform the following1. Shutdown the database and listener.2. Remove all database files, binaries, trace files and administration logs using thedeinstalltool - seeMiscellaneous Sectionbelow.File Listingsoracle .profile#----------------------------------------------------------------------# Configure Terminal Settings.#----------------------------------------------------------------------stty susp ^Zstty quit ^Cstty erase ^Hexport TERM=vt100-wexport ORACLE_TERM=vt100#----------------------------------------------------------------------# Configure Shell Settings.#----------------------------------------------------------------------set -o viexport PATH=/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/ccs/bin:$PATHexport EDITOR=viexport HOSTNAME=hostname`export PS1=$LOGNAME@$HOSTNAME:$ORACLE_SID> 'export TMPDIR=/tmpexport TEMP=/tmpumask 022#----------------------------------------------------------------------# Configure Aliases.#----------------------------------------------------------------------alias ll="ls -la"alias bdf="df -k"#----------------------------------------------------------------------# Configure Oracle Settings.#----------------------------------------------------------------------export ORACLE_BASE=/u01/app/oracleexport SQLPATH=$ORACLE_BASE/scripts/sqlexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1export TNS_ADMIN=$ORACLE_HOME/network/adminexport ORACLE_HOME_LISTNER=$ORACLE_BASE/product/11.2.0/dbhome_1export PATH=$ORACLE_HOME/bin:$PATHexport ORATAB=/etc/orataboratabSID:/u01/app/oracle/product/11.2.0/dbhome_1:Y+ASM:/u01/app/oracle/product/11.2.0/grid:Nlistener.oraSID_LIST_LISTENER =(SID_LIST =(SID_DESC =(GLOBAL_DBNAME = )(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)(SID_NAME = )))LISTENER =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)))ADR_BASE_LISTENER = /u01/app/oracleASM Parameter File############################################ Cache and I/O###########################################large_pool_size = 12m############################################ ASM Instance Parameters###########################################instance_type = asmasm_power_limit = 1############################################ Security and Diagnostics###########################################remote_login_passwordfile = exclusivediagnostic_dest = '/u01/app/oracle'############################################ Disk Groups###########################################asm_diskstring = '/dev/oracleasm/disks/*'asm_diskgroups = 'DATA','FRA'initSID.ora############################################ Cache and I/O###########################################db_block_size=8192memory_target=1606418432db_block_checking=MEDIUMdb_block_checksum='FULL'

############################################ Cursors and Library Cache###########################################open_cursors=500############################################ Database Identification###########################################compatible='11.2.0.0.0'db_name='SID'############################################ Diagnostics and Statistics###########################################diagnostic_dest='/u01/app/oracle'############################################ File Configuration###########################################control_files='+DATA/SID/control01.ctl','+DATA/SID/control02.ctl','+DATA/SID/control03.ctl'############################################ Processes###########################################processes=1000############################################ System Managed Undo and Rollback Segments###########################################undo_tablespace='UNDO'############################################ Security and Auditing###########################################audit_trail='db'remote_login_passwordfile='EXCLUSIVE'############################################ Enabling Archivelog mode###########################################log_archive_dest='+FRA/SID/arch/d1'log_archive_format=arch_%t_%s_%r.log############################################ Defer Segment Creation###########################################deferred_segment_creation=FALSEcreatedb.sql---- Title : createdb.sql-- Description : Build an empty database.---- Usage/Notes : For use with 11g databases.-- Required answers for SYS,-- SYSTEM and SID.----ACCEPT syspw PROMPT 'Enter SYS password : 'ACCEPT systpw PROMPT 'Enter SYSTEM password : 'ACCEPT sid PROMPT 'Enter SID name : 'SET VERIFY OFFSET ECHO ONSPOOL createdb.logSTARTUP NOMOUNTCREATE DATABASE &sidUSER SYS IDENTIFIED BY &syspwUSER SYSTEM IDENTIFIED BY &systpwMAXDATAFILES 1024MAXINSTANCES 1MAXLOGFILES 32MAXLOGMEMBERS 4MAXLOGHISTORY 100CHARACTER SET AL32UTF8ARCHIVELOGDATAFILE '+DATA/&sid/system_01.dbf'SIZE 400mEXTENT MANAGEMENT LOCALSYSAUX DATAFILE '+DATA/&sid/sysaux_01.dbf'SIZE 400mLOGFILEGROUP 1 ('+DATA/&sid/redo001a.dbf','+FRA/&sid/redo001b.dbf')SIZE 50m,GROUP 2 ('+DATA/&sid/redo002a.dbf','+FRA/&sid/redo002b.dbf')SIZE 50m,GROUP 3 ('+DATA/&sid/redo003a.dbf','+FRA/&sid/redo003b.dbf')SIZE 50m,GROUP 4 ('+DATA/&sid/redo004a.dbf','+FRA/&sid/redo004b.dbf')SIZE 50mUNDO TABLESPACE undoDATAFILE '+DATA/&sid/undo_01.dbf'SIZE 400mDEFAULT TEMPORARY TABLESPACE tempTEMPFILE '+DATA/&sid/temp_01.dbf'SIZE 400mEXTENT MANAGEMENT LOCAL UNIFORM SIZE 1m/SET ECHO OFFPROMPTPROMPTPROMPT Now running CATALOG. Please wait.PROMPTPROMPTSET TERMOUT OFF@${ORACLE_HOME}/rdbms/admin/catalogSET TERMOUT ONPROMPTPROMPTPROMPT Now running CATBLOCK. Please wait.PROMPTPROMPTSET TERMOUT OFF@${ORACLE_HOME}/rdbms/admin/catblockSET TERMOUT ONPROMPTPROMPTPROMPT Now running CATPROC. Please wait.PROMPTPROMPTSET TERMOUT OFF@${ORACLE_HOME}/rdbms/admin/catprocSET TERMOUT ONSET ECHO ONCREATE TABLESPACE toolsDATAFILE '+DATA/&sid/tools_01.dbf' SIZE 400mEXTENT MANAGEMENT LOCAL AUTOALLOCATESEGMENT SPACE MANAGEMENT AUTO/CREATE TABLESPACE usersDATAFILE '+DATA/&sid/users_01.dbf' SIZE 400mEXTENT MANAGEMENT LOCAL AUTOALLOCATESEGMENT SPACE MANAGEMENT AUTO/CREATE TABLESPACE indxDATAFILE '+DATA/&sid/indx_01.dbf' SIZE 400mEXTENT MANAGEMENT LOCAL AUTOALLOCATESEGMENT SPACE MANAGEMENT AUTO/CREATE USER ops$oracle IDENTIFIED EXTERNALLYDEFAULT TABLESPACE users/GRANT DBA TO ops$oracle/CONN system/&systpwSET ECHO OFFPROMPTPROMPTPROMPT Now running PUPBLD. Please wait.PROMPTPROMPTSET TERMOUT OFF@?/sqlplus/admin/pupbld.sqlSET TERMOUT ONCONN system/&systpwSET ECHO OFFPROMPTPROMPTPROMPT Now running HLPBLD. Please wait.PROMPTPROMPTSET TERMOUT OFF@?/sqlplus/admin/hlpbld.sqlSET TERMOUT ONSET ECHO ONSPOOL OFFtnsnames.ora =(DESCRIPTION =(ADDRESS = (PROTOCOL = tcp)(HOST = )(PORT = 1521))(CONNECT_DATA = (SID = )))File Systems--- /u01 --- /app --- /oraInventory|aaaaaaaaaaaaaa||aaaaaaaaaaaaaa--- /oracle --- /software|aaaaaaaaaaaaaaaaaaaaaaa||aaaaaaaaaaaaaaaaaaaaaaa--- /dba --- /scripts|aaaaaaaaaaaaaaaaaaaaaaa||aaaaaaaaaaaaaaaaaaaaaaa|aaaaaaa--- /sql|aaaaaaaaaaaaaaaaaaaaaaa||aaaaaaaaaaaaaaaaaaaaaaa--- /diag|aaaaaaaaaaaaaaaaaaaaaaa||aaaaaaaaaaaaaaaaaaaaaaa--- /product ---/11.2.0 ---/dbhome_1|aaaaaaaaaaaaaaaaaaaaaaa||aaaaaaaaaaaaaaaaaaaaaaa--- /product ---/11.2.0 ---/grid|aaaaaaaaaaaaaaaaaaaaaaa||aaaaaaaaaaaaaaaaaaaaaaa--- /admin --- /SID --- /adump|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa||aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa--- /create|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa||aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa--- /exp|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa|aa (link to /u09)|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa||aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa--- /parfile|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa||aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa--- /pfile|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa||aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa--- /scripts ---/base ---/rfc|||--- /u09 --- /oradata --- /SID -------- /exp ------- /d1Example ASM Install

SelectInstall and Configure Grid Infrastructure for a Standalone Server ClickNext

ClickNext

SetDisk Group NametoDATA Ensure theRedundancyradio button is set toExternal NBIt is assumed that external disk infrastricture will mirror the disks. If not, review this option. Ensure theCandidate Diskradio button is selected. Tick the box next to the candidate disk(s) you wish to add to the disk group. ClickNext

SelectUse same passwords for these accounts Enter a valid password in theSpecify Passwordbox. Enter a valid password in theConfirm Passwordbox.

NBIf you specified an insecure password, the following message will be displayed.

Set theASM Database Administrator (OSDBA) Grouptodba Set theASM Instance Administration Operator (OSOPER) Grouptodba Set theASM Instance Administrator (OSASM) Grouptodba NBThese options will be site specific and should be reviewed. ClickNext

ClickYesto continue.

EnsureOracle Baseis set to/u01/app/oracle ClickNext

Ensure theInventory Directoryis set to/u01/app/oraInventory ClickNext

Review the Summary screen ClickFinish

As root, ask the UNIX administrator to run/u01/app/oraInventory/orainstRoot.sh As root, ask the UNIX administrator to run/u01/app/oracle/product/11.2.0/grid/root.sh ClickYes

ClickClose

Example Database Install

Un-tick theI wish to receive security updates via My Oracle Supportbox. NBThis is site specific and should be reviewed. ClickNext.

ClickYesto remain uninformed.

SelectInstall database software only. ClickNext.

EnsureSingle instance database installationis selected. ClickNext.

Ensure languagesEnglsihandEnglish (United Kingdom)are selected. ClickNext.

EnsureEnterprise Editionis selected. ClickNext.

SetOracle Baseto/u01/app/oracle AllowSoftware Locationto default ClickNext.

EnsureDatabase Administrator (OSDBA) Groupis set todba EnsureDatabase Operator (OSOPER) Groupis set todba ClickNext

Review the summary. If required save the response file by selectingSave Response File ClickFinish

This screen moves on automatically when complete.

Ask Unix Administrator to runroot.sh. -Note: There is a known issue with running this script.Seehere. ClickOK.

ClickClose.

Other References Best Practices For Running Oracle Databases In Solaris Containers Oracle 10g Hidden Performance Tuning ParametersKnown IssuesORA-7445 [kokscold()+849]DescriptionThis is due to unpublished Bug9594372, documented in Note1115493.1and occurs when running SQL_ANALYZE from a scheduled job. The SQL statement is likely to be similar to the following./* SQL Analyze(397,1) */ MERGE INTO MGMT_ARU_PATCH_RECOMMENDATIONS p USING ..FixApply patch9594372

Running root.sh on the DatabaseDescriptionWhen runningroot.shyou are prompted for thelocal bindirectory. The default directory is specified in square brackets. However, due to a bug in theroot.shscript this default is not picked up. As a result, you will always need to specify thelocal bindirectory regardless of the default specified within the square brackets.Example Output[root@myhost dbhome_1]# ./root.shRunning Oracle 11g root.sh scriptThe following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1Enter the full pathname of the local bin directory: [/usr/local/bin]: /usr/local/binThe file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)[n]: yCopying dbhome to /usr/local/bin The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)[n]: yCopying oraenv to /usr/local/bin The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)[n]: yCopying coraenv to /usr/local/bin

Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.Finished product-specific root actions.

MiscellaneousOS Packages for Oracle Enterprise Linux v5The followingOSpackages at the following minimum version should be installed on Oracle Enterprise Linux v5 before you start the Oracle software install.Correct as of 01 September 2009binutils-2.17.50.0.6compat-libstdc++-33-3.2.3compat-libstdc++-33-3.2.3 (32 bit)elfutils-libelf-0.125elfutils-libelf-devel-0.125gcc-4.1.2gcc-c++-4.1.2glibc-2.5-24glibc-2.5-24 (32 bit)glibc-common-2.5glibc-devel-2.5glibc-devel-2.5 (32 bit)glibc-headers-2.5ksh-20060214libaio-0.3.106libaio-0.3.106 (32 bit)libaio-devel-0.3.106libaio-devel-0.3.106 (32 bit)libgcc-4.1.2libgcc-4.1.2 (32 bit)libstdc++-4.1.2libstdc++-4.1.2 (32 bit)libstdc++-devel 4.1.2make-3.81sysstat-7.0.2unixODBC-2.2.11unixODBC-2.2.11 (32 bit)unixODBC-devel-2.2.11unixODBC-devel-2.2.11 (32 bit)Removing an 11g DatabaseUse the following SQL script if you wish to remove just the 11g database. If you wish to remove both database and binaries, then use the deinstall tool, details of whcih can be foundhere.Shutdown the database and run the following SQL script logged ontoASMalter diskgroup DATA drop file '+DATA/SID/system_01.dbf';alter diskgroup DATA drop file '+DATA/SID/sysaux_01.dbf';alter diskgroup DATA drop file '+DATA/SID/redo001a.dbf'alter diskgroup DATA drop file '+DATA/SID/redo002a.dbf';alter diskgroup DATA drop file '+DATA/SID/redo003a.dbf';alter diskgroup DATA drop file '+DATA/SID/redo004a.dbf';alter diskgroup FRA drop file '+FRA/SID/redo001a.dbf'alter diskgroup FRA drop file '+FRA/SID/redo002a.dbf';alter diskgroup FRA drop file '+FRA/SID/redo003a.dbf';alter diskgroup FRA drop file '+FRA/SID/redo004a.dbf';alter diskgroup DATA drop file '+DATA/SID/temp_01.dbf';alter diskgroup DATA drop file '+DATA/SID/undo_01.dbf';alter diskgroup DATA drop file '+DATA/SID/control01.ctl';alter diskgroup DATA drop file '+DATA/SID/control02.ctl';alter diskgroup DATA drop file '+DATA/SID/control03.ctl';alter diskgroup FRA drop file '+FRA/SID/control01.ctl';alter diskgroup FRA drop file '+FRA/SID/control02.ctl';alter diskgroup FRA drop file '+FRA/SID/control03.ctl';Deinstalling Oracle 11g Binaries and DatabaseWith11.2the Oracle Universal Installer no longer removes Oracle software. Use the new deinstallation tool calleddeinstallavailable on the installation media before installation as well as in the Oracle home directory after installation.Step-by-Step1. Run this tool fromORACLE_HOMEfirst. cd $ORACLE_HOME/deinstall ./deinstall When prompted for the database name enter the *SID* you want to remove. NBThis will remove the database binaries too. When askedDo you still want to modify the details of SID database(s)? [n]:AnswerN NBYou would answerYif you wanted to amend the database configuration. The tool should now complete okay after performing several tasks. Seeexample outputbelow.NOTESAn error will occur if there are any missingdeinstallfiles at which point the tool prompts you to download the standalone version available in the deinstall directory on the installation mediaExample OutputThe following output is example output for removing a standalone database and the related binaries.oracle@myhost.mydomain.com:> ./deinstallChecking for required files and bootstrapping Please wait Location of logs /u01/app/oracle/oraInventory/logs/############ ORACLE DEINSTALL & DECONFIG TOOL START #################################### CHECK OPERATION START ########################Install check configuration STARTChecking for existence of the Oracle home location /u01/app/oracle/SID/product/11.2.0Oracle Home type selected for de-install is: SIDBOracle Base selected for de-install is: /u01/app/oracleChecking for existence of central inventory location /u01/app/oracle/oraInventoryInstall check configuration ENDNetwork Configuration check config STARTNetwork de-configuration trace file location: /u01/app/oracle/oraInventory/logs/netdc_check627197374662265908.logNetwork Configuration check config ENDDatabase Check Configuration STARTDatabase de-configuration trace file location: /u01/app/oracle/oraInventory/logs/databasedc_check6468731932053553666.logUse comma as separator when specifying list of values as inputSpecify the list of database names that are configured in this Oracle home [SID]:SID###### For Database 'SID' ######Single Instance DatabaseThe diagnostic destination location of the database: /u01/app/oracle/SID/admin/SID/trace/diag/rdbms/SIDStorage type used by the Database: FSDatabase file location: /u03/oradata/SID/users/d1,/u03/oradata/SID/tools/d1,/u03/oradata/SID/indx/d1,/u03/oradata/SID/system/d1,/u03/oradata/SID/sysaux/d1,/u04/oradata/SID/undo/d1Flash recovery area location: /u10/oradata/SID/flash/d1/SIDdatabase spfile location: /u01/app/oracle/SID/product/11.2.0/dbs/spfileSID.oraThe details of database(s)SIDhave been discovered automatically. Do you still want to modify the details ofSIDdatabase(s)? [n]:Database Check Configuration ENDEnterprise Manager Configuration Assistant STARTEMCA de-configuration trace file location: /u01/app/oracle/oraInventory/logs/emcadc_check.logChecking configuration for databaseSIDEnterprise Manager Configuration Assistant ENDOracle Configuration Manager check STARTOCM check log file location : /u01/app/oracle/oraInventory/logs//ocm_check3867.logOracle Configuration Manager check END######################### CHECK OPERATION END ################################################ CHECK OPERATION SUMMARY #######################Oracle Home selected for de-install is: /u01/app/oracle/SID/product/11.2.0Inventory Location where the Oracle home registered is: /u01/app/oracle/oraInventoryThe following databases were selected for de-configuration :SIDDatabase unique name :SIDStorage used : FSNo Enterprise Manager configuration to be updated for any database(s)No Enterprise Manager ASM targets to updateNo Enterprise Manager listener targets to migrateChecking the config status for CCROracle Home exists with CCR directory, but CCR is not configuredCCR check is finishedDo you want to continue (y - yes, n - no)? [n]: yA log of this session will be written to: '/u01/app/oracle/oraInventory/logs/deinstall_deconfig2009-11-03_10-45-31-AM.out'Any error messages from this session will be written to: '/u01/app/oracle/oraInventory/logs/deinstall_deconfig2009-11-03_10-45-31-AM.err'######################## CLEAN OPERATION START ########################Enterprise Manager Configuration Assistant STARTEMCA de-configuration trace file location: /u01/app/oracle/oraInventory/logs/emcadc_clean.logUpdating Enterprise Manager ASM targets (if any)Updating Enterprise Manager listener targets (if any)Enterprise Manager Configuration Assistant ENDDatabase de-configuration trace file location: /u01/app/oracle/oraInventory/logs/databasedc_clean6686076943326692780.logDatabase Clean Configuration STARTSIDThis operation may take few minutes.Database Clean Configuration ENDSIDNetwork Configuration clean config STARTNetwork de-configuration trace file location: /u01/app/oracle/oraInventory/logs/netdc_clean7861096860567065254.logDe-configuring Local Net Service Names configuration fileLocal Net Service Names configuration file de-configured successfully.De-configuring backup filesBackup files de-configured successfully.The network configuration has been cleaned up successfully.Network Configuration clean config ENDOracle Configuration Manager clean STARTOCM clean log file location : /u01/app/oracle/oraInventory/logs//ocm_clean3867.logOracle Configuration Manager clean ENDOracle Universal Installer clean STARTDetach Oracle home '/u01/app/oracle/SID/product/11.2.0' from the central inventory on the local node : DoneDelete directory '/u01/app/oracle/SID/product/11.2.0' on the local node : DoneThe Oracle Base directory '/u01/app/oracle' will not be removed on local node. The directory is in use by Oracle Home '/u01/app/oracle/agent10g'.The Oracle Base directory '/u01/app/oracle' will not be removed on local node. The directory is in use by central inventory.Oracle Universal Installer cleanup was successful.Oracle Universal Installer clean ENDOracle install clean STARTClean install operation removing temporary directory '/tmp/install' on node 'myhost'Oracle install clean END######################### CLEAN OPERATION END ################################################ CLEAN OPERATION SUMMARY #######################Successfully de-configured the following database instances :SIDCleaning the config for CCRAs CCR is not configured, so skipping the cleaning of CCR configurationCCR clean is finishedSuccessfully detached Oracle home '/u01/app/oracle/SID/product/11.2.0' from the central inventory on the local node.Successfully deleted directory '/u01/app/oracle/SID/product/11.2.0' on the local node.Oracle Universal Installer cleanup was successful.Oracle install successfully cleaned up the temporary directories.#################################################################################### ORACLE DEINSTALL & DECONFIG TOOL END #############