Install Oracle 10g (10.2.0.1.0) on Red Hat enterprice linux4)

Install Oracle 10g (10.2.0.1.0) on Red Hat enterprice linux4)

Step 1 Preparation

? Check memory
Sz_tomcat:/home/xjy/soft> grep swaptotal/proc/meminfo
Swaptotal: 2031608 KB

? Check the kernel
Linux reaky.com 2.6.9-5. elsmp #1 SMP wed Jan 5 19:30:39 est 2005 i686 i686 i386 GNU/Linux

? Check the Software Package
Sz_tomcat:/home/xjy/soft> rpm-q gcc make binutils glibc libaio
Gcc-3.4.3-9.EL4
Make-3.80-5
Binutils-2.15.92.0.2-10.EL4
Glibc-2.3.4-2
Libaio-0.3.102-1

Sz_tomcat:/home/xjy/soft> rpm-Q openmotif
Openmotif-2.2.3-6.RHEL4.2
Setarch-1.6-1

Check Kernel Parameters
Sysctl-

Then add
Kernel. Shmall = 2097152
Kernel. shmmax = 2147483648
Kernel. shmmni = 4096
Kernel. SEM = 250 32000 100 128
FS. File-max = 65536
Net. ipv4.ip _ local_port_range = 1024 65000
Net. Core. rmem_default = 262144
Net. Core. rmem_max = 1048576
Net. Core. wmem_default = 262144
Net. Core. wmem_max = 1048576

Run/sbin/sysctl-P

 

Cultural Display Work

Modify the/etc/sysconfig/i18n file
Lang = "zh_cn.gb18030"
Language = "zh_cn.gb18030: zh_cn.gb2312: zh_cn"
Zh_CN.UTF-8: zh_cn: Zh: en_us.utf-: en_us: en"
Sysfont = "lat0-sun16" Modify the/etc/sysconfig/i18n file
Lang = "zh_cn.gb18030"
Language = "zh_cn.gb18030: zh_cn.gb2312: zh_cn"
Zh_CN.UTF-8: zh_cn: Zh: en_us.utf-: en_us: en"
Sysfont = "lat0-sun16"

Step 2:
? Create user
Su-Root
[Root @ reaky etc] # groupadd DBA
[Root @ reaky etc] # groupadd oinstall
[Root @ reaky etc] # useradd-c "Oracle software owner"-G oinstall-g dba Oracle

? Set Environment
Edit/home/Oracle/. bash_profile
#. Bash_profile
# Get the aliases and functions
If [-f ~ /. Bashrc]; then
.~ /. Bashrc
Fi
# User specific environment and startup programs
Alias ls = 'LS-CF'
PS1 = 'sz _ Tomcat: $ PWD> '; export PS1
Umask 022
Set-O vi
Stty intr '^ C'
Stty-istrip
# If [$ user = "oracle"]; then
# If [$ shell = "/bin/KSh"]; then
# Ulimit-P 16384
# Ulimit-N 65536
# Else
# Ulimit-u 16384-N 65536
# Fi
# Fi
Editor = VI; export Editor
Temp =/tmp; export temp
Tmpdir =/tmp; export tmpdir
### Setup Oracle environment ###
Oracle_sid = ora10; export oracle_sid
Oracle_base =/home/Oracle; export oracle_base
ORACLE_HOME =/home/Oracle/product/10.2.0; export ORACLE_HOME
Oracle_term = ANSI; export oracle_term
Java_fonts =/usr/share/fonts/zh_cn/TrueType/; export java_fonts
Nls_lang = american_america.zhs16gbk; export nls_lang
LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib LD_LIBRARY_PATH = $ LD_LIBRARY_PATH:/usr/local/lib
Export LD_LIBRARY_PATH
Classpath = $ ORACLE_HOME/JRE: $ ORACLE_HOME/jlib: $ ORACLE_HOME/rdbms/jlib
Classpath = $ classpath: $ ORACLE_HOME/Network/jlib
Export classpath
Path =.: $ ORACLE_HOME/bin: $ path
Export path
### For Oracle install ###
Export lc_all = "en_us"
Export lc = "en_us"

 

Step 3: Install Oracle10g

