tech_memo/ORACLE
SQLでRAC構成インスタンスとステータスの確認 †
- GV$INSTANCEを見ればわかる
select inst_id, instance_number, instance_name, status, host_name from gv$instance;
- ちなみに、gv$sessionというグローバルビューもある
全RACインスタンスに接続しているセッション情報を取得 †
- gv$sessionというグローバルビューから確認可能
Document †
RAC ポリシーベース管理(11gR2) †
RAC間のインターコネクタのIP †
指定インスタンスに接続 †
インストール・セットアップ †
アンインストール †
RAC Performance †
RAC奮闘記 †
起動・停止 †
- サーバ再起動時にはまったこと。
- clusterwareがうまく動作しない(statusが見れない)。racserver1,racserver2のvipが起動していなかった。srvctlでracserver1とracserver2のvipを手動で起動するとうまくいった。
thin driver †
- SIDの前がRACかSingleかで、「/」か「:」になる
tnsnames.ora †
# tnsnames.ora Network Configuration File:
# Generated by Oracle configuration tools.
NB01 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hcs00c10)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = nba.npa.go.jp)
(INSTANCE_NAME = nb01)
)
)
NB02 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hcs00c11)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = nba.npa.go.jp)
(INSTANCE_NAME = nb02)
)
)
NB03 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hcs00i10)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = nb03.npa.go.jp)
(INSTANCE_NAME = nb03)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
NBA_RAC1_LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hcs00c10)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = hcs00c30)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = hcs00c11)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = hcs00c31)(PORT = 1522))
(FAILOVER = ON)
(LOAD_BALANCE = OFF)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = nba.npa.go.jp)
(FAILOVER_MODE =
(BACKUP = NBA_RAC2_LISTENER)(TYPE = SELECT)
(METHOD = BASIC)(RETRIES = 180)(delay = 3)
)
)
)
NBA_RAC2_LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hcs00c11)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = hcs00c31)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = hcs00c10)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = hcs00c30)(PORT = 1522))
(FAILOVER = ON)
(LOAD_BALANCE = OFF)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = nba.npa.go.jp)
(FAILOVER_MODE =
(BACKUP = NBA_RAC1_LISTENER)(TYPE = SELECT)
(METHOD = BASIC)(RETRIES = 180)(delay = 3)
)
)
)
Arch †
最新の20件
2023-01-26
2022-11-11
2022-03-02
2022-02-03
2021-11-18
2021-11-11
2021-10-27
2021-10-04
2021-09-30
2021-08-24
2021-04-01
2021-02-25
2020-08-13
2020-05-22
2020-04-16
2020-04-15
2020-03-23
2020-03-12
2020-02-27
今日の20件
- counter: 287
- today: 1
- yesterday: 0
- online: 2