Re: Connection manager (setup error)

From: Lionel Mandrake <nobody_at_nospam.nowhere.nohow>
Date: Wed, 14 Nov 2001 02:07:29 GMT
Message-ID: <BlkI7.143397$My2.83585137@news1.mntp1.il.home.com>

"Dominica Leung" <dominica_l_at_yahoo.com> wrote in message news:5f8af180.0111131806.267f72fe_at_posting.google.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

Have you not read the response to your original posting? Received on Tue Nov 13 2001 - 20:07:29 CST