Oracle manual database creation

Install the Oracle client software:
Root Account execution:
# Groupadd oinstall
# Groupadd dba
# Useradd-g oinstall-G dba oracle
# Passwd oracle
Create an oracle basic directory:
# Mkdir-p/u01/app/oracle
# Chown-R oracle: oinstall/u01
# Chmod-R 775/u01
/U01 is owned by the root directory.
/U01/app is owned by the root directory.
/U01/app/oracle is owned by oracle: oinstall with 775 permissions. This ownership and permission allows OUI to create an oraInventory directory in the/u01/app/oracle/oraInventory path.
 
Configure Kernel Parameters
 
For Oracle Database 10g 2nd on RHEL/OEL 5, the kernel parameter settings shown below are required. The given values are the minimum values, so do not change them if your system uses a larger value:
 
# Vi/etc/sysctl
Kernel. shmmax = 4294967295
Kernel. shmall = 268435456
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 = 1048576
Net. core. rmem_max = 1048576
Net. core. wmem_default = 262144
Net. core. wmem_max = 262144
 
Start effective
# Sysctl-p
 
Set Shell restrictions for Oracle users
 
To improve the performance of software on Linux, Oracle recommends that you increase the shell restrictions of oracle users:
 
Shell limits the entry hard limit in limits. conf
Maximum number of opened file descriptors: nofile 65536
Maximum number of nproc processes per user: 16384
 
To make these changes, run the following command as the root user:
# Cat>/etc/security/limits. conf <EOF
Oracle soft nproc 2047
Hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536
EOF
 
# Cat>/etc/pam. d/login <EOF
Session required/lib/security/pam_limits.so
Session required pam_limits.so
EOF
 
Update the default shell Startup File for the "oracle" UNIX account.
 
For Bourne, Bash, or Korn shell, run the following command to add the following lines to the/etc/profile file:
# Cat>/etc/profile <EOF
If [\ $ USER = "oracle"]; then
If [\ $ SHELL = "/bin/ksh"]; then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Umask 022
Fi
EOF
 
# Su-oracle
Install the client:
Configure oracle environment variables:
$ Vi ~ /. Bash_profile
 
Export ORALCE_BASE =/u01/app/oracle
Export ORALCE_HOME = $ ORACLE_BASE/product/10.2.0/db_1
Export ORALCE_SID = orcl
Export PATH = $ ORACLE_HOME/bin: $ PATH
 
Effective environment variables:
$ Source ~ /. Bash_profile

1 2 Next Page