New user of SQL*Plus....Can anyone help

Reeno · Mar 27th, 2004, 06:40

I've just installed Oracle 8i personal edition on my Windows XP machine but when I try to log into SQL*PLUS I'm prompted for a user/password/host string - yet I wasn't prompted for any of this during the install.Can anyone solve my problem.

Webforumz Staff · Mar 27th, 2004, 08:22

Apparently there's something called the orapwd utility for setting these. That's about all I could find without having access to the full Oracle docs. Never used this so I don't know for sure.

http://www.geocities.com/samoracle/T...ternalPass.htm
http://milinddev.tripod.com/internalpassword.htm

Reeno · Mar 27th, 2004, 18:05

But Sir my problem is still unsloved...i tried to slove my problem by the information i got from those links...but nothing happened..

Webforumz Staff · Mar 27th, 2004, 19:12

OK, I had better luck searching today.

Read this article:
http://cisnet.baruch.cuny.edu/holowc...ll/personal8i/

The whole thing should be useful to you, and for your specific question
<blockquote id="quote"><font size="1" face="geneva, verdana, arial" id="quote">quote:<hr height="1" noshade id="quote">Once SQL Plus is running, you will be prompted for 3 things: Username, password and Host String.

The default Database Administrator's account has a username of SYSTEM and a default password of MANAGER.

Fill in the Username and password fields with the SYSTEM account and leave the Host String field blank. Since we are connecting to a local Oracle database, no Host String is required. Click on the OK button as shown below:
<hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">

Reeno · Apr 9th, 2004, 20:09

It still dosent work..when i give the user SYSTEM & password MANAGER it givs that error..

ERROR:
ORA-12203: TNS:unable to connect to destination

Reeno · Apr 9th, 2004, 20:18

sorry!! i forgot to mension one thing that when i start installation from CD there were three types of installation option i select the custom installation ...& only install SQL*Plus

Webforumz Staff · Apr 10th, 2004, 02:50

Oh, well Plus is just a utility to access the database. If you only installed that then you have no database to connect to.

Reeno · Apr 10th, 2004, 07:22

ok i tried for typical installation from CD it gives that error

Error
rdbms80.map(0):FILE_NOT_FOUND while mapping rdbms80

Webforumz Staff · Apr 10th, 2004, 07:38

All I can suggest is to follow the install directions at
http://cisnet.baruch.cuny.edu/holowc...ll/personal8i/

Reeno · Apr 27th, 2004, 20:50

Is there any different version of CD available of oracle 8i for win xp so please inform me.
Thanx