I applied a patch for upgrading from 9.2.0.1.0 to 9.2.0.5.0 patch no.3501955.

patch was updated successfully.

actually i am using advance queuing. now even if i am stopping a queue it gives me error: ORA-03113: end-of-file on communication channel

when i am trying to drop the user which contains aq configuration then also it is giving me error: ORA-03113: end-of-file on communication channel

I am using oracle standard edition on windows 2000 server

Answer by forum member:

Execute the post execution steps for the patch, and those are as follows

1. Run the startup migrate command.  If you are running Oracle Real Applications Clusters, set cluster_database in the initSID.ora file to FALSE prior to starting in migrate mode.

2. Run the spool patch.log command.

3. Run the @\rdbms\admin\catpatch.sql script.

4. Run the spool off command.

5. Review the patch.log file for errors, and rerun the catpatch.sql script after correcting any problems.

6. Run the shutdown command.

7. Run the startup command.

8. Run the ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql script.  This step is optional, and will recompile all invalid PL/SQL packages now instead of when the packages are accessed the first time. You can use the utlrcmp.sql script to parallelize this in multiprocessor computers.

 9. Run the exit command.