| Conection Problem with Pro*c [message #94434] |
Thu, 28 October 2004 21:33  |
alok
Messages: 12
Registered: December 2000
|
Junior Member |
|
|
Hello Everyone!!!
I have a Server application written in pro*C. This application connects remotely with Oracle DataBase 9i running in redhat linux 8.0, using the oracle client 9.2.0.4.
My application fork serveral child process, and each one keep the connection with the database to server various requests.
But to my surprise after several transactions with the DataBase, the child process is locked waiting for answer from oracle, and all process are just in no response state without any error or any message. every now and then i restart the application it works as
fine. but again same problem ...
ocassionally i encounter with ORA- 03113 end of file on communication channel error message.
e.g i am using the following connection string "db_con" now,
EXEC SQL CONNECT :username IDENTIFIED BY :password AT :db_con USING :db_name;
Is there any additinal parameter i have to add in the connection string.
pls can anybody help me out ... what could be the issue with the oracle server or my client application.
thanx !!!
alok
|
|
|
|
| Re: Conection Problem with Pro*c [message #94437 is a reply to message #94434] |
Fri, 29 October 2004 00:59  |
Pedro
Messages: 8
Registered: October 2002
|
Junior Member |
|
|
Hi.
well, Iīm just starting with Oracle and donīt know much about this... but have you edited the alert.log file?
I suppose that it will give you more information.
pedro.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
