Intelligent agent and MTS
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Intelligent agent and MTS

  1. #1
    Join Date
    Aug 2000
    Posts
    194
    Hi,

    Recently I changed my DB to have MTS and I did the following changes. Now whenevr I start Intelligent agent, I am getting the warning "No Listener found for SID ORCL. ORCL will be skipped"

    initORCL.ora:
    ------------------
    db_name = "dbacct"
    instance_name = ORCL

    service_names = dbacct.dev05.intacct.com

    ....
    ....
    #mts_dispatchers = "(PROTOCOL=TCP)(DISPATCHERS=3)"
    MTS_DISPATCHERS=
    "(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(DISPATCHERS=2)"
    MTS_DISPATCHERS=
    "(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1522))(DISPATCHERS=1)"
    mts_servers = 1


    Listener.ora
    -------------
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME=dbacct.dev05.intacct.com)
    (ORACLE_HOME = /oracle/product/8.1.6)
    (SID_NAME = ORCL)
    )
    (SID_DESC =
    (ORACLE_HOME = /oracle/product/8.1.6)
    (SID_NAME = STBY)
    )
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /oracle/product/8.1.6)
    (PROGRAM = extproc)
    )
    )

    Lsnrctl Status output:
    ----------------------
    lsnrctl status

    LSNRCTL for Linux: Version 8.1.6.0.0 - Production on 25-JAN-2001 18:15:21

    (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 8.1.6.0.0 - Production
    Start Date 25-JAN-2001 17:39:18
    Uptime 0 days 0 hr. 36 min. 2 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File /oracle/product/8.1.6/network/admin/listener.ora
    Listener Log File /oracle/product/8.1.6/network/log/listener.log
    Services Summary...
    PLSExtProc has 1 service handler(s)
    STBY has 1 service handler(s)
    ORCL has 1 service handler(s)
    The command completed successfully


    Tnsnames.ora:
    ------------
    DEV05 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = dbacct.dev05.intacct.com)
    )
    )

    What am I doing wrong here?. why the "lsnrctl status" doesn't show the dispatchers?. How do I get the Intelligent agent start working with the MTS configuration?

    If I connect using "DEV05", I see the connection established as "SHARED"

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Could you check the parameters for MAX_DISPATCHERS. Seems service name is missing thats registered with Listener.
    Give parameter service=ORCL and try.

    [url]http://www-wnt.gsi.de/oragsidoc/doc_816/server.816/a76961/ch198.htm#64057[/url]

  3. #3
    Join Date
    Aug 2000
    Posts
    194
    But, I specify "SERVICE_NAMES" parameter in the init.ora. Oracle doc says "If no value is specified for SERVICE, the service names specified with the SERVICE_NAMES parameter are used".

    Anyway, I vl do some more research. Mean time, if any of u can get me some document on how u configure intelligent agent with MTS running, I would greatly appreciate it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width