Oxax Techie Rss

If you intend to connect with service name XE, edit your listener.ora to look include the XE name. Sample below SID_LIST_LISTENER =   (SID_LIST =   (SID_DESC =       (SID_NAME = XE)       (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)     )     (SID_DESC =       (SID_NAME = PLSExtProc)       (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)       (PROGRAM = extproc)     )     (SID_DESC =       (SID_NAME = CLRExtProc)       (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)       (PROGRAM = extproc)     )   ) LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))     )   ) DEFAULT_SERVICE_LISTENER = (XE) Open your command prompt as administrator and Run  lsnrctl restart lsnrctl reload Voila..Goodluck.

To resolve this issue, Goto your oraclexe directory and navigate to network/ADMIN     e.g oraclexe\app\oracle\product\11.2.0\server\network\ADMIN Open ( listener .ora) in notepad and replace the HOST address with your localhost or current-ip e.g LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))     )   ) DEFAULT_SERVICE_LISTENER = (XE) Open ( tnsnames .ora) with notepad and replace HOST address with your localhost or current-ip address. e.g XE =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST =  localhost )(PORT = 1521))     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = XE)     )   ) Open your command prompt as adminstrator and run  lsnrctl start NB: You might have to map localhost to 127.0.0.1 in the C:\Windows\System32\drivers\etc\host file by adding   127.0.0.1       localhost