程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> DB2數據庫 >> DB2教程 >> 對監聽靜態注冊配置的理解

對監聽靜態注冊配置的理解

編輯:DB2教程

對監聽靜態注冊配置的理解


Listener.ora 配置文件 中global_dbname 可以隨便配置;

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = ora11gbak)----可以自定義

(ORACLE_HOME = /u01/app/ora11/product/11.2.0/dbhome_1)

(SID_NAME = ora11g)

)

(SID_DESC =

(GLOBAL_DBNAME = lixorabak) ----可以自定義

(ORACLE_HOME = /oracle)

(SID_NAME = lixora)

)

)

LSNRCTL> status

Services Summary...

Service "PLSExtProc" has 1instance(s).

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

Service "lixora" has 1instance(s).

Instance "lixora", status READY, has 1 handler(s) for thisservice... ----------動態注冊

Service "lixorabak" has 1 instance(s).

Instance "lixora", status UNKNOWN, has 1 handler(s) for this service...----------靜態注冊

Service "ora11g" has 1instance(s).

Instance "ora11g", status READY, has 1 handler(s) for thisservice... --------------動態注冊

Service "ora11gbak" has 1 instance(s).

Instance "ora11g", status UNKNOWN, has 1 handler(s) for this service... ----------靜態注冊

The command completed successfully

NAME TYPE VALUE

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

db_name string ora11g

db_unique_name string ora11g

global_names boolean FALSE

instance_name string ora11g

service_names string ora11g

客戶端連接測試:---可以正常連接

C:\Users\hlj>sqlplus system/[email protected]/ora11gbak

SQL*Plus: Release 10.2.0.1.0 - Productionon 星期五 6月 19 16:56:15 2015

Copyright (c) 1982, 2005, Oracle. All rights reserved.

連接到:

Oracle Database 11g Enterprise EditionRelease 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Miningand Real Application Testing options

SQL> select * from dual;

DU

--

X

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved