페이지 이력

[oracle@orcl19c ~]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 08-JAN-2024 14:22:21

Copyright (c) 1991, 2023, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora19c)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                08-JAN-2024 14:20:24
Uptime                    0 days 0 hr. 1 min. 57 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19c/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/ora19c/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora19c)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "orcl19c" has 1 instance(s).
  Instance "orcl19c", status READY, has 1 handler(s) for this service...
Service "orcl19cXDB" has 1 instance(s).
  Instance "orcl19c", status READY, has 1 handler(s) for this service...
The command completed successfully

[ora19c:/home/oracle]> dbca -silent -generateScripts -gdbName orcl19c -templateName New_Database.dbt -scriptDest ~/dbca_scripts -createAsContainerDatabase false -databaseConfigType SINGLE -memoryMgmtType AUTO_SGA -totalMemory 2000 -characterSet AL32UTF8  -nationalCharacterSet AL16UTF16 -storageType FS -redoLogFileSize 200 -databaseType MULTIPURPOSE -datafileDestination /oradata -recoveryAreaDestination /FRA -recoveryAreaSize 20000 -emConfiguration none -listeners LISTENER
DB 작업 준비
5% 완료
Oracle 인스턴스 생성 및 시작 중
6% 완료
9% 완료
데이터베이스 파일 생성 중
10% 완료
14% 완료
데이터 딕셔너리 뷰 생성 중
15% 완료
18% 완료
20% 완료
22% 완료
23% 완료
27% 완료
Oracle JVM
34% 완료
41% 완료
48% 완료
50% 완료
Oracle Text
53% 완료
55% 완료
Oracle Multimedia
68% 완료
Oracle OLAP
73% 완료
Oracle Spatial
74% 완료
82% 완료
데이터베이스 생성 완료 중
84% 완료
85% 완료
86% 완료
사후 구성 작업 실행 중
100% 완료
스크립트 "/home/oracle/dbca_scripts" 생성을 성공했습니다.
자세한 내용은 로그 파일 "/u01/app/oracle/cfgtoollogs/dbca/orcl19c/orcl19c0.log"을(를) 참조하십시오.

##############################################################################
# Copyright (c) 1991, 2013 by Oracle Corporation
##############################################################################

###########################################
# NLS
###########################################
nls_language="AMERICAN"
nls_territory="KOREA"

###########################################
# SGA Memory
###########################################
sga_target=1500m

###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=orcl19cXDB)"

###########################################
# Miscellaneous
###########################################
compatible=19.0.0
diagnostic_dest=/u01/app/oracle

###########################################
# Network Registration
###########################################
#local_listener=LISTENER_ORCL19C

###########################################
# Database Identification
###########################################
db_name="orcl19c"

###########################################
# Security and Auditing
###########################################
audit_file_dest="/u01/app/oracle/admin/orcl19c/adump"
audit_trail=none
remote_login_passwordfile=EXCLUSIVE

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_tablespace=UNDOTBS1

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=500m

###########################################
# Cache and I/O
###########################################
db_block_size=8192

###########################################
# Cursors and Library Cache
###########################################
open_cursors=300

###########################################
# File Configuration
###########################################
control_files=("/oradata/ORCL19C/control01.ctl", "/FRA/ORCL19C/control02.ctl")
db_recovery_file_dest="/FRA"
db_recovery_file_dest_size=20000m
db_create_online_log_dest_1="/oradata/"
db_create_online_log_dest_2="/FRA/"

###########################################
# Processes and Sessions
###########################################
processes=300

set verify off
ACCEPT sysPassword CHAR PROMPT 'Enter new password for SYS: ' HIDE
ACCEPT systemPassword CHAR PROMPT 'Enter new password for SYSTEM: ' HIDE
host /u01/app/oracle/product/19c/db_1/bin/orapwd file=/u01/app/oracle/product/19c/db_1/dbs/orapworcl19c force=y format=12
@/home/oracle/dbca_scripts/CreateDB.sql
@/home/oracle/dbca_scripts/CreateDBFiles.sql
@/home/oracle/dbca_scripts/CreateDBCatalog.sql
@/home/oracle/dbca_scripts/JServer.sql
#@/home/oracle/dbca_scripts/context.sql
#@/home/oracle/dbca_scripts/ordinst.sql
#@/home/oracle/dbca_scripts/interMedia.sql
#@/home/oracle/dbca_scripts/cwmlite.sql
#@/home/oracle/dbca_scripts/spatial.sql
@/home/oracle/dbca_scripts/lockAccount.sql
@/home/oracle/dbca_scripts/postDBCreation.sql

[oracle@orcl19c ~]$ ~/dbca_scripts/orcl19c.sh
/etc/oratab에 추가해야 할 항목: orcl19c:/u01/app/oracle/product/19c/db_1:Y

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 8 14:26:03 2024
Version 19.21.0.0.0

Copyright (c) 1982, 2022, Oracle.  All rights reserved.

Enter new password for SYS:
Enter new password for SYSTEM:

Enter password for SYS:

Connected to an idle instance.
SQL> spool /home/oracle/dbca_scripts/CreateDB.log append
SQL> startup nomount pfile="/home/oracle/dbca_scripts/init.ora";
ORACLE instance started.

Total System Global Area 1577054648 bytes
Fixed Size                  8925624 bytes
Variable Size             385875968 bytes
Database Buffers         1174405120 bytes
Redo Buffers 
...... << 생략 >> ......

SQL> SET serveroutput off
SQL>
SQL>
SQL> Rem =====================================================================
SQL> Rem Run component validation procedure
SQL> Rem =====================================================================
SQL>
SQL> SET serveroutput on
SQL> EXECUTE dbms_registry_sys.validate_components;

PL/SQL procedure successfully completed.

SQL> SET serveroutput off
SQL>
SQL>
SQL> Rem ===========================================================================
SQL> Rem END utlrp.sql
SQL> Rem ===========================================================================
SQL> select 'utlrp_end: ' || to_char(sysdate, 'HH:MI:SS') from dual;

'UTLRP_END:'||TO_CH
-------------------
utlrp_end: 02:41:46

1 row selected.

SQL> select comp_id, status from dba_registry;

COMP_ID               7847936 bytes
SQL> CREATE DATABASE "orcl19c"
  2  MAXINSTANCES STATUS
------------------------------ --------------------------------------------
CATALOG                        VALID
CATPROC                        VALID
RAC                            OPTION OFF
JAVAVM                         VALID
XML                            VALID
CATJAVA                        VALID
XDB                            VALID
OWM                            VALID

8 rows selected.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> connect "SYS"/"&&sysPassword" as SYSDBA
Connected to an idle instance.
SQL> startup ;
ORACLE instance started.

Total System Global Area 1577054648 bytes
Fixed Size                  8925624 bytes
Variable Size             385875968 bytes
Database Buffers         1174405120 bytes
Redo Buffers                7847936 bytes
Database mounted.
Database opened.
SQL> spool off
SQL> exit;
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.21.0.0.0