Re: CMAN not utilizing port 1521

sybrandb_at_yahoo.com wrote in message news:<a1d154f4.0408092355.75da0cc2_at_posting.google.com>...
> dkolva_at_atlab.com (Don) wrote in message news:<7f205d5c.0408091727.1d52bfee_at_posting.google.com>...
> > bdbafh_at_gmail.com (Paul Drake) wrote in message news:<910046b4.0408090936.21f02ff6_at_posting.google.com>...
> > > dkolva_at_atlab.com (Don) wrote in message news:<7f205d5c.0408090416.41b81b12_at_posting.google.com>...
> > > > bdbafh_at_gmail.com (Paul Drake) wrote in message news:<910046b4.0408082141.7a3cc55a_at_posting.google.com>...
> > > > > dkolva_at_atlab.com (Don) wrote in message news:<7f205d5c.0408081525.2a3b0feb_at_posting.google.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)
> > > > > > )
> > > > > > )
> > > > > > ====================================
> > > > >
> > > > > take:
> > > > > (ADDRESS = (PROTOCOL = TCP)(HOST = ourdomain.com)(PORT = 1630))
> > > > > (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
> > > > >
> > > > > and replace it with:
> > > > > (ADDRESS = (PROTOCOL = TCP)(HOST = ourdomain.com)(PORT = 1630))
> > > > > (ADDRESS = (PROTOCOL = TCP)(HOST = ourdomain.com)(PORT = 1521))
> > > > >
> > > > > and you should be set.
> > > > >
> > > > > -bdbafh
> > > >
> > > > Paul,
> > > >
> > > > Thanks for the posting. I had tried that, but still no joy. Any other ideas?
> > >
> > > 1. In your sqlnet.ora, is the parameter names.default_domain
> > > populated?
> > > The string "SERVICE_NAME" is not a fully qualified name, try using
> > > service_name = global_name = instance_name || db_domain
> > >
> > > 2. Are you sure that the string "ourdomain.com" resolves to a single
> > > host?
> > > I realize that you most likely did that to make this text
> > > anonymous.
> > >
> > > 3. What services and dispatchers are registered with the listener?
> > > in lsnrctl,
> > >
> > > C:\> lsnrctl
> > > LSNRCTL> set password
> > >
> > > LSNRCTL> set displaymode verbose
> > > LSNRCTL> services
> > >
> > > It sounds as if the session handled by cman is not handing off to a
> > > dispatcher.
> > >
> > > Are you using a dynamically assigned port for the dispatcher, or a
> > > statically named port?
> > >
> > > hth.
> > >
> > > -bdbafh
> >
> > Paul,
> >
> > 1. The sqlnet.ora file on the server contains the name of the
> > internal domain:
> > =============
> > NAMES.DEFAULT_DOMAIN = ATL.local
> > SQLNET.AUTHENTICATION_SERVICES= (NTS)
> > NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
> > =============
> >
> > 2. Yes, the ourdomain.com does resolve to the database server - name
> > changed to protect the innocent ;)
> >
> > 3. Services gives:
> > =============
> > Service "sldbsrvr" has 2 instance(s).
> > Instance "sldbsrvr", status UNKNOWN, has 1 handler(s) for this
> > service.
> > Handler(s):
> > "DEDICATED" established:0 refused:0
> > LOCAL SERVER
> > Instance "sldbsrvr", status READY, has 1 handler(s) for this
> > service...
> > Handler(s):
> > "DEDICATED" established:20 refused:0 state:ready
> > LOCAL SERVER
> > Service "sldbsrvrXDB" has 1 instance(s).
> > Instance "sldbsrvr", status READY, has 1 handler(s) for this
> > service...
> > Handler(s):
> > "D000" established:0 refused:0 current:0 max:1002 state:ready
> > DISPATCHER <machine: SL_DB_SRVR, pid: 6448>
> > (ADDRESS=(PROTOCOL=tcp)(HOST=sl_db_srvr.ATL.local)(PORT=32952))
> > ==============
> >
> > I think that you hit the nail on the head. Looking at the
> > inialization parameters for the database, shows
> > dispatchers=(PROTOCOL=TCP) (SERVICE=sldbsrvrXDB), which appear to be
> > getting a dynamic port (32952 in this case).
> >
> > Being totally ignorant of Oracle, can I utilize lsnrctl to set the
> > port for the sldbsrvrXDB?
> >
> > Thanks for all the help!
>
>
> No, you can't. Nor do you need to. The dispatcher communicates with
> Connection Manager only, when the client connects through connection
> manager.
> Please read up on how connection manager works in the net8
> administrators manual.
> If you still think you need to set an explicit port, you can read in
> the same manual how to change the mts_dispatchers parameter.
>
> Sybrand Bakker
> Senior Oracle DBA

Sybrand,

I've read the manual on how connection manager works, but don't seem to have it configured to port redirect like it should. It should read the port from the client connection, but in my case, it still appears to be selecting a random high port.

Any other ideas? Received on Tue Aug 10 2004 - 19:18:48 CDT