aspose file tools*
The moose likes Oracle/OAS and the fly likes what is Host String? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "what is Host String?" Watch "what is Host String?" New topic
Author

what is Host String?

nan sh
Ranch Hand

Joined: Jan 05, 2001
Posts: 167
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


Have you tried this Mock Exam Testing Engine yet?<br /><a href="http://www.mycgiserver.com/~nan111/index.html" target="_blank" rel="nofollow">www.mycgiserver.com/~nan111/index.html</a>
Desai Sandeep
Ranch Hand

Joined: Apr 02, 2001
Posts: 1157
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


<b>Sandeep</b> <br /> <br /><b>Sun Certified Programmer for Java 2 Platform</b><br /> <br /><b>Oracle Certified Solution Developer - JDeveloper</b><br /><b>-- Oracle JDeveloper Rel. 3.0 - Develop Database Applications with Java </b><br /><b>-- Object-Oriented Analysis and Design with UML</b><br /> <br /><b>Oracle Certified Enterprise Developer - Oracle Internet Platform</b><br /><b>-- Enterprise Connectivity with J2EE </b><br /><b>-- Enterprise Development on the Oracle Internet Platform </b>
Rob Lyon
Greenhorn

Joined: Nov 29, 2001
Posts: 7
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
Ranch Hand

Joined: Jan 05, 2001
Posts: 167
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
Ranch Hand

Joined: Apr 02, 2001
Posts: 1157
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

  5. 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
Ranch Hand

Joined: Nov 28, 2001
Posts: 60
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
Ranch Hand

Joined: Jan 05, 2001
Posts: 167
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
Ranch Hand

Joined: Jan 05, 2001
Posts: 167
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
Greenhorn

Joined: Nov 28, 2001
Posts: 25
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
Ranch Hand

Joined: Apr 02, 2001
Posts: 1157
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
Ranch Hand

Joined: Jan 05, 2001
Posts: 167
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
Greenhorn

Joined: Feb 06, 2004
Posts: 1
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
Greenhorn

Joined: Apr 27, 2009
Posts: 2
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)
)
)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: what is Host String?
 
Similar Threads
Is This Stupid?
JDBC ODBC host string
JDBC Connection Problem
Properly Catching an Unknown Host exception
how to find Host Name