Oracle 12.1.0.2 links without a problem on CentOS 7.0 and OL 7.0

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 5 Aug 2014 17:53:11 +0000 (UTC)
Message-ID: <pan.2014.08.05.17.53.11_at_gmail.com>



The previous release (12.1.0.1) was failing miserably and required me to manually change the make files for RDBMS. This release links without a single glitch. Of course, I omitted setting the database to NOARCHIVELOG mode, so the upgrade took forever and a day and a gazillion of archive logs were written, but it completed OK, using DBUA. Let the testing games begin. If you run out of space, the DBUA will detect it automatically:

9f094v55_.log
  Current log# 1 seq# 139 mem# 1: /data/oradata/fra/ORA12C/onlinelog/ o1_mf_1_9f094vx8_.log
Tue Aug 05 13:45:48 2014
Thread 1 advanced to log sequence 140 (LGWR switch)   Current log# 2 seq# 140 mem# 0: /data/oradata/ora12c/ORA12C/onlinelog/ o1_mf_2_9f094wn3_.log
  Current log# 2 seq# 140 mem# 1: /data/oradata/fra/ORA12C/onlinelog/ o1_mf_2_9f094xds_.log
Tue Aug 05 13:45:51 2014
Archived Log entry 115 added for thread 1 sequence 139 ID 0xcc4f914 dest 1:
Tue Aug 05 13:45:51 2014

Resize operation completed for file# 202, old size 20480K, new size 21504K
Resize operation completed for file# 202, old size 21504K, new size 22528K
Resize operation completed for file# 202, old size 22528K, new size 23552K
Resize operation completed for file# 202, old size 23552K, new size 24576K
Resize operation completed for file# 202, old size 24576K, new size 25600K
Resize operation completed for file# 202, old size 25600K, new size 26624K
Resize operation completed for file# 202, old size 26624K, new size 27648K
Resize operation completed for file# 202, old size 27648K, new size 28672K
Resize operation completed for file# 202, old size 28672K, new size 29696K
Resize operation completed for file# 202, old size 29696K, new size 30720K
Resize operation completed for file# 202, old size 30720K, new size 31744K
Resize operation completed for file# 202, old size 31744K, new size 32768K
Resize operation completed for file# 202, old size 32768K, new size 33792K
Resize operation completed for file# 202, old size 33792K, new size 34816K
Resize operation completed for file# 202, old size 34816K, new size 35840K
Tue Aug 05 13:45:57 2014
Thread 1 cannot allocate new log, sequence 141 Checkpoint not complete
  Current log# 2 seq# 140 mem# 0: /data/oradata/ora12c/ORA12C/onlinelog/ o1_mf_2_9f094wn3_.log
  Current log# 2 seq# 140 mem# 1: /data/oradata/fra/ORA12C/onlinelog/ o1_mf_2_9f094xds_.log
Tue Aug 05 13:46:00 2014
Thread 1 advanced to log sequence 141 (LGWR switch)   Current log# 3 seq# 141 mem# 0: /data/oradata/ora12c/ORA12C/onlinelog/ o1_mf_3_9f094y4j_.log
  Current log# 3 seq# 141 mem# 1: /data/oradata/fra/ORA12C/onlinelog/ o1_mf_3_9f094yxt_.log
TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P221
(41855) VALUES LESS THAN (TO_DATE(' 2014-08-06 00:00:00', 'SYYYY-MM-DD
HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
Tue Aug 05 13:46:04 2014
Archived Log entry 116 added for thread 1 sequence 140 ID 0xcc4f914 dest 1:
TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P224
(41855) VALUES LESS THAN (TO_DATE(' 2014-08-06 00:00:00', 'SYYYY-MM-DD
HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
Tue Aug 05 13:46:07 2014
TABLE SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY: ADDED INTERVAL PARTITION SYS_P278
(41855) VALUES LESS THAN (TO_DATE(' 2014-08-06 00:00:00', 'SYYYY-MM-DD
HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRI$_OPTSTAT_HISTGRM_HISTORY: ADDED INTERVAL PARTITION SYS_P281
(41855) VALUES LESS THAN (TO_DATE(' 2014-08-06 00:00:00', 'SYYYY-MM-DD
HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
Tue Aug 05 13:46:09 2014
SERVER COMPONENT id=APS: status=VALID, version=12.1.0.2.0, timestamp=2014-08-05 13:46:09 Container=PDB$SEED Id=2 Tue Aug 05 13:46:13 2014
Thread 1 cannot allocate new log, sequence 142 Checkpoint not complete
  Current log# 3 seq# 141 mem# 0: /data/oradata/ora12c/ORA12C/onlinelog/ o1_mf_3_9f094y4j_.log
  Current log# 3 seq# 141 mem# 1: /data/oradata/fra/ORA12C/onlinelog/ o1_mf_3_9f094yxt_.log
Tue Aug 05 13:46:14 2014
SERVER COMPONENT id=APS: status=VALID, version=12.1.0.2.0, timestamp=2014-08-05 13:46:14 Container=PDBTEST Id=3 Tue Aug 05 13:46:16 2014
Thread 1 advanced to log sequence 142 (LGWR switch)   Current log# 1 seq# 142 mem# 0: /data/oradata/ora12c/ORA12C/onlinelog/ o1_mf_1_9f094v55_.log
  Current log# 1 seq# 142 mem# 1: /data/oradata/fra/ORA12C/onlinelog/ o1_mf_1_9f094vx8_.log
Tue Aug 05 13:46:17 2014
Archived Log entry 117 added for thread 1 sequence 141 ID 0xcc4f914 dest 1:
Tue Aug 05 13:46:19 2014
SERVER COMPONENT id=OLS: status=VALID, version=12.1.0.2.0, timestamp=2014-08-05 13:46:19 Container=PDB$SEED Id=2 Tue Aug 05 13:46:22 2014
SERVER COMPONENT id=OLS: status=VALID, version=12.1.0.2.0, timestamp=2014-08-05 13:46:22 Container=PDBTEST Id=3 Tue Aug 05 13:46:40 2014
Thread 1 cannot allocate new log, sequence 143 Checkpoint not complete
  Current log# 1 seq# 142 mem# 0: /data/oradata/ora12c/ORA12C/onlinelog/ o1_mf_1_9f094v55_.log
  Current log# 1 seq# 142 mem# 1: /data/oradata/fra/ORA12C/onlinelog/ o1_mf_1_9f094vx8_.log
Tue Aug 05 13:46:46 2014
SERVER COMPONENT id=DV: status=VALID, version=12.1.0.2.0, timestamp=2014-08-05 13:46:46 Container=PDB$SEED Id=2 Tue Aug 05 13:46:46 2014
Thread 1 advanced to log sequence 143 (LGWR switch)   Current log# 2 seq# 143 mem# 0: /data/oradata/ora12c/ORA12C/onlinelog/ o1_mf_2_9f094wn3_.log
  Current log# 2 seq# 143 mem# 1: /data/oradata/fra/ORA12C/onlinelog/ o1_mf_2_9f094xds_.log

....

Archived Log entry 127 added for thread 1 sequence 151 ID 0xcc4f914 dest 1:
Tue Aug 05 13:51:20 2014
Resize operation completed for file# 7, old size 614400K, new size 624640K

As long as there is enough disk space, there is nothing to worry about. The only thing to fear is the fear itself. And the bugs, of course.

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com
Received on Tue Aug 05 2014 - 19:53:11 CEST

Original text of this message