Oracle 10.1.2 iAS metadata repository ettevalmistamine

Allikas: Kuutõrvaja

MRCA paigaldamine

MRCA abil MR skeemide laadimiseks olemasolevasse 10R2 andmebaasi tuleb teha sellised ettevalmistused, numbrid viitava Metalink'i (http://metalink.oracle.com/) nootidele, neile ligipääsuks peab olema Metalink süsteemis kasutada kasutaja

Kasutada MRCA (Metadata Repository Creation Assistant) versiooni 10.1.2.0.3, http://www.oracle.com/technology/software/products/ias/htdocs/101202.html 

 $ cksum as_linux_x86_mrca_101203.cpio
 1961190085 480973824 as_linux_x86_mrca_101203.cpio

Pakime MRCA paigaldusmaterjali lahti 

 $ cpio -dmvi < as_linux_x86_mrca_101203.cpio

MRCA kasutamiseks tuleb esmalt MRCA ise paigaldada, nt kataloogi 

 /u01/app/oracle/product/10.1.2/mrca

Veenduge, ega Oracle'ga seatud keskkonnamuutujaid ei ole kirjeldatud, ega esine vatavaid teid PATH'is 

 $ env | grep ORA*
 $ echo $PATH

Näiteks sellise skriptiga /home/oracle/system/env.sh saab nad eemaldada 

 unset ENV
 unset ORA_CRS_HOME
 unset ORA_DB_HOME
 unset ORACLE_SID
 unset ORA_NLS10
 unset ORACLE_BASE
 unset ORA_IAS_HOME
 unset ORACLE_HOME
 unset LD_LIBRARY_PATH
 export PATH=/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin
 unset CLASSPATH
 unset TNS_ADMIN
 unset AGENT_HOME
 unset ORA_ASM_HOME
 unset ORACLE_HOSTNAME

ning öelda 

 $ . ./system/env.sh

Ja käivitada installer 

 $ ./runInstaller 
 ***************************************************************
 The following files should not be present :
 /etc/profile.d/oracle.csh 
 /etc/profile.d/oracle.sh 
 /etc/profile.d/alljava.csh 
 /etc/profile.d/alljava.sh 
 Please remove the above files or move them to .bak
 Remove the ". ./.oracle" entries from /home/oracle/.profile
 Logout and login to reset the Shell environment.
 ***************************************************************
 Do you want to continue anyway: [y/n] 
 y
 For SuSE, you are required to login as root and run the patch present in 
 the utils/3167528/ and utils/4015045 directory
 Enter y if you have allready installed the patch 
 Enter n to exit the installer and run the patch 
 Is the patch for bug # 3167528 and 4015045 run : [y/n] :
 y

Kui kõnealuses arvutis on MRCA installer esimene Oracle programm, siis küsitakse inventory asukohta

Mrca-inst-1.gif

ning moodustatakse kaks faili

Mrca-inst-2.gif 

 # /u01/app/oracle/oraInventory/orainstRoot.sh 
 Creating the Oracle inventory pointer file (/etc/oraInst.loc)
 Changing groupname of /u01/app/oracle/oraInventory to oinstall.

Seejärel tuleb näidata millisesse kataloogi tarkvara paigaldatakse

Mrca-inst-3.gif

Keelevalikud, installeri kasutajaliidese keele osas

Mrca-inst-4.gif

