修改本地配置遠端連線oracle資料庫

標籤：個人   sid   com   back   換行   pre   add   file   dbn   

　　當我們需要查看資料庫資訊時，我們更願意通過用戶端來查看，這樣不僅操作方便，而且查看更精準。那麼需要遠端連線資料庫需要在本地修改那些配置呢？以下是我個人的經驗，希望大家都指正。

　　1、在oracle安裝目錄\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora檔案中添加紅線以下的配置，可以換行，但不能有間隔。 

# tnsnames.ora Network Configuration File: E:\oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) YT_PX= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.41.1.21)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = matedb) ) )

　　

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  2、監聽本地ip有兩種方法

　　（1）在\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora 檔案中監聽本地ip                                                                                              

# listener.ora Network Configuration File: E:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = E:\oracle\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:E:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = E:\oracle\product\11.2.0\dbhome_1) (SID_NAME = ORCL) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.88.220)(PORT = 1521)) ) ) ADR_BASE_LISTENER = E:\oracle

 

 

 

 

 

 

 

 

 

 

 

（2）在功能表列找到Net Manager 點擊進入

如添加新的監聽器監聽本地ip 

修改本地配置遠端連線oracle資料庫