Connection manager (setup error)

Connection manager (setup error)

Post by Dominica Leu » Thu, 15 Nov 2001 11:06:03



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

 
 
 

Connection manager (setup error)

Post by Lionel Mandrak » Thu, 15 Nov 2001 11:07:29



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

============================================================================
==================================================================

- Show quoted text -

Quote:> 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
Quote:> 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)
(

- Show quoted text -

> 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


Have you not read the response to your original posting?

 
 
 

Connection manager (setup error)

Post by Jef » Thu, 15 Nov 2001 22:14:42



Quote:>My question is ?
>Is there any daemon, I need to turn ON
>for the CMAN-server side???

Yes.  CMCTL is the control utility that you need to do so.

Quote:>Also, what should be the cman.ora look like in ops002,the client
>side, I am assuming that file should NOT exist at all.

What you had listed as cman.ora on 001 was actually sqlnet.ora.  You should
read the online documentation (go search Oracle's web site for "configuring
connection manager" or "cman.ora") for the proper cman.ora setup.  You are
correct in that cman.ora does not belong on the client side.
 
 
 

Connection manager (setup error)

Post by domin.. » Fri, 16 Nov 2001 09:35:40


I don't know what happen to my thread, I could not see it
from trn.

Hmm Hmm

Dominica




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

>Have you not read the response to your original posting?

 
 
 

Connection manager (setup error)

Post by domin.. » Fri, 16 Nov 2001 09:39:49


Yeah, you are right,
that cman.ora is sqlnet.ora

my cman.ora is:
cman=(address=(protocol=tcp)(host=ops001.corp.abc.com)(port=1630))
cman_rules=
 (rule_list=
   (rule=(src=ops002.corp.abc.com)(dst=ops001.corp.abc.com)(srv=TARGETDB.C
ORP.ABC.COM)(act=accept)))
====
Good at least cman.ora does not need on client.

I think I will give it another try with CMCTL...

===============



>>My question is ?
>>Is there any daemon, I need to turn ON
>>for the CMAN-server side???

>Yes.  CMCTL is the control utility that you need to do so.

>>Also, what should be the cman.ora look like in ops002,the client
>>side, I am assuming that file should NOT exist at all.

>What you had listed as cman.ora on 001 was actually sqlnet.ora.  You should
>read the online documentation (go search Oracle's web site for "configuring
>connection manager" or "cman.ora") for the proper cman.ora setup.  You are
>correct in that cman.ora does not belong on the client side.