Q
Problem solve Get help with specific problems with your technologies, process and projects.

End of file on communication channel

I had to uninstall Oracle9i and reinstall it again, and during that process I encountered a TNS error, but I continued with the installation. After that I logged into PL/SQL to execute some scripts. After the execution it gave an 'end of file on communication channel' error. Why? (I have deactivated my firewall.)

I had to uninstall Oracle9i from my laptop running on Windows XP Home Edition. But I had to reinstall it again, and during that process I encountered a TNS error, but I continued with the installation. After that I logged into PL/SQL to execute some scripts. After the execution it gave an 'end of file on communication channel' error. Why is this so? (I have deactivated my firewall.)

If this error occurs only when you are running user-written PL/SQL scripts within SQL*Plus, it is quite likely that you are attempting to perform a task within the database but are not logged on. Adjust your scripts accordingly to ensure that a login occurs prior to making calls to Oracle.

If this error occurs when performing other actions, review the alert log to determine whether there are additional errors accompanying the ORA-3113 errors. This error may also appear if network connectivity issues cause a disconnection between your client and database server.

Dig Deeper on Using Oracle PL-SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close