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;