Oracle View native Service name
Select Global_name from Global_name;
Database 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
Database 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 Display
Operating system Services list display
ORACLE Service Name Brief and configuration instructions