oracle RAC问题，请高手指教？

cbird78

oracle 9i RAC ,双机并行，建库完毕，在笔记本上安装客户端,用sqlplus连接数据库，有时能连上，有时连不上，网络检测无误，三个地址全能ping通，无延时与丢包，不知是什么原因，数据库名叫highway，SID:hiway1,hiway2,我的配置文件如下：
这是listener.ora
# LISTENER.ORA.KSLDS1 Network Configuration File: /oracle/home/app/product/9.2.0/network/admin/listener.ora.kslds1
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = kslds1)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle/home/app/product/9.2.0)
      (PROGRAM = extproc)
     )
    (SID_DESC =
      (SID_NAME = hiway1)
      (ORACLE_HOME = /oracle/home/app/product/9.2.0)
    )
  )

这是tnsnames.ora
# TNSNAMES.ORA Network Configuration File: /oracle/home/app/product/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

HIWAY2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = kslds2)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = highway)
      (INSTANCE_NAME = hiway2)
    )
  )

HIWAY1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = kslds1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = highway)
      (INSTANCE_NAME = hiway1)
    )
  )

LISTENERS_HIGHWAY =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = kslds1)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = kslds2)(PORT = 1522))
  )

LISTENER_KSL2 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = kslds2)(PORT = 1522))


LISTENER_KSL1 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = kslds1)(PORT = 1521))


HIGHWAY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = kslds1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = kslds2)(PORT = 1522))
      (LOAD_BALANCE = yes)
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
      (SERVICE_NAME = highway)
    )
  )

LISTENER_HIWAY2 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = kslds2)(PORT = 1522))


LISTENER_HIWAY1 =
  (ADDRESS = (PROTOCOL = TCP)(HOST = kslds1)(PORT = 1521))


INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = kslds1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

cbird78

这是客户端的TNS文件
TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

HIGHWAY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.82.15)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.88.82.16)(PORT = 1522))
      (LOAD_BALANCE = on)
      )
    (CONNECT_DATA =
        (SERVICE_NAME = highway)
    )
  )

daniel_w

在群集的本地服务器上SQLPLUS呢？

txfy

你每次连接上后查询一下instance_id,或者instance_name看看是不是总是一个instance。另外os?linux,unix?

sshd

"有时能连上，有时连不上"

LOAD_BALANCE = on

you have client load balance turned on and that means the client connection will go to one of the node randomly.

to make it work you will need to carefully tell where the database instance will register themselves.

by default each instance will register itself at port 1521 on local machine.

for an instance to register itself to port other than 1521, or a remote listener, you will need to specify

local_listener
remote_listener

in the init.ora files for each of the instances.

sshd

here is what you need to consider:
                |------>;  listener a (1521) -------->; insyance a
client  --->;|                                            X
                |------>;  listener b (1521) -------->;  insyance b

on instance a you will need to set remote_listener  to point to
the listener b
and
on instance b you will need to set remote_listener  to point to
the listener a

if you do not use port 1521, them you will need to set local_listener  to point to the listener on the local machine.

chaoping

notepad /etc/hosts (winnt: c:\winnt\system32\etc\drivers\hosts)
add IP hostname mapping

zorrol

我碰到过，把防火墙调过后就好了。

cbird78

我的客户端上并未安装防火墙，服务器是AIX操作系统5.2，ML04，Oracle9.2已升级为9.2.0.4，重新建了数据库，错误依然如此，依照楼上版主的方法是不是在$ORALCE_BASE/admin/highway/pfile/init.ora文件中将两台机器的listener互指为remote,我这样做过不管用啊！我这样指对不对啊，有没有例子给小弟参照一下呢？不胜感激！

sshd

1) on HOSTA:

-------- init.ora-------
service_names = sales
instance_name = instA
local_listener = where2register
-------------------------

-------- tnsnames.ora -----
where2register =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = HOSTA)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = HOSTB)(PORT = 1521))
    )
  )
------------

2) on HOSTB:

same as HOSTA but change instA to instB.

3) On both HOSTA and HOSTB:

remove listener.ora (you do not need it)
startup the listener: lsnrctl start
shutdown and restart the database
check the registration status: lsnrctl services

you should see that the listener is listening for both local and remote databases.

4) on client
------------ tnsnames.ora ---------
sales =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = HOSTA)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = HOSTB)(PORT = 1521))
      (SOURCE_ROUTE = false)
      (LOAD_BALANCE = yes)
      (FAILOVER = yes)
    )
    (CONNECT_DATA =
      (SERVICE_NAME = sales)
    )
  )
--------------