Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: newbie sqlplus ?

RE: newbie sqlplus ?

From: Chris Stephens <ChrisStephens_at_affina.com>
Date: Mon, 24 Feb 2003 19:23:37 -0800
Message-ID: <F001.00557E71.20030224192337@fatcity.com>


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 <http://www.ixora.com.au/>  

chris

-----Original Message-----
Sent: Monday, February 24, 2003 4:51 PM
To: Multiple recipients of list ORACLE-L  

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?

To: Multiple <mailto:ORACLE-L_at_fatcity.com> recipients of list ORACLE-L

Sent: Monday, February 24, 2003 2:10 PM  

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?

To: Multiple <mailto:ORACLE-L_at_fatcity.com> recipients of list ORACLE-L

Sent: Monday, February 24, 2003 1:30 PM  

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-----
Sent: Monday, February 24, 2003 10:59 AM To: Multiple recipients of list ORACLE-L

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" <ORACLE-L_at_fatcity.com> 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
<http://www.orafaq.net>
> --
> Author: Daniel Wisser
> INET: daniel.wisser_at_isis-papyrus.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<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: ListGuru_at_fatcity.com (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
<http://www.orafaq.net>  
-- 
Author: Les Ayudo 
  INET: info_at_lesayudo.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
<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: ListGuru_at_fatcity.com (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: Chris Stephens
  INET: ChrisStephens_at_affina.com

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: ListGuru_at_fatcity.com (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).
Received on Mon Feb 24 2003 - 21:23:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US