OraFAQ Forum: Server Administration » end of file communication channel

Home » RDBMS Server » Server Administration » end of file communication channel (Oracle 9.2.0.5.0 Windows server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

end of file communication channel [message #383529]

Thu, 29 January 2009 01:31

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.

Report message to a moderator

Re: end of file communication channel [message #383534 is a reply to message #383529]

Thu, 29 January 2009 01:50

Michel Cadot
Messages: 68666
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

Report message to a moderator

Re: end of file communication channel [message #383536 is a reply to message #383534]

Thu, 29 January 2009 01:56

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Ok i will check and let you know.

thanks
Seenu.

Report message to a moderator

Re: end of file communication channel [message #383634 is a reply to message #383529]

Thu, 29 January 2009 07:07

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.

Report message to a moderator

Re: end of file communication channel [message #383635 is a reply to message #383634]

Thu, 29 January 2009 07:14

Michel Cadot
Messages: 68666
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

Report message to a moderator

Re: end of file communication channel [message #383636 is a reply to message #383635]

Thu, 29 January 2009 07:29

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.

Report message to a moderator

Re: end of file communication channel [message #383638 is a reply to message #383636]

Thu, 29 January 2009 07:34

Michel Cadot
Messages: 68666
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

Report message to a moderator

Re: end of file communication channel [message #383661 is a reply to message #383638]

Thu, 29 January 2009 10:16

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Yes mine is

NLS_CHARACTERSET=UTF8
NLS_NCHAR_CHARACTERSET=AL16UTF16.

Thanks & Regards,
Seenu.

Report message to a moderator

Re: end of file communication channel [message #383673 is a reply to message #383661]

Thu, 29 January 2009 11:07

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So it is very likely you hit this bug.

Regards
Michel

Report message to a moderator

Previous Topic:	migration from 9i to 10g
Next Topic:	scheduler job

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 04:49:37 CDT 2024