Hello all,
On my production server I have error ORA-03114: not connected to Oracle.
Some users are being disconnected, but after some time, the users can connect again.

Anybode have faced with this error?

Hello All,
Any idea?

Thank you in advance.

Can be just about anything.

ORA-3114
A call to Oracle was attempted when no connection was established. Usually this happens because a user-written program has not logged on. It may happen if communication trouble causes a disconnection. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request.

check your alert log.

Dave

Hello Dave,
I have checked the alert.log, file and no found any issue about ORA-3114.
The only file where I find that is on the application server side, on oracle8.log file.

Any suggestion?
Thank you in advance.

Can you post the actual error from the log then?

Dave

Hello Dave,
I´m sending my oracle8.log file

2009-01-09[17:16:20]:E:root:
2009-01-09[17:16:20]:E:root: ******* S T A R T of Error message *******
2009-01-09[17:16:20]:E:root: Log message called from /BAAN/view/port.6.1c.07.20/vobs/tt/servers/ORACLE_2/ora_native.c: #2189 keyword: Oracle Error
2009-01-09[17:16:20]:E:root: Pid 3364 Uid 0 Euid 0 Gid 0 Egid 0
2009-01-09[17:16:20]:E:root: user_type S language 2 user_name root tty 1 locale ISO88591/NULL
2009-01-09[17:16:20]:E:root: Errno 0 bdb_errno 110 (End of file reached)
2009-01-09[17:16:20]:E:root:
2009-01-09[17:16:20]:E:root: dbs_errno = 0, Error 522 occurred:
2009-01-09[17:16:20]:E:root: Error ORA-3114 occurred during commit.
2009-01-09[17:16:20]:E:root: ORA-03114: not connected to ORACLE
2009-01-09[17:16:20]:E:root:
2009-01-09[17:16:20]:E:root: Error BDB-522 returned.
2009-01-09[17:16:20]:E:root: Flushed at /BAAN/view/port.6.1c.07.20/vobs/tt/servers/ORACLE_2/ora_db.c : #74.
2009-01-09[17:16:20]:E:root: ******* E N D of Error message *******
2009-01-09[17:16:30]:E:root:

Thank you in advance.

well, that doesn't help much. can you reproduce it at will?

Hello Dave,
In fact, in oracle8.log I can see that event every 10 minutes average.

Regards.

oh. that's the printer daemon.

You brought down baan and/or the database and didn't bring down pdaemon6.X
(rc.stop rarely brings it down correctly)

Just stop and restart it and the error will go away.

Dave

Hello Dave,
Thank you for your answer. Yes, I have stop and reestart the app server and no error have been logged on oracle8.log

Thank you, again.

Regards.