Seejärel sooritab installer standarse operatsioonisüsteemi parameetrite kontrolli, mille tulemus võiks olla näiteks selline 

 Checking operating system certification
 Expected result: One of redhat-2.1,redhat-3,redhat-4,SuSE-9,SuSE-8,UnitedLinux-1.0
 Actual Result: SuSE-9
 Check complete. The overall result of this check is: Passed
 =======================================================================
 
 Checking security kernel parameters
 Checking for shmall=2097152; found shmall=2097152.      Passed
 Checking for msgmnb=65535; found msgmnb=65536.  Passed
 Checking for semmns=32000; found semmns=32000.  Passed
 Checking for semopm=100; found semopm=100.      Passed
 Checking for msgmni=2878; found msgmni=16.      Failed <<<<
 Checking for shmmax=2147483648; found shmmax=3294967296.        Passed
 Checking for hardnofiles=65536; found hardnofiles=65536.        Passed
 Checking for VERSION=2.6.5-7.97; found VERSION=2.6.16.60-0.27-default.  Passed
 Checking for file-max=131072; found file-max=131072.    Passed
 Checking for semmsl=256; found semmsl=1250.     Passed
 Checking for semmni=142; found semmni=256.      Passed
 Checking for msgmax=8192; found msgmax=65536.   Passed
 Checking for shmmni=4096; found shmmni=4096.    Passed
 Checking for softnofiles=4096; found softnofiles=65536. Passed
 Check complete. The overall result of this check is: Failed <<<<
 Problem: The security parameters in the kernel do not meet the minimum requirements (see above).
 Recommendation: Perform operating system specific instructions to update the kernel parameters, namely BIT_SIZE and   noexec_user_stack.
 =======================================================================
 
 Checking recommended operating system packages
 Checking for pdksh-5.2.14-780.1; found Not found.       Failed <<<<
 Checking for sysstat-5.0.1-35.1; found sysstat-8.0.4-1.4.       Passed
 Checking for openmotif21-libs-2.1.30MLI4-119.1; found Not found.        Failed <<<<
 Checking for libstdc++-3.3.3-43.24; found libstdc++-4.1.2_20070115-0.21.        Passed
 Checking for make-3.80-184.1; found make-3.80-202.2.    Passed
 Checking for binutils-2.15.90.0.1.1-32.5; found binutils-2.16.91.0.5-23.31.     Passed
 Checking for gcc-3.3.3-43.24; found gcc-4.1.2_20070115-0.21.    Passed
 Checking for gcc-c++-3.3.3-43.24; found gcc-c++-4.1.2_20070115-0.21.    Passed
 Checking for gnome-libs-1.4.1.7-671.1; found Not found. Failed <<<<
 Checking for gnome-libs-devel-1.4.1.7-671.1; found Not found.   Failed <<<<
 Checking for libstdc++-devel-3.3.3-43.24; found libstdc++-devel-4.1.2_20070115-0.21.    Passed
 Check complete. The overall result of this check is: Failed <<<<
 Problem: Some recommended packages are missing (see above).
 Recommendation: You may actually have installed packages which have obsoleted these, in which case you can successfully continue with the i
 =======================================================================
 
 Checking glibc installed on the system
 Expected result: 2.3.3-98.28
 Actual Result: 2.4-31.54
 Check complete. The overall result of this check is: Passed
 =======================================================================
 
 Validating ORACLE_BASE location (if set)
 Check complete. The overall result of this check is: Passed
 =======================================================================

Siit on näha järgmised probleemid 

 * Checking for msgmni=2878; found msgmni=16.      Failed <<<< - tuleb seada kernel.msgmni parameeter
 * mõni pakett on puudu - neid võib praktiliselt ignoreerida kuna me kasutame tegelikult SLES10 operatsioonisüsteemi

Peale parameetri seadmist käsuga 

 # sysctl -w kernel.msgmni=2878

ning faili /etc/sysctl.conf lisades.

Peale installeri töö katkestamist ja enne uuesti käivitamist tuleb vahepeal eemaldada failisüsteemist tekkinud kataloog 

 $ rm -rf /u01/app/oracle/product/10.1.2/mrca

Küsitakse, kas installeri paigaldamise järel asutakse koheselt andmebaasi ettevalmistama, vastame eitavalt, et protseduurid lahus hoida

Mrca-inst-5.gif

Näidatakse tehtud otsustusi

Mrca-inst-6.gif

Ja toimub tarkvara paigaldamine

Mrca-inst-7.gif

