| HELP!! ora-03113 end of file on communication channel [message #50435] |
Thu, 14 March 2002 17:37  |
Ben Tran
Messages: 2
Registered: March 2002
|
Junior Member |
|
|
i'm connecting to an oracle 8.1.7 database through the web. i have oracle 8i client installed on my machine and i use embarcadero rapid sql for development. i can successfully connect to the db, but when i run a simple query, the ora-03113 message occurs.
i've already checked the sqlnet.ora and made the suggested changes:
SQLNET.AUTHENTICATION_SERVICES= (NONE)
but still no luck.
other client machines within my network don't experience the same problem.
also, these problems do not occur when i run the queries in sql+.
any suggestions will definitely be appreciated!!!!
Ben
cmptr_kemist@yahoo.com
|
|
|
|
| Re: HELP!! ora-03113 end of file on communication channel [message #50501 is a reply to message #50435] |
Mon, 18 March 2002 22:53  |
Lapenkov V.
Messages: 8
Registered: March 2002
|
Junior Member |
|
|
I've encountered the same problem when I tried to initialize an instance I created before. Try to diminish the number of processes in initSID.ora
If you use unix,probably the error takes place due to incorrect kernel parameters which are not enough to allocate some system memory for SGA . Try to explicitly increase shmmax to about 4 or more Gb.
I hope this helps
|
|
|
|
|
|
|
|
| Re: HELP!! ora-03113 end of file on communication channel [message #57159 is a reply to message #50501] |
Fri, 23 May 2003 03:46 |
RCHU
Messages: 3
Registered: May 2003
|
Junior Member |
|
|
|
I experience end of file on communication channel while I am in DBMS_ALERT.WAITONE, but, to make the matter worse, this problem happens intermittently, especially when the waiting time is longer than 2 hours. This problem does not exist in SQL+ and this problem does not exist in Oracle 8.1.6. Recently, we upgraded to 8.1.7 and a new HP rp7410 and this problem begins to surface.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
