UPG-1400 AutoUpgrade

OS환경 : Oracle Linux 7.6 (64bit)

DB 환경 : Oracle Database 18.1.0.0

에러 : UPG-1400 AutoUpgrade

18c 에서 19c로 AutoUpgrade 명령으로 업그레이드 작업 중 발생한 문제

AutoUpgrade deploy 명령 실행

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

$ $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config config.txt -mode deploy AutoUpgrade tool launched with default options Processing config file ... +--------------------------------+ | Starting AutoUpgrade execution | +--------------------------------+ 1 databases will be processed Type 'help' to list console commands upg> lsj -p +----+-------+---------+---------+-------+--------------+--------+--------+---------------+ |Job#|DB_NAME|    STAGE|OPERATION| STATUS|    START_TIME|END_TIME| UPDATED|        MESSAGE| +----+-------+---------+---------+-------+--------------+--------+--------+---------------+ | 103|   orcl|PRECHECKS|PREPARING|RUNNING|20/03/24 00:32|     N/A|00:32:34|Loading DB info| +----+-------+---------+---------+-------+--------------+--------+--------+---------------+ Total jobs 1

작업중 에러발생

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

upg>  ------------------------------------------------- Errors in database [orcl] Stage     [DBUPGRADE] Operation [STOPPED] Status    [ERROR] Info    [ Error: UPG-1400 UPGRADE FAILED [orcl] Cause: This indicates that the database upgrade failed with errors. For further details, see the log file located at  /home/oracle/upg_logs/orcl/orcl/103/autoupgrade_20200324_user.log]   ------------------------------------------------- Logs: [/home/oracle/upg_logs/orcl/orcl/103/autoupgrade_20200324_user.log] -------------------------------------------------

해당 작업 조회

1 2 3 4 5 6 7

upg> lsj -p +----+-------+---------+---------+------+--------------+--------+--------+--------+ |Job#|DB_NAME|    STAGE|OPERATION|STATUS|    START_TIME|END_TIME| UPDATED| MESSAGE| +----+-------+---------+---------+------+--------------+--------+--------+--------+ | 103|   orcl|DBUPGRADE|  STOPPED| ERROR|20/03/24 00:32|     N/A|00:46:09|UPG-1400| +----+-------+---------+---------+------+--------------+--------+--------+--------+ Total jobs 1

해당 로그 확인

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55

