Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc))) Listener Log File C:\dev\env\oracle11gXE\app\oracle\diag\tnslsnr\DCNU251B78K\listener\alert\log.xml Listener Parameter File C:\dev\env\oracle11gXE\app\oracle\product\11.2.0\server\network\admin\listener.ora Version TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production All rights reserved.Ĭonnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER ![]() Output of the command below should list now XE (which was missing earlier for ORA-12514) Alternatively restart OracleServiceXE and OracleXETNSListener services and run the SQL alter statements.Ĩ. SQL> alter system set LOCAL_LISTENER='(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))' scope=both Īnd try to reconnect using SqlDeveloper or your app. Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production ![]() If you still cannot connect due to listener problem then open Windows command line (type CMD in Windows program) and type:Ĭopyright (c) 2009 Microsoft Corporation.Then make sure you SqlDeveloper settions are:.(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) Then check port and hostname in listener.ora and (present for my installation in C:\dev\env\oracle11gXE\app\oracle\product\11.2.0\server\network\ADMIN) : ![]() ORA-12514, TNS:listener does not currently know of service requested in connect descriptor When you cannot connect to the listener due to:Ĭaused by: .NetException: Listener refused the connection with the following error:.When you want to start Oracle XE just start manually: OracleServiceXE and OracleXETNSListener Change startup type to manual for all of them.Type”services” in Windows programs search to start services program.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |