Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!news.glorb.com!postnews2.google.com!not-for-mail
From: dkolva@atlab.com (Don)
Newsgroups: comp.databases.oracle.server
Subject: CMAN not utilizing port 1521
Date: 8 Aug 2004 16:25:08 -0700
Organization: http://groups.google.com
Lines: 54
Message-ID: <7f205d5c.0408081525.2a3b0feb@posting.google.com>
NNTP-Posting-Host: 66.26.17.87
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1092007508 11277 127.0.0.1 (8 Aug 2004 23:25:08 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sun, 8 Aug 2004 23:25:08 +0000 (UTC)
Xref: core-easynews comp.databases.oracle.server:227825
X-Received-Date: Sun, 08 Aug 2004 16:24:04 MST (news.easynews.com)

Hello all, I'm having difficulty getting CMAN to work properly on a
Windows 2003 server.  The server is running CMAN and the database as
well.  It looks as though the connection is still getting forwarded to
a random high port (9298 in this example).  I am just learning Oracle,
so appreciate any help!

Thanks for all help in advance.

The following is in the cman.log:
====================================
(TIMESTAMP=08-AUG-2004 19:11:30)(EVENT=10)(VERSION=9.2.0.1.0)
(TIMESTAMP=08-AUG-2004 19:11:30)(EVENT=36)(RULE_LIST=)
(TIMESTAMP=08-AUG-2004
19:11:30)(EVENT=32)(PARAMETER_LIST=(MAXIMUM_RELAYS=1024)(RELAY_STATISTICS=yes)(AUTHENTICATION_LEVEL=0)(LOG_LEVEL=4)(SHOW_TNS_INFO=yes)(ANSWER_TIMEOUT=0)(MAXIMUM_CONNECT_DATA=1025)(USE_ASYNC_CALL=yes)(TRACING=no)(TRACE_DIRECTORY=default)(MAX_FREELIST_BUFFERS=0)(REMOTE_ADMIN=no))
(TIMESTAMP=08-AUG-2004 19:11:30)(EVENT=34)(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1630)))
(TIMESTAMP=08-AUG-2004
19:14:17)(EVENT=102)(RLYNO=0)(ADDRESS=(PROTOCOL=tcp)(HOST=66.26.17.87)(PORT=9298))
====================================

The cman.ora file is as follows:
====================================
cman = (ADDRESS_LIST=
           (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1630))
       )

cman_admin = (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1830))

cman_profile = (parameter_list=
                   (MAXIMUM_RELAYS=1024)
                   (LOG_LEVEL=16)
                   (TRACING=off)
                   (RELAY_STATISTICS=yes)
                   (SHOW_TNS_INFO=yes)
                   (USE_ASYNC_CALL=yes)
                   (AUTHENTICATION_LEVEL=0)
                   (REMOTE_ADMIN=FALSE)
               )
===================================

and the client tns.ora is as follows:
===================================
SLDBSRVR.ATL.LOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ourdomain.com)(PORT = 1630))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = SLDBSRVR)
      (SOURCE_ROUTE=YES)
    )
  )
====================================