Centos7 Oracle11g silent 설치

● centos 7 환경에서 oracle 11g silent mode 로 설치 

가끔 오라클을 설치할때 GUI 방식을 사용하지 못할때가 있다. 
그럴때는 silent 모드로 설치하면 된다.

1. 환경설정 (root 유저)
- yum install 
yum install -y binutils compat-libcap1 gcc gcc-c++ glibc glibc glibc-devel glibc-devel ksh compat-libstdc++-33 libaio libaio libaio-devel libaio-devel libgcc libgcc libstdc++ libstdc++ libstdc++-devel libstdc++-devel libXi libXi libXtst libXtst make sysstat xorg-x11-apps

- oracle 유저 생성
[root@localhost ~]# groupadd oinstall
[root@localhost ~]# groupadd dba
[root@localhost ~]# useradd -g oinstall -G dba oracle
[root@localhost ~]# passwd oracle
Changing password for user oracle.
New password: 
BAD PASSWORD: The password is shorter than 8 characters
Retype new password: 
passwd: all authentication tokens updated successfully.
[root@localhost ~]# 

cd / 
mkdir oracle
chown -R oracle:oinstall /oracle

vi /etc/sysctl.conf
------------------------------------------------------------------
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 1987162112
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
------------------------------------------------------------------

-- 설정 확인
sysctl -p

vi /etc/security/limits.conf

( 파일 아래쪽에 ) 
------------------------------------------------------------------
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
------------------------------------------------------------------

2. oracle 설정 (oracle 유저)

su - oracle

vi /home/oracle/.bash_profile

------------ bash_profile --------------------------------------------------
PATH=$PATH:$HOME/.local/bin:$HOME/bin

 

export TMP=/tmp
export ORACLE_HOSTNAME=oradb
export ORACLE_UNQNAME=orcl
export ORACLE_SID=orcl
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_HOME_LISTNER=$ORACLE_HOME/bin/lsnrctl
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export NLS_LANG=American_America.KO16MSWIN949

export PATH=$ORACLE_HOME/bin:$PATH

------------ bash_profile --------------------------------------------------

 

 

--설치 파일 압축을 푼다.
unzip p13390677_112040_Linux-x86-64_1of7.zip
unzip p13390677_112040_Linux-x86-64_2of7.zip

unzip p13390677_112040_Linux-x86-64_3of7.zip

unzip p13390677_112040_Linux-x86-64_4of7.zip

unzip p13390677_112040_Linux-x86-64_5of7.zip

unzip p13390677_112040_Linux-x86-64_6of7.zip

3. silent mode 로 Database 설치

cd /home/oracle/database

[oracle@oracdb database]$  ./runInstaller -silent \
> DECLINE_SECURITY_UPDATES=true \
> SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
> oracle.install.responseFileVersion=/app/oracle/install/rspfmt_dbinstall_response_schema_v11.2.0 \
> oracle.install.option=INSTALL_DB_SWONLY \
> ORACLE_HOSTNAME=oracdb \
> UNIX_GROUP_NAME=dba \
> INVENTORY_LOCATION=/app/oracle/oraInventory \
> SELECTED_LANGUAGES=en \
> ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1 \
> ORACLE_BASE=/app/oracle \
> oracle.install.db.InstallEdition=EE \
> oracle.install.db.DBA_GROUP=oinstall \
> oracle.install.db.OPER_GROUP=dba \
> oracle.install.db.BACKUPDBA_GROUP=dba \
> oracle.install.db.DGDBA_GROUP=dba \
> oracle.install.db.KMDBA_GROUP=dba

--------------------------------------------------------------------------------------------------------------------------------------------
 ./runInstaller -silent \
DECLINE_SECURITY_UPDATES=true \
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
oracle.install.responseFileVersion=/app/oracle_install/rspfmt_dbinstall_response_schema_v11_2_0 \
oracle.install.option=INSTALL_DB_SWONLY \
ORACLE_HOSTNAME=oracdb \
UNIX_GROUP_NAME=dba \
INVENTORY_LOCATION=/app/oracle/oraInventory \
SELECTED_LANGUAGES=en \
ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1 \
ORACLE_BASE=/app/oracle \
oracle.install.db.InstallEdition=EE \
oracle.install.db.DBA_GROUP=oinstall \
oracle.install.db.OPER_GROUP=dba \
oracle.install.db.BACKUPDBA_GROUP=dba \
oracle.install.db.DGDBA_GROUP=dba \
oracle.install.db.KMDBA_GROUP=dba

--------------------------------------------------------------------------------------------------------------------------------------------

다음과 같이 실행을 하면 

Oracle Universal Installer 시작 중...

임시 공간 확인 중: 120MB 이상이어야 합니다..   실제 31087MB    성공
스왑 공간 확인 중: 150MB 이상이어야 합니다..   실제 5119MB    성공
다음에서 Oracle Universal Installer의 시작을 준비하는 중 /tmp/OraInstall2023-12-31_04-24-34PM. 기다리십시오.[oracle@oradb database]$ [WARNING] [INS-32055] 중앙 인벤토리는 Oracle Base에 있습니다.
   원인: 중앙 인벤토리는 Oracle Base에 있습니다.
   작업: Oracle은 이 중앙 인벤토리를 Oracle Base 디렉토리 외부에 배치할 것을 권장합니다.
