Oracle Connection Manager

From: Atul Kumar via DBMonster.com <forum_at_DBMonster.com>
Date: Thu, 17 Mar 2005 17:32:24 GMT
Message-ID: <1e7e77c6300240f3bbce1bfecca768a5@DBMonster.com>

Hi,
i'm having problem configuring Oracle Conection Manager. i'm not able to start an instance of Oracle Connection Manager

Summary of my environment is

10g Application server and infrastructure machine OS: Windows 2003 9i Database Server: Windows 2003
Client : Java Applet
JDBC driver type : THIN

Installed: 10g Infra first and then 10g midiier(portal and wireless) in seperate oracle homes on the same machine. Eveything is up and running as i was able to login seperately in infra and midtier enterprise managers.

Final Goal : Trying to connect to an Oracle 9i database on a differnt machine than the appserver using an applet, thin drivers and Oracle Connection Manager

Problem : Connection manager instance not started however cmanADMIn service started.

CMCTL:CMAN_oracle9-app> administer cmanOracleAS Current instance cmanOracleAS is not yet started Connections refer to (address=(protocol=tcp)(host=10.10.1.101)(port=1610)). The command completed successfully.
CMCTL:cmanOracleAS> startup
Service Oracleoracle_infraCMAdmincmanOracleAS already running. TNS-04012: Unable to start Oracle Connection Manager instance. CMCTL:cmanOracleAS>

Steps done to configure Oracle Connection manager 1. Copied 4 .exe (CMADMIN, CMCTL,CMGW,CMMIGR) files to bin folder of Appserver or midtier's main ORACLE_HOME/BIN folder.

2) created a cman.ora file and copied in appservers /NETWORK/ADMIN directory

3) On cammand prompt type CMCTL...ADMINISTER cman_OracleAS where cman_OracleAS is the name of cman instance used in cman.ora file.

My cman.ora file is as follows
######################################################################
#
# Copyright (c) 2001,2002, Oracle Corporation. All rights reserved.
#
# NAME
# cman.ora
#
# DESCRIPTION
# Sample CMAN configuration file that the user can modify for their
# own use.
#
# NOTES
# 1. Change <fqhost> to your fully qualified hostname
# 2. Change <lsnport> to the listening port number
# 3. Change <logdir> and <trcdir> to your log and trace directories
#
# MODIFIED (MM/DD/YYYY)
# asankrut 10/05/2002 - Added Rule List Specifications
# asankrut 06/11/2002 - Modified to add new parameters; added comments.
# asankrut 12/31/2001 - Creation.
#
######################################################################

# CMAN Alias

cmanOracleAS =
(configuration=

# Listening address of the cman

(address=(protocol=tcp)(host=appserver_name)(port=1610))

# 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=D:\GAV\OracleAS10\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=D:\GAV\OracleAS10\NETWORK\trace)

# 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=databaseIP)(srv=*)(act=accept)
(action_list=(aut=off)(moct=0)(mct=0)(mit=0)(conn_stats=on)) 

)
(rule=
(src=appserverIP)(dst=127.0.0.1)(srv=cmon)(act=accept)

) 
)
)

Please help

Thanks
Atul Jain
atul785_at_hotmail.com

-- 
Message posted via http://www.dbmonster.com

Received on Thu Mar 17 2005 - 11:32:24 CST