Thursday, February 21, 2013

Packaging an incident using ADRCI for Oracle Support

Sending a packaged incident to Oracle Support.

adrci> show homes
ADR Homes:
diag/clients/user_grid/host_1359114779_80
diag/clients/user_oracle/host_1359114779_80
diag/clients/user_oracle/host_1359114779_11
diag/rdbms/mydba/MYDBA1
diag/rdbms/mydbb/MYDBB1
diag/asm/+asm/+ASM1

adrci> set homepath diag/rdbms/mydba/MYDBA1

adrci> ips create package
Created package 1 without any contents, correlation level typical

adrci> ips show package
   PACKAGE_ID             1
   PACKAGE_NAME
   PACKAGE_DESCRIPTION
   DRIVING_PROBLEM        N/A
   DRIVING_PROBLEM_KEY    N/A
   DRIVING_INCIDENT       N/A
   DRIVING_INCIDENT_TIME  N/A
   STATUS                 New (0)
   CORRELATION_LEVEL      Typical (2)
   PROBLEMS               0 main problems, 0 correlated problems
   INCIDENTS              0 main incidents, 0 correlated incidents
   INCLUDED_FILES         0



adrci> ips add incident 7930 package 1;
Added incident 7930 to package 1

adrci> ips show package 1
DETAILS FOR PACKAGE 1:
   PACKAGE_ID             1
   PACKAGE_NAME
   PACKAGE_DESCRIPTION
   DRIVING_PROBLEM        N/A
   DRIVING_PROBLEM_KEY    N/A
   DRIVING_INCIDENT       N/A
   DRIVING_INCIDENT_TIME  N/A
   STATUS                 New (0)
   CORRELATION_LEVEL      Typical (2)
   PROBLEMS               1 main problems, 1 correlated problems
   INCIDENTS              1 main incidents, 11 correlated incidents
   INCLUDED_FILES         28
   SEQUENCES              Last 0, last full 0, last base 0
   UNPACKED               FALSE
   CREATE_TIME            2012-10-16 10:37:13.227548 +10:00
   UPDATE_TIME            2012-10-16 11:10:24.762948 +10:00
   BEGIN_TIME             N/A
   END_TIME               N/A
   FLAGS                  0
adrci> 

adrci> ips finalize package 1
Finalized package 1
adrci> show packages

adrci> ips generate package 1 in /mydir/mypackages/ips
Generated package 1 in file /mydir/mypackages/ips/IPSPKG_20121016103713_COM_1.zip, mode complete
adrci> exit

Thursday, February 7, 2013

Data pump, ORA-12161 TNS bad packet, ORA-12592 internal error.

Datapump import over database link failed with:
ORA-12161: TNS:internal error: partial data received
ORA-12592: TNS:bad packet

Solution was to disable ALG on the Juniper firewall. This is similar to another problem when using SCAN listeners and ALG enabled in the firewall.

Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [TABLE:"ME"."MYTAB"]
ORA-12161: TNS:internal error: partial data received
ORA-02063: preceding line from MYDB_LINK

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
3f7ed28b0     20462  package body SYS.KUPW$WORKER
3f7ed28b0      9028  package body SYS.KUPW$WORKER
3f7ed28b0     10935  package body SYS.KUPW$WORKER
3f7ed28b0      2728  package body SYS.KUPW$WORKER
3f7ed28b0      9697  package body SYS.KUPW$WORKER
3f7ed28b0      1775  package body SYS.KUPW$WORKER
3f7c070a8         2  anonymous block

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS [TABLE:"ME"."MYOTHERTAB"]
ORA-31600: invalid input value 100001 for parameter HANDLE in function CLOSE
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 544
ORA-06512: at "SYS.DBMS_METADATA", line 4187
ORA-06512: at "SYS.DBMS_METADATA", line 1475
ORA-06512: at "SYS.DBMS_METADATA", line 7481
ORA-06512: at "SYS.KUPW$WORKER", line 2792
ORA-02067: transaction or savepoint rollback required
ORA-06512: at "SYS.DBMS_METADATA", line 1475
ORA-06512: at "SYS.DBMS_METADATA", line 7481
ORA-06512: at "SYS.KUPW$WORKER", line 10928
ORA-12592: TNS:bad packet
ORA-02055: distributed update operation failed; rollback required
ORA-02063: preceding lines from MYDB_LINK

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
3f7ed28b0     20462  package body SYS.KUPW$WORKER
3f7ed28b0      9028  package body SYS.KUPW$WORKER
3f7ed28b0      9831  package body SYS.KUPW$WORKER
3f7ed28b0      1775  package body SYS.KUPW$WORKER
3f7c070a8         2  anonymous block

Job "ME"."IMPDP_TEST_JOB" stopped due to fatal error at 10:52:42