Re: newbie sqlplus ?

2003-02-24 Thread Daniel Wisser
hi! in your profile set $ORACLE_HOME to your oracle directory and put $ORACLE_HOME/bin in your path daniel Les Ayudo wrote: I have just installed Oracle 8i1.7 on solaris 9 (ultra sparc 10) and issued the command sqlplus and I rec'd a command not found error. Is there something I forgt to

Re: newbie sqlplus ?

2003-02-24 Thread Les Ayudo
I'm just going to reinstall Oracle8i and start from scratch. Any docs out there on uninstalling Oracle8i? The only ones I have found are on Windows and they're all saying how Oracle does not completely uninstall. Is this true for Oracle on Solaris? I ran the uninstaller and removed everything

RE: newbie sqlplus ?

2003-02-24 Thread Chris Stephens
Title: RE: newbie sqlplus ? Launch $ORACLE_HOME/bin/dbassist and delete any database you have created. Then launch the installer from your oracle cd and select deinstall option to deinstall the software. chris -Original Message- From: Les Ayudo [mailto:[EMAIL PROTECTED]] Sent

Re: newbie sqlplus ?

2003-02-24 Thread Les Ayudo
Title: RE: newbie sqlplus ? Well, since I already went through the deinstall option and also deleted the $oracle_home, is there something else I can do? I'm trying to reinstall the db but i'm getting a prompt asking me if I want to upgrade or migrate the old db at /db/oracle/... (strange

Re: newbie sqlplus ?

2003-02-24 Thread Les Ayudo
Title: RE: newbie sqlplus ? Another question, I setup my computer like this: $ORACLE_BASE=/db/oracle $ORACHE_HOME=/db/oracle/ora817/817home My oracle directories like this: /db/oracle/ora817/817db1 --files for db1 /db/oracle/ora817/817db2 --files for db2 /db/oracle/ora817/817db3 --files

RE: newbie sqlplus ?

2003-02-24 Thread Chris Stephens
Title: RE: newbie sqlplus ? I'm a little confused by your post. I'm not sure if this is where you are going wrong but not so long ago, I failed to make the distinction between the database and the oracle software. If you have deinstalled/deleted the oracle binaries (all files

RE: newbie sqlplus ?

2003-02-24 Thread Chris Stephens
Title: RE: newbie sqlplus ? If that is where you want to put all of your database files than yes. I think that starting out, a single location will be fine. As you learn more about the database you'll find that spreading the database out among server different physical disks is key

Re: newbie sqlplus ?

2003-02-24 Thread Chip
unt points are available, then /db could be replaced by other mount points for database files. Have Fun :) Les Ayudo wrote: RE: newbie sqlplus ? Another question, I setup my computer like this: $ORACLE_BASE=

Re: newbie sqlplus ?

2003-02-24 Thread Les Ayudo
Title: RE: newbie sqlplus ? Using my setup or my example of folders, how would you setup a db? I want to see what I'm failing to see. Thx for the reply - Original Message - From: Chris Stephens To: Multiple recipients of list ORACLE-L Sent: Monday, February 24

Re: newbie sqlplus ?

2003-02-23 Thread Luc Demanche
Les, Check your PATH. Issue echo $PATH and your should have $ORACLE_HOME/bin Otherwise you should enter the full path. Luc --- Les Ayudo [EMAIL PROTECTED] wrote: I have just installed Oracle 8i1.7 on solaris 9 (ultra sparc 10) and issued the command sqlplus and I rec'd a command not found

RE: newbie sqlplus ?

2003-02-23 Thread sstefick
Do the following at the command line: echo $PATH Then look to see if your ORACLE_HOME/bin is in the path. If not, you need to put that in your path. and just to make sure that it is being found, do: which sqlplus This should return the path to sqlplus. If it cannot find it, you will get a