RAC对于SQLPLUS不可以进行切换

wiki23

最初由 儿子属羊 发布
[B]SQL> connect system/manager@inst1                        
connected                                                
SQL>select instance_name from v$instance ;               
inst1                                                   
                                                         
/另外开一个窗口 shutdown abort inst1                     
再执行                                                   
                                                         
SQL>select instance_name from v$instance ;               
inst2                                                   
                                                         
就说明你的TAF没有问题! [/B]

select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION           STARTUP_T STATUS       PAR    THREAD# ARCHIVE LOG_SWITCH_
----------------- --------- ------------ --- ---------- ------- -----------
LOGINS     SHU DATABASE_STATUS   INSTANCE_ROLE      ACTIVE_ST
---------- --- ----------------- ------------------ ---------
              1 tired1
t1
9.2.0.4.0         23-FEB-06 OPEN         YES          1 STARTED
ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE   NORMAL

在另外一个窗口把TIRED1关闭

再执行
SQL> select * from v$instance;
select * from v$instance
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

但是在TOAD就不会出现这个问题，
快晕了，郁闷，看来TAF没有实现

Yong Huang

最初由 wiki23 发布
[B]...
在另外一个窗口把TIRED1关闭

再执行
SQL> select * from v$instance;
select * from v$instance
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

但是在TOAD就不会出现这个问题，
快晕了，郁闷，看来TAF没有实现 [/B]

Does your sqlplus connection go through Oracle Net (SQL*Net)? If so, show us the output of tnsping connectionstring.

(It's better to use DOS version sqlplus. That way you can type tnsping in the same DOS window.)

Yong Huang

儿子属羊

最初由 wiki23 发布
[B]

select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION           STARTUP_T STATUS       PAR    THREAD# ARCHIVE LOG_SWITCH_
----------------- --------- ------------ --- ---------- ------- -----------
LOGINS     SHU DATABASE_STATUS   INSTANCE_ROLE      ACTIVE_ST
---------- --- ----------------- ------------------ ---------
              1 tired1
t1
9.2.0.4.0         23-FEB-06 OPEN         YES          1 STARTED
ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE   NORMAL

在另外一个窗口把TIRED1关闭

再执行
SQL> select * from v$instance;
select * from v$instance
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

但是在TOAD就不会出现这个问题，
快晕了，郁闷，看来TAF没有实现 [/B]

TAF没有实现,贴出你所有相关的文件,tnsnames.ora sqlnet.ora listener.ora 以及客户端的tnsnames.ora

wiki23

最初由 儿子属羊 发布
[B]

TAF没有实现,贴出你所有相关的文件,tnsnames.ora sqlnet.ora listener.ora 以及客户端的tnsnames.ora [/B]

T1,T2 SPFILE


*.background_dump_dest='/u01/oracle/admin/tired/bdump'
*.cluster_database_instances=2
*.cluster_database=true
*.compatible='9.2.0.0.0'
*.control_files='/u01/oracle/oradata/tired/control01.ctl','/u01/oracle/oradata/tt
ired/control02.ctl','/u01/oracle/oradata/tired/control03.ctl'
*.core_dump_dest='/u01/oracle/admin/tired/cdump'
*.db_block_size=8192
*.db_cache_size=20971520
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='tired'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
tired2.instance_name='tired2'
tired1.instance_name='tired1'
tired1.instance_number=1
"pfile1.ora" 42L, 1352C 1,1 Top
*.background_dump_dest='/u01/oracle/admin/tired/bdump'
*.cluster_database_instances=2
*.cluster_database=true
*.compatible='9.2.0.0.0'
*.control_files='/u01/oracle/oradata/tired/control01.ctl','/u01/oracle/oradata/tired/control02.ctl','/u01/oracle/oradata/tired/control03.ctl'
*.core_dump_dest='/u01/oracle/admin/tired/cdump'
*.db_block_size=8192
*.db_cache_size=20971520
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='tired'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
tired2.instance_name='tired2'
tired1.instance_name='tired1'
tired1.instance_number=1
tired2.instance_number=2
*.java_pool_size=0
*.large_pool_size=8388608
tired2.local_listener='LISTENER_TIRED2'
tired1.local_listener='LISTENER_TIRED1'
*.log_archive_dest='/u01/oracle/oradata/tired/archive'
*.log_archive_format='%t_%s.trc'
*.log_archive_start=true
*.open_cursors=300
tired1.open_cursors=250
*.pga_aggregate_target=25165824



T1接点的TNSNAMES.ORA


TIRED2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = t2pub)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = tired)
(INSTANCE_NAME = tired2)
)
)

TIRED1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = t1pub)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = tired)
(INSTANCE_NAME = tired1)
)
)

TIRED =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = t1pub)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = t2pub)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER = on)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tired)
(FAILOVER_MODE =
(TYPE=SESSION)
(METHOD=basic)
)
)
)

LISTENERS_TIRED =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = t1pub)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = t2pub)(PORT = 1521))
)

LISTENER_TIRED2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = t2pub)(PORT = 1521))


LISTENER_TIRED1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = t1pub)(PORT = 1521))


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



t2接点的TNSNAMES.ORA
TIRED2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = t2pub)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = tired)
(INSTANCE_NAME = tired2)
)
)

TIRED1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = t1pub)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = tired)
(INSTANCE_NAME = tired1)
)
)

TIRED =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = t1pub)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = t2pub)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER = on)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tired)
(FAILOVER_MODE =
(TYPE=SESSION)
(METHOD=basic)
)
)
)

LISTENERS_TIRED =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = t1pub)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = t2pub)(PORT = 1521))
)

LISTENER_TIRED2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = t2pub)(PORT = 1521))


LISTENER_TIRED1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = t1pub)(PORT = 1521))


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





T1的listener.ora

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

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/oracle/ora920)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = /u01/oracle/ora920)
(SID_NAME = tired1)
)
)


T2的listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = t2pub)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/oracle/ora920)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = /u01/oracle/ora920)
(SID_NAME = tired2)
)
)



我客户端的配置

TIRED2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.6.0.54)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = tired)
(INSTANCE_NAME = tired2)
)
)

TIRED1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.6.0.52)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = tired)
(INSTANCE_NAME = tired1)
)
)


tired =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.6.0.52)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.6.0.54)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER = ON)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tired)
(FAILOVER_MODE =
(type = SESSION)
(method = basic)
)
)
)


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