Re: Oracle 9iAs on Linux intel

2001-04-18 Thread tom panzarella

TARUN SHARMA wrote:

 Moreover, I'm working  first time on
 Linux so I don't know how to set path and oracle home variables.
 permanently. Is there any file like '.bat' in windows which set the
path. Help needed. Also if there is any book for oracle 9i and linux.
  

Yes.  It depends on the shell you are using.  By default Linux uses the 
Bash shell (/bin/bash).  To set your environment variables in bash edit 
the file ~/.bash_profile and include something like:

ORACLE_BASE=/usr/oraInventory
ORACLE_HOME=/usr/oracle

EXPORT ORACLE_BASE ORACLE_HOME
If you are using the C-shell (/bin/csh), you can edit your ~/.cshrc 
file, the syntax is slightly different:

set ORACLE_BASE = (/usr/oraInventory)
set ORACLE_HOME = (/usr/oracle)

If you are not sure which shell you are using, you can find out by typing:

echo $SHELL

also, the "~" thingy is a short hand for your home directory.  So if 
your user name is "tsharma" ~/.bash_profile and 
/home/tsharma/.bash_profile refer to the same file.

--tom.

-- 
C-x C-c

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: tom panzarella
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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



Java Programmer just getting started with Oracle......

2001-04-17 Thread tom panzarella

Hello.  I'm new to Oracle and am looking for some "guru" guidance on 
some resources to tap in order to get up to speed (preferrably quickly). 
  I'm a Java programmer looking to start getting into building 
applications backended by Oracle.  I am comfortable with Java (including 
JDBC) and SQL.  I have experience with other database systems (Progress, 
PostgreSQL, MySQL) but am a total newbie to Oracle.  I'm not looking to 
become an Oracle DBA but as an application programmer there is certainly 
some level of DBA skills needed as well as an overall understanding of 
how the backend system works in order to do my job affectively.

I recently read and did all associated exercises in the "Oracle8i for 
Linux Starter Kit" which definitely gave me a nice overview and hands on 
practice of using the Oracle system.  The book was good as a "starter 
kit" (just as the title states) and now I am looking to get some more 
depth.  My questions to the list are:

1.  How much of an "Oracle DBA" do I need to be in order to write 
affective applications using Oracle and Java?

2.  Any good books that you would recommend (that you have read)?  I 
have thought that my next purchase would be "Oracle DBA 101":
http://www1.fatbrain.com/asp/bookinfo/bookinfo.asp?theisbn=0072121203vm=

or

"Oracle Essentials: Oracle8 and Oracle8i":
http://www.oreilly.com/catalog/oressentials/

I am assuming that after getting somewhat more familiar with Oracle and 
the basics of Oracle Administration, a good book to move on to would be 
the big fat Wrox Press book on Oracle8i Application Programming:

http://www1.fatbrain.com/asp/bookinfo/bookinfo.asp?theisbn=1861004842vm=


Any advice or comments that you can offer would be greatly appreciated.

Thanks.
--tom.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: tom panzarella
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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