Re: newbie sqlplus ?

[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, 2003 7:23 PM Subject: 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 to improving i/o rates.  The specifics are documented many places.  ...although it isn't very straight forward and depends on the usage of the database.   Off the top of my head, Steve Adam's website has some VERY good information on I/O.  www.ixora.com.au     chris -----Original Message----- From: Les Ayudo [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 4:51 PM To: Multiple recipients of list ORACLE-L Subject: 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 for db3   During the installation, i get a prompt asking me for db file installation, would this be /db/oracle/ora817/817db1  ? if this was my 1st db being installed? ----- Original Message ----- From: Les Ayudo To: Multiple recipients of list ORACLE-L Sent: Monday, February 24, 2003 2:10 PM Subject: 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 since i had deleted that folder).  Can i just ignore this option and proceed w/ the install w/o the install going haywire?  Can I still delete the old db w/ dbassist after the install? ----- Original Message ----- From: Chris Stephens To: Multiple recipients of list ORACLE-L Sent: Monday, February 24, 2003 1:30 PM Subject: 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: Monday, February 24, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: newbie sqlplus ? 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 but I noticed the oracle home was still there.  I ended up deleting it.  Is there anything else I need to do? ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 2:34 AM   > 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 do before the install?  Let me kow if u need more info. > > THanks. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Daniel Wisser >   INET: [EMAIL PROTECTED] > > Fat City Network Services    -- 858-538-5051 http://www.fatcity.com > San Diego, California        -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from).  You may > also send the HELP command for other information (like subscribing). > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Les Ayudo   INET: [EMAIL PROTECTED] Fat City Network Services    -- 858-538-5051 http://www.fatcity.com San Diego, California        -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing).