on 12-17-2011 6:35 PM
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
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.