Hi ,
During manual database creation I am facing following issue
SQL> startup nomount pfile=inittestdb.ora
ORACLE instance started.
Total System Global Area 2667577344 bytes
Fixed Size 8624264 bytes
Variable Size 687867768 bytes
Database Buffers 1962934272 bytes
Redo Buffers 8151040 bytes
SQL> @createcdb.sql
CREATE DATABASE TESTDB
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/dtxnspc.bsq' near line 6
ORA-00604: error occurred at recursive SQL level 1
ORA-28365: wallet is not open
Process ID: 4230
Session ID: 17 Serial number: 47226
SQL>
#####
[oracle@ORCL ~]$ !cat inittestdb.ora
cat inittestdb.ora inittestdb.ora
*.audit_file_dest='/u01/app/oracle/admin/ORCL/adump'
*.audit_trail='db'
*.compatible='12.2.0'
*.control_file_record_keep_time=30
*.control_files='/u02/app/oracle/oradata/TESTDB/control01.ctl','/u03/app/oracle/fast_recovery_area/TESTDB/control02.ctl'
*.control_management_pack_access='NONE'
*.db_block_size=8192
*.db_create_file_dest='/u02/app/oracle/oradata/TESTDB'
*.db_domain='nareshkumar1.oraclecloud.internal'
*.db_files=250
*.db_flashback_retention_target=1440
*.db_name='TESTDB'
*.db_recovery_file_dest='/u03/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=6442450944
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCL.nareshkumar1.oraclecloud.internalXDB)'
*.enable_ddl_logging=FALSE
#*.enable_pluggable_database=true
#*.encrypt_new_tablespaces='CLOUD_ONLY'
*.filesystemio_options='setall'
*.instance_name='TESTDB'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST REOPEN=60'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=1775294400
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sec_protocol_error_trace_action='LOG'
*.service_names='ORCL.nareshkumar1.oraclecloud.internal'
*.sga_target=2662941600
*.sql92_security=TRUE
*.undo_tablespace='UNDOTBS1'
*.audit_file_dest='/u01/app/oracle/admin/ORCL/adump'
*.audit_trail='db'
*.compatible='12.2.0'
*.control_file_record_keep_time=30
*.control_files='/u02/app/oracle/oradata/TESTDB/control01.ctl','/u03/app/oracle/fast_recovery_area/TESTDB/control02.ctl'
*.control_management_pack_access='NONE'
*.db_block_size=8192
*.db_create_file_dest='/u02/app/oracle/oradata/TESTDB'
*.db_domain='nareshkumar1.oraclecloud.internal'
*.db_files=250
*.db_flashback_retention_target=1440
*.db_name='TESTDB'
*.db_recovery_file_dest='/u03/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=6442450944
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCL.nareshkumar1.oraclecloud.internalXDB)'
*.enable_ddl_logging=FALSE
#*.enable_pluggable_database=true
#*.encrypt_new_tablespaces='CLOUD_ONLY'
*.filesystemio_options='setall'
*.instance_name='TESTDB'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST REOPEN=60'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=1775294400
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sec_protocol_error_trace_action='LOG'
*.service_names='ORCL.nareshkumar1.oraclecloud.internal'
*.sga_target=2662941600
*.sql92_security=TRUE
*.undo_tablespace='UNDOTBS1'
[oracle@ORCL ~]$
#####
[oracle@ORCL ~]$ cat createcdb.sql
CREATE DATABASE TESTDB
USER SYS IDENTIFIED BY sys_password
USER SYSTEM IDENTIFIED BY system_password
LOGFILE GROUP 1 ('/u04/app/oracle/redo/redo01a.log')
SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/u04/app/oracle/redo/redo02a.log')
SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/u04/app/oracle/redo/redo03a.log')
SIZE 100M BLOCKSIZE 512
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u02/app/oracle/oradata/TESTDB/system01.dbf'
SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SYSAUX DATAFILE '/u02/app/oracle/oradata/TESTDB/sysaux01.dbf'
SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TABLESPACE deftbs
DATAFILE '/u02/app/oracle/oradata/TESTDB/deftbs01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u02/app/oracle/oradata/TESTDB/temp01.dbf'
SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE undotbs1
DATAFILE '/u02/app/oracle/oradata/TESTDB/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
[oracle@ORCL ~]$
###