SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Install DB trends

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Install DB trends
Author Message
Gary Mazzone



Joined: 05 Dec 2000
Posts: 3

Post Install DB trends Reply with quote

I had a lot of problems install intalling DBTrends package. I got must done with the exection of the data collection job scheduleing. I installed DBMS_Jobs package but get this error when tring to run the last procedure in the install package:

DECLARE job BINARY_INTEGER;
*
ERROR at line 1:
ORA-23319: parameter value "06-DEC-00" is not appropriate
ORA-06512: at "SYS.DBMS_JOB", line 50
ORA-06512: at "SYS.DBMS_JOB", line 120
ORA-06512: at line 5

here is the procedure:

DECLARE job BINARY_INTEGER;

BEGIN

IF '&schedule' = 'YES' THEN

dbms_job.submit( job, 'ora_monitor.db_trends.collect;', &start_time, &next_time, FALSE );

END IF;
END;

Gary Mazzone
gmazzone@plansys.com

Tue Dec 05, 2000 8:15 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Re: Install DB trends Reply with quote

The value of &start_time, &next_time should match your NLS settings so Oracle can understand and properly convert dates from strings.

By default
The line "dbms_job.submit( job, 'ora_monitor.db_trends.collect;', &start_time,
&next_time, FALSE );"
is executeuded as "dbms_job.submit( job, 'ora_monitor.db_trends.collect;', trunc(SYSDATE) + 26/24, 'SYSDATE + 1', FALSE );"

If you have customized &start_time, &next_time variables, make sure they are assigned correct values

Just for your reference here are the default settings in case if you changed them. Note that &next_time is a string, not a date.

DEFINE start_time trunc(SYSDATE) + 26/24; -- initial start time for the DBMS_JOB dbTrends
DEFINE next_time 'SYSDATE + 1'; -- time Because You need to change value of

: I had a lot of problems install intalling DBTrends package. I got must done
: with the exection of the data collection job scheduleing. I installed
: DBMS_Jobs package but get this error when tring to run the last procedure
: in the install package: DECLARE job BINARY_INTEGER;
: *
: ERROR at line 1: ORA-23319: parameter value "06-DEC-00" is not
: appropriate
: ORA-06512: at "SYS.DBMS_JOB", line 50
: ORA-06512: at "SYS.DBMS_JOB", line 120
: ORA-06512: at line 5

: here is the procedure: DECLARE job BINARY_INTEGER;

: BEGIN

: IF '&schedule' = 'YES' THEN

: dbms_job.submit( job, 'ora_monitor.db_trends.collect;', &start_time,
: &next_time, FALSE );

: END IF;
: END;

: Gary Mazzone
: gmazzone@plansys.com

Tue Dec 05, 2000 9:21 am View user's profile Send private message
Gary Mazzone



Joined: 05 Dec 2000
Posts: 3

Post Re: Install DB trends Reply with quote

I did not change the &start_time,&next_time variables from the set that came in the package. The NLS setting is the US default.

: The value of &start_time, &next_time should match your NLS settings so Oracle
: can understand and properly convert dates from strings.

: By default
: The line "dbms_job.submit( job, 'ora_monitor.db_trends.collect;',
: &start_time,
: &next_time, FALSE );"
: is executeuded as "dbms_job.submit( job,
: 'ora_monitor.db_trends.collect;', trunc(SYSDATE) + 26/24, 'SYSDATE + 1',
: FALSE );"

: If you have customized &start_time, &next_time variables, make sure they are
: assigned correct values

: Just for your reference here are the default settings in case if you changed
: them. Note that &next_time is a string, not a date.

: DEFINE start_time trunc(SYSDATE) + 26/24; -- initial start time for the
: DBMS_JOB dbTrends
: DEFINE next_time 'SYSDATE + 1'; -- time Because You need to change value of

Tue Dec 05, 2000 9:59 am View user's profile Send private message
Gary Mazzone



Joined: 05 Dec 2000
Posts: 3

Post Re: Install DB trends Reply with quote

Never mind I reworte the block with out using variable (is just code the section same as teh variable) and it worked.

Gary
: I did not change the &start_time,&next_time variables from the set that came
: in the package. The NLS setting is the US default.

Tue Dec 05, 2000 10:59 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.