February 22 2013

How to relink Oracle binaries after OS upgrade in 11gR2 with Grid Infra?

Tagged Under : , ,

(1) Shutdown DB, DBconsole (if any), Cluster, ASMlib (if any in Linux)

As RDBMS owner id “oracle”:
$ srvctl stop database -d -o immediate #– run once in any node
$ emctl stop dbconsole #– run on all nodes

As UNIX/Linux “root”:
# /bin/crsctl stop crs #– run on all nodes
# /bin/crsctl disable crs #– run on all nodes
# /etc/init.d/oracleasm stop #– run on all nodes
# /etc/init.d/oracleasm disable #– run on all nodes

(2) Backup filesystem for GI ORACLE_HOME & RDBMS ORACLE_HOME

(3) O/S upgrade

(4) Upgrade ASMlib (if any in Linux, run on all nodes)
# rpm -Uvh oracleasm-support-xxx
# rpm -Uvh oracleasm-2.6.xxx
# rpm -Uvh oracleasmlib-xxx
# /etc/init.d/oracleasm enable
# /etc/init.d/oracleasm lisdisks

(5) Relink RDBMS ORACLE_HOME Binary
Note: complete full steps in onde node, then proceed to next

As RDBMS owner id “oracle”:
$ /bin/relink all

(6) Relink GI ORACLE_HOME Binary
Note: complete full steps in onde node, then proceed to next

As UNIX/Linux “root”:
# cd /crs/install
# ./rootcrs.pl -unlock

As RDBMS owner id “oracle”:
$ cd /bin
$ ./relink all

As UNIX/Linux “root”:
# cd /rdbms/install
# ./rootadd_rdbms.sh
# cd /crs/install
# ./rootcrs.pl -patch

(7) Enable CRS auto-startup and start CRS on all nodes
Note: complete full steps in onde node, then proceed to next

As UNIX/Linux “root”:
# /bin/crsctl start crs
# /bin/crsctl enable crs

(8) Double check if DB, instances and all resrouces are ONLINE.

As RDBMS owner id “oracle”:
$ crsctl stat res -t

Gentle reminder:
Please read the following known bug before you plan for relinking Grid Infra 11.2.0.3.

Bug 16038046 : FAILED TO WRITE THE CHECKPOINT:” WITH STATUS:FAIL.ERROR CODE IS 256

March 25 2011

Oracle ORA-31671: Worker process DW08 had an unhandled exception.

Tagged Under : , , , , , , ,

expdp (Export datapump) fail with following errors (shown in symptoms) in Oracle RDBMS 10.2.0.3.

Applies to:

Oracle RDBMS 10.1 to 10.2

Symptoms:

#– found following errors on expdb logs –#

Starting “MYUSER”.”MYUSER_JOB”: MYUSER/******** DIRECTORY=EXP_EG711 LOGFILE=myuser_dmp.log DUMPFILE=myuser%U.dmp JOB_NAME=myuser_job CONTENT=all FILESIZE=20G PARALLEL=16

ORA-39014: One or more workers have prematurely exited.

ORA-39029: worker 8 with process name “DW08” prematurely terminated

ORA-31671: Worker process DW08 had an unhandled exception.

ORA-12801: error signaled in parallel query server P000, instance mynode03:MYDB3 (3)

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-31626: job does not exist

ORA-06512: at “SYS.ORACLE_DATAPUMP”, line 19

ORA-06512: at “SYS.KUPW$WORKER”, line 1342

ORA-06512: at line 2

Job “WM7IS”.”MYUSER_JOB” stopped due to fatal error at 00:35:10

ORA-39014: One or more workers have prematurely exited.

#– Also found followings errors on bdump trace file –#

kupprdp: Error 12801 detected in worker process DW08, worker id=8.

OPIRIP: Uncaught error 447. Error stack:

ORA-00447: fatal error in background process

ORA-31671: Worker process DW08 had an unhandled exception.

ORA-12801: error signaled in parallel query server P000, instance mynode0303:MYDB3 (3)

ORA-29913: error in executing ODCIEXTTABLEOPEN callout

ORA-31626: job does not exist

ORA-06512: at “SYS.ORACLE_DATAPUMP”, line 19

ORA-06512: at “SYS.KUPW$WORKER”, line 1342

ORA-06512: at line 2

January 30 2011

Oracle RAC 11.1.0.6.0 installation on AIX 6.1 Java issue.

Tagged Under : ,

Before start oracle RAC 11.1.0.6.0 installation on AIX 6.1 platform, you are require to install JDK to fix the Bug 9216848.

During the installation, on the “Select Installation Type”, pick the “Minimum” ratio button.

After JDK installed, you can continue to install oracle clusterware software and oracle rdbms software.