Oracle graphical and command line installation
Oracle Installation version description
Different Versions of Oracle must be installed on a specific system version.
For example, 11.2.0.1.0 of Oracle 11gR2 needs to be installed in CentOS 5.X and RHLE 5.X.
Hardware requirements
Physical Memory >= 1GSwap Space >= 2G (available)Temporary Space >= 400MB
Install dependent Libraries
yum -y install binutils compat-libstdc++ compat-libstdc++-33 elfutils-libelf-devel gcc gcc-c++ glibc-devel glibc-headers ksh libaio-devel libstdc++-devel make sysstat unixODBC-devel binutils-* compat-libstdc++* elfutils-libelf* glibc* gcc-* libaio* libgcc* libstdc++* make* sysstat* unixODBC*rpm -e kshyum install pdksh
Related parameter settings
Vi/etc/sysctl. conf
# Oracle Configurationkernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096# semaphors: semmsl, semmns, semopm, semmnikernel.sem = 250 32000 100 128net.core.rmem_default=262144net.core.wmem_default=262144fs.file-max = 6815744net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_max = 4194304net.core.wmem_max = 1048576# Oracle Configuration Endecho "1048576" >/proc/sys/fs/aio-max-nr
Oracle users
First create an Oracle user and install it under this user
Create steps (root permission required ):
$/usr/sbin/groupadd oinstall$/usr/sbin/groupadd dba$useradd –g oinstall -G dba -d /home/oracle -r oracle$mkdir -p /home/oracle$chown oracle:dba /home/oracle$passwd oracle
Use the id command to view user information
$id oracle
Output:
uid=504(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
The specific id data can be different.
Oracle Installation
Note: hard limit for maximum open file descriptors is set to at least 65536 can be ignored in Oracle check conditions.
Follow the installation steps.
Listener. ora Configuration
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /bank/oracle/oracle10g/product/10.2.0) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL DBNAME = orcl) (SID_NAME = orcl) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) )
Command line installation Initialization Configuration configuration db_install.rsp File Installation
./runInstaller -responseFile /home/oracle/database/response/db_install.rsp -silent -showProgress
Q &
- Problem: [FATAL] [INS-32037] The operating system group specified for central inventory (oraInventory) ownership is invalid.
Solution:
Set a group with the write oraInventory permission
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/home/oracle/oraInventory
- Problem: [FATAL] [INS-35071] Global database name cannot be left blank.
Solution: ORACLE_HOSTNAME = oracle1
- [FATAL] [INS-35071] Global database name cannot be left blank.
Solution:oracle.install.db.config.starterdb.globalDBName=oracle.sunyard
* Problem: [FATAL] [INS-35175] No value given for the allocated memory of the database
Solution:oracle.install.db.config.starterdb.memoryLimit=512
[FATAL] [INS-30501] Automatic Storage Management software is not configured on this system.
Configure Oracle Storage
- Problem: [FATAL] [INS-30004] The ADMIN password entered is invalid.
Solution: the password cannot contain @
[FATAL] [INS-35341] User is not a member of the following chosen OS groups
Solution:
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
Problem: sqlplus: error while loading shared libraries: libsqlplus. so: cannot open shared object file: No such file or directory
Solution: set the following configuration file:
# .bash_profileif [ -f ~/.bashrc ]; then . ~/.bashrcfi# for oracle iPATH=$PATH:$HOME/bin#oracle add export ORACLE_BASE=/home/oracle/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1export ORACLE_SID=orclexport PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
- Problem: ORA-xxxxx: Message xxx not found; no message file for product = RDBMS, facility = ORA
Solution: the ORACLE_HOME path, such as app/oracle, is not correctly set to/home/oracle/app/oracle.
Problem: sqlplus: error while loading shared libraries:/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh. so.11.1: cannot restore segment prot after reloc: Permission denied
Change selinux = disabled chcon-t texrel_shlib_t $ ORACLE_HOME/lib/*. so in/etc/sysconfig/SELINUX.
Refer:
Prerequisites for Oracle RAC in the Oracle document:
Http://docs.oracle.com/cd/B28359_01/nav/portal_6.htm
Oracle version and corresponding installation system:
Http://docs.oracle.com/cd/E11882_01/relnotes.112/e23558/toc.htm#CHDHCEFI
Relationship between CentOS and RedHat releases and Linux kernel versions:
For some operations, refer:
Http://www.tldp.org/LDP/solrhe/Securing-Optimizing-Linux-RH-Edition-v1.3/chap6sec72.html
Oracle 11g installation manual on RedHat Linux 5.8 _ x64 Platform
Installing Oracle 12C in Linux-6-64
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian