One of the RAC decomposition steps to install the Oracle 10.2.0.1.0 Operations log on the Oracle Linux 4U4

Practicing Oracle's RAC build process, the first step is to practice installing Oracle 10.2.0.1.0 on 4U4 first. Installing RAC directly is somewhat difficult. From a simple start. For the total RAC Step, refer to the RAC form of the teacher.

1. Start VC, login vsphere 5.1,

2. Create a new virtual machine, Redhat 4 32bit compatible virtual machine, memory 1G, HDD 30G. Remove the floppy drive and select the optical drive as an ISO image file.

3. Start the virtual machine, select English, select the American keyboard, select Custom, and choose your own manual partitioning. Partitions are 2, one swap,2100m, the primary partition is forced, the other is ext3, and all other free space is available.

4. Network configuration, cancel DHCP, IP set to 192.168.7.140,netmask to 255.255.255.0,gateway for 192.168.7.166,dns to 114.114.114.114.

5. No Firewall,selinux is active.

6. Default language is English USA, click Chinese RPC at the same time. , in order to be more stable in the future, choose English as the preferred language.

7. Time zone select Shanghai, use UTC clock.

8. Set the password, admin123

9. Select Software

A. Click on the Editors of application.

B. Click on Development's development Tools

C. Click the Sysstat of System Tools

Next, start the installation, and then follow the prompts to insert 2.3 disks.

11. After completion, when installing Oracle, will be prompted missing Libaio files, in all the selected packages, I checked 2 sides, did not find the parent layer of the Libaio file, after the installation is complete, from the third disk, there are libaio files, This file is used for asynchronous IO read and write.

12. Initialize the Linux login for the first time, with a resolution of 800x600, select No when establishing the system user. Enter Linux, at this time prompted to install additional disk, skip, here is unable to install Libaio.

13. Install the Libaio file, on the third disk, Mount/dev/hdc/cdrom, RPM-IVH libaio-0.3.105.rpm

14. Install the vmware-tools and enhance the virtual machine tools. After decompression, in the Vmware-tools-distrib directory, #./vmware-install.pl, all the way to enter, the default installation can be. Resolution of the selected 800x600. Modify the configuration again, which is available in the install directory.

15. Run, pietty file, root telnet

16. On Linux, configure the Modify environment

modifying control files

Vim/etc/sysctl.conf

1 Kernel.shmmax = 536870912 2 Kernel.shmmni = 8192 3 Kernel.sem =250 32000 4 Fs.file-max = 6815744 5 net.ipv4.ip_l  Ocal_port_range =  65000 6 net.core.rmem_default = 4194304 7 Net.core.rmem_max = 4194304 8 Net.core.wmem_default = 262144 9 Net.core.wmem_max = 104857610 Fs.aio-max-nr = 1048576

Modify the license file,

Vim/etc/security/limits.conf

Oracle  Soft  nproc  2047Oracle  hard  nproc  16384oracle  soft  nofile 1024 Oracle  hard  nofile 65536  

Modify the Login file

Vim/etc/pam.d/login

Session     required        pam_limits.so

Modify Host Name

Vim/etc/hosts

192.168.7.140        ora.tralinhotel.cn    ora

Set hostname

#hostname RAC

Set up user groups and users, and their passwords

Groupadd oinstallgroupadd dbagroupadd opergroupadd asmadminuseradd-g oinstall-g dba,oper,asmadmin oraclepasswd Oracle

Building the directory structure

Mkdir-p/u01/app/oracle/product/10.2.0/mkdir/u01/oradatachmod-r 755/u01chown-r oracle.oinstall/u01 

modifying environment variables

Vim/home/oracle/.bash_profile

Export tmp=/tmpexport tmpdir=$TMPexport oracle_base=/u01/app/oracleexport oracle_home= $ORACLE _base/ product/10.2.0/export oracle_sid=oraexport path= $PATH: $ORACLE _home/bin:/usr/local/sbin:/usr/local/  Binexport ld_library_path= $ORACLE _home/lib:/lib:/usr/lib:/usr/local/libexport class_path= $ORACLE _home/jre:$ Oracle_home/jlib: $ORACLE _home/rdbms/jlib#export lang= "ZH_CN. UTF-8 "export oracle_term=vt100if [$USER =" ORACLE "], then if [$SHELL ="/bin/ksh "], then ulimit-p 1638 4 ulimit-n 65536 else ulimit-u 16384-n 65536 Fifi           

Language Options commented out Simplified Chinese, default to English

Immediate effect:

Download Oracle 10.2.0.1.0

Switch to Oracle user,

Su- oraclewget ftp://sdgtxuyong:[email Protected]/tools/database/oracle10/linux_32/10201_database_ Linux32.zipunzip 10201_database_linux32.zip

Reboot, restart. -----<<<<

To the UI interface, open Xhost + with root

#xhost +

Switch to Oracle user and start installing Oracle

Su- oraclecd database./runinstaller

In database Configuration Assistant, Password management ... in management

Modify the user lock to unlock Scott.

Log in with Pietty,root, run the following script file,

/u01/app/oracle/orainventory/orainstroot.sh

/u01/app/oracle/product/10.2.0/root.sh

Tips:

Isql*plus URL:

Http://ora.tralinhotel.cn:5560/isqlplus

Isql*plus DBA URL:

Http://ora.tralinhotel.cn:5560/isqlplus/dba

Enterprise Manager 10g Database Control URL:

Http://ora.tralinhotel.cn:1158/em

At this point, if the installation is smooth, it is finished.

After installation, with Oracle user, after entering Sqlplus, cannot startup Nomount. Tip Missing Initora.ora file. In the admin directory in the Pfile directory has a backup of the Ora control file, but at this time after the copy, can not be used, the reason is that Linux started a lot of lock files, so that the Ora file can not be loaded,

Restart reboot. Clears the lock file.

Then use the Oracle user login to copy the admin directory under the Pfile Init.ora. Timestamp, to the/dbs directory. After logging in with Sqlplus/as SYSDBA, start startup open to load the database successfully

17. Follow-up installation of the Help file, and the page Assist tool.

After logging in as SYSDBA, after starting the database,

@?/sqlplus/admin/help/hlpbld.sql Helpus.sql

Usage: Help shutdown

After logging in with the root user, install the sqlplus page patch

wget ftp://sdgtxuyong:[email Protected]/tools/database/oracle11/rlwrap-0.37.tar.gztar zxvf rlwrap-0.37.tar. gz. /configure&&makemake Install# echo ' Alias sqlplus= ' Rlwrap sqlplus ' >>/home/oracle/.bash_profile 

Immediate effect,/sbin/sysctl-p

With Oracle User login, Sqlplus/as sysdba, database startup Nomount, ALTER DB MOUNT, ALTER databases Open

Test with SQL,

Select username from user_users;

One of the RAC decomposition steps to install the Oracle 10.2.0.1.0 Operations log on the Oracle Linux 4U4