A little memories of Oracle 9.2 EE on AIX

zhaozj2021-02-16  73

A few days ago, I learned Oracle 9.2 EE on AIX 4.3.3 and AIX 5.1, and I met some problems. I regret that I forgot to record it, huh, it's okay, now I am leisure, think about it, remember, later Record it when you put it, if you are ready to work, it is easy to install Oracle 9.2 on AIX, huh, huh, it is like it is installed in Window, and the installation process behind AIX 5.1 is a problem. No, strictly follow the Oracle installation document, there is no problem, huh, huh. AIX 4.3.3 Installing Oracle 9.2 Recall: 1. Check Physical Memory: (Ram> = 512 MB) # lsattr --l sys0 -a RealMem RealMem 1048576 Amount of usable Physical Memory in kbytes false # 我们 我们,, huh, It is enough 2. Check SWAP space: (equal to physical memory or 1G, best big) # lsps -a page space pHysical Volume Volume group size% Used active auto type hd6 hdisk0 rootvg 2048MB 1 yes Yes lv # 我们 2 2G , Huh, huh 3. Check the disk space, mainly pay attention to two points: a) Install 9.2, mainly to store Oracle Code, this space is recommended to 4G, or bigger.

b) In addition, in the process of installing Oracle, Oracle Universal Installer requires approximately 400M to temporary space, you can use the system default / TMP directory, you can also set up the environment variable TMPDIR to specify a directory with sufficient space, or in the installation process In particular, a temporary directory with sufficient space, such as: tmpdir = / ORatools Export Tmpdir, the Oracle installation file is placed on the built-in, so we need to look at the space of the built-in: # lsdev -cc disk hdisk0 Available 40-60-00-4, 0 16 Bit LVD SCSI Disk Drive Hdisk1 Available 14-08-L SSA Logical Disk Drive # We see hdisk0 is a built-in disk, now determine its size: # lspv hdisk0 Physical Volume: HDisk0 Volume Group: rootvg PV IDENTIFIER: 000ca13f7ebe3b7e VG IDENTIFIER 000ca13f7ebe3e67 PV STATE: active STALE PARTITIONS: 0 ALLOCATABLE: yes PP SIZE: 32 megabyte (s) LOGICAL VOLUMES: 11 TOTAL PPs: 542 (17344 megabytes) VG DESCRIPTORS: 2 FREE PPs: 217 (6944 megabytes HOT SPARE: NO Used PPS: 325 (10400 megabytes) free distribution: 108..20..00..89 Used Distribution: 01 ..88..108..108..20 # we see, Total is 18G, free is 7G, ​​enough, huh, huh 4. Check the version of the OS, two methods: You can use the oslevel command to determine the current AIX version , # Oslevel 4.3.3.0 # or you can also use OsLVEL -R to determine the current AIX version and ml (the maintenance level limited of the system): # oslevel -r 4330-09 # This result,

Similar to the instfix command to view the current ml: $ instfix -i | grep ml all filesets for 4.3.0.0_aix_ml were found. All FileSets for 4.3.2.0_aix_ml wrefound. All FileSets for 4320-02_AIX_ML were found. All filesets for 4.3.3.0_AIX_ML were found. All filesets for 4330-01_AIX_ML were found. All filesets for 4330-02_AIX_ML were found. All filesets for 4330-03_AIX_ML were found. All filesets for 4330-04_AIX_ML were found. All filesets for 4330-05_AIX_ML were found. All filesets for 4330-06_AIX_ML were found. Not all filesets for 4330-07_AIX_ML were found. All filesets for 4330-08_AIX_ML were found. All filesets for 4330-09_AIX_ML were found. All filesets For Aix43ml Were Found. $ visible, we are AIX 4.3.3, ml is 09 5. Check if the OS is 64 bit: If it is a 64 bit bit OS, you can load 32 bit or 64 bit Oracle 8i, but 32 Bit's OS can only load 32 bit's oracle; because Oracle 9.2 does not have 32 bits, so we must verify that our OS is 64-bit OS: There are two ways: # locale64 lang = C lc_collate = "c" lc_ctyp E = "c" lc_monetary = "c" lc_numeric = "c" lc_time = "c" lc_messages = "c" lc_all = # or # bootinfo -y 64 # 6. Take a look at the Patch of OS is not enough Oracle's documentation, for AIX 4.3.3 requires at least in ML 09, and IY24568, IY25282, IY27614, IY30151 these four patches, in fact, but in fact, we also need an IY30927, and the document says this package is just a package related to the use of CPUs. Don't, but the experience I installed is, must, otherwise I will have problems.

If the above package does not exist, then the following site download: http://techsupport.services.ibm.com/server/fixes $ instfix -i | grep ml all filesets for 4.3.0.0_aix_ml were found. All FileSets for 4.3 .1.0_AIX_ML were found. All filesets for 4.3.2.0_AIX_ML were found. All filesets for 4320-02_AIX_ML were found. All filesets for 4.3.3.0_AIX_ML were found. All filesets for 4330-01_AIX_ML were found. All filesets for 4330-02_AIX_ML were found. All filesets for 4330-03_AIX_ML were found. All filesets for 4330-04_AIX_ML were found. All filesets for 4330-05_AIX_ML were found. All filesets for 4330-06_AIX_ML were found. Not all filesets for 4330-07_AIX_ML were found. All FileSets for 4330-08_Aix_ml WERE FOUND. All FileSets for 4330-09_Aix_ML WERE FOUND. All FileSets for Aix43ml WERE Found. $ Obviously, our AIX is 4.3.3 ml09 Viewing a Patch is installed: # instfix -i | grep iY24568 All FileSets for iY25282 befound indicates that there is already this Patch # instfix -i | grep iY30927 NOT All FileSets for IY30927 WERE FOUND. Indicates that there is no IY30927 this Patch 7. Specially, Java is not installed in the default installation of AIX 4.3.3, need to be manually installed (not handled by AIX 5.1) The default installation of the system will install Java) at least JDK1.1.8, the corresponding patch is IY30886 If you use HTTP Server, you need JDK1.3.1, the corresponding Patch is: IY31033 Download address: ftp://service.software. IBM.com/aix/efixes/ (If this patch is already installed, there will be a / usr / jdk_base directory, it is your java_home) 8. Check if you have the required OS Package Aix 4.3.3 requires the following package: BOS .adt.base, bos.adt.lib, bos.adt.libm, bos.perf.perfstat We can use the lslpp pl ics_package command to view:

