[orcl:/home/oracle/dbca_scripts]> ./orcl.sh
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jan 14 10:14:02 2020
Version 19.5.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected.
Diskgroup altered.
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.5.0.0.0
/etc/oratab : orcl:/u01/app/oracle/product/19c/db_1:Y
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jan 14 10:14:03 2020
Version 19.5.0.0.0
Copyright (c) 1982, 2019, 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 3154113400 bytes
Fixed Size 8901496 bytes
Variable Size 637534208 bytes
Database Buffers 2499805184 bytes
Redo Buffers 7872512 bytes
SQL> CREATE DATABASE "orcl"
2 MAXINSTANCES 8
3 MAXLOGHISTORY 1
4 MAXLOGFILES 16
5 MAXLOGMEMBERS 3
6 MAXDATAFILES 100
7 DATAFILE SIZE 700M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
8 EXTENT MANAGEMENT LOCAL
9 SYSAUX DATAFILE SIZE 550M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
10 SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE SIZE 20M AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
11 SMALLFILE UNDO TABLESPACE "UNDOTBS1" DATAFILE SIZE 200M AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
12 CHARACTER SET AL32UTF8
13 NATIONAL CHARACTER SET AL16UTF16
14 LOGFILE GROUP 1 SIZE 200M,
15 GROUP 2 SIZE 200M,
16 GROUP 3 SIZE 200M
17 USER SYS IDENTIFIED BY "&&sysPassword" USER SYSTEM IDENTIFIED BY "&&systemPassword";
Database created.
<< 중략 >>
SQL> select comp_id, status from dba_registry;
COMP_ID 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> host /u01/app/oracle/product/19c/db_1/bin/srvctl enable database -d orcl;
SQL> host /u01/app/oracle/product/19c/db_1/bin/srvctl start database -d orcl;
SQL> connect "SYS"/"&&sysPassword" as SYSDBA
Connected.
SQL> spool off
SQL> exit;
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.5.0.0.0 |