Re: problem with dbsnmp agent on Solaris

From: Ed Stevens <nospam_at_noway.nohow>
Date: Fri, 21 Feb 2003 10:06:09 -0600
Message-ID: <gpic5v06q1mku0ldtsa2rvmk5v49svvqsj@4ax.com>

On Thu, 20 Feb 2003 23:37:07 +0100, Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote:

>On Wed, 19 Feb 2003 10:46:05 -0600, Ed Stevens <nospam_at_noway.nohow>
>wrote:
>
>>
>>As a point of clarification in the above log, ORACLE_SID is
>>*incorrctly* set to MOVEX. There is no MOVEX sid. On the other hand,
>>CMPM1240 *is* a vaild sid and *is* listed in oratab
>
>
>doesn't matter. Both the SIDs you mention are not configured using the
>default listener in listener.ora, and that is the reason why you are
>getting this error.
>
>
>Sybrand Bakker, Senior Oracle DBA
>
>To reply remove -verwijderdit from my e-mail address

listener.ora looks like this:

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

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))     )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521))     )
    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 2481))
      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )

    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = CMPM1240))     )
  )

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
      (PROGRAM = extproc)

)
)
#==== end of listener.ora =====

After logging on as the user 'oracle', (which was the user that installed the Oracle software and under which all the oracle processes run) I generated the following. This 'log' picks up right after the 'welcome' msgs from a successful logon.

session log =========

OS installation date: Monday January 6 04:55:53 MST 2003

The SIDs on this machine are:
CMPM1240
$ lsnrctl status

LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 21-FEB-2003 08:19:49

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 8.1.7.0.0 -
Production
Start Date                22-JAN-2003 14:48:10
Uptime                    29 days 17 hr. 31 min. 38 sec
Trace Level               off
Security                  OFF
SNMP                      OFF

Listener Parameter File
/u01/app/oracle/product/8.1.7/network/admin/listener.o ra
Listener Log File
/u01/app/oracle/product/8.1.7/network/log/listener.log Services Summary...

  CMPM1240              has 1 service handler(s)
  PLSExtProc            has 1 service handler(s)

The command completed successfully
$ lsnrctl dbsnmp_status

LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 21-FEB-2003 08:20:32

The db subagent is already running.
$ echo $ORACLE_SID
MOVEX
$ set ORACLE_SID=CMPM1240
$ echo $ORACLE_SID
MOVEX
$ export ORACLE_SID=CMPM1240
$ echo $ORACLE_SID
CMPM1240
$ sqlplus system/********

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Feb 21 08:23:27 2003

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SQL> select name from v$database;

NAME

CMPM1240 SQL>

end session log =====

I notice that the SID is not listed in the listener.ora file, but is listed on a lsnrctl status. So I presume it is auto-registering with the listener. When you say "the SIDs . . . are not configured using the default listener in listener.ora" are you saying that they need to be specifically listed in listener.ora, even though they are self-registering? If that isn't what you mean, then I'm lost.

I also noticed that when I did a 'set ORACLE_SID' to correct the value of that variable, it didn't change it. I had to do an 'export', even to change it within my own session. I'm still feeling my way around in unix, but that goes against what I thought I understood.

Related to the immediate problem or not, could the fact that the default value of ORACLE_SID is 'incorrect' be causing any problems? I wouldn't think so, since there can be only one ORACLE_SID, even when you may have multiple sids running.

Thanks for your patience. Moving from Windows to unix almost makes me feel like I'm starting all over again. I'm sure it will be a good experience, once I get my feet back on solid ground. Received on Fri Feb 21 2003 - 10:06:09 CST