Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002
    Posts
    162

    Unanswered: can't see database on node discovered

    Hi,

    I have scoured thru past solutions on this issue but I still cant solve my problem. I have also looked at past notes:97067.1 and Note:166935.1.


    I have a Microsoft XP box. I can discover the node automatically no problem

    my host name is 'olawale' (DHCP IP, although the ip assigned is always the same).

    my local db is called "demo"

    and these are my tns entries (OMS has its own db/repository)
    (not sure where first entry came from. I figure its an OEM entry):

    ************************************************** *******************
    INST1_HTTP.BAH.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = olawale)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = MODOSE)
    (PRESENTATION = http://HRService)
    )
    )

    DEMO.BAH.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = olawale)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = Demo)
    )
    )

    OEMREP.BAH.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = olawale)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = OEMREP)
    )
    )
    ************************************************** *******************

    My sqlnet.ora looks like this:

    ************************************************** *******************
    # This file is actually generated by netca. But if customers choose to
    # install "Software Only", this file wont exist and without the native
    # authentication, they will not be able to connect to the database on NT.

    SQLNET.AUTHENTICATION_SERVICES = (NTS)

    NAMES.DEFAULT_DOMAIN = bah.com

    SQLNET.EXPIRE_TIME = 0
    ************************************************** *******************

    My listener entries look like this:

    ************************************************** *******************
    # LISTENER.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\listener.ora
    # Generated by Oracle configuration tools.

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

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = Demo.bah.com)
    (ORACLE_HOME = C:\Oracle\Ora92)
    (SID_NAME = Demo)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = OEMREP.bah.com)
    (ORACLE_HOME = C:\oracle\ora92)
    (SID_NAME = OEMREP)
    )
    )************************************************* ********************
    one thing i must point out is this. I made an alteration to my
    ora92\sqlplus\admin\glogin.sql file as follows :

    ************************************************** *******************
    column global new_value dbname
    select global_name global from global_name;
    set sqlprompt '&dbname> '
    ************************************************** *******************

    so that I could see the global_name attached to my sql prompt (helps me comfirm what database I am connected to) and for my "demo" database" it comes up as : "DEMO.US.ORACLE.COM"

    so I figure that I am missing something somewhere.

    I have other entries in my tns with the bah.com Names.default_domain
    and they all come up with name.bah.com in my prompt except for the "demo" db as mentioned right above(which is on the local machine i might add).

    Everything on my machine is all 9ir2. I can ping my agents with no prob. I have checked the so called nmiconf.log file and i got this

    ************************************************** *******************

    DBSNMP for 32-bit Windows: release 9.2.0.0.0 - Production on 22-JAN-03 15:17:21
    Discovering services on olawale configured on host addresses {olawale 156.80.88.132}
    Error : Agent NT service name is not set
    Agent NT service name is not set

    DBSNMP for 32-bit Windows: release 9.2.0.0.0 - Production on 22-JAN-03 15:33:36
    Discovering services on olawale configured on host addresses {olawale 156.80.88.132}
    Warning : Skipping OracleOraHome92TNSListener : Could not find corresponding listener definition in {C:\oracle\ora92\network\admin\listener.ora}
    Warning : No Listener found for SID DEMO. DEMO will be skipped
    Warning : No Listener found for SID OEMREP. OEMREP will be skipped
    Warning : Error while sourcing third party discovery file emddiscover.tcl : unable to get value "em_loc" from key "HKEY_LOCAL_MACHINE\Software\Oracle": The system cannot find the file specified.
    ************************************************** *******************

    Why is it skipping. I dont think the "third party discovery file " is that important

    please help....................

    'Wale

  2. #2
    Join Date
    Mar 2002
    Posts
    162
    I fixed it. I deleted my old listener and then rebuilt it using, database configuration asst and rebooted.

Posting Permissions

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