动态注册
1.确定service_names 和 instance_name 两个参数的值
1.确定service_names 和 instance_name 两个参数的值
QL> show parameter service_names
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
service_names string
tid001
SQL> show parameter instance_name
------------------------------------ ---------------------------------
VALUE
------------------------------
service_names string
tid001
SQL> show parameter instance_name
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
instance_name string
tid001
------------------------------------ ---------------------------------
VALUE
------------------------------
instance_name string
tid001
2.在init.ora文件中指定 service_names 和 instance_name 两个参数的值
[oracle@..]$ vi inittid001.ora
...
...
*.instance_name='tid001'
*.service_name='tid001'
...
*.service_name='tid001'
...
3.数据库启动到mount状态时注册监听
动态注册,出现Blocked connection requests 的情况
1).instance 在nomount下,客户端连接数据库时出现Blocked connection requests
1).instance 在nomount下,客户端连接数据库时出现Blocked connection requests
2).在shutdown期间,客户端连接数据库时出现Blocked connection requests
The error occurs when a database instance is not yet registered with the listener.
http://docs.oracle.com/cd/E11882_01/network.112/e10836/net_arch.htm#NETAG1080
About Blocked Connection Requests
http://docs.oracle.com/cd/E11882_01/network.112/e10836/net_arch.htm#NETAG1080
About Blocked Connection Requests
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24756186/viewspace-746062/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24756186/viewspace-746062/