Oracle 10g Linux Installation notes

Oracle 10g Linux Installation notes

I. Create a user and a directory

1. Create user group
#/Usr/sbin/groupadd oinstall
#/Usr/sbin/groupadd DBA
2. Create a user and set a password
#/Usr/sbin/useradd-G oinstall-g dba Oracle
# Passwd Oracle
3. Create a directory (which can be divided into two subdirectories in one directory)
/Ora10g/APP/Oracle
/Ora10b/oradata
4. Set directory permission
# Chown-r ORACLE: oinstall/ora10g/APP/Oracle/ora10b/oradata
# Chmod-r 775/ora10g/APP/Oracle/ora10b/oradata

II. Configure Kernel Parameters
1. Check the kernel parameters in the following table. The current system parameter value is greater than or equal:
========================================================== ========================================================== ======================
Parameter | value | file | view command
----------------- + --------------- + ------------------------------- + ------------------------------
Semmsl | 250 |/proc/sys/kernel/SEM | #/sbin/sysctl-A | grep SEM
Semmns | 32000 |
Semopm | 100 |
Semmni | 128 |
----------------- + --------------- + -----------------------------
Shmall | 2097152 |/proc/sys/kernel/Shmall | #/sbin/sysctl-A | grep SHM
----------------- + --------------- + -----------------------------
Shmmax | half of the physical memory |/proc/sys/kernel/shmmax |
----------------- + --------------- + -----------------------------
Shmmni | 4096 |/proc/sys/kernel/shmmni |
----------------- + --------------- + -----------------------------
File-max | 65536 |/proc/sys/fs/file-max | #/sbin/sysctl-A | grep file-max
----------------- + --------------- + -----------------------------
Ip_local_port_range | 1024 65000 |/proc/sys/NET/IPv4/ip_local_port_range | # sysctl-A | grep ip_local_port_range
============================= ========================================================== ====================
If there are any differences, modify the Kernel configuration file/etc/sysctl. conf and run #/sbin/sysctl-P to make the configuration take effect immediately.

3. Set shell restrictions for oracle users
========================================================== ===================================================
Shell limit | item in limits. conf | hard limit
------------------------------------------- + --------------- + -----------------
Maximum number of open file descriptors | nofile | 65536
------------------------------------------- + --------------- + -----------------
Maximum number of processes available to a single user | nproc | 16384
========================================================== ===================================================
Add the following configuration to the/etc/security/limits. conf file:
* Soft nproc 2047
* Hard nproc 16384
* Soft nofile 1024
* Hard nofile 65536
Add the following configuration to the/etc/PAM. d/login file:
Session required/lib/security/pam_limits.so
Add the following script to the configuration file/etc/profile for the shell of an Oracle user separately:
If [$ user = "oracle"]; then
If [$ shell = "/bin/KSh"]; then
Ulimit-P 16384
Ulimit-N 65536
Else
Ulimit-u 16384-N 65536
Fi
Fi

4. Set Oracle environment variables
1. Log On As an oracle user:
Add umask 022 to the configuration file. bash_profile to set the user's default umask
Execute the $ ../. bash_profile configuration to take effect.
2. Set temporary file directory
$ Temp =/directory
$ Tmpdir =/directory
$ Export temp tmpdir
3. If it is not locally installed, set the DISPLAY variable so that the X Window can be displayed in the current system.
$ Display = Your IP: 0.0; export display
4. Set oracle_base and oracle_sid Variables
$ Oracle_base =/ora10g/APP/Oracle // This is the master program directory of Oracle created earlier
$ Oracle_sid = Sales
$ Export oracle_base oracle_sid
5. Check whether the ORACLE_HOME and tns_admin environment variables are not set. If any, delete them with unset ORACLE_HOME.

5. Let's get started. We can't do the previous work.
Run runinstaller to start Installation
Installation FAQ: If you are prompted that you do not have sufficient permissions, log on to start X using the guest El user. Do not use root startup to switch users in Su-Oracle mode.
The prompt cannot display the X Window. Check the previous display settings.
When garbled characters are displayed in the displayed window, change the following environment variables:
$ Export lang = en_US.UTF-8
$ Export lc_ctype = en_US.UTF-8
Installing Oracle 10g requires the Linux version. you can skip the 10g check on the supported system using the following parameters:
Runinstall-ignoresysprereqs
PS: I started to install the parameter on fc5. I don't know this parameter. I can't go through it, and I have reinstalled a red flag dc4 before I installed it ^_^.

 

Sat. Start Installation
1. Enter the CD-key and select the installation directory and user group. If the preceding environment variables are set correctly, the directory should be in the Set Oracle directory, and the user group should be oinstall.
2. Click Next and a window will pop up prompting you to run the orainstroot. Sh script. After a terminal is run as root, click Continue.
3. Click Next twice and select the installation type. Click Next to check the conditions required for installation. Then click Next.
4. Select to create a general database and click Next.
5. The oracle_sid we set previously appears in the database name. Select the corresponding character set and click Next. Here we choose to create an example database.
6. Click Next twice, select the database installation location, and select the/ora10g/oradata we created earlier.
7. Click "Next" twice to enter the password for managing the user and then click "Next.
8. Confirm the selection and click Install to start installation.
9. After the installation is complete, a window is displayed, showing the URL of the management tool. Click OK and a prompt is displayed asking to run the root. Sh script.
OK. installation is complete.

After the installation is complete, the URLs of some tools under the class type are displayed,
Ultra Search URL:
Http://localhost.localdomain: 5620/Ultrasearch

Ultra Search administration tool URL:
Http://localhost.localdomain: 5620/Ultrasearch/admin

ISQL * Plus URL:
Http://localhost.localdomain: 5560/isqlplus

Enteprise Manager 10g Database Control URL:
Http://localhost.localdomain: 5500/em

7. Start and Stop databases and tools
Set the following variables after logging on as an oracle user
Export oracle_base =/ora10g/APP/Oracle
Export oracle_sid = Sales
Export ORACLE_HOME = $ oracle_base/product/10.1.0/db_1
Export Path = $ path: $ ORACLE_HOME/bin

Start and Stop a listener:
LSNRCTL start
LSNRCTL stop

Start and Stop Oracle Enterprise Manager:
Emctl start dbconsole
Emctl stop dbconsole

Start and Stop iSQL * Plus
Isqlplusctl start
Isqlplusctl stop

Start and Stop a database
Start:
Sqlplus
Enter USR-Name:/As syadba
SQL> startup
Stop:
SQL> shutdown immediate