日韩成人黄色,日韩精品视频三区,蜜臀a∨国产成人精品

Oracle靜態監聽注冊詳解

　網上有很多關于oracle 監聽靜態注冊的文章，但大多都是簡單說說，并沒有詳細的例子，這里，將結合linux as4 下的oracle 10gR2.0.1 舉一個具體的例子

　　1、在 $ORACLE_HOME/network/admin/listener.ora 文件中加入一個靜態注冊的節點

[oracle@prudent oracle]$ cd $ORACLE_HOME/network/admin

[oracle@prudent admin]$ vi listener.ora

# listener.ora Network Configuration File: /mydatafile2/app/oracle/oracle/product/11.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /mydatafile2/app/oracle/oracle/product/11.2.0/db_1)

(PROGRAM = extproc)

)

(SID_DESC =

(SID_NAME = ORCL)

(ORACLE_HOME = /mydatafile2/app/oracle/oracle/product/11.2.0/db_1)

(GLOBAL_DBNAME=WOO.COM)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

(ADDRESS = (PROTOCOL = TCP)(HOST = prudent)(PORT = 1521))

)

　　注意這里的GLOBAL_DBNAME=WOO.COM

　　SID_NAME=ORCL

　　這個SID_NAME 應與你對外提供服務的 $ORACLE_SID 一致

　　[oracle@prudent admin]$ echo $ORACLE_SID

　　ORCL

　　2、配置對應的tnsnames.ora 中的節點

[oracle@prudent admin]$ vi tnsnames.ora

# tnsnames.ora Network Configuration File: /mydatafile2/app/oracle/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

ORCL=

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = prudent)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ORCL)

)

WOOORCL=

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = prudent)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = WOO.COM)

)

[oracle@prudent admin]$ vi tnsnames.ora

# tnsnames.ora Network Configuration File: /mydatafile2/app/oracle/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

ORCL=

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = prudent)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ORCL)

)

WOOORCL=

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = prudent)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = WOO.COM)

)

tnsname WOOORCL 中的 SERVICE_NAME=WOO.COM

　　這里的服務名為 WOO.COM 而不是通常的 ORCL，因為在 listener.ora 中已經注冊了 WOO.COM,lsnrctl 啟動時會監聽 WOO.COM ，并對應到 SID_NAME=ORCL 上。3、啟動監聽和服務

[oracle@prudent oracle]$ cat dbstart

lsnrctl start

sqlplus /nolog <<EOF

connect /as sysdba

startup

EOF

[oracle@prudent oracle]$ ./dbstart

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 13-FEB-2011 20:11:15

Starting /mydatafile2/app/oracle/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production

System parameter file is /mydatafile2/app/oracle/oracle/product/11.2.0/db_1/network/admin/listener.ora

Log messages written to /mydatafile2/app/oracle/oracle/product/11.2.0/db_1/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prudent)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date 13-FEB-2011 20:11:15

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /mydatafile2/app/oracle/oracle/product/11.2.0/db_1/network/admin/listener.ora

Listener Log File /mydatafile2/app/oracle/oracle/product/11.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prudent)(PORT=1521)))

Services Summary...

Service "WOO.COM" has 1 instance(s).

Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...

Service "ORCL" has 1 instance(s).

Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

SQL*Plus: Release 11.2.0.1.0 - Production on Sun Feb 13 20:11:16 2011

SQL> Connected to an idle instance.

SQL> ORA-32004: obsolete and/or deprecated parameter(s) specified

ORACLE instance started.

Total System Global Area 461373440 bytes

Fixed Size 1220000 bytes

Variable Size 75498080 bytes

Database Buffers 381681664 bytes

Redo Buffers 2973696 bytes

Database mounted.

Database opened.

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

　　可以看到

　　Service "WOO.COM" has 1 instance(s).

　　Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...

　　正在被監聽。

　　4、驗證該服務可以到達

[oracle@prudent oracle]$ tnsping WOOORCL

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 13-FEB-2011 20:14:59

Used parameter files:

/mydatafile2/app/oracle/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = prudent)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = WOO.COM)))

OK (10 msec)

　　5、利用靜態注冊的服務登入oracle

[oracle@prudent oracle]$ sqlplus system@oracleWOOORCL

SQL*Plus: Release 11.2.0.1.0 - Production on Sun Feb 13 20:17:27 2011

Connected to:

Oracle Database 10g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL> select count(*) from date_log;

COUNT(*)

----------

SQL>

　　至此：已驗證該靜態注冊可以成功的被解析，監聽，連接。

posted on 2014-09-12 10:04 順其自然EVO 閱讀(3048) 評論(0) 編輯收藏所屬分類: 測試學習專欄

新用戶注冊刷新評論列表


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關文章: 如何進行Web服務的性能測試？利用drozer進行Android滲透測試 Appium Android Bootstrap源碼分析之命令解析執行 Fliptest—iOS 的應用A/B測試框架 iOS功能測試工具 Frank iOS單元測試框架Kiwi for iOS Appium Android Bootstrap之控件AndroidElement 移動應用測試框架—Calabash Android 簡介 Appium Server源碼分析之作為Bootstrap客戶端移植MonkeyRunner的圖片對比功能實現-Appium篇

qileilove

Oracle靜態監聽注冊詳解

導航

統計

常用鏈接

留言簿(55)

隨筆分類

隨筆檔案

文章分類

文章檔案

搜索

最新評論

閱讀排行榜

評論排行榜