clua_services設定一問

[watermelonyu]

我安裝了一套9i RAC(tru64 5.1B,oracle 9.2.05)

兩個node 各起了一個listener 在1521 port

我在clua_services檔案裡面還沒加

OracleDB 1521/tcp in_multi,out_alias

但是sqlplus 用alias ip連進來的時候,卻還是可以連到DB

請問這樣對嗎?

為什麼alias沒有Indicates a service 1521 port,但是sqlplus 連alias ip確一樣可以連進DB,請問這樣正常嗎

[watermelonyu]

Hello Joey:



請問您的Oracle是否有用CAA控制啟動/結束...,

也就是說用caa_start/caa_stop/caa_relocate去

提供high availability. 還是單純用手動方式啟動.

Oracle是用Single instance還是Multiple instances?



請一併提供"netstat -an | grep 1521"的結果.

(for all of TruCluster members)



Best Regards

Danny

[watermelonyu]

我不是用CAA

SID=ora9i1 on A node

SID=ora9i2 on B node

this is a RAC DB

oracle db9i1> netstat -an | grep 1521

tcp 0 0 172.16.12.52.1521 172.16.12.54.1226 TIME_WAIT

tcp 0 0 *.1521 *.* LISTEN

####################################

oracle db9i2> netstat -na |grep 1521

tcp 0 0 172.16.12.53.1521 172.16.12.53.1107 TIME_WAIT

tcp 0 0 *.1521 *.* LISTEN

[watermelonyu]

Hello Joey:



請問172.16.12.52及172.16.12.53是network interface IP 還是alias IP? 其實一般network

applications,例如www(80 port), 即使不用定義

在/etc/services或/etc/clua_services也可以使用.



Best Regards

Danny

[watermelonyu]

172.16.12.52 and 172.16.12.53 is network interface IP

我在clua_services沒有將listener 1521 port 給加進來

我用sqlplus 連alias ip,結果也是可以連

[watermelonyu]

Hello Joey:



"tcp 0 0 *.1521 *.* LISTEN" means that any valid

IP addresses bound on your machine, such as

your interface IP or alias IP will receive the

socket connection to 1521 port, maybe, your

listener.ora can specify your desired service

IP, so your client can connect the desired

machine, I think you Oracle RAC will provide

high availability, and does it use the same

group of dbf files? so Node A and Node B can

access your database at the same time.



So far, if you just use default cluster alias

IP as client connection target, you could

find sometimes you are connected to wrong

machine, isn't it?



I am very sorry that I am not an expert of RAC,

would you be kindly to give simple description

of your RAC application?



Best Regards

Danny

[watermelonyu]

Hello Joey:



The following is a good reference guide for

Tru64 UNIX using Oracle 9i RAC:

http://otn.oracle.com/products/oracle9i/pdf/Oracle_9i_on_Tru64_UNIX.pdf



Best Regards

Danny

[watermelonyu]

node1:a800 ip is 172.16.12.52

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = a800)(PORT = 1521))

)

)

)



SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = db9i)

(SID_NAME = db9i1)

(ORACLE_HOME = /u01/app/oracle/product/9i)

)

)



node2:es47 ip is 172.16.13.53

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = es47)(PORT = 1521))

)

)

)



SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = db9i)

(SID_NAME = db9i2)

(ORACLE_HOME = /u01/app/oracle/product/9i)

)

)



我目前是用sqlplus use DEFAULTALIAS,也都可以正常連進來

[watermelonyu]

Hello Joey:



請問您用DEFAULTALIAS是否每次都能連上同一台

機器, 雖然是RAC, 但兩台機器的SID_NAME是不同的.

(GLOBAL_DBNAME是一樣, 所以研判是共用一份DB files

吧)





Best Regards

Danny

[watermelonyu]

yes,

it's the same datafile



Joey