Prev: SQLPLus and Linux (Gentoo) - tnsnames problem
Next: Oracle 64 bit ODBC dirver
From: Robbert van der Hoorn on 18 Jul 2006 04:55

"Jens Lenge" <Spampot(a)gmx.net> wrote in message
news:e9h2me$sft$03$1(a)news.t-online.com...
> <akkha1234(a)gmail.com> wrote:
>
> > How do you connect to the
> > database via your other tools?
>
> With Oracle SQL Developer, I just enter the host IP, port number, and SID
> (and username/password, of course). It can then connect successfully.
>
> But I guess SQL Developer does not refer to tnsnames.ora, while Designer
> probably does.
>
> > Then stick the ABC or the database field as the connect string. Then
> > you are good.
> > If you get an error, this means your tnsnames.ora is not correct. This
> > would be a different issue.
>
> I suspect you are right and my tnsnames.ora is not properly configured. I
> was only using Oracle SQL Developer before I installed Designer (as part
of
> the suite). I will check this next week when I'm back at work again.
>
> Jens
>

If you're using more than one Oracle product, they may be installed in
different Oracle home directories.
You have two ways of solving tnsnames problems:

1) Find a working product, and copy the tnsnames.ora from its home directory
to the other home,or
2) set an (system) environment variable TNS_ADMIN pointing to the directory
of the working product, hence all other products will use this directory
too; usally it's something like c:\[oracle_home_name]\network\admin


Robbert


First  |  Prev  | 
Pages: 1 2 3
Prev: SQLPLus and Linux (Gentoo) - tnsnames problem
Next: Oracle 64 bit ODBC dirver