Oracle Basics

Time:2019-12-10

1. View Oracle port

Tnsnames. Ora in D: \ app \ administrator \ product \ 11.1.0 \ DB \ 1 \ network \ admin

Here is my local information:

# tnsnames.ora Network Configuration File: D:\app\Administrator\product.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)
    )
  )