Recently, we re-installed Oracle10g and encountered this error. It seems that every time we installed 10g, we encountered this problem. Let's take a look at it as soon as possible.
Under normal circumstances, everything works in sqlplus, but the ora-12505 error is reported when the database is accessed through the jar package driver. The following solutions are often effective:
Find the listener. ora file: My oracle is installed on drive D, path: D: \ oracle \ product \ 10.2.0 \ db_1 \ Network \ admin \ listener. ora
The configuration before modification 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 = 127.0.0.1) (Port = 1521 ))
)
)
The modified configuration 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)
)
(Sid_desc =
(Global_dbname = orcl)
(ORACLE_HOME = D: \ 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 is the added content. For personal suggestions, the green part is written as localhost or 127.0.0.1, rather than the computer name. The default value is the computer name.
Restart listener