Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem connecting to 8i on same machine

Re: Problem connecting to 8i on same machine

From: <elrudi_at_my-deja.com>
Date: Wed, 29 Nov 2000 12:31:50 GMT
Message-ID: <902svm$npc$1@nnrp1.deja.com>

WebDB has its own tnsnames.ora. Check your path-variable or set a vriable called tns_admin with the path to the right tnsnames.ora.

greetings from germany
rudi

In article <3a1428f6.1306433772_at_news.earthlink.net>,   andreyNSPAM_at_bookexchange.net (NetComrade) wrote:
> is your listener listening on tcp?
>
> NEW_LISTENER =
> (ADDRESS_LIST =
> (ADDRESS= (PROTOCOL= TCP)(Host= sydney)(Port= 1522))
> )
> SID_LIST_NEW_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (ORACLE_HOME= /opt/oracle/product/816)
> (SID_NAME = WHSE)
> )
> )
>
> On Mon, 13 Nov 2000 09:31:28 +0100, "Peter" <P.Slingerland_at_IMN.nl>
> wrote:
>
> >Hello all,
> >
> >I'm having trouble connecting to my Oracle 8i (8.1.5) database on NT
> >from Enternprise Manager client applications and WebDB on the same
> >machine.
> >
> >I've installed Oracle 8i (default install). The database is running
 fine.
> >Then I
> >install the Enterprise Manager client applications (storage manager,
> >security
> >manager etc.) on the same machine. This installation creates a new
 Oracle
> >home (as expected) Then when I'm trying to configure sqlnet for this
 new
> >Oracle Home I get the TNS-12203 Error (TNS:unable to connect to
 destination)
> >message. I can still connect to the database using sqlplus in the 8i
> >home\bin directory.
> >Similar problems occur when installing WebDB.
> >
> >When I perfom the same client installation steps on another NT
 machine, and
> >try to
> >connect to 8i on the first machine things work fine.
> >
> >Is there anyone who experienced the same problems and solved them?
 Please
> >inform
> >me.
> >
> >Thanks,
> >
> >
> >Peter.
> >
> >
> >
> >
>
> ---------------
> In case I forgot to mention:
> We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 29 2000 - 06:31:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US