Re: problem with setting up connection manager

HI Lionel,
thank a lot,
you know what happen, I posted thru' DEJANEWS, it took so long to appear on the newsgroup, I thought my posting is not there, and then I post again using another machine's trn.

I am going to try it now.

Dominica
In article <N%jI7.143305$My2.83553391_at_news1.mntp1.il.home.com>, Lionel Mandrake <nobody_at_nospam.nowhere.nohow> wrote:
>
><dominica_at_secondhat.com> wrote in message
>news:9spap5$s85$1_at_secondhat.secondhat.com...
>> Hi Everyone,
>>
>>
>> I am trying to setup a connection manager and connection client.
>>
>> I did read the Oracle net8 admin. guide and try out in 2
>> little sun sparc server, I run into an error.
>>
>> Maybe my concept is wrong.
>>
>> The following is step I did and some file.
>>
>> I have ops001 is the machine has oracle db on it.
>> And I want ops001 to be the CMAN server, I know this does not make
>> sense, I should have one more machine, but I don't.
>>
>> ops002 is the client of Oracle connection manager.
>> =======================================================================
>> listener.ora on ops001 look like this:
>> =======================================================================
>> # LISTENER.ORA Network Configuration File:
>/u1/orahome/product/8.1.7/network/adm
>> in/listener.ora
>> # Generated by Oracle configuration tools.
>>
>> LISTENER =
>> (DESCRIPTION_LIST =
>> (DESCRIPTION =
>> (ADDRESS_LIST =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = ops001.corp.abc.com)(PORT =
>1521))
>> )
>> (ADDRESS_LIST =
>> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
>> )
>> )
>> )
>>
>> SID_LIST_LISTENER =
>> (SID_LIST =
>> (SID_DESC =
>> (SID_NAME = CATA_DB)
>> (ORACLE_HOME = /u1/orahome/product/8.1.7)
>> )
>> (SID_DESC =
>> (SID_NAME = TARGETDB)
>> (ORACLE_HOME = /u1/orahome/product/8.1.7)
>> )
>> )
>>
>>
>>
>> ======= TNSNAMES.ora on ops001 look like this: =========
>> EXTPROC_CONNECTION_DATA =
>> (DESCRIPTION =
>> (ADDRESS_LIST =
>> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
>> )
>> (CONNECT_DATA =
>> (SID = PLSExtProc)
>> (PRESENTATION = RO)
>> )
>> )
>>
>> TARGETDB.CORP.ABC.COM =
>> (DESCRIPTION =
>> (ADDRESS_LIST =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = ops001.corp.abc.com)(PORT =
>1521))
>> )
>> (CONNECT_DATA =
>> (SID = TARGETDB)
>> )
>> )
>>
>> =======================================================================
>> on ops001, I have cman.ora like this:
>> =======================================================================
>> NAMES.DEFAULT_DOMAIN = corp.abc.com
>>
>> USE_CMAN = true
>>
>> NAMES.DIRECTORY_PATH= (TNSNAMES)
>> =======================================================================
>> tnsnames.ora in ops002 is like the followings:
>>
>> =======================================================================
>> TARGET2.CORP.ABC.COM =
>> (DESCRIPTION =
>> (ADDRESS_LIST =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = ops001.corp.abc.com)(PORT =
>1630))
>> (ADDRESS = (PROTOCOL = TCP)(HOST = ops001.corp.abc.com)(PORT =
>1521))
>> (SOURCE_ROUTE = yes)
>> (FAILOVER = false)
>> )
>> (CONNECT_DATA =
>> (SERVICE_NAME = TARGETDB.CORP.ABC.COM)
>> )
>> )
>>
>> =======================================================================
>>
>> error I got is:
>>
>> Fatal NI connect error 12541, connecting to:
>>
>(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ops001.corp.abc.com)(PORT=1630))(C
>>
>ONNECT_DATA=(SERVICE_NAME=TARGETDB.CORP.ABC.COM)(CID=(PROGRAM=)(HOST=ops002)
>(
>> USER=oracle))))
>>
>> VERSION INFORMATION:
>> TNS for Solaris: Version 8.1.7.0.0 - Production
>> TCP/IP NT Protocol Adapter for Solaris: Version 8.1.7.0.0 -
>Production
>> Time: 12-NOV-2001 18:35:25
>> Tracing not turned on.
>> Tns error struct:
>> nr err code: 0
>> ns main err code: 12541
>> TNS-12541: TNS:no listener
>> ns secondary err code: 12560
>> nt main err code: 511
>> TNS-00511: No listener
>> nt secondary err code: 146
>> nt OS err code: 0
>>
>> ===============
>> My question is ?
>> Is there any daemon, I need to turn ON
>> for the CMAN-server side???
>>
>> Also, what should be the cman.ora look like in ops002,the client
>> side, I am assuming that file should NOT exist at all.
>>
>>
>>
>> THanks a lot,
>>
>>
>>
>> Dominica
>> dominica_at_secondhat.com
>
>
>
>> I did read the Oracle net8 admin. guide... [snip]
>> My question is ?
>> Is there any daemon, I need to turn ON
>> for the CMAN-server side???
>
>Yes. You must have missed the section on 'cmctl'...
>
>HTH,
>
>-LM
>
>
Received on Wed Nov 14 2001 - 18:42:59 CST