Oracle gets connected without host String [message #193429] |
Sat, 16 September 2006 13:35 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ab_trivedi
Messages: 460 Registered: August 2006 Location: Pune, India
|
Senior Member |
|
|
Hi,
I have Oracle 8i personal edition installed in Windows 98.Now the problem is that ' I can connect to Oracle only giving username/password' but when I give the hoststring then it gives problem.
I have also modify TNSNAMES.ORA but no use of it.
How this is happening, I mean is it that the Oracle is taking taking default host string? Or what. If it is taking taking the default one then how am I come to know that what is the Host String.
Regards
Ashutosh Trivedi
|
|
|
Re: Oracle gets connected without host String [message #193432 is a reply to message #193429] |
Sat, 16 September 2006 14:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
kimant
Messages: 201 Registered: August 2006 Location: Denmark
|
Senior Member |
|
|
Hi
You are missing some details, like how You connect, which applicatio nYou are connecting from, where You are connecting from (I assume the same machine as the database resides on), what happens when it does not work etc.
Br
Kim
|
|
|
Re: Oracle gets connected without host String [message #193443 is a reply to message #193432] |
Sat, 16 September 2006 15:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
If you installed only one database and it is the only one in the TNSNAMES.ORA file, it will be a default one. Using database alias in connection string will raise an error if it is not fully specified - check the SQLNET.ORA for the default extension (could be "world", for example; in that case, you'd use such a connection string: "scott/tiger@ora8.world")
|
|
|