Thursday, January 11, 2007

RepCA on HPUX 64-Bit

You may run into the following errors when running RepCA on HPUX 64-Bit (Itanium):

in the repca.log file

[CustomExternalProcessAction] Command line: /oracle/product/10.1.2.mrca/jdk/bin/java -cp /oracle/product/10.1.2.mrca/assistants/opca/jlib/opca.jar:/oracle/product/10.1.2.mrca/portal/jlib/ptlshare.jar:/oracle/product/10.1.2.mrca/jdbc/lib/classes12.jar:/oracle/product/10.1.2.mrca/jdbc/lib/nls_charset12.jar oracle.webdb.config.PortalConfigAssistant
[CustomExternalProcessAction] Process exited abnormally
[CustomExternalProcessAction] Action failed due to: oracle.ias.repca.ifs.utils.action.ActionFailedException: Some of the operations have failed during this OracleAS RepCA session. Please see the log file at /oracle/product/10.1.2.mrca/assistants/repca/log/repca_2007-01-11_01-38-25_PM.log for further details.
ERROR - Some of the operations have failed during this OracleAS RepCA session. Please see the log file at /oracle/product/10.1.2.mrca/assistants/repca/log/repca_2007-01-11_01-38-25_PM.log for further details.
oracle.ias.repca.ifs.utils.action.ActionFailedException: Some of the operations have failed during this OracleAS RepCA session. Please see the log file at /oracle/product/10.1.2.mrca/assistants/repca/log/repca_2007-01-11_01-38-25_PM.log for further details.
at oracle.ias.repca.actions.CustomExternalProcessAction.perform(CustomExternalProcessAction.java:155)
at oracle.ias.repca.ifs.utils.action.ActionQueue.performActions(ActionQueue.java:319)
at oracle.ias.repca.ifs.utils.action.ActionQueue.run(ActionQueue.java:245)
at java.lang.Thread.run(Thread.java:534)



in the sso.log file

...end of SSO install

INSTALL_ACTION:createSSOSchema() : loadjava -resolve -verbose -user orasso/orasso@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=xxxxx))) /oracle/product/10.1.2.mrca/portal/admin/plsql/sso/SSOExtDB.class

arguments: '-resolve' '-verbose' '-user' 'orasso/orasso@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=xxxxx)))' '/oracle/product/10.1.2.mrca/portal/admin/plsql/sso/SSOExtDB.class'

SQL Error while connecting with oci8 driver to (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=xxxxx))): Closed Connection

exiting : could not open connection

INSTALL_ACTION:createSSOSchema() : loadjava -resolve -verbose -user orasso/orasso@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=xxxxx))) /oracle/product/10.1.2.mrca/portal/admin/plsql/wwc/SSOHash.class

arguments: '-resolve' '-verbose' '-user' 'orasso/orasso@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=xxxxx)))' '/oracle/product/10.1.2.mrca/portal/admin/plsql/wwc/SSOHash.class'

SQL Error while connecting with oci8 driver to (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=xxxxx))): Closed Connection

exiting : could not open connection

INSTALL_ACTION : Set the component loading flag for SSO

ERROR: Setting the component loading flag in the DBMS registry raised exception.



It could be that the loadjava of the repca doesn't work well in this configuration. There are probably at least two issues: first, the symbolic link $REPCA_HOME/JRE does not point to the correct location. It needs to point to the full JRE location (java/1.3.1). Second, the loadjava itself is an issue. I tried to solve the problem in a bunch of ways, but found the easiest thing to do is just run the repca from a Windows or Linux box. Much faster than troubleshooting the install on HPUX.

4 comments:

Ashish said...

HI,

Did you manage to fix this issue as I have having the same problem in my sso.log and repca log.

Can you please update this post to tell How you managed to fix this issue.

Thanks

Anton Nielsen said...

Ashish,

I never bothered to figure it out. in general I have decided not to run RepCA from HPUX. I have found the HPUX version of RepCA to be very buggy. The 10.1.4 HPUX RepCA requires a patch to have it create with the right version. If you just download HPUX RepCA 10.1.4 from Oracle it creates an repository with a version of 10.1.2. Instead of installing the patch, I just always run RepCA from Linux or Windows.

Martin Malmstrom said...

I ran into the same issue today on an AIX machine, but I was able to solve it with this Metalink note:

436246.1 "The Metadata Repository Creation Assistant Fails While Opening Orasso-Connection, Against 10.1.2.0.3 Database"

If present, unset:
* NLS_LANG
* ORA_NLS33

Regards,
Martin

Anton Nielsen said...

Martin,

Thanks for the info. The RepCA should create the same database objects for all operating systems, but the installer itself has to be slightly different. Unfortunately sometimes the db scripts are also different. I have found a variety of problems with RepCA on both HPUX and AIX. The Linux scripts seem to be the most well tested, so I have opted to always use the Linux version.

Anton