ORACLE 服務名簡述及配置說明

標籤：

oracle查看本機服務名

select global_name from global_name;

 

資料庫listener.ora

# listener.ora Network Configuration File: E:\app\chenjz\product\11.2.0\dbhome_1\network\admin\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =  

(SID_LIST =    

　　(SID_DESC =      

　　(PROGRAM = extproc)      

　　(SID_NAME = PLSExtProc)      

　　 (ORACLE_HOME = D:\app\Administrator\product\11.1.0\db_1)    

)  

(SID_DESC =      

　　(GLOBAL_DBNAME = ORCL.liuxianhu)      

　　 (ORACLE_HOME = D:\app\Administrator\product\11.1.0\db_1)      

　　 (SID_NAME = ORCL)    

  )  

)

ADR_BASE_LISTENER =D:\app\Administrator

資料庫tnsnames.ora

# tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN\tnsnames.ora

# Generated by Oracle configuration tools.

 

ORCL =  

   (DESCRIPTION =    

     (ADDRESS_LIST =      

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

     )    

   (CONNECT_DATA =      

       (SERVICE_NAME = ORCL.LIUXIANHU)  

     )  

   )

Net Manager 顯示  

作業系統服務列表顯示  

 

ORACLE 服務名簡述及配置說明