Re: newbie sqlplus ?

  Reading "The OFA standard: Oracle for Open Systems" could be helpful: http://www.hotsos.com/catalog/

An OFA compliant setup looks a bit different: $ORACLE_BASE=/db/oracle
$ORACLE_HOME=/db/oracle/product/8.1.7

The Admin directories could be:

/db/oracle/admin/817db1
/db/oracle/admin/817db2
/db/oracle/admin/817db3

Each admin/817db# directory should have these sub-directories: adhoc
adump
bdump
cdump
create
exp
logbook
pfile
udump

The database file directories could be:

/db/oradata/817db1
/db/oradata/817db2
/db/oradata/817db3

If more mount points are available, then /db could be replaced by other mount points for database files.

Have Fun :)

Les Ayudo wrote:

> 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 <mailto:info_at_lesayudo.com>
> To: Multiple recipients of list ORACLE-L
> <mailto:ORACLE-L_at_fatcity.com>
> 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 <mailto:ChrisStephens_at_affina.com>
> To: Multiple recipients of list ORACLE-L
> <mailto:ORACLE-L_at_fatcity.com>
> 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:info_at_lesayudo.com]
> 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" <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
> > --
> > Author: Daniel Wisser
> > INET: daniel.wisser_at_isis-papyrus.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).
> >
> >
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Les Ayudo
> INET: info_at_lesayudo.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Chip
  INET: ocp-dba_at_earthlink.net

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