Shulou(Shulou.com)06/01 Report--

If ORA-12514 error occurs, you need to find the file F:\app\khe\product\11.2.0\dbhome_3\NETWORK\ADMIN\listener.ora

==============================

Open the file and add the red part.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = CLRExtProc)

(ORACLE_HOME = F:\app\khe\product\11.2.0\dbhome_3)

(PROGRAM = extproc)

(ENVS = "EXTPROC_DLLS=ONLY:F:\app\khe\product\11.2.0\dbhome_3\bin\oraclr11.dll")

)

(SID_DESC =

(GLOBAL_DBNAME = MYORACLE)

(ORACLE_HOME = F:\app\khe\product\11.2.0\dbhome_3)

(SID_NAME = MYORACLE)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))

(ADDRESS = (PROTOCOL = TCP)(HOST = D305875.asiapacific.epicor.net)(PORT = 1522))

)

)

ADR_BASE_LISTENER = F:\app\khe

==============================

GLOBAL_DBNAME can be accessed by querying

select * from global_name Query

ORACLE_HOME is the same as the previous section. SID_NAME is the same as GLOBAL_DBNAME.

Restart the listener service.

In the login form, HostName and port should be the same as those in the blue part. If it is local, you can fill in localhost. Service Name is like GLOBAL_DBNAME.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.