本帖最后由 gh_95533 于 2018-4-11 16:49 编辑
数据库版本:oracle 10.2.0.4是否集群:集群
连接串配置
RAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.181)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = RAC1)
)
)
RAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.183)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.184)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC)
)
)
RAC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.182)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = RAC2)
)
)
分别使用 rac1,rac,rac2的数据库链接登陆,只有节点一报错:ORA-12519:TNS:没有找到适用的服务处理程序
暂时将节点一数据库链接修改成shared,才能登陆
RAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.181)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = shared)
(SID = RAC1)
)
)
下面第一个是节点二的进程和会话数,第二个是节点一的进程和会话数
====节点二========================
SQL> show parameter processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 10
gcs_server_processes integer 20
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 1000
SQL> select count(1) from v$process;
COUNT(1)
----------
361
show parameter session;
SQL> show parameter session;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
session_cached_cursors integer 20
session_max_open_files integer 10
sessions integer 1105
shared_server_sessions integer
SQL> select count(8) from v$session;
COUNT(8)
----------
357
===节点一=====================
SQL> show parameter processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 10
gcs_server_processes integer 20
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 1000
SQL> select count(1) from v$process;
COUNT(1)
----------
113
SQL> show parameter session;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
session_cached_cursors integer 20
session_max_open_files integer 10
sessions integer 1105
shared_server_sessions integer
SQL> select count(8) from v$session;
COUNT(8)
----------
109
SQL>
我想问的问题是为什么设置成第一个为什么节点一设置成server=shared,就可以登陆数据库,第二为什么节点一都而没有达到阀值,就不能使用server=dedicited(专用)登陆