1. Start Oracle general installation
Log on to Linux as an oracle user and load the Oracle Oracle10g CD. Before running the runinstaller, make sure that the Oracle environment variable has been set. Run the following command to check the environment variable settings:
Oracle user login
$ Set
In the terminal command window, run the following command to start Oracle10g installation:
Oracle $/mnt/CDROM/runinstaller
2. Click "Next" on the welcome window.
3. Specify the inventory path and Authentication Window:
Inventory path:/home/Oracle/orainventory
Specify the operating system group name: oinstall
Click "Next ".
4. A window will pop up to execute the orainstroot. Sh script:
Open another terminal and run the following command as the root user:
Su-Root
CD/home/Oracle/orainventory
./Orainstroot. Sh
Switch to the Oracle installation window and click "continue ".
5. After the window pops up for the specified file location, specify the corresponding path:
Source:
Path:/mnt/CDROM/stage/products. xml
Purpose:
Name: oradb10g_home1
Path:/home/Oracle/product/10.1.0/db_1
Then, click "Next ".
6. Select the installation type:
Select "Enterprise Edition" and click "Next. Setup verifies that the system meets all minimum requirements for installing and configuring the selected product
7. The installer verifies that the system meets all the minimum requirements for installing and configuring the selected product. After the detection is complete and successful, click "Next ".
8. Select database settings:
Select the "General" option and click "Next ".
9. Specify database configuration parameters:
Global Database Name: "test ".
Sid: "test ".
Select the "Create Database with sample solution" check box, and then click "Next ".
10. Select database management settings:
Select "Use Database Control to manage databases ".
Then, click "Next"
11. Specify database file storage options
Select "File System.
Specify the database path:/home/Oracle/oradata/
Click "Next,
12. Specify backup and recovery options:
Select "Disable Automatic Backup ".
Click "Next ".
13. Specify the database scheme password:
You can specify a password for sys, system, sysman, or Dbsnmp, or select the "All users use the same password" option to specify the same password for these users.
Do not start with a number for the specified password. Otherwise, an error message is displayed. Then, click "Next ".
14. After the overview window appears, click "Install ".
15. Then, you will see the database installation window, the auxiliary settings window appears, and the database creation window appears.
16. After the database is created, the database creation completion window is displayed. Click OK.
When a window for executing the root. Sh script is displayed, execute the following command on another terminal:
Su-Root
CD/home/Oracle/product/10.1.0/db_1
./Root. Sh
Click OK.

17. After the installation is complete, a file named $ oracle_base/product/10.1.0/db_1/portlist. INI is reported. Click OK.
18. installation is complete:
Click "exit" to end the installation program.
6. Start and Stop a database
To start the database, run the following command:
Oracle $ sqlplus/nolog
SQL> connect/As sysdba
SQL> startup
To stop the database, run the following command:
Oracle $ sqlplus/nolog
SQL> connect/As sysdba
SQL> Shutdown
 

 

 

 

