关于UPG错误:
可参考:Where are AutoUpgrade error codes documented? 一旦使用AutoUpgrade遇到错误情况,它将打印错误代码,例如UPG-1400或UPG-1303。
通常,此错误代码不是很有意义。 那么如何可以找到有关这些错误代码的更多信息。
可以通过 java -jar /soft/autoupgrade.jar -error_code 来获取错误信息,
例如:
代码语言:javascript复制[oracle@cdb19c:/home/oracle]$ java -jar /soft/autoupgrade.jar -error_code UPG-1304
ERROR1304.ERROR = UPG-1304
ERROR1304.CAUSE = IO error creating before, during or after upgrade pfile
以下罗列出所有的ERROR CODE:
代码语言:javascript复制[oracle@cdb19c:/home/oracle]$ java -jar /soft/autoupgrade.jar -error_code
ERROR1000.ERROR = UPG-1000
ERROR1000.CAUSE = It was not possible to create the data file where the jobsTable is being written or there was a problem during the writing, it might be thrown due to a permission error or a busy resource scenario
ERROR1001.ERROR = UPG-1001
ERROR1001.CAUSE = There was a problem reading the state file perhaps there was corruption writing the file and in the next write it might be fixed
ERROR1002.ERROR = UPG-1002
ERROR1002.CAUSE = Error deserializing the object for rerun, review log for any errors
ERROR1100.ERROR = UPG-1100
ERROR1100.CAUSE = either, the console or the job manager were interrupted and it might lead to unknown errors because if there were active tasks running they won't be able to be finish gracefully nor we will guarantee that we track their progress properly
ERROR1200.ERROR = UPG-1200
ERROR1200.CAUSE = Error reading the standard input, perhaps a malformed character or there was a problem with the process's stdin
ERROR1300.ERROR = UPG-1300
ERROR1300.CAUSE = The current execution of the database fixups was interrupted and a set of checks is still pending
ERROR1301.ERROR = UPG-1301
ERROR1301.CAUSE = The current execution of the database fixups was not completed
ERROR1302.ERROR = UPG-1302
ERROR1302.CAUSE = The current execution of the database checks was interrupted
ERROR1303.ERROR = UPG-1303
ERROR1303.CAUSE = A failed check has an ERROR severity but the fixup is unavailable or failed to correct the problem. Manually fix the problem and rerun AutoUpgrade
ERROR1304.ERROR = UPG-1304
ERROR1304.CAUSE = IO error creating before, during or after upgrade pfile
ERROR1305.ERROR = UPG-1305
ERROR1305.CAUSE = Error executing SQL statement in upgrade inspector during database preupgrade checks
ERROR1306.ERROR = UPG-1306
ERROR1306.CAUSE = Error during the database preupgrade checks in upgrade inspector
ERROR1307.ERROR = UPG-1307
ERROR1307.CAUSE = Error running database postupgrade checks in upgrade inspector
ERROR1308.ERROR = UPG-1308
ERROR1308.CAUSE = Error running database postupgrade checks in upgrade inspector
ERROR1309.ERROR = UPG-1309
ERROR1309.CAUSE = Error accessing the log file that contains the check list (CFG format)
ERROR1310.ERROR = UPG-1310
ERROR1310.CAUSE = Error accessing the log file that contains the check list (log format)
ERROR1311.ERROR = UPG-1311
ERROR1311.CAUSE = Error accessing the checks HTML report file
ERROR1312.ERROR = UPG-1312
ERROR1312.CAUSE = A failed check has an ERROR severity but the fixup is unavailable or failed to correct the problem. Manually fix the problem and rerun AutoUpgrade
ERROR1313.ERROR = UPG-1313
ERROR1313.CAUSE = Internal error, contact Oracle Support
ERROR1314.ERROR = UPG-1314
ERROR1314.CAUSE = User requested an abort of the checks
ERROR1315.ERROR = UPG-1315
ERROR1315.CAUSE = User requested an abort of the fixups
ERROR1316.ERROR = UPG-1316
ERROR1316.CAUSE = Error running database checks or fixups
ERROR1317.ERROR = UPG-1317
ERROR1317.CAUSE = Required checkslist file unavailable; unable to run fixups
ERROR1318.ERROR = UPG-1318
ERROR1318.CAUSE = Error creating custom pfiles
ERROR1319.ERROR = UPG-1319
ERROR1319.CAUSE = Loading the current state of the database failed
ERROR1400.ERROR = UPG-1400
ERROR1400.CAUSE = Database upgrade failed with errors
ERROR1401.ERROR = UPG-1401
ERROR1401.CAUSE = Opening database for upgrade in the target home failed
ERROR1402.ERROR = UPG-1402
ERROR1402.CAUSE = GRP creation prior to upgrade failed
ERROR1403.ERROR = UPG-1403
ERROR1403.CAUSE = Drop of existing GRP failed
ERROR1404.ERROR = UPG-1404
ERROR1404.CAUSE = Error running upgrade
ERROR1405.ERROR = UPG-1405
ERROR1405.CAUSE = Database upgrade was interrupted
ERROR1406.ERROR = UPG-1406
ERROR1406.CAUSE = Unexpected Exception occurred during database compilations.
ERROR1407.ERROR = UPG-1407
ERROR1407.CAUSE = IO error creating database spfile
ERROR1408.ERROR = UPG-1408
ERROR1408.CAUSE = Unable to open pdb in upgrade mode
ERROR1409.ERROR = UPG-1409
ERROR1409.CAUSE = Unable to open pdb in normal mode
ERROR1410.ERROR = UPG-1410
ERROR1410.CAUSE = Unable to open database in normal mode
ERROR1411.ERROR = UPG-1411
ERROR1411.CAUSE = Invalid version of catctl.pl and catctl.pm
ERROR1412.ERROR = UPG-1412
ERROR1412.CAUSE = Unable to query database
ERROR1413.ERROR = UPG-1413
ERROR1413.CAUSE = Error occurred during upgrade
ERROR1414.ERROR = UPG-1414
ERROR1414.CAUSE = Database compilation interrupted
ERROR1415.ERROR = UPG-1415
ERROR1415.CAUSE = Database upgrade interrupted by a system shutdown or CTRL C
ERROR1416.ERROR = UPG-1416
ERROR1416.CAUSE = Error during database compilations
ERROR1417.ERROR = UPG-1417
ERROR1417.CAUSE = PDB upgrade failed with errors
ERROR1418.ERROR = UPG-1418
ERROR1418.CAUSE = Database upgrade failed; review the upgrade log files
ERROR1419.ERROR = UPG-1419
ERROR1419.CAUSE = Database upgrade job has been killed, by abort or restore
ERROR1420.ERROR = UPG-1420
ERROR1420.CAUSE = Enabling Local Undo failed
ERROR1500.ERROR = UPG-1500
ERROR1500.CAUSE = Database post upgrade failed
ERROR1501.ERROR = UPG-1501
ERROR1501.CAUSE = Oratab file not readable
ERROR1502.ERROR = UPG-1502
ERROR1502.CAUSE = Oratab file not writable
ERROR1503.ERROR = UPG-1503
ERROR1503.CAUSE = IO error updating the oratab file
ERROR1504.ERROR = UPG-1504
ERROR1504.CAUSE = Error writing to oratab file
ERROR1505.ERROR = UPG-1505
ERROR1505.CAUSE = Error copying listener.ora file in postupgrade
ERROR1506.ERROR = UPG-1506
ERROR1506.CAUSE = Error copying tnsnames.ora file in postupgrade
ERROR1507.ERROR = UPG-1507
ERROR1507.CAUSE = Error copying sqlnet.ora file in postupgrade
ERROR1508.ERROR = UPG-1508
ERROR1508.CAUSE = Error processing the ifile
ERROR1509.ERROR = UPG-1509
ERROR1509.CAUSE = Error copying the wallet files
ERROR1510.ERROR = UPG-1510
ERROR1510.CAUSE = Unable to create the postupgrade directory
ERROR1511.ERROR = UPG-1511
ERROR1511.CAUSE = Error during user-defined postupgrade action
ERROR1512.ERROR = UPG-1512
ERROR1512.CAUSE = Error copying the password files
ERROR1513.ERROR = UPG-1513
ERROR1513.CAUSE = Error restoring the database state
ERROR1514.ERROR = UPG-1514
ERROR1514.CAUSE = Error deserializing the database state
ERROR1515.ERROR = UPG-1515
ERROR1515.CAUSE = Error dropping the GRP
ERROR1516.ERROR = UPG-1516
ERROR1516.CAUSE = Error restarting the database
ERROR1517.ERROR = UPG-1517
ERROR1517.CAUSE = Error recreating the final spfile
ERROR1518.ERROR = UPG-1518
ERROR1518.CAUSE = An error occurred while copying Context text files in Postupgrade phase
ERROR1519.ERROR = UPG-1519
ERROR1519.CAUSE = An error occurred while generating Context text file list in Drain phase
ERROR1520.ERROR = UPG-1520
ERROR1520.CAUSE = Error copying oranfstab file in postupgrade
ERROR1521.ERROR = UPG-1521
ERROR1521.CAUSE = Error copying ldap.ora file in postupgrade
ERROR1522.ERROR = UPG-1522
ERROR1522.CAUSE = Error updating network file's ORACLE_HOME in postupgrade
ERROR1523.ERROR = UPG-1523
ERROR1523.CAUSE = Error restarting the pdbs
ERROR1600.ERROR = UPG-1600
ERROR1600.CAUSE = Error copying the pfile during an UPGRADE mode job
ERROR1601.ERROR = UPG-1601
ERROR1601.CAUSE = Error reading the error properties file
ERROR1602.ERROR = UPG-1602
ERROR1602.CAUSE = Job killed
ERROR1603.ERROR = UPG-1603
ERROR1603.CAUSE = Error executing a database command for PDB$SEED
ERROR1604.ERROR = UPG-1604
ERROR1604.CAUSE = Error executing a database command
ERROR1605.ERROR = UPG-1605
ERROR1605.CAUSE = Unable to abort a job in a unsupported stage
ERROR1606.ERROR = UPG-1606
ERROR1606.CAUSE = Source version cannot be upgraded to the specified target version
ERROR1607.ERROR = UPG-1607
ERROR1607.CAUSE = Target version is not supported by AutoUpgrade
ERROR1608.ERROR = UPG-1608
ERROR1608.CAUSE = Unable to determine database version; review the logs files
ERROR1699.ERROR = UPG-1699
ERROR1699.CAUSE = Error finding error definition, contact Oracle Support
ERROR1700.ERROR = UPG-1700
ERROR1700.CAUSE = Error generating Windows services in drain module
ERROR1701.ERROR = UPG-1701
ERROR1701.CAUSE = Error stopping queue jobs during drain
ERROR1702.ERROR = UPG-1702
ERROR1702.CAUSE = Error deleting service during drain, review log files
ERROR1703.ERROR = UPG-1703
ERROR1703.CAUSE = Error creating service during drain, review log files
ERROR1704.ERROR = UPG-1704
ERROR1704.CAUSE = Error commenting service during drain, review log files
ERROR1705.ERROR = UPG-1705
ERROR1705.CAUSE = Error changing service owner during drain, review log files
ERROR1706.ERROR = UPG-1706
ERROR1706.CAUSE = Error starting service during drain, review log files
ERROR1707.ERROR = UPG-1707
ERROR1707.CAUSE = Error stopping service during drain, review log files
ERROR1708.ERROR = UPG-1708
ERROR1708.CAUSE = Error changing the source database state
ERROR1709.ERROR = UPG-1709
ERROR1709.CAUSE = Error serializing the database state
ERROR1710.ERROR = UPG-1710
ERROR1710.CAUSE = Error during PDB operation in drain
ERROR1711.ERROR = UPG-1711
ERROR1711.CAUSE = An error occurred while deferring Standby in Drain phase
ERROR1800.ERROR = UPG-1800
ERROR1800.CAUSE = Progress report is empty, review log file
ERROR1900.ERROR = UPG-1900
ERROR1900.CAUSE = Unable to create preupgrade directory
ERROR1901.ERROR = UPG-1901
ERROR1901.CAUSE = Error during user-defined preupgrade action
ERROR2000.ERROR = UPG-2000
ERROR2000.CAUSE = Creation of GRP failed
ERROR2001.ERROR = UPG-2001
ERROR2001.CAUSE = Unable to drop GRP
ERROR2002.ERROR = UPG-2002
ERROR2002.CAUSE = Restoration of the GRP failed
ERROR2003.ERROR = UPG-2003
ERROR2003.CAUSE = Unable to validate proper database state to start GRP restoration
ERROR2004.ERROR = UPG-2004
ERROR2004.CAUSE = Unable to create restore point due to insufficient disk space
ERROR2005.ERROR = UPG-2005
ERROR2005.CAUSE = AutoUpgrade is unable to proceed because database is not in ARCHIVE LOG mode and guarantee restore point cannot be taken (default behavior). In order to proceed either put de database in ARCHIVE LOG mode and enable database flashback or add entry restoration=no in the configuration file.
ERROR3000.ERROR = UPG-3000
ERROR3000.CAUSE = Error executing noncdbtopdb task
ERROR3001.ERROR = UPG-3001
ERROR3001.CAUSE = Could not describe the specified database
ERROR3002.ERROR = UPG-3002
ERROR3002.CAUSE = Could not execute database action
ERROR3003.ERROR = UPG-3003
ERROR3003.CAUSE = Plugin violations found
ERROR3004.ERROR = UPG-3004
ERROR3004.CAUSE = Could not create pluggable database
ERROR3005.ERROR = UPG-3005
ERROR3005.CAUSE = Error running noncdb_to_pdb.sql script
ERROR3006.ERROR = UPG-3006
ERROR3006.CAUSE = Error starting the database
ERROR3007.ERROR = UPG-3007
ERROR3007.CAUSE = User requested an abort of the noncdbtopdb task
ERROR3008.ERROR = UPG-3008
ERROR3008.CAUSE = Unable to remove the oratab entry of the source DB
ERROR3009.ERROR = UPG-3009
ERROR3009.CAUSE = After running noncdb_to_pdb.sql, the pdb was closed or was opened in restricted mode
ERROR3010.ERROR = UPG-3010
ERROR3010.CAUSE = Error running approot_to_pdb.sql script
ERROR3100.ERROR = UPG-3100
ERROR3100.CAUSE = Unable to list RAC services
ERROR3101.ERROR = UPG-3101
ERROR3101.CAUSE = Unable to shutdown RAC services
ERROR3102.ERROR = UPG-3102
ERROR3102.CAUSE = Unable to shutdown RAC database
ERROR3103.ERROR = UPG-3103
ERROR3103.CAUSE = Failed to disable RAC database
ERROR3104.ERROR = UPG-3104
ERROR3104.CAUSE = Unable to remove spfile parameter
ERROR3105.ERROR = UPG-3105
ERROR3105.CAUSE = Unable to start RAC database
ERROR3106.ERROR = UPG-3106
ERROR3106.CAUSE = Unable to upgrade RAC database on CRS
ERROR3107.ERROR = UPG-3107
ERROR3107.CAUSE = Unable to update spfile information on CRS
ERROR3108.ERROR = UPG-3108
ERROR3108.CAUSE = Failed to enable RAC database on CRS
ERROR3109.ERROR = UPG-3109
ERROR3109.CAUSE = Unable to stop current instance
ERROR3110.ERROR = UPG-3110
ERROR3110.CAUSE = Unable to downgrade RAC database source binaries on CRS
ERROR3111.ERROR = UPG-3111
ERROR3111.CAUSE = Failed to enable RAC database source binaries on CRS
ERROR3112.ERROR = UPG-3112
ERROR3112.CAUSE = Unable to start RAC database after downgrade source binaries on CRS
ERROR3113.ERROR = UPG-3113
ERROR3113.CAUSE = After executing "srvctl stop database", AutoUpgrade sees that the RAC database is still up, which suggests that the database was started up manually and not via CRS. This condition can cause AutoUpgrade to stop the current job.
ERROR3114.ERROR = UPG-3114
ERROR3114.CAUSE = Database could not be removed from Clusterware.
ERROR3115.ERROR = UPG-3115
ERROR3115.CAUSE = Unable to set TNS_ADMIN environmental variable in srvctl
ERROR4000.ERROR = CON-4000
ERROR4000.CAUSE = Database {0} shutdown or open with incorrect binaries for {1}. Ensure it is open with {2}
ERROR4001.ERROR = CON-4001
ERROR4001.CAUSE = Database {0} currently has a status of {1}. For {2} mode, open it with one of the following: {3}.