[WARNING] [INS-13014] 대상 환경이 일부 선택적 요구 사항을 충족하지 않습니다.
   원인: 일부 선택적 필요 조건이 충족되지 않았습니다. 자세한 내용은 로그를 참조하십시오. /tmp/OraInstall2023-12-31_04-24-34PM/installActions2023-12-31_04-24-34PM.log
   작업: /tmp/OraInstall2023-12-31_04-24-34PM/installActions2023-12-31_04-24-34PM.log 로그에서 실패한 필요 조건 검사 목록을 확인하십시오. 로그 파일 또는 설치 설명서에서 필요 조건을 충족하는 적합한 구성을 찾아 수동으로 오류를 수정하십시오.
다음 위치에서 이 설치 세션의 로그를 찾을 수 있습니다.
 /app/oracle/oraInventory/logs/installActions2023-12-31_04-24-34PM.log
Oracle Database 11g의 설치을(를) 성공했습니다.
자세한 내용은 '/app/oracle/oraInventory/logs/silentInstall2023-12-31_04-24-34PM.log'을(를) 확인하십시오.

루트 사용자로 다음 스크립트를 실행합니다.
        1. /app/oracle/oraInventory/orainstRoot.sh
        2. /app/oracle/product/11.2.0/dbhome_1/root.sh


Successfully Setup Software.

 

이렇게 성공했다는 메세지가 나온다. 

 

 

** root 로 접속해서 스크립트 실행 

[root@oracdb ~]# sh /app/oracle/oraInventory/orainstRoot.sh
Changing permissions of /home/oracle/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /home/oracle/oraInventory to dba.
The execution of the script is complete.

[root@oracdb ~]# sh /app/oracle/product/11.2.0/dbhome_1/root.sh
Check /app/oracle/product/11.2.0/dbhome_1/install/root_db_server_2023-04-04_11-43-54.log for the output of root script
[root@oracdb ~]# 

 

4. dbca.rsp 로 DB 생성 (dbca.rsp 내용은 아래 참고) _ test 파일로 dbca_temp_rsp
[oracle@oracdb response]$ dbca -silent -responseFile /app/oracle_install/database/response/dbca_temp.rsp

 

Copying database files
1% complete
....
100% complete
Look at the log file "/oracle/cfgtoollogs/dbca/cdbtest/cdbtest.log" for further details.

--------------- dbca_temp.rsp ------------------------------

[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"

[CREATEDATABASE]
GDBNAME = "orcl"
DATABASECONFTYPE  = "SI"
SID = "orcl"
CREATEASCONTAINERDATABASE = true
NUMBEROFPDBS = 1
PDBNAME = pdb01
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "패스워드"
SYSTEMPASSWORD = "패스워드"
DATAFILEDESTINATION = /app/oracle
RECOVERYAREADESTINATION= /app/oracle/reco
STORAGETYPE=FS
CHARACTERSET = "K016MSWIN949"
NATIONALCHARACTERSET= "UTF8"
SAMPLESCHEMA=FALSE
MEMORYPERCENTAGE = "40"
DATABASETYPE = "MULTIPURPOSE"
AUTOMATICMEMORYMANAGEMENT = "TRUE"
TOTALMEMORY = "2048"
--------------- dbca.rsp ------------------------------

 

CHARACTERSET = "US7ASCII"

 

 

* 데이터베이스 삭제

$ dbca -silent -deleteDatabase -sourceDB ORCL

[oracle@oracdb response]$ sqlplus "/as sysdba"

SQL*Plus: Release 12.1.0.2.0 Production on Wed Dec 13 14:21:19 2017
Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select name from v$database;

NAME      CDB
--------- ---
CDBTEST   YES



SQL> 



 



이상 



DB 생성
- DBCA를 위해 dbca.rsp 파일을 아래와 같이 설정하고 저장한다.
--------------------------------------------------------------------------------
[oracle@OTS response]$ pwd
/home/oracle/database/response

[oracle@OTS response]$ vi dbca.rsp
 78 GDBNAME = "orcl“
 170 SID = "orcl“
 418 CHARACTERSET = " K016MSWIN949"
--------------------------------------------------------------------------------

dbca.rsp 파일을 실행하고 password를 입력한 후 DB생성이 완료된 것을 확인한다.
--------------------------------------------------------------------------------
[oracle@OTS response]$ dbca -silent -responseFile dbca.rsp
Enter SYS user password:
Enter SYSTEM user password:
--------------------------------------------------------------------------------
Copying database files
1$ com..
...
...
..
100% complete
Look at the log. .....
--------------------------------------------------------------------------------

추가적으로 SQL*PLUS에 정상 접속되는지 확인 한다.
--------------------------------------------------------------------------------
sqlplus / as sysdba

SQL > select status from v$instance;

STATUS
----------
OPEN

SQL > show sga

......
......



db삭제
dbca -silent -deleteDatabase -sourceDB "orcl" -sysDBAUserName sys -sysDBAPassword "orcl"


- DB 생성
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname "exoDevDb" -sid "orcl" -responseFile NO_VALUE -characterSet "K016MSWIN949" -memoryPercentage 20 -emConfiguration NONE


dbca -silent -deleteDatabase -sourceDB "orcl" -sysDBAUserName sys -sysDBAPassword "패스워드"