# lslpp -l bos.adt.base fileset level state description ------------------------------------- --------------------------------------- path: / usr / lib / Objrepos bos.adt .Base 4.3.3.77 Committed Base Application Developments Toolkit # lslpp -l bos.com ----------------------------------------- ------------------------------------------------- : / usr / lib / objrepos bos.adt.lib 4.3.3.10 Committed Base Application Development Libraries # lslpp -l bos.adt.libm FileSet Level State Description ----------------- -------------------------------------------------- --------- path: / usr / lib / Objrepos bos.adt.libm 4.3.3.50 Committed Base Application Developments Math Library # If the Patch and PackGAE you need is not installed, then go to the corresponding site Download, and use the SMIT's Update All to install them.

There is sometimes an error like "this package has been installed or specified" during the installation process, at this time, go to the directory you specified below, if there is .toc file, we need to delete it (it is a hidden With files, you need to view with ls -a. Need a place to store installation files, assume it to / oratools, we need to enter the Smit- System Storage Management (Physical & Logical Storage) -file systems or -Logical Volume Manager, (if you are an AIX newer, then you choose FS Let the system build a logical volume for you, huh, huh; if you want to install OPS or Rac, you have to use first logical volume, then build a file system method, because the logical volume established by the system will be renamed, huh, huh, -Add / change / show / delete file systems -journaled File System - Add A Large File Enabled Journald File System (Select this, file system greater than 2G) This is the system will make you choose one VG window, it is best not to choose rootvg because we usually put things related to OS.

Then appear: Similar to the window: Size of File System (in 512-byte blocks) [] # * mount point [] Mount Automatic AT System Restart? NO (Note Mount Automatically At System Restart) 11. Create an Oracle_Home home directory (method is the same as above) 12. Establish a DBA group SMIT Group - Add a group 13. Establish Oracle User Smit User - Add A User 14. Take Oracle, modify Profile, such as: Path = / usr / bin: / ETC: / usr / sbin: / usr / ucb: $ home / bin: / usr / bin / x11: / sbin :. export pathix f [-s "$ mail"] # this is at shell startup. in Normal Then Echo "$ MAILMSG" # operation, the Shell checks fi # periodically PATH = $ PATH:. /oratools/gzip-1.2.4a export PATH DISPLAY = 192.168.2.216:0.0 export DISPLAY ORACLE_BASE = / oracle92 export ORACLE_BASE ORACLE_HOME = $ ORACLE_BASE / product /9.2 export oracle_home oracle_sid = ORA92 Export Oracle_sid Oracle_Term = VT100 Export Oracle_Term ORA_NLS33 = $ ORAC LE_HOME / ocommon / nls / admin / data export ORA_NLS33 JAVA_HOME = / usr / jdk_base export JAVA_HOME LIBPATH = $ ORACLE_HOME / lib export LIBPATH CLASSPATH = $ ORACLE_HOME / product / jlib: $ ORACLE_HOME / jlib export CLASSPATH PATH = $ ORACLE_HOME / bin: $ Path Export Path NLS_LANG = American_america.zhs16GBK Export NLS_LANG TmpDir = / ORatools Export Tmpdir set -o vi umask 022 set -o vi is not required, huh, it allows you to use VI command when entering OS (similar VI command Mode), for example: h: left shift a character J: The last command I just implemented K: The previous command just implemented L: Right shift a character, etc. 15. Install Oracle,

Need XWindow's support to log in in Oracle, enter: XClock, see if you can have a small clock, if you can do it, SU to root, then Xhost 192.168.2.216 16. There is no more saying, According to the prompt, there have been several times to execute a few SH in the middle, then OK pay attention, when I installed IY30927, I'm wrong, then view the Make file to find a lot of problems, huh, my solution: First , Install IY30927, then reboot; then, reelink If there is similar to the following questions: LD: 0711-317 error: undefined Symbol: Ksusga_ ld: 0711-317 error: undefined Symbol: kwqpls_ ld: 0711-317 error: undefined Symbol: kclnlt_ ld: 0711-317 eRROR: Undefined symbol: ksulsg_ ld: 0711-317 eRROR: Undefined symbol: kcbstdbz_ ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information make:. The error code from the last command Is 8. So $ oracle_home / lib, see if ksms.im is 0 bytes, if yes, then remove this file, and execute Relink, it is no problem. (This error is because when there is no IY30927, it prompts a .so error during the installation process, we have chosen ignored, then $ oracle_home / bin / genksms will fail, and in $ oracle_home / lib / ksms .imp produced the 0 BYTES file file) Recalling, I will basically appear above, I will reinstall it, and I will put it on the needed bag. It is estimated that there will be no later. Trouble, huh, huh. http://www.cnoug.org/viewthread.php?tid=259&highlight=+lunar

转载请注明原文地址:https://www.9cbs.com/read-14315.html

New Post(0)