| Oracle Version | 11.2 | 11.1 | 10.2 | 10.1 | 9.2.0 | 9.0.1 | 8.1.7 | 8.1.6 | 8.1.5 | 8.0.6 | 8.0.5 |
| Linux x86 OS | o RHEL4,OEL4 - Update 7 or greater which is Kernel 2.6.9-78 or newer o RHEL5, OEL5 - 5.2 or greater which is Kernel 2.6.18-92 or newer o SLES10 - Kernel 2.6.16.21 or higher o SLES 11 - Kernel 2.6.27.19-5 or greater o Asianux Server 3 SP2 | o RHEL4, OEL4, Asianux 2.0 2.6.9 o RHEL5, OEL5, Asianux Server 3 2.6.18 o SuSE SLES10 2.6.16.21 o SuSE SLES11 - Kernel 2.6.27.19-5 or greater | o RHEL 3 AS/ES ( RHEL3 ) (Update 4 or later) 2.4.21-27.EL or higher o RHEL 4 AS/ES ( RHEL4 ) and Oracle Enterprise Linux 4 ( OEL4 ) 2.6.9-5.0.5.EL or higher o RHEL 5 AS/ES ( RHEL5 ) and Oracle Enterprise Linux 5 ( OEL5 ) o SuSE SLES9 2.6.5-7.201 or higher o SuSE SLES10 o SuSE SLES11 - Kernel 2.6.27.19-5 or greater o Asianux 1.0 2.4.21-27.EL or higher o Asianux 2.0 2.6.9-5.0.5.EL or higher | o RHEL AS/ES 2.1 (Update 3 or higher) 2.4.9-e34 or higher o RHEL AS/ES 3.0 (Update 2 or higher) 2.4.21-15.EL or higher o RHEL4 (10.1.0.3.0 patchset required) o SuSE SLES8 (Service Pack 3 or higher) 2.4.21-138 o SuSE SLES9 2.6.5-7.5 o Red Flag Advanced Server 4.0 (China only) o Miracle Linux Std Ed 2.1 (Japan only) o Asianux 1.0 | o Red Hat Enterprise AS/ES 2.1 2.4.9-e34 or higher o Red Hat Enterprise AS/ES 3.0 2.4.21-15 o RHEL4 (9.2.0.6.0 patchset required or 9.2.0.5.0 patchset and Patch 4276910 required) o SuSE SLES8 2.4.21-138 o SuSE SLES9 2.6.5-7.97 o United Linux 1.0 (SP3 or higher) o Red Flag DC Server 4.0 (China and Hong Kong only) o Monta Vista Carrier Grade Linux 3.0 (embedded) o Miracle Linux Std Ed 2.1 (Japan only) 2.4.7 o Asianux 1.0 | Caldera OU8+LKP, Red Hat 7.1, Advanced Server 2.1, SuSE 7.1, 7.2, SLES7, Kernel 2.4.4 | Caldera OU8+LKP, Miracle 1.0, 2.0, Red Hat 6.1,6.2, EE 6.2, 7.0, 7.1, Advanced Server 2.1, SuSE 7.0, 7.1, 7.2, SLES7, Kernel 2.2.16 | Miracle 1.0, Red Hat 6.0,6.1,6.2, EE 6.2, SuSE 6.3, 6.4, 7.0, VA 6.2, Kernel 2.2 | Red Hat 6.2, EE 6.2, SuSE 6.3, 6.4, Kernel 2.2 | Red Hat 6.2, SuSE 6.4, 7.0, Kernel 2.0.34 | 2.0.34 |
| Linux x86 Disk Space | 3.8G Database | 2G Database 3.5G Install | 1.2G Database 1.5 to 3.5G Install | 1.2G Database 1.5G Software 1G Companion 150M-650M Client | 4.5G | 3.5G | 900Mb | 1G | 811Mb | 400Mb | 400Mb |
| Linux x86 RAM | 1GB | 1GB | 1GB | 512Mb 256Mb(Client/Compan) | 512Mb | 512Mb | 128Mb | 128Mb | 128Mb | 32Mb | 32Mb |
| Linux x86 swap | If RAM=1 GB to 2 GB then 1.5 times RAM If RAM=2 GB to 16 GB then equal to RAM If greater than 16 GB then 16 GB | If RAM between 1 GB and 2 GB then 1.5 times RAM elseif RAM between 2 GB and 16 GB then match RAM else RAM > 16 GB then 16 GB | If RAM = 1024MB to 2048Mb then 1.5 times RAM elseif RAM > 2048MB and < 8192MB then match RAM else RAM > 8192MB then .75 times RAM | 1Gb or match RAM 512Mb(Client/Compan) | 1Gb or match RAM | 512Mb | 400Mb | 400Mb | 256Mb | 3*RAM | 3*RAM |
| Linux x86 tmp | 1024Mb | 400Mb | 400Mb | 400Mb | 400Mb | 400Mb | 75Mb | 75Mb | 75Mb | 75Mb | 20Mb |
| Linux x86 JDK & JRE | JDK (version TBS) is installed | JDK (version TBS) is installed | JDK 1.4.2_08 is installed | JDK 1.4.2_02 is installed | Sun JDK 1.3.1_02 & Blackdown 1.1.8_v3 | Blackdown JDK 1.1.8_3 & 1.1.8_v3 | JDK 1.2.2. & 1.1.8-3from IBM | 1.1.8 | 1.1.6v5 | n/a | n/a |
| Linux x86 Patches/ Packages | REHEL4, OEL4: SLES10: SLES11: | Asianux 2.0,OEL4,RHEL4: * default OS installedAsianux Server 3,OEL5,RHEL5: (required by elfutils-libelf-devel) (required by glibc-devel) (required by gcc) * default OS installedSLES10: (required by sysstat) (requried by sysstat) (required by sysstat) * default OS installed | RHEL3: default RPMS RHEL4: binutils-2.15.92.0.2-10.EL4 The dependent packages are: gcc-4.1.1-52.el5.i386.rpm libstdc++-devel-4.1.1-52.el5.i386.rpm glibc-devel-2.5-12.i386.rpm glibc-headers-2.5-12.i386.rpm libgomp-4.1.1-52.el5.i386.rpm | RHEL ES/AS 2.1: set LD_ASSUME_KERNEL=2.4.19RHEL4: Patch 4153257 required for installer to work Requires 10.1.0.3 Full Release (CD Release) Requires 10.1.0.3 Full Release (CD Release) | RHEL ES/AS 2.1: default-RPMs Additional steps: for additional setup requirements for RHEL3 and 9.2 x86 for Async I/O functionality to work you need to install Patch 3016968 on top of 9.2.0.3.0 or 9.2.0.4.0 or Patch 3208258 on top of 9.2.0.5.0 or 9.2.0.6.0RHEL4: compat-db-4.1.25-9 Set LD_ASSUME_KERNEL=2.4.19 Post install you need to apply Patch 4190568 on top of the 9.2.0.6 patchset SuSE SLES8: SuSE SLES9: glibc-2.3.3 Additional steps for SLES9 for 9.2 32bit x86: Install 9.2.0.4 (Complete release) and then apply 9.2.0.5 and 9.2.0.5 one-off Patch 3809563 or 9.2.0.6 patchset If using Bourne, Bash, or Korn shell: ( /usr/lib/libInternalSymbols.so can be obtained from the orarun package ) ORACLE_BASE= ; export ORACLE_BASE LD_ASSUME_KERNEL=2.4.21; export LD_ASSUME_KERNEL LD_PRELOAD=/usr/lib/libInternalSymbols.so ; export LD_PRELOAD for Async I/O functionality to work you need to install Patch 3208258 on top of 9.2.0.5.0 or 9.2.0.6.0 | make-3.79, and binutils-2.10. | GLIBC package version 2.1.3 or higher | GLIBC package version 2.1 | GNU C Library, version 2.0.6 GLIBC package version 2.1 | GNU C Library, version 2.0.7 TCL library (libtcl.so), version 8.0.2-16 | GNU C Library, version 2.0.7 TCL library (libtcl.so), version 8.0.2-16 |
| Linux x86 Kernel Settings | kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 6815744 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 | SEMMSL 250 SEMMNS 32000 SEMMNI 128 SEMOPM 100 SHMMAX RAM times 0.5 but not greater then 4Gb SHMMNI 4096 SHMALL = SHMMAX/pagesize FILE-MAX =6815744 IP_LOCAL_PORT_RANGE 9000 65500 RMEM_DEFAULT 262144 RMEM_MAX 4194304 WMEM_DEFAULT 262144 WMEM_MAX 1048576 | SuSE SLES9: SEMMSL 250 SEMMNS 32000 SEMMNI 128 SEMOPM 100 SHMMAX RAM times 0.5 but not greater then 4Gb SHMMNI 4096 SHMALL = SHMMAX/pagesize FILE-MAX 65536 IP_LOCAL_PORT_RANGE 9000 65500 RMEM_DEFAULT 262144 RMEM_MAX 2097152 WMEM_DEFAULT 262144 WMEM_MAX 262144 Other Linux OS: SEMMSL 250 SEMMNS 32000 SEMMNI 128 SEMOPM 100 SHMMAX RAM times 0.5 but nor greater then 4Gb SHMMNI 4096 SHMALL = SHMMAX/pagesize FILE-MAX 65536 IP_LOCAL_PORT_RANGE 9000 65500 RMEM_DEFAULT 262144 RMEM_MAX 2097152 WMEM_DEFAULT 262144 WMEM_MAX 262144 | SEMMSL 250 SEMMNS 32000 SEMMNI 128 SEMOPM 100 SEMVMX 32767 SHMMAX 2147483648 One-half the size of your system's physical memory. Check your system for additional restrictions. SHMMNI 4096 SHMALL = SHMMAX/pagesize FILE-MAX 65536 IP_LOCAL_PORT_RANGE 9000 65500 | SEMMNI 100 SEMMNS 256 SEMMSL 100 SEMOPM 100 SEMVMX 32767 SHMMAX 2147483648 One-half the size of your system's physical memory. Check your system for additional restrictions. SHMMIN 1 SHMMNI 4096 SHMSEG 4096 | SEMMNI 100 SEMMNS 256 SEMMSL 100 SEMOPM 100 SEMVMX 32767 SHMMAX 2147483648 One-half the size of your system's physical memory. Check your system for additional restrictions. SHMMIN 1 SHMMNI 4096 SHMSEG 4096 | SHMMAX 0.5*(physical memory present in machine) but not greater then 4Gb SHMMIN 1 SHMMNI 100 SHMSEG 10 SEMMNI 100 SEMMSL Set to 10 plus the largest PROCESSES parameter of any Oracle database on the system. SEMMNS Set to the sum of the PROCESSES parameter for each Oracle database, adding the largest one twice, then add an additional 10 for each database. SEMOPM 100 SEMVMX 32767 | SHMMAX 0.5*(physical memory present in machine) but not greater then 4Gb SHMMIN 1 SHMMNI 100 SHMSEG 10 SEMMNI 100 SEMMSL Set to 10 plus the largest PROCESSES parameter of any Oracle database on the system. SEMMNS Set to the sum of the PROCESSES parameter for each Oracle database, adding the largest one twice, then add an additional 10 for each database. SEMOPM 100 SEMVMX 32767 | SHMMAX 0.5 *(physical memory present in machine) but not greater then 4Gb SHMMIN 1 SHMMNI 100 SHMSEG 10 SEMMNI 100 SEMMSL Set to 10 plus the largest initsid.ora PROCESSES parameter of an Oracle database on the system. SEMMNS Set to the sum of the PROCESSES parameter for each Oracle database except the largest one, plus 2 times the largest PROCESSES value, plus 10 times the number of Oracle databases. SEMOPM 100 SEMVMX 32767 | SHMMAX (1/4 of RAM) but not greater then 4Gb SHMMIN 1 SHMMNI 100 SHMSEG 10 SEMMNS 200 SEMMNI 70 SEMMSL Equal to or greater than the value of the PROCESSES initialization parameter. | SHMMAX (1/4 of RAM) but not greater then 4Gb SHMMIN 1 SHMMNI 100 SHMSEG 10 SEMMNS 200 SEMMNI 70 SEMMSL Equal to or greater thanthe value of the PROCESSES initialization parameter. |
Saturday, February 12, 2011
Prerequisites for Oracle Database Installation on Linux x86
Prerequisites for Oracle Database Installation on Sun Solaris
| Oracle Version | 11.2 | 11.1 | 10.2 | 10.1 | 9.2.0 | 9.0.1 | 8.1.7 | 8.1.6 | 8.1.5 | 8.0.6 | 8.0.5 |
| Sun Solaris (32- and 64-bit stands for Oracle not OS) | Solaris(64bit) 10 (update 6 or higher) | 2.9 Update 7 (09/04), 2.10 |
| Solaris SPARC 2.8, 2.9 (64bit) o Solaris SPARC 10 (64bit) requires 10.1.0.3.0 patchset o Solaris x86 2.9, 10 | o 2.6, 2.7, 2.8, 2.9 (32bit) o Solaris 10 (32bit) requires 9.2.0.4.0 patchset o 2.8, 2.9 (64bit) o Solaris 10 (64bit) requires 9.2.0.5.0 patchset | o 2.6, 2.7, 2.8, 2.9 (32bit) o 2.8, 2.9 (64bit) | o 2.6, 2.7, 2.8, 2.9 (32bit) o 2.8, 2.9 (64bit) | o 2.6, 2.7, 2.8 (32bit) o 2.7, 2.8 (64bit) | 2.6, 2.7, 2.8 (32bit) o 2.7 (64bit) | 2.5.1, 2.6, 2.7, 2.8 | 2.5.1, 2.6, 2.7, 2.8 |
| Sun Disk Space | 1.5 to 2G Database 4.7G Software | 1.5 to 2G Database 4.7G Software | 1.2G Database 1.5G - 3.5G Software 1G Companion 150M-1G Client | 1.2G Database 1.5G Software 1G Companion 150M-1G Client | 4.5G | 3.5G (32bit) 5.7G (64bit) | 1355Mb | 1170Mb | 811Mb | 600Mb | 600Mb |
| Sun RAM | 4GB | 1GB | 1GB | 512Mb 256Mb(Client/Compan) | 512Mb | 256Mb (32bit) 512Mb (64bit) | 128Mb | 128Mb | 128Mb | 64Mb or 128Mb / ConText | 32Mb or 128Mb / ConText |
| Sun swap | If RAM = 1 GB to 2 GB then 1.5 times RAM elseif RAM = 2 GB and 16 GB then match RAM else RAM > 16 GB then .75 times RAM | If RAM = 1024MB to 2048Mb then 1.5 times RAM elseif RAM > 2048MB and < 8192MB then match RAM else RAM > 8192MB then .75 times RAM | If RAM = 1024MB to 2048Mb then 1.5 times RAM elseif RAM > 2048MB and < 8192MB then match RAM else RAM > 8192MB then .75 times RAM | 1Gb or match RAM 512Mb(Client/Compan) | 1Gb or match RAM | 400Mb | 2*RAM or 400Mb | 2*RAM or 400Mb | 2*RAM | 3*RAM | 3*RAM |
| Sun tmp | 1GB | 275Mb | 400Mb | 400Mb | 400Mb | 400Mb | ? | ? | ? | 20Mb | 20Mb |
| Sun JDK & JRE | JDK 6 Update 10 (Java SE Development Kit 1.6 u10) or JDK 5 (1.5.0_16) | JDK 1.5.0_11 is installed | JDK 1.4.2_01 is installed JDK 1.4.2_08 is installed (x86_64) | JDK 1.4.2_01 is installed | JDK 1.3.1_02 & 1.1.8_12 (32bit) 1.1.8_15 (64bit) | JDK 1.2.2_07 & 1.1.8_12 | JDK 1.2.2. & 1.1.8_10 | 1.1.8_10 | ? | n/a | n/a |
| Sun Patches/ Packages | Required Packages: SUNWarc SUNWbtool sunwhea SUNWlibC SUNWlibm SUNWlibms SUNWsprot SUNWtoo SUNWi1of SUNWi1cs (ISO8859-1) SUNWi15cs (ISO8859-15) SUNWxwfnt SUNWcsl | Important: For non-sun4u or sun4v workstations Only, set the following before starting the OUI,DBCA, or DBUA: $ export JAVA64FLAG="-d64" Required Packages: SUNWarc SUNWbtool SUNWhea SUNWi15cs SUNWi1cs SUNWi1of SUNWlibC SUNWlibm SUNWlibms SUNWsprot SUNWsprox (Not applicable to Solaris 10), SUNWtoo SUNWxwfnt SUNWuiu8 SUNWulcf Solaris 9 Reqd Patches: 112233-11 111722-04 112874-39 115675-01 (NUMA only) 113471-08 (NUMA only) 115675-01 (NUMA only) 113029-07 Solaris 10 Reqd Patches: 127111-02 s/b 127127-11 137111-04 s/b 137137-09 (Part Number B32314-02) To support Pro*C/C++,Pro*FORTRAN,Oracle Call Interface,Oracle C++ Call Interface,Oracle XML Developer's Kit (XDK) 112760-05 (Solaris 9) 117837-05 (Solaris X86 10) 117846-08 (Solaris X86 10) 118682-01 (Solaris X86 10) ulimit(TIME) to unlimited. ulimit(FILE) to unlimited. ulimit(DATA) to a minimum of 1048576. ulimit(STACK) to a minimum of 32768. ulimit(NOFILES) to a minimum of 4096. ulimit(VMEMORY) to a minimum of 4194304. | Required Packages: SUNWarc, SUNWbtool, SUNWhea, SUNWlibm, SUNWlibms, SUNWmfrun, SUNWsprot, SUNWsprox (Not applicable to Solaris 10), SUNWtoo, SUNWxwfnt, SUNWi1cs, SUNWi15cs, SUNWi1of, SUNWxcu4, SUNWuiu8 and SUNWulcf Solaris 8 Reqd Patches: 108528-23 108652-66 108773-18 108921-16 108940-53 108987-13 108989-02 108993-45 109147-24 110386-03 111023-02 111111-03 111308-03 111310-01 112396-02 111721-04 112003-03 112138-01 112760-05 (Native PL/SQL,ProC,ProFortran,OCI,OCCI,XDK only) SUNWctplx/ SUNWdtbax/ SUNWtltkx/ SUNWtoox/ SUNWxwicx/ SUNWxwplx/ and also Patch 112771-30 in order to fix the SUNWdtbax package Solaris 9 Reqd Patches: 112233-11 111722-04 (Bug 4122475) 115675-01 113471-08 115675-01 112760-05 (Native PL/SQL,ProC,ProFortran,OCI,OCCI,XDK only) 112963-25 113029-07 for Fair Scheduler Solaris 10 Reqd Patches 127111-02 s/b 127127-11 for 10.2.0.4 or later (see README for 10.2.0.4.0) 127111-03 s/b 127127-11 Solaris 10 x86_64 Reqd Patches: 118345-03 119961-01 127127-11 Solaris 10 special instructions: Select 'Do not create a starter database' when installing Oracle 10gR2 due to Bug 4884705 and run the DBCA after the installation. The Fair Share Scheduler(FSS) requires Solaris 10 11/06 or higher. If using a prior update of Solaris 10 install the following patches : Install patch 118833-36 before installing Oracle 10gR2 for Solaris 10 on SPARC. Install patch 118855-36 before installing Oracle 10gR2 for Solaris 10 on x86-64 IMPORTANT: Patch 4589082 needs to be installed prior to attempting an installation of 10.2 on Solaris 10 SPARC to avoid "Error in invoking target 'relink' of makefile 'precomp/lib/ins_precomp.mk' related to -ldce not found. See also | Required Packages: SUNWarc, SUNWbtool, SUNWhea, SUNWlibC (CRS only) SUNWlibm, SUNWlibms, SUNWmfrun, SUNWsprot, SUNWsprox (Not applicable to Solaris 10), SUNWtoo, SUNWxwfnt, SUNWi1cs, SUNWi15cs, SUNWi1of SUNWuiu8,SUNWulcf SUNWxcu4Solaris 8 Reqd Patches: 108528-23 108652-66 108773-18 108921-16 108940-53 108987-13 108989-02 108993-18 109147-24 110386-03 111023-02 111111-03 111308-03 111310-01 112396-02 111721-04 112003-03 112138-01 Solaris 9 Reqd Patches: 112233-11 111722-04 (Bug 4122475) 112963-25 113029-07 for Fair Scheduler, Solaris 10 special instructions: 1. Execute runInstaller with the -ignoreSysPrereqs option. 2. Select 'Do not create a starter database' when installing Oracle 10g. 3. During installation, the warning message 'SUNWsprox package not installed' can be ignored as it is no longer provided separately. Press Continue to resume the installation. 4. Download and install PSR 10.1.0.4 Patch 4163362(or apply PSR 10.1.0.3 Patch 3761843 and interim Patch 4163208(SPARC) or patch 4186426 (x86) from metalink.oracle.com. 5. Download and install Patch 4365826 from 10.1.0.3 or 10.1.0.4 from metalink.oracle.com. (SPARC only), also a merge patch containing 4365826 can be applied to 10.1.0.4.2 Patch 4590858 6. If you have an End User Solaris 10 distribution, install the SUNWuiu8 package prior to installing the 10g client. 7. The Fair Share Scheduler(FSS) requires Solaris 10 11/06 or higher. If using a prior update of Solaris 10 install the following patches : Install patch 118833-36 before installing Oracle 10gR2 for Solaris 10 on SPARC. Install patch 118855-36 before installing Oracle 10gR2 for Solaris 10 on x86-64 8. Sun Solaris 10 install Sun patch 127111-03 (SPARC) / 127127-11 (x86-64) | 32bit/64bit SUNWarc, SUNWbtool, SUNWhea, SUNWlibm, SUNWlibms, SUNWmfrun, SUNWsprot, SUNWtoo SUNWi1of and SUNWxwfnt (for Java) SUNWsprox (for 64bit Oracle) (Not applicable to Solaris 10) SUNWuiu8,SUNWulcf (if Bug 4025250occurs) SUNWxcu4108528-05 (2.8) Solaris 10 special instructions: Execute runInstaller with the -ignoreSysPrereqs option The Fair Share Scheduler(FSS) requires Solaris 10 11/06 or higher. If using a prior update of Solaris 10 install the following patches : Install patch 118833-36 before installing Oracle 10gR2 for Solaris 10 on SPARC. Install patch 118855-36 before installing Oracle 10gR2 for Solaris 10 on x86-64 Sun Solaris 10 install Sun patch 127111-03 (SPARC) / 127127-11 (x86-64) | 32bit/64bit SUNWarc, SUNWbtool, SUNWhea, SUNWlibm, SUNWlibms, SUNWsprot, SUNWtoo SUNWxcu4Additional 64bit SUNWarcx, SUNW2x (believe this is a typo and should be SUNWtoox) 108528-01 (2.8) 105181-15 (2.6) | SUNWarc, SUNWbtool, SUNWhea, SUNWlibm, SUNWlibms, SUNWsprot, SUNWtoo SUNWxcu42.6 requires at least 105181-15 | SUNWarc, SUNWbtool, SUNWhea, SUNWlibm, SUNWlibms, SUNWsprot, SUNWtoo2.6 requires at least 105181-15 | SUNWarc, SUNWbtool, SUNWlibm, SUNWlibms,SUNWsprot, SUNWtoo, SUNWhea.Sun 2.6 requires 105181-06 | ||
| Sun Kernel Settings | Refer to the 11g Solaris Install Guide. Part Number E17163-01 for steps to do this. Verifying UDP and TCP Kernel Parameters | SEMMNI 100 SEMMNS 1024(Obsolete) SEMMSL 256 SEMVMX 32767(Obsolete) SHMMAX 4294967295 SHMMNI 100 (Obsolete) NOEXEC_USER_STACK 1 Note: For Solaris 10 Oracle recommends still setting all these values in the /etc/system file, as well as, the Resource Control Facility. Refer to the 11g Solaris Install Guide for steps to do this.Here are the new names of the kernel parameters for Solaris 10 (Solaris 9 equivalents are in parentheses): | SEMMNI 100 *** SEMMNS 1024 ** SEMMSL 256 *** SEMVMX 32767 ** SHMMAX 4294967295 SHMMIN 1 * SHMMNI 100*** SHMSEG 10 * NOEXEC_USER_STACK 1 * obsolete in Solaris 9 and 10 ** obsolete in Solaris 10 *** default value in Solaris 10 is already larger Note: for Solaris 10 SHMMAX which is now set through the Resource Control Facility not /etc/system. Refer to the 10gR2 for Solaris SPARC Installation guide for steps to do this, as well as, the Release Notes which has corrections: 10.2 Install Guides and Release NotesHere are the new names of the kernel parameters for Solaris 10 (Solaris 9 equivalents are in parentheses): | SEMMNI 100 *** SEMMNS 1024 ** SEMMSL 256 *** SEMVMX 32767 ** SHMMAX 4294967295 SHMMIN 1 * SHMMNI 100*** SHMSEG 10 * NOEXEC_USER_STACK 1 * obsolete in Solaris 9 and 10 ** obsolete in Solaris 10 *** default value in Solaris 10 is already larger | SEMMNI 100 *** SEMMNS 1024 ** SEMMSL 256 *** SHMMAX 4294967295 SHMMIN 1 * SHMMNI 100*** SHMSEG 10 * NOEXEC_USER_STACK 1 * obsolete in Solaris 9 and 10 ** obsolete in Solaris 10 *** default value in Solaris 10 is already larger | SEMMNI 100 SEMMNS 256 SEMMSL 256 SHMMAX 4294967295 SHMMIN 1 SHMMNI 100 SHMSEG 10 | SHMMAX 4294967295 SHMMIN 1 SHMMNI 100 SHMSEG 10 SEMMNI 100 SEMMSL Set to 10 plus the largest PROCESSES parameter of any Oracle database on the system. SEMMNS Set to the sum of the PROCESSES parameter for each Oracle database, adding the largest one twice, then add an additional 10 for each database. SEMOPM 100 SEMVMX 32767 | SHMMAX 4294967295 SHMMIN 1 SHMMNI 100 SHMSEG 10 SEMMNI 100 SEMMSL Set to 10 plus the largest PROCESSES parameter of any Oracle database on the system. SEMMNS Set to the sum of the PROCESSES parameter for each Oracle database, adding the largest one twice, then add an additional 10 for each database. SEMOPM 100 SEMVMX 32767 | SHMMAX 0.5*(physical memory present in machine) SHMMIN 1 SHMMNI 100 SHMSEG 10 SEMMNI 100 SEMMSL Set to 10 plus the largest initsid.ora PROCESSES parameter of an Oracle database on the system. SEMMNS Set to the sum of the PROCESSES parameter for each Oracle database except the largest one, plus 2 times the largest PROCESSES value, plus 10 times the number of Oracle databases. SEMOPM 100 SEMVMX 32767 | SHMMAX 4294967295 SHMMIN 1 SHMMNI 100 SHMSEG 10 SEMMNS 200 SEMMNI 70 SEMMSL Equal to or greater than the value of the PROCESSES initialization parameter. | SHMMAX 4294967295 SHMMIN 1 SHMMNI 100 SHMSEG 10 SEMMNS 200 SEMMNI 70 SEMMSL Equal to or greater than the value of the PROCESSES initialization parameter. |
Friday, February 11, 2011
Oracle Database Installation on AIX Requirements
| Oracle Version | 11.2 | 11.1 | 10.2 | 10.1 | 9.2.0 | 9.0.1 | 8.1.7 | 8.1.6 | 8.1.5 | 8.0.6 | 8.0.5 |
| AIX OS (32- and 64-bit stands for Oracle not OS) | AIX 5L V5.3 TL 09 SP1 ("5300-09-01"), 64 bit kernel (Oracle documentation E10854-01), AIX 6.1 TL 02 SP5 ("6100-02-05"), 64-bit kernel | AIX 6.1L, AIX 5L version 5.3, TL 05, Service Pack 06 (Oracle documentation B32076-07), AIX 6L version 6.1, TL 00, Service Pack 04 or later (Oracle documentation B32076-03) | 5.2 ML4 or higher, 5.3 ML2 or higher, 6.1, 10.2.0.4.0 & above AIX 5.3 TL5 (5300-05) | 5.2 ML1 or higher, 5.3 | o 4.3.3 (64bit only) o 5.1, 5.2, 5.3 (5L)(64bit only) | 4.3.3 (64bit) | o 4.3.2, 4.3.3 (32bit) o 5.1, 5.2, 5.3 (5L) (32bit) [patch 2896876is required if kernel is running in 64bit mode] o 4.3.2, 4.3.3 (64bit) | 4.3.2, 4.3.3 (32 or 64bit) | o 4.2.1 , 4.3.0, 4.3.1, 4.3.2, 4.3.3 (32bit) o 4.3.2, 4.3.3 (64bit) | o 4.2.1, 4.3.2, 4.3.3 (32bit) o 4.3.2, 4.3.3 (64bit) | o 4.1.4, 4.1.5, 4.2.1, 4.3.2, 4.3.3 (32bit) o 4.3.2, 4.3.3 (64bit) |
| AIX Disk Space | 6.40G Database 1.55G Software | 6.45G Database 1.6G Software | 1.2G Database 3G Software 1G Companion 150M-1.9G Client | 1.2G Database 3G Software 1G Companion 150M-1.9G Client | 4.5G | 4.7G | 1.58G | 800Mb | 800Mb | 700Mb | 700Mb |
| AIX RAM | 4GB | 1GB | 1GB | 512Mb 256Mb(Client/Compan) | 512Mb | 512Mb | 256Mb | 128Mb | 128Mb | 64Mb or 128Mb / ConText | 32Mb or 128Mb / ConText |
| AIX swap | Between 1GB and 2GB then 1.5 times RAM Between 2GB and 16 GB then match RAM More than 16 GB then 16GB RAM | If RAM = 1024MB to 2048Mb then 1.5 times RAM elseif RAM > 2048MB and < 8192MB then match RAM else RAM > 8192MB then .75 times RAM | If RAM = 1024MB to 2048Mb then 1.5 times RAM elseif RAM > 2048MB and < 8192MB then match RAM else RAM > 8192MB then .75 times RAM | 1Gb or match RAM 512Mb(Client/Compan) | 1Gb or match RAM | 400Mb | 400Mb | 400Mb | 256Mb | 2*RAM | 2*RAM |
| AIX tmp | 1GB | 240Mb | 400Mb | 400Mb | 400Mb | 400Mb | 400Mb | 400Mb | 50Mb | 20Mb | 20Mb |
| AIX JDK & JRE | IBM JDK 1.6.0.00 (64 BIT) | IBM JDK 1.5.0.06 (IA64 - mixed mode) is installed | IBM JDK 1.4.2 (32bit) is installed | IBM JDK 1.4.1.2 (32bit) is installed | JDK 1.3.1-build 20020316 & 1.1.8-Build 20020313 | JDK 1.2.2.04 or JDK 1.2.2 & 1.1.8 | JDK 1.1.8 / 1.2.2 & 1.1.8.3 | 1.1.8.3 | ? | n/a | n/a |
| AIX Patches/ Packages versions in parens mean if OS is later than the listed version, the APAR is built into the later OS version and need not be applied. | AIX 6.1 /5.3 required packages: bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat 5.3.9.0 or later (AIX 5.3) bos.perf.libperfstat 6.1.2.1 or later (AIX 6.1) bos.perf.perfstat bos.perf.proctools rsct.basic.rte rsct.compat.clients.rte xlC.aix50.rte:10.1.0.0 or later (AIX 5.3) xlC.aix61.rte:10.1.0.0 or later (AIX 6.1) gpfs.base 3.2.1.8 or later (Only for RAC)Authorized Problem Analysis Reports (APARs) for AIX 5L: IZ42940 IZ49516 IZ52331 | 6.1 / 5.3 ML5 required packages: bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat bos.perf.perfstat bos.perf.proctools xlC.aix50.rte:8.0.0.7 or later (AIX 5.3) xlC.rte:8.0.0.7 or later (AIX 5.3) xlC.aix61.rte:9.0.0.1 or later (AIX 6.1) xlC.rte:9.0.0.1 or later (AIX 6.1) rsct.basic.rte (For RAC configurations only) rsct.compat.clients.rte (For RAC configurations only)5.3 ML5 required patches: IY89080 IY92037 IY94343 IZ01060 or efix for IZ01060 IZ03260 or efix for IZ03260 (IZ03260 for ML6, IZ03475 for ML7) to address ORA-27061 IY84780 IY68989 POWER7 Based Hardware Patch 9216848 | 5.2 ML4 required patches: IY63133 IY64978 IY63366 IY64691 IY64737 IY65001 IY94343 5.3 ML2 required patches: IY58143 IY59386 IY60930 IY66513 IY70159 IY68989 IY94343 Patch 5496862 is required if running on AIX 5.3 ML5 IY84780 IY68989 Required OS packages: bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat bos.perf.libperfstat bos.perf.proctools 6.1 specifics: Please download and run an updated version of rootpre.script before proceeding with the Oracle Database install. Internal bug 6613550. 6718715can be downloaded from MetaLink. | 5.2 required patches: IY43980 IY44810 IY45462 IY45707 IY46214 IY46605 IY48525 IY51801 IY59082 IY94343 5.3 required patches: IY58143 IY59386 IY60930 IY94343 Patch 5496862 is required if running on AIX 5.3 ML5. IY84780 IY68989 Required OS packages: bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat bos.perf.libperfstat bos.perf.proctools X11.motif.lib (Spatial only) | 4.3.3 required patches/packages: IY30927(4.3.3.0.10) IY24568(4.3.3.0.09) IY25282(4.3.3.0.09) IY27614(4.3.3.0.09) IY30151(4.3.3.0.10) Maint Level 9 or higher (4.3.3.0.09) bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat 5.1(5L) required patches/packages: IY26778(5100-01) IY28766(5100-01) IY28949(5100-01) IY29965(5100-02) IY30150(5100-02) IY59082 Maint Level 1 and IY22854 bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat bos.perf.libperfstat Use the -ignoreSysPrereqs option with runInstaller to ignore the system pre-requisite test | Maint Level 7 or higher (4.3.3.0.07) bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat X11.apps.rte X11.apps.xterm X11.base.rte X11.motif.lib X11.motif.mwm | IY01050 (4.3.3.0.03) IY07276 (4.3.3.0.02) IY05995 (4.3.3.01) IY02407 (4.3.2.02) IX89087 (4.3.2.0.02) IY03412 (4.3.2.0.02) IX85104 (4.3.2.0.01) IX87313 (4.3.2.0.01) IX87382 (4.3.2.0.01) IX89552 (4.3.2.0.01) IX81863 (4.3.1) IX72696 (4.3.0) | IY01050 (4.3.3.0.03) IY07276 (4.3.3.0.02) IY05995 (4.3.3.01) IY07018 (4.3.3) IY02407 (4.3.2.02) IX89087 (4.3.2.0.02) IY03412 (4.3.2.0.02) IX85104 (4.3.2.0.01) IX87313 (4.3.2.0.01) IX87382 (4.3.2.0.01) IX89552 (4.3.2.0.01) IX81863 (4.3.1) IX72696 (4.3.0) | 4.2 related required APARs IX62429 (4.2.0) IX67174 (4.2.0) IX67978 (4.2.1) IX68932 (4.2.1) IX70737 (4.2.1) IX78933 (4.2.1.0.03) IX81957 (4.2.1.0.03) IX86229 (4.2.1.0.05) 4.3 related required APARs IX71948 (4.3.0) IX79690 (4.3.0) IX81863 (4.3.1) | bos.adt.base, bos.adt.libm must be installed 4.2 related required APARs IX62429 (4.2.0) IX67174 (4.2.0) IX67978 (4.2.1) IX68932 (4.2.1) IX70737 (4.2.1) IX78933 (4.2.1.0.03) IX81957 (4.2.1.0.03) IX86229 (4.2.1.0.05) IX88178 (4.2.1.0.06) 4.3 related required APARs IX71948 (4.3.0) IX79690 (4.3.0) IX81863 (4.3.1) IX87313 (4.3.2.0.01) IX87382 (4.3.2.0.01) IX89087 (4.3.2.0.02) | bos.adt.base, bos.adt.libm must be installed 4.1 related required APARs IX54124 (4.1.4) IX55203 (4.1.5.0.01) IX62330 (4.1.5) IX58455 (4.1.4) IX61237 (4.1.4) IX67074 (4.1.5) IX61933 (4.1.5) IX70194 (4.1.5) 4.2 related required APARs IX62429 (4.2.0) IX67174 (4.2.0) IX67978 (4.2.1) IX68932 (4.2.1) IX70737 (4.2.1) If running 4.2 then need bos.rte.libc version 4.2.0.5 4.3 related required APARs IX71948 (4.3.0) |
| AIX Kernel Settings | set AIXTHREAD_SCOPE=S in the environment:(Part Number E10839-04) export AIXTHREAD_SCOPE=S | set AIXTHREAD_SCOPE=S in the environment: export AIXTHREAD_SCOPE=S | set AIXTHREAD_SCOPE=S in the environment: export AIXTHREAD_SCOPE=S | set AIXTHREAD_SCOPE=S in the environment: export AIXTHREAD_SCOPE=S | set AIXTHREAD_SCOPE=S in the environment: export AIXTHREAD_SCOPE=S | N/A | N/A | N/A | LINK_CNTRL = L_PTHREADS_D7 (if using 4.3) | LINK_CNTRL = L_PTHREADS_D7 (if using 4.3) | LINK_CNTRL = L_PTHREADS_D7 (if using 4.3) |
How to determine installed package and patches on AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64
| OS | COMMAND FOR PACKAGES | COMMAND FOR PATCHES |
| AIX | lslpp -w | grep -i "software title" (applies to APARs and PTFs) | /usr/sbin/instfix -ik patch number |
| HP | Prior to 11: /usr/sbin/swlist -lproduct PH\* hp-ux 11 and after: * /usr/sbin/swlist -l patch \*\.*,c=patch * /usr/contrib/bin/show_patches (from patch PHCO_19550) | /usr/sbin/swlist -l fileset | grep -i |
| Solaris | /bin/pkginfo -l | grep -i "software title" | /bin/showrev -p |
| Tru64 | /usr/sbin/setld -i | grep -i "software title" | /usr/sbin/setld -i | more For patchkits: /usr/sbin/dupatch -track -type kit |
| Linux | To see if a particular RPM is installed (without the architectur): $ rpm -qa | grep "package name" To see if a particular RPM is installed (with the architectur): $ rpm -qa --qf "%{NAME}-%{VERSION}-%{RELEASE}_%{ARCH}\\n" | grep "package name" To see what RPM provided a particular object/library: $ rpm -q --whatprovides --qf "%{NAME}-%{VERSION}-%{RELEASE}_%{ARCH}\\n" "full path/library name" To see the contents listing of an RPM: $ rpm -ql "RPM name" For example: $ rpm -ql compat-libstdc++-33-3.2.3-47.3.ppc /usr/lib/libstdc++.so.5 /usr/lib/libstdc++.so.5.0.7 | |
| Mac OS X | Snow Leopard location is /Library/Receipts/InstallHistory.plist or /var/db/receipts Leopard location is /Library/Receipts/ or /var/db/receipts or command pkgutil --pkgs or issue pkgutil --pkgs | less |
How to determine kernel parameters on AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64
| OS | LOCATION | COMMAND TO SEARCH |
| AIX | automatically configured | do 'env' for LINK_CNTRL, To determine if AIX is 64 bit enabled do 'genkex | grep 64' or 'genkex | grep call' |
| HP | /stand/system or use SAM -->Kernel Configuration | /etc/sysdef, /usr/sbin/kmtune (kmtune desupported in 11.31, use /usr/sbin/kctune -v), or /usr/sbin/kcweb -F |
| Tru64 | /etc/sysconfigtab | /sbin/sysconfig -q ipc or /sbin/sysconfig -q vm or /sbin/sysconfig -q proc |
| Solaris | /etc/system | "/etc/sysdef | grep SHM" or "/etc/sysdef | grep SEM" |
| Linux | /usr/src/linux/include/asm/shmparam.h /usr/src/linux/include/linux/sem.h /proc/sys/kernel/sem /proc/sys/kernel/shmall /proc/sys/kernel/shmmax /proc/sys/kernel/shmmni | ipcs -lms |
| Mac OS X | /etc/sysctl.conf | "# /usr/sbin/sysctl -a | grep |
How to find swap, RAM and OS version on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64
| OS | SWAP | RAM | OS VERSION |
| AIX | /usr/sbin/lsps -a | /usr/sbin/lsattr -HE -l sys0 -a realmem | oslevel |
| HP PA-RISC | swapinfo -a | grep "Physical:" /var/adm/syslog/syslog.log | uname -a |
| HP Itanium | swapinfo -a | /usr/contrib/bin/machinfo | grep -i Memory | uname -a |
| Tru64 | swapon -s | vmstat -P | /usr/sbin/sizer -v |
| Solaris | swap -s | /usr/sbin/prtconf | grep -i memory | uname -r |
| Linux | free | free | uname -a |
| Mac OS X | # df -h / | # /usr/sbin/system_profiler SPHardwareDataType | grep Memory | # sw_vers |
OUI-11108 error during OUI OS package requirements check
Problem Description
While installing Oracle, OUI result in a "Not Executed" status message during the Checking operating system required packages requirements phase:
Checking operating system package requirements ...
Check complete. The overall result of this check is: Not executed <<<< OUI-11108: Packages information not specified. Recommendation: Install the required packages before continuing with the installation.
Cause of the Problem
If you already installed latest OS packages then this is Oracle installation bug. The Oracle installer is checking for the fixed version requirements of the packages, and provides this message if the major version installed on your system does not match. Though in my system the latest upgraded version is installed and Oracle is search for some old version. For example in 10g the minimum gcc package required is gcc-3.2 but in our system we have gcc - 4.1.2-44.el5.x86_64. It is searching for make-3.79 but in our system we havemake - 3.81-3.el5.x86_64 version which is latest. Also Oracle still searching binutils-2.14 but it was installed binutils - 2.17.50.0.6-9.el5.x86_64.
However, if you don't have the required package Oracle can still show the OUI-11108 error message. In that case, make sure you have required OS package in your environment. See Oracle platform specific installation guide in this case to know about each package name.
Solution of the Problem
This type of warning message can be ignored by manually verifying the package installation:
rpm -qa --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" | grep {package_name}
and then clicking the "Not Executed" check-box in the Status column and proceeding with the installation.
While installing Oracle, OUI result in a "Not Executed" status message during the Checking operating system required packages requirements phase:
Checking operating system package requirements ...
Check complete. The overall result of this check is: Not executed <<<< OUI-11108: Packages information not specified. Recommendation: Install the required packages before continuing with the installation.
Cause of the Problem
If you already installed latest OS packages then this is Oracle installation bug. The Oracle installer is checking for the fixed version requirements of the packages, and provides this message if the major version installed on your system does not match. Though in my system the latest upgraded version is installed and Oracle is search for some old version. For example in 10g the minimum gcc package required is gcc-3.2 but in our system we have gcc - 4.1.2-44.el5.x86_64. It is searching for make-3.79 but in our system we havemake - 3.81-3.el5.x86_64 version which is latest. Also Oracle still searching binutils-2.14 but it was installed binutils - 2.17.50.0.6-9.el5.x86_64.
However, if you don't have the required package Oracle can still show the OUI-11108 error message. In that case, make sure you have required OS package in your environment. See Oracle platform specific installation guide in this case to know about each package name.
Solution of the Problem
This type of warning message can be ignored by manually verifying the package installation:
rpm -qa --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" | grep {package_name}
and then clicking the "Not Executed" check-box in the Status column and proceeding with the installation.
Relink Fails On Target "Client_sharedlib" During Install Of Interim Patch Or CPU Patch
Problem Description
While Oracle 10gR2 installation after installation successfully then during linking to binary files the followings error are reported in the alert log.
Cause of the Problem
The message is just a warning, attempts to remove the file, which was busy. May be some other Oracle process is already using the file and hence another oracle process fails while removing the file. This happens due to oracle code bug.
Solution of the Problem
If you find the Oracle log file it says failing command is "genclntsh: Failed to remove /u01/app/oracle/product/10.2.0/db/lib/libclntsh.sl.10.1". and it happened due to following command failure.
rm: /u01/app/oracle/product/10.2.0/db/lib/libclntsh.sl.10.1 not removed. Text file busy
So manually move/rename the referenced library.
$ mv $ORACLE_HOME/lib/libclntsh.sl.10.1 $ORACLE_HOME/lib/libclntsh.sl.10.1.bak
- Rerun the failed relink command
$ cd $ORACLE_HOME/bin
$ ./genclntsh
While Oracle 10gR2 installation after installation successfully then during linking to binary files the followings error are reported in the alert log.
INFO: End output from spawned process.
INFO: ----------------------------------
INFO: Calling Action unixActions10.2.0.1.0 make
installMakePath = /usr/ccs/bin/make
installMakeFileName = /u01/app/oracle/product/10.2.0/db/network/lib/ins_net_client.mk
installTarget = client_sharedlib
installArguments = ORACLE_HOME=/u01/app/oracle/product/10.2.0/db,
undoMakeFileName = null
undoTarget = null
undoArguments = null
logFile = /u01/app/oracle/product/10.2.0/db/install/make.log
progMsg = Building client shared libraries
INFO: The output of this make operation is also available at: '/u01/app/oracle/product/10.2.0/db/install/make.log'
INFO:
INFO: Start output from spawned process:
INFO: ----------------------------------
INFO:
INFO: /u01/app/oracle/product/10.2.0/db/bin/genclntsh
INFO: rm: /u01/app/oracle/product/10.2.0/db/lib/libclntsh.sl.10.1 not removed. Text file busy
INFO: genclntsh: Failed to remove /u01/app/oracle/product/10.2.0/db/lib/libclntsh.sl.10.1
INFO: *** Error exit code 1
INFO:
Stop.
INFO: End output from spawned process.
INFO: ----------------------------------
INFO: Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'client_sharedlib' of makefile '/u01/app/oracle/product/10.2.0/db/network/lib/ins_
net_client.mk'. See '/home/oracle/oraInventory/logs/installActions2011-02-11_04-14-56AM.log' for details.
Exception Severity: 1
Cause of the Problem
The message is just a warning, attempts to remove the file, which was busy. May be some other Oracle process is already using the file and hence another oracle process fails while removing the file. This happens due to oracle code bug.
Solution of the Problem
If you find the Oracle log file it says failing command is "genclntsh: Failed to remove /u01/app/oracle/product/10.2.0/db/lib/libclntsh.sl.10.1". and it happened due to following command failure.
rm: /u01/app/oracle/product/10.2.0/db/lib/libclntsh.sl.10.1 not removed. Text file busy
So manually move/rename the referenced library.
$ mv $ORACLE_HOME/lib/libclntsh.sl.10.1 $ORACLE_HOME/lib/libclntsh.sl.10.1.bak
- Rerun the failed relink command
$ cd $ORACLE_HOME/bin
$ ./genclntsh
Thursday, February 10, 2011
Word count in notepad++
Many one thinks notepad++ is the best available editor tool but it lacks of word count tool. In fact, with notepad++ you can easily count number of words in a file. Just follow the following steps.
1) Open the file with notepad++ where you want to count number of words. You can count entire file word count or subpart of the file.
2) Highlight the portion of the file where you want to count words. You can select entire file by CTRL+A or just part of the file by highlighting mouse cursor.
3) While the text are selected click on TextFX menu bar.
4) Navigate to TextFX Tools.
5) Select Word Count.
6) In the pop up window it will show you follow information.
Words
Characters (no spaces)
Characters
UTF-8 Characters
UTF-8 Efficiency
Lines
Longest Line
Shortest Nonblank Line
Nonblank Lines
So now you have not only word count information but also many other additional information.
1) Open the file with notepad++ where you want to count number of words. You can count entire file word count or subpart of the file.
2) Highlight the portion of the file where you want to count words. You can select entire file by CTRL+A or just part of the file by highlighting mouse cursor.
3) While the text are selected click on TextFX menu bar.
4) Navigate to TextFX Tools.
5) Select Word Count.
6) In the pop up window it will show you follow information.
Words
Characters (no spaces)
Characters
UTF-8 Characters
UTF-8 Efficiency
Lines
Longest Line
Shortest Nonblank Line
Nonblank Lines
So now you have not only word count information but also many other additional information.
Sunday, February 6, 2011
Computer Graphics (CM0330M) Coursework: The Virtual Scene
Specification
You are required to write an OpenGL program of a virtual scene of your choice. Examples would be a city scene, nightlife, nature, etc. Please also see snapshots of example scenes located in Sample Scenes under the module web page. Note, by no means you are restricted to use any of the examples I have highlighted. The choice of your virtual scene is entirely yours. Emphasis is placed upon the implementation of OpenGL basic capabilities such as shading, lighting, material properties. Use of imagination and creativity in the implementation of the techniques to create interesting effects to set up an appropriate mood to your scene will attract bonus marks.
The basic technical requirements are:
The user should be able to navigate your virtual scene in 3D. This should include translating forwards and backwards, rotating left and right, and translating up and down. Tilting up and down and spinning upside down are other possible optional camera motions.
You should use at least one 3D model in your scene. You can create the model using OpenGL/Glut routines. Alternatively you can create your own models using a 3D package such as Maya or download models from Internet.
Programming should be done using Microsoft Visual C++ .NET, OpenGL and GLUT.
You must write your own code. You should not share code. You can, however, look at sample codes from books, Internet etc. for ideas that may help you in implementing your virtual scene. You can also look at the sample project by a previous student located at Sample project under the module web page
Assessment criteria
In terms of learning outcomes this assignment addresses your ability to be able to apply computer graphics techniques in practical situations.
In order to achieve a pass you will need to demonstrate the ability to write a piece of code and produce a report on a computer graphics scene described as above with the minimal technical requirements as outlined above. To achieve a merit you will have to demonstrate the ability to utilise the OpenGL to produce special effects in terms of modelling, lighting and interaction of your scene. To achieve a distinction you will need to demonstrate the advanced ability to cleverly utilise OpenGL routines to make your scene realistic by producing interesting effects that will enable to setup an appropriate mood to your scene.
What to Submit
1. Computer files
the complete project workspace including the C++ source code and the executable (.exe file).
a snapshot of your virtual scene in the form of a jpeg or a gif file.
2. 1000 word report.
The report should contain detailed description of your virtual scene and a short user guide. You should highlight the reason for your choice of the scene, the technical challenges you came across in implementing your ideas and the shortcomings as well as how you would have improved your scene if you had more time/resources/knowledge etc.
Copy these files onto a CD and hand in to the Student Support Office.
Subscribe to:
Posts (Atom)
Tag Cloud
10.2g
10g
11g
11gR2
Abasa
About Oracle
Administration
Adsense
Alerts
Archival
ASM
ASP.Net
Audit
Audit Vault
Backup
Bangladesh
Block Corruption
Blogger
Browser
Bug
Business
Clone
Clusterware
Comments
Concepts
Connection
Controlfiles
Crime
CSS
Data Block
Data Dictionary
Data Guard
Data Mining
Data Pump
Data Type
Database Administration
Database Vault
DBConsole
Developer
Economics
EM
Excel
Exercise
Explain plan
Export
External Table
Facebook
Firefox
Firmware
Flashback
Forum
Functions
Games
Globalization Support
Grid Control
Hardware
History
HTML
IE
Import
Indexes
initializaion parameter
initialization parameter
Installation
Internals
Internet
Interview
isql*plus
Java
JavaScript
Job
Joins
Joke
Limitation
Linux
Listener
Logminer
Magento
Mail
Materialized View
Medical
Memory
Mobile
Money
Multimedia
MySQL
Net Services
Network
OCP
Operators
Oracle
Oracle Concepts
Oracle Recovery
OS
Others
OUI
Package
Packages
Parameters
Partitioning
Patchset
Performance
Perl
Pfile
Photos
PHP
PL/SQL
Profile
Pseudocolumns
Puzzle
Quiz
Quota
RAC
RAC Installation
Recovery
Recovery Problems
Redo Log
Reports
RMAN
Scripts
Security
SEO
Server Administration
SGA
Shell Script
Smarty
Social Marketing
Solaris
Spfile
SQL
SQL Tuning
SQL*Loader
Sql*Plus
Startup Problem
Streams
SwingBench
System Analysis
Tablespaces
Technology
Temp
TNS Error
Tools
Troubleshooting
Tuning
Undo
UNIX
Upgradation
Utilities
Version
Views
Vmware
Windows
Wordpress
XML