Need to Kill j000 process to shutdown the database after upgrade from 8.1.7.4 to 9.2.0.8.

This is a common problem after the upgrade. One important point to remember is to disable all the schedules for dbms jobs before kicking off the upgrade and enable the schedule after the uprade is over. Alternatively job_queue_processes parameter can be set to '0'.

You see following symptoms in the alert log.

-- Clip --

Active call for process 21244 user 'oracle' program 'oracle@hostname (J000)'
SHUTDOWN: waiting for active calls to complete.

-- End Clip --

Trace File of J000 process shows

-- Clip --

Unix process pid: 13302, image: oracle@hostname (J000)

*** SESSION ID:(95.9333) 2007-12-14 22:50:52.282
OPIRIP: Uncaught error 1089. Error stack:
ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-00448: normal completion of background process

-- End Clip --


Reference - Metalik Note:342805.1

After 9.2.0.8 patchset adgrants.sql fails "O/S Message: No such file or directory"

SYMPTOM:

sqlplus "/ as sysdba" @adgrants.sql

SQL*Plus: Release 9.2.0.8.0 - Production on Sun Nov 18 16:14:16 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

O/S Message: No such file or directory

SQL*PLUS exits O/S message "No such file or directory" or "Permission denied"


Solution:

Apply the RDBMS patch 5495695. Review the README.txt for instructions.