RedHat install Oracle 10g Release 2 on Linux as 4.0

Source: Internet
Author: User

3. Set System Parameters
Modify # vi/etc/sysctl. conf to add the following code:

Kernel. Shmall = 2097152
Kernel. shmmax = 2147483648
(Generally, you can set the maximum shared memory to half the physical memory. If the physical memory is 2 GB, you can set the maximum shared memory to 1073741824 (1g = 1024*1024*1024 ))

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 = 262144
Net. Core. wmem_default = 262144
Net. Core. wmem_max = 262144
Run the # sysctl-p command after modification to make the kernel change take effect immediately.

4. Set shell restrictions for oracle users:
A) edit the file: # vi/etc/security/limits. conf and add the following statement:
Oracle soft nproc 2047
Hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536
B) edit the file: # vi/etc/PAM. d/login and add the following statement:
Session required/lib/security/
C) edit the file: # Add the following statement to VI/etc/profile:
If [$ user = "oracle"]; then
If [$ shell = "/bin/KSh"]; then
Ulimit-P 16384
Ulimit-N 65536
Ulimit-u 16384-N 65536

5. Configure the Oracle user environment
Use an oracle user to log on:
# Su-Oracle
$ VI. bash_profile

The content of the configuration file is as follows:

#. Bash_profile

# Get the aliases and functions
If [-f ~ /. Bashrc]; then
.~ /. Bashrc
# User specific environment and startup programs

Umask 022
TMP =/tmp; export TMP
Tmpdir = $ TMP; export tmpdir
Export oracle_base =/opt/ora10
Export ORACLE_HOME =/opt/ora10/product/
Export Path = $ ORACLE_HOME/Apache/perl/bin: $ ORACLE_HOME/Apache/bin: $ path
Export oracle_owner = Oracle
Export oracle_sid = oradb
Export oracle_term = xterm
Unset Username

