Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Connecting
I assume that the connection is being done to a local database....right?
Oracle applications will default to the local database, perhaps the third
party tool you are using does not.
Check to see that the SID is in your CONNECT_DATA in your tnsnames.ora file.
hth,
-- Joseph Ranseth - Webmaster World Cup Fishing http://www.worldcupfishing.com "Waldo Ricketts" <wricketts_at_mncppc.state.md.us> wrote in message news:t7dgess7fk0734_at_corp.supernews.com...Received on Tue Jan 30 2001 - 12:41:53 CST
> I'm having problems connecting, I get the error ORA-12504:TNS:Listener was
> not given the SID in connection, I have no problems win I run tnsping, or
> when I run SQL+ I only get this error when I try to connect using a third
> party application, is this a problem with the way I have Oracle setup or
> do you think it is with the third party application. Thanks
>
> --
> Posted via CNET Help.com
> http://www.help.com/
![]() |
![]() |