Oracle Error Ora-12514:tns:listener does not currently know of service requested in Connec

Connections are still not established when Oracle's common services are started by connecting Oracle's correct username and password on navicat. But sqlpus on the input user name and password can be connected through, baffled (rookie nature Curiosity).

In this scenario, the history log for Navicat is viewed:Ora-12514:tns:listener does not currently know of service requested in Connect.

through the online search to say that the Navicat tool is 32-bit, oracle64 bit mismatch, thought it might be the reason. So the path http://www.oracle.com/technetwork/topics/winsoft-085727.html by Bo Friends is downloaded toInstantclient-basic-nt-11.2.0.3.0.zip ora-12514: listener Does not currently know of the service requested in Connect listener is not currently aware of the connection request. Since listener don't know how to let it know? Why don't you know? It's hard to understand. Failed to install Oracle But why is the Sqlpus connected? To solve the problem reinstall Oracle before the installation of the uninstall, the Control Panel does not have this software, the Software manager has, in short, a lot of problems. Uninstall the Delete cleanup registry (run regedit  roughly under services) or you cannot reinstall Oracle. Reinstalling the connection still does not work. The problem is back to listener does not currently know of service Requested in Connect The listener is not currently aware of the connection service request, how can listener know?

It can be resolved by modifying the Listener.ora file by checking the Internet. http://blog.csdn.net/icqsky/article/details/4313791

Added a section in the installation directory E:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN file modified a copy of the Code at home (Blue section):

sid_list_ LISTENER =
  (sid_list =
    (sid_desc =
      (sid_name = Clrextproc)
      (oracle_home = E:\app\Administrator\product\11.2.0\dbhome_1)
      (program = extproc)
      (Envs = "extproc_dlls=only:e:\ App\administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll ")
   ) (Sid_desc =
    (Global_ DBNAME = ORCL)
    (Oracle_home = E:\app\Administrator\ product\11.2.0\dbhome_1)
    (Sid_name = ORCL)
Span style= "color: #0000ff;" >   )
 )

Turn off the service and listener, and then start the service and listener. The initial replication did not notice the ORACLE_HOME = directory , the copy directory is not a native file directory, so failure, details really important! Fortunately, the connection was successful after the change .

Oracle Error Ora-12514:tns:listener does not currently know of service requested in Connec