Use bare devices to install oracle10g databases on aix

Use bare devices to install oracle10g Database on aix I. Check System Information

[root@aix222 /]# oslevel -r5300-08[root@aix222 /]# prtconf | grep -i memMemory Size: 1904 MBGood Memory Size: 1904 MB…[root@aix222 /]# lsattr -El mem0goodsize 1904 Amount of usable physicalmemory in Mbytes Falsesize    1904 Total amount of physical memory in Mbytes  False[root@aix222 /]# prtconf | more…Processor Implementation Mode: POWER 5Processor Version: PV_5_2Number Of Processors: 2Processor Clock Speed: 1898 MHzCPU Type: 64-bitKernel Type: 64-bitLPAR Info: 1 10-0884GMemory Size: 1904 MBGood Memory Size: 1904 MBPlatform Firmware level: SF240_382Firmware Version: IBM,SF240_382…[root@aix222 /]# bootinfo -K64[root@aix222 /]# lsps –a…[root@aix222 /]# lsps –s…

 

Ii. View software packages and install patches

[Root @ aix222/] # lslpp-l | grep bos. adt [root @ aix222/] # lslpp-l | grep-I xlc. rte [root @ aix222/] # lslpp-l | grep-I xlc [root @ aix222/] # lslpp-l | grep-I bos. oracle10g on perfAix requires the following software package Bos. adt. baseBos. adt. libBos. adt. libmBos. pref. libperfstatBos. perf. perfstatBos. perf. proctoolsXlc. aix50.rtexlC. view the Patch [root @ aix222/] # instfix-ik IY58143 [root @ aix222/] # instfix-ik IY59386 [root @ aix222/] # instfix-ik IY60930 [root @ aix222/] # instfix-ik IY66513 [root @ aix222/] # instfix-ik IY70159 [root @ aix222/] # instfix-ik IY68989

 

3. Configure System Parameters

[root@aix222 /]# smit systemChange / Show Characteristics of OperatingSystem =>Maximum number of PROCESSES allowed peruser       [2048][root@aix222 /]# smit chaioMINIMUM number of servers                          [1]MAXIMUM number of servers per cpu                  [10]maximum number of REQUESTS                         [4096]server PRIORITY                                    [39]STATE to be configured at systemrestart            availableState of fast path                                  enable

 

4. create user Groups and user Groups: oinstall, dba Users: oracle use smit to add 5. Configure the. profile of the oracle user

[oracle@aix222 ~]$ vi .profile…ORACLE_BASE=/u01/app/oracleORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1ORACLE_SID=siqianPATH=$PATH:$ORACLE_HOME/binexport ORACLE_BASE ORACLE_HOME ORACLE_SID PATHexport EDITOR=viexport DBCA_CONFIG=/home/oracle/raw_mp.txt

 

6. Create an lv using an existing vg

