1.查看Oracle端口
D:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN中的【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 = (PROTOCOL = TCP)(HOST = PC-201904130542)(PORT = 1521))
- (CONNECT_DATA =
- (SERVER = DEDICATED)
- (SERVICE_NAME = orcl)
- )
- )