| droping the queue tables [message #207078] |
Mon, 04 December 2006 01:52  |
m.arunrajkumar
Messages: 13
Registered: July 2005
Location: Chennai-India
|
Junior Member |
|
|
Hi,
While droping the queue tables i am facing this problem.
SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'IFTB_ONLN_IN_QU_V',force =>
TRUE);
BEGIN DBMS_AQADM.DROP_QUEUE_TABLE(queue_table=>'IFTB_ONLN_IN_QU_V',force => TRUE
); END;
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel.
Can any one give help out me in solving this. It's urgent.
Regrds,
Arun
|
|
|
|
|
|
|
|
|
|
| Re: droping the queue tables [message #207113 is a reply to message #207098] |
Mon, 04 December 2006 03:29  |
m.arunrajkumar
Messages: 13
Registered: July 2005
Location: Chennai-India
|
Junior Member |
|
|
Hi taj,
Thanks for ur support.. problem has been solved. I got solution from the following..
Errors
ORA-3113 "end-of-file on communication channel"
Symptoms
After applying a patchset such as 9.2.0.4 or 9.2.0.5, receiving an ORA-3113 error when dropping a queue table.
For example:
EXECUTE dbms_aqadm.drop_queue_table (queue_table => 'QTAB',force => TRUE);
BEGIN dbms_aqadm.drop_queue_table (queue_table => 'QTAB',force => TRUE); END;
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Changes
Installation of 9.2.0.x patchset
Cause
Patchset steps not followed completely.
The patchset was installed, but post installation steps including running catpatch.sql script were not done.
Fix
Start the database in migrate mode and run the catpatch.sql script.
Follow any additional steps in the patchset installation instructions.
For example:
- Shutdown the database
- Startup migrate
- Run the $ORACLE_HOME/rdbms/admin/catpatch.sql script
- Shutdown database
- Startup database
regards,
Arun
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
