Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: CMAN not utilizing port 1521

Re: CMAN not utilizing port 1521

From: Don <dkolva_at_atlab.com>
Date: 9 Aug 2004 18:27:48 -0700
Message-ID: <7f205d5c.0408091727.1d52bfee@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! Received on Mon Aug 09 2004 - 20:27:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US