Oracle Database Discussions

Dear All,

Kindly note, in the alert log, I am getting the following Fatal Error and the connection breaks and TNS error is shown in the client side. On restart of the server the Oracle works fine. This happens once in 2 days.

When this happens, sometimes the Oracle service is stop sometimes not

Can anyone guid me please.

Regards,
Manoj
Kuwait



***********************************************************************

Fatal NI connect error 12560, connecting to:
(LOCAL=NO)

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.1.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.1.0.6.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.1.0.6.0 - Production
Time: 09-JAN-2011 09:00:00
Tracing not turned on.
Tns error struct:
ns main err code: 12560

Dump file g:\app\administrator\diag\rdbms\orcl\orcl\trace\alert_orcl.log
Sun Jan 09 09:00:00 2011
ORACLE V11.1.0.6.0 - 64bit Production vsnsta=0
vsnsql=15 vsnxtr=3
Sun Jan 09 09:12:13 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as G:\app\administrator\product\11.1.0\db_1\RDBMS
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =242
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.6.0.
Using parameter settings in server-side spfile G:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
processes = 2000

Edited by: user576147 on Jan 8, 2011 11:58 PM