Steps to create active data guard in 11g and up-gradation to 12c using manual method - IV

• «
• 1
• 2
• 3
• 4

10. Post upgrade steps


i. Set cluster_database to TRUE

Alter system set cluster_database=TRUE scope=spfile;

Srvctl stop instance –d TESTDBPRD –I NEWDBPRD1

Srvctl start instance –d TESTDBPRD –I NEWDBPRD1

Srvctl start instance –d TESTDBPRD –I NEWDBPRD2



ii. Update profile of DB services with new 12c home

Srvctl upgrade database –d TESTDBPRD –o /rdbms/app/oracle/12.1.0.2/db


iii. Re verify if all components are in valid state in dba_registry


A. Issues Faced


i. ORA-00600: internal error code, arguments: [pesldl03_MMap: errno 1 errmsg Operation not permitted




Issue: Alert log notifying below error during utlrp.sql executions


Errors in file /golden/app/oracle/11.2.0.3.0/diag/rdbms/TESTDBPRD/NEWDBPRD1/trace/NEWDBPRD1_ora_62755.trc (incident=1687133):


ORA-00600: internal error code, arguments: [pesldl03_MMap: errno 1 errmsg Operation not permitted


Cause: /dev/shm was mountable with noexec,nosuid




ORA-600 [pesldl03_MMap: Errno 1 Errmsg Operation Not Permitted] (Doc ID 1625010.1)

Solution:


1. /dev/shm changes


[oracle@testlabdb005a security]$ cat /etc/fstab | grep -i shm

tmpfs /dev/shm tmpfs defaults,nodev,nosuid,noexec 0 0

should be


[oracle@testlabdb005a security]$ cat /etc/fstab | grep -i shm
tmpfs /dev/shm tmpfs defaults,nodev 0 0


as per solution note


Ensure that the /dev/shm mount area is of type tmpfs and is mounted with the following options:


With rw and exec permissions set on it

Without noexec or nosuid set on it"


# cat /etc/fstab

...

tmpfs /dev/shm tmpfs defaults 0 0


2. limit changes

/etc/security/limits.conf
* soft nofile 32768
* hard nofile 65535
* soft stack 10240
* soft nproc 131072

oracle soft nproc 131072
oracle hard nproc 131072


3. in /etc/security/limits.d/ <not sure if in 90-nproc.conf or 20-nproc.conf>


* soft nproc 131072
oracle soft nproc 131072
oracle hard nproc 131072

ii. UTLRP.sql hangs with “single task message” wait event

Issue:

Utlrp.sql hangs with wait event “single task message”


Cause:

Many of the procedure/packages dependent on unresolvable db link


Solution: To remove all DB link pointing to invalid DB link



iii. TIME Zone upgrade status issue


Issue: TIMEZONE pre-requisites were not fulfilling for TZ upgrade , DST_UPGRADE_STATE should be NONE however stucked on DATAPUMP(4) state


SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME; 2 3 4


PROPERTY_NAME               VALUE
---------------- ------------------------------
DST_PRIMARY_TT_VERSION       14
DST_SECONDARY_TT_VERSION     4
DST_UPGRADE_STATE DATAPUMP  (4)



Solution:

Execute below multiple times till DATAPUMP(4) count reduces and reaches to NONE

SQL> ALTER SESSION SET EVENTS '30090 TRACE NAME CONTEXT FOREVER, LEVEL 32';

SQL> exec dbms_dst.unload_secondary;

• «
• 1
• 2
• 3
• 4