Sometimes you like to find out the hostname/IP address the sessions that came from.
onstat -g ses only display 8 characters out the hostname.
Use below query to retrive the hostname direct from sysmaster database :-
# dbaccess sysmaster -
SQL> select sid, username, hostname from syssessions where sid=session_id
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
Continue reading Oracle ORA-31671: Worker process DW08 had an unhandled exception. »
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.
Continue reading Oracle RAC 11.1.0.6.0 installation on AIX 6.1 Java issue. »