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

"Jens Lenge" <spampot(a)gmx.net> wrote in message
news:1152862001.548362.8190(a)b28g2000cwb.googlegroups.com...
> Hello world,
>
> when I try to make Oracle Designer connect to a database, it will ask
> for username, password, and some strange "connect string".
>
> While I do know the host IP, port number, and SID of the database, I
> have no idea what the "connect string" must look like.
>
> Who can help?
>
> Jens
>

Find your TNSNAMES.ORA filie in [oracle_designer_home]\network\admin
Somewhere there should be an entry like
ABC = ....... pointing to your designer database.
Just use this entry ABC (whatever is there..) as connect string.
This should work.

TIA

Robbert



From: Jens Lenge on 17 Jul 2006 18:18
"Frank van Bortel" <frank.van.bortel(a)gmail.com> wrote:

> Did you try host:port:sid?

Yes, that was actually my first guess.
But it did not work with Designer.

I then checked the availability of the DB with Oracle SQL Developer, which
could successfully connect to the DB using the same host, port, and IP.

Therefore I believed that I was just using the wrong syntax for the "connect
string".

From the replies I got until now, I now believe that Designer just CANNOT
connect using a single connect string that contains host, port, and IP.
Instead, I need to edit the "tnsnames.ora" file before. Did I understand
that right?

Jens

From: Jens Lenge on 17 Jul 2006 18:24
<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

From: Jens Lenge on 17 Jul 2006 18:25
"Robbert van der Hoorn" <removetheXinR.Xvanderhoorn(a)osait.nl> wrote:

> Find your TNSNAMES.ORA filie in [oracle_designer_home]\network\admin
> Somewhere there should be an entry like
> ABC = ....... pointing to your designer database.
> Just use this entry ABC (whatever is there..) as connect string.
> This should work.

Thanks for the hint, I will try. It may well be that the tnsnames.ora itself
it not properly configured; I'll need to check.

Jens

From: Jens Lenge on 17 Jul 2006 19:11
"Maxim Demenko" <mdemenko(a)arcor.de> wrote:

> IMHO, you could safely ignore Sybrand's remark about German people.

Sorry if I over-reacted. I just don't like ignorance, and I even like it
worse when combined with racism.

> It would be wise, however, if you not ignore his remarks about searching
> ( and , much more important, reading) the docs.

You're definitely right. (I am a newbie to Oracle, but I'm not new to
usenet. I know that before posting a question, one should first see the docs
then search Google or something.)
In this case, I have first looked into the manual that came with Designer,
where they explain the username and password fields, but only refer to the
connect string field saying "enter the connect string here". I then used
Google for the Oracle Designer connect string, but only found some articles
about how to avoid having to enter a connect string, but no explanation of
the string itself. Then I posted my question here.

> You should not be surprised however, that people here will feel annoyed,
> if you try to compel somebody to do *your* job for free. (And reading
> documentation is definitely *everybody*'s own job).

Again you're perfectly right. However, if one single person starts offending
others without any helpful contents and still ignores the facts after they
have been named, he should not be surprised be get an appropriate answer.
That's usenet. ;o)

I had replied to Sybrand's first post that I DID look into the manual
before, but he just insisted to place some unsubstancial offenses.

> If i start at the high level entry for documentation -
> http://tahiti.oracle.com/

Thank you very much for this link! I admit I did not know it and therefore
did not search it before. I referred to the helpfiles and manual that came
with Designer.

> If you still don't understand some things, you can always post here the
> quote from manuals ( trying to be as precise as possible ), most likely
> you'll get polite and comprehensive explanations.

Once again you're right. Just as I got a couple of truly helpful replies to
this thread, like yours.

BTW: IMO even saying "RTFM" is perfectly okay and still helpful when put
together with some explaning words and an appropriate link or something.

I hope I could clarify a bit.
Thanks again for your explanations and the tahiti link!

Jens


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