Monday, January 5, 2009

Invalid range "a-Z" in transliteration operator

Error while running Pre-Clone Script.

Environment : Linux A.S.4
Bit : 32
Version : 11.5.10


[applspin@spinner SPIN_spinner]$ ./adpreclone.pl appsTier
Invalid range "a-Z" in transliteration operator at /d02/applspin/spinora/iAS/Apache/perl/lib/5.00503/vars.pm line 17.
Compilation failed in require at /d02/applspin/spinora/iAS/Apache/perl/lib/5.00503/File/Copy.pm line 13.
BEGIN failed--compilation aborted at /d02/applspin/spinora/iAS/Apache/perl/lib/5.00503/File/Copy.pm line 13.
Compilation failed in require at ./adpreclone.pl line 36.
BEGIN failed--compilation aborted at ./adpreclone.pl line 36.


Solution:

Open $IAS_ORACLE_HOME/Apache/perl/lib/5.00503/vars.pm and change (line 17):

if ($sym =~ tr/A-Za-Z_0-9//c) {

change to
if ($sym =~ tr/A-Za-z_0-9//c) {

(The change is the single character Z->z)

[applspin@spinner SPIN_spinner]$ ./adpreclone.pl appsTier
Completed Successfully


Reference: From Forums.

https://metalink2.oracle.com/metalink/plsql/f?p=200:27:7385154415821451567::::p27_id,p27_show_header,p27_show_help:677071.993,1,1

3 comments:

Anonymous said...

Hi We have installed new 9i oracle home on hp-ux and cloned the 11.5.9 database.

DB cloning was done manually.

DB home was configured autoconfigured.

While running adpreclone.pl dbTier
the below error occured

$ perl adpreclone.pl dbTier
Can't locate loadable object for module Fcntl in @INC (@INC contains:
/9ihome/9.2.0/Apache/perl/lib/5.00503/IA64.ARCHREV_0
/9ihome/9.2.0/Apache/perl/lib/5.00503
/9ihome/9.2.0/Apache/perl/lib/site_perl/5.005/IA64.ARCHREV_0
/9ihome/9.2.0/Apache/perl/lib/site_perl/5.005
/9ihome/9.2.0/appsutil/perl
/project/ia64hpunix64/9202/APACHE/src/pdc_perl/bin/HPUX/Opt/lib/5.00503/IA64.ARCHREV_0
/project/ia64hpunix64/9202/APACHE/src/pdc_perl/bin/HPUX/Opt/lib/5.00503
/project/ia64hpunix64/9202/APACHE/src/pdc_perl/bin/HPUX/Opt/lib/site_perl/5.005/IA64.ARCHREV_0
/project/ia64hpunix64/9202/APACHE/src/pdc_perl/bin/HPUX/Opt/lib/site_perl/5.005 .) at adpreclone.pl line 35
BEGIN failed--compilation aborted at adpreclone.pl line 35.

Regards,
Sreedhar

Prem Kumar said...

Hi .... Pls try the sol. available in the given reference note...if your error matched with it,,,,

Olathe Auto Locksmith said...

Loved reading thhis thank you