Home » RDBMS Server » Server Administration » end of file communication channel (Oracle 9.2.0.5.0 Windows server 2003)
end of file communication channel [message #383529] Thu, 29 January 2009 01:31 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


Hi Everybody,

I have used the below command to extract the ddl of the tablespaces but when i execute this command in the server i get

the error as below.

SQL> select dbms_metadata.get_ddl('TABLESPACE','TOOLS') FROM DUAL;


ORA-03113 End of file on communication channel.

no rows selected.

But i have used the command in other database it works well.

Someone might have experienced this.

Thanks & Regards,
Seenu.
Re: end of file communication channel [message #383534 is a reply to message #383529] Thu, 29 January 2009 01:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check if there was any connection problem or error in alert.log.
Otherwise ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support.

Regards
Michel

Re: end of file communication channel [message #383536 is a reply to message #383534] Thu, 29 January 2009 01:56 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


Ok i will check and let you know.

thanks
Seenu.
Re: end of file communication channel [message #383634 is a reply to message #383529] Thu, 29 January 2009 07:07 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member

Hi Michel,

I didn't find any errors or information recorded in alert.log file.

And no trace files are also generated. I ran the commands several times and everytime i get the same response.

Thanks & Regards,
Seenu.
Re: end of file communication channel [message #383635 is a reply to message #383634] Thu, 29 January 2009 07:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you are hitting a bug and should search on Metalink and if you don't find anything you have to call Oracle support.

Regards
Michel
Re: end of file communication channel [message #383636 is a reply to message #383635] Thu, 29 January 2009 07:29 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


Yes Michel you are right.

I have searched and the bug no is 3022016.

It is said that it is fixed in 10.1 version.

I am searching for an workaround other than upgrading my database.

Thanks for your information.
Seenu.
Re: end of file communication channel [message #383638 is a reply to message #383636] Thu, 29 January 2009 07:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you notice that the bug is related to AL32UTF8 database character set?
Is this your case?

Regards
Michel


Re: end of file communication channel [message #383661 is a reply to message #383638] Thu, 29 January 2009 10:16 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


Yes mine is

NLS_CHARACTERSET=UTF8
NLS_NCHAR_CHARACTERSET=AL16UTF16.

Thanks & Regards,
Seenu.
Re: end of file communication channel [message #383673 is a reply to message #383661] Thu, 29 January 2009 11:07 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So it is very likely you hit this bug.

Regards
Michel
Previous Topic: migration from 9i to 10g
Next Topic: scheduler job
Goto Forum:
  


Current Time: Fri Dec 09 07:35:05 CST 2016

Total time taken to generate the page: 0.09374 seconds