This week's giveaway is in the Spring forum.
We're giving away four copies of Learn Spring Security (video course) and have Eugen Paraschiv on-line!
See this thread for details.
Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

what is Host String?

 
nan sh
Ranch Hand
Posts: 167
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1157
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 167
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1157
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 167
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 167
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 25
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1157
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 167
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
)
)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic