RE: POLL: Database to DBA ratio
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
-- 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.
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
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
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
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
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).
