Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Designer: Connect string
If you config your tnsnames.ora properly, you should not worry about
hostname, port id or even instance name. How do you connect to the
database via your other tools?
It should be something like this in sqlplus:
username/password_at_ABC
or in TOAD, what do you put in the filed 'Database'?
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.
Frank van Bortel wrote:
> Jens Lenge schreef:
> > Frank van Bortel wrote:
> >
> >> vanbortel.blogspot.com - search for the Network Blues
> >
> > Hmmm... that refers to SQL Plus and involves manual editing of config
> > files and/or environment variables.
> >
> > Maybe I am just a little blind, but I did not find how the GUI-"connect
> > string" for Designer must be composed of host IP, port, and SID.
> >
> > Could you please give a little example (such as "<host>:<port>:<sid>"
> > or something like that)?
> >
> > Jens
> >
> And building some understanding of what is going on, actually.
>
> Did you try host:port:sid?
>
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
Received on Fri Jul 14 2006 - 11:08:15 CDT