Foreword: There are a lot of solutions on the net, delete Listener.ora or whatever, still can not solve this problem of me, still report 12514 error, following is I try after the successful listening string.
Listener.ora file:
# Listener.ora Network Configuration File:d:/app/john/product/11.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = cjtfs)
(Oracle_home = d:/app/john/product/11.1.0/db_1)
(program = CJTFS)
)
(Sid_desc =
(Global_dbname = cjtfs)
(Oracle_home = d:/app/john/product/11.1.0/db_1)
(Sid_name = cjtfs)
)
)
LISTENER =
(Description_list =
(DESCRIPTION =
(address = (PROTOCOL = TCP) (HOST = john-pc) (PORT = 1521))
)
)
Tnsnames.ora file:
# Tnsnames.ora Network Configuration File:d:/app/john/product/11.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
Cjtfs =
(DESCRIPTION =
(address = (PROTOCOL = TCP) (HOST = john-pc) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = cjtfs) #要和listener. Ora the name of the CJTFS position is consistent.
)
)
If still can not solve, then leave a message, I generally will often read the blog .... Everyone to solve together. Learn from each other.