1.ASMCA 실행
2. 삭제 할 DISKGROUP DATA1 선택 후 마운트 해제
3.DATA1 dismounted 확인
4. 레이블 삭제 및 지우기 선택
5.확인
6. 삭제 완료
7. crs 상태 확인 - 더이상 DATA1 볼륨 그룹은 보이지 않는다.
| ORACLE ASM DISK 삭제(DROP) 정리 (0) | 2023.06.08 |
|---|---|
| oracle restart 기동 절차 (0) | 2023.06.02 |
| 오라클 asm disk 그룹 추가 시 설정 ASM AFD (0) | 2023.05.25 |
| ORACLE SEHA 인스턴스 이동 (0) | 2022.09.15 |
| ORACLE SEHA LISTENER설정 및 상태 체크 (0) | 2022.09.15 |
root유저로 실행
### 경로 설정
export ORACLE_HOME=/u01/app/oracle/19c/grid
export ORACLE_BASE=/tmp
$ORACLE_HOME/bin/asmcmd afd_label RDATA1 /dev/sdf --migrate
$ORACLE_HOME/bin/asmcmd afd_label RDATA2 /dev/sdg --migrate
$ORACLE_HOME/bin/asmcmd afd_label RDATA3 /dev/sdh --migrate
$ORACLE_HOME/bin/asmcmd afd_label RFRA1 /dev/sdi --migrate
$ORACLE_HOME/bin/asmcmd afd_lslbl /dev/sdf
$ORACLE_HOME/bin/asmcmd afd_lslbl /dev/sdg
$ORACLE_HOME/bin/asmcmd afd_lslbl /dev/sdh
$ORACLE_HOME/bin/asmcmd afd_lslbl /dev/sdi
grid 유저로 asmca 실행 후 그룹 추가
[grid@+ASM ~]$
| oracle restart 기동 절차 (0) | 2023.06.02 |
|---|---|
| ORACLE ASM DISKGROUP 삭제 (0) | 2023.05.25 |
| ORACLE SEHA 인스턴스 이동 (0) | 2022.09.15 |
| ORACLE SEHA LISTENER설정 및 상태 체크 (0) | 2022.09.15 |
| RAC DB삭제 (0) | 2022.05.22 |
오라클 그리드 인프라스트럭쳐 설치하고 DBT-05801 에러 발생
DBT-05801 오라클 리스타트 설치시에 asm 볼륨이 안보일 때
나의 원인
원인
chmod 775 /u01 -R
그리드 와 오라클 의 oracle 파일의 퍼미션인 775로 변경 되서 발생
chmod 6751 oracle
반드시 $ORACLE_HOME/bin/oracle 파일과 $GRID_HOME/bin/oracle 파일 모두 6751 퍼미션을 줘야 된다.
| ORA-65096: invalid common user or role name (0) | 2023.06.08 |
|---|---|
| oracle ora-15032 ora-15260 (0) | 2023.06.08 |
| linux 7버전에 oracle 11g 설치시 'agent nmhs' 관련 에러 발생 (0) | 2022.04.11 |
| 오라클 ora-48913 (0) | 2018.12.31 |
| ORA-39125 expdp 중 오류 (0) | 2018.10.16 |
RAC TO SINGLE 복제 목적지 에서 실행
[oracle@aracdb aracdb]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.219.201 ora12c
### Public
192.168.219.111 arac1
192.168.219.113 arac2
### Private
192.168.0.111 arac1-priv
192.168.0.112 arac2-priv
### Virtual
192.168.219.112 arac1-vip
192.168.219.114 arac2-vip
### DNS
192.168.219.115 arac-scan
source 서버에서 pwd파일 목적지 서버로 카피
scp $ORACLE_HOME/dbs/orapwaracdb1 ora12c:$ORACLE_HOME/dbs/orapwaracdb
-- 패스워드 파일이 없을 시에 실행 후 목적지 서버로 옮긴다
orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=oracle force=y format=12
파라미터 설정
*.audit_file_dest='/u01/app/oracle/admin/aracdb/adump'
*.audit_trail='db'
#*.cluster_database=true
*.compatible='12.2.0'
*.control_files='/oradata/aracdb/controlfile/control01.ctl','/oradata/aracdb/controlfile/control02.ctl'
*.db_block_size=8192
*.db_create_file_dest='/oradata/aracdb'
*.db_name='aracdb'
*.db_recovery_file_dest='/oradata/aracdb'
*.db_recovery_file_dest_size=10g
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=aracdbXDB)'
#family:dw_helper.instance_mode='read-only'
*.log_archive_format='%t_%s_%r.dbf'
*.nls_language='KOREAN'
*.nls_territory='KOREA'
*.open_cursors=300
*.pga_aggregate_target=1000m
*.processes=320
*.remote_login_passwordfile='exclusive'
*.sga_target=2998m
*.log_file_name_convert='+DATA','/oradata','+FRA','/oradata'
*.db_file_name_convert='+DATA','/oradata','+FRA','/oradata'
오라클 유저로 디렉토리 생성
/oradata/aracdb
/oradata/aracdb/onlinelog <<== 리두 로그 경로 안만들었더니 에러 발생
/u01/app/oracle/admin/aracdb/adump
/u01/app/oracle/diag/rdbms/aracdb/aracdb/trace
/u01/app/oracle/diag/rdbms/aracdb/aracdb/cdump
-- 목적지 복제용 리스너 구성
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ora12c)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = aracdb)
(ORACLE_HOME = /u01/app/oracle/product/12C/db_1)
)
)
목적지 NO MOUNT 모드 기동
SQL*Plus: Release 12.2.0.1.0 Production on Tue May 23 17:18:57 2023
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 3154116608 bytes
Fixed Size 8625656 bytes
Variable Size 788529672 bytes
Database Buffers 2348810240 bytes
Redo Buffers 8151040 bytes
SQL>
목적지
## tnsnames.ora
ARACDB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.219.112)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = aracdb)
)
)
aracdb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ora12c)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aracdb)
)
)
-- 리스너 기동
[oracle@aracdb admin]$ lsnrctl start
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 25-JAN-2024 16:31:24
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Starting /u01/app/oracle/product/12C/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/12C/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/ora12c/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora12c)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date 25-JAN-2024 16:31:24
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12C/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/ora12c/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora12c)(PORT=1521)))
Services Summary...
Service "aracdb" has 1 instance(s).
Instance "aracdb", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
-- 목적지에서 rman 접속 후 복제 명령어 실행
[oracle@aracdb admin]$ rman target sys/oracle@aracdb1 auxiliary sys/oracle@aracdb
Recovery Manager: Release 12.2.0.1.0 - Production on Thu Jan 25 16:31:34 2024
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: ARACDB (DBID=2943394426)
connected to auxiliary database: ARACDB (not mounted)
RMAN> DUPLICATE DATABASE TO aracdb
2> FROM ACTIVE DATABASE
3> NOFILENAMECHECK;
Starting Duplicate Db at 24/01/25
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=261 device type=DISK
current log archived
contents of Memory Script:
{
sql clone "create spfile from memory";
}
executing Memory Script
sql statement: create spfile from memory
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 3154116608 bytes
Fixed Size 8625656 bytes
Variable Size 788529672 bytes
Database Buffers 2348810240 bytes
Redo Buffers 8151040 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''ARACDB'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''aracdb'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
restore clone from service 'aracdb1' primary controlfile;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''ARACDB'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''aracdb'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 3154116608 bytes
Fixed Size 8625656 bytes
Variable Size 788529672 bytes
Database Buffers 2348810240 bytes
Redo Buffers 8151040 bytes
Starting restore at 24/01/25
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=135 device type=DISK
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
output file name=/oradata/aracdb/controlfile/control01.ctl
output file name=/oradata/aracdb/controlfile/control02.ctl
Finished restore at 24/01/25
database mounted
contents of Memory Script:
{
set newname for datafile 1 to
"/oradata/aracdb/datafile/system.265.1136924533";
set newname for datafile 3 to
"/oradata/aracdb/datafile/sysaux.266.1136924577";
set newname for datafile 4 to
"/oradata/aracdb/datafile/undotbs1.267.1136924603";
set newname for datafile 5 to
"/oradata/aracdb/datafile/undotbs2.273.1136924729";
set newname for datafile 7 to
"/oradata/aracdb/datafile/users.268.1136924605";
restore
from nonsparse from service
'aracdb1' clone database
;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 24/01/25
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /oradata/aracdb/datafile/system.265.1136924533
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to /oradata/aracdb/datafile/sysaux.266.1136924577
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to /oradata/aracdb/datafile/undotbs1.267.1136924603
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to /oradata/aracdb/datafile/undotbs2.273.1136924729
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00007 to /oradata/aracdb/datafile/users.268.1136924605
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
Finished restore at 24/01/25
sql statement: alter system archive log current
current log archived
contents of Memory Script:
{
restore clone force from service 'aracdb1'
archivelog from scn 1728198;
switch clone datafile all;
}
executing Memory Script
Starting restore at 24/01/25
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=23
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service aracdb1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=24
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
Finished restore at 24/01/25
datafile 1 switched to datafile copy
input datafile copy RECID=10 STAMP=1159202130 file name=/oradata/aracdb/datafile/system.265.1136924533
datafile 3 switched to datafile copy
input datafile copy RECID=11 STAMP=1159202130 file name=/oradata/aracdb/datafile/sysaux.266.1136924577
datafile 4 switched to datafile copy
input datafile copy RECID=12 STAMP=1159202130 file name=/oradata/aracdb/datafile/undotbs1.267.1136924603
datafile 5 switched to datafile copy
input datafile copy RECID=13 STAMP=1159202130 file name=/oradata/aracdb/datafile/undotbs2.273.1136924729
datafile 7 switched to datafile copy
input datafile copy RECID=14 STAMP=1159202130 file name=/oradata/aracdb/datafile/users.268.1136924605
contents of Memory Script:
{
set until scn 1728333;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 24/01/25
using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 23 is already on disk as file /oradata/aracdb/ARACDB/archivelog/2024_01_25/o1_mf_1_23_lv43szth_.arc
archived log for thread 1 with sequence 24 is already on disk as file /oradata/aracdb/ARACDB/archivelog/2024_01_25/o1_mf_1_24_lv43t18x_.arc
archived log file name=/oradata/aracdb/ARACDB/archivelog/2024_01_25/o1_mf_1_23_lv43szth_.arc thread=1 sequence=23
archived log file name=/oradata/aracdb/ARACDB/archivelog/2024_01_25/o1_mf_1_24_lv43t18x_.arc thread=1 sequence=24
media recovery complete, elapsed time: 00:00:01
Finished recover at 24/01/25
Oracle instance started
Total System Global Area 3154116608 bytes
Fixed Size 8625656 bytes
Variable Size 788529672 bytes
Database Buffers 2348810240 bytes
Redo Buffers 8151040 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''ARACDB'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
}
executing Memory Script
sql statement: alter system set db_name = ''ARACDB'' comment= ''Reset to original value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance started
Total System Global Area 3154116608 bytes
Fixed Size 8625656 bytes
Variable Size 788529672 bytes
Database Buffers 2348810240 bytes
Redo Buffers 8151040 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ARACDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/oradata/aracdb/onlinelog/group_1.260.1136924673', '/oradata/aracdb/onlinelog/group_1.270.1136924671' ) SIZE 200 M REUSE,
GROUP 2 ( '/oradata/aracdb/onlinelog/group_2.261.1136924673', '/oradata/aracdb/onlinelog/group_2.271.1136924671' ) SIZE 200 M REUSE
DATAFILE
'/oradata/aracdb/datafile/system.265.1136924533'
CHARACTER SET AL32UTF8
sql statement: ALTER DATABASE ADD LOGFILE
INSTANCE 'i2'
GROUP 3 ( '/oradata/aracdb/onlinelog/group_3.274.1136924835', '/oradata/aracdb/onlinelog/group_3.262.1136924835' ) SIZE 200 M REUSE,
GROUP 4 ( '/oradata/aracdb/onlinelog/group_4.275.1136924837', '/oradata/aracdb/onlinelog/group_4.263.1136924837' ) SIZE 200 M REUSE
contents of Memory Script:
{
set newname for tempfile 1 to
"/oradata/aracdb/tempfile/temp.272.1136924683";
switch clone tempfile all;
catalog clone datafilecopy "/oradata/aracdb/datafile/sysaux.266.1136924577",
"/oradata/aracdb/datafile/undotbs1.267.1136924603",
"/oradata/aracdb/datafile/undotbs2.273.1136924729",
"/oradata/aracdb/datafile/users.268.1136924605";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /oradata/aracdb/tempfile/temp.272.1136924683 in control file
cataloged datafile copy
datafile copy file name=/oradata/aracdb/datafile/sysaux.266.1136924577 RECID=1 STAMP=1159202165
cataloged datafile copy
datafile copy file name=/oradata/aracdb/datafile/undotbs1.267.1136924603 RECID=2 STAMP=1159202165
cataloged datafile copy
datafile copy file name=/oradata/aracdb/datafile/undotbs2.273.1136924729 RECID=3 STAMP=1159202165
cataloged datafile copy
datafile copy file name=/oradata/aracdb/datafile/users.268.1136924605 RECID=4 STAMP=1159202165
datafile 3 switched to datafile copy
input datafile copy RECID=1 STAMP=1159202165 file name=/oradata/aracdb/datafile/sysaux.266.1136924577
datafile 4 switched to datafile copy
input datafile copy RECID=2 STAMP=1159202165 file name=/oradata/aracdb/datafile/undotbs1.267.1136924603
datafile 5 switched to datafile copy
input datafile copy RECID=3 STAMP=1159202165 file name=/oradata/aracdb/datafile/undotbs2.273.1136924729
datafile 7 switched to datafile copy
input datafile copy RECID=4 STAMP=1159202165 file name=/oradata/aracdb/datafile/users.268.1136924605
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Cannot remove created server parameter file
Finished Duplicate Db at 24/01/25
RMAN>
접속 후 상태 확인
SQL*Plus: Release 12.2.0.1.0 Production on Thu Jan 25 16:37:44 2024
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
aracdb OPEN
##################################################################################
채널 여러개 할당
복제 시에 채널 개수 만큼 패러럴 하게 복제
ex) 채널 2개 할당
rman target sys/oracle@aracdb1 auxiliary sys/oracle@aracdb
run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate auxiliary channel stby1 type disk;
allocate auxiliary channel stby2 type disk;
duplicate database to aracdb from active database nofilenamecheck;
}
| 백업 되지 않는 datafile 삭제 (0) | 2024.02.14 |
|---|---|
| 오라클 duplicate (복제) 시에 에러 (0) | 2023.05.23 |
| RAC to clonedb(single) 복구 (2) | 2014.08.15 |
| clone DB를 이용한 incomplete recovery (0) | 2012.08.08 |
| 복구에 필요한 정보 보기 (0) | 2011.11.23 |
오라클 DB 리소스 정보가 1,2번 순서가 db 장애 이후에 바뀌어져 나올 때
리소스를 삭제하고 재 등록 하면 된다.
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.CRS.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.FRA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac2 STABLE
ora.qosmserver
1 ONLINE ONLINE rac2 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.racdb.db
1 ONLINE ONLINE rac2 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
2 ONLINE ONLINE rac1 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
DB 인스턴스가 순서가 바뀌어 나옴을 확인
db 정지
srvctl stop database -d racdb
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.CRS.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.FRA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac2 STABLE
ora.qosmserver
1 ONLINE ONLINE rac2 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.racdb.db
1 ONLINE OFFLINE Instance Shutdown,STABLE
2 ONLINE OFFLINE Instance Shutdown,STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
정지 확인
리소스 삭제
[racdb1:/home/oracle]> srvctl remove database -d racdb
racdb 데이터베이스를 제거하겠습니까? (y/[n]) y
삭제 완료
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.CRS.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.FRA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac2 STABLE
ora.qosmserver
1 ONLINE ONLINE rac2 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
DB 정보 나오지 않음
DB 리소스 등록
[racdb1:/home/oracle]> srvctl add database -d racdb -oraclehome /u01/app/oracle/product/19c/db_1
인스턴스 리소스 등록
[racdb1:/home/oracle]> srvctl add instance -db racdb -instance racdb1 -node rac1
[racdb1:/home/oracle]> srvctl add instance -db racdb -instance racdb2 -node rac2
[racdb1:/home/oracle]> srvctl start database -d racdb
PRCR-1079 : ora.racdb.db 리소스 시작을 실패했습니다.
CRS-5017: The resource action "ora.racdb.db start" encountered the following error:
ORA-01078: failure in processing system parameters
LRM-00109: '/u01/app/oracle/product/19c/db_1/dbs/initracdb1.ora' ������������ ��������� ��� ��� ������������
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/rac1/crs/trace/crsd_oraagent_oracle.trc".
CRS-5017: The resource action "ora.racdb.db start" encountered the following error:
ORA-01078: failure in processing system parameters
LRM-00109: '/u01/app/oracle/product/19c/db_1/dbs/initracdb2.ora' ������������ ��������� ��� ��� ������������
. For details refer to "(:CLSN00107:)" in "/u01/app/oracle/diag/crs/rac2/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.racdb.db' on 'rac2' failed
CRS-2632: There are no more servers to try to place resource 'ora.racdb.db' on that would satisfy its placement policy
CRS-2674: Start of 'ora.racdb.db' on 'rac1' failed
혹시 라도 기동 실패시에 1,2번 노드에서 각 각 오라클 홈 밑에 dbs 경로에 spfile 경로를 지정해 주면 된다.
파라미터 파일 을 못 찾아서 나는 에러
[racdb1:/u01/app/oracle/product/19c/db_1/dbs]> vi initracdb1.ora
spfile='+data/racdb/parameterfile/spfile.274.1093539721'
2번 서버
[racdb2:/u01/app/oracle/product/19c/db_1/dbs]> vi initracdb2.ora
spfile='+data/racdb/parameterfile/spfile.274.1093539721'
정상 적으로 기동 완료
[racdb1:/home/oracle]> srvctl start database -d racdb
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.CRS.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.FRA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac1 STABLE
ora.qosmserver
1 ONLINE ONLINE rac1 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.racdb.db
1 ONLINE ONLINE rac1 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
2 ONLINE ONLINE rac2 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
ora.scan1.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac1 STABLE
--------------------------------------------------------------------------------
정상 확인
| 오라클 RAC MGMT 정지 및 비활성화,활성화 (0) | 2024.09.26 |
|---|---|
| ORACLE RAC DATABASE RESOURCE 삭제 (0) | 2023.03.06 |
| RAC 리소스 상태 확인 명령어 변경 (0) | 2023.03.06 |
| rac 리소스 재등록 (0) | 2019.10.08 |
| oracle rac to single (0) | 2016.06.10 |
RAC에서 DB 인스턴스 종료 후
ORACLE RAC DATABASE RESOURCE 삭제
[racdb1:/home/oracle]> srvctl remove database -d racdb
racdb 데이터베이스를 제거하겠습니까? (y/[n]) y
하면
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.CRS.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.FRA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac2 STABLE
ora.qosmserver
1 ONLINE ONLINE rac2 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.racdb.db
1 OFFLINE OFFLINE Instance Shutdown,STABLE
2 OFFLINE OFFLINE Instance Shutdown,STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
삭제 후
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.CRS.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.FRA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac2 STABLE
ora.qosmserver
1 ONLINE ONLINE rac2 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
RACDB 리소스 삭제 확인
| 오라클 RAC MGMT 정지 및 비활성화,활성화 (0) | 2024.09.26 |
|---|---|
| RAC 장애 후 인스턴스 리소스 순서 이상 할 때 (0) | 2023.03.06 |
| RAC 리소스 상태 확인 명령어 변경 (0) | 2023.03.06 |
| rac 리소스 재등록 (0) | 2019.10.08 |
| oracle rac to single (0) | 2016.06.10 |
기존 명령어
crs_stat -p
12C 이후 명령어 변경
[root@rac2 bin]# crsctl status resource
NAME=ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
TYPE=ora.asm_listener.type
TARGET=ONLINE , ONLINE , ONLINE
STATE=ONLINE on rac1, ONLINE on rac2, OFFLINE
NAME=ora.CRS.dg(ora.asmgroup)
TYPE=ora.diskgroup.type
TARGET=ONLINE , ONLINE , OFFLINE
STATE=ONLINE on rac1, ONLINE on rac2, OFFLINE
NAME=ora.DATA.dg(ora.asmgroup)
TYPE=ora.diskgroup.type
TARGET=ONLINE , ONLINE , OFFLINE
STATE=ONLINE on rac1, ONLINE on rac2, OFFLINE
NAME=ora.FRA.dg(ora.asmgroup)
TYPE=ora.diskgroup.type
TARGET=ONLINE , ONLINE , OFFLINE
STATE=ONLINE on rac1, ONLINE on rac2, OFFLINE
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE , ONLINE
STATE=ONLINE on rac1, ONLINE on rac2
NAME=ora.LISTENER_SCAN1.lsnr
TYPE=ora.scan_listener.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.LISTENER_SCAN2.lsnr
TYPE=ora.scan_listener.type
TARGET=ONLINE
STATE=ONLINE on rac2
NAME=ora.LISTENER_SCAN3.lsnr
TYPE=ora.scan_listener.type
TARGET=ONLINE
STATE=ONLINE on rac2
NAME=ora.asm(ora.asmgroup)
TYPE=ora.asm.type
TARGET=ONLINE , ONLINE , OFFLINE
STATE=ONLINE on rac1, ONLINE on rac2, OFFLINE
NAME=ora.asmnet1.asmnetwork(ora.asmgroup)
TYPE=ora.asm_network.type
TARGET=ONLINE , ONLINE , OFFLINE
STATE=ONLINE on rac1, ONLINE on rac2, OFFLINE
NAME=ora.chad
TYPE=ora.chad.type
TARGET=ONLINE , ONLINE
STATE=ONLINE on rac1, ONLINE on rac2
NAME=ora.cvu
TYPE=ora.cvu.type
TARGET=ONLINE
STATE=ONLINE on rac2
NAME=ora.net1.network
TYPE=ora.network.type
TARGET=ONLINE , ONLINE
STATE=ONLINE on rac1, ONLINE on rac2
NAME=ora.ons
TYPE=ora.ons.type
TARGET=ONLINE , ONLINE
STATE=ONLINE on rac1, ONLINE on rac2
NAME=ora.qosmserver
TYPE=ora.qosmserver.type
TARGET=ONLINE
STATE=ONLINE on rac2
NAME=ora.rac1.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.rac2.vip
TYPE=ora.cluster_vip_net1.type
TARGET=ONLINE
STATE=ONLINE on rac2
NAME=ora.racdb.db
TYPE=ora.database.type
TARGET=ONLINE , ONLINE
STATE=OFFLINE, OFFLINE
NAME=ora.scan1.vip
TYPE=ora.scan_vip.type
TARGET=ONLINE
STATE=ONLINE on rac1
NAME=ora.scan2.vip
TYPE=ora.scan_vip.type
TARGET=ONLINE
STATE=ONLINE on rac2
NAME=ora.scan3.vip
TYPE=ora.scan_vip.type
TARGET=ONLINE
STATE=ONLINE on rac2
| RAC 장애 후 인스턴스 리소스 순서 이상 할 때 (0) | 2023.03.06 |
|---|---|
| ORACLE RAC DATABASE RESOURCE 삭제 (0) | 2023.03.06 |
| rac 리소스 재등록 (0) | 2019.10.08 |
| oracle rac to single (0) | 2016.06.10 |
| IBM General Parallel File System (GPFS) 3.2-3.5, 4.1 and Oracle RAC (문서 ID 1376369.1) (0) | 2015.09.06 |
오라클 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
===================================================================
전환 완료
| 오라클 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 |
상태 체크
[oracle@seha admin]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISA.lsnr
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.chad
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.net1.network
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.ons
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.proxy_advm
OFFLINE OFFLINE seha1 STABLE
OFFLINE OFFLINE seha2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE seha2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE seha1 Started,STABLE
2 ONLINE ONLINE seha2 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.cvu
1 ONLINE ONLINE seha1 STABLE
ora.qosmserver
1 ONLINE ONLINE seha1 STABLE
ora.scan1.vip
1 ONLINE ONLINE seha2 STABLE
ora.seha.db
1 ONLINE ONLINE seha1 Open,HOME=/u01/app/o
racle/product/19c,ST
ABLE
ora.seha1.vip
1 ONLINE ONLINE seha1 STABLE
ora.seha2.vip
1 ONLINE ONLINE seha2 STABLE
--------------------------------------------------------------------------------
2번 서버로 인스턴스 이동
[oracle@seha admin]$ srvctl relocate database -d seha -n seha2 -w 1 -v
[oracle@seha admin]$ srvctl relocate database -h
RAC One Node 데이터베이스의 온라인 재배치를 시작합니다.
사용법: srvctl relocate database -db <db_unique_name> {[-node <target>] [-timeout <timeout>] [-stopoption <stop_option>] | -abort [-revert]} [-drain_timeout <timeout>] [-verbose]
-db <db_unique_name> 재배치할 데이터베이스의 고유 이름
-node <target> 데이터베이스를 재배치할 대상 노드
-timeout <timeout> 온라인 재배치 시간 초과(분)
-abort 실패한 온라인 재배치 중단
-revert 관리자 관리 RAC One Node 데이터베이스의 후보 서버 목록에서 실패한 온라인 재배치 요청의 대상 노드 제거
-stopoption <stop_option> 인스턴스 실행을 위한 기본 종료 옵션 무효화(NORMAL만 허용됨)
-drain_timeout <drain_timeout> 초 단위로 지정된 서비스 비우기 시간 초과입니다.
-verbose 상세 정보 출력
-help 사용법 인쇄
옵션 설명
출처:https://hoing.io/archives/5280#relocate
-w 옵션을 기술 하지 않는다면 online relocation timeout : 30 이 적용 됩니다.
단위 는 분 이며 이 시간은 세션을 종료 하고 , 인스턴스를 migrate , 트랜잭션을 OPEN 하는 시간을 의미 합니다.
시간 안에 트랜젝션이 종료 되지 않는다면, shutdown abort 과 같은 일환으로 트랜젝션은 취소 가 되며, 세션은 사라지게 됩니다.
이런 시간에 대한 제한에 대해서 default 30분이 아닌 다른 시간으로 제한을 두고자 할 때 -w 옵션을 사용하게 됩니다.
보통의 경우 테스트 문서나 외국 문서들의 대부분이 -w 1 을 주며 시간의 범위는 1~720 분 까지 입니다.
[oracle@seha admin]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISA.lsnr
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.chad
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.net1.network
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.ons
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.proxy_advm
OFFLINE OFFLINE seha1 STABLE
OFFLINE OFFLINE seha2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE seha2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE seha1 Started,STABLE
2 ONLINE ONLINE seha2 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.cvu
1 ONLINE ONLINE seha1 STABLE
ora.qosmserver
1 ONLINE ONLINE seha1 STABLE
ora.scan1.vip
1 ONLINE ONLINE seha2 STABLE
ora.seha.db
1 ONLINE ONLINE seha2 Open,HOME=/u01/app/o
racle/product/19c,ST
ABLE
ora.seha1.vip
1 ONLINE ONLINE seha1 STABLE
ora.seha2.vip
1 ONLINE ONLINE seha2 STABLE
--------------------------------------------------------------------------------
1번 서버로 인스턴스 이동
srvctl relocate database -d seha -n seha1 -w 1 -v
[oracle@seha admin]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISA.lsnr
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.chad
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.net1.network
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.ons
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.proxy_advm
OFFLINE OFFLINE seha1 STABLE
OFFLINE OFFLINE seha2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE seha2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE seha1 Started,STABLE
2 ONLINE ONLINE seha2 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.cvu
1 ONLINE ONLINE seha1 STABLE
ora.qosmserver
1 ONLINE ONLINE seha1 STABLE
ora.scan1.vip
1 ONLINE ONLINE seha2 STABLE
ora.seha.db
1 ONLINE ONLINE seha1 Open,HOME=/u01/app/o
racle/product/19c,ST
ABLE
ora.seha1.vip
1 ONLINE ONLINE seha1 STABLE
ora.seha2.vip
1 ONLINE ONLINE seha2 STABLE
--------------------------------------------------------------------------------
| ORACLE ASM DISKGROUP 삭제 (0) | 2023.05.25 |
|---|---|
| 오라클 asm disk 그룹 추가 시 설정 ASM AFD (0) | 2023.05.25 |
| ORACLE SEHA LISTENER설정 및 상태 체크 (0) | 2022.09.15 |
| RAC DB삭제 (0) | 2022.05.22 |
| 오라클 메모리 튜닝 권고 (0) | 2022.05.22 |
/etc/hosts
### Public
192.168.219.141 seha1
192.168.219.143 seha2
### Private
192.168.56.41 seha1-priv
192.168.56.42 seha2-priv
### Virtual
192.168.219.192 seha1-vip
192.168.219.194 seha2-vip
### SCAN
192.168.219.147 seha-scan
[root@seha1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.chad
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.net1.network
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.ons
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.proxy_advm
OFFLINE OFFLINE seha1 STABLE
OFFLINE OFFLINE seha2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE seha2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE seha1 Started,STABLE
2 ONLINE ONLINE seha2 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.cvu
1 ONLINE ONLINE seha1 STABLE
ora.qosmserver
1 ONLINE ONLINE seha1 STABLE
ora.scan1.vip
1 ONLINE ONLINE seha2 STABLE
ora.seha.db
1 ONLINE ONLINE seha1 Open,HOME=/u01/app/o
racle/product/19c,ST
ABLE
ora.seha1.vip
1 ONLINE ONLINE seha1 STABLE
ora.seha2.vip
1 ONLINE ONLINE seha2 STABLE
--------------------------------------------------------------------------------
tnsnames.ora 등록
1번 서버 등록
lisa =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = seha1-vip)(PORT = 2555))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =seha)
)
)
2번 서버 등록
lisa =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = seha2-vip)(PORT = 2555))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =seha)
)
)
리스너 삭제 후 변경
srvctl stop listener
srvctl remove listener -l listener
리스너 생성 2555포트 사용
srvctl add listener -o /u01/app/grid -p 2555 -l lisa
리스너 기동
srvctl start listener -l lisa
상태 확인
[oracle@seha admin]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISA.lsnr
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.chad
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.net1.network
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.ons
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.proxy_advm
OFFLINE OFFLINE seha1 STABLE
OFFLINE OFFLINE seha2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE INTERMEDIATE seha1 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE seha1 Started,STABLE
2 ONLINE ONLINE seha2 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.cvu
1 ONLINE ONLINE seha1 STABLE
ora.qosmserver
1 ONLINE ONLINE seha1 STABLE
ora.scan1.vip
1 ONLINE ONLINE seha1 STABLE
ora.seha.db
1 ONLINE ONLINE seha1 Open,HOME=/u01/app/o
racle/product/19c,ST
ABLE
ora.seha1.vip
1 ONLINE ONLINE seha1 STABLE
ora.seha2.vip
1 ONLINE ONLINE seha2 STABLE
--------------------------------------------------------------------------------
[oracle@seha ~]$ sqlplus system/oracle@lisa
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 15 11:25:24 2022
Version 19.16.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Last Successful login time: Thu Sep 15 2022 10:58:22 +09:00
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
접속 실패 시 DB 인스턴스 재 기동
[oracle@seha admin]$ sqlplus scott/tiger@lisa
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 15 10:13:12 2022
Version 19.16.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
[oracle@seha admin]$ lsnrctl status lisa
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 15-SEP-2022 09:57:55
Copyright (c) 1991, 2022, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISA)))
STATUS of the LISTENER
------------------------
Alias LISA
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 15-SEP-2022 09:56:03
Uptime 0 days 0 hr. 1 min. 51 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/seha1/lisa/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISA)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.219.141)(PORT=2555)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.219.192)(PORT=2555)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
The command completed successfully
================================================
인스턴스 재 기동 후
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISA.lsnr
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.chad
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.net1.network
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.ons
ONLINE ONLINE seha1 STABLE
ONLINE ONLINE seha2 STABLE
ora.proxy_advm
OFFLINE OFFLINE seha1 STABLE
OFFLINE OFFLINE seha2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE seha2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE seha1 Started,STABLE
2 ONLINE ONLINE seha2 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE seha1 STABLE
2 ONLINE ONLINE seha2 STABLE
ora.cvu
1 ONLINE ONLINE seha1 STABLE
ora.qosmserver
1 ONLINE ONLINE seha1 STABLE
ora.scan1.vip
1 ONLINE ONLINE seha2 STABLE
ora.seha.db
1 ONLINE ONLINE seha1 Open,HOME=/u01/app/o
racle/product/19c,ST
ABLE
ora.seha1.vip
1 ONLINE ONLINE seha1 STABLE
ora.seha2.vip
1 ONLINE ONLINE seha2 STABLE
--------------------------------------------------------------------------------
[oracle@seha admin]$ lsnrctl status lisa
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 15-SEP-2022 09:58:31
Copyright (c) 1991, 2022, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISA)))
STATUS of the LISTENER
------------------------
Alias LISA
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 15-SEP-2022 09:56:03
Uptime 0 days 0 hr. 2 min. 27 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/seha1/lisa/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISA)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.219.141)(PORT=2555)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.219.192)(PORT=2555)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "seha" has 1 instance(s).
Instance "seha", status READY, has 1 handler(s) for this service...
Service "sehaXDB" has 1 instance(s).
Instance "seha", status READY, has 1 handler(s) for this service...
The command completed successfully
접속 확인
[oracle@seha admin]$ sqlplus system/oracle@lisa
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 15 11:38:28 2022
Version 19.16.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Last Successful login time: Thu Sep 15 2022 11:25:24 +09:00
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
SQL>
================================================
| 오라클 asm disk 그룹 추가 시 설정 ASM AFD (0) | 2023.05.25 |
|---|---|
| ORACLE SEHA 인스턴스 이동 (0) | 2022.09.15 |
| RAC DB삭제 (0) | 2022.05.22 |
| 오라클 메모리 튜닝 권고 (0) | 2022.05.22 |
| oracle ERROR: ORA-12547: TNS:lost contact (0) | 2018.08.08 |
|
