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
Reference to Metalink Doc 861152.1, to determine PSU version installed in your Oracle Home :-
1) Ensure that opatch version is having version of at least / or higher than :-
10.2.0.4.5 for version 10gR2 Oracle Home
11.1.0.6.5 for version 11gR1 Oracle Home
11.2.0.1.0 for version 11gR2 Oracle Home