help open sqlplus

I just download Oracle9i Database Release 2 Enterprise/Standard/Personal Edition
from oracle  web site 3 download I am trying to open sqlplus

It is ask me for

User Name ______

Host string_______

I tried to use User scott and password tiger

is there another way user and password?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


User system and password manager

jamesccnacmpAuthor Commented:
what about the host string?

If it is the personal edition it would probably by 2: or blank.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

jamesccnacmpAuthor Commented:
type in the number  2 or type in blank, the user and password is not allow me in?


(number 2 and colon)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jamesccnacmpAuthor Commented:
No it just kick me out I type

user: system
password: manager
Host string: 2:

NO, you will have to create a TNS String for your server from "Net Configuration Manager". Give your Machine's IP and the SID being ORCL (this is default, if you haven't chaged anything). Give it's name as "localHost"

No connect to OEM Using,


Mehul ShahIT consultantCommented:
Go to

Oracle Home\network\admin folder

open the tnsnames.ora file and add the below entry

<<DB_NAME> =
      (ADDRESS = (PROTOCOL = TCP)(HOST = <<IP ADDRESS>>)(PORT = 1521))
      (SID = <<DB_NAME>>)

Change the <<DB_NAME>> and <<IP_ADDRESS>> parameter according to your server.

and use the <<DB_NAME>> as the host string.

Hope this helps
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.