|
|
|
|
|
|
| Author |
Message |
frank.van.bortel@gmail.co
*nix forums Guru
Joined: 11 Sep 2005
Posts: 832
|
 Posted: Fri Jul 14, 2006 7:38 am Post subject:
Re: Oracle Designer: Connect string
|
|
|
Jens Lenge schreef:
| Quote: | 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
vanbortel.blogspot.com - search for the Network Blues |
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up... |
|
| Back to top |
|
 |
Jens Lenge
*nix forums beginner
Joined: 09 Mar 2006
Posts: 20
|
| Posted: Fri Jul 14, 2006 7:55 am Post subject:
Re: Oracle Designer: Connect string
|
|
|
Frank van Bortel wrote:
| Quote: | 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 |
|
| Back to top |
|
|
sybrandb
*nix forums beginner
Joined: 13 Jul 2006
Posts: 22
|
| Posted: Fri Jul 14, 2006 8:17 am Post subject:
Re: Oracle Designer: Connect string
|
|
|
Jens Lenge wrote:
| Quote: | 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
|
There is no difference in connection to sql*plus as compared with
Designer, all Oracle products connect in the same fashion.
Could please start reading docs, instead of boring this forum to dead
with your FAQS, for which you could easily find the answer, if you
weren't so lazy?
--
Sybrand Bakker
Senior Oracle DBA |
|
| Back to top |
|
|
Jens Lenge
*nix forums beginner
Joined: 09 Mar 2006
Posts: 20
|
| Posted: Fri Jul 14, 2006 8:40 am Post subject:
Re: Oracle Designer: Connect string
|
|
|
sybrandb wrote:
| Quote: | There is no difference in connection to sql*plus as compared with
Designer, all Oracle products connect in the same fashion.
|
I am quite used to Oracle SQL Developer ("Raptor").
It does not ask for a connect string, but host id, port, and SID.
As this actually is the required information, I guess the "connect
string" used by Designer must be composed of these parts.
| Quote: | Could please start reading docs, instead of boring this forum to dead
with your FAQS, for which you could easily find the answer, if you
weren't so lazy?
|
I referred to the documentation and also asked Google but did not find
the composition syntax. If you had followed this thread you would have
noticed that I did also read the Network Blues blog I was directed to.
While the blog does confirm that the above data is relevant for
connecting to a remote database, it does not say how to compose the
connect string that Designer asks for, at least if I did not miss it.
Sorry if you feel bored. If my question is a FAQ, it would have been
enough to simply direct me to the URL of the FAQ of this group. If you
do not want to answer, you may feel free to ignore my post. But please
do not confuse being a newbie with laziness.
Jens |
|
| Back to top |
|
|
sybrandb
*nix forums beginner
Joined: 13 Jul 2006
Posts: 22
|
| Posted: Fri Jul 14, 2006 9:03 am Post subject:
Re: Oracle Designer: Connect string
|
|
|
Jens Lenge wrote:
| Quote: | sybrandb wrote:
There is no difference in connection to sql*plus as compared with
Designer, all Oracle products connect in the same fashion.
I am quite used to Oracle SQL Developer ("Raptor").
It does not ask for a connect string, but host id, port, and SID.
As this actually is the required information, I guess the "connect
string" used by Designer must be composed of these parts.
Could please start reading docs, instead of boring this forum to dead
with your FAQS, for which you could easily find the answer, if you
weren't so lazy?
I referred to the documentation and also asked Google but did not find
the composition syntax. If you had followed this thread you would have
noticed that I did also read the Network Blues blog I was directed to.
While the blog does confirm that the above data is relevant for
connecting to a remote database, it does not say how to compose the
connect string that Designer asks for, at least if I did not miss it.
Sorry if you feel bored. If my question is a FAQ, it would have been
enough to simply direct me to the URL of the FAQ of this group. If you
do not want to answer, you may feel free to ignore my post. But please
do not confuse being a newbie with laziness.
Jens
|
It is quite clear you *ARE* lazy, as you request to be spoon-fed and
don't want to search the docs.
You don't NEED to composition syntax, and setting up tnsnames.ora is
perfectly valid.
I guess the German people still didn't change since World War II.
--
Sybrand Bakker
Senior Oracle DBA |
|
| Back to top |
|
|
Jens Lenge
*nix forums beginner
Joined: 09 Mar 2006
Posts: 20
|
| Posted: Fri Jul 14, 2006 9:21 am Post subject:
Re: Oracle Designer: Connect string
|
|
|
sybrandb wrote:
| Quote: | [perfectly useless fullquote removed]
|
http://learn.to/quote/
| Quote: | It is quite clear you *ARE* lazy, as you request to be spoon-fed and
don't want to search the docs.
|
I see. Had a bad day? Why didn't you say in the first place that you
just want to bother and do not care about content?
| Quote: | I guess the German people still didn't change since World War II.
|
Don't know, not my time.
Germans obviously do not have a monopoly on ignorance. |
|
| Back to top |
|
|
Maxim Demenko
*nix forums Guru
Joined: 24 Apr 2005
Posts: 428
|
| Posted: Fri Jul 14, 2006 11:41 am Post subject:
Re: Oracle Designer: Connect string
|
|
|
sybrandb schrieb:
| Quote: | Jens Lenge wrote:
sybrandb wrote:
There is no difference in connection to sql*plus as compared with
Designer, all Oracle products connect in the same fashion.
I am quite used to Oracle SQL Developer ("Raptor").
It does not ask for a connect string, but host id, port, and SID.
As this actually is the required information, I guess the "connect
string" used by Designer must be composed of these parts.
Could please start reading docs, instead of boring this forum to dead
with your FAQS, for which you could easily find the answer, if you
weren't so lazy?
I referred to the documentation and also asked Google but did not find
the composition syntax. If you had followed this thread you would have
noticed that I did also read the Network Blues blog I was directed to.
While the blog does confirm that the above data is relevant for
connecting to a remote database, it does not say how to compose the
connect string that Designer asks for, at least if I did not miss it.
Sorry if you feel bored. If my question is a FAQ, it would have been
enough to simply direct me to the URL of the FAQ of this group. If you
do not want to answer, you may feel free to ignore my post. But please
do not confuse being a newbie with laziness.
Jens
It is quite clear you *ARE* lazy, as you request to be spoon-fed and
don't want to search the docs.
You don't NEED to composition syntax, and setting up tnsnames.ora is
perfectly valid.
I guess the German people still didn't change since World War II.
|
IMHO, you could safely ignore Sybrand's remark about German people.
It would be wise, however, if you not ignore his remarks about searching
( and , much more important, reading) the docs.
The Oracle Documentation is pretty comprehensive, well organized and has
excellent search functionality. So, one can easily be suspictious about
not finding in the documentation nothing about connect string . If i
start at
the high level entry for documentation - http://tahiti.oracle.com/ - and
enter in the search form "connect string" - i will come to the next page
immediately, which says 416 matches across 95 books for 10gR2 ( you can
choose the appropriate Oracle version ) and suggest to search further in
that library. Accept suggestion and you get to the next page, which
lists matches for different books. The most matched topics (except Error
Messages) - 33 - has Net Services Administrator's Guide. That complies
with the common sense as well - one will expect "connect string" to be
network related.
You go there and among first matches see Chapter: 3 Connectivity
Concepts. And here begins the part which is complementary to the
documentation search - the reading of documentation.
Unfortunately, you should do it yourself, probably more than one time,
then you have not a couple of recipes but understanding, how it works.
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.
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).
Best regards
Maxim |
|
| Back to top |
|
|
frank.van.bortel@gmail.co
*nix forums Guru
Joined: 11 Sep 2005
Posts: 832
|
| Posted: Fri Jul 14, 2006 1:13 pm Post subject:
Re: Oracle Designer: Connect string
|
|
|
Jens Lenge schreef:
| Quote: | 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... |
|
| Back to top |
|
|
akkha1234@gmail.com
*nix forums beginner
Joined: 19 Apr 2006
Posts: 14
|
| Posted: Fri Jul 14, 2006 4:08 pm Post subject:
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@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:
| Quote: | 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... |
|
|
| Back to top |
|
|
Robbert van der Hoorn
*nix forums beginner
Joined: 29 Jun 2006
Posts: 16
|
| Posted: Fri Jul 14, 2006 11:06 pm Post subject:
Re: Oracle Designer: Connect string
|
|
|
"Jens Lenge" <spampot@gmx.net> wrote in message
news:1152862001.548362.8190@b28g2000cwb.googlegroups.com...
| Quote: | 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 |
|
| Back to top |
|
|
Jens Lenge
*nix forums beginner
Joined: 09 Mar 2006
Posts: 20
|
| Posted: Mon Jul 17, 2006 10:18 pm Post subject:
Re: Oracle Designer: Connect string
|
|
|
"Frank van Bortel" <frank.van.bortel@gmail.com> wrote:
| Quote: | 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 |
|
| Back to top |
|
|
Jens Lenge
*nix forums beginner
Joined: 09 Mar 2006
Posts: 20
|
| Posted: Mon Jul 17, 2006 10:24 pm Post subject:
Re: Oracle Designer: Connect string
|
|
|
<akkha1234@gmail.com> wrote:
| Quote: | 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.
| Quote: | 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 |
|
| Back to top |
|
|
Jens Lenge
*nix forums beginner
Joined: 09 Mar 2006
Posts: 20
|
| Posted: Mon Jul 17, 2006 10:25 pm Post subject:
Re: Oracle Designer: Connect string
|
|
|
"Robbert van der Hoorn" <removetheXinR.Xvanderhoorn@osait.nl> wrote:
| Quote: | 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 |
|
| Back to top |
|
|
Jens Lenge
*nix forums beginner
Joined: 09 Mar 2006
Posts: 20
|
| Posted: Mon Jul 17, 2006 11:11 pm Post subject:
Re: Oracle Designer: Connect string
|
|
|
"Maxim Demenko" <mdemenko@arcor.de> wrote:
| Quote: | 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.
| Quote: | 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.
| Quote: | 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.
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.
| Quote: | 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 |
|
| Back to top |
|
|
Robbert van der Hoorn
*nix forums beginner
Joined: 29 Jun 2006
Posts: 16
|
| Posted: Tue Jul 18, 2006 8:55 am Post subject:
Re: Oracle Designer: Connect string
|
|
|
"Jens Lenge" <Spampot@gmx.net> wrote in message
news:e9h2me$sft$03$1@news.t-online.com...
| Quote: | akkha1234@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 |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Fri Nov 21, 2008 12:12 pm | All times are GMT
|
|
Remortgaging | Free Ringtones | Auto Loans | Mortgage Calculator | Online Advertising
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
