datapatch fails with Error :"Can't locate XML/Simple.pm in @INC " or "Can't locate sqlpatch.pm in @INC" or "sqlpatch.bat not recognized"
(Doc ID 2696332.1)
Last updated on MARCH 06, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.
Symptoms
1) datapatch fails with error:
datapatch -verbose
Can't locate XML/Simple.pm in @INC (@INC contains: $ORACLE_HOME/sqlpatch
$ORACLE_HOME/rdbms/admin $ORACLE_HOME/sqlpatch/lib $ORACLE_HOME/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi
$ORACLE_HOME/perl/lib/site_perl/5.14.1
$ORACLE_HOME/perl/lib/5.14.1/x86_64-linux-thread-multi
$ORACLE_HOME/perl/lib/5.14.1 .) at
$ORACLE_HOME/sqlpatch/sqlpatch.pm line 188.
BEGIN failed--compilation aborted at $ORACLE_HOME/sqlpatch/sqlpatch.pm line 188.
Compilation failed in require at $ORACLE_HOME/sqlpatch/sqlpatch.pl line 64.
BEGIN failed--compilation aborted at $ORACLE_HOME/sqlpatch/sqlpatch.pl line 64.
Can't locate XML/Simple.pm in @INC (@INC contains: $ORACLE_HOME/sqlpatch
$ORACLE_HOME/rdbms/admin $ORACLE_HOME/sqlpatch/lib $ORACLE_HOME/perl/lib/site_perl/5.14.1/x86_64-linux-thread-multi
$ORACLE_HOME/perl/lib/site_perl/5.14.1
$ORACLE_HOME/perl/lib/5.14.1/x86_64-linux-thread-multi
$ORACLE_HOME/perl/lib/5.14.1 .) at
$ORACLE_HOME/sqlpatch/sqlpatch.pm line 188.
BEGIN failed--compilation aborted at $ORACLE_HOME/sqlpatch/sqlpatch.pm line 188.
Compilation failed in require at $ORACLE_HOME/sqlpatch/sqlpatch.pl line 64.
BEGIN failed--compilation aborted at $ORACLE_HOME/sqlpatch/sqlpatch.pl line 64.
or
datapatch -bootstrap
Can't locate sqlpatch.pm in @INC (you may need to install the sqlpatch module) (@INC entries checked: $ORACLE_HOME/sqlpatch $ORACLE_HOME/rdbms/admin $ORACLE_HOME/sqlpatch/lib $ORACLE_HOME/perl/lib/site_perl/5.38.2/x86_64-linux-thread-multi $ORACLE_HOME/perl/lib/site_perl/5.38.2 $ORACLE_HOME/perl/lib/5.38.2/x86_64-linux-thread-multi $ORACLE_HOME/perl/lib/5.38.2) at $ORACLE_HOME/sqlpatch/sqlpatch.pl line 138.
BEGIN failed--compilation aborted at $ORACLE_HOME/sqlpatch/sqlpatch.pl line 138
Can't locate sqlpatch.pm in @INC (you may need to install the sqlpatch module) (@INC entries checked: $ORACLE_HOME/sqlpatch $ORACLE_HOME/rdbms/admin $ORACLE_HOME/sqlpatch/lib $ORACLE_HOME/perl/lib/site_perl/5.38.2/x86_64-linux-thread-multi $ORACLE_HOME/perl/lib/site_perl/5.38.2 $ORACLE_HOME/perl/lib/5.38.2/x86_64-linux-thread-multi $ORACLE_HOME/perl/lib/5.38.2) at $ORACLE_HOME/sqlpatch/sqlpatch.pl line 138.
BEGIN failed--compilation aborted at $ORACLE_HOME/sqlpatch/sqlpatch.pl line 138
2)In Windows:
datapatch fails with error:
datapatch -verbose
'%ORACLE_HOME%\OPatch\\..\sqlpatch\sqlpatch.bat' is not recognized as an internal or external command,operable program or batch file. "
'%ORACLE_HOME%\OPatch\\..\sqlpatch\sqlpatch.bat' is not recognized as an internal or external command,operable program or batch file. "
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |