Sunday, October 23, 2011

Can't locate strict.pm in @INC (@INC while running adpreclone.pl dbTier

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Running adpreclone.pl on the Database tier gave the below error:

oratest@erptest-db $ perl adpreclone.pl dbTier
Can't locate strict.pm in @INC (@INC contains: /oracle/11.2.0/perl/lib/5.8.3 /oracle/11.2.0/perl/lib/site_perl/5.8.3 /oracle/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 ../lib/5.10.0 ../lib/5.10.0/sun4-solaris-thread-multi-64 ../lib/site_perl .) at adpreclone.pl line 34.
BEGIN failed--compilation aborted at adpreclone.pl line 34.

After upgrading you database from 10g to 11g , perl utility has been upgraded from 5.8.3 to 5.10.0

So in order to resolve this issue, you need to update the database main environment file :
cd $ORACLE_HOME
vi <SID>_hostname.env
and update the
PERL5LIB with the right location of your perl libraries.
from
$ORACLE_HOME/perl/lib/5.8.3 to $ORACLE_HOME/perl/lib/5.10.0

However




If you are using autoconfig, you have to
Login to the Application Manager then click on site map
From the Administration tap , click on AutoConfig from the system configuration area
Click on Edit Parameters for the Database section
From the search , search for title:PERL5LIB and click save
Then run autoconfig for the database.


Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: