오라클 linux 8에 seha설치 후 전환 테스트 실패
PRKF-1421 : cannot relocate database "seha8"; invalid database type
[seha8:/home/oracle]> crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE seha8a STABLE
ONLINE ONLINE seha8b STABLE
ora.chad
ONLINE ONLINE seha8a STABLE
ONLINE ONLINE seha8b STABLE
ora.net1.network
ONLINE ONLINE seha8a STABLE
ONLINE ONLINE seha8b STABLE
ora.ons
ONLINE ONLINE seha8a STABLE
ONLINE ONLINE seha8b STABLE
ora.proxy_advm
OFFLINE OFFLINE seha8a STABLE
OFFLINE OFFLINE seha8b STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE seha8a STABLE
2 ONLINE ONLINE seha8b STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE seha8a STABLE
2 ONLINE ONLINE seha8b STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE seha8a STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE seha8a Started,STABLE
2 ONLINE ONLINE seha8b Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE seha8a STABLE
2 ONLINE ONLINE seha8b STABLE
ora.cvu
1 ONLINE ONLINE seha8a STABLE
ora.qosmserver
1 ONLINE ONLINE seha8a STABLE
ora.scan1.vip
1 ONLINE ONLINE seha8a STABLE
ora.seha8.db
1 ONLINE ONLINE seha8a Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
ora.seha8a.vip
1 ONLINE ONLINE seha8a STABLE
ora.seha8b.vip
1 ONLINE ONLINE seha8b STABLE
--------------------------------------------------------------------------------
relocate 2번째 노드로 전환 시킴
[seha8:/home/oracle]> srvctl relocate database -d seha8 -n seha8a -w 1 -v
PRKF-1421 : cannot relocate database "seha8"; invalid database type
설정 확인
[seha8:/home/oracle]> srvctl config database -db seha8
Database unique name: seha8
Database name: seha8
Oracle home: /u01/app/oracle/product/19c/db_1
Oracle user: oracle
Spfile: +DATA/SEHA8/PARAMETERFILE/spfile.267.1116773743
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: SINGLE
OSDBA group: dba
OSOPER group: dba
Database instance: seha8
Configured nodes: seha8a <<======2번 노드가 나오지 않음
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
2번 노드 등록
[seha8:/home/oracle]> srvctl modify database -db seha8 -node seha8a,seha8b
등록 확인
[seha8:/home/oracle]> srvctl config database -db seha8
Database unique name: seha8
Database name: seha8
Oracle home: /u01/app/oracle/product/19c/db_1
Oracle user: oracle
Spfile: +DATA/SEHA8/PARAMETERFILE/spfile.267.1116773743
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: SINGLE
OSDBA group: dba
OSOPER group: dba
Database instance: seha8
Configured nodes: seha8a,seha8b 2번 노드 추가 확인
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
서버 전환
[seha8:/home/oracle]> srvctl relocate database -d seha8 -n seha8b -w 1 -v
서버 전환 확인
[seha8:/home/oracle]> crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE seha8a STABLE
ONLINE ONLINE seha8b STABLE
ora.chad
ONLINE ONLINE seha8a STABLE
ONLINE ONLINE seha8b STABLE
ora.net1.network
ONLINE ONLINE seha8a STABLE
ONLINE ONLINE seha8b STABLE
ora.ons
ONLINE ONLINE seha8a STABLE
ONLINE ONLINE seha8b STABLE
ora.proxy_advm
OFFLINE OFFLINE seha8a STABLE
OFFLINE OFFLINE seha8b STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE seha8a STABLE
2 ONLINE ONLINE seha8b STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE seha8a STABLE
2 ONLINE ONLINE seha8b STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE seha8a STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE seha8a Started,STABLE
2 ONLINE ONLINE seha8b Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE seha8a STABLE
2 ONLINE ONLINE seha8b STABLE
ora.cvu
1 ONLINE ONLINE seha8a STABLE
ora.qosmserver
1 ONLINE ONLINE seha8a STABLE
ora.scan1.vip
1 ONLINE ONLINE seha8a STABLE
ora.seha8.db
1 ONLINE ONLINE seha8b Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
ora.seha8a.vip
1 ONLINE ONLINE seha8a STABLE
ora.seha8b.vip
1 ONLINE ONLINE seha8b STABLE
--------------------------------------------------------------------------------
원래 대로
[seha8:/home/oracle]> srvctl relocate database -d seha8 -n seha8a -w 1 -v
===================================================================
ora.seha8.db
1 ONLINE ONLINE seha8b Open,HOME=/u01/app/o
racle/product/19c/db
_1,STOPPING
ora.seha8a.vip
===================================================================
ora.seha8.db
1 ONLINE OFFLINE seha8a Instance Shutdown,ST
ARTING
===================================================================
ora.seha8.db
1 ONLINE ONLINE seha8a Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
===================================================================
전환 완료
'ORACLE > INSTALL' 카테고리의 다른 글
| 오라클 single adg 초기 설정 (1) (0) | 2023.06.14 |
|---|---|
| 오라클 single adg 네트워크 설정 (2) (0) | 2023.06.14 |
| 오라클 11G upgrade관련문서 (0) | 2013.10.29 |
| oracle silent install (0) | 2012.05.11 |
| [ Oracle - Admin ] Linux 커널 매게변수 및 Shell Limit (0) | 2012.01.10 |
