如果数据文件中存在多个实例的情况,就应该配置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>
配置后就可以实现远程登录数据库实例
如果是数据文件中就一个实例,则无需配置此参数