Levicorp's WebNote Moving into http://levicorp.com

Just another web note

  • Hear This

    Radio Rodja 756 AM
  • June 2009
    M T W T F S S
    « May   Jul »
    1234567
    891011121314
    15161718192021
    22232425262728
    2930  
  • Advertisements

MIGRATION Oracle EBS 11.5.9 with Database 10g Part II

Posted by Admin on June 10, 2009

Sorry, I am moving into http://levicorp.com/2009/06/10/migration-oracle-ebs-11-5-9-with-database-10g-part-ii/

Advertisements

3 Responses to “MIGRATION Oracle EBS 11.5.9 with Database 10g Part II”

  1. Haresh said

    Sir,

    In Gather statistics for SYS schema when I run adstats.sql script It’s give’s error as below

    SQL> @adstats.sql
    Connected.
    ———————————————————-adstats.sql started at 2009-07-21 00:20:43 —
    Checking for the DB version
    declare
    *
    ERROR at line 1:
    ORA-27476: “SYS.GATHER_STATS_JOB” does not exist
    ORA-06512: at “SYS.DBMS_ISCHED”, line 3429
    ORA-06512: at “SYS.DBMS_SCHEDULER”, line 2395
    ORA-06512: at line 2
    ORA-06512: at line 23
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    Please guide me how to resolve it.

    Regards,
    Haresh

    • levicorp said

      Hi Haresh,
      Unfortunately I never found this error, But I found the solution in Metalink Note 787798.1 :

      Cause
      RUN_JOB requires that either you be the owner of the job or have ALTER privileges on that job. As we didn’t granted ALTER on ‘GATHER_STATS_JOB’ job ,It is failing.

      Solution

      Grant the following to the external user.
      SQL> GRANT ALTER ON GATHER_STATS_JOB TO OPT$ORACLE;

      Then run the following
      SQL> exec sys.dbms_scheduler.RUN_JOB(‘SYS.GATHER_STATS_JOB’);

      This will be successfully executed.
      NOTE: Don’t forget to prefix the GATHER_STATS_JOB with SYS,As SYS is the owner of GATHER_STATS_JOB.

  2. […] that I got during the migration Oracle DB and Apps EBSĀ  as we post in trilogy of migration part I, II and III. And how to solve the problem, hope this can help […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: