Oracle Database ORA-12514 error Solution

ERROR prompt: ERROR: ORA-12514: TNS: Listener solution: Code as follows 1. Open the networkadminlistener. ora file, find: SID_LIST_LISTENER (SID_LIST (SID_DESC (SID_NAMEPLSExtProc) (ORACLE _

ERROR message: ERROR: ORA-12514: TNS: listener cocould not resolve SERVICE_NAME given in connect solution: the code is as follows 1. enable/network/admin/listener. ora file, find: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE _

Problem prompt

ERROR message: ERROR: ORA-12514: TNS: listener cocould not resolve SERVICE_NAME given in connect

Solution:

The Code is as follows:

1. Open the/network/admin/listener. ora file and find:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = D: oracleproduct10.1.0db _ 1)

(PROGRAM = extproc)

)

)

2. Add:

The Code is as follows:

(SID_DESC =

(GLOBAL_DBNAME = ORACLE)

(ORACLE_HOME = D: oracleproduct10.1.0db _ 1)

(SID_NAME = ORACLE)

)

3. Finally changed:

The Code is as follows:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = D: oracleproduct10.1.0db _ 1)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = ORACLE)

(ORACLE_HOME = D: oracleproduct10.1.0db _ 1)

(SID_NAME = ORACLE)

)

)

4. Save the file and restart TNSListener in the service. OK!

Note: You must restart TNSListener,

Method: Command mode

The Code is as follows:

C:> lsnrctl

LSNRCTL> stop

LSNRCTL> start

Done.

Another cause of this problem is: Ora-12514: TNS: no listeners

Solution: If the TNSListener service is not started, you can start the service.

Common Name: OracleOraDb10g_home1TNSListener:

This Service corresponds to % Oracle_HoembinTNSLSNR.EXE

Ora-12514: TNS: The Listener currently cannot identify the Service requested in the Link descriptor.

For this error, the practice on the internet is usually as follows:

Open the file: % Oracle_Hoem %/network/admin/listener. ora.

In

The Code is as follows:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = D: OracleOracle10g)

(PROGRAM = extproc)

)

Add:

The Code is as follows:

(SID_DESC =

(GLOBAL_DBNAME = ORACLE)

(ORACLE_HOME = D: OracleOracle10g)

(SID_NAME = ORACLE)

)

Finally changed:

The Code is as follows:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = D: OracleOracle10g)

(PROGRAM = extproc)

) (SID_DESC =

(GLOBAL_DBNAME = ORACLE)

(ORACLE_HOME = D: OracleOracle10g)

(SID_NAME = ORACLE)

)

)

However, I don't think it is so laborious. First, disable the listener service, then shut down the Database Service, start the Database Service, and start the listener service. That's simple.