I have a 184.108.40.206 instance that is an RMAN restore from a DB with a different name. The listener reports it as:
Service “olddb” has 1 instance(s).
Instance “newdb”, status READY, has 1 handler(s) for this service…
So, I created a connection in 64-bit Toad 220.127.116.11 under Win7 using the Direct method, but checking “SID” instead of the default of “Service Name” and specifying “newdb” for that SID. This works great except when using the “New Connection” button dropdown and selecting this connection. Then it fails with the fun “ORA-12514: TNS: listener does not currently know of service requested in connect descriptor.”
I’d try the beta (oh, how I miss it so!), but time’s uber-tight right now with new hardware, installs, data copies, and general chaos. CHAOS, I tell you! CHAOS!