Tuesday, April 7, 2015

Change ORACLE_BASE after installation

Situation:Want to change the ORACLE_BASE after the installation regardless the environment variable is set or not.

Cause:You used a wrong ORACLE_BASE location during the installation or want to set a new one.

Solution:Use the orabase utility. It is available in 11g and above.

First, check the current value of ORACLE_BASE:
$ORACLE_HOME/bin/orabase

Then, change the value using this command:
$ORACLE_HOME/bin/orabase -d <NEW_ORACLE_BASE>

Finally, verify if the ORACLE_BASE has been changed:
$ORACLE_HOME/bin/orabase

[RUEI] Synchronise with EBS on Solaris 10 SPARC

Situation:
When trying to synchronise RUEI with E-Business Suite on Sun Solaris 10 SPARC. The following error appears:
Can't locate strict.pm in @INC (@INC contains: /u300/baru/db/tech_st/11.2.0/perl/lib/5.8.3 /u300/baru/db/tech_st/11.2.0/perl/lib/site_perl/5.8.3 /u300/baru/db/tech_st/11.2.0/appsutil/perl ../lib/5.10.0/sun4-solaris-thread-multi-64 ../lib/5.10.0 ../lib/site_perl/5.10.0/sun4-solaris-thread-multi-64 ../lib/site_perl/5.10.0 .) at create_EBS_info.pl line 13.
BEGIN failed--compilation aborted at create_EBS_info.pl line 13.

Cause:
Perl path is not valid.

Solution:
Set the required perl in PATH through PERL5LIB:
export PERL5LIB=/db/tech_st/11.2.0/perl/lib/5.10.0:/db/tech_st/11.2.0/perl/lib/site_perl/5.10.0:/db/tech_st/11.2.0/appsutil/perl