Paigalduse lõpul tuleb käivitada juurkasutajana skript 

 # /u01/app/oracle/product/10.1.2/mrca/root.sh 
 Running Oracle9 root.sh script...
 \nThe following environment variables are set as:
     ORACLE_OWNER= oracle
     ORACLE_HOME=  /u01/app/oracle/product/10.1.2/mrca
 
 Enter the full pathname of the local bin directory: [/usr/local/bin]: /usr/local/mrca/bin 
 Creating /usr/local/mrca/bin directory...
    Copying dbhome to /usr/local/mrca/bin ...
    Copying oraenv to /usr/local/mrca/bin ...
    Copying coraenv to /usr/local/mrca/bin ...
 
 \nCreating /etc/oratab file...
 Adding entry to /etc/oratab file...
 Entries will be added to the /etc/oratab file as needed by
 Database Configuration Assistant when a database is created
 Finished running generic part of root.sh script.
 Now product-specific root actions will be performed.
 Running Oracle9 root.sh script...
 \nThe following environment variables are set as:
     ORACLE_HOME=  /u01/app/oracle/product/10.1.2/mrca
 Finished running generic part of root.sh script.
 Now product-specific root actions will be performed.

Mrca-inst-8.gif

Teatatakse, et paigaldus on lõppenud

Mrca-inst-9.gif

Installeri sulgemine toimub justkui ebaloomulikult öeldes Exit, aga nii ta on

Mrca-inst-10.gif

MRCA abil MR skeemide laadimine olemasolevasse andmbaasi

MRCA sisaldab vahendit olemasoleva andmebaasi sobivuse kontrollimiseks, sedasi 

 $ cd /u01/app/oracle/product/10.1.2/mrca/repca/prereq
 $ ./DBPrereqChecker -DBHOST baas-vip-loomaaed.tartu.ee -DBPORT 1521 -DBNAME loomdba.loomaaed.tartu.ee -SYSPWD xxx -LOGDIR /home/oracle/mrca-log
 Starting validation DatabasePrerequisite
 Database Problems 
 The following problems were found with the specified database: 
 The aq_tm_processes initialization parameter needs to be greater than or equal to 1. Please correct it and try again.
 
 The db_cache_size initialization parameter needs to be set to 144MB or a greater value. Please correct it and try again.
 
 The shared_pool_size initialization parameter needs to be set to 175MB or a greater value. Please correct it and try again.
 
 The java_pool_size initialization parameter needs to be set to 120MB or a greater value. After changing the value of the parameter, restart the database for the new value to take effect.

Selliste probleemide korrigeerimiseks tuleb

  • ..

Edu puhul vastatakse 

 Starting validation DatabasePrerequisite
 Validation Succeeded -> DatabasePrerequisite
 Validation check complete

MRCA kasutamine toimub selliselt 

 $ cd /u01/app/oracle/product/10.1.2/mrca
 $ ./runRepca

Mrca-rac-1.gif

Seejärel tuleb sisestada kasutatava välise andmebaasi tee andmebaasi arvutis

Mrca-rac-1-1.gif

Näitame, et toimub andmete laadimine baasi

Mrca-rac-2.gif

Näitame, millised baasiga on tegu, antud juhul RAC

Mrca-rac-3.gif

Näitame, et RAC kasutab ASMi

Mrca-rac-4.gif

Grupivalik

Mrca-rac-5.gif

Tutvustab valikuid

Mrca-rac-6.gif

Arvuti näitab progressi

Mrca-rac-7.gif

Arvuti õnnitleb

Mrca-rac-8.gif

Märkused

  • Kui andmebaasile vastavad failid asuvad failisüsteemis sarnaselt, siis on tegu nn Regular File System storage tüübiga
 $ find /u01/app/oracle/oradata/
 /u01/app/oracle/oradata/
 /u01/app/oracle/oradata/portdba
 /u01/app/oracle/oradata/portdba/control01.ctl
 /u01/app/oracle/oradata/portdba/control02.ctl
 /u01/app/oracle/oradata/portdba/control03.ctl
 /u01/app/oracle/oradata/portdba/redo01.log
 /u01/app/oracle/oradata/portdba/redo02.log
 ...
Pärit leheküljelt "https://kuutorvaja.eenet.ee/w/index.php?title=Oracle_10.1.2_iAS_metadata_repository_ettevalmistamine&oldid=8813"