ORA-06512: at "SYS.DBMS_ADVISOR", line 201 PL/SQL: numeric o

All posts relating to Oracle database administration.

Moderator: Tim...

ORA-06512: at "SYS.DBMS_ADVISOR", line 201 PL/SQL: numeric o

Postby ssadoglu » Fri Feb 22, 2013 10:00 am

Hi there,

We have been using Oracle Database - Enterprise Edition 11.2.0.3 running on the IBM AIX on POWER Systems (64-bit). My question / problem is : When trying to run below commmand then I'm getting the following error.

My command :
SQL> exec dbms_space.auto_space_advisor_job_proc;
BEGIN dbms_space.auto_space_advisor_job_proc; END;

Here is my error message :

*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_ADVISOR", line 201
ORA-06512: at "SYS.DBMS_SPACE", line 2276
ORA-06512: at "SYS.DBMS_SPACE", line 2538
ORA-06512: at line 1

Thanks and best regards,
ssadoglu
Senior Member
 
Posts: 58
Joined: Wed Feb 02, 2011 10:59 am

Re: ORA-06512: at "SYS.DBMS_ADVISOR", line 201 PL/SQL: numer

Postby Tim... » Mon Feb 25, 2013 1:53 pm

Hi.

Are you running this as SYS?

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17953
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: ORA-06512: at "SYS.DBMS_ADVISOR", line 201 PL/SQL: numer

Postby ssadoglu » Mon Feb 25, 2013 3:38 pm

Tim... wrote:Hi.

Are you running this as SYS?

Cheers

Tim...


Yes,
ssadoglu
Senior Member
 
Posts: 58
Joined: Wed Feb 02, 2011 10:59 am

Re: ORA-06512: at "SYS.DBMS_ADVISOR", line 201 PL/SQL: numer

Postby Tim... » Mon Feb 25, 2013 6:25 pm

Hi.

Then I am at a loss. I think you need to progress this with Oracle support. That is a standard package, so there should be nothing in it that fails... If I run it on my installations it works fine...

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17953
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 2 guests