| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: CMAN not utilizing port 1521
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!
nah - leave that one alone (xdb).
add another dispatcher to the init.ora file (assuming that you are not
using an spfile.ora file).
<lazydba>
one way to do this is to use dbca to create a db with shared servers,
and copy the parameters over.
</laxydba>
It just so happens that I have the config files for a 9.2 on win32 mts setup for use with a locked down vpn - on the laptop.
this is mogrified to obfuscate the config used. I believe that it was entered with '\' used to continue the lines, but I don't recall right now. Its very verbose, so that fixed, known ports would be used. If you don't need to specify the ports, you could probably get away with:
dispatchers=(ADDRESS=(protocol=TCP))
I used 2 dispatchers in the event that one went down - you can use more or less.
bdbafh_at_mydb> show parameter dispatcher
NAME_COL_PLUS_SHOW_PARAM
hth.
-bdbafh Received on Tue Aug 10 2004 - 01:51:32 CDT
 |
 |