Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Personnal Oracle 8 - Cannot create a connection service ? Help!
I have 3 tnsnames.ora.
C:\orant\net80\admin C:\orant\net80\admin\sample C:\orant\net80\tnsapi
I've set the TNS_ADMIN variable as you told me... No change :( If I ping my IP with the TNSPING80 utility, I got a "No listener" ... If I take a look at the service utility under Windows 2000 Pro, I don't see nothing like Oracle, is it normal?
"news" <support_at_javautil.com> a écrit dans le message news:
aDYK5.47717$%t3.2691720_at_news1.rdc1.tx.home.com...
> Do you have more than one tnsnames.ora?
> If multiple products are installed this frequently occurs.
>
> Although oracle doesn't recommend it on WINTEL the TNS_ADMIN environment
> variable works as well
> on NT as it does on unix.
> TNS_ADMIN=d:\orant\net80\admin
>
> or where the desired tnsnames.ora file is located.
>
> delete all of the others.
>
> do you have a sqlnet.ora file?
> do you have tnsping installed?
>
> "Christian Hamel" <christianhamel_at_sympatico.ca> wrote in message
> news:SgXK5.402426$1h3.10795739_at_news20.bellglobal.com...
> > Hi,
> > I've just installed Personnal Oracle 8i on my desktop (Win2000 Pro).
It
> > install POlite as a default database. I created a new one, let's call
it
> > MyDB. If I check in the ODBC Adminstration under Windows2000, it
created
a
> > POLite Data source with a driver Oracle Lite 40 ODBC Driver. So I
created
> > an exactly one for MyDB. If I go with Excel -> Microsoft Query, I can
> > easily access my new created MyDB and extract the data from it.
> > My problem is that I cannot access it from SQL Plus. I tried to
define
> > a new service with Oracle Net8 Easy Config but it doesnt work. MyDB is
> > local on my PC, so I tried to define different type of Service, IPC
Local,
> > Bequeath, and evenly TCP/IP using my local IP. It never connect when I
try
> > to test my new connection. I created a user in my database. So I try
to
> > connect with my new user created and I try with the user SYSTEM too for
> > which I didnt change the default password that is blank..
> > Any help and idea would be greatly appreciated. Thanks!
> >
> >
> >
>
>
Received on Sun Oct 29 2000 - 11:05:27 CST