2 Replies Latest reply on Mar 27, 2015 11:55 PM by GatotRu

    error adadmin after upgrade database 11gR2 to 12c

    GatotRu

      I've just upgrading Oracle Database on Oracle E-Business Suite. But when i want to run adadmin i can't run it well.

       

      [oravis@ebs scripts]$ adadmin

       

                           Copyright (c) 2002, 2012 Oracle Corporation

                              Redwood Shores, California, USA

       

                         Oracle E-Business Suite AD Administration

       

                                       Version 12.2.0

       

      NOTE: You may not use this utility for custom development

            unless you have written permission from Oracle Corporation.

       

      Your default directory is '/source/VIS/fs1/EBSapps/appl'.

      Is this the correct APPL_TOP [Yes] ?

       

      AD Administration records your AD Administration session in a text file

      you specify.  Enter your AD Administration log file name or press [Return]

      to accept the default file name shown in brackets.

       

      Filename [adadmin.log] :

       

      ************* Start of AD Administration session *************

      AD Administration version: 12.2.0

      AD Administration started at: Sat Mar 28 2015 00:01:25

       

      APPL_TOP is set to /source/VIS/fs1/EBSapps/appl

       

       

      Backing up restart files, if any......Done.

       

       

      Your previous AD Administration session did not run to completion.

      Do you wish to continue with your previous AD Administration session [Yes] ? no

       

      You chose to disregard your previous AD Administration session

      and to restart AD Administration from the beginning.

       

      Enter Yes to confirm that you wish to overwrite your previous

      AD Administration session and begin a new AD Administration session.

       

      Enter No to continue with your previous AD Administration session. [No] :

       

       

       

      You are about to use or modify Oracle E-Business Suite product tables

      in your ORACLE database 'VIS'

      using ORACLE executables in '/source/VIS/fs1/EBSapps/10.1.2'.

       

      Is this the correct database [Yes] ? /source/VIS/12.1.0

       

      Already asked for the ORACLE username and password

      of Application Object Library.

      (The given username/password was: APPLSYS/*****)

       

      Error: Unable to execute statement <

      Begin

      ad_jar.get_jripasswords(:l_storepass, :l_keypass);

      End;

      > len = 63

       

      AD Administration error:

      ORA-01031: insufficient privileges

      ORA-06512: at "SYS.DBMS_SESSION", line 122

      ORA-06512: at "APPS.AD_JAR", line 17

      ORA-06512: at line 3

       

       

      AD Administration error:

       

      Unable to get passwords from Vault

       

       

      You should check the file

      /source/VIS/fs_ne/EBSapps/log/adadmin/log/adadmin.log

       

      for errors.

       

      After opening the log :

      ************* Start of AD Administration session *************

      AD Administration version: 12.2.0

      AD Administration started at: Fri Mar 27 2015 22:57:16

       

      APPL_TOP is set to /source/VIS/fs1/EBSapps/appl

       

      NLS_LANG value from the environment is    : American_America.AL32UTF8

      NLS_LANG value for this AD utility run is : AMERICAN_AMERICA.AL32UTF8

       

      You can be notified by email if a failure occurs.

      Do you wish to activate this feature [No] ? No

       

      Please enter the batchsize [1000] : 1000

       

       

      Please enter the name of the Oracle E-Business Suite System that this

      APPL_TOP belongs to.

       

      The Applications System name must be unique across all Oracle

      Applications Systems at your site, must be from 1 to 30 characters

      long, may only contain alphanumeric and underscore characters,

      and must start with a letter.

       

      Sample Applications System names are: "prod", "test", "demo" and

      "Development_2".

       

      Applications System Name [VIS] : VIS *

       

       

      NOTE: If you do not currently have certain types of files installed

      in this APPL_TOP, you may not be able to perform certain tasks.

       

      Example 1: If you don't have files used for installing or upgrading

      the database installed in this area, you cannot install or upgrade

      the database from this APPL_TOP.

       

      Example 2: If you don't have forms files installed in this area, you cannot

      generate them or run them from this APPL_TOP.

       

      Example 3: If you don't have concurrent program files installed in this area,

      you cannot relink concurrent programs or generate reports from this APPL_TOP.

       

       

      Do you currently have files used for installing or upgrading the database

      installed in this APPL_TOP [YES] ? YES *

       

       

      Do you currently have Java and HTML files for HTML-based functionality

      installed in this APPL_TOP [YES] ? YES *

       

       

      Do you currently have Oracle E-Business Suite forms files installed

      in this APPL_TOP [YES] ? YES *

       

       

      Do you currently have concurrent program files installed

      in this APPL_TOP [YES] ? YES *

       

       

      Please enter the name Oracle E-Business Suite will use to identify this APPL_TOP.

       

      The APPL_TOP name you select must be unique within an Oracle E-Business Suite

      System, must be from 1 to 30 characters long, may only contain

      alphanumeric and underscore characters, and must start with a letter.

       

      Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".

       

      APPL_TOP Name [ebs] : ebs *

       

       

       

      You are about to use or modify Oracle E-Business Suite product tables

      in your ORACLE database 'VIS'

      using ORACLE executables in '/source/VIS/fs1/EBSapps/10.1.2'.

       

      Is this the correct database [Yes] ? Yes

       

      AD Administration needs the password for your 'SYSTEM' ORACLE schema

      in order to determine your installation configuration.

       

      Enter the password for your 'SYSTEM' ORACLE schema: *****

       

       

      Connecting to SYSTEM......Connected successfully.

       

      The ORACLE username specified below for Application Object Library

      uniquely identifies your existing product group: APPLSYS

       

      Enter the ORACLE password of Application Object Library [APPS] : *****

       

      AD Administration is verifying your username/password.

      Connecting to APPS......Connected successfully.

       

      Error: Unable to execute statement <

      Begin

      ad_jar.get_jripasswords(:l_storepass, :l_keypass);

      End;

      > len = 63

       

      AD Administration error:

      ORA-01031: insufficient privileges

      ORA-06512: at "SYS.DBMS_SESSION", line 122

      ORA-06512: at "APPS.AD_JAR", line 17

      ORA-06512: at line 3

       

      AD Administration error:

       

      Unable to get passwords from Vault

       

       

      You should check the file

      /source/VIS/fs_ne/EBSapps/log/adadmin/log/adadmin.log

       

      for errors.

       

       

       

      AD Administration error:

       

      Unable to get passwords from Vault

       

       

      You should check the file

      /source/VIS/fs_ne/EBSapps/log/adadmin/log/adadmin.log

       

      for errors.