Need help "HOST STRING"

[naasash1]

Hi ,
I have been able to install Oracle 8i on my laptop, but when ever I use 'scott' and 'tiger' I get an error message. Because the Host string text field is blank and I don't know what to put in the textfield. Can anyone please help.

 

[donkeyhote]

Where / how are you trying to connect?

The host string should be whatever was set up in tnsnames.ora file (created when you install or modified when you add a new connection to a database) which is in your Oracle directory /instance / network / admin

Hope that helps.

 

[naasash1]

Thank you donkeyhote,

I connect through the sql+ icon on my desktop. I followed the path you stated but it still didn't work. Can you give me an example of what I need to write in the host strng field.

 

[donkeyhote]

OK firstly did you find your tnsnames.ora file (on your pc with the sql+ icon on it)?
if so in the directory where you found it there should also be a sqlnet.ora file

This sets up any default 'Domains' so that might be in tek-tips.co.uk format if you have it set up.

in tnsnames.ora you should have entries like this
ORATST.tek-tips.co.UK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oratst.tek-tips.co.uk)(PORT = 1521))
)
(CONNECT_DATA =
(SID = iasdb)
)
)

so on to connect to sql+

double click on the icon should give a window with 3 fields for entry by you - Username Password and HostString

For the example given above I could use

Scott
Tiger
and
ORATST

Note the last one because I have my default domain set in my sqlnet.ora file if not you migh have to enter in the format

ORATST.tek-tips.co.uk obviously replacing my example with your real world name

In effect you have to try to connect to the hostname where your database exists (usually port 1521) hence the connection info in tnsnames

Hope that helps

 

[naasash1]

Hi

Thank you once again. I have made a few changes in my tnsnames.ora. Now when I enter scott, tiger and host string name which is the name of my computer. I get the TNS: error message which says "No Listerner"

 

[donkeyhote]

Hmm I think I need to know more about what your OS is - have you installed AS on the same 'box'as where you are trying to access the database from?
What is the OS of the box where you installed the DB - what is the OS (Windows??) of the box from where you are trying to connect.

Can you confirm that your Oracle listener is started?
It is a service.

If you run sqlplus from a command line of the machine which has Oracle installed on it can you connect to the database?
as sysdba or scott tiger - if not then I strongly suspect that the database listener won't be started.

I'm running out of options now

 

[naasash1]

Thanks,

I am running Windows XP pro. Anyway I will try and play around some more with it and see if it will work. Thanks for your help.