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 显示  

操作系统服务列表显示