ORA-1205, TNS:listener does not currently know of SID... sqldeveloper
I'm trying to use sqldeveloper for the first time on a new installation of 11g on Windows XP 32 bit.
I believe the database is up and running because it looks good from https://localhost:1158/em
What is a SID? How do I know what my SID is? sqldeveloper defaults to "xe".
So when I run sqldeveloper and try to log in, I specify SYSTEM as the username, I give my passoword, I use the defaults for role, connection type. Port is 1521 and SID is XE.
And I get
"Status: Failure - Test Failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor"
So I google searched and tried:
$ ./tnsping.exe global
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 07-JAN-2011 17:04:36
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
C:\app\siegfried\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
TNS-03505: Failed to resolve name
OK, what was I supposed to put there? The other example used global, but I don't know what that is.
I tried telnet localhost 1521 and it just skips a blank line and returns to the command prompt.
So what am I doing wrong and how do I do it right?
Thanks!
Siegfried