[Root @ aix222/] # mklv-y 'system'-t 'raw 'datavg3 32 the lp size here is 32 mb, that is, the lv size of system is 1 gb. [Root @ aix222/] # mklv-y 'sysaux '-t 'raw' datavg3 32 [root @ aix222/] # mklv-y 'users'-t 'raw 'datavg3 16 [root @ aix222/] # mklv-y 'example '-t 'raw' datavg3 5 [root @ aix222/] # mklv-y 'undotbs '-t 'raw' datavg3 16 [root @ aix222/] # mklv-y 'temp '-t 'raw' datavg3 10 [root @ aix222/] # mklv-y 'control01'-t 'Raw' datavg3 2 [root @ aix222/] # mklv-y 'control02'-t 'raw 'datavg3 2 [root @ aix222/] # mklv-y' co Ntrol03 '-t 'raw' datavg3 2 [root @ aix222/] # mklv-y 'spfile'-t 'raw 'datavg3 1 [root @ aix222/] # mklv-y' redo01a '-t 'raw' datavg3 5 [root @ aix222/] # mklv-y 'redo01b '-t 'raw' datavg3 5 [root @ aix222/] # mklv-y' redo02a '-t' raw' datavg3 5 [root @ aix222/] # mklv-y 'redo02b '-t 'raw' datavg3 5 [root @ aix222/] # mklv-y' redo03a '-t 'Raw' datavg3 5 [root @ aix222/] # mklv-y 'redo03b'-t 'Raw' datavg3 5 7. Configuration Set the ing file [oracle @ aix222 ~] $ Vi raw_mp.txtsystem =/u01/app/oracle/oradata/siqian/system01.dbfsysaux =/u01/app/oracle/oradata/siqian/Baidu =/u01/app/oracle/oradata/siqian /users01.dbfexample =/u01/app/oracle/oradata/siqian/example01.dbfundotbs1 =/u01/app/oracle/oradata/siqian/Hangzhou =/u01/app/oracle/oradata/siqian/ region =/u01/app/oracle/oradata/siqian/control01.ctlcontrol2 =/u01/app/oracle/oradata/siqian/control02.ctlcontrol3 =/u01/app/oracle/oradata/siqian/Region _ 1 =/u01/app/oracle/oradata/siqian/redo01a. logredo1_2 =/u01/app/oracle/oradata/siqian/redo01b. logredo2_1 =/u01/app/oracle/oradata/siqian/redo02a. logredo2_2 =/u01/app/oracle/oradata/siqian/redo02b. logredo3_1 =/u01/app/oracle/oradata/siqian/redo03a. logredo3_2 =/u01/app/oracle/oradata/siqian/redo03b. logspfile =/u01/app/oracle/oradata/siqian/spfilesiqian. ora

 

8. Run the configuration bare setting permission under root:

chown oracle:oinstall /dev/rsystemchown oracle:oinstall /dev/rsysauxchown oracle:oinstall /dev/ruserschown oracle:oinstall /dev/rexamplechown oracle:oinstall /dev/rundotbschown oracle:oinstall /dev/rtempchown oracle:oinstall /dev/rcontrol01chown oracle:oinstall /dev/rcontrol02chown oracle:oinstall /dev/rcontrol03chown oracle:oinstall /dev/rspfilechown oracle:oinstall /dev/rredo01achown oracle:oinstall /dev/rredo01bchown oracle:oinstall /dev/rredo02achown oracle:oinstall /dev/rredo02bchown oracle:oinstall /dev/rredo03achown oracle:oinstall /dev/rredo03b

 

9. Create a link for the bare configuration (devices starting with r)

ln -s /dev/rsystem /u01/app/oracle/oradata/siqian/system01.dbfln -s /dev/rsysaux/u01/app/oracle/oradata/siqian/sysaux01.dbfln -s /dev/rusers/u01/app/oracle/oradata/siqian/users01.dbfln -s /dev/rexample/u01/app/oracle/oradata/siqian/example01.dbfln -s /dev/rundotbs /u01/app/oracle/oradata/siqian/undotbs01.dbfln -s /dev/rtemp/u01/app/oracle/oradata/siqian/temp01.dbfln -s /dev/rcontrol01/u01/app/oracle/oradata/siqian/control01.ctlln -s /dev/rcontrol02/u01/app/oracle/oradata/siqian/control02.ctlln -s /dev/rcontrol03/u01/app/oracle/oradata/siqian/control03.ctlln -s /dev/rspfile/u01/app/oracle/oradata/siqian/spfilesiqian.oraln -s /dev/rredo01a/u01/app/oracle/oradata/siqian/redo01a.logln -s /dev/rredo01b/u01/app/oracle/oradata/siqian/redo01b.logln -s /dev/rredo02a/u01/app/oracle/oradata/siqian/redo02a.logln -s /dev/rredo02b/u01/app/oracle/oradata/siqian/redo02b.logln -s /dev/rredo03a/u01/app/oracle/oradata/siqian/redo03a.logln -s /dev/rredo03b/u01/app/oracle/oradata/siqian/redo03b.log

 

10. Add two parameters to the DBCA Database: control_filesand spfile. enter the correct value and import raw_mp.txt to the database.