Oracle配置共用伺服器詳細步驟
Oracle配置共用伺服器:
1.配置第二個監聽
netca/手工
手工:listener.ora
LSNR_2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Demon)(PORT = 1526))
)
)
2.啟動LSR_2監聽 lsnrctl start lsnr_2
3.配置tnsnames.ora
添加:
LSNR_2 =(ADDRESS = (PROTOCOL = TCP)(HOST = Demon)(PORT = 1526))
ORCL_1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Demon)(PORT = 1526))
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = ORCL)
)
)
4.註冊LSNR_2監聽
show parameter service_names
show parameter local_listener
alter system set local_listener='LSNR_2';
alter system register;
註:到此為止,與建立第二監聽的差別不是很大,只是改變了一個SERVER = SHARED參數;
此外還可修改資料庫服務名,一個資料庫可有多個服務名:
show parameter service_names
alter system set service_name=" ……";
alter system set service_names=ORCL,EG;
5.配置共用伺服器參數
show parameter shared; 共用進程
show parameter dispatch; 調度參數
6.產生pfile,關庫
create pfile from spfile;
shutdown immediate
7.修改參數檔案
$ORACLE_HOME/dbs/
ls -ctl
vi initORCL.ora
在pfile參數檔案中添加參數:
shared_servers=10
max_shared_servers=30
shared_server_sessions=200
dispatchers="(PROTOCOL=TCP) (DISPATCHERS=3)" /網路通訊協定和發送器參數
max_dispatchers=10
8.產生spfle ,起庫
create spfile from pfile;
startup
9.查看相關參數
show parameter shared; 共用進程
show parameter dispatch; 調度參數
10.測試
sqlplus hr/hr@ORCL_1
查看視圖:
select server from v$session; /給予許可權
配置Oracle共用伺服器