what is Host String?

[nan sh]

I install Oracle8i on my Window98 machine, use default setting.
When I open SQLPlus, it ask for user id, password and Host String
what is host string? whatever I type in, I cannot logn in.
Anybody know what is host string?
Thanks

[Desai Sandeep]

Hi Nan,
It is support to be your System Identifier (SID), which you would have specified while installation.
I suppose by default it is oracle.I am not very sure, but you can confirm this.Alternatively, you can try scott as user name and tiger as password without Host String entry.I think it should work.
HTH,
Sandeep

[Rob Lyon]

You can also look in the 'tnsnames.ora' network configuration file found in the oracle/ora81/network/admin folder. That will list all the SID's and atributes associated with them.

[nan sh]

HI Desai, Rob and all,
Thanks for help,
The following is my tnsname.ora file
**********************************
# C:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:c:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Net8 Assistant
MYORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
)
(CONNECT_DATA =
(SERVICE_NAME = MYORACLE)
)
)
******************************
When I use SYSTEM/MANAGER/MYORACLE as log on, I've got ;
ERROR
ORA-12560: TNS rotocol adapter error
I can get the same error message, if I try connection test.
I bought the Book "Using Oracle8/8i" from QUE.
The Software is from the CD with the book.
I don't know what is wrong.

[Desai Sandeep]

Nan,
A few check points...

1. Windows 98 I believe supports only Oracle 8i Personal Edition.Is this the version you are using.
   
2. Have you tried SCOTT/TIGER/MYORACLE for connect?Did you get any errors while connecting?
   
3. If it is still not running, check if the TNSListener service in your Windows 98 is "Started".If not, you need to configure the TNS listener again.
   
4. If you still have problems, ensure that you did not get unsuccessful completion of certain services while installed the product
   

If the last 2 points are true, I suggest you install the product once again.It is a cumbersome process to find out what is actually going wrong.
Hope this helps,
Sandeep

[Adam Adams]

it is you database instance name

Originally posted by nan sh:
I install Oracle8i on my Window98 machine, use default setting.
When I open SQLPlus, it ask for user id, password and Host String
what is host string? whatever I type in, I cannot logn in.
Anybody know what is host string?
Thanks

[nan sh]

HI ALL,
The real problem for me is not enough memory, when I reinstall the software again, I saw the error message saiy not enough menory, I am going to buy memory chip at weekend, and try again.
I will let you know results.

[nan sh]

HI Desia and all,
I added more memory in my computer and tried to reinstall Oracle 8i, and I got the following error messages, I clicked ignore button for all of them, at the end I still cannot log in.
*****************
ORA-00101 Invalid specification for system parameter MTS_DISPATCHERS
************************
ORA-00102 network protocal(ADDRESS=PARTIAL=YES)(PROTOCOL=TCP))
***************************************
ORA-01034 ORACLE not available
***********************************
ORA-01012 not logged on

I feel like something wrong with my NT workstation, particular in network area. Do you have any idea, what is wrong?

[Bashir Mirzad]

Hi sh
try to login with out the host name just type
scott/tiger I hope it work
[This message has been edited by Bashir Mirzad (edited December 09, 2001).]

[Desai Sandeep]

Hi,
It seems that there is some problem with the installation of network protocol on your machine.Ensure that TCP/IP protocol is installed properly.I have never encountered the protocol problem before.
You usually get problem with installation (particularly when you have installed once unsuccessfully!) if there are some entries which has been made in the Windows NT registries.I will suggest you type "regedit" in the Start --> Run and then in the Registry Editor delete any TNSListeners or information that is related to Oracle 8i installation by going to HKEY_LOCAL_MACHINE --> SOFTWARE path.
Will keep you informed if I happen to get any further assistance on this problem.
Regards,
Sandeep

[nan sh]

Hi Desai and all,
I fixed my problem, that is, my Nt Workstation did not setup TCP/IP and RAS(Romte Access Service) properly.
I have to format the disk, reinstall worstation and Oracle, now it's fine.
Thank you for your help.

[niranjan apte]

I install oracle 8i when I type user name & password it ask for host string
I came to know SID but how do u get sid? what do I have to type in host string title

[hemadri saxena]

Hi all,

I am unable to login to SQL Plus

I am trying to login as ias_admin user and host string itnnodemgr1

# tnsnames.ora Network Configuration File: C:\OraHome_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = itnnodemgr1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.ARICENT)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = itnnodemgr1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)