This discussion is archived
5 Replies Latest reply: Sep 26, 2012 7:36 AM by Helios-GunesEROL RSS

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

user1983888 Explorer
Currently Being Moderated
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