Home » RDBMS Server » Server Administration » ORA-03113: end-of-file on communication channel
ORA-03113: end-of-file on communication channel [message #188857] Tue, 22 August 2006 02:44 Go to next message
rohank009
Messages: 9
Registered: April 2006
Location: India
Junior Member
Hi,

I am getting this error message,
while connecting to oracle.
I am able to login through sys user,
but when i try to login through other users it gives me
this error :-

ORA-03113: end-of-file on communication channel

Please help.

Thanks and Regards,
Rohan
Re: ORA-03113: end-of-file on communication channel [message #188872 is a reply to message #188857] Tue, 22 August 2006 04:19 Go to previous messageGo to next message
naveen19
Messages: 24
Registered: November 2005
Location: Chennai
Junior Member

Hi,

U have give proper privillege(connect,Resource,DBA) to the user's,which ru going to connect to the database.

and try to do this

Cheer's
Naveen
Re: ORA-03113: end-of-file on communication channel [message #188885 is a reply to message #188872] Tue, 22 August 2006 04:49 Go to previous messageGo to next message
rohank009
Messages: 9
Registered: April 2006
Location: India
Junior Member
Hi,
I am able to connect to the server with the system login (eg sys/sys123)through that particular machine only,
when i try to connect through some other machine,
it doesn't connect and gives me error that

ORA-12514 :- TNS Listener could not resolve SERVICE_NAME given in connect descriptor.
i hv checked both the tnsnames and listener.ora file,
my init.ora file has 'DEFAULT' specified in the database field.

Thanks and Regards,
Rohan
Re: ORA-03113: end-of-file on communication channel [message #188901 is a reply to message #188885] Tue, 22 August 2006 05:33 Go to previous messageGo to next message
rohank009
Messages: 9
Registered: April 2006
Location: India
Junior Member
Hi,

I have also checked the trc file,
it is giving me this error message

HS Agent diagnosed error on initial communication,
probable cause is an error in network administration
Network error 2: NCR-00002: NCR: Invalid usage.

Thanks and Regards,
Rohan
Re: ORA-03113: end-of-file on communication channel [message #200294 is a reply to message #188857] Mon, 30 October 2006 04:38 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Hi,

There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.

Babu
Previous Topic: How to configure RAC on 9.2 database
Next Topic: Oracle 9i version for Windows 2003 Server
Goto Forum:
  


Current Time: Sun Dec 04 08:38:39 CST 2016

Total time taken to generate the page: 0.07407 seconds