Delete Oracle10g
If an error occurs during oracle10ganzhuang and you need to reinstall it, run the following command to delete the previously installed ORACLE:
Su-Oracle
Rm-RF/home/Oracle /*
Rm-F/etc/orainst. Loc/etc/oratab/etc/Oracle
Su-Root
Export ORACLE_HOME =/home/Oracle/product/10.1.0/db_1
$ ORACLE_HOME/bin/localconfig Delete
Rm-F/etc/inittab.css d
Rm-F/usr/local/bin/coraenv/usr/local/bin/dbhome
Rm-F/usr/local/bin/oraenv
After executing the preceding command, restart the system and reinstall the Oracle10g Database System.

 

 

 

 

 

 

 

 

 

 

 

FAQ (FAQs about Oracle Installation on Linux)
1. The installation interface cannot be started.
The prompt message for running runinstaller is as follows:
Xlib: connection to "localhost: 0.0" refused by Server
Xlib: client is not authorized to connect to server
Exception in thread "Main" Java. Lang. internalerror:
Can't connect to X11 window server using "localhost: 0.0" .......
Solution: Set your display environment parameters.
# Export display = your_ipaddress: 0.0
Replace your_ipaddress with your IP address. Or use root to execute # xhost + (note that this will pose security risks)
2. Many garbled characters are displayed on the installation interface.
Solution: view the locale output
# Locale
Lang = en_US.UTF-8
Lc_ctype = zh_cn.gb18030
Lc_numeric = "en_US.UTF-8"
Lc_time = "en_US.UTF-8"
Lc_collate = "en_US.UTF-8"
Lc_monetary = "en_US.UTF-8"
Lc_messages = "en_US.UTF-8"
Lc_paper = "en_US.UTF-8"
Lc_name = "en_US.UTF-8"
Lc_address = "en_US.UTF-8"
Lc_telephone = "en_US.UTF-8"
Lc_measurement = "en_US.UTF-8"
Lc_identification = "en_US.UTF-8"
Lc_all =
Execute # export lc_ctype = en_US.UTF-8 and then re-call the installer.
3. garbled em logs on Linux servers using IE
Oracle 10 Gb is successfully installed in Linux (UNIX) environment, and EM 10 Gb is logged on from IE browser in Windows. The button is a box like "Mouth.
Solution: refer:
Http://www.dbanotes.net/Oracle/Oracle-10g-font.properties.htm
4. A ORA-03113 error occurred while creating the database
Solution: Check whether the core parameters are correctly adjusted. refer:
Http://www.dbanotes.net/Oracle/ORA-03113.htm
5. How can I install a RedHat 9/FC1 or another 10 Gb system?
Solution: Install 10 Gbit/s on Linux distributions that are not supported by 10 Gbit/s.
1). Run runinstaller-ignoresysprereqs to skip the check.
2). From www.puschitz.com to modify the/etc/RedHat-release file:
# Su-Root
# Cp/etc/RedHat-release/etc/redhat-release.backup
# Cat>/etc/RedHat-release <EOF
Red Hat Enterprise Linux as Release 3 (taroon)
EOF
After installation, perform the following operations:
# Su-Root
# Cp/etc/redhat-release.backup/etc/RedHat-release
3). http://www.dbanotes.net/Oracle/10G-Beta-Install-Bug.htm
In the same way, we can modify the install/oraparam. ini file of Oracle for the purpose.
6. How do I disable the ocssd. Bin processes?
Solution: edit the/etc/inittab file (back up)
Comment out this line:
H1: 3: respawn:/etc/init. d/init.css D run>/dev/null 2> ................
Bytes ---------------------------------------------------------------------------------------------------------------------
References
Http://blog.csdn.net/itsdn/archive/2007/05/21/1619114.aspx
:
1. Install Oracle Database 10 GB on Linux x86
Http://www.oracle.com/technology/global/cn/pub/articles/smiley_10gdb_install.html#rhel3
2. Oracle 10gr2 + Redhat Enterprise Linux as4 Installation
Http://www.linuxdiyf.com/viewarticle.php? Id = 11578
3. Oracle 10g for Linux installation manual
Http://bbs.database.ccidnet.com/htm_data/27/0607/112610.html
4. Installing Oracle 10g on RHEL as 3 step-by-step
Http://www.dbanotes.net/Oracle/Install-Oracle10g-RHEL3.htm

/Etc/rc. d/init. d/dbora File Content
# Http://staff.in2.hr/denis/oracle/10g1install_fedora3_en.html#n4_4
# Chkconfig: 0356 95 1
# Description: init script to start/stop Oracle Database 10g, TNS Listener, EMS
#
#
# Match these values to your environment:
Export oracle_base =/u01/APP/Oracle
Export ORACLE_HOME = $ oracle_base/product/10.2.0/db_1
Export oracle_sid = cqrcdata
Export Path = $ path: $ ORACLE_HOME/bin
Export oracle_user = Oracle
# See how we are called:
Case $1 in
Start)
Dltelecom-"$ oracle_user"-c "$ ORACLE_HOME/bin/dbstart"
Dltelecom-"$ oracle_user"-c "$ ORACLE_HOME/bin/emctl start dbconsole"
Dltelecom-"$ oracle_user"-c "soracle_home/bin/isqlplusctl start"
;;
Stop)
Dltelecom-$ oracle_user-c "$ ORACLE_HOME/bin/LSNRCTL stop"
Dltelecom-$ oracle_user-c "$ ORACLE_HOME/bin/dbshut"
Dltelecom-$ oracle_user-c "$ ORACLE_HOME/bin/emctl stop dbconsole"
;;
*)
Echo "Usage: $0 {START | stop }"
;;
Esac