This forum is currently locked. You can't register or post questions at this time. (read more)

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

All posts relating to Oracle database administration.

Moderator: Tim...

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

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,

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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

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

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,

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 4 guests

cron