Perl for Oracle DBAs

From: Dwayne Cox <dwaynec_at_infotechfl.com>
Date: Thu, 26 Jun 2003 16:08:49 -0700
Message-ID: <F001.005BACE2.20030626154918@fatcity.com>

Hi,

I apologize in advance for the length of this post.

I have been wrestling with this for a couple days now and I regreewt having to toss in the towel but I need help.

I am trying to setup dbup.pl from the Perl for Oracle DBAs book (highly recommended, I must say). As long as the databases are running, everything looks good (the log files show everything is ok). I get an error from the script whenever I take a database down as opposed to an email or pager.

Here is the section of the file that seems to be causing my woes (if necessary, I could send the rest):

%addresses = (

        'dbamgr' => { pager => '',
                      emailWork => '[EMAIL PROTECTED]',
                      emailHome => '[EMAIL PROTECTED]' },
        'opsmgr' => { pager => '',
                      emailWork => '[EMAIL PROTECTED]',
                      emailHome => '[EMAIL PROTECTED]' },
        'corpdba' => { pager => '',
                     emailWork => '[EMAIL PROTECTED]',
                     emailHome => '[EMAIL PROTECTED]' },

);
[EMAIL PROTECTED] = ('opsmgr','dbamgr');

%onCallList = ( 'default' => 'corpdba' );

Here is the error:

$ Use of uninitialized value in hash element at /usr/bin/dbup.pl line 597 (#1)
(W uninitialized) An undefined value was used as if it were already defined. It was interpreted as a "" or a 0, but maybe it was a mistake. To suppress this warning assign a defined value to your variables.

To help you figure out what was undefined, perl tells you what operation you used the undefined value in. Note, however, that perl optimizes your program and the operation displayed in the warning may not necessarily appear literally in your program. For example, "that $foo" is usually optimized into "that " . $foo, and the warning will refer to the concatenation (.) operator, even though there is no . in your program.

Use of uninitialized value in concatenation (.) or string at
/usr/bin/dbup.pl

line 311 (#1)

Use of uninitialized value in hash element at /usr/bin/dbup.pl line 317 (#1)
Use of uninitialized value in hash element at /usr/bin/dbup.pl line 319 (#1)
Use of uninitialized value in hash element at /usr/bin/dbup.pl line 320 (#1)

Use of uninitialized value in join or string at /usr/bin/dbup.pl line 525 (#1)
No recipient!Use of uninitialized value in join or string at
/usr/bin/dbup.pl line 339 (#1)

Use of uninitialized value in concatenation (.) or string at
/usr/bin/dbup.pl

line 363 (#1)
No recipient!Use of uninitialized value in concatenation (.) or string at /usr/bin/dbup.pl

line 388 (#1)

--
Dwayne Cox
Corporate Database Administrator
Info Tech, Inc.
5700 SW 34th Street, Suite 1235
Gainesville, FL  32608
email: [EMAIL PROTECTED]
phone: 352.381.4521 fax: 352.381.4444
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Dwayne Cox
 INET: [EMAIL PROTECTED]
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Jun 26 2003 - 18:08:49 CDT

Perl for Oracle DBAs - dbup.pl