Navicat Premium connection O r a c l e appears o r a-1 2 5 0 5 Error solution case

Find the listener. ora file: My Oracle is installed on the F disk,

Path: F: \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \ listener. ora:

# Listener. ora Network Configuration File: F: \ 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 = F: \ oracle \ product \ 10.2.0 \ db_1)

(PROGRAM = extproc )))

LISTENER = (DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))

(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521 ))))

 

The modified configuration is as follows:

# Listener. ora Network Configuration File: F: \ 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 = F: \ oracle \ product \ 10.2.0 \ db_1)

(PROGRAM = extproc ))

(SID_DESC =

(GLOBAL_DBNAME = ORCL)

(ORACLE_HOME = F: \ oracle \ product \ 10.2.0 \ db_1)

(SID_NAME = ORCL ))

)

LISTENER = (DESCRIPTION_LIST =

(DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))

(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521 ))))

 

The red part restarts the listener for the added content.