[oracle@rac5 trace]$ cat alert_CATDB.log
2022-01-23T18:23:51.929754+05:30
Starting ORACLE instance (normal) (OS id: 25545)
2022-01-23T18:23:51.995350+05:30
****************************************************
/dev/shm will be used for creating SGA
Large pages will not be used. Only standard 4K pages will be used
****************************************************
2022-01-23T18:23:52.008448+05:30
**********************************************************************
2022-01-23T18:23:52.008533+05:30
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)
2022-01-23T18:23:52.008749+05:30
Domain name: user.slice
2022-01-23T18:23:52.008828+05:30
Per process system memlock (soft) limit = 128G
2022-01-23T18:23:52.008903+05:30
Expected per process system memlock (soft) limit to lock
instance MAX SHARED GLOBAL AREA (SGA) into memory: 1024M
2022-01-23T18:23:52.009048+05:30
Available system pagesizes:
4K, 2048K
2022-01-23T18:23:52.009191+05:30
Supported system pagesize(s):
2022-01-23T18:23:52.009264+05:30
PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s)
2022-01-23T18:23:52.009339+05:30
4K Configured 262150 262150 NONE
2022-01-23T18:23:52.009422+05:30
Reason for not supporting certain system pagesizes:
2022-01-23T18:23:52.009497+05:30
2048K - Dynamic allocate and free memory regions
2022-01-23T18:23:52.009570+05:30
**********************************************************************
2022-01-23T18:24:12.013644+05:30
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
2022-01-23T18:24:12.057139+05:30
Initial number of CPU is 1
Number of processor cores in the system is 1
Number of processor sockets in the system is 1
Shared memory segment for instance monitoring created
Capability Type : Network
capabilities requested : 7 detected : 0 Simulated : 0
Capability Type : Runtime Environment
capabilities requested : 400000FF detected : 40000000 Simulated : 0
Capability Type : Engineered Systems
capabilities requested : 7 detected : 0 Simulated : 0
Capability Type : Database Test
capabilities requested : 3 detected : 0 Simulated : 0
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/19.0.0/dbhome_1/dbs/arch
Autotune of undo retention is turned on.
IMODE=BR
ILAT =22
LICENSE_MAX_USERS = 0
SYS auditing is enabled
NOTE: remote asm mode is local (mode 0x1; from cluster type)
2022-01-23T18:24:13.951075+05:30
NOTE: Using default ASM root directory ASM
NOTE: remote asm mode is local (mode 0x1; from cluster type)
NOTE: Cluster configuration type = NONE [2]
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0.
ORACLE_HOME: /u01/app/oracle/product/19.0.0/dbhome_1
System name: Linux
Node name: rac5.samik.com
Release: 4.14.35-1818.3.3.el7uek.x86_64
Version: #2 SMP Mon Sep 24 14:45:01 PDT 2018
Machine: x86_64
Using parameter settings in server-side pfile /u01/app/oracle/product/19.0.0/dbhome_1/dbs/initCATDB.ora
System parameters with non-default values:
memory_target = 1G
memory_max_target = 1G
control_files = "/data1/CATDB/control01.ctl"
compatible = "19.0.0"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_name = "CATDB"
diagnostic_dest = "/u01/app/oracle"
2022-01-23T18:24:14.532024+05:30
============================================================
NOTE: PatchLevel of this instance 0
============================================================
2022-01-23T18:24:15.169676+05:30
Starting background process PMON
2022-01-23T18:24:15.212486+05:30
PMON started with pid=2, OS id=25670
Starting background process CLMN
2022-01-23T18:24:15.459233+05:30
CLMN started with pid=3, OS id=25672
Starting background process PSP0
2022-01-23T18:24:15.567595+05:30
PSP0 started with pid=4, OS id=25674
Starting background process VKTM
2022-01-23T18:24:15.727296+05:30
VKTM started with pid=5, OS id=25676 at elevated (RT) priority
Starting background process GEN0
2022-01-23T18:24:15.895158+05:30
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Starting background process MMAN
2022-01-23T18:24:15.996149+05:30
GEN0 started with pid=6, OS id=25681
2022-01-23T18:24:16.175964+05:30
MMAN started with pid=7, OS id=25683
2022-01-23T18:24:16.736287+05:30
Starting background process GEN1
2022-01-23T18:24:17.435801+05:30
GEN1 started with pid=9, OS id=25688_25691
Starting background process DIAG
Starting background process OFSD
2022-01-23T18:24:17.623628+05:30
DIAG started with pid=8, OS id=25693
2022-01-23T18:24:17.749960+05:30
Starting background process DBRM
2022-01-23T18:24:17.751319+05:30
OFSD started with pid=11, OS id=25695_25696
2022-01-23T18:24:17.754882+05:30
Oracle running with ofslib:'Oracle File Server Library' version=2
2022-01-23T18:24:17.857259+05:30
DBRM started with pid=13, OS id=25698
Starting background process VKRM
2022-01-23T18:24:17.960437+05:30
VKRM started with pid=14, OS id=25700
Starting background process SVCB
2022-01-23T18:24:18.094831+05:30
SVCB started with pid=15, OS id=25702
Starting background process PMAN
2022-01-23T18:24:18.201252+05:30
PMAN started with pid=16, OS id=25704
Starting background process DIA0
2022-01-23T18:24:18.331715+05:30
DIA0 started with pid=17, OS id=25706
Starting background process DBW0
2022-01-23T18:24:19.111114+05:30
Starting background process LGWR
2022-01-23T18:24:19.116202+05:30
DBW0 started with pid=18, OS id=25709
2022-01-23T18:24:19.378838+05:30
LGWR started with pid=19, OS id=25712
Starting background process CKPT
2022-01-23T18:24:19.513616+05:30
CKPT started with pid=20, OS id=25714
Starting background process SMON
2022-01-23T18:24:19.683503+05:30
SMON started with pid=21, OS id=25716
Starting background process SMCO
2022-01-23T18:24:19.784261+05:30
SMCO started with pid=22, OS id=25718
Starting background process RECO
2022-01-23T18:24:19.898217+05:30
RECO started with pid=23, OS id=25720
Starting background process LREG
2022-01-23T18:24:20.100922+05:30
LREG started with pid=25, OS id=25726
2022-01-23T18:24:20.694354+05:30
Starting background process PXMN
2022-01-23T18:24:21.127645+05:30
Using default pga_aggregate_limit of 2048 MB
2022-01-23T18:24:21.211443+05:30
PXMN started with pid=27, OS id=25730
Starting background process FENC
2022-01-23T18:24:21.500815+05:30
FENC started with pid=28, OS id=25733
Starting background process MMON
2022-01-23T18:24:21.831116+05:30
MMON started with pid=29, OS id=25735
2022-01-23T18:24:21.832099+05:30
Starting background process MMNL
Starting background process TMON
2022-01-23T18:24:22.036743+05:30
MMNL started with pid=28, OS id=25738
2022-01-23T18:24:22.386257+05:30
Setting CPU count to 1
ORACLE_BASE from environment = /u01/app/oracle
2022-01-23T18:24:22.393851+05:30
TMON started with pid=30, OS id=25740
==================================================
When DB creation script is run then below things are captured in alert log file.
2022-01-23T18:27:50.682378+05:30
create database CATDB
LOGFILE
group 1 ('/data1/CATDB/redo01.log') SIZE 10M,
group 2 ('/data1/CATDB/redo02.log') SIZE 10M,
group 3 ('/data1/CATDB/redo03.log') SIZE 10M
datafile '/data1/CATDB/system01.dbf' SIZE 500M
SYSAUX datafile '/data1/CATDB/sysaux01.dbf' SIZE 300M
DEFAULT TABLESPACE USERS datafile '/data1/CATDBusers01.dbf' size 50M
DEFAULT TEMPORARY TABLESPACE temp
tempfile '/data1/CATDB/temp01.dbf' SIZE 50M
UNDO TABLESPACE undotbs1
datafile '/data1/CATDB/undotbs01.dbf' SIZE 50M
CHARACTER SET AL32UTF8
2022-01-23T18:27:51.944936+05:30
Expanded controlfile section 32 from 31 to 128 records
Requested to grow by 97 records; added 3 blocks of records
.... (PID:25924): Redo network throttle feature is disabled at mount time
2022-01-23T18:27:51.963907+05:30
Database mounted in Exclusive Mode
Lost write protection disabled
.... (PID:25924): Using STANDBY_ARCHIVE_DEST parameter default value as /u01/app/oracle/product/19.0.0/dbhome_1/dbs/arch [krsd.c:18141]
2022-01-23T18:27:53.021106+05:30
Successful mount of redo thread 1, with mount id 2640461351
2022-01-23T18:27:53.022650+05:30
Ping without log force is disabled:
instance mounted in exclusive mode.
Buffer Cache Full DB Caching mode changing from FULL CACHING DISABLED to FULL CACHING ENABLED
Database SCN compatibility initialized to 3
2022-01-23T18:27:53.310352+05:30
Assigning activation ID 2640461351 (0x9d623e27)
Redo log for group 1, sequence 1 is not located on DAX storage
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /data1/CATDB/redo01.log
Successful open of redo thread 1
2022-01-23T18:27:53.380372+05:30
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
stopping change tracking
processing ?/rdbms/admin/dcore.bsq
2022-01-23T18:27:54.067957+05:30
create tablespace SYSTEM datafile '/data1/CATDB/system01.dbf' SIZE 500M
default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
2022-01-23T18:27:54.252459+05:30
TT00 (PID:25957): Gap Manager starting
2022-01-23T18:28:08.393125+05:30
Endian type of dictionary set to little
2022-01-23T18:28:10.394423+05:30
Completed: create tablespace SYSTEM datafile '/data1/CATDB/system01.dbf' SIZE 500M
default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
2022-01-23T18:28:13.165648+05:30
Buffer Cache Full DB Caching mode changing from FULL CACHING ENABLED to FULL CACHING DISABLED
Full DB Caching disabled: DEFAULT_CACHE_SIZE should be at least 95 MBs bigger than current size.
2022-01-23T18:28:14.442046+05:30
Undo initialization recovery: err:0 start: 4609113 end: 4609116 diff: 3 ms (0.0 seconds)
Undo initialization online undo segments: err:0 start: 4609116 end: 4609116 diff: 0 ms (0.0 seconds)
Caching undo dictionary info: used hint for object index=0
Caching undo dictionary info: used hint for object index=1
Caching undo dictionary info: used hint for object index=2
Caching undo dictionary info: used hint for object index=3
Caching undo dictionary info: used hint for object index=4
Undo initialization finished serial:0 start:4609113 end:4609117 diff:4 ms (0.0 seconds)
2022-01-23T18:28:19.859916+05:30
alter tablespace system force logging
Completed: alter tablespace system force logging
2022-01-23T18:28:19.980303+05:30
processing ?/rdbms/admin/dsqlddl.bsq
processing ?/rdbms/admin/dmanage.bsq
CREATE TABLESPACE sysaux DATAFILE '/data1/CATDB/sysaux01.dbf' SIZE 300M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE FORCE LOGGING
2022-01-23T18:28:31.709126+05:30
Completed: CREATE TABLESPACE sysaux DATAFILE '/data1/CATDB/sysaux01.dbf' SIZE 300M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE FORCE LOGGING
alter tablespace system default compress for all operations
Completed: alter tablespace system default compress for all operations
alter tablespace sysaux default compress for all operations
Completed: alter tablespace sysaux default compress for all operations
2022-01-23T18:28:31.805575+05:30
processing ?/rdbms/admin/dplsql.bsq
processing ?/rdbms/admin/dtxnspc.bsq
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/data1/CATDB/undotbs01.dbf' SIZE 50M
2022-01-23T18:28:36.143642+05:30
[25924] Successfully onlined Undo Tablespace 2.
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/data1/CATDB/undotbs01.dbf' SIZE 50M
CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE '/data1/CATDB/temp01.dbf' SIZE 50M
Completed: CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE '/data1/CATDB/temp01.dbf' SIZE 50M
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP"
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP"
CREATE TABLESPACE "USERS" DATAFILE '/data1/CATDBusers01.dbf' size 50M
SEGMENT SPACE MANAGEMENT AUTO
2022-01-23T18:28:39.295989+05:30
Completed: CREATE TABLESPACE "USERS" DATAFILE '/data1/CATDBusers01.dbf' size 50M
SEGMENT SPACE MANAGEMENT AUTO
ALTER DATABASE DEFAULT TABLESPACE "USERS"
Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
2022-01-23T18:28:39.352528+05:30
processing ?/rdbms/admin/dfmap.bsq
processing ?/rdbms/admin/denv.bsq
processing ?/rdbms/admin/drac.bsq
2022-01-23T18:28:40.016979+05:30
Thread 1 advanced to log sequence 2 (LGWR switch)
Current log# 2 seq# 2 mem# 0: /data1/CATDB/redo02.log
2022-01-23T18:28:40.172831+05:30
processing ?/rdbms/admin/dsec.bsq
2022-01-23T18:28:41.495780+05:30
processing ?/rdbms/admin/doptim.bsq
processing ?/rdbms/admin/dobj.bsq
processing ?/rdbms/admin/djava.bsq
processing ?/rdbms/admin/dpart.bsq
2022-01-23T18:28:42.577083+05:30
processing ?/rdbms/admin/drep.bsq
2022-01-23T18:28:42.812220+05:30
Thread 1 advanced to log sequence 3 (LGWR switch)
Current log# 3 seq# 3 mem# 0: /data1/CATDB/redo03.log
2022-01-23T18:28:43.507486+05:30
processing ?/rdbms/admin/daw.bsq
2022-01-23T18:28:44.239221+05:30
processing ?/rdbms/admin/dsummgt.bsq
2022-01-23T18:28:44.637710+05:30
processing ?/rdbms/admin/dtools.bsq
2022-01-23T18:28:44.975799+05:30
Thread 1 advanced to log sequence 4 (LGWR switch)
Current log# 1 seq# 4 mem# 0: /data1/CATDB/redo01.log
2022-01-23T18:28:45.008331+05:30
processing ?/rdbms/admin/dexttab.bsq
processing ?/rdbms/admin/ddm.bsq
processing ?/rdbms/admin/dlmnr.bsq
2022-01-23T18:28:45.560910+05:30
processing ?/rdbms/admin/ddst.bsq
processing ?/rdbms/admin/dfba.bsq
processing ?/rdbms/admin/dpstdy.bsq
processing ?/rdbms/admin/drupg.bsq
processing ?/rdbms/admin/dtlog.bsq
processing ?/rdbms/admin/dmisc.bsq
2022-01-23T18:28:46.119188+05:30
processing ?/rdbms/admin/dhcs.bsq
2022-01-23T18:28:47.207387+05:30
Successfully created internal service SYS$BACKGROUND at open
Successfully created internal service SYS$USERS at open
joxcsys_required_dirobj_exists: directory object does not exist, pid 25924 cid 0
joxcsys_ensure_directory_object: created directory object with path /u01/app/oracle/product/19.0.0/dbhome_1/javavm/admin/, pid 25924 cid 0
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: create database CATDB
LOGFILE
group 1 ('/data1/CATDB/redo01.log') SIZE 10M,
group 2 ('/data1/CATDB/redo02.log') SIZE 10M,
group 3 ('/data1/CATDB/redo03.log') SIZE 10M
datafile '/data1/CATDB/system01.dbf' SIZE 500M
SYSAUX datafile '/data1/CATDB/sysaux01.dbf' SIZE 300M
DEFAULT TABLESPACE USERS datafile '/data1/CATDBusers01.dbf' size 50M
DEFAULT TEMPORARY TABLESPACE temp
tempfile '/data1/CATDB/temp01.dbf' SIZE 50M
UNDO TABLESPACE undotbs1
datafile '/data1/CATDB/undotbs01.dbf' SIZE 50M
CHARACTER SET AL32UTF8
No comments:
Post a Comment