Cannot connect to XE after following "How To" Windows XP Pro SP2
515424Jun 2 2006 — edited Jun 4 2006Hi Sharon and everyone,
I have read all related posts, the how-to and tried many times including restarting XE but still cannot connect using SQL Developer. I already have a small schema created using ths SQL Window of XE and can connect using "Toolkit for Oracle" (though this behaves erratically and I don't like it so far). I have succesfully connected also using the XE ODBC Driver from MS Access and INSERTED Rows in a table in the Schema.
I want to use SQL Developer but I get the following message when trying to connect (this PC is Server and Client) :
"Status : Failure -Listener refused the connection with the following error:ORA-12505, TNS:listener does not know of SID given in connect descriptorThe Connection decriptor used by the client was:127.0.0.1:1521:xe"
Inputs used :
Username : system
Password : *******
Basic Tab :
Hostname: 127.0.0.1
Port: 1521
SID: XE
TNS TAB:
Network Alias: "XE" (this is the default and there is no mention in the How-To of overriding it at all ! )
If I change the Network Alias to "EXTPROC_CONNECTION_DATA" or "ORACLR_CONNECTION_DATA" I get the same message.
If I try using "Service Name" instead of "SID" I get a similar message but with "does not currently know of service requested". ( All 3 Network Alias values tried)
Please can you help me ?