| Oracle Connection Manager - ORA-12564 and TNS-04002 [message #116586] |
Wed, 20 April 2005 14:20  |
dmauldin
Messages: 3
Registered: April 2005
|
Junior Member |
|
|
Hello,
I have an oracle 8.1.7 database on a sun server and an apache webserver on linux redhat with oracle 8.1.7 oracle connection manager installed. The java applets on the webserver cannot get a connection to the database server.
When I try to start up oracle connection manager on the webserver using cmctl start, it prints:
ADMIN Status:
(STATUS=(VERSION=8.1.7.0.0)(STARTED=20-APR-2005 12:07:01)(STATE=RUNNING))
TNS-04002:CMCTL: error while starting the Connection Manager
However, when I check the running processes I have:
/home/oracle/bin/cmadmin cman
/home/oracle/bin cmgw
When I run netasst and try to 'Test' the connection for the oracle connection manager, it gives me:
ORA-12564: TNS: connection refused
However, when I 'Test' a separate connection that just directly connects to the database on the database server, that works (DBID). This indicates that it seems to be a problem with the connection manager running on the webserver. I have tracing on, but I can't tell what I'm looking for and all of the exits seem to be normal. The final lines in the cman trace file are:
nsevwait: entry
nsevwait: 1 registered connection(s)
nsevwait: 0 added to NT list for 0x8
nsevwait: 0 pre-posted event(s)
nsevwait: waiting for transport event (0 thru 0)...
ntctst: size of NTTEST list is 1 - not calling poll
sntseltst: Testing for CONNECTIONS on socket 6
However, running trcasst -e on the files shows the following for both the cman trace and the cmadm trace.
TNS-04233: Trace Assistant WARNING: Going beyond Packet length
TNS-04233: Trace Assistant WARNING: Going beyond Packet length
TNS-04233: Trace Assistant WARNING: Going beyond Packet length
TNS-04206: Trace Assistant Internal ERROR: Packet Type
I'd appreciate any help or advice on what to do next on troubleshooting or if you guys can diagnose something.
Denise
cman.ora:
CMAN = (ADDRESS=(PROTOCOL=tcp)(HOST=webserver)(PORT=1610))
CMAN_ADMIN = (ADDRESS=(PROTOCOL=tcp)(HOST=webserver)(PORT=1650))
CMAN_RULES=(RULE_LIST=
(RULE = (SRC=netmask)
(DST=netmask)
(SRV=database sever)
(ACT=ACC)
)
)
CMAN_PROFILE = (PARAMETER_LIST=
(MAXIMUM_RELAYS=512)
(LOG_LEVEL=1)
(TRACING=YES)
(SHOW_TNS_INFO=YES)
(RELAY_STATISTICS=NO)
)
tnsnames.ora:
webserver_cman =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = webserver)(PORT = 1610))
(ADDRESS = (PROTOCOL = TCP)(HOST = databaseserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DBID)
)
(SOURCE_ROUTE = yes)
)
DBID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = databaseserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DBID)
)
(SOURCE_ROUTE = yes)
)
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
