Home » Other » General » oRACLE 9i post installaion problem (Oarcle9i, Windows XP OS)
oRACLE 9i post installaion problem [message #387279] Wed, 18 February 2009 13:37 Go to next message
happyjoshua777
Messages: 33
Registered: February 2009
Location: United States
Member
hello,
i was wondering if anyone could help me.
i have just installed Oracle 9i Personal edition on my computer. I have WIndows XP. WHen I try to run SQL+
with USER NAME: SYSTEM
Password: MANAGER
Host String: 0.0.0.0

I get the following error:
ORA-12560: TNS: protocol adapter error

WHen i tried runnin SQL+ again without feeling in any of he above, i clicked on OK and the put in:
USER NAME: SYSTEM
Password: MANAGER

sql+ JUST SHUT down on me.

I did use NEt Config. Assistant and followed all the steps and nothing worked.
please help!
P.S. oRACLE 9i post installaion problem [message #387281 is a reply to message #387279] Wed, 18 February 2009 13:40 Go to previous messageGo to next message
happyjoshua777
Messages: 33
Registered: February 2009
Location: United States
Member
the reason why tried SYSTEM and MANAGER as a user name and password respectively is because i have read in the documentation that these are the default ones. Smile
Re: oRACLE 9i post installaion problem [message #387282 is a reply to message #387279] Wed, 18 February 2009 13:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Host String: 0.0.0.0
Obvisouly wrong.

I suggest you use command line sqlplus to access DB.

>Oracle 9i
V9 has not been supported this century.
I suggest a current/supported Oracle version.
Re: oRACLE 9i post installaion problem [message #387284 is a reply to message #387279] Wed, 18 February 2009 13:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I suggest you to read "Getting Started" documents at http://www.oracle.com/pls/db102/portal.portal_db?selected=1

Regards
Michel
Re: oRACLE 9i post installaion problem [message #387285 is a reply to message #387279] Wed, 18 February 2009 13:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
If the database is local and you have only one database,
there no need use host string.
Just sqlplus username/password should work.
Ofcourse, use the latest version. 9i is dead.
Re: oRACLE 9i post installaion problem [message #387291 is a reply to message #387282] Wed, 18 February 2009 14:41 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
BlackSwan wrote on Wed, 18 February 2009 20:44

V9 has not been supported this century.



Actually, V9 was supported until July 2007, and is still in extended support until 2010.

So it was/is very much supported this century.

[Updated on: Wed, 18 February 2009 14:42]

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #387294 is a reply to message #387282] Wed, 18 February 2009 15:16 Go to previous messageGo to next message
happyjoshua777
Messages: 33
Registered: February 2009
Location: United States
Member
i have tried accessing via command line SQL+ without 0.0.0.0 and it does not work
any ideas?
Re: oRACLE 9i post installaion problem [message #387295 is a reply to message #387285] Wed, 18 February 2009 15:24 Go to previous messageGo to next message
happyjoshua777
Messages: 33
Registered: February 2009
Location: United States
Member
would Oracle Database 10g Express Edition (Western European)
suffice to learn PL/SQL from the textbook?
thank you Smile
Re: oRACLE 9i post installaion problem [message #387296 is a reply to message #387291] Wed, 18 February 2009 15:28 Go to previous messageGo to next message
happyjoshua777
Messages: 33
Registered: February 2009
Location: United States
Member
would you have any ideas what to do? i already installed 9i version which is obviously supported and do not want to bother installing version 10 or 11...
Re: oRACLE 9i post installaion problem [message #387299 is a reply to message #387296] Wed, 18 February 2009 15:37 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Depends on what you did.

You installed 9i.

But did you also create a sample database? Then you would have needed to enter the database name at that point. Have you followed the Getting Started Guide to the letter?

It won't work if you just read bits of it and skip over parts. You have to follow it step by step.

Also, "does not work" is not an Oracle Error. Oracle errors are usually pretty specific, so when someone knows the actual error that someone most of the time will know what's wrong. But nobody is able to troubleshoot a "does not work".

If you are just getting started, and you want to learn then I would definitely suggest you start with version 11 and forget about 9.

Re: oRACLE 9i post installaion problem [message #387304 is a reply to message #387299] Wed, 18 February 2009 15:57 Go to previous messageGo to next message
happyjoshua777
Messages: 33
Registered: February 2009
Location: United States
Member
"does not work" was a SQL+ error.


no, i did not install a database, i skipped over it.

I may be stuck with 9i for now simply because i do not have the time to download 1.7 gb of 11g, i really need to get into PL/SQL asap and do all the exercises.
Re: oRACLE 9i post installaion problem [message #387306 is a reply to message #387299] Wed, 18 February 2009 16:01 Go to previous messageGo to next message
happyjoshua777
Messages: 33
Registered: February 2009
Location: United States
Member
if i have install a newer version (even after following all the steps in: http://www.prenhall.com/oracle/Personal_9i_guide.pdf it still does not work) is 10g express edition enough to do exercises in a PL/SQl textbook?


thank you Smile
Re: oRACLE 9i post installaion problem [message #387307 is a reply to message #387306] Wed, 18 February 2009 16:04 Go to previous messageGo to next message
happyjoshua777
Messages: 33
Registered: February 2009
Location: United States
Member
p.s. i installed apache SQL server in the past in about 20min without an issues, i never expected that Oracle installtion would be so not user friendly. AND it takes like 1.7Gb just to download the file.
Re: oRACLE 9i post installaion problem [message #387309 is a reply to message #387307] Wed, 18 February 2009 16:14 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Yes, The XE version of 10g should be able to do anything you need in regards to PL/SQL exercised.

Oh, and Oracle IS user friendly. It's just somewhat picky which user it's get friendly with. Very Happy

[Updated on: Wed, 18 February 2009 16:15]

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #387311 is a reply to message #387309] Wed, 18 February 2009 16:19 Go to previous messageGo to next message
happyjoshua777
Messages: 33
Registered: February 2009
Location: United States
Member
thank you SOOOO much for your help.
i am installing Oracle Express edition which only takes about 158Mb Smile
Re: oRACLE 9i post installaion problem [message #414582 is a reply to message #387279] Wed, 22 July 2009 15:58 Go to previous messageGo to next message
chan2009
Messages: 4
Registered: July 2009
Junior Member
Hi,

Could any one please let me know the user name, password and host string for Oracle9i.
I just downloaded and got stuck here. Please help me.

Thanks
Chan
Re: oRACLE 9i post installaion problem [message #414583 is a reply to message #414582] Wed, 22 July 2009 16:47 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
When you "Just downloaded" there is no user name, password and host string.

If you are unable to read the actual README that came with the download, nobody will be able to help you.

Re: oRACLE 9i post installaion problem [message #414584 is a reply to message #387279] Wed, 22 July 2009 17:11 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>oRACLE 9i post installaion problem
PROBLEM? What Problem? I don't see any problem.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

Why did you install an obsoleted & unsupported version?
Re: oRACLE 9i post installaion problem [message #414585 is a reply to message #414584] Wed, 22 July 2009 17:19 Go to previous messageGo to next message
chan2009
Messages: 4
Registered: July 2009
Junior Member
I downloaded it from CD which I borrowed from library( Introduction to Relational database and sql programming and I installed it in my laptop and I don't know what is the user name, password and host string.please help me
Re: oRACLE 9i post installaion problem [message #414588 is a reply to message #387279] Wed, 22 July 2009 17:31 Go to previous messageGo to next message
chan2009
Messages: 4
Registered: July 2009
Junior Member
Hi Joshua, it seems you had the same problem like me, So please guide me how can I retrieve the user name, password and host srting

Thanks

Chan
Re: oRACLE 9i post installaion problem [message #414608 is a reply to message #414585] Wed, 22 July 2009 22:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Wed, 18 February 2009 20:53
I suggest you to read "Getting Started" documents at http://www.oracle.com/pls/db102/portal.portal_db?selected=1

Regards
Michel


Re: oRACLE 9i post installaion problem [message #414765 is a reply to message #414608] Thu, 23 July 2009 07:34 Go to previous message
chan2009
Messages: 4
Registered: July 2009
Junior Member
I read through that , it is not mentioned there about user name and password,
please
any one can help me

chan
Sad
Previous Topic: Simple Newbie Questions about SQL and Oracle 10g
Next Topic: Oracle profiler
Goto Forum:
  


Current Time: Thu Mar 28 11:22:28 CDT 2024