Oracle Database Appliance (ODA) (MOSC)

MOSC Banner

PSU patch

edited Dec 7, 2016 5:42PM in Oracle Database Appliance (ODA) (MOSC) 3 commentsAnswered ✓

Hi All,

Could someone please explain the purpose of each steps involved below for applying PSU patch in Oracle database?

Pre- checks

==================

1)Check the listener status using command ps -ef|grep tns

2)Check the DB instance status using command ps -ef|grep pmon

3)select OWNER,OBJECT_NAME,OBJECT_TYPE,CREATED,LAST_DDL_TIME,STATUS from dba_objects where status='INVALID';

4)select count(*) from dba_indexes where status='UNUSABLE';

5)select count(*) from dba_ind_partitions where status='UNUSABLE';

6)select count(*) from dba_ind_subpartitions where status='UNUSABLE';

7)select * from registry$history;

8)select COMP_ID,COMP_NAME,VERSION,STATUS,MODIFIED from dba_registry;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center