Home » RDBMS Server » Server Administration » droping the queue tables
droping the queue tables [message #207078] Mon, 04 December 2006 01:52 Go to next message
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 #207082 is a reply to message #207078] Mon, 04 December 2006 02:01 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi ,

For ora-03113 ..
first check alert.log files
or
any trace files generate during this error. and post here.

regards
Taj

Re: droping the queue tables [message #207096 is a reply to message #207082] Mon, 04 December 2006 02:39 Go to previous messageGo to next message
m.arunrajkumar
Messages: 13
Registered: July 2005
Location: Chennai-India
Junior Member

hi,

where will this trace file or log will reside...


regards,

Arun
Re: droping the queue tables [message #207098 is a reply to message #207096] Mon, 04 December 2006 02:41 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,

oraclehome/admin/bdump/alert<sid>.log
and trace files.

also check
oraclehome/admin/udump/for any trace files

first see alert.log you will get ur reason on alert.log files..

and post here.


regards
taj
Re: droping the queue tables [message #207113 is a reply to message #207098] Mon, 04 December 2006 03:29 Go to previous message
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
Previous Topic: what is diff between "Create pfile from spfile and Create spfile from pfile"
Next Topic: Oracle start/shutdown with non sysdba account
Goto Forum:
  


Current Time: Thu Dec 08 20:29:42 CST 2016

Total time taken to generate the page: 0.25114 seconds