설치 전 환경 설정
- OS 환경 체크
[root@oraclevm ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.9 (Maipo)
- 메모리 체크
최소물리메모리 1GB of RAM/ 권장물리메모리 : 2GB of RAM or more
물리메모리 1G~2G → Swap 1.5배
2G~16G 사이 ▶ Swap 물리메모리 양과 동일
16G 이상 ▶ Swap 16G 로 설정
1. 전체 메모리 확인
[root@oraclevm ~]# grep Total /proc/meminfo
MemTotal: 4045072 kB
SwapTotal: 4063228 kB
VmallocTotal: 34359738367 kB
CmaTotal: 0 kB
HugePages_Total: 0
2. SWAP 메모리 확인
[root@oraclevm ~]# grep Swap /proc/meminfo
SwapCached: 3548 kB
SwapTotal: 4063228 kB
SwapFree: 4010492 kB
3. 여유 공간 확인
[root@oraclevm ~]# free -gh
total used free shared buff/cache available
Mem: 3.9G 1.1G 123M 1.5G 2.6G 1.0G
Swap: 3.9G 51M 3.8G
패키지 설치
아래의 패키지를 yum 또는 rpm 명령어로 설치
** compat-libstdc++ 패키지 외에는 centos 설치 CD 에 포함되어 있음
- yum install -y ...
- rpm -ivh ...
bc
binutils
compat-libcap1
compat-libstdc++ => yum 또는 다운로드 설치(구글 검색)
elfutils-libelf
elfutils-libelf-devel
fontconfig-devel
glibc
glibc-devel
ksh
libaio
libaio-devel
libXrender
libXrender-devel
libX11
libXau
libXi
libXtst
libgcc
libstdc++
libstdc++-devel
libxcb
make
sysstat
-----------------------------------------------------------------------RAC 관련 툴
net-tools (for Oracle RAC and Oracle Clusterware)
nfs-utils (for Oracle ACFS)
python (for Oracle ACFS Remote)
python-configshell (for Oracle ACFS Remote)
python-rtslib (for Oracle ACFS Remote)
python-six (for Oracle ACFS Remote)
targetcli (for Oracle ACFS Remote)
오라클 설치를 위한 환경 설정
- 그룹 및 유저 생성
[root@oraclevm ~]# groupadd oinstall
[root@oraclevm ~]# groupadd dba
[root@oraclevm ~]# groupadd oper
[root@oraclevm ~]# useradd -g oinstall -G dba ora11g_slient
[root@oraclevm ~]# passwd ora11g_slient
- 파라미터 설정
1. 커널 파라미터 값을 설정. 설정 후 바로 적용을 위해 sysctl –p
[root@oraclevm ~]# vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
fs.aio-max-nr = 1048576
fs.file-max = 6815744
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
[root@oraclevm ~]# sysctl -p
2. 설치할 사용자의 Resource limit 값을 확인하고 수정
-nofile – 동시에 파일을 열 수 있는 개수 지정 / 최저값 1024 최고값 65536
-nproc – 한 사용자당 사용 가능한 프로세스 개수 지정 / 최저값 2047 최고값 16384
[root@oraclevm ~]# vi /etc/security/limits.conf
ora11g_silent soft nproc 2047
ora11g_silent hard nproc 16384
ora11g_silent soft nofile 1024
ora11g_silent hard nofile 65536
3. 사용자 인증 보안 설정 pam.d는 사용자 인증 모듈이며 제한 기능을 사용하기 위해 내용 추가
[root@oraclevm ~]# vi /etc/pam.d/login
session required pam_limits.so
4. 호스트명을 IP로 연결해주기 위해 추가
[root@oraclevm ~]# vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.136.4 oraclevm
- 디렉토리 설정
1. 디렉토리 생성
[root@oraclevm ~]# mkdir -p /u01/app4/oracle/11.2.0.3/11.2.0.3_slient
2. 디렉토리 권한 설정
[root@oraclevm ~]# chown -R ora11g_slient:dba /u01/app4
[root@oraclevm u01]# ll
total 0
drwxr-xr-x. 4 ora11g dba 40 Nov 8 10:29 app
drwxr-xr-x. 3 ora19c dba 20 Nov 8 13:02 app2
drwxr-xr-x. 3 ora11gs dba 20 Nov 15 10:43 app3
drwxr-xr-x. 3 ora11g_slient dba 20 Nov 22 14:26 app4
3. oraInventory 생성
[ora11g_slient@oraclevm ~]$ mkdir -p /u01/app4/oraInventory
- profile 설정
[root@oraclevm ~]# su - ora11g_slient
[ora11g_slient@oraclevm ~]# vi .bash_profile
export ORACLE_BASE=/u01/app4
export ORACLE_HOME=$ORACLE_BASE/oracle/11.2.0.3/11.2.0.3_slient
export ORACLE_SID=DB11S
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export DISPLAY=192.168.10.192:0.0
[ora11g_slient@oraclevm ~]# . ~/.bash_profile
DB Engine 설치
- 설치 파일 압축 해제
[ora11g_slient@oraclevm ~]$ cd /tmp
[ora11g_slient@oraclevm tmp]$ cp p10404530_112030_linux-x86-64_* ~/
[ora11g_slient@oraclevm tmp]$ cd
[ora11g_slient@oraclevm ~]$ ls
p10404530_112030_linux-x86-64_1of7.zip p10404530_112030_linux-x86-64_2of7.zip p10404530_112030_linux-x86-64_3of7.zip
[ora11g_slient@oraclevm ~]$ ll
total 2442044
-rw-r--r--. 1 ora11g_slient oinstall 1358454646 Nov 22 14:40 p10404530_112030_linux-x86-64_1of7.zip
-rw-r--r--. 1 ora11g_slient oinstall 1142195302 Nov 22 14:40 p10404530_112030_linux-x86-64_2of7.zip
-rw-r--r--. 1 ora11g_slient oinstall 979195792 Nov 22 14:40 p10404530_112030_linux-x86-64_3of7.zip
[ora11g_slient@oraclevm ~]$ unzip p10404530_112030_linux-x86-64_1of7.zip && unzip p10404530_112030_linux-x86-64_2of7.zip
[ora11g_slient@oraclevm ~]$ ls -lrt
total 3398296
drwxr-xr-x. 8 ora11g_slient oinstall 4096 Sep 22 2011 database
-rw-r--r--. 1 ora11g_slient oinstall 1358454646 Nov 22 14:40 p10404530_112030_linux-x86-64_1of7.zip
-rw-r--r--. 1 ora11g_slient oinstall 1142195302 Nov 22 14:40 p10404530_112030_linux-x86-64_2of7.zip
-rw-r--r--. 1 ora11g_slient oinstall 979195792 Nov 22 14:42 p10404530_112030_linux-x86-64_3of7.zip
[ora11g_slient@oraclevm ~]$ cd database/
[ora11g_slient@oraclevm database]$ ls -lrt
total 52
-rwxr-xr-x. 1 ora11g_slient oinstall 5466 Aug 23 2011 welcome.html
drwxr-xr-x. 12 ora11g_slient oinstall 4096 Sep 19 2011 doc
-rwxr-xr-x. 1 ora11g_slient oinstall 3226 Sep 22 2011 runInstaller
drwxr-xr-x. 2 ora11g_slient oinstall 34 Sep 22 2011 rpm
drwxr-xr-x. 2 ora11g_slient oinstall 61 Sep 22 2011 response
drwxr-xr-x. 4 ora11g_slient oinstall 4096 Sep 22 2011 install
drwxr-xr-x. 14 ora11g_slient oinstall 4096 Sep 22 2011 stage
drwxr-xr-x. 2 ora11g_slient oinstall 29 Sep 22 2011 sshsetup
-rwxr-xr-x. 1 ora11g_slient oinstall 28122 Sep 22 2011 readme.html
[ora11g_slient@oraclevm database]$ cd response/
[ora11g_slient@oraclevm response]$ pwd
/home/ora11g_slient/database/response
[ora11g_slient@oraclevm response]$ ls -lrt
total 80
-rwxr-xr-x. 1 ora11g_slient oinstall 5871 Sep 22 2011 netca.rsp
-rwxr-xr-x. 1 ora11g_slient oinstall 24992 Sep 22 2011 db_install.rsp
-rwxr-xr-x. 1 ora11g_slient oinstall 44533 Sep 22 2011 dbca.rsp
- db_install.rsp 내용 변경
1. install_option 설정
#------------------------------------------------------------------------------
# Specify the installation option.
# It can be one of the following:
# 1. INSTALL_DB_SWONLY = install database software only
# 2. INSTALL_DB_AND_CONFIG = create & configuration a database
# 3. UPGRADE_DB = upgrade and existing database
#-------------------------------------------------------------------------------
oracle.install.option=INSTALL_DB_SWONLY
2. Hostname 설정
#-------------------------------------------------------------------------------
# Specify the hostname of the system as set during the install. It can be used
# to force the installation to use an alternative hostname rather than using the
# first hostname found on the system. (e.g., for systems with multiple hostnames
# and network interfaces)
#-------------------------------------------------------------------------------
ORACLE_HOSTNAME=oraclevm
3. inventory group 설정
#-------------------------------------------------------------------------------
# Specify the Unix group to be set for the inventory directory.
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=oinstall
4. Inventory location 설정
#-------------------------------------------------------------------------------
# Specify the location which holds the inventory files.
# This is an optional parameter if installing on
# Windows based Operating System.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/u01/app4/oraInventory
5. Languages 설정
#-------------------------------------------------------------------------------
# Specify the languages in which the components will be installed.
#
# en : English ja : Japanese
# fr : French ko : Korean
# ar : Arabic es : Latin American Spanish
# bn : Bengali lv : Latvian
# pt_BR: Brazilian Portuguese lt : Lithuanian
# bg : Bulgarian ms : Malay
# fr_CA: Canadian French es_MX: Mexican Spanish
# ca : Catalan no : Norwegian
# hr : Croatian pl : Polish
# cs : Czech pt : Portuguese
# da : Danish ro : Romanian
# nl : Dutch ru : Russian
# ar_EG: Egyptian zh_CN: Simplified Chinese
# en_GB: English (Great Britain) sk : Slovak
# et : Estonian sl : Slovenian
# fi : Finnish es_ES: Spanish
# de : German sv : Swedish
# el : Greek th : Thai
# iw : Hebrew zh_TW: Traditional Chinese
# hu : Hungarian tr : Turkish
# is : Icelandic uk : Ukrainian
# in : Indonesian vi : Vietnamese
# it : Italian
#
# all_langs : All languages
#
# Specify value as the following to select any of the languages.
# Example : SELECTED_LANGUAGES=en,fr,ja
#
# Specify value as the following to select all the languages.
# Example : SELECTED_LANGUAGES=all_langs
#------------------------------------------------------------------------------
SELECTED_LANGUAGES=en,ko
5. ORACLE_HOME 설정
#------------------------------------------------------------------------------
# Specify the complete path of the Oracle Home.
#------------------------------------------------------------------------------
ORACLE_HOME=/u01/app4/oracle/11.2.0.3/11.2.0.3_slient
6. ORACLE_BASE 설정
#------------------------------------------------------------------------------
# Specify the complete path of the Oracle Base.
#------------------------------------------------------------------------------
ORACLE_BASE=/u01/app4
7. InstallEdition 설정
#------------------------------------------------------------------------------
# Specify the installation edition of the component.
#
# The value should contain only one of these choices.
# EE : Enterprise Edition
# SE : Standard Edition
# SEONE : Standard Edition One
# PE : Personal Edition (WINDOWS ONLY)
#------------------------------------------------------------------------------
oracle.install.db.InstallEdition=EE
8. GROUP 설정
- DBA
#------------------------------------------------------------------------------
# The DBA_GROUP is the OS group which is to be granted OSDBA privileges.
#------------------------------------------------------------------------------
oracle.install.db.DBA_GROUP=dba
- oper
#------------------------------------------------------------------------------
# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.
# The value to be specified for OSOPER group is optional.
#------------------------------------------------------------------------------
oracle.install.db.OPER_GROUP=oper
9. Security option 설정
#------------------------------------------------------------------------------
# Specify whether user doesn't want to configure Security Updates.
# The value for this variable should be true if you don't want to configure
# Security Updates, false otherwise.
#
# The value can be either true or false. If left blank it will be assumed
# to be false.
#
# Example : DECLINE_SECURITY_UPDATES=false
#------------------------------------------------------------------------------
DECLINE_SECURITY_UPDATES=true
[ora11g_slient@oraclevm ~]$ cd ~/database
[ora11g_slient@oraclevm database]$ ll
total 52
drwxr-xr-x. 12 ora11g_slient oinstall 4096 Sep 19 2011 doc
drwxr-xr-x. 4 ora11g_slient oinstall 4096 Sep 22 2011 install
-rwxr-xr-x. 1 ora11g_slient oinstall 28122 Sep 22 2011 readme.html
drwxr-xr-x. 2 ora11g_slient oinstall 61 Sep 22 2011 response
drwxr-xr-x. 2 ora11g_slient oinstall 34 Sep 22 2011 rpm
-rwxr-xr-x. 1 ora11g_slient oinstall 3226 Sep 22 2011 runInstaller
drwxr-xr-x. 2 ora11g_slient oinstall 29 Sep 22 2011 sshsetup
drwxr-xr-x. 14 ora11g_slient oinstall 4096 Sep 22 2011 stage
-rwxr-xr-x. 1 ora11g_slient oinstall 5466 Aug 23 2011 welcome.html
[ora11g_slient@oraclevm database]$ ./runInstaller -waitforcompletion -showProgress -silent -responseFile /home/ora11g_slient/database/response/db_install.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 36970 MB Passed
Checking swap space: must be greater than 150 MB. Actual 3967 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2022-11-22_04-12-56PM. Please wait ...[WARNING] [INS-13014] Target environment do not meet some optional requirements.
CAUSE: Some of the optional prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/installActions2022-11-22_04-12-56PM.log
ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/installActions2022-11-22_04-12-56PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2022-11-22_04-12-56PM.log
Prepare in progress.
.................................................. 9% Done.
Prepare successful.
Copy files in progress.
.................................................. 14% Done.
.................................................. 20% Done.
.................................................. 26% Done.
.................................................. 31% Done.
.................................................. 36% Done.
.................................................. 44% Done.
.................................................. 49% Done.
.................................................. 54% Done.
.................................................. 59% Done.
.................................................. 64% Done.
.................................................. 69% Done.
.................................................. 74% Done.
.................................................. 79% Done.
.................................................. 84% Done.
....................
Copy files successful.
Link binaries in progress.
..........
Link binaries successful.
Setup files in progress.
.................................................. 89% Done.
.................................................. 94% Done.
Setup files successful.
The installation of Oracle Database 11g was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2022-11-22_04-12-56PM.log' for more details.
Execute Root Scripts in progress.
As a root user, execute the following script(s):
1. /u01/app4/oracle/11.2.0.3/11.2.0.3_slient/root.sh
▶ 기존 DB 설치한 서버에 추가로 설치 진행하는 것으로 root shell 하나만 출력됨
.................................................. 100% Done.
Execute Root Scripts successful.
Successfully Setup Software.
[ora11g_slient@oraclevm database]$ su - root
Password:
Last login: Tue Nov 22 16:15:47 KST 2022 from 192.168.136.1 on pts/1
[root@oraclevm ~]#
[root@oraclevm ~]# vi /u01/app4/oracle/11.2.0.3/11.2.0.3_slient/install/root_oraclevm_2022-11-22_16-16-35.log
[root@oraclevm ~]# /u01/app4/oracle/11.2.0.3/11.2.0.3_slient/root.sh
Check /u01/app4/oracle/11.2.0.3/11.2.0.3_slient/install/root_oraclevm_2022-11-22_16-16-35.log for the output of root script
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= ora11g_slient
ORACLE_HOME= /u01/app4/oracle/11.2.0.3/11.2.0.3_slient
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
- Listener 설정 (netca.rsp)
1. GUI 환경이 아닌 백그라운드에서 진행하기에 해당 옵션 주석 해제
#-------------------------------------------------------------------------------
# Name : SHOW_GUI
# Datatype : Boolean
# Description: This variable controls appearance/suppression of the NetCA GUI,
# Pre-req : N/A
# Default : TRUE
# Note:
# This must be set to false in order to run NetCA in silent mode.
# This is a substitute of "/silent" flag in the NetCA command line.
# The command line flag has precedence over the one in this response file.
# This feature is present since 10.1.0.3.
#-------------------------------------------------------------------------------
SHOW_GUI=false
2. Install Type 설정 (내용 변경하기 때문에 custom으로 진행, Default typical)
#INSTALL_TYPE;String;type of install
# The possible values for install type are:
# "typical","minimal" or "custom"
INSTALL_TYPE=""custom""
3. LISTENR NAME 설정 (필수 아님, Default LISTENER 해도 무방)
#LISTENER_NAMES;StringList;list of listener names
# The values for listener are:
# "LISTENER","LISTENER1","LISTENER2","LISTENER3", ...
# A typical install sets only "LISTENER"
LISTENER_NAMES={"DB11S"}
4. LISTENER PORT 설정 (필수 아님, Default 1521 해도 무방)
#LISTENER_PROTOCOLS;StringList;list of listener addresses(protocols and parameters separated by semicolons)
# The possible values for listener protocols are:
# "TCP;1521","TCPS;2484","NMP;ORAPIPE","IPC;IPCKEY","VI;1521"
# A typical install sets only "TCP;1521"
LISTENER_PROTOCOLS={"TCP;6525"}
5. LISTENER START NAME 설정 (필수 아님, Default LISTENER 해도 무방)
#LISTENER_START;String;name of the listener to start, in double quotes
LISTENER_START=""DB11S""
[ora11g_slient@oraclevm ~]$ netca /silent /responseFile /home/ora11g_slient/database/response/netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /home/ora11g_slient/database/response/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Configuring Listener:DB11S
Listener configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/u01/app4/oracle/11.2.0.3/11.2.0.3_slient/bin/lsnrctl start DB11S
Listener Control complete.
Listener started successfully.
Profile configuration complete.
Oracle Net Services configuration successful. The exit code is 0
1. 리스너 동작 확인
[ora11g_slient@oraclevm ~]$ lsnrctl status DB11S
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 22-NOV-2022 16:29:38
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraclevm)(PORT=6525)))
STATUS of the LISTENER
------------------------
Alias DB11S
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 22-NOV-2022 16:28:58
Uptime 0 days 0 hr. 0 min. 39 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app4/oracle/11.2.0.3/11.2.0.3_slient/network/admin/listener.ora
Listener Log File /u01/app4/diag/tnslsnr/oraclevm/db11s/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oraclevm)(PORT=6525)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC6525)))
The listener supports no services
The command completed successfully
2. $ORACLE_HOME/network/admin/listener.ora 내용 추가 수정
# listener.ora Network Configuration File: /u01/app4/oracle/11.2.0.3/11.2.0.3_slient/network/admin/listener.ora
# Generated by Oracle configuration tools.
DB11S =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclevm)(PORT = 6525))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC6525))
)
)
SID_LIST_DB11S =
(SID_LIST =
(SID_DESC =
(SID_NAME = DB11S)
(ORACLE_HOME = /u01/app4/oracle/11.2.0.3/11.2.0.3_slient)
)
)
ADR_BASE_DB11S = /u01/app4
3. Listener 재기동
[ora11g_slient@oraclevm admin]$ lsnrctl stop DB11S
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 22-NOV-2022 16:31:26
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraclevm)(PORT=6525)))
The command completed successfully
[ora11g_slient@oraclevm admin]$ lsnrctl start DB11S
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 22-NOV-2022 16:31:31
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /u01/app4/oracle/11.2.0.3/11.2.0.3_slient/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u01/app4/oracle/11.2.0.3/11.2.0.3_slient/network/admin/listener.ora
Log messages written to /u01/app4/diag/tnslsnr/oraclevm/db11s/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oraclevm)(PORT=6525)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC6525)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraclevm)(PORT=6525)))
STATUS of the LISTENER
------------------------
Alias DB11S
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 22-NOV-2022 16:31:31
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app4/oracle/11.2.0.3/11.2.0.3_slient/network/admin/listener.ora
Listener Log File /u01/app4/diag/tnslsnr/oraclevm/db11s/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oraclevm)(PORT=6525)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC6525)))
Services Summary...
Service "DB11S" has 1 instance(s).
Instance "DB11S", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
- 오라클 데이터 베이스 생성하기 (dbca.rsp)
1. Global Database name 설정
#-----------------------------------------------------------------------------
# Name : GDBNAME
# Datatype : String
# Description : Global database name of the database
# Valid values : <db_name>.<db_domain> - when database domain isn't NULL
# <db_name> - when database domain is NULL
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
GDBNAME = "DB11S"
2. SID 설정
#-----------------------------------------------------------------------------
# Name : SID
# Datatype : String
# Description : System identifier (SID) of the database
# Valid values : Check Oracle11g Administrator's Guide
# Default value : <db_name> specified in GDBNAME
# Mandatory : No
#-----------------------------------------------------------------------------
SID = "DB11S"
3. SYS 및 SYSTEM 패스워드 설정
#-----------------------------------------------------------------------------
# Name : SYSPASSWORD
# Datatype : String
# Description : Password for SYS user
# Valid values : Check Oracle11g Administrator's Guide
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
SYSPASSWORD = "oracle_4U"
#-----------------------------------------------------------------------------
# Name : SYSTEMPASSWORD
# Datatype : String
# Description : Password for SYSTEM user
# Valid values : Check Oracle11g Administrator's Guide
# Default value : None
# Mandatory : Yes
#-----------------------------------------------------------------------------
SYSTEMPASSWORD = "oracle_4U"
4. Storage Type 설정
#-----------------------------------------------------------------------------
# Name : STORAGETYPE
# Datatype : String
# Description : Specifies the storage on which the database is to be created
# Valid values : FS (CFS for RAC), ASM
# Default value : FS
# Mandatory : No
#-----------------------------------------------------------------------------
STORAGETYPE=FS
5. Charaterset 설정
#-----------------------------------------------------------------------------
# Name : CHARACTERSET
# Datatype : String
# Description : Character set of the database
# Valid values : Check Oracle11g National Language Support Guide
# Default value : "US7ASCII"
# Mandatory : NO
#-----------------------------------------------------------------------------
CHARACTERSET = "AL32UTF8"
6. Listener 설정
#-----------------------------------------------------------------------------
# Name : LISTENERS
# Datatype : String
# Description : Specifies list of listeners to register the database with.
# By default the database is configured for all the listeners specified in the
# $ORACLE_HOME/network/admin/listener.ora
# Valid values : The list should be space separated names like "listener1 listener2".
# Mandatory : NO
#-----------------------------------------------------------------------------
LISTENERS = "DB11S" -- listener 설치시 변경했기때문에 이름 지정
7. sampleschema 설정
#-----------------------------------------------------------------------------
# Name : SAMPLESCHEMA
# Datatype : Boolean
# Description : Specifies whether or not to add the Sample Schemas to your database
# Valid values : TRUE \ FALSE
# Default value : FASLE
# Mandatory : No
#-----------------------------------------------------------------------------
SAMPLESCHEMA=TRUE
8. 메모리 설정 (자동/ Total)
#-----------------------------------------------------------------------------
# Name : AUTOMATICMEMORYMANAGEMENT
# Datatype : Boolean
# Description : flag to indicate Automatic Memory Management is used
# Valid values : TRUE/FALSE
# Default value : TRUE
# Mandatory : NO
#-----------------------------------------------------------------------------
AUTOMATICMEMORYMANAGEMENT = "FALSE"
#-----------------------------------------------------------------------------
# Name : TOTALMEMORY
# Datatype : String
# Description : total memory in MB to allocate to Oracle
# Valid values :
# Default value :
# Mandatory : NO
#-----------------------------------------------------------------------------
TOTALMEMORY = "1024"
[ora11g_slient@oraclevm ~]$ dbca -silent -createDatabase -responseFile /home/ora11g_slient/database/response/dbca.rsp
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
57% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app4/cfgtoollogs/dbca/orcl11g/orcl11g.log" for further details.
최종확인
1. 오라클 백그라운드 프로세스 확인
[ora11g_slient@oraclevm ~]$ ps -ef | grep pmon
ora11g 14826 1 0 13:10 ? 00:00:00 ora_pmon_DB11G
ora19c 15024 1 0 13:15 ? 00:00:00 ora_pmon_DB19C
ora11gs 15677 1 0 13:20 ? 00:00:00 ora_pmon_DB11GS2
ora11g_+ 15980 1 0 16:58 ? 00:00:00 ora_pmon_DB11S
ora11g_+ 16084 15886 0 16:58 pts/0 00:00:00 grep --color=auto pmon
2. Oracle 기동 확인
[ora11g_slient@oraclevm ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Nov 22 17:01:13 2022
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select instance_name,status
2 from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
DB11S OPEN'DB > Oracle' 카테고리의 다른 글
| [INSTALL][OL7.9 / Oracle 19.15.0.0] Oracle Slient 설치_생성 스크립트 추출 버전 (수정중) (0) | 2022.11.30 |
|---|---|
| [DATAPUMP] Table EXPDP IMPDP (0) | 2022.11.23 |
| [ETC] 오라클 AWR 레포트 출력하는 방법 (0) | 2022.11.22 |
| [ETC] AWR Report 보는 방법 (0) | 2022.11.22 |
| [Admin] Shared / Dedicated Server Test (1) | 2022.11.16 |