个人观点:
1关于静态静听和动态坚挺也是一直头疼,静态说是实例启动时根据listener.ora文件来启动坚挺然后把实例注入坚挺程序中,动态是实例启动时pmon把实例注入监听程序中,
2一个主机上是可以配置多个监听,但是监听的端口号和监听名称要不同,一个监听可以监听多个实例,一个实例也可以有多个监听。当主机上拥有不同版本数据库时,可能会建立多个监听,可以每个版本建立1个监听,但推荐是所有监听都使用版本最高的建立。
3 当主机lisener.ora和tsnames.ora配置好,tnping ok,在客户端连接报 监听错误,大致是客户端配置问题,如网络中断,端口号和服务器不一致(一个是1521,一个是1522);
4 建库后,常规要改监听参数文件,我把平时稳定运行的贴出,以备后用,呵呵;
listner.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
#(PROGRAM = extproc)
)
)
(SID_DESC=
(GLOBAL_DBNAME=TEST2)
(ORACLE_HOME=/u01/oracle/product/10.2.0/db_1)
(SID_NAME=TEST2)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
)
)
tsnames.ora;
TEST2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.11)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test2)
)
)
LISTENER_TEST2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
5 oracle 静态静态和动态监听
http://space.itpub.net/14284241/viewspace-462978