Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [Oracle 10g 10.1.0.2] TNS:listener does not currently know of service requested in connect
Thanks, it works if I use sqlplus scott/tiger_at_cambridg it works but if you
check
http://forums.oracle.com/forums/thread.jspa?forumID=220&messageID=960520&thr
eadID=303267
you will see that it seems to be a problem with oracle 10g.
However i am connecting through jdbc:
conn = DriverManager.getConnection ("jdbc:oracle:thin:@" + server + ":" + port + ":" + base, user, pwd);
that is why i want to get the sqlplus connection under DOS working.
I need the localhost + port as well.
Unless there is another getConnection method that only takes user, pwd and base ?
"Randy Harris" <randy_at_SpamFree.com> a écrit dans le message de news:
tjMGe.2882$aT1.1590_at_newssvr19.news.prodigy.com...
>
> "mike henkins" <dd_at_nospam.com> wrote in message
> news:42eb8c51$0$3132$8fcfb975_at_news.wanadoo.fr...
> > Thanks. I modified it like your example:
> >
> [snip]
>
> > I still get the same boring and annoying error :
> > C:\Documents and Settings\bob>sqlplus
scott/tiger_at_localhost:1521:cambridg
> >
> > SQL*Plus: Release 10.1.0.2.0 - Production on Sam. Juil. 30 16:18:22 2005
> >
> > Copyright (c) 1982, 2004, Oracle. All rights reserved.
> >
> > ERROR:
> > ORA-12514: TNS:listener does not currently know of service requested in
> > connect descriptor
> >
> > Any suggestion please ?
>
> Do you still get the same error if you use scott/tiger_at_cambridg as the
> connect descriptor?
>
Received on Sat Jul 30 2005 - 09:50:53 CDT