Thanks Hans, I'll try Metalink.

Vern

"Hans Forbrich" <forbrich (AT) yahoo (DOT) net> wrote

Hans Forbrich wrote:

Not being familiar with this combo, it might be worth while
trying to set use_shared_socket=true in the environment.
It should make all connections going thru the listener port
socket (1521 in your case).

Ymmv!
--

Regards,
Frank van Bortel

Thanks Frank, I'll give that a try. Incidentally, I found a method using a
configuration file called cman.ora. I followed the instructions but it
didn't work in the Novell environment. I think that maybe it is for Unix.
The contents of the method is as follows... I hope it'll help someone else.

# Installation and configuration of CMAN

# The installation must be done on the server where the database is. After
the installation we need to start the services (cmctl start or in services)
# Configuration has two steps, configuration of server side and
configuration of client side. # Configuration of CMAN in server side # We
need to create the cman.ora file in $ORACLE_HOME\network\admin

# It could be like this:

CMAN = (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.254)(PORT=1 610))

CMAN_PROFILE=
(PARAMETER_LIST=
(MAXIMUM_RELAYS=70)
(LOG_LEVEL=0)
(TRACING=NO)
(RELAY_STATISTICS=NO)
(SHOW_TNS_INFO=NO)
(USE_ASYNC_CALL=NO)
(AUTHENTICATION_LEVEL=0)
)

# Configuration of client

# We need to configure the client to use CMAN. It is needed make some
changes in tnsnames.ora and sqlnet.ora

TNSNAMES.ORA

sid_db.WORLD=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=xxxxx)
(PORT=1610)
)
(ADDRESS=
(PROTOCOL=TCP)
(HOST=xxxxx)
(PORT=1521)
)
)
(CONNECT_DATA=
(SID=sid_db)
(SOURCE_ROUTE=YES)
)
)
)

SQLNET.ORA

# We should say that sqlnet will use CMAN, so add this parameter to the
file:

USE_CMAN=TRUE




Vern

"Frank van Bortel" <fvanbortel (AT) netscape (DOT) net> wrote