如果数据文件中存在多个实例的情况，就应该配置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>

配置后就可以实现远程登录数据库实例

如果是数据文件中就一个实例，则无需配置此参数