Created
April 25, 2020 00:43
-
-
Save cristianmiranda/8de881b6b0a84ed3992783c289d51bab to your computer and use it in GitHub Desktop.
Oracle DB init error log
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[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 ! |
Author
cristianmiranda
commented
Apr 27, 2020
•
[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