1.sqlplus+tnsname

環境變數:C:\Oracle\Network\Admin 指定TNSname路徑

sqlnet.ora

TRACE_LEVEL_CLIENT = OFF

names.directory_path = (TNSNAMES, HOSTNAME)

names.default_domain = world

name.default_zone = world

automatic_ipc = off

tnsname.ora

DEMO.world=

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = IP或電腦名稱)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = demo.kh.*******.com)

    )

  )

or 

sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES)

tnsname.ora

DEMO=

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = IP or 電腦名稱)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = demo.kh.*******.com)

    )

  )

sqlplus 工具路徑

C:\Oracle\x86\bin

------------

cmd login

sqlplus SYS/password@DEMO as sysdba

user>>sqlplus SYSTEM/password@DEMO

https://asekh-go.kh.asegroup.com/codimd/s/HyONeRY43