Notes on installing Oracle 10.2.0.1.0 on Oracle Linux 4u4

Notes on installing Oracle 10.2.0.1.0 on Oracle Linux 4u4

Exercise the Oracle RAC formation process. Step 1: First practice installing Oracle 10.2.0.1.0 on Oracle Linux 4u4. It is difficult to directly install RAC. Start from simple. For the overall RAC steps, refer to the RAC set up by instructor Xiao Bu.

1. Start vc and log on to vsphere 5.1,

2. Create a new virtual machine, RedHat 4 32bit compatible virtual machine, 1 GB memory, 30 GB hard disk. Remove the floppy drive and select the optical drive as an ISO image file.

3. Start the VM, select English, select the American keyboard, select custom, and select your own manual partition. There are two partitions, one is swap, 2100 M, the primary partition is forced, the other is ext3, all other available space.

4. network configuration. disable DHCP. set IP to 192.168.7.140, Netmask to 255.255.255.0, Gateway to 192.168.7.166, and DNS to 114.114.114.114.

5. No firewall, Selinux is active.

6. The default language is USA, and select chinese RPC ., For future stability, English is the preferred language.

7. Select Shanghai as the time zone and use the UTC clock.

8. Set the password, admin123

9. select Software

A. Click Editors of Application.

B. Click Development Tools.

C. Click sysstat of System Tools.

10. Next, start installation, and insert 2.3 disks as prompted.

11. after following the instructions, when installing oracle, the system will prompt that the libaio file is missing. In all the selected packages, I checked the two sides and did not find the parent layer of the libaio file, after the installation is complete, there will be a libaio file on the third disk, which is used for asynchronous io read/write.

12. For the first linux Login initialization, the resolution is 800x600. When creating a System User, select No. In linux, the system prompts you to install the additional disk and skip it. Here, libaio cannot be installed.

13. Install the libaio file, on the third Disk, mount/dev/hdc/cdrom, rpm-ivh libaio-0.3.105.rpm

14. Install vmware-tools and enhance virtual machine tools. After decompression, In the vmware-tools-distrib directory, #./vmware-install.pl, all the way to press enter, the default installation can be. Select 800x600 for resolution. Modify the configuration again in the install directory.

15. Run the Pietty file and log on remotely as the root user.

16. On linux, modify the configuration Environment

Modify Control File

Vim/etc/sysctl. conf

1 kernel. shmmax = 536870912
2 kernel. shmmni = 8192
3 kernel. sem = 250 32000 100 128
4 fs. file-max = 6815744
5 net. ipv4.ip _ local_port_range = 1024 65000
6. net. core. rmem_default = 4194304
7 net. core. rmem_max = 4194304
8 net. core. wmem_default = 262144
9 net. core. wmem_max = 1048576
10 fs. aio-max-nr = 1048576

 

Modify the license file,

Vim/etc/security/limits. conf

Oracle soft nproc 2047
Hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536

Modify login file

Vim/etc/pam. d/login

Session required pam_limits.so

Modify host name

Vim/etc/hosts

192.168.7.140 ora.tralinw..cn ora

Set hostname

# Hostname rac

Create user groups and users and their passwords

Groupadd oinstall
Groupadd dba
Groupadd rule
Groupadd asmadmin
Useradd-g oinstall-G dba, role, asmadmin oracle
Passwd oracle

Create a directory structure

Mkdir-p/u01/app/oracle/product/10.2.0/
Mkdir/u01/oradata
Chmod-R 755/u01
Chown-R oracle. oinstall/u01

 

Modify Environment Variables

Vim/home/oracle/. bash_profile

 

Export TMP =/tmp
Export TMPDIR = $ TMP
Export ORACLE_BASE =/u01/app/oracle
Export ORACLE_HOME = $ ORACLE_BASE/product/10.2.0/
Export ORACLE_SID = ora
Export PATH = $ PATH: $ ORACLE_HOME/bin:/usr/local/sbin:/usr/local/bin
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/local/lib
Export CLASS_PATH = $ ORACLE_HOME/JRE: $ ORACLE_HOME/jlib: $ ORACLE_HOME/rdbms/jlib
# Export LANG = "zh_CN.UTF-8"
Export ORACLE_TERM = vt100
If [$ USER = "oracle"]; then
If [$ SHELL = "/bin/ksh"]; then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Fi

The language option is commented out in simplified Chinese. The default value is English.

Effective immediately:

/Sbin/sysctl-p

Download oracle 10.2.0.1.0

Switch to the oracle user,

Su-oracle
Wget ftp: // sdgtxuyong: [email protected]/tools/database/oracle10/linux_32/10201_database_linux32.zip
Unzip 10201_database_linux32.zip

 

Reboot, restart. ----- <

Go to the UI and use root to enable xhost +

# Xhost +

Switch to the oracle user and start installing oracle

Su-oracle
Cd database
./RunInstaller

In Database Configuration Assistant, Password management... management

Modify the user lock and unlock scott.

Use Pietty and root to log on and run subsequent script files,

/U01/app/oracle/oraInventory/orainstRoot. sh

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

Tip:

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

If the installation is successful, the installation is complete.

After the installation is complete, the oracle user cannot start up nomount after entering sqlplus. The initora. ora file is missing. The pfile directory in the admin directory contains a backup ora control file, which cannot be used after being copied. The reason is that many lock files have been started in linux, making the ora file unable to be loaded,

Restart reboot. Clear the lock file.

Then, log on to the oracle user and copy the init. ora. timestamp under pfile In the admin directory to the/dbs directory. After logging in with sqlplus/as sysdba, start startup open to load the database.

17. Install the help file and paging auxiliary tools later.

After logging in as sysdba and starting the database,

@? /Sqlplus/admin/help/hlpbld. SQL helpus. SQL

Usage: help shutdown

Install the SQL plus paging patch after logging on with the root user

Wget ftp: // sdgtxuyong: [email protected]/tools/database/oracle11/rlwrap-0.37.tar.gz
Tar zxvf rlwrap-0.37.tar.gz
./Configure & make
Make install
# Echo 'Alias sqlplus = "rlwrap sqlplus" '>/home/oracle/. bash_profile

Effective immediately,/sbin/sysctl-p

Use an oracle user to log on, sqlplus/as sysdba, and set the database to startup nomount, alter database mount, and alter database open

SQL for testing,

Select username from user_users;