Home » Infrastructure » Windows » Oracle gets connected without host String
Oracle gets connected without host String [message #193429] Sat, 16 September 2006 13:35 Go to next message
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member

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.

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 messageGo to next message
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member

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.

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
Messages: 21146
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")
Previous Topic: Oracle 8i Personal Edition problem
Next Topic: Oracle 10g Express for Windows on a USB key
Goto Forum:

Current Time: Wed Aug 16 16:54:13 CDT 2017

Total time taken to generate the page: 0.12675 seconds