Iii. Installation Process
1. Restart the server to log on as an oracle user and start X-window for local installation.
# Su-Oracle
$ Startx
(I started from XWindow, So I skipped this step, but under root # xhost +)
Copy the Oracle10g CD file to the created installation folder (/tmp/Oracle. (If the download is enabled, copy 10201_database_linux_x86_64.cpio.gz to/tmp/oracle,
1. Unzip the file: gunzip <FILENAME>
2. Extract the file: cpio-idmv <FILENAME>
To the current directory)
2. Formal Installation
1) Click "Taskbar"> "application"> "System Tools"> "terminal ":
$/Tmp/Oracle/runinstaller (CD to/tmp/Oracle/$./runinstaller)

It is commendable that the 10g installation requires a checking Operating System Certification step compared to 9i. It is particularly practical. The installation file automatically detects the required conditions. If any, the installer will report the cause to you.
2) after a short period of time, the "Select installation method" Information Window appears. Click "Advanced installation (A)". To continue the installation, click "next (n; go to the "specify product list directory and ID card" window: confirm the complete path of the product list directory (d):/Oracle/orainventory; specify the operating system group name (s): oinstall; click "next (n)" to continue installation. In the "Select installation type" window, click "Enterprise Edition (e)". To continue installation, click "next (n; go to the "specify home directory details" window. Name (m): oradb10g_home1 path (a):/opt/Oracle/product/ To continue the installation, click "next (N) "button;
3) go to the "product-specific prerequisite check" window. after a short period of inspection, the following check information window will appear. In the "Checking Network Configuration Requirements" project, select the content of the status bar and click "next (n)" to continue the installation. In the "select Configuration Options" window, click "Create Database (c )", click "next (n)" to continue the installation. In the "select database configuration" window, click "general purpose (g)". To continue the installation, click "next (n) "press the key to go to the" specify Database Configuration Options "window; settings in the database name; Global Database Name: oradb Sid: oradb; database character set: Simplified Chinese zhs16gbk; to continue the installation, click "next (n;
4) in the "select database management options" window, click "manage database using Database Control". To continue the installation, click "next (n; in the "specify database storage options" window, click "File System", specify the database file location:/Oracle/product/10.2.0/oradata/, and click "next (n)" to continue the installation) "press the button. In the" specify backup and recovery options "window, click" do not enable automatic backup ". To continue installation, click" next (n; go to the "password of the specified database solution" window, click "all accounts use the same password", and enter the password. Click "next (n)" to continue the installation. In the "Overview" window, click "next (n)" to continue the installation. In the "installation" window, detailed installation is as follows: A. Installation part; B. copy file part; C. Connect to the data system part; D. Set the data system part;
5) enter the "configuration assistant" window: configuration: Oracle Database Configuration Assistant, a new window "Database Configuration assistant" will appear. Detailed configuration process: A. Copying database files; b. An Oracle instance is being created and started. c. A database is being created. After the preceding three parts are completed, a prompt window is displayed. Click OK.
6) configuration: iSQL * Plus is used to configure the auxiliary program. During the configuration process, a prompt window is displayed for executing the configuration script. Run the script on the terminal and run orainstroot. sh script process: click "Taskbar"> "application"> "System Tools"> "terminal ",
$ Su root (converted to the root Super User Environment) password: ****** (enter the root user password)
#/Opt/Oracle/orainventory/orainstroot. Sh (enter the detailed path for executing the script)
Detailed operation:
#/Opt/Oracle/product/ Sh (enter the detailed path for script execution)
Execution completed orainstroot. sh, Root. after the sh script is executed, close "superuser terminal" and return to the "execute configuration script" Prompt window. To continue the installation, click "OK" to go to the "installation ended" window, to exit the installer, click exit (X;

Iv. self-starting settings
Oracle 10 Gb needs to start the following services (for Oracle Users)
$ LSNRCTL start
$ Dbstart
$ Emctl start dbconsole
$ Isqlplusctl start
Therefore, the following configuration is required:
By default, dbstart does not work. The following configurations are required:
1. Modify/etc/oratab
$ VI/etc/oratab
Oradb:/opt/ora10/product/ Y (changed from N to Y)
2. Copy a system-configured pfile to the DBS directory.
# Cp/opt/ora10/admin/oradb/pfile/init. ora.2292007201045 $ ORACLE_HOME/dbs/init. ora (the $ ORACLE_HOME Path depends on the installation path)
Now you can test it.
$ Dbstart
Note: If the installation version is 10201, this error may occur:
Failed to auto-start Oracle Net listene using/Ade/vikrkuma_new/Oracle/bin/tnslsnr
Modify the 78th rows of dbstart ($ ORACLE_HOME/bin/dbstart)
Oracle_home_listner =/Ade/vikrkuma_new/Oracle
Oracle_home_listner = $ ORACLE_HOME

$ Dbshut

Add the following code to/etc/rc. d/rc. Local:
Su-Oracle-c "LSNRCTL start"
Su-Oracle-c "dbstart"
Su-Oracle-c "emctl start dbconsole"
Su-Oracle-c "isqlplusctl start"

In this way, Oracle will automatically start after the server is restarted.

5. Oracle 10 Gb settings
ISQL * Plus URL: Connection address: http: // server: 5560/isqlplus
ISQL * Plus dba url: Connection address: http: // server: 5560/isqlplus/DBA
Enterprise Manager 10g Database Control URL: Connection address: http: // server: 1158/em
Username: SYS
Password :******
Connection identity: sysdba
Click "I agree" to continue logging in;
# Su-Oracle
$ Startx

$ Netca enable network configuration Assistant
$ Sqlplus/nolog start sqlplus
$ Dbca start Database Configuration Assistant (DCA) and create an Oracle database

Other reference urls:
Install Oracle Database 10 GB on Linux x86

Oracle Database quick installation guide
10g Release 2 (10.2) for Linux x86-64

Installing Oracle Database 10g Release 1 and 2 (32-bit/64-bit) on Red Hat Enterprise Linux as 4, 3, 2.1, Red Hat Fedora Core 4, 3, 1, RH 9 on x86 and x86-64 (amd64/em64t) Architecture


Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.