Hello everybody and thanks in advance for your time and help. Im a newbie and greatly appreciate it.
I know this error is common in the forums but no one seems to be able to explain a clear effective solution or root cause. Im not ungrateful, its just nothing is working or their steps are unclear. I have installed, uninstalled and reinstalled XE four times now and still have the same problem.
Im trying to run XE 11g on Windows 7 home 64-bit. I have installed the database and it is up and running according to the SQL cmd line output.
When I installed XE using the Install wizard I left all the default settings. The Port for the Oracle Database listener was 1521 and the port for the Oracle HTTP listener was 8080.
When I try to connect to the database using SQL developer I get the following error:
Status:Failure -Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently know SID given in connect descriptorThe Connection descriptor used by the client was:localhost:1521:XE
And when I click the Get Started shortcut to access the Admin Console I get the following error:
Oops! Google Chrome could not connect to 127.0.0.1:8080
I ran the following commands to look at what might be the root cause. I have also included the listener.ora and tsnames.ora file contents below.
C:\Users\mgann>ping localhost
Pinging AST-867mgann.ast.com [::1] with 32 bytes of data:
Reply from ::1: time<1ms
Reply from ::1: time<1ms
Reply from ::1: time<1ms
Reply from ::1: time<1ms
Ping statistics for ::1:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
C:\Users\mgann>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 25-JUN-2014 15:02
:38
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Produ
ction
Start Date 25-JUN-2014 14:55:41
Uptime 0 days 0 hr. 6 min. 56 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\AST-867mgann\liste
ner\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=AST-867mgann.ast.com)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
The listener.ora file:
SID_LIST_LISTENER =
(SID_LIST =
(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 = AST-867mgann.ast.com)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
The tsnames.ora file:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = AST-867mgann.ast.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
Thanks again for the help!