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



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



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





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



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


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 in $ORACLE_HOME) then there is no way you can create a
database.



You first have to reinstall the binaries.

I would then launch dbassist and delete
any old databases that oracle 'thinks' are there.  ...I believe
the installer looks at the /etc/oratab file for references to databases.  ...after
that you can create a database.



-Original Message-
From: Les Ayudo
[mailto:[EMAIL PROTECTED] 
Sent: Monday, February 24, 2003
4:10 PM
To: Multiple recipients of list
ORACLE-L
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). 










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












Re: newbie sqlplus ?

2003-02-24 Thread Chip






  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:
 

  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:10PM
 
Subject: 
Re: newbie sqlplus ?
 

 
 
Well, since I already went through the 
deinstalloption and also deleted the $oracle_home, is there something 
else I cando? I'm trying to reinstall the db but i'm getting a prompt 
asking me ifI want to upgrade or migrate the old db at /db/oracle/... 
(strange since i haddeleted that folder). Can i just ignore this option 
and proceed w/ theinstall 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  

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, 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 
  PMTo: Multiple recipients of list 
  ORACLE-LSubject: 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: 
  

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


=
Luc Demanche
[EMAIL PROTECTED]

__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Luc Demanche
  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).



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 
message like:
no sqlplus found in /usr/bin /usr/local/bin . and so on.

Whenever you issue a command, UNIX looks for it in the path that is specified.
 If it finds it, it will execute it, and if not, you will get that command not 
found error.

-Scott



= Original Message From [EMAIL PROTECTED] =
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: 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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: sstefick
  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).