如果数据文件中存在多个实例的情况,就应该配置shared_server_sessions和shared_servers参数的值
如:
设置之前
SQL> show parameter shared
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
max_shared_servers integer
shared_memory_address integer 0
shared_pool_reserved_size big integer 5M
shared_pool_size big integer 0
shared_server_sessions integer
shared_servers integer 1
设置
SQL> alter system set shared_server_sessions=200;
System altered.
SQL> alter system set shared_servers=10;
System altered.
设置之后
SQL> show parameter shared
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
max_shared_servers integer
shared_memory_address integer 0
shared_pool_reserved_size big integer 5M
shared_pool_size big integer 0
shared_server_sessions integer 200
shared_servers integer 10
SQL>
配置后就可以实现远程登录数据库实例
如果是数据文件中就一个实例,则无需配置此参数
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29802484/viewspace-1418289/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29802484/viewspace-1418289/