Monday, July 8, 2013

Recreate grants and synonyms for APPS schema


           AD Administration Main Menu
   --------------------------------------------------

   1.    Generate Applications Files menu

   2.    Maintain Applications Files menu

   3.    Compile/Reload Applications Database Entities menu

   4.    Maintain Applications Database Entities menu

   5.    Change Maintenance Mode

   6.    Exit AD Administration









Enter your choice [6] : 4

         Maintain Applications Database Entities
   ---------------------------------------------------

   1.    Validate APPS schema

   2.    Re-create grants and synonyms for APPS schema

   3.    Maintain multi-lingual tables

   4.    Check DUAL table

   5.    Return to Main Menu











Enter your choice [5] : 2


AD utilities can support a maximum of 999 workers. Your
current database configuration supports a maximum of 47 workers.
Oracle recommends that you use between 2 and 4 workers.


Enter the number of workers [2] :

 Recreating grants and synonyms needed by all installed applications...

sqlplus -s APPS/***** @/u01/oracle/VIS/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/afpub.sql &un_apps &pw_apps &un_pub &pw_pub

sqlplus -s APPS/***** @/u01/oracle/VIS/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/afsys.sql SYSTEM &systempwd &un_apps &un_fnd

sqlplus -s APPS/***** @/u01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adpcpmsc.sql &un_fnd &pw_fnd &systempwd

sqlplus -s APPS/***** @/u01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adinvmsc.sql &un_fnd &pw_fnd &systempwd

sqlplus -s APPS/***** @/u01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adjvaprm.sql &un_apps &systempwd

sqlplus -s APPS/***** @/u01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adgrnctx.sql &systempwd &un_fnd CTXSYS &un_fnd FND

sqlplus -s APPS/***** @/u01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adgrnctx.sql &systempwd &un_fnd CTXSYS &un_icx ICX

sqlplus -s APPS/***** @/u01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adgrnctx.sql &systempwd &un_fnd CTXSYS &un_amv AMV

sqlplus -s APPS/***** @/u01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adgrnctx.sql &systempwd &un_fnd CTXSYS &un_jtf JTF

sqlplus -s APPS/***** @/u01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adgrnctx.sql &systempwd &un_fnd CTXSYS &un_cs CS

sqlplus -s APPS/***** @/u01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adgrnctx.sql &systempwd &un_fnd CTXSYS &un_ar AR

sqlplus -s APPS/***** @/u01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adgrnctx.sql &systempwd &un_fnd CTXSYS &un_apps APPS

sqlplus -s APPS/***** @/u01/oracle/VIS/apps/apps_st/appl/ad/12.0.0/patch/115/sql/aduora.sql &un_apps &pw_apps &systempwd


Creating the AD_UTIL_PARAMS table...
Table AD_UTIL_PARAMS already exists, so dropping the table and recreating it.

Creating FND_INSTALL_PROCESSES table...

Setting parallel context: Maintaining grants and synonyms in APPS schema(s) at R120


Need to create grants and synonyms in APPS account APPS/*****

Making job list for APPS/*****


Selecting from FND_PRODUCT_GROUPS table...

Writing dependencies of jobs to run to appldep.txt file...

There are now 184 jobs remaining (current phase=admin):
    0 running, 184 ready to run and 0 waiting.

Reading completed jobs from restart file (if any).

There are now 184 jobs remaining (current phase=admin):
    0 running, 184 ready to run and 0 waiting.


Determining which java executables are supported by adJavaWorker...

Starting worker processes.

Worker process 1 started.

Worker process 2 started.

Checking if all jobs have their actual and symbolic arguments in sync....

Done.

Writing jobs to run to restart file.

Reading jobs from FND_INSTALL_PROCESSES table ...


Done reading jobs from FND_INSTALL_PROCESSES table ...

Telling workers to read 'todo' restart file.
Done.
************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Mon Jul 08 2013 13:50:47

APPL_TOP is set to /u01/oracle/VIS/apps/apps_st/appl

************* Start of AD Worker session *************
AD Worker version: 12.0.0
AD Worker started at: Mon Jul 08 2013 13:50:47

APPL_TOP is set to /u01/oracle/VIS/apps/apps_st/appl


Starting phase 1000 (admin): Administration


There are now 184 jobs remaining (current phase=admin):
    0 running, 184 ready to run and 0 waiting.

 Assigned: file adappsgs.pls on worker  1 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
Completed: file adappsgs.pls on worker  2 for product ad  username APPLSYS.
 Assigned: file adappsgs.pls on worker  2 for product ad  username APPLSYS.

No comments:

Post a Comment