Install Oracle10g in Linux [personal notes]

1. Check System Software and Hardware configuration
 
2. Add related users and user groups
Add an Oracle Installation group: groupadd oinstal [Check whether an Oracle Installation group exists: More/etc/orainst. Loc]
Add Oracle DBA group: groupadd DBA [check whether the user group has grep DBA/etc/group]
Add Oracle user: useradd-G oinstall-g dba Oracle
Change Oracle password: passwd Oracle

3. Create corresponding folders and associated users [run with root users]:
Mkdir-P/Oracle/product
Mkdir-P/Oracle/oinstall
Chown-r ORACLE: oinstall/Oracle/product
Chown-r ORACLE: oinstall/Oracle/oinstall
Chmod-r 775/Oracle/product
Chmod-r 775/Oracle/oinstall

4. Configure the Oracle environment variables (File/home/Oracle/. bash_profile ):
ORACLE_HOME =/Oracle/product/10.1.0/db_1
Oracle_base =/Oracle/oinstall
Oracle_sid = rdpublic
Path = $ path: $ ORACLE_HOME/bin: $ home/bin

Export path ORACLE_HOME oracle_base oracle_sid
Display = Support-server: 0.0 # (support-server is the host name or IP address of the PC)

Export display
Unset Username

5. Modify system parameters (/etc/sysctl. conf) [run with root user]
---------------------------------
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
Rmem_default = 262144
Rmem_max= 262144
W mem_default = 262140034
Wmem_max= 262144
---------------------------------
Run the following command to make the change take effect.
Sysctl-P
Note: For rmem _ * values, an error is reported in Linux according to the official document. I changed to the following statement based on the previous values:
Net. Core. rmem_default = 262144
Net. Core. rmem_max = 262144
Net. Core. wmem_default = 262140034
Net. Core. wmem_max = 262144
######################################## ######################################## ######################################## #########

Bytes --------------------------------------------------------------------------------------------------------------------
Recommended Oracle parameters (refer to the official documentation)
Bytes --------------------------------------------------------------------------------------------------------------------
Parameter value File
Bytes --------------------------------------------------------------------------------------------------------------------
Semms l 250/proc/sys/kernel/SEM
Semmns 32000/proc/sys/kernel/SEM
Semopm 100/proc/sys/kernel/SEM
Semmni 128/proc/sys/kernel/SEM
Shmall 2097152/proc/sys/kernel/Shmall
Shmmax half the size of physical memory (inbytes)/proc/sys/kernel/shmmax
Shmmin 4096/proc/sys/kernel/shmmni
File-Max 65536/proc/sys/fs/file-max
Ip_local_port_range minimum: 1024 maximum: 65000/proc/sys/NET/IPv4/ip_local_port_range
Rmen_default 262144/proc/sys/NET/CORE/rmem_default
Rmen_max 262144/proc/sys/NET/CORE/rmem_max
Wmen_default 262144/proc/sys/NET/CORE/wmem_default
Wmen_max262144/proc/sys/NET/CORE/wmem_max


Bytes ----------------------------------------------------------------------------------------------------------------------
View System Parameters
Bytes ----------------------------------------------------------------------------------------------------------------------
Parameter command
Bytes ----------------------------------------------------------------------------------------------------------------------
Semmsl, semmns, semopm, semmni/sbin/sysctl-A | grep SEM this command displays the value of the semaphore parameters in the order listed.
Shmall, shmmax, shmmni/sbin/sysctl-A | grep SHM
File-max/sbin/sysctl-A | grep file-max
Ip_local_port_range/sbin/sysctl-A | grep ip_local_port_range
Rmem_default/sbin/sysctl-A | grep rmem_default
Rmem_max/sbin/sysctl-A | grep rmem_max
Wmem_default/sbin/sysctl-A | grep wmem_default
Wmem_max/sbin/sysctl-A | grep wmem_max
Bytes ----------------------------------------------------------------------------------------------------------------------

######################################## ######################################## ######################################## ###########
 
6. Set shell restrictions for oralce users
6.1 Configure/etc/security/limits. conf
Oracle soft nproc 2047
Hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536
6.2 Configure/etc/PAM. d/login
Session required/lib/security/pam_limits.so
6.3 configure the default Oracle shell startup file (/etc/profile)
If [$ user = "oracle"]; then
If [$ shell = "/bin/KSh"]; then
Ulimit-P 16384
Ulimit-N 65536
Else
Ulimit-u 16384-N 65536
Fi
Fi

7. Unzip the installation package [executed by oracle users]
Gunzip filename.cpio.gz
Cpio-idmv <FILENAME. cpio
8. Start Installation
8.1 use xmanager enterprise 3 and use oracle users to log on
8.2 switch to the Oracle installer directory./runinstaller. After a while, the GUI installation interface will appear. The installation method is the same as the GUI installation in windows. You only need to execute the corresponding shell script as prompted.
 

9. enable the Service

If the machine restarts, you may need to manually enable Oracle

 

Follow these steps to enable the Database Service:
A: enter as Oracle
B: Go to the oraproduct/bin directory.
C: Execute the start listening command: LSNRCTL start
D: Modify the SID value to be started: Export oracle_sid = dbname
(View available database instances in the oraproduct/DBS directory. Ls to see if all the extensions are. ora)
E: connect to the database using nolog: sqlplus/nolog
F: connect to sysdba again: connect/As sysdba
G: Execute the startup command: startup
PS: the first three steps are executed only once, and the last four steps can be repeated.