| 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 -> Configuring Oracle Connection Manager
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)))
) ) )
Forgot to mention that
cmanOracleAS.log file i.e connection manger log file is as follows. It says does not currently know of service 'cmon' but i have the rule which allows cmctl to conect locally with 127.0.0.1 .
TNSLSNR for 32-bit Windows: Version 10.1.0.3.0 - Production on 17-MAR-2005 12:17:53
Copyright (c) 1991, 2004, Oracle. All rights reserved.
System parameter file is D:\GAV\oracle_infra\network\admin\sqlnet.ora
Command-line specified parameter file is D:\GAV\oracle_infra\network\admin\
cman.ora
Log messages written to D:\GAV\OracleAS10\NETWORK\log\cmanoracleas1_924.log
Trace information written to D:\GAV\OracleAS10\NETWORK\trace\
cmanoracleas1_924.trc
Trace level is currently 6
Started with pid=332
Running in PROXY mode
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.1.101)
(PORT=1610)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
17-MAR-2005 12:22:07 * (connect_data=(service_name=cmon)(pid=ctl)) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.1.101)(PORT=4589)) * establish * cmon *
12514
TNS-12514: TNS:listener does not currently know of service requested in
connect descriptor
17-MAR-2005 12:22:10 * (connect_data=(service_name=cmon)(pid=ctl)) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.1.101)(PORT=4596)) * establish * cmon *
12514
TNS-12514: TNS:listener does not currently know of service requested in
connect descriptor
17-MAR-2005 12:23:31 * (connect_data=(service_name=cmon)(pid=ctl)) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.1.101)(PORT=4782)) * establish * cmon *
12514
Thanks
Atul jain
-- Message posted via http://www.dbmonster.comReceived on Thu Mar 17 2005 - 15:11:01 CST
 |
 |