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 -cvpf 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
|
새로운 오라클 홈 경로로 이동후 압축해제
(tar 해제시 본문에서는 oracle 유저로 해제했지만 root 유저로 해제하는것을 권장함(oradism등 소유자 문제))
|
1
2
|
$ cd /ORA19/app/oracle/product/19c
$ tar -xvpf 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
|
$ORACLE_HOME/perl/bin/perl clone.pl ORACLE_BASE="target_oracle_base" ORACLE_HOME="target_oracle_home"
OSDBA_GROUP=OSDBA_privileged_group OSOPER_GROUP=OSOPER_privileged_group -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 -cvpf 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
|
새로운 오라클 홈 경로로 이동후 압축해제
(tar 해제시 본문에서는 oracle 유저로 해제했지만 root 유저로 해제하는것을 권장함(oradism등 소유자 문제))
|
1
2
|
$ cd /ORA19/app/oracle/product/19.3
$ tar -xvpf 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
'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 |
