OS환경 : Oracle Linux 7.5 (64bit)
DB 환경 : Oracle Database 19.3.0.0
방법 : 오라클 19c 홈경로(엔진경로) 변경 방법
기존 경로 : /ORA19/app/oracle/product/19.0.0/db_1
변경 경로 : /ORA19/app/oracle/product/19c
홈경로 변경 전 db 및 리스너 종료
1 2 3 4 5 6 7 8 9 10 11 12 | SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. $ lsnrctl stop LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 24-MAY-2020 22:25:24 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel7)(PORT=1521))) The command completed successfully |
오라클 관련 프로세스가 올라와있지 않은지 확인
1 2 3 4 5 | $ ps -ef | grep ora root 9020 8976 0 22:27 pts/0 00:00:00 su - oracle oracle 9021 9020 0 22:27 pts/0 00:00:00 -bash oracle 9069 9021 0 22:27 pts/0 00:00:00 ps -ef oracle 9070 9021 0 22:27 pts/0 00:00:00 grep --color=auto ora |
오라클 홈 경로로 이동 후 기존 파일 확인
1 2 3 4 5 6 7 8 9 10 11 | $ cd $ORACLE_HOME $ pwd /ORA19/app/oracle/product/19.0.0/db_1 $ ls addnode css demo hs jlib network ora_home.tar perl relnotes schagent.conf srvm apex ctx diagnostics install ldap nls oraInst.loc plsql root.sh sdk suptools assistants cv dmu instantclient lib odbc ord precomp root.sh.old slax ucp bin data drdaas inventory LINUX.X64_193000_db_home.zip olap ords QOpatch root.sh.old.1 sqldeveloper usm cfgtoollogs dbjava dv javavm log OPatch oss R root.sh.old.2 sqlj utl clone dbs env.ora jdbc md opmn oui racg root.sh.old.3 sqlpatch wwg crs deinstall has jdk mgw oracore owm rdbms runInstaller sqlplus xdk |
tar로 압축
1 2 3 | $ tar -cvf ora_home.tar * $ ls -al ora_home.tar -rw-r--r-- 1 oracle dba 10481694720 May 24 22:32 ora_home.tar |
새로운 오라클 홈 경로 생성 후 압축파일 이동
1 2 3 4 5 6 7 | $ mkdir -p /ORA19/app/oracle/product/19c $ mv ora_home.tar /ORA19/app/oracle/product/19c/ $ ls -al /ORA19/app/oracle/product/19c/ total 10236032 drwxr-xr-x 2 oracle dba 26 May 24 22:33 . drwxrwxr-x. 4 oracle oinstall 31 May 24 22:33 .. -rw-r--r-- 1 oracle dba 10481694720 May 24 22:32 ora_home.tar |
기존 경로 삭제
1 | $ rm -rf /ORA19/app/oracle/product/19.0.0/db_1 |
새로운 오라클 홈 경로로 이동후 압축해제
1 2 | $ cd /ORA19/app/oracle/product/19c $ tar -xvf ora_home.tar |
압축 해제 후 확인
1 2 3 4 5 6 7 8 9 10 | $ pwd /ORA19/app/oracle/product/19c $ ls addnode css demo hs jlib network ora_home.tar perl relnotes schagent.conf srvm apex ctx diagnostics install ldap nls oraInst.loc plsql root.sh sdk suptools assistants cv dmu instantclient lib odbc ord precomp root.sh.old slax ucp bin data drdaas inventory LINUX.X64_193000_db_home.zip olap ords QOpatch root.sh.old.1 sqldeveloper usm cfgtoollogs dbjava dv javavm log OPatch oss R root.sh.old.2 sqlj utl clone dbs env.ora jdbc md opmn oui racg root.sh.old.3 sqlpatch wwg crs deinstall has jdk mgw oracore owm rdbms runInstaller sqlplus xdk |
oracle 유저 홈으로 가서 .bash_profile 변경
1 2 3 4 5 6 7 | $ cd ~ $ vi .bash_profile 기존 : export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/db_1 변경 : export ORACLE_HOME=$ORACLE_BASE/product/19c $ . ./.bash_profile $ echo $ORACLE_HOME /ORA19/app/oracle/product/19c |
relink 명령 실행
1 2 3 4 5 | $ cd $ORACLE_HOME $ pwd /ORA19/app/oracle/product/19c $ relink all writing relink log to: /ORA19/app/oracle/product/19c/install/relinkActions2020-05-24_10-43-26PM.log |
서버 기동시 oracle 자동 시작하고 싶은 경우 oratab 수정
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 | $ cat /etc/oratab # # This file is used by ORACLE utilities. It is created by root.sh # and updated by either Database Configuration Assistant while creating # a database or ASM Configuration Assistant while creating ASM instance. # A colon, ':', is used as the field terminator. A new line terminates # the entry. Lines beginning with a pound sign, '#', are comments. # # Entries are of the form: # $ORACLE_SID:$ORACLE_HOME:<N|Y>: # # The first and second fields are the system identifier and home # directory of the database respectively. The third field indicates # to the dbstart utility that the database should , "Y", or should not, # "N", be brought up at system boot time. # # Multiple entries with the same $ORACLE_SID are not allowed. # # 기존 : ORCL19:/ORA19/app/oracle/product/19.0.0/db_1:N 변경 : ORCL19:/ORA19/app/oracle/product/19c:Y |
db 및 리스너 기동
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 | SQL> startup ORACLE instance started. Total System Global Area 1660940992 bytes Fixed Size 8897216 bytes Variable Size 956301312 bytes Database Buffers 687865856 bytes Redo Buffers 7876608 bytes Database mounted. Database opened. $ lsnrctl start LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 24-MAY-2020 22:44:27 Copyright (c) 1991, 2019, Oracle. All rights reserved. Starting /ORA19/app/oracle/product/19c/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 19.0.0.0.0 - Production System parameter file is /ORA19/app/oracle/product/19c/network/admin/listener.ora Log messages written to /ORA19/app/oracle/diag/tnslsnr/oel7/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel7)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel7)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 24-MAY-2020 22:44:28 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /ORA19/app/oracle/product/19c/network/admin/listener.ora Listener Log File /ORA19/app/oracle/diag/tnslsnr/oel7/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel7)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully |
db 도 정상적으로 기동되고 리스너도 정상적으로 작동함
하지만
root 계정에서 $ORACLE_HOME에 있는 root.sh 실행
1 2 | # sh root.sh root.sh: line 3: /ORA19/app/oracle/product/19.0.0/db_1/install/utl/rootmacro.sh: No such file or directory |
이전 경로를 바라보며 에러가 발생함
dbca 또는 netca 실행
1 2 3 4 | $ dbca /ORA19/app/oracle/product/19c/bin/dbca: line 135: /ORA19/app/oracle/product/19.0.0/db_1/bin/platform_common: No such file or directory $ netca /ORA19/app/oracle/product/19c/bin/netca: line 168: /ORA19/app/oracle/product/19.0.0/db_1/bin/platform_common: No such file or directory |
이전 경로를 바라보며 에러가 발생함
해결 방법
db 및 리스너 중지
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | SQL> shutdown immediate lsnrctl stop Database closed. Database dismounted. ORACLE instance shut down. $ lsnrctl stop LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 24-MAY-2020 22:52:11 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel7)(PORT=1521))) The command completed successfully |
oraInventory 경로 파일 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | $ cat /ORA19/app/oraInventory/ContentsXML/inventory.xml <?xml version="1.0" standalone="yes" ?> <!-- Copyright (c) 1999, 2020, Oracle and/or its affiliates. All rights reserved. --> <!-- Do not modify the contents of this file by hand. --> <INVENTORY> <VERSION_INFO> <SAVED_WITH>12.2.0.7.0</SAVED_WITH> <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER> </VERSION_INFO> <HOME_LIST> <HOME NAME="OraDB19Home1" LOC="/ORA19/app/oracle/product/19.0.0/db_1" TYPE="O" IDX="1"/> </HOME_LIST> <COMPOSITEHOME_LIST> </COMPOSITEHOME_LIST> </INVENTORY> |
이전 엔진경로로 잡혀있음
해당 내용 inventory에서 삭제
1 2 3 4 5 6 7 8 9 10 | $ cd $ORACLE_HOME/oui/bin $ ./detachHome.sh -silent -local -invPtrLoc $ORACLE_HOME/oraInst.loc ./detachHome.sh: line 5: cd: /ORA19/app/oracle/product/19.0.0/db_1/oui/bin: No such file or directory Starting Oracle Universal Installer... Checking swap space: must be greater than 500 MB. Actual 3815 MB Passed The inventory pointer is located at /ORA19/app/oracle/product/19c/oraInst.loc You can find the log of this install session at: /ORA19/app/oraInventory/logs/DetachHome2020-05-24_10-54-56PM.log 'DetachHome' was successful. |
3번 째 줄에서 파일을 못찾는다는 에러가 발생하지만 10번 째 줄에서 성공메세지가 나옴
oraInventory 경로 파일 재확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | $ cat /ORA19/app/oraInventory/ContentsXML/inventory.xml <?xml version="1.0" standalone="yes" ?> <!-- Copyright (c) 1999, 2020, Oracle and/or its affiliates. All rights reserved. --> <!-- Do not modify the contents of this file by hand. --> <INVENTORY> <VERSION_INFO> <SAVED_WITH>12.2.0.7.0</SAVED_WITH> <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER> </VERSION_INFO> <HOME_LIST> </HOME_LIST> <COMPOSITEHOME_LIST> </COMPOSITEHOME_LIST> </INVENTORY> |
이전 엔진경로가 제거됨
엔진 경로 변경(single 노드용)
ORACLE_BASE 경로 및 ORACLE_HOME 경로 확인 후 perl clone.pl 구문 실행
1 2 3 4 5 6 | $ echo $ORACLE_BASE /ORA19/app/oracle $ echo $ORACLE_HOME /ORA19/app/oracle/product/19c $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/clone/bin/clone.pl ORACLE_BASE=$ORACLE_BASE ORACLE_HOME=$ORACLE_HOME OSDBA_GROUP=dba -defaultHomeName |
참고용 구문
실행 로그
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 56 57 58 59 | $ $ORACLE_HOME/perl/bin/perl clone.pl ORACLE_BASE="/ORA19/app/oracle" ORACLE_HOME="/ORA19/app/oracle/product/19c" OSDBA_GROUP=dba -defaultHomeName [INFO] [INS-32183] Use of clone.pl is deprecated in this release. Clone operation is equivalent to performing a Software Only installation from the image. You must use /ORA19/app/oracle/product/19c/runInstaller script available to perform the Software Only install. For more details on image based installation, refer to help documentation. Starting Oracle Universal Installer... You can find the log of this install session at: /ORA19/app/oraInventory/logs/cloneActions2020-05-24_11-02-34PM.log .................................................. 5% Done. .................................................. 10% Done. .................................................. 15% Done. .................................................. 20% Done. .................................................. 25% Done. .................................................. 30% Done. .................................................. 35% Done. .................................................. 40% Done. .................................................. 45% Done. .................................................. 50% Done. .................................................. 55% Done. .................................................. 60% Done. .................................................. 65% Done. .................................................. 70% Done. .................................................. 75% Done. .................................................. 80% Done. .................................................. 85% Done. .......... Copy files in progress. Copy files successful. Link binaries in progress. .......... Link binaries successful. Setup files in progress. .......... Setup files successful. Setup Inventory in progress. Setup Inventory successful. .......... Finish Setup successful. The cloning of OraHome1 was successful. Please check '/ORA19/app/oraInventory/logs/cloneActions2020-05-24_11-02-34PM.log' for more details. Setup Oracle Base in progress. Setup Oracle Base successful. .................................................. 95% Done. As a root user, execute the following script(s): 1. /ORA19/app/oracle/product/19c/root.sh .................................................. 100% Done. |
제일 아래 나오는 root.sh 쉘 root 계정으로 실행
1 2 | # /ORA19/app/oracle/product/19c/root.sh Check /ORA19/app/oracle/product/19c/install/root_oel7_2020-05-24_23-04-12-534179389.log for the output of root script |
oraInventory 경로 파일 재확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | $ cat /ORA19/app/oraInventory/ContentsXML/inventory.xml <?xml version="1.0" standalone="yes" ?> <!-- Copyright (c) 1999, 2020, Oracle and/or its affiliates. All rights reserved. --> <!-- Do not modify the contents of this file by hand. --> <INVENTORY> <VERSION_INFO> <SAVED_WITH>12.2.0.7.0</SAVED_WITH> <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER> </VERSION_INFO> <HOME_LIST> <HOME NAME="OraHome1" LOC="/ORA19/app/oracle/product/19c" TYPE="O" IDX="1"/> </HOME_LIST> <COMPOSITEHOME_LIST> </COMPOSITEHOME_LIST> </INVENTORY> |
정상적으로 변경된 엔진 경로가 나옴
db 및 리스너 기동
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 | SQL> startup ORACLE instance started. Total System Global Area 1660940992 bytes Fixed Size 8897216 bytes Variable Size 956301312 bytes Database Buffers 687865856 bytes Redo Buffers 7876608 bytes Database mounted. Database opened. $ lsnrctl start LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 24-MAY-2020 23:04:46 Copyright (c) 1991, 2019, Oracle. All rights reserved. Starting /ORA19/app/oracle/product/19c/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 19.0.0.0.0 - Production System parameter file is /ORA19/app/oracle/product/19c/network/admin/listener.ora Log messages written to /ORA19/app/oracle/diag/tnslsnr/oel7/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel7)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel7)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 24-MAY-2020 23:04:47 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /ORA19/app/oracle/product/19c/network/admin/listener.ora Listener Log File /ORA19/app/oracle/diag/tnslsnr/oel7/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel7)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully |
정상적으로 실행됨
dbca 실행 테스트
정상적으로 실행됨
하지만 이 방법은 perl clone.pl 실행 시 제일 상단에 나온 메세지를 보면 알수 있듯이
oracle 19c에서 더 이상 사용되지 않으며 향후 릴리스에서 제거 될 수 있는 명령임
홈경로 변경 시 runInstaller 을 사용하라고 나와있음
1 2 | [INFO] [INS-32183] Use of clone.pl is deprecated in this release. Clone operation is equivalent to performing a Software Only installation from the image. You must use /ORA19/app/oracle/product/19c/runInstaller script available to perform the Software Only install. For more details on image based installation, refer to help documentation. |
아래는 runInstaller 을 이용한 오라클 홈경로(엔진경로) 변경 방법을 설명함
방법 : runInstaller 을 이용한 오라클 홈경로(엔진경로) 변경
기존 경로 : /ORA19/app/oracle/product/19c
변경 경로 : /ORA19/app/oracle/product/19.3
db 및 리스너 종료
1 2 3 4 5 6 7 8 9 10 11 12 13 | SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. $ lsnrctl stop LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 24-MAY-2020 23:14:34 Copyright (c) 1991, 2019, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel7)(PORT=1521))) The command completed successfully |
오라클 관련 프로세스가 올라와있지 않은지 확인
1 2 3 4 5 | $ ps -ef | grep ora root 9020 8976 0 22:27 pts/0 00:00:00 su - oracle oracle 9021 9020 0 22:27 pts/0 00:00:00 -bash oracle 9069 9021 0 22:27 pts/0 00:00:00 ps -ef oracle 9070 9021 0 22:27 pts/0 00:00:00 grep --color=auto ora |
오라클 홈 경로로 이동 후 기존 파일 확인
1 2 3 4 5 6 7 8 9 10 11 | $ cd $ORACLE_HOME $ pwd /ORA19/app/oracle/product/19c $ ls addnode css demo hs jlib network ora_home.tar perl relnotes schagent.conf srvm apex ctx diagnostics install ldap nls oraInst.loc plsql root.sh sdk suptools assistants cv dmu instantclient lib odbc ord precomp root.sh.old slax ucp bin data drdaas inventory LINUX.X64_193000_db_home.zip olap ords QOpatch root.sh.old.1 sqldeveloper usm cfgtoollogs dbjava dv javavm log OPatch oss R root.sh.old.2 sqlj utl clone dbs env.ora jdbc md opmn oui racg root.sh.old.3 sqlpatch wwg crs deinstall has jdk mgw oracore owm rdbms runInstaller sqlplus xdk |
tar로 압축
1 2 3 | $ tar -cvf ora_home2.tar * $ ls -al ora_home2.tar -rw-r--r-- 1 oracle dba 10499921920 May 24 23:18 ora_home2.tar |
새로운 오라클 홈 경로 생성 후 압축파일 이동
1 2 3 4 5 6 7 | $ mkdir -p /ORA19/app/oracle/product/19.3 $ mv ora_home2.tar /ORA19/app/oracle/product/19.3/ $ ls -al /ORA19/app/oracle/product/19.3/ total 10253832 drwxr-xr-x 2 oracle dba 27 May 24 23:19 . drwxrwxr-x. 5 oracle oinstall 43 May 24 23:19 .. -rw-r--r-- 1 oracle dba 10499921920 May 24 23:18 ora_home2.tar |
기존 경로 삭제
1 | $ rm -rf /ORA19/app/oracle/product/19c |
새로운 오라클 홈 경로로 이동후 압축해제
1 2 | $ cd /ORA19/app/oracle/product/19.3 $ tar -xvf ora_home2.tar |
압축 해제 후 확인
1 2 3 4 5 6 7 8 9 10 | $ pwd /ORA19/app/oracle/product/19.3 $ ls addnode css demo hs jlib network ora_home.tar perl relnotes schagent.conf srvm apex ctx diagnostics install ldap nls oraInst.loc plsql root.sh sdk suptools assistants cv dmu instantclient lib odbc ord precomp root.sh.old slax ucp bin data drdaas inventory LINUX.X64_193000_db_home.zip olap ords QOpatch root.sh.old.1 sqldeveloper usm cfgtoollogs dbjava dv javavm log OPatch oss R root.sh.old.2 sqlj utl clone dbs env.ora jdbc md opmn oui racg root.sh.old.3 sqlpatch wwg crs deinstall has jdk mgw oracore owm rdbms runInstaller sqlplus xdk |
oracle 유저 홈으로 가서 .bash_profile 변경
1 2 3 4 5 6 7 | $ cd ~ $ vi .bash_profile 기존 : export ORACLE_HOME=$ORACLE_BASE/product/19c 변경 : export ORACLE_HOME=$ORACLE_BASE/product/19.3 $ . ./.bash_profile $ echo $ORACLE_HOME /ORA19/app/oracle/product/19.3 |
오라클 홈경로(엔진경로) 로 이동 후 ./runInstaller 실행
1 2 | $ cd $ORACLE_HOME $ ./runInstaller |
Set Up Software Only 선택
Single instance database installation 선택
Enterprise Edition 선택
Oracle base 경로 선택
권한 선택
root.sh 쉘 자동 실행 비밀번호 입력
사전 요구사항 체크
Install 선택
db 엔진 구성중
root.sh 쉘 실행하겠냐는 메세지 Yes 선택
정상적으로 설치됨
oraInventory 경로 파일 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | $ cat /ORA19/app/oraInventory/ContentsXML/inventory.xml <?xml version="1.0" standalone="yes" ?> <!-- Copyright (c) 1999, 2020, Oracle and/or its affiliates. All rights reserved. --> <!-- Do not modify the contents of this file by hand. --> <INVENTORY> <VERSION_INFO> <SAVED_WITH>12.2.0.7.0</SAVED_WITH> <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER> </VERSION_INFO> <HOME_LIST> <HOME NAME="OraHome1" LOC="/ORA19/app/oracle/product/19c" TYPE="O" IDX="1"/> <HOME NAME="OraDB19Home1" LOC="/ORA19/app/oracle/product/19.3" TYPE="O" IDX="2"/> </HOME_LIST> <COMPOSITEHOME_LIST> </COMPOSITEHOME_LIST> </INVENTORY> |
이전 홈경로와 현재 홈경로가 같이 존재함
이전 홈경로 주석 처리 또는 삭제
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | $ vi /ORA19/app/oraInventory/ContentsXML/inventory.xml <?xml version="1.0" standalone="yes" ?> <!-- Copyright (c) 1999, 2020, Oracle and/or its affiliates. All rights reserved. --> <!-- Do not modify the contents of this file by hand. --> <INVENTORY> <VERSION_INFO> <SAVED_WITH>12.2.0.7.0</SAVED_WITH> <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER> </VERSION_INFO> <HOME_LIST> <!--HOME NAME="OraHome1" LOC="/ORA19/app/oracle/product/19c" TYPE="O" IDX="1"/--> <HOME NAME="OraDB19Home1" LOC="/ORA19/app/oracle/product/19.3" TYPE="O" IDX="2"/> </HOME_LIST> <COMPOSITEHOME_LIST> </COMPOSITEHOME_LIST> </INVENTORY> |
서버 기동시 oracle 자동 시작하고 싶은 경우 oratab 수정
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 | $ cat /etc/oratab # # This file is used by ORACLE utilities. It is created by root.sh # and updated by either Database Configuration Assistant while creating # a database or ASM Configuration Assistant while creating ASM instance. # A colon, ':', is used as the field terminator. A new line terminates # the entry. Lines beginning with a pound sign, '#', are comments. # # Entries are of the form: # $ORACLE_SID:$ORACLE_HOME:<N|Y>: # # The first and second fields are the system identifier and home # directory of the database respectively. The third field indicates # to the dbstart utility that the database should , "Y", or should not, # "N", be brought up at system boot time. # # Multiple entries with the same $ORACLE_SID are not allowed. # # 기존 : ORCL19:/ORA19/app/oracle/product/19c:Y 변경 : ORCL19:/ORA19/app/oracle/product/19.3:Y |
db 및 리스너 기동
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 | SQL> startup ORACLE instance started. Total System Global Area 1660940992 bytes Fixed Size 8897216 bytes Variable Size 956301312 bytes Database Buffers 687865856 bytes Redo Buffers 7876608 bytes Database mounted. Database opened. $ lsnrctl start LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 24-MAY-2020 23:29:07 Copyright (c) 1991, 2019, Oracle. All rights reserved. Starting /ORA19/app/oracle/product/19.3/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 19.0.0.0.0 - Production System parameter file is /ORA19/app/oracle/product/19.3/network/admin/listener.ora Log messages written to /ORA19/app/oracle/diag/tnslsnr/oel7/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel7)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel7)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 24-MAY-2020 23:29:07 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /ORA19/app/oracle/product/19.3/network/admin/listener.ora Listener Log File /ORA19/app/oracle/diag/tnslsnr/oel7/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel7)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully |
정상기동됨
dbca 실행 테스트
정상적으로 실행됨
참조 :
https://m.blog.naver.com/yoonono/220572215590
https://m.blog.naver.com/hanajava/221024623378
https://docs.oracle.com/en/database/oracle/oracle-database/19/ssdbi/cloning-an-oracle-home.html#GUID-494E59C3-C381-4A35-8ABE-F6E5DBF29032'ORACLE > Admin' 카테고리의 다른 글
| 오라클 19c 홈경로(엔진경로) 변경 후 기동시 alert log (0) | 2020.05.31 |
|---|---|
| 오라클 19c 컴포넌트 설치시 OPEN 되는 유저 (0) | 2020.05.27 |
| 오라클 리스너 패스워드 분실시 조치 방법 (0) | 2020.05.22 |
| 오라클 리스너 패스워드 설정 방법 (0) | 2020.05.22 |
| 오라클 설치 이후 uid, gid 및 권한 변경 (4) | 2020.05.13 |