mardi 19 février 2013

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UPATE_TD_


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "DBADM"."SYS_IMPORT_FULL_03" successfully loaded/unloaded
Starting "DBADM"."SYS_IMPORT_FULL_03":  dbadm/******** full=y directory=imp_dir dumpfile=exptestcmovel.dmp exclude=statistics content=DATA_ONLY logfile=imptest.log
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UPATE_TD_ROW_IMP [62]
TABLE_DATA:"AGENTCOMM"."COMMISSION_EXCLUSION_LIST"
ORA-31603: object "COMMISSION_EXCLUSION_LIST" of type TABLE not found in schema "AGENTCOMM"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 8170


(one of the )Problem : content=DATA_ONLY

 dbadm/******** full=y directory=imp_dir dumpfile=exptestcmovel.dmp exclude=statistics content=DATA_ONLY logfile=imptest.log

(one of the) SOLUTION do not uset Content Data Only

dbadm/******** full=y directory=imp_dir dumpfile=exptestcmovel.dmp exclude=statistics logfile=imptest.log


Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "DBADM"."SYS_IMPORT_FULL_04" successfully loaded/unloaded
Starting "DBADM"."SYS_IMPORT_FULL_04":  dbadm/******** full=y directory=imp_dir dumpfile=exptestcmovel.dmp exclude=statistics logfile=imptest.log
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
.
.
.









RMAN-06004: ORACLE error from recovery catalog database: ORA-03113: end-of-file on communication channel


.
.

channel ORA_DISK_2: finished piece 7 at 19-FEB-13
piece handle=/backup/oracle/CMOVP/rman/25o2bs8k_7_1 tag=TAG20130219T105516 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 01:01:21
Finished backup at 19-FEB-13

Starting backup at 19-FEB-13
current log archived

Starting backup at 19-FEB-13
current log archived
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 02/19/2013 12:12:21
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: ORA-03113: end-of-file on communication channel
Process ID: 27169
Session ID: 133 Serial number: 6861
ORACLE error from recovery catalog database: ORA-03114: not connected to ORACLE

Problem : The RMAN REPOSITORY was in a diffrent platform (Linux) Target - (Solaris) Repository
Solution : Do not use the Respoitory

mardi 12 février 2013

/usr/bin/xauth: file /home/oracle/.Xauthority does not exist


In My Case :
IF ERROR on LOGIN :
/usr/bin/xauth:  file /home/oracle/.Xauthority does not exist

Check The /etc/passwd

oinstall:x:1001:1001::/home/oinstall:/bin/sh
oracle:x:1002:1001::/home/oracle:/bin/sh

REPLACE /bin/sh with /bin/bash
oinstall:x:1001:1001::/home/oinstall:/bin/bash
oracle:x:1002:1001::/home/oracle:/bin/bash