oracle查看本機(jī)服務(wù)名

select global_name from global_name;

?

數(shù)據(jù)庫(kù)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

數(shù)據(jù)庫(kù)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 顯示 ?

操作系統(tǒng)服務(wù)列表顯示 ?

?

轉(zhuǎn)載于:https://www.cnblogs.com/huxian/p/4321506.html

總結(jié)

以上是生活随笔為你收集整理的ORACLE 服务名简述及配置说明的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。