Section 1: Installation Note: Because Oracle 9i is 64-bit, the installed AIX platform must also be 64 bits. If you don't have to reinstall or use the connection library function to change it to 64 bit to change to change to change to change to 64 bit multi-processor mode: # ln -sf / usr / lib / boot / UNIX_64 / UNIX # ln -sf / usr / lib / BOOT / UNIX_64 / USR / LIB / BOOT / UNIX # bosboot -ad / dev / ipldevice # shutdown -r 1, confirmation system environment 1, host environment: IBM P630 ?? CPU: 1000MHz ?? MEM: 1G ( MIN 512M) $ / usr / sbin / lsattr - E -L Sys0 -a RealMem 12582912 Amount of USABLE Physical Memory in Kbytes False ?? / TMP: 1000M (min 500m) $ DF-K / TMP FileSystem 1024-blocks free% Used iused% iused mounted on / dev / hd3 655360 603088 8% 69 1% / TMP ?? swap: 6G (generally 2 times in MEM, but because our memory is already big, there is no general rules) $ / USR / SBIN / LSPS -A Page Space Physical Volume Volume Group Size% Used Active Auto Type HD6 HDisk0 Rootvg 6144MB 1 YES YES LV ?? / Oracle: 38g (MIN 3.5G, this catalog is used to install software, store Source and Oracle9 users The root directory is located) $ df -k / oracle filesystem 1024-block free% Used iused% iused mounted on / dev / oracle 38010880 28495268 26% 64272 1% / oracle 2, operating system environment ?? os situation: AIX 5L 64bit and 64-bit kernel mode, hostname ERP01 $ uname -a aix haw3 1 5 000BD81A4C00 HAWK3: / # bootinfo -y 64 haw3: / # bootinf O-K 64 ?? OS Patch: Oracle Requirements Patch: IY22854, IY26778, IY28766, IY28949, IY29965, IY30150 Vissent with the following commands to check the required patch, such as: # / usr / sbin / instfix -a -ivk IY22854? There is X-Window, 32bit Java Version 1.3.1 installed separately, you can from now, Download: http://www.ibm.com/developerworks/java/jdk/aix/index.html 3, Oracle Version 1. To the IBM website to download JDK1.3.1 for Aix, pay attention to download JDK1.3.1 Lience, use the tar command unpacking the two files in the same directory. Http://www.ibm.com/developerWorks/java/jdk/index.html 2.
Use the Smitty InstallP installation, select the JDK1.3.1 and JDK1.3.1License two file packs Note PREVIEW New License Agreements? To select Yes, there is an error 3 when installing. Since the BOS.RTE.LIBC version is prompted during the installation process requires Update to IBM website download update package https://techsupport.services.ibm.com/server/aix.fixsearch51 Other update packages can also be downloaded. 4. Install the download 5 Update package, reinstall JDK 5. Modify / etc / environment path to change to / usr / jdk13 Re-login Java - Version View Current Java version ?? Oracle Version 9.2.0.1.0, if you don't have Oracle media, you can also Here Download: http://otn.oracle.com/software/products/oracle9i/htdocs/aix5lsoft.html The usual habits are copied to the hard drive, using Gunzip and CPIO -IDCMV to unzip unpacking. Second, specific installation steps: 1. Use root users to complete the following operations Add Oracle users and groups: You can use commands or smit to complete, I usually create only DBA groups. Create a relevant directory and change the appropriate permissions.
2, set the environment variables to set the environment variables in .profile oracle user: # Oracle Environment ORACLE_BASE = / oracle / app; export ORACLE_BASE ORACLE_HOME = $ ORACLE_BASE / product / 9.2.0; export ORACLE_HOME ORACLE_SID = ora9; export ORACLE_SID ORACLE_TERM = vt100; export ORACLE_TERM TNS_ADMIN = $ ORACLE_HOME / network / admin; export TNS_ADMIN NLS_LANG = american_america.zhs16cgb231280; export NLS_LANG ORA_NLS33 = $ ORACLE_HOME / ocommon / nls / admin / data; export ORA_NLS33 LD_LIBRARY_PATH = $ ORACLE_HOME / lib: / usr / lib; export LD_LIBRARY_PATH LIBPATH = $ ORACLE_HOME / lib: $ ORACLE_HOME / ctx / lib; export LIBPATH ORA_DB = $ ORACLE_HOME / dbs; export ORA_DB CLASSPATH = $ ORACLE_HOME / JRE / lib: $ ORACLE_HOME / JRE / lib / rt.jar: $ ORACLE_HOME / Jlib: $ ORACLE_HOME / RDBMS / JLIB; Export ClassPath Path = $ Oracle_Home / BIN: $ PATH; Export Path Handmade Display to Local: Export Display = 10.16.98.16: 0.0 3 Rootpre.sh, then select Y, make normal installation; recommended "Installation Types" to select Custom mode, which can choose to install the component; the installation process generally does not choose to create the database, this can be done separately after the installation is complete; then there will be prompt run oraptestroot .sh script, will be prompted to run root.sh when the LINK is to end, and it can be done as required. In the second section: The process of building the library is very simple, and will not be described again.
Here is a few scripts of the manual construction library: run1.sh ===================================== ========================================= #! / bin / sh oracle_sid = ORA9 export oracle_sid / oracle / app / oracle / Product / 9.2.0 / bin / SQLPlus '/ as sysdba' << EOF Spool /Oracle/Orcle9/crdb1/run1.log startup nomount pfile = "/ Oracle / App / Oracle / Product / 9.2.0 / dbs / initora9. ora "CREATE DATABASE ora9 CONTROLFILE REUSE MAXDATAFILES 254 MAXINSTANCES 8 MAXLOGHISTORY 100 MAXLOGMEMBERS 3 MAXLOGFILES 16 DATAFILE '/ dev / rsystem' sIZE 1190M REUSE AUTOEXTEND OFF default temporary tablespace temp tempfile '/ dev / rtemp' size 20400M reuse autoextend off UNDO TABLESPACE" UNDOTBS1 " DATAFILE '/ dev / rundo1' SIZE 10200M REUSE AUTOEXTEND OFF CHARACTER SET ZHS16CGB231280 LOGFILE GROUP 1 ( '/ dev / rredo11') SIZE 150M REUSE, GROUP 2 ( '/ dev / rredo12') SIZE 150M REUSE; disconnect spool off exit EOF = ============================================================================================================================================================================================================= ================== run2.sql ======================================================================================================================================================== ================
================================== Create undo tablespace "undotbs2" DataFile '/ dev / rundo2' size 10350m Reuse create tablespace "default" logging datafile '/ dev / rdefault 'SIZE 10230M REUSE EXTENT MANAGEMENT LOCAL; alter database ora9 add LOGFILE GROUP 3 (' / dev / rredo13 ') SIZE 150M REUSE; alter database ora9 add LOGFILE GROUP 4 (' / dev / rredo14 ') SIZE 150M REUSE; alter Database ORA9 Add Logfile Group 5 ('/ dev / rredo15') size 150m Reuse; Alter Database ORA9 Add Logfile Group 6 ('/ dev / rredo16') size 150m reuse; ============= ============================================================================================================================================================================================================= ====== Opening followed by @ / Oracle / Oracle9 / App / Oracle / Product / 9.2.0 / RDBMS / Admin / CatProc.sql @ / Oracle / Oracle9 / App / Oracle / Product / 9.2.0 / RDBMS / Admin / Caths.sql @ / Oracle / Oracle9 / App / Oracle / Product / 9.2.0 / Rdbms / Admin / Otrcsvr.SQL Connect System / Manager @ / Oracle / Oracle9 / App / Oracle / Product / 9.2.0 / Sqlplus / Admin / PuPBLD.SQL Section 3: Upgrade Oracle 9.2.0.1.0 to Oracle 9.2.0.0.0 Oracle 9.2.0.0.0 Patch is only available on 3 this month, it is the latest, so in the upgrade process Listening 9.2.0.2 is more complicated. 9203's Patch Number is 2761332, you can download in Metalink, select "IBM AIX BASED SYSTEM (64-bit) 5L". The total size is 660m, the file name is: p2761332_9203_aix64-5l.zip. After the unzip decompressed, TAR is opened. In the past 9.2.02, from here, you can run Runinstaller to install it, but now it is not, for the smooth completion of our upgrade, the following work is also required.
1, shutdown database, stop listener. 2. Adjust the Memory and DATA restrictions of the AIX 5L system, we can set it out. The adjustment method is to edit / etc / security / limits, change the value of Memory and Data into -l. 3.1 Upgrade Universal Installer, because 9.2.0.3 requires that the version 2.2.0.18.0 version of Universal Installer is installed, and this patch is just this month. It is estimated to upgrade 9.2.0.3. Patch Number is 2878462, pay attention, this is written on the ReadMe of 9.2.0.3, a significant error. The file name is: p2878462_220_aix64-5l.zip, size 27.5m. 3.2, after the download is complete, use unzip to decompress, generate the AIX directory, there is readme.txt and ui220180_aix.jar, use jar -xvf ie220180_aix.jar unpack, then CD CD / Disk1 / Install / AIX, running RunInstaller. Ok, the work before installation is so much, there are other things to do. Now you can perform RunInstaller to install a 9.2.0.3 Patch, you want to install a failed prompt to run root.sh. Before starting the database, we need to adjust the following initialization parameters: shared_pool_size = 1024000000 #Add AT 20030426 (minimum required 150M) java_pool_size = 217440512 #Changed Larger AT 20030427 (If Java is installed, the minimum requirement 150m) is now implemented: startup: Startup Migrate Pfile = '/ Oracle / App / Oracle / Admin / ORA9 / PFILE / INTORA9.ORA' Spool Patch.log @ / Oracle / App / Oracle / Product / 9.2.0 / Rdbms / Admin / CatPatch.sql Spool Off View LOG See if there is any fault, some of which is negligible. After that: Create SPFile from Pfile = '/ ORACLE / App / Oracle / Admin / Ora9 / Pfile / Initora9.ora'; Shutdown Startup @ / Oracle / App / Oracle / Product / 9.2.0 / Rdbms / Admin / Utlrp.sql SQL > SELECT * FROM V $ VERSION; Banner ----------------------------------------- ----------------------- Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production PL / SQL Release 9.2.0.3.0 - Production Core 9.2.0.3 .0 Production TNS for IBM / AIX RISC System / 6000: Version 9.2.0.3.0 - Production NLSRTL VERSION 9.2.0.3.0 - Production Appendix 1 System Installation Minimum Configuration Checklist The following document is for Oracle9.2.0 inspections on AIX5L Project.
System installation minimum configuration check table Remarks Requires auxiliary command to complete hardware requirements 64bite 64bite minimum 256MB memory $ / usr / bin / lsattr □ not less than 2 times memory or 400M SWAP Space or $ / usr / bin / LSPS -A □ CD-ROM □ Operating System Software Requires Operating System: AIX 5 $ USR / BIN / OSLVEL □ Operating System Patch, see Appendix 2 View all patch $ / usr / sbin / instfix -a View a patch $ / USR / SBIN / INSTFIX -IK Maintenance_LEVEL or $ / usr / sbin / instfix -a -ivk apar_number View a patch example / usr / sbin / instfix -ik 4330-07_aix_ml or / usr / sbin / instfix -a -ivk iy15138 □ 3GB Disk Space Database Software (2.5G) Basis (SEED) Database (1G) □ SHELL FILE file limit $ ulimit -f This should change 1000M or more temporary disk space in / tmp directory $ / usr / BIN / DF -K / TMP This is the requirements of Oracle Universal Installer, if not enough, can create / TMP on additional file systems, set TEMP and TMPDIR environment variables, examples: $ mkdir / u03 / tmp $ TEMP = / U03 / TMP; Export Temp $ TMPDIR = / U03 / TMP; Export TmpDir □ JRE Patches $ JRE Oracle Requirements Version at least JRE 1.1.8.5. □ JDK Patches $ Java -Version Oracle HTTP Server needs to use JDK, version at least 1.3.1, In the process of installing this, you will be prompted □ Make the following two files to write /etc/orainst.loc / etc / oracle users can guarantee this command to log in with Oracle users, perform Touch /et /etc/orainst.loc / etc / ETC / ORATAB then delete these two files These two files are in Anacle Automatically create an operating system file set (FileSets)