ORA-12514: TNS: The Listener currently cannot identify the Service requested in the connection Descriptor

An error occurred while testing the connection during Oracle 10g client configuration (net configuration assistant -- local net service name configuration ):

ORA-12514: TNS: ListenersProgramThe Service requested in the connection descriptor cannot be recognized currently

Then open:

D: \ oracle \ product \ 10.2.0 \ db_1 \ Network \ admin \ listener. ora

 

The content is as follows:

# Listener. ora network configuration file: D: \ oracle \ product \ 10.2.0 \ db_1 \ Network \ admin \ listener. ora
# Generated by Oracle configuration tools.

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = plsextproc)
(ORACLE_HOME = D: \ oracle \ product \ 10.2.0 \ db_1)
(Program = EXTPROC)
)
)

Listener =
(Description_list =
(Description =
(Address = (Protocol = IPC) (Key = extproc1 ))
(Address = (Protocol = TCP) (host = pc20120520 )(Port = 1522))
)
)

 

Port = 1522 is not a common 1521, because Oracle9i and Oracle10g are installed on the PC, and oracle10 ports are automatically set to 1522.

Write 1522 when entering the port number. The test is successful.