Re: Oracle Connection Manager

Comments embedded

On Thu, 17 Mar 2005 17:32:24 GMT, "Atul Kumar via DBMonster.com" <forum_at_DBMonster.com> wrote:

>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
>

Is not going to work, connection manager *has* to run on the database server. Did you read the manual?

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

No proof of this assertion

>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.
So you aleready have a connection manager running *on the same port*!!! This is not possible! Did you read the manual?

>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.

Why on earth? Why do you *hack* your Oracle installation?

>
>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.

--
Sybrand Bakker, Senior Oracle DBA