cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Database Packages and Types - 10.2.0.4.0 INVALID

Former Member
0 Kudos

Dear all,

We are have applied MOPatch for oracle 10.2.0.4 with the latest SBP SAP_102049_201109.zip. The patching was successful and continued running catsbp.sql.

The output was bit disappointing as there was some error was reported. We fixed one issue:

Patch 9352164 by running psu_root.sh and after that we ran utlrp.sql and found the bugs got reduced to 8.

Now after going through the log we found some errors,

ERROR at line 1:

ORA-04068: existing state of packages has been discarded

ORA-04061: existing state of package "SYS.DBMS_AQADM_SYSCALLS" has been invalidated

ORA-04065: not executed, altered or dropped package "SYS.DBMS_AQADM_SYSCALLS"

ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYSCALLS"

ORA-06512: at "SYS.DBMS_AQADM_SYS", line 4101

ORA-04061: existing state of package "SYS.DBMS_AQADM_SYSCALLS" has been invalidated

ORA-04065: not executed, altered or dropped package "SYS.DBMS_AQADM_SYSCALLS"

ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_AQADM_SYSCALLS"

ORA-06512: at line 7

We referred to SAP note Note 1509324 - catsbp.sql reports INCOMPLETE status.

and executed

select action_time from registry$history group by action_time having count(*) > 1;

but result was 0 rows.

also we are trying to run, catsbp.sql but throws the message "

-


SQL> @?/sapbundle/SAP_102049_201109/catsbp.sql

SP2-0606: Cannot create SPOOL file "/oracle/SID/102_64/cfgtoollogs/catbundle/SAP_10.2.0.4.9_201109_2011Dec17_23_53_16.log"

O/S Message: Permission denied

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

-


Need help in resolving this issue.

Thanks,

Rableen

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

> also we are trying to run, catsbp.sql but throws the message "

> -


> SQL> @?/sapbundle/SAP_102049_201109/catsbp.sql

> SP2-0606: Cannot create SPOOL file "/oracle/SID/102_64/cfgtoollogs/catbundle/SAP_10.2.0.4.9_201109_2011Dec17_23_53_16.log"

> O/S Message: Permission denied

I still have to go through whole of the problem here, but for now, for this catsbp.sql I think the problem is related to filesystem/directory/file permission.

Seems the user orasid is either not authorized for this directory or file /sapbundle/SAP_102049_201109/catsbp.sql (check the permission/owner for both dir and file) or not authorized for this path "/oracle/SID/102_64/cfgtoollogs/catbundle/SAP_10.2.0.4.9_201109_2011Dec17_23_53_16.log"

Thanks

Former Member
0 Kudos

Hi,

Thatwa an authorization issue, but after again running query @utlrp.sql we found the following error:

PL/SQL procedure successfully completed:

DOC> The following query reports the number of objects that have compiled

DOC> with errors (objects that compile with errors have status set to 3 in

DOC> obj$). If the number is higher than expected, please examine the error

DOC> messages reported with each object (using SHOW ERRORS) to see if they

DOC> point to system misconfiguration or resource constraints that must be

DOC> fixed before attempting to recompile these objects.

DOC>#

OBJECTS WITH ERRORS

-


7

DOC> The following query reports the number of errors caught during

DOC> recompilation. If this number is non-zero, please query the error

DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors

DOC> are due to misconfiguration or resource constraints that must be

DOC> fixed before objects can compile successfully.

DOC>#

ERRORS DURING RECOMPILATION

-


1

Need to know, how these errors can be fixed.

Thanks,

Rableen

Former Member
0 Kudos

Hi,

We tried few commands and found few objects which contains bugs:

SELECT SUBSTR(OWNER, 1, 20) OWNER, SUBSTR(OBJECT_NAME, 1, 35) OBJECT_NAME, SUBSTR(OBJECT_TYPE, 1, 20) OBJECT_TYPE FROM DBA_OBJECTS WHERE STATUS = 'INVALID';

OWNER

-


OBJECT_NAME

-


OBJECT_TYPE

-


SYS

AQ$_KUPC$DATAPUMP_QUETAB_V

EVALUATION CONTEXT

SYS

KUPC$DATAPUMP_QUETAB

TABLE

OWNER

-


OBJECT_NAME

-


OBJECT_TYPE

-


SYS

SYSNTtDihchKZAJLgQ8CgCikAkg==

TABLE

SYS

SYSNTtDihchKbAJLgQ8CgCikAkg==

OWNER

-


OBJECT_NAME

-


OBJECT_TYPE

-


TABLE

SYS

SYSNTtDihchKdAJLgQ8CgCikAkg==

TABLE

SYS

OWNER

-


OBJECT_NAME

-


OBJECT_TYPE

-


AQ$_KUPC$DATAPUMP_QUETAB_E

QUEUE

SYS

AQ$_KUPC$DATAPUMP_QUETAB_F

VIEW

OWNER

-


OBJECT_NAME

-


OBJECT_TYPE

-


SYS

AQ$KUPC$DATAPUMP_QUETAB

VIEW

8 rows selected.

SELECT O.NAME FROM OBJ$ O, REGISTRY$ R WHERE O.STATUS > 1 AND (O.CTIME BETWEEN R.DATE_LOADING AND R.DATE_LOADED OR O.MTIME BETWEEN R.DATE_LOADING AND R.DATE_LOADED OR O.STIME BETWEEN R.DATE_LOADING AND R.DATE_LOADED);

NAME

-


AQ$_KUPC$DATAPUMP_QUETAB_V

KUPC$DATAPUMP_QUETAB

SYSNTtDihchKZAJLgQ8CgCikAkg==

SYSNTtDihchKbAJLgQ8CgCikAkg==

SYSNTtDihchKdAJLgQ8CgCikAkg==

AQ$_KUPC$DATAPUMP_QUETAB_E

AQ$_KUPC$DATAPUMP_QUETAB_F

AQ$KUPC$DATAPUMP_QUETAB

Please help us, so that we can proceed.

Regards,

Rableen

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

My solution to the event

 

SP2-0606: Cannot create SPOOL file
"/oracle/cfgtoollogs/catbundle/SBP_1120211_201308_BOR_2013Nov12_09_47_45.log"

O/S Message: Permission denied

was to add write permissions in the target directory in the SRP configuration for the database owner:

cmpt:# whoami

root

cmpt:# pwd

/etc/cmpt

cmpt:# diff /etc/cmpt/BOR_INST.h.orig /etc/cmpt/BOR_INST.h

19a20,23

> // added to install Oracle patch - begin

> perm all /oracle/cfgtoollogs

> perm all /oracle/cfgtoollogs/catbundle

> // added to install Oracle patch - end

cmpt:# setrules

setrules:
warning ignoring one or more rules that reference "init" compartment
as "init" compartment is not redefined

Kind regards

Ludvik