Oracle 19c Silent Installation(Single Filesystem) 오라클 19c 사일런트 설치

Oracle 19c Silent Installation(Single File system)

 

#테스트 환경

구성 환경		비고
VM	Hyper-V
OS	Oracle Linux 7.8
Core	2
Memory	4G
Disk	50G Filesystem
Database Version	Oracle Database 19c Enterprise Edition
File	LINUX.X64_193000_db_home.zip DB.RSP DBCA.RSP NETCA.RSP	설치 파일 설치구성 파일 인스턴스 구성 파일 리스너 구성 파일

 

#디렉토리

mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1 mkdir -p /u01/oradata chown -R oracle:oinstall /u01 chmod -R 775 /u01

$unzip /u01/app/oracle/product/19.0.0/dbhome_1/LINUX.X64_193000_db_home.zip

 

#.bash_profile

export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=19c export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1 export ORA_INVENTORY=/u01/app/oraInventory export ORACLE_SID=orcl export PATH=/usr/sbin:/usr/local/bin:$PATH export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

 

#구성 파일

해당 파일 경로에 이동합니다. /u01/app/oracle/product/19.0.0/dbhome_1/install/DB.RSP /u01/app/oracle/product/19.0.0/dbhome_1/assistants/dbca/dbca.rsp /u01/app/oracle/product/19.0.0/dbhome_1/assistants/assistants/netca/netca.rsp

 

#RPM 설치

# rpm -Uvh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

 

#hostname

cat /etc/hosts 127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4 192.168.56.104             19c             19c

 

#Password 설정

#passwd oracle

 

#사일런트 설치 구성사항

Version : 19c Enterprise Edition Oracle Base : /u01/app Software Location : /u01/app/oracle/product/19.0.0/dbhome_1 Privileged Operating System groups : oinstall Inventory information Inventory location: /u01/app/oraInventory oraInventory group : oinstall

 

#엔진설치

# db.rsp file

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0

 

#실행

$ ./runInstaller -silent -responseFile /u01/app/oracle/product/19.0.0/dbhome_1/install/db.rsp

 

#DBCA 구성사항

global database name : orcl configuration type : Oracle Single Instance database SID : orcl Create as Container database : No Memory Configuration Type : Automatic Memory Management Template name : General Purpose audit_filedest : {ORACLE_HOME}/admin/{DB_UNIQUE_NAME}/adump audit_trail: db compatible : 19.0.0 control_files {ORACLE_HOME}/oradata/{DB_UNIQUE_NAME}/adump db_block_size : 8192bytes db_name : orcl db_recovery_file_dest : {ORACLE_HOME}/fast_recovery_area/{DB_UNIQUE_NAME} db_recovery_file_dest_size : 8256 MB diagnostic_dest {ORACLE_BASE} dispatchers: {PROTOCO=TCP)(SERVICE=orclXDB) log_archive_format : %t_%s_%r.dbf memory_target 1560 MB nls_language : AMERICAN nls_territory : AMERICAN open_cursors: 300 processes : 320 remote_login_passwordfile: EXCLUSIVE undo_tablespace : UNDOTBS1   Database character set : AL32UTF8 National character set AL16UTF16 Data Files FILE : {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/sysaux01.dbf FILE : {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/system01.dbf FILE : {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/undotbs01.dbf FILE : {ORACLE_BASE}/oradata/{DB_UNIQUE_NAME}/users01.dbf   Controlfile   FILE : {ORACLE_BASE}/ordata/{DB_UNIQUE_NAME}/control01.ctl FILE : {ORACLE_BASE}/fast_recovery/{DB_UNIQUE_NAME}/control02.ctl   Redo Log Groups GROUP 1 FILE {ORACLE_BASE}/oradata{DB_UNIQUE_NAME}/redo01.log GROUP 2 FILE {ORACLE_BASE}/oradata{DB_UNIQUE_NAME}/redo02.log GROUP 3 FILE {ORACLE_BASE}/oradata{DB_UNIQUE_NAME}/redo03.log

 

#데이터베이스 설치

$ dbca -silent -createDatabase -responsefile $ORACLE_HOME/assistants/dbca/dbca.rsp

 

Enter SYS user password:   Enter SYSTEM user password:   [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.    CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password    ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards.    CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password    ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. Prepare for db operation 10% complete Copying database files   40% complete Creating and starting Oracle instance 42% complete 46% complete 50% complete 54% complete 58% complete 60% complete Completing Database Creation 66% complete 69% complete 70% complete Executing Post Configuration Actions 100% complete Database creation complete. For details check the logfiles at:  /u01/app/oracle/cfgtoollogs/dbca/orcl. Database Information: Global Database Name:orcl System Identifier(SID):orcl Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.   [oracle@19c ~]$ ps -ef | grep pmon oracle   23142     1  0 22:42 ?        00:00:00 ora_pmon_orcl oracle   24861 24699  0 23:02 pts/4    00:00:00 grep --color=auto pmon

 

#인스턴스 확인

SQL> select status , instance_name from v$instance; STATUS       INSTANCE_NAME ------------ ---------------- OPEN         orcl

 

#Netca 리스너 설치

$ netca -silent -responseFile $ORACLE_HOME/assistants/netca/netca.rsp

 

Parsing command line arguments:     Parameter "silent" = true     Parameter "responsefile" = /u01/app/oracle/product/19.0.0/dbhome_1/assistants/netca/netca.rsp Done parsing command line arguments. Oracle Net Services Configuration: Profile configuration complete. Oracle Net Listener Startup:     Running Listener Control:       /u01/app/oracle/product/19.0.0/dbhome_1/bin/lsnrctl start LISTENER     Listener Control complete.     Listener started successfully. Listener configuration complete. Oracle Net Services configuration successful. The exit code is 0  [oracle@19c netca]$ lsnrctl status   LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 10-AUG-2020 23:05:46   Copyright (c) 1991, 2019, Oracle.  All rights reserved.   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=19c)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias                     LISTENER Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date                10-AUG-2020 23:05:38 Uptime                    0 days 0 hr. 0 min. 8 sec Trace Level               off Security                  ON: Local OS Authentication SNMP                      OFF Listener Parameter File   /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora Listener Log File         /u01/app/oracle/diag/tnslsnr/19c/listener/alert/log.xml Listening Endpoints Summary...   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=19c)(PORT=1521)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services

$ cat /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools.   LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.103)(PORT = 1521))       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))     )   )

 

$ lsnrctl status   LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 10-AUG-2020 23:07:17   Copyright (c) 1991, 2019, Oracle.  All rights reserved.   Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.103)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias                     LISTENER Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date                10-AUG-2020 23:05:38 Uptime                    0 days 0 hr. 1 min. 38 sec Trace Level               off Security                  ON: Local OS Authentication SNMP                      OFF Listener Parameter File   /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora Listener Log File         /u01/app/oracle/diag/tnslsnr/19c/listener/alert/log.xml Listening Endpoints Summary...   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=19c)(PORT=1521)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Services Summary... Service "orcl" has 1 instance(s).   Instance "orcl", status READY, has 1 handler(s) for this service... Service "orclXDB" has 1 instance(s).   Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully