how to solve this problem

大尾巴牛

When I log in to the server with sql * plus, I get this prompt: ora-12514: TNS: The listener cannot determine the service_name provided in the connection description area, because the tnsnames.ora file is replaced
Please how to solve the problem of masters?

海蓝之谜

There is something wrong with your TNS configuration file :)

There are several places to pay attention to
1.HOST is on the server machine name or static IP address
2.SERVICE_NAME The name of the ORACLE instance you installed, other copies are just fine

海蓝之谜

There is something wrong with your TNS configuration file :)

There are several places to pay attention to
1.HOST is on the server machine name or static IP address
2.SERVICE_NAME The name of the ORACLE instance you installed, other copies are just fine

For example:

CKCRP = --You can write the name of CKCRP in this place, just write this in the name of the service you log in to.
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP) (HOST = 172.28.65.213) (PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = CKCRP)
    )
  )
among them
HOST = 172.28.65.213 replaced with the live static IP address or machine name of the machine where your database is located
SERVICE_NAME = CKCRP where CKCRP is replaced with the name of your instance

lightzopiol

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = wgn)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oracle)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
I think I just create a new one
According to the above format host write computer name service_name write instance name