The Oracle adapter is not connected to the solution
Author: Vashon
Oracle's developer connection is not reported incorrectly: listener does not currently know of SID given in Connect descriptor solution:
In D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN find the Listener.ora file, the modified file in the "below", copy and overwrite the OK.
# Listener.ora Network Configuration File:d:\app\administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
Change the configuration in the Listener.ora to the following:
Sid_list_listener =
(sid_list = (
Sid_desc =
(sid_name = Clrextproc)
(oracle_home = D:\app\ Administrator\product\11.2.0\dbhome_1)
(program = extproc)
(Envs = "Extproc_dlls=only:d:\app\administrator \product\11.2.0\dbhome_1\bin\oraclr11.dll ")
)
(Sid_desc =
(global_dbname = ORCL)
(Oracle_home = D:\app\Administrator\product\11.2.0\dbhome_1)
(Sid_name = ORCL
)) LISTENER =
(description_list = (
DESCRIPTION =
(address = (PROTOCOL = IPC) (KEY = EXTPROC1521))
( Address = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
)
Adr_base_listener = D:\app\Administrator
If you follow the above or the connection is not, it may be your SID error.
WORKAROUND: See this article