linux 跨服务器启动,Linux/Unix shell 脚本跨服务器跨实例执行SQL

4、测试

#使用tnsnames方式测试

oracle@linux1:~> ./query_multi_inst_tns.sh

************************************

Current host is 172.168.2.196.

************************************

------------------------------------

Current database is US001.

------------------------------------

NAME                          VALUE

------------------------------ --------------------

open_cursors                  300

------------------------------------

Current database is US002.

------------------------------------

NAME                          VALUE

------------------------------ --------------------

open_cursors                  300

------------------------------------

Current database is US003.            #这个是没有tnsnames的情形

------------------------------------

ERROR:

ORA-12154: TNS:could not resolve the connect identifier specified

#直接在远程服务器环境轮巡测试

oracle@linux1:~> ./query_multi_inst_notns.sh

************************************

Current host is 172.168.1.196.

************************************

------------------------------------

Current database is US001.

------------------------------------

NAME                          VALUE

------------------------------ --------------------

open_cursors                  300

------------------------------------

Current database is US002.

------------------------------------

NAME                          VALUE

------------------------------ --------------------

open_cursors                  300

------------------------------------

Current database is US005.            #远程服务器上的实例没有启动的情形

------------------------------------

select name,value from v$parameter where name='open_cursors'

*

ERROR at line 1:

ORA-01034: Oracle not available