$ cat /home/oracle/upg_logs/orcl/orcl/103/autoupgrade_20200324_user.log 2020-03-24 00:44:19.345 INFO  build.hash:04dd9f2 build.version:19.7.5 build.date:2020/02/11 15:28:49 build.max_target_version:19 build.type:production build.label:HEAD   2020-03-24 00:44:19.400 INFO Using /home/oracle/upg_logs/orcl/orcl/103/prechecks/orcl_checklist.cfg  as reference to determine the fixups which will be executed  2020-03-24 00:44:35.761 INFO Adding fixup PURGE_RECYCLEBIN to execution queue of orcl  2020-03-24 00:45:00.973 INFO Analyzing orcl, 74 checks will run using 2 threads  2020-03-24 00:45:59.075 INFO Copying password file from /app/oracle/product/18.1.0/db_1/dbs/orapworcl  to /app/oracle/product/19.0.0/db_1/dbs/orapworcl  2020-03-24 00:45:59.082 INFO Copying password file completed with success  2020-03-24 00:45:59.113 WARNING Permission denied.  The current user does not have the necessary  permissions to run the command /app/oracle/product/19.0.0/db_1/bin/sqlplus.  2020-03-24 00:45:59.114 ERROR Creating Process Sql*Plus Failed  2020-03-24 00:45:59.115 WARNING Permission denied.  The current user does not have the necessary  permissions to run the command /app/oracle/product/19.0.0/db_1/bin/sqlplus.  2020-03-24 00:45:59.115 ERROR Creating Process Sql*Plus Failed  2020-03-24 00:45:59.117 WARNING Permission denied.  The current user does not have the necessary  permissions to run the command /app/oracle/product/19.0.0/db_1/bin/sqlplus.  2020-03-24 00:45:59.117 ERROR Creating Process Sql*Plus Failed  2020-03-24 00:45:59.118 WARNING Permission denied.  The current user does not have the necessary  permissions to run the command /app/oracle/product/19.0.0/db_1/bin/sqlplus.  2020-03-24 00:45:59.118 ERROR Creating Process Sql*Plus Failed  2020-03-24 00:45:59.489 INFO Total Number of upgrade phases is 108  2020-03-24 00:45:59.505 INFO Begin Upgrade on Database [orcl]  2020-03-24 00:46:04.513 WARNING Permission denied.  The current user does not have the necessary  permissions to run the command /app/oracle/product/19.0.0/db_1/bin/sqlplus.  2020-03-24 00:46:04.513 ERROR Creating Process Sql*Plus Failed  2020-03-24 00:46:04.514 WARNING Permission denied.  The current user does not have the necessary  permissions to run the command /app/oracle/product/19.0.0/db_1/bin/sqlplus.  2020-03-24 00:46:04.514 ERROR Creating Process Sql*Plus Failed  2020-03-24 00:46:04.522 ERROR  DATABASE NAME: orcl          CAUSE: ERROR at Line 700 in [/home/oracle/upg_logs/orcl/orcl/103/dbupgrade/catupgrd20200324004419orcl0.log]         REASON: CATCTL FATAL ERROR         ACTION: [MANUAL]         DETAILS:    2020-03-24 00:46:04.544 ERROR Database Upgrade Error in File  [/home/oracle/upg_logs/orcl/orcl/103/dbupgrade/catupgrd20200324004419orcl0.log]  on Database [/home/oracle/upg_logs/orcl/orcl/103/dbupgrade/catupgrd20200324004419orcl0.log]  2020-03-24 00:46:04.547 ERROR UPGRADE FAILED [orcl]  2020-03-24 00:46:04.548 ERROR Exception Error in Database Upgrade [UPG-1400#UPGRADE FAILED [orcl]]  2020-03-24 00:46:04.548 INFO End Upgrade on Database [orcl]  2020-03-24 00:46:09.522 ERROR UPGRADE FAILED [orcl]  2020-03-24 00:46:09.523 ERROR Exception Error in Database Upgrade [orcl]  2020-03-24 00:46:09.566 ERROR orcl Return status is ERROR  2020-03-24 00:46:09.571 INFO Starting error management routine  2020-03-24 00:46:09.572 INFO Ended error management routine  2020-03-24 00:46:09.573 ERROR Error occurred while running the dispatcher for job 103 Cause: This indicates that the database upgrade failed with errors.

sqlplus 에 Permission denied 가 발생하고 있음

해결 방법 : 업그레이드 대상버전(19c) ./runInstaller 실행

19c ./runInstaller 실행

1 2	$ cd /app/oracle/product/19.0.0/db_1/ $ ./runInstaller

software only로 설치

중단된 작업 재실행

upg> resume -job 103
Resuming job: [103][orcl]

작업확인

1 2 3 4 5 6 7

upg> lsj -p +----+-------+---------+---------+-------+--------------+--------+--------+-----------+ |Job#|DB_NAME|    STAGE|OPERATION| STATUS|    START_TIME|END_TIME| UPDATED|    MESSAGE| +----+-------+---------+---------+-------+--------------+--------+--------+-----------+ | 103|   orcl|DBUPGRADE|EXECUTING|RUNNING|20/03/24 00:32|     N/A|01:02:27|0%Upgraded | +----+-------+---------+---------+-------+--------------+--------+--------+-----------+ Total jobs 1

MESSAGE에 0%Upgraded로 퍼센트가 표시됨

원인 : 업그레이드 대상버전(19c)db 엔진을 설치하지 않아 발생한 문제

업그레이드 대상버전(19c)db 엔진을 설치하지 않아 발생한 문제

참조 :