ORA-12154

ykuj

从D:\oracle\ora92\network\admin目录下找到tnsnames.ora
# TNSNAMES.ORA Network Configuration File: D:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

TESTL001 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = testl001)
    )
  )

ZJYTEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = zjytest)
    )
  )
DUC08 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = duc08)
    )
  )
XC14 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = xc14)
    )
  )
AEC12 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = aec12)
    )
  )
AYC11 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ayc11)
    )
  )
VVC06 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = vvc06)
    )
  )
PACKC03 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = packc03)
    )
  )
ABC13=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = abc13)
    )
  )
NZC04=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = nzc04)
    )
  )
QCC16=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = qcc16)
    )
  )
QTC15=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = qtc15)
    )
  )
查看是否配置好了服务