Re: problem with dbsnmp agent on Solaris

"Ed Stevens" <nospam_at_noway.nohow> wrote in message news:gpic5v06q1mku0ldtsa2rvmk5v49svvqsj_at_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
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> 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
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> 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
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
>
> 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.

Your problem has nothing to do with Windows vs. Unix, but with 8.0 vs 8i

The Agent still uses sqlnet2/net 8.0 technology and doesn't work with the service_name concept. Hence, when using the OIA, you *must* have a valid sid_list_listener section (as documented in the net8 doco). Both SIDs are missing from your listener.ora.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address