| Connection Manager woes [message #326781] |
Thu, 12 June 2008 10:21  |
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 #326791 is a reply to message #326784] |
Thu, 12 June 2008 10:38  |
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 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
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!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
