hello tamilselvan,dba,carp,mbhima
there is a problem with my db since 3 months.
ora-12560 tns protocol adapter error at server and at
client
ora- tns failed to start a dedicated server process.
listener also stops ,on restarting server for sometime it works fine but again the same problem starts.
i have checked tnsnames.ora and listener.ora ,if required i can give u the details of these 2 files.
2 times we formatted and loaded win -NT 4.0 and oracle 8i
on server,
20-23 days it worked fine but again today the same problem
started.
pl suggest soon.
this is the file detail
# E:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:E:\oracle\ora81\network\admin\listener.ora
# Generated by Oracle Net8 Assistant
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = appserver)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = appserver)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ortelapp)
(ORACLE_HOME = E:\oracle\ora81)
(SID_NAME = ORTELAPP)
)
)
tnsnames.ora
# E:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:E:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant
ORTELAPP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = appserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ortelapp)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
i have also checked the error message at technetoracle.com
the error explanation-
ORA-12560 TNSrotocol adapter error
This message indicates that there is a problem at the protocol adapter
level. That is, SQL*Net and the Interchange are functioning correctly,
but there is something wrong with the protocol adapter that underlies
them. The Oracle operating specific documentation for your platform
contains more information about the protocol adapters.
ORA-12560 TNSrotocol adapter error
Cause: A generic protocol adapter error occurred.
Action: Check addresses used for proper protocol specification.
Before reporting this error, look at the error stack and check for
lower level transport errors. For further details, turn on tracing
and reexecute the operation. Turn off tracing when the operation is
complete.
i have traced the error but did not get to make anything out.
pl suggest soon as this is urgent.
there is a problem with my db since 3 months.
ora-12560 tns protocol adapter error at server and at
client
ora- tns failed to start a dedicated server process.
listener also stops ,on restarting server for sometime it works fine but again the same problem starts.
i have checked tnsnames.ora and listener.ora ,if required i can give u the details of these 2 files.
2 times we formatted and loaded win -NT 4.0 and oracle 8i
on server,
20-23 days it worked fine but again today the same problem
started.
pl suggest soon.
this is the file detail
# E:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:E:\oracle\ora81\network\admin\listener.ora
# Generated by Oracle Net8 Assistant
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = appserver)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = appserver)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ortelapp)
(ORACLE_HOME = E:\oracle\ora81)
(SID_NAME = ORTELAPP)
)
)
tnsnames.ora
# E:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:E:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant
ORTELAPP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = appserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ortelapp)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
i have also checked the error message at technetoracle.com
the error explanation-
ORA-12560 TNSrotocol adapter error
This message indicates that there is a problem at the protocol adapter
level. That is, SQL*Net and the Interchange are functioning correctly,
but there is something wrong with the protocol adapter that underlies
them. The Oracle operating specific documentation for your platform
contains more information about the protocol adapters.
ORA-12560 TNSrotocol adapter error
Cause: A generic protocol adapter error occurred.
Action: Check addresses used for proper protocol specification.
Before reporting this error, look at the error stack and check for
lower level transport errors. For further details, turn on tracing
and reexecute the operation. Turn off tracing when the operation is
complete.
i have traced the error but did not get to make anything out.
pl suggest soon as this is urgent.