No question at this time
DBA Top 10
1 M. Cadot 15900
2 A. Kavsek 11800
3 B. Vroman 10800
4 M. Hidayathullah ... 7600
5 T. Boles 4800
6 P. Wisse 4000
7 J. Schnackenberg 3000
8 K. Van Nieuwenhov... 2100
9 A. Hudspith 700
9 T. P 700
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48114
Total active users1700
Act. users last 24h12
Act. users last hour1
Registered user hits last week507
Registered user hits last month1127
Go up

Facing issue during applying PSU Patch July-2017 patch 26609783
Next thread: Enabling AMM automatic memory managment in oracle12c
Prev thread: views creation using impdp

Message Score Author Date
Dear Friends, I was facing issues during applyi...... Prasathi Ji Jan 11, 2018, 16:04
Hi Friends, Issue is resolved ,it has permissio...... Prasathi Ji Jan 17, 2018, 12:43

Follow up by mail Click here


Subject: Facing issue during applying PSU Patch July-2017 patch 26609783
Author: Prasathi Ji, India
Date: Jan 11, 2018, 16:04, 6 days ago
Message: Dear Friends,

I was facing issues during applying PSU Patch July-2017 patch 26609783.

1. opatch apply 26609783 is executed successfully.

/oracle/app/oracle/product/12.1.0.2/oracle12c/OPatch\>./opatch apply 26609783

We faced error during applying datapatch on database.We have multiple instance on databases on server.
Fire below command to update patch set in DB.


#OPatch\>./datapatch -verbose
If more than 2-3 instances then do as below
#Opatch\>./datapatch -verbose -db mydblv

Please refer log in error code section.


SQL> ALTER PROCEDURE sys.aps_validate COMPILE;
ALTER PROCEDURE sys.aps_validate COMPILE
*
ERROR at line 1:
ORA-04043: object APS_VALIDATE does not exist


SQL> ALTER VIEW sys.dba_aw_prop COMPILE;
ALTER VIEW sys.dba_aw_prop COMPILE
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> ALTER VIEW sys.user_aw_prop COMPILE;
ALTER VIEW sys.user_aw_prop COMPILE
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> ALTER VIEW sys.all_aw_prop COMPILE;
ALTER VIEW sys.all_aw_prop COMPILE
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> ALTER PACKAGE sys.dbms_cube COMPILE;
ALTER PACKAGE sys.dbms_cube COMPILE
*
ERROR at line 1:
ORA-04043: object DBMS_CUBE does not exist


S
LINE/COL ERROR
-------- -----------------------------------------------------------------
305/4 PLS-00201: identifier 'DBMS_LOB' must be declared
313/8 PL/SQL: Statement ignored
313/8 PLS-00201: identifier 'DBMS_LOB' must be declared
314/8 PL/SQL: Statement ignored
314/8 PLS-00201: identifier 'DBMS_LOB' must be declared
318/4 PL/SQL: Statement ignored
318/4 PLS-00201: identifier 'DBMS_LOB' must be declared

LINE/COL ERROR
-------- -----------------------------------------------------------------
319/4 PL/SQL: Statement ignored
319/4 PLS-00201: identifier 'DBMS_LOB' must be declared
940/3 PL/SQL: Statement ignored
940/10 PLS-00201: identifier 'DBMS_LOB' must be declared


SQL> SET PAGESIZE 10
SQL>
SQL> SPOOL off


Thanks in advance
Regards
Prasathiji
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Facing issue during applying PSU Patch July-2017 patch 26609783
Author: Prasathi Ji, India
Date: Jan 17, 2018, 12:43, 8 hours ago
Message: Hi Friends,

Issue is resolved ,it has permission issue.

Regards
Prasathi
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here