当前位置 博文首页 > lucifer三思后行:Oracle 自动升级工具AutoUpgrade错误代码

    lucifer三思后行:Oracle 自动升级工具AutoUpgrade错误代码

    作者:[db:作者] 时间:2021-06-07 18:15

    关于UPG错误:

    可参考:Where are AutoUpgrade error codes documented?
    一旦使用AutoUpgrade遇到错误情况,它将打印错误代码,例如UPG-1400或UPG-1303。

    通常,此错误代码不是很有意义。 那么如何可以找到有关这些错误代码的更多信息。

    可以通过?java -jar /soft/autoupgrade.jar -error_code 来获取错误信息,

    例如

    [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:

    [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}.
    
    

    ?