[Oracle 11g] Installation(silent mode) Oracle 11gR2(11.2.0.1) for CentOS 7

Pre-Installation: https://testtube.tistory.com/21

[Oracle 11g] Pre-Installation Oracle 11gR2(11.2.0.1) for CentOS 7

 

### orauser Permission ###

 

 

1. Download Installer and unzip

https://edelivery.oracle.com/

Oracle Software Delivery Cloud

 

# unzip V17530-01_1of2.zip
# unzip V17530-01_2of2.zip

 

 

2. DB Engine Installation

 

# cd database/response

# vi db_install.rsp
Line 29:
oracle.install.option=INSTALL_DB_SWONLY
Line 37:
ORACLE_HOSTNAME=MYSTUDY
Line 42:
UNIX_GROUP_NAME=oinstall
Line 47:
INVENTORY_LOCATION=/app/orauser/oracle/oraInventory
Line 78:
SELECTED_LANGUAGES=en,ko
Line 83:
ORACLE_HOME=/app/orauser/oracle/products/11.2.0
Line 88:
ORACLE_BASE=/app/orauser/oracle
Line 99:
oracle.install.db.InstallEdition=EE
Line 108:
oracle.install.db.isCustomInstall=false
Line 142:
oracle.install.db.DBA_GROUP=dba
Line 147:
oracle.install.db.OPER_GROUP=oper
Line 385:
DECLINE_SECURITY_UPDATES=true

저장

# cd ..
# ./runInstaller -silent -responseFile `pwd`/response/db_install.rsp -waitForCompletion

 

!!! root Permission !!! (open another terminal)

# /app/orauser/oracle/oraInventory/orainstRoot.sh
# /app/orauser/oracle/products/11.2.0/root.sh

 

 

3. Listener Installation

 

### orauser Permission ###

 

# cd database/response

# vi netca.rsp
Line 32:
RESPONSEFILE_VERSION="11.2"
Line 33:
CREATE_TYPE="CUSTOM"
Line 47:
#SHOW_GUI=false
Line 61:
LOG_FILE=""/app/orauser/oracle/products/11.2.0/network/tools/log/netca.log""
Line 72:
INSTALL_TYPE=""custom""
Line 82:
LISTENER_NAMES={"LI_MYDB"}
Line 91:
LISTENER_START=""LI_MYDB""

# netca -silent -responseFile `pwd`/netca.rsp

(silent mode 옵션을 줬음에도 ****DISPLAY environment variable not set! 이런 오류가 나오면 export DISPLAY=localhost:0.0 실행후 다시 실행)

 

 

4. Create DB

 

 

### root Permission ###

 

# cd /data
# mkdir orauser
# chown orauser.dba orauser
# chmod 755 orauser

 

 

### orauser Permission ###

 

# cd database/response

# vi dbca.rsp
Line 78:
GDBNAME = "MYDB"
Line 149:
SID = "MYDB"
Line 357:
DATAFILEDESTINATION = /data/orauser/oradata
Line 415:
CHARACTERSET = "UTF8"
Line 425:
NATIONALCHARACTERSET= "UTF8"

저장

 

# dbca -silent -responseFile `pwd`/dbca.rsp
SYS user Password: 
SYSTEM user Password:

 

# sqlplus / as sysdba
sql> select status from v$instance;
sql> show sga

 

 

※※※ 원격접속 문제 발생시(FIREWALL 관련 문제일 경우 오라클 접속 포트 개방) ※※※

 

### root Permission ###

# firewall-cmd --permanent --zone=public --add-port=1521/tcp
# firewall-cmd --reload

 

 

※※※ Universal Installer(GUI) 실행시 ※※※

 

### orauser Permission ###

# ./runInstaller -jreLoc /usr/lib/jvm/jre

 

 

※※※ deinstallation (silent mode) ※※※

 

### orauser Permission ###

# cd $ORACLE_HOME/deinstall
# ./deinstall -silent -home $ORACLE_HOME

 

 

### root Permission ###

# rm -rf /etc/oraInst.loc