5 Replies Latest reply: Sep 26, 2012 9:36 AM by Helios-GunesEROL RSS

    Cloning Issue with Oracle EBS 11.5.10.2 on Win (adcrobj.cmd & adcrobj.sql)

    user1983888
      Hi All,

      We upgraded our Oracle EBS 11.5.10/9iR2 on Windows 2003 (2 Node - Apps Tier and DB Tier) to 11.5.10.2/11gR2 last year. Since then Cloning to Test/Dev env has become an issue and every time we face some issue and we will do some work around. We created SR and it didn't help.

      Yesterday I did a fresh clone (database restored using RMAN). After restoring the database I created the DB Tier context file. DB Tier AutoConfig is failing with while running adcrobj.cmd & adcrobj.sql

      I noticed the issue in adcrobj.cmd is with the line:
      sqlplus /nolog  @d:\prod\proddb\11.2.0/appsutil/install/PROD_ebsdbsv/adcrobj.sql %user%

      and the issue with adcrobj.sql is with the line:

      connect &1

      When I run adcrobj.cmd manually it fails with Insufficient privileges connecting to Oracle Database using / as sysdba. I tried few things but finally manually run the following commands:

      CREATE OR REPLACE DIRECTORY APPS_DATA_FILE_DIR AS 'd:\prod\proddb\11.2.0\appsutil\outbound\PROD_ebsdbsvr';
      CREATE OR REPLACE DIRECTORY ECX_UTL_LOG_DIR_OBJ AS 'c:\temp';
      CREATE OR REPLACE DIRECTORY ECX_UTL_XSLT_DIR_OBJ AS 'c:\temp';


      Please let me know if this is a bug and if there is a permanent solution.

      Rgds,
      Thiru