Solution for Oracle Adapter not connected _oracle

Racle developer Connection does not escalate error: Listener does not currently know of SID given in Connect descriptor

Solution:

In D:\app\Administrator\product\. \dbhome_\network\admin found in the Listener.ora file, the modified file in the "below", copy and overwrite the OK.

# Listener.ora Network Configuration file:d:\app\administrator\product\. \dbhome_\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\.. \dbhome_) 
   (program = extproc) 
   (Envs = "extproc_dlls=only:d:\app\administrator\product\. \dbhome_\bin\oraclr.dll ") 
  ) 
 
  (Sid_desc =  
   (global_dbname = ORCL)  
   (oracle_home = D:\app\Administrator \product\.. \dbhome_)  
   (sid_name = ORCL)  
  ) 
LISTENER = 
 (description_list 
   = (DESCRIPTION = ( Address = (PROTOCOL = IPC) (KEY = Extproc)) 
   (address = (PROTOCOL = TCP) (HOST = localhost) (PORT =)) 
 
   
    adr_base_listener = D:\app\Administrator 


   

If you follow the above or the connection is not, it may be your SID error!

Workaround: http://www.jb51.net/article/73178.htm