Oracle基本知识

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)
    )
  )