Skip to content

Instantly share code, notes, and snippets.

@cristianmiranda

cristianmiranda/oracle-db.error.log

Created April 25, 2020 00:43
Show Gist options
  • Save cristianmiranda/8de881b6b0a84ed3992783c289d51bab to your computer and use it in GitHub Desktop.
Save cristianmiranda/8de881b6b0a84ed3992783c289d51bab to your computer and use it in GitHub Desktop.
Download ZIP
Oracle DB init error log
Raw
oracle-db.error.log
[oracle@a6573e40d8b8 dbfiles]$ cat /home/oracle/setup/log/configDB.log
Sat Apr 25 00:35:35 UTC 2020
Start Docker DB configuration
Call configDBora.sh to configure database
Sat Apr 25 00:35:35 UTC 2020
Configure DB as oracle user
Setup Database directories ...
SQL*Plus: Release 12.2.0.1.0 Production on Sat Apr 25 00:35:35 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
File created.
SQL> ORACLE instance started.
Total System Global Area 1342177280 bytes
Fixed Size 8792536 bytes
Variable Size 402654760 bytes
Database Buffers 922746880 bytes
Redo Buffers 7983104 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 124
Session ID: 5 Serial number: 19838
SQL> ERROR:
ORA-03114: not connected to ORACLE
SQL> ERROR:
ORA-03114: not connected to ORACLE
SQL> ERROR:
ORA-03114: not connected to ORACLE
SQL> ERROR:
ORA-03114: not connected to ORACLE
SQL> ERROR:
ORA-03114: not connected to ORACLE
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
update password
Enter password for SYS:
create pdb : ORCLPDB1
SQL*Plus: Release 12.2.0.1.0 Production on Sat Apr 25 00:35:46 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> 2 3 4 5 create pluggable database ORCLPDB1 ADMIN USER sys1 identified by "Oradoc_db1"
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SQL> alter pluggable database ORCLPDB1 open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SQL> alter pluggable database all save state
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SQL> Disconnected
Reset Database parameters
SQL*Plus: Release 12.2.0.1.0 Production on Sat Apr 25 00:35:47 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> alter system set encrypt_new_tablespaces=ddl scope=both
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SQL> Disconnected
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 25-APR-2020 00:35:48
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Starting /u01/app/oracle/product/12.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/12.2.0/dbhome_1/admin/ORCLCDB/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/a6573e40d8b8/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 25-APR-2020 00:35:49
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0/dbhome_1/admin/ORCLCDB/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/a6573e40d8b8/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
DONE!
Remove password info
Docker DB configuration is complete !
@cristianmiranda
Copy link
Author 

[oracle@70987400d103 redo]$ cat /u01/app/oracle/diag/rdbms/orclcdb/ORCLCDB/trace/ORCLCDB_lgwr_90.trc
Trace file /u01/app/oracle/diag/rdbms/orclcdb/ORCLCDB/trace/ORCLCDB_lgwr_90.trc
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Build label:    RDBMS_12.2.0.1.0_LINUX.X64_170125
ORACLE_HOME:    /u01/app/oracle/product/12.2.0/dbhome_1
System name:	Linux
Node name:	70987400d103
Release:	5.6.0-1007-oem
Version:	#7-Ubuntu SMP Mon Apr 6 08:54:58 UTC 2020
Machine:	x86_64
Instance name: ORCLCDB
Redo thread mounted by this instance: 0 <none>
Oracle process number: 20
Unix process pid: 90, image: oracle@70987400d103 (LGWR)


*** 2020-04-27T13:46:57.562638+00:00 (CDB$ROOT(1))
*** SESSION ID:(239.51864) 2020-04-27T13:46:57.562690+00:00
*** CLIENT ID:() 2020-04-27T13:46:57.562700+00:00
*** SERVICE NAME:() 2020-04-27T13:46:57.562710+00:00
*** MODULE NAME:() 2020-04-27T13:46:57.562718+00:00
*** ACTION NAME:() 2020-04-27T13:46:57.562727+00:00
*** CLIENT DRIVER:() 2020-04-27T13:46:57.562735+00:00
*** CONTAINER ID:(1) 2020-04-27T13:46:57.562745+00:00
 
Created 2 redo writer workers (2 groups of 1 each)

*** 2020-04-27T13:47:02.130753+00:00
DDE rules only execution for: ORA 312
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
Successfully dispatched
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 1 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 1 csec) -----
DDE rules only execution for: ORA 313
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
DDE Action 'DB_STRUCTURE_INTEGRITY_CHECK' was flood controlled
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (FLOOD CONTROLLED, 0 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u04/app/oracle/redo/redo001.log'
ORA-27047: unable to read the header block of file
Linux-x86_64 Error: 22: Invalid argument
Additional information: 1
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u04/app/oracle/redo/redo001.log'
ORA-27047: unable to read the header block of file
Linux-x86_64 Error: 22: Invalid argument
Additional information: 1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment