내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
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로 설치
중단된 작업 재실행
1 2 | 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 엔진을 설치하지 않아 발생한 문제
참조 :
'ORACLE > Trouble Shooting' 카테고리의 다른 글
| DIA-48223: Interrupt Requested - Fetch Aborted - Return Code [1] [DIR_EXT] (0) | 2020.03.29 |
|---|---|
| Invalid value for target_home [/app/oracle/product/19.0.0/db_1] (0) | 2020.03.24 |
| UPG-1312 AutoUpgrade (0) | 2020.03.24 |
| It is not possible to determine the target ORACLE_BASE (0) | 2020.03.24 |
| IO 오류 : Got minus one from a read call, connect lapse 18ms., Authentication lapse 0 ms. (2) | 2020.03.11 |