Intelligent Agent skipping my SIDS!

[ErrolDC2]

DBSNMP for SunOS 5.10: release 9.2.0.6.0 - Production on 16-FEB-06 15:13:06
Discovering services on twdb01.tripwire-dhs.net configured on host addresses {twdb01 twdb01 172.16.100.14 twdb01.tripwire-dhs.private 129.15.1.2 twdb01}
Using oratab file /var/opt/oracle/oratab
Warning : LISTENER defined in /u01/app/oracle/product/9.2.0.1.0/network/admin/listener.ora will be skipped, because it does not monitor any of the valid SIDs {iedportl weblogic}
Warning : No Listener found for SID iedportl. iedportl will be skipped
Warning : No Listener found for SID weblogic. weblogic will be skipped
Could not open emtab at /var/opt/oracle/emtab.

That is what I get out of nmiconf.log.

Here is my listener.ora, oratab and tnsnames.ora and hosts file..

$ cat /etc/hosts
#
# Internet host table
#
127.0.0.1       localhost loghost
172.16.100.14   twdb01 twdb01.tripwire-dhs.net
172.16.103.200  twap01.tripwire-dhs.net twap01
129.15.1.2      twdb01.tripwire-dhs.private
129.15.1.1      twap01.tripwire-dhs.private
$ pwd
/u01/app/oracle/product/9.2.0.1.0/network
$ cd admin
$ cat tnsnames.ora
# TNSNAMES.ORA Network Configuration File: /u01/app/oracle/product/9.2.0.1.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

IEDPORTL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = iedportl)
    )
  )

WEBLOGIC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = weblogic)
    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = [URL unfurl="true"]http://HRService)[/URL]
    )
  )

$ cat listener.ora
# LISTENER.ORA Network Configuration File: /u01/app/oracle/product/9.2.0.1.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.100.14)(PORT = 1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 129.15.1.2)(PORT = 1521))
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)))

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/9.2.0.1.0)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = iedportl.twdbp01)
      (ORACLE_HOME = /u01/app/oracle/product/9.2.0.1.0)
      (SID_NAME = iedportl)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = weblogic.twbp01)
      (ORACLE_HOME = /u01/app/oracle/product/9.2.0.1.0)
      (SID_NAME = weblogic)
    )
  )

$ cat /var/opt/oracle/oratab
#

# This file is used by ORACLE utilities.  It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.

# A colon, ':', is used as the field terminator.  A new line terminates
# the entry.  Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
#   $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively.  The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
*:/u01/app/oracle/product/9.2.0.1.0:N
iedportl:/u01/app/oracle/product/9.2.0.1.0:Y
weblogic:/u01/app/oracle/product/9.2.0.1.0:Y

Stuff hit the fan after I changed the hostname of my server. But my applications and users are not complaining of any issues. PS - I've already cleaned up the agent directory.

So how do I fix this, I've searched meta-link but nothing suggested is working.

 

[LKBrwnDBA]

Try adding the following last two lines to your description list in your listener.ora file:

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

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.100.14)(PORT = 1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = 129.15.1.2)(PORT = 1521))
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)))
        (ADDRESS = (PROTOCOL = IPC)(KEY = iedportl))
        (ADDRESS = (PROTOCOL = IPC)(KEY = weblogic))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
...etc...

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[ErrolDC2]

Thanks for the reply. I added those two lines but the results are the same. Any other ideas you can think of?

 

[taupirho]

Can you supply the contents of your services.ora file

 

[ErrolDC2]

Once again, thanks for the reply and assistance. It is much appreciated.

cat services.ora
twdb01 = (ORACLE_NODE, twdb01, twdb01, (PLATFORM=(osName=SunOS)(osVersion=5.10)(oracleHomes=/u01/app/oracle/product/9.2.0.1.0)))


twdb01:443 = (oracle_sysman_webserver, twdb01,

http://twdb01:443/server-status,

unavailable, /u01/app/oracle/product/9.2.0.1.0/Apache/Apache/conf/httpd.conf, /u01/app/oracle/product/9.2.0.1.0/Apache/Apache)