Home » RDBMS Server » Networking and Gateways » Connection Manager woes (Oracle 10.0.2.0, Windows 2003 x64)
Connection Manager woes [message #326781] Thu, 12 June 2008 10:21 Go to next message
rjebb
Messages: 2
Registered: June 2008
Junior Member
Hi

I am trying to set up a server to provide a development/test environment for a project we are just starting. I have installed 10.0.2.0 Enterprise Edition, created 2 databases and imported the backup files from the customer. I can use sqlplus and Enterprise Manager on the server and verify that all seems OK.

As we will have some external developers working on the project I have also installed Connection Manager on the box so that we can selectively restrict remote access to the server. I have never used Connection Manager before and I'm struggling to get things working as far as remote access is concerned.

What I have done so far (after reading many pages of Oracle docs) is:

- copied the sample cman.ora from \network\admin\sample to \network\admin and inserted hostname etc as instructed in the header block. I have had to change the port number in the address section from 1521 to 1522 as otherwise I couldn't start the cman listener. It originally complained 1521 was already in use, but now I can see the service has started OK.

- set remote_listener to "listener_cman" in the initialisation parameters

- added another entry in the tnsnames.ora on the server to define "listener_cman"

I still can't get a connection to the database though. The various files currently look like this:

Server End
=================================================================

tnsnames.ora
-----------------------------------------------------------------
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

# QEI geography and reference data/PPS reference data
QEIDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ellison)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = QEIDB)
)
)

# alternate access to PMDB to mimic production PPS database
PPSP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ellison)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PMDB)
)
)

# Primavera database
PMDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ellison)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PMDB)
)
)

# Connection Manager listener
listener_cman=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=ellison)(PORT=1522))))


EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


cman.ora
-----------------------------------------------------------------
# CMAN Alias
cman_ellison =
(configuration=

# Listening address of the cman
(address=(protocol=tcp)(host=ellison)(port=1522))

# Configuration parameters of this CMAN
(parameter_list =

# Need authentication for connection?
# Valid values: boolean values for on/off
(aso_authentication_filter=off)

# Connection statistics need to be collected?
# Valid values: boolean values for on/off
(connection_statistics=yes)

# Log files would be created in the directory specified here
(log_directory=C:\Oracle\product\10.2.0\db_2\NETWORK\log)

# Logging would be in done at this level
# Valid values: OFF | USER | ADMIN | SUPPORT
(log_level=admin)

# Maximum number of connections per gateway
# Valid values: Any positive number (Practically limited by few 1000s)
(max_connections=256)

# Idle timeout value in seconds
# Valid values: Any positive number
(idle_timeout=0)

# Inbound connect timeout in seconds
# Valid values: Any positive number
(inbound_connect_timeout=0)

# Session timout in seconds
# Valid values: Any positive number
(session_timeout=0)

# Outbound connect timeout in seconds
# Valid values: Any positive number
(outbound_connect_timeout=0)

# Maximum number of gateways that can be started
# Valid values: Any positive number (Practically limited by
# system resources)
(max_gateway_processes=16)

# Minimum number of gateways that must be present at any time
# Valid values: Any positive number (Practically limited by
# system resources)
# max_gateway_processes > min_gateway_processes
(min_gateway_processes=2)

# Remote administration allowed?
# Valid Values: Boolean values for on/off
(remote_admin=on)

# Trace files would be created in the directory specified here
(trace_directory=C:\Oracle\product\10.2.0\db_2\NETWORK\log)

# Trace done at this level
# Valid values: OFF | USER | ADMIN | SUPPORT
(trace_level=admin)

# Is timestamp needed with tracing?
# Valid values: Boolean values for on/off
(trace_timestamp=on)

# Length of the trace file in kB
# Valid values: Any positive number (Limited practically)
(trace_filelen=1000)

# No. of trace files to be created when using cyclic tracing
# Valid values: Any positive number
(trace_fileno=1)

# Maximum number of CMCTL sessions that can exist simultaneously
# Valid values: Any positive number
(max_cmctl_sessions=4)

# Event logging: event groups that need to be logged
(event_group=init_and_term,memory_ops)
)

# Rule list

# Rule Specification:
# src = Source of connection; '*' for 'ANY'
# dst = Destination of connection; '*' for 'ANY'
# srv = Service of connection; '*' for 'ANY'
# act = Action: 'accept', 'reject' or 'drop'

# Action List Specification:
# aut = aso_authentication_filter
# moct = outbound_connect_timeout
# mct = session_timeout
# mit = idle_timeout
# conn_stats = connect_statistics
(rule_list=
(rule=
(src=*)(dst=*)(srv=*)(act=accept)
(action_list=(aut=off)(moct=0)(mct=0)(mit=0)(conn_stats=on))
)
)
)


Client End
=================================================================

tnsnames.ora
-----------------------------------------------------------------
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

PPSP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.124)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PMDB)
)
)

PMDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.124)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PMDB)
)
)

QEIDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.124)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = QEIDB)
)
)



Can anyone give me a simple set of instructions as to how to string the various components together so I can get a client PC to talk to the database? I do not want references to the standard Oracle docs, I have been through them many times today and they are too complex for someone with only a passing acquaintance with Net8 concepts!
Re: Connection Manager woes [message #326784 is a reply to message #326781] Thu, 12 June 2008 10:26 Go to previous messageGo to next message
BlackSwan
Messages: 22911
Registered: January 2009
Senior Member
>Connection Manager
Hmmmmm.... I thought Connection Manager was obsoleted about a decade ago.

Are there any firewalls between the "remote" folks & the database?

I suggest hiring somebody for a day who already knows SQL*Net to configure things for you.
Re: Connection Manager woes [message #326791 is a reply to message #326784] Thu, 12 June 2008 10:38 Go to previous messageGo to next message
rjebb
Messages: 2
Registered: June 2008
Junior Member
There will be firewalls, and we can do any necessary port/address translation later.

I only included Connection Manager in this setup as the previous version of this setup used 9i without Connection Manager and i had to go through hoops to pass sessions out through the firewall, due to the way it dynamically assigns you a port number when you connect
Re: Connection Manager woes [message #326794 is a reply to message #326781] Thu, 12 June 2008 10:48 Go to previous message
BlackSwan
Messages: 22911
Registered: January 2009
Senior Member
>I have installed 10.0.2.0 Enterprise Edition
I doubt this.
Most likely it is V10.2.0.1
I am willing to bet that Connection Manager is/was not certified to work with V10
& based upon it's ancient heritage it very well is incompatible with v10.

IIRC, Connection Manager supported V7 & V8.0 which speak an older version of SQL*Net that is not compatible with current version.

Good Luck!
Previous Topic: Sqlnet.ora
Next Topic: Listener
Goto Forum:
  


Current Time: Fri Oct 24 10:08:26 CDT 2014

Total time taken to generate the page: 0.08353 seconds