OraFAQ Forum: General » oRACLE 9i post installaion problem

Home » Other » General » oRACLE 9i post installaion problem (Oarcle9i, Windows XP OS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oRACLE 9i post installaion problem [message #387279]

Wed, 18 February 2009 13:37

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!

Report message to a moderator

P.S. oRACLE 9i post installaion problem [message #387281 is a reply to message #387279]

Wed, 18 February 2009 13:40

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

Smile

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #387282 is a reply to message #387279]

Wed, 18 February 2009 13:44

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.

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #387284 is a reply to message #387279]

Wed, 18 February 2009 13:53

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #387285 is a reply to message #387279]

Wed, 18 February 2009 13:55

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #387291 is a reply to message #387282]

Wed, 18 February 2009 14:41

ThomasG
Messages: 3212
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

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?

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #387295 is a reply to message #387285]

Wed, 18 February 2009 15:24

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

Smile

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #387296 is a reply to message #387291]

Wed, 18 February 2009 15:28

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...

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #387299 is a reply to message #387296]

Wed, 18 February 2009 15:37

ThomasG
Messages: 3212
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.

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #387304 is a reply to message #387299]

Wed, 18 February 2009 15:57

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.

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #387306 is a reply to message #387299]

Wed, 18 February 2009 16:01

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

Smile

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #387307 is a reply to message #387306]

Wed, 18 February 2009 16:04

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.

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #387309 is a reply to message #387307]

Wed, 18 February 2009 16:14

ThomasG
Messages: 3212
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

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

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

Smile

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #414582 is a reply to message #387279]

Wed, 22 July 2009 15:58

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

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #414583 is a reply to message #414582]

Wed, 22 July 2009 16:47

ThomasG
Messages: 3212
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.

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #414584 is a reply to message #387279]

Wed, 22 July 2009 17:11

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?

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #414585 is a reply to message #414584]

Wed, 22 July 2009 17:19

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

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #414588 is a reply to message #387279]

Wed, 22 July 2009 17:31

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

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #414608 is a reply to message #414585]

Wed, 22 July 2009 22:32

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: oRACLE 9i post installaion problem [message #414765 is a reply to message #414608]

Thu, 23 July 2009 07:34

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

Sad

Report message to a moderator

Previous Topic:	Simple Newbie Questions about SQL and Oracle 10g
Next Topic:	Oracle profiler

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 22:46:17 CST 2024