adclonectx.pl failed

[latifa]

Hi Erman,

I am trying to generate environment in the standbay Database with running this command line:

perl $ORACLE_HOME/appsutil/clone/bin/adclonectx.pl \ contextfile=$ORACLE_HOME/appsutil/EBS1_scam02db07.xml \ ***source database contextfile*** template=$ORACLE_HOME/appsutil/template/adxdbctx.tmp \ pairsfile=$ORACLE_HOME/appsutil/clone/pairsfile.txt initialnode

However I got error message :

Please ensure that Classpath is set properly

What could be missing !

I set : export PATH=$ORACLE_HOME/bin:$PATH

It dosen't change any thing.

Thank you very much for your help.

Regards,
Latifa

[ErmanArslansOracleBlog]

Hi Latifa,

What is the version of this EBS?
I think it is 11i, is it right?
What 's the ATG version?

There is a bug which was fixes in 11i.ATG_PF.H.delta.7 (RUP 7).

7305054 OAM:ADCLONECTX.PL FAILS WITH "PLEASE ENSURE THAT CLASSPATH IS SET PROPERLY" ON 11G

So it seems, it just can't get the classpath properly..

Answer the questions above and send me the adclonectx.pl of yours for further analysis.

[latifa]

Hi Erman,

EBS version is 12.1.3

Database is 12c.

How to find ATG version ?

CLASSPATH has no value even in the primary site (database).

Please find joined to this message adclonectx.pl file.

adclonectx.pl

Regards,
Latifa

[ErmanArslansOracleBlog]

That error is coming from the following check:

if ( $ADCONFIG eq "" or $XMLPARSERV2 eq ""
    or $JDBCCLASSES eq "") {
    print "Please ensure that Classpath is set properly\n";
    die "\n";
  }
  else {
  }

So, one of the following is empty and that's why you are getting error:

ADCONFIG
XMLPARSERV2
JDBCCLASSES

[ErmanArslansOracleBlog]

These variables are dependent on the current working directory where you execute the adclonectx.pl.
So there should be a jlib directory there..
In that directory; adclonectx.pl is searching for certain jar file, for ex: ojdbc5.jar or ojdbc14.jar or jdbc14.jar , etc..
So if it finds one of them, it sets the JDBCCLASSES.
If it can't find any one then, your JDBCCLASSRS will be null.

Likewise, for XMLPARSERV2 , that jlib directory is searched.. It is searched for xmlparserv2-904.zip or xmlparserv2.jar etc.. So if it can't find any of these kinds of files, your XMLPARSERV2 will be null...

So check your filesystem accordingly.

jlib should be located in the parent directory of adclonectx.pl. |current_working_direcotry\/../jlib/..

so you jlib may be missing. or it may be lacking some files.. compare it with your source db..
Also ensure that, you are executing the adclonectx.pl from where it resides.

[latifa]

Hi Erman,

Thank you for your reply.

I run  adclonectx.pl from $ORACLE_HOME/appsutil/clone/bin/
In $ORACLE_HOME/appsutil/clone : there is :

drwxr-xr-x   3 oracle   oinstall       3 Feb 26 12:08 java
-rw-r--r--   1 oracle   oinstall 1669142 Mar 13 14:02 xmlparserv2.jar
-rw-r--r--   1 oracle   oinstall 3718685 Mar 13 14:02 ojdbc6.jar
drwxr-xr-x   3 oracle   oinstall      46 Mar 13 14:02 oui

--> Similar as source

So there is ojdbc6.jar and xmlparserv2.jar, so I think it should work.

So why it doesn't work.

[ErmanArslansOracleBlog]

The files that are set for the $ADCONFIG variable, may be missing..

Please compare your /appsutil directory with a working instance.. Any files missing or any difference that you see?

[latifa]

Hi Erman,

I copied appsutil from source system so appsutil is similar as source one.

However, I tried to clean nodes with this and I have got the following message:

SQL> exec fnd_conc_clone.setup_clean ;
BEGIN fnd_conc_clone.setup_clean ; END;

*
ERROR at line 1:
ORA-16000: database or pluggable database open for read-only access
ORA-06512: at "APPS.FND_CONC_CLONE", line 354
ORA-06512: at line 1

Regards,
Latifa

[ErmanArslansOracleBlog]

Is your environment correct? (I m asking these for both of your problems, both fnd_conc_clone and adclonectx.pl)

What is this database? Is it an active dataguard or something? ORA-16000 is weird.. This is coming from the core / RDBMS , and it means there is read/write attempt in a readonly database.