How to solve this problem

大尾巴牛

When I log in to the server with sql * plus on the server, I get the following prompt: ora-12514: TNS: The listener cannot determine the service_name provided in the connection description area. The reason is because the tnsnames.ora file has been replaced. Delete the listener in the middle, and rebuilding is still not possible.
Please how to solve the problem of masters?

Thank you!!!

海蓝之谜

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
    
You can copy everything else and add it to your TNS file.