Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Perl for Oracle DBAs - dbup.pl
FYI, if any of you are using the dbup.pl script from the PDBA toolkit:
The solution to Dwayne's problem was to change the following line in dbup.conf from this:
%onCallList = ( 'default' => 'corpdba' );
to this:
%onCallList = (
'20030101' => 'corpdba', 'default' => 'corpdba'
Seems the programmer didn't take into account that the 'default' might be the only value in the onCallList hash.
I've already given him (the programmer) a stern reprimand.
Jared
On Thursday 26 June 2003 17:19, [EMAIL PROTECTED] wrote:
> Dwayne,
>
> Offhand, I would say that the problem is due to the pager attribute
> being empty in the %addresses hash.
>
> Try putting a value in it.
>
> Also, what is line 597 in dbup.pl? Yours is likely
> a few lines different than mine.
>
> Please show it in context. ie. with surrounding lines as well.
>
> Jared
>
>
>
>
>
> Dwayne Cox <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 06/26/2003 04:49 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:
> Subject: Perl for Oracle DBAs - dbup.pl
>
>
> 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)
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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 Tue Jul 01 2003 - 00:13:16 CDT