RE: POLL: Database to DBA ratio

2003-03-11 Thread Robin Ilardi
I currently have 5 development databases and 1 "beta" production database
that I administer, so that's 6:1, but I'm also the Sys Admin for these
servers as well.   These are also very small databases.

robin


-Original Message-
Sent: Tuesday, March 11, 2003 11:44 AM
To: Multiple recipients of list ORACLE-L



We have 10 development databases that I support directly plus 5
implementation/testing databases that I support as second level and one
production snapshot datamart.

16:1

However, there are also DBAs who support each project.  That would make the
ratio closer to 4:1 or 3:1.




  "Chuck Hamilton"
  
  @softhome.net>   cc:
  Sent by: rootSubject: POLL: Database to
DBA ratio


  03/11/2003 09:59
  AM
  Please respond
  to ORACLE-L






I'm trying to build a case for management that we need additional DBAs so
I'd like to take a quick poll if I may. What is the ratio of Oracle
databases to DBAs in your shop? This includes development and production
databases. At our shop it's 33:1.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
  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: Thomas Day
  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: Robin Ilardi
  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: Orawomen

2003-01-08 Thread Robin Ilardi
--
Author: Rachel Carmichael
  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: Robin Ilardi
  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: Client Connection-SQLNET ?/? ODBC.

2001-07-10 Thread Robin Ilardi

Yes, you do need to have Net8 installed in order for Cold Fusion to connect
to the database through ODBC.  It uses ODBC through SqlNet.  First set up
the Sqlnet connection to the database, then set up the ODBC connection using
the service name you used for the Sqlnet connection.

hth,
Robin


-Original Message-
Damiano
Sent: Tuesday, July 10, 2001 11:15 AM
To: Multiple recipients of list ORACLE-L


Dear DBA Colleagues,

Please pardon me if this question is a bit elementary, but this concerns
applications connecting to Oracle.

Most of our Oracle Apps are PowerBuilder-based such that we use the
appropriate PowerBuilder DLLs and SQLNET on the Client to connect up to
SQLNET and the Oracle RDBMS on the server.

A new application we are proposing to build is Web-based, with Browser
clients connecting to a Linux (Red Hat 7.x) machine running Apache and Cold
Fusion.  This Linux machine will then act as a client, connecting to the
Oracle 8i RDBMS running on a Compaq (DEC) Alpha with Digital Unix Version 5.
On the Linux box, we will of course need to specify the Cold Fusion DLLs to
allow connection to the Oracle 8i Database.

But my issue is this:
On the Linux machine running as the client, if we do "ODBC", do we need
to do SQLNET (Net 8) as well?

I.E. What is it on the client that actually makes the connection to the
SQLNET (Net 8) running on the server:
- "ODBC" itself
- "ODBC through SQLNET"?

Thanks very much in advance!

Jim Damiano
Oracle DBA


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


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



RE: Oracle 9i database for Linux available for download on Technet

2001-06-14 Thread Robin Ilardi

So far my download is at 296mb out of 393mb(for the first download file) and
it's still going.

robin


-Original Message-
Carmichael
Sent: Thursday, June 14, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L
Technet


has anyone had any luck downloading file 3?  It SAYS 800+MB, it downloads
79+MB and says it's done.

I tried both download sites (east and west) that I know of. Are there any
others?

Rachel


>From: "Joe Raube" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Oracle 9i database for Linux available for download on Technet
>Date: Wed, 13 Jun 2001 20:25:48 -0800
>
>Enjoy
>
>
>
>_
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Joe Raube
>   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).

_
Get your FREE download of MSN Explorer at http://explorer.msn.com

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


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



RE: regarding isqlPlus

2001-06-12 Thread Robin Ilardi

The documentation states "Earlier versions of the Oracle database may work,
but only Oracle 8i 8.1.7 (Release 3) is supported."

The important thing is to have Oracle's Apache HTTP server, which comes with
either 8.1.7 or 9iAS.  I have it installed under 9iAS with an 8.1.7 database
and it seems just fine.

Robin


-Original Message-
Sharma
Sent: Tuesday, June 12, 2001 2:25 AM
To: Multiple recipients of list ORACLE-L


can a version earlier than 8.1.7 be used as the database server in the
3-tier-architecture.

i have 8.1.5 on NT 4.0 service pack 5.

saurabh
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 9:11 PM


> Got it working at home on Windows 2000 with 8.1.7.0.0.
>
> Works just fine, but .sql files are not able to read SQL*Plus commands
> (i.e. column xxx format a10).
>
> As I recall the install was fairly simple.
>
>
> Jon Baker
> Database Engineer (1/5)
> <[EMAIL PROTECTED]>
> www.netsec.net
>
>
> > Saurabh Sharma wrote:
> >
> > hi all,
> >
> > has anybody using iSqlPlus tool, provided by oracle.
> > what i know is , it's the internat enabled extension of sql * plus,
> > utilising the 3-tier architecture.
> >
> > they say oracle 8.1.7 is required for the implementation.
> >
> > any suggestions.
> >
> > saurabh
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jonathan Baker
>   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).

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


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



RE: regarding isqlPlus

2001-06-11 Thread Robin Ilardi



We 
have installed iSQLPlus on our development box, and it seems to work fairly 
well.  The nice thing about it is you don't have to install the client on 
the user's PC, it just uses a browser.  It does have a bug or two - for 
example, if the user does not click on the "Logoff" button and just closes the 
browser window, a session is left open in the database.  I'd be hesitant 
about using it in a production environment until they at least get that 
fixed.
 
You do 
have to have an 8.1.7 database installed with the Apache web server, although 
you might be able to get away with a lower version of the database as long as 
you're using Apache.  We are using an 8.1.7 database and the Apache web 
server installed with 9iAS, all under NT (not my choice - I'm going to move the 
web server to Linux as soon as I can get a box configured).
 
hth,
Robin
 
Robin 
Ilardi
Sherian Corporation

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of Saurabh SharmaSent: 
  Monday, June 11, 2001 2:35 AMTo: Multiple recipients of list 
  ORACLE-LSubject: regarding isqlPlus
  hi all,
   
  has anybody using iSqlPlus tool, 
  provided by oracle.
  what i know is , it's the 
  internat enabled extension of sql * plus, utilising the 3-tier 
  architecture.
   
  they say oracle 8.1.7 is required 
  for the implementation.
   
  any suggestions.
   
  saurabh


RE: OT Unix shell variable question

2001-05-29 Thread Robin Ilardi

How about $PASSWORD?


-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 3:41 PM
To: Multiple recipients of list ORACLE-L


I am trying to pass a shell variable into a "here document" in a unix shell
script, i.e.,

export PASSWORD=the_pass

svrmgrl << EOF
connect user/$PASS
do_stuff_here;
commit;
exit
EOF

I have tried:  "$PASS" , \$PASS , and just plain $PASS - no dice.
Anyone know how to do this?  I spent too many hours in the sun this past
weekend and am drawing a blank...

Thanks,

Scott Shafer
San Antonio, TX
210-581-6217

"And no amount of training or preparedness can eliminate the almost
certainty that in the middle of your Angry Crane stance, as you transition
to your Combative Monkey to administer the Coup de Grâce via your Ninja
Death Touch, you step on a beer bottle and fall backwards into the juke box
and get your head stove in by a drunk with a pool cue."  --Jay Trigg

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


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