Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    11

    Unanswered: Issue with services and instances

    Problem again with listeners, I just don't get it. I re-installed Oracle 9i R2 on Red Hat 9.0, and all that jazz. I had to fiddle around with my tnsnames.ora and listener.ora and I got everything to work just fine. My client on Win XP could even access the db no prob.

    Then I noticed something really strange: when doing lsnrctl status, another service and extra instances pop up (!). Here it is:

    -------------------------------------------------------------------------

    LSNRCTL for Linux: Version 9.2.0.1.0 - Production on 25-JUN-2004 23:53:20

    Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux1)( PORT=1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 9.2.0.1.0 - Production
    Start Date 25-JUN-2004 23:29:15
    Uptime 0 days 0 hr. 24 min. 4 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File /opt/oracle/product/9.2.0/network/admin/listener.ora
    Listener Log File /opt/oracle/product/9.2.0/network/log/listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux1.r eaktor.net)(PORT=1521)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "PRODXDB" has 1 instance(s).
    Instance "psy", status READY, has 1 handler(s) for this service... Service "psy" has 2 instance(s).
    Instance "psy", status UNKNOWN, has 1 handler(s) for this service...
    Instance "psy", status READY, has 1 handler(s) for this service...

    The command completed successfully
    [oracle@linux1 admin]$

    -------------------------------------------------------------------------

    First of all, I never put a service named "PRODXDB". Did a search on the net, nothing either. Anyway, then the service psy has 2 instances of the psy db. Doesn't make any sense at all.

    So here are the contents of my files:


    # LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = linux1)(PORT = 1521))
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = psy)
    (ORACLE_HOME = /opt/oracle/product/9.2.0)
    (SID_NAME = psy)
    )
    (SID_DESC =
    (PROGRAM = extproc)
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /opt/oracle/product/9.2.0)
    )
    )


    -------------------------------------------------------------------------


    # TNSNAMES.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.

    PSY =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = linux1)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = psy)
    )
    )


    -------------------------------------------------------------------------

    # SQLNET.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/sqlnet.ora
    # Generated by Oracle configuration tools.

    NAMES.DEFAULT_DOMAIN = reaktor.net

    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)


    -------------------------------------------------------------------------


    I even use Net assistant and it still fails to work like I want. Can someone tell me if there are any other files I should be looking in? The logs do not really show error messages per se, so I'm a bit at a loss here.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    what are the contents of the "oratab" file?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2004
    Posts
    11
    *:/opt/oracle/product/9.2.0:N

    What does this tell you anyway, just out of curiosity? I'm not familiar with this file.

Posting Permissions

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