Imre: /* Märkused */

2008-10-14T05:38:24Z

Märkused

←Vanem redaktsioon		Redaktsioon: 14. oktoober 2008, kell 05:38
276. rida:		276. rida:
	===Märkused===		===Märkused===

	* Kui andmebaasile vastavad failid asuvad failisüsteemis sarnaselt, siis on tegu nn Regular ~~Files~~ storage tüübiga		* Kui andmebaasile vastavad failid asuvad failisüsteemis sarnaselt, siis on tegu nn Regular File System storage tüübiga

	$ find /u01/app/oracle/oradata/		$ find /u01/app/oracle/oradata/

Imre – 14. oktoober 2008, kell 05:37

2008-10-14T05:37:44Z

←Vanem redaktsioon		Redaktsioon: 14. oktoober 2008, kell 05:37
273. rida:		273. rida:

	[[Pilt:Mrca-rac-8.gif]]		[[Pilt:Mrca-rac-8.gif]]

			===Märkused===

			* Kui andmebaasile vastavad failid asuvad failisüsteemis sarnaselt, siis on tegu nn Regular Files 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
			...

Imre – 9. september 2008, kell 22:45

2008-09-09T22:45:30Z

@@ 245. rida: / 245. rida: @@
 [[Pilt:Mrca-rac-1-1.gif]]
 [[Pilt:Mrca-rac-2.gif]]
 [[Pilt:Mrca-rac-3.gif]]
 [[Pilt:Mrca-rac-4.gif]]
 [[Pilt:Mrca-rac-5.gif]]
 [[Pilt:Mrca-rac-6.gif]]
 [[Pilt:Mrca-rac-7.gif]]
 [[Pilt:Mrca-rac-8.gif]]

Imre: New page: ===MRCA paigaldamine=== MRCA abil MR skeemide laadimiseks olemasolevasse 10R2 andmebaasi tuleb teha sellised ettevalmistused, numbrid viitava Metalink'i (http://metalink.oracle.com/) noot...

2008-09-09T21:47:19Z

New page: ===MRCA paigaldamine=== MRCA abil MR skeemide laadimiseks olemasolevasse 10R2 andmebaasi tuleb teha sellised ettevalmistused, numbrid viitava Metalink'i (http://metalink.oracle.com/) noot...

Uus lehekülg

===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

* http://download.oracle.com/docs/cd/B14099_19/sol.1012/repca.1012/repca/toc.htm - Oracle® Application Server Metadata Repository Creation Assistant User's Guide
* 431665.1 - How to Obtain the Latest MRCA Information
* 362983.1 - MRCA 10.1.2.0.3 and Oracle Database 10g Release 2 (10.2)

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

[[Pilt:Mrca-inst-1.gif]]

ning moodustatakse kaks faili

[[Pilt: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

[[Pilt:Mrca-inst-3.gif]]

Keelevalikud, installeri kasutajaliidese keele osas

[[Pilt: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

[[Pilt:Mrca-inst-5.gif]]

Näidatakse tehtud otsustusi

[[Pilt:Mrca-inst-6.gif]]

Ja toimub tarkvara paigaldamine

[[Pilt: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.

[[Pilt:Mrca-inst-8.gif]]

Teatatakse, et paigaldus on lõppenud

[[Pilt:Mrca-inst-9.gif]]

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

[[Pilt: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

[[Pilt:Mrca-rac-1.gif]]

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

[[Pilt:Mrca-rac-1-1.gif]]
[[Pilt:Mrca-rac-2.gif]]
[[Pilt:Mrca-rac-3.gif]]
[[Pilt:Mrca-rac-4.gif]]
[[Pilt:Mrca-rac-5.gif]]
[[Pilt:Mrca-rac-6.gif]]
[[Pilt:Mrca-rac-7.gif]]
[[Pilt:Mrca-rac-8.gif]]

Oracle 10.1.2 iAS metadata repository ettevalmistamine - Redigeerimiste ajalugu

Imre: /* Märkused */

Imre – 14. oktoober 2008, kell 05:37

Imre – 9. september 2008, kell 22:45

Imre: New page: ===MRCA paigaldamine=== MRCA abil MR skeemide laadimiseks olemasolevasse 10R2 andmebaasi tuleb teha sellised ettevalmistused, numbrid viitava Metalink'i (http://metalink.oracle.com/) noot...