Connection manager (setup error)

From: Dominica Leung <dominica_l_at_yahoo.com>
Date: 13 Nov 2001 18:06:03 -0800
Message-ID: <5f8af180.0111131806.267f72fe@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 Received on Tue Nov 13 2001 - 20:06:03 CST