-
在专用服务器模式中,对于每个运行数据库应用程序的用户进程都由执行Oracle 数据库服务器代码的专用服务器进程提供服务。
-
在共享服务器模式中,不必为每个连接都提供一个专用服务器进程。分派程序将多个传入网络会话请求引到共享服务器进程池。共享服务器进程为所有客户机请求提供服务。
-
Easy Connect(EZCONNECT)
-
本地命名(TNSNAMES)
-
目录命名和外部命名
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
$
cat
sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE =
/u01/app/oracle
$
cat
listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ora11g.example.com)(PORT = 1521))
)
)
ADR_BASE_LISTENER =
/u01/app/oracle
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON
# line added by Agent
$
cat
tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = orcl.example.com)
)
)
$ lsnrctl service
LSNRCTL
for
Linux: Version 11.2.0.1.0 - Production on 11-SEP-2013 22:11:58
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora11g.example.com)(PORT=1521)))
Services Summary...
Service
"+ASM"
has 1 instance(s).
Instance
"+ASM"
, status READY, has 1 handler(s)
for
this service...
Handler(s):
"DEDICATED"
established:0 refused:0 state:ready
LOCAL SERVER
Service
"orcl.example.com"
has 1 instance(s).
Instance
"orcl"
, status READY, has 1 handler(s)
for
this service...
Handler(s):
"DEDICATED"
established:0 refused:0 state:ready
LOCAL SERVER
Service
"orclXDB.example.com"
has 1 instance(s).
Instance
"orcl"
, status READY, has 1 handler(s)
for
this service...
Handler(s):
"D000"
established:0 refused:0 current:0 max:972 state:ready
|