DBA needed in Austin, TX
With permission from Jared: 'Needed' is kind of strong. We've got a position open, but we're not real needy folks. We're a school district. The 37th (depending on the day of the week) largest in the United States. If we were a business, it'd be pretty good-sized. Our annual operating budget is 730 million dollars plus (of which MIS gets a really small, tiny, little itty bit), we have 15,000 employees, 130 branch offices, our own police force and post office. We fix 150,000 meals a day and need to collect cash or validate for every person through the cafeterias. We're moving from a mainframe environment to client-server computing with an Oracle back-end running on HPUX and Linux for both our student data and ERP systems. It's a pretty dynamic shop. We've got 40 or so people (depending on the day of the week) split into three areas, business systems, student systems and programming. We don't do the network piece, but that's solid - switched gigabit ethernet running on over 300 miles of fiber with 100MB to the desktop. I don't hire or set salaries. HR does that. I only recommend. The salary for this position will be somewhere between $60K and $80K depending on experience (and whatever bizarre decisions are reached by the compensation analyst). You've got to be REAL strong in backup and recovery. And curious. We're planning to go where no school district (or very few) has gone before. Your assistance will be vital in making the investment Austin has made in technology pay off. If you've got any questions, please send me an email. If you'd like to apply, you can do so on-line at http://www.austin.isd.tenet.edu/about/hr/search/index.phtml Under 'classified' positions, see if you can find the DBA position. If it isn't there (depending on the day of the week), and you can't possibly wait, apply for either the Programmer/Analyst or UNIX Admin position. It should be there sometime after 4pm CDT, or maybe tomorrow, or maybe not. [We don't do the Internet piece - yet]. David A. Barbour Director, Management Information Services AISD Confidentiality Notice: This email message, including all attachments, is for the sole use of the intended recipient(s) and may contain confidential student information. Unauthorized use or disclosure is prohibited under the federal Family Education Rights & Privacy Act (20 U.S.C. §1232g; 34 CFR Part 99). If you are not the intended recipient, you may not use, disclose, copy or disseminate this information. Please contact the sender by reply email or by contacting 414-0095 immediately and destroy all copies of the original message, including attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Kalido
So you're looking for a Kalido scope? Sorry - couldn't resist. David A. Barbour AISD Confidentiality Notice: This email message, including all attachments, is for the sole use of the intended recipient(s) and may contain confidential student information. Unauthorized use or disclosure is prohibited under the federal Family Education Rights & Privacy Act (20 U.S.C. §1232g; 34 CFR Part 99). If you are not the intended recipient, you may not use, disclose, copy or disseminate this information. Please contact the sender by reply email or by contacting 414-0095 immediately and destroy all copies of the original message, including attachments. "Novice DBA" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> l.com> cc: Sent by: Subject: Kalido [EMAIL PROTECTED] .com 06/25/2003 08:05 PM Please respond to ORACLE-L Dear all, Has anyone heard about Kalido. Are there any comparitive tools in the market. What is the scope for a Kalido programmer/developer/specialist. Please let me know your thoughts Thanks and Regards Novice No more Oracle Certifiable DBA _ Take this online tour. Win an HCL Beanstalk PC. http://server1.msn.co.in/sp03/hclbeanstalktour/amazing_winxp.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Novice DBA 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: 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: Tracing or not tracing, this is the question now.
Okay Mladen, I'll bite. How about checking the user_dump_dest? David A. Barbour AISD Confidentiality Notice: This email message, including all attachments, is for the sole use of the intended recipient(s) and may contain confidential student information. Unauthorized use or disclosure is prohibited under the federal Family Education Rights & Privacy Act (20 U.S.C. §1232g; 34 CFR Part 99). If you are not the intended recipient, you may not use, disclose, copy or disseminate this information. Please contact the sender by reply email or by contacting 414-0095 immediately and destroy all copies of the original message, including attachments. "Gogala, Mladen" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >cc: Sent by: Subject: Tracing or not tracing, this is the question now. [EMAIL PROTECTED] 01/15/2003 03:40 PM Please respond to ORACLE-L I'm looking for a way of checking which sessions on the database have trace turned on. I can set event in another session, but I'd like to know whether the event (10046 in this case) is set in some sessions. Mladen Gogala Oracle DBA Oxford Health Plans www.oxhp.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Cannot Connect to DB from 9i DS Release 2
Specify the tnsnames.ora file to Toad. On the startup page, click the SQL*Net Help button. David A. Barbour AISD "KENNETH JANUSZ" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: et> Subject: Cannot Connect to DB from 9i DS Release 2 Sent by: [EMAIL PROTECTED] om 08/16/2002 09:58 AM Please respond to ORACLE-L I have a DB connection problem that I cannot resolve and need your help. Standalone Dell 8200 PC using XP Prof. with 61.6 GB of free space. A couple of days ago I installed my 9.2 DB successfully and was able to connect with SQL*Plus and TOAD. Then yesterday I installed 9iDS Rel. 2 which finished with no errors. Destination for DS is: Name: IDSHome Path: C:\IDSHome1 The 9.2 DB is located at C:\oracle\admin . . . \ora92 . . . \oradata Now I'm having a problem connecting the DB. I can connect via SQL*Plus but not TOAD. I tried connecting to the Forms Developer/Builder, Designer, and Reports Developer/Builder and get the same error message. ORA-12154:TNS: Could not resolve service name. Service name specified is not defined in TNSNAMES.ORA file. And when I go to Services for DS I get: OracleIDSHomeAgent - fails (will not run even with numerous start attempts) OracleIDSHomeClientCache - runs Both have startup type of manual. Attached is my TNSNAMES.ORA file. One thing I didn't do is reboot my PC prior to the start of this installation. I didn't think I needed to since this is the first installation for DS. Anyone have any idea what is wrong and how I go about correcting it? Any and all help will be greatly appreciated. Thanks, Ken (See attached file: tnsnames.ora) tnsnames.ora Description: Binary data
Re: 20 Instances 1 Machine
Twenty Instances? At 500M per SGA, you're talking a minimum of 12+ G of RAM. How many users per instance? More RAM. Are these OLTP or Datawarehousing type DBs? Disk and I/O and RAM. 24 x 7? If one has to be, then you're going to need some type of failover/standby capability. What vendor applications will be supported? More RAM. Any Corba brokers? More RAM. What flavor of UNIX are you on right now? David A. Barbour AISD "Post, Ethan" .net>cc: Sent by: Subject: 20 Instances 1 Machine [EMAIL PROTECTED] om 08/01/2002 04:58 PM Please respond to ORACLE-L I got a request to spec out a machine that could handle 20 separate Oracle instances on a single UNIX server. SGA should total about 500 MB per instance. We have some hosts here with 6-8 instances but never tried 20 before. Wondering what types of things I should be worried about, obviously having enough memory but are there any other limitations I can expect? Anyone had to do this? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: 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: A DBA looks at OAS
Robert, Just use the iAS (Apache) webserver that comes with 8i and up. Really configurable, as simple or complex as you want it to be. With the various mod_ plugins, you can be serving up stuff in no time. David A. Barbour AISD "Freeman, Robert" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: A DBA looks at OAS Sent by: [EMAIL PROTECTED] om 07/17/2002 11:18 AM Please respond to ORACLE-L Folks, I'm a DBA who is really an old developer at heart. I know a little Java, a little Asp (enough, as they say, to be really dangerous!), I used to do C code that now makes my head swim to look at. (I think to myself, what the devil was I doing??) Anyway, I've finally found some time and a machine here at work to start playing with OAS just to see what it's all about. Anyone have any good suggestions with regards to: 1. Sites, books, white papers and the like with good install tips, hints, warnings and the like. 2. Sites, books, white papers and the like Quick getting started tips. 3. Your own "getting started" experiences of things to do or not to do. 5. Anything I should do before I mess with OAS. Optimistically hopeful that this will all just go really smooth and I'll have a cool web page that I can bring up soon! RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: 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: Unix related - need some info
You didn't specify the "flavor" of your OS. Although they all have similarities, they're also vastly different. Start here: http://bhami.com/rosetta.html Buy O'Reilly's "Essential System Administration." Good basic 'NIX book, even if it doesn't answer your specific question, it'll point you in the right direction. Welcome back Ferenc. David A. Barbour AISD "Vladimir Barac - posao" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Unix related - need some info Sent by: [EMAIL PROTECTED] om 06/22/2002 12:38 PM Please respond to ORACLE-L Good day to everyone... I have two questions related to Linux and Solaris... * I need do find memory usage (physical, virtual...) of a particular proccess. PID is given by by "ps", but what aditional parameters I have to provide? At a first glance, output of "man ps" vas confusing... * How do I find computer's configuration - what CPU, numbers of CPUs, clock, amount of memory, number of harddrives, what version of OS, what OS patches are applied...? No, I can't ask sysadmin about that (hard to explain), and, no, I don't have any kind of advanced manuals... Thanks in advance, Vladimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao 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: 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: VB and Oracle...memory limiting the amount of records returned?
We have a similar problem with a vendor supplied application. We solved it (at least we masked the symptom) by increasing the ODBC timeout in the user's W2K registry. The vendor app uses an ODBC connect to a CORBA broker (OpenLink) on the server. It's a bank rec that was only returning a portion of the payroll checks issued. David A. Barbour AISD "Grabowy, Chris" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: VB and Oracle...memory limiting the amount of records Sent by: returned? [EMAIL PROTECTED] om 06/14/2002 03:43 PM Please respond to ORACLE-L We have a VB app that uses Oracle as the database. The users noticed a limitation in the amount of records being returned from the database. So they decided to increase the memory of the PC and some additional volume of records were returned. ?? Has anyone using VB/Oracle noticed this?? Is this simply a sign of bad coding? Trying to load up all the records into memory, and therefore failing? Any clues, references or links would be appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris 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: 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: online backup and alter system switch logfile
John,Add a 'sleep' command to your UNIX-side shell script before you copy the logs to ensure the log has finished writing. You need to have that last archivelog - it contains the data regarding datafile header record changes you'll need to apply in the event you have to restore to sync up your controlfile. David A. BarbourOracle DBA, OCPAISD512-414-1002 John Dunn <[EMAIL PROTECTED]>Sent by: [EMAIL PROTECTED]05/28/2002 03:08 AM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Subject: online backup and alter system switch logfile I have a online backup script which issues the commandALTER SYSTEM SWITCH LOGFILE;immediately before copying the archived redo logs.Does this make sense? I am finding that the ARC process has not finishedarchiving the log before I copy the archive logsJohn--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: John Dunn INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- 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).
Re: ORA-03113: end-of-file on communication channel
Check and see if you still have a lock file in $ORACLE_HOME/dbs David A. Barbour Oracle DBA, OCP AISD 512-414-1002 John Weatherman ments.com> cc: Sent by: Subject: ORA-03113: end-of-file on communication channel [EMAIL PROTECTED] 05/06/2002 03:18 PM Please respond to ORACLE-L All, I had an instance crash this morning and sence then have been getting an ORA-3113 whenever I try to open it. It will startup nomount and mount, the error occurs on the open. A search on metalink showed this was likely a shared memory error and recommended a reboot, which I have now done (fortunately this is on a development server). I'm still getting the ORA-3113. Anybody seen anything like this and/or have any suggestions for getting the database to open? TIA, John -- 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).
Re: Oracle - Access
I guess this is what has replaced Friday humor and recipes. Anything tangentially related to Oracle. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Oracle - Access om 05/03/2002 09:48 AM Please respond to ORACLE-L Hallo, anyone who has a good hint on this: I have an appplication which goes against Oracle and when I am inthe application and run VBA code which connects to linked tables everything works fine. But when I have an icon on the desktop and runs that icon as shortcut then I get error messagelike "table not exist", but it really exists and it is the same code running both times. Thanks in advance Roland -- 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: 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 IFS
Samba on Linux has been a life saver. Users can map a network drive, that's nfs mounted on UNIX that's accessible from the web. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Jack van Zanen" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: L> Subject: Oracle IFS Sent by: [EMAIL PROTECTED] om 05/02/2002 03:48 AM Please respond to ORACLE-L Hi All, We are looking for possible solutions to share files between Windows & Unix. And also store millions of little files that are now a backup nightmare. Does anybody have any experience with IFS (performance, possibilities, pitfalls ) TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst & Young. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst & Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst & Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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
Re: ORA-27101 "Shared Memory Realm Does Not Exist"
Rick, Are you trying for two seperate versions of Oracle on the box, or did you remove the 8.1.6 to install 9i? If you did the latter, I'm afraid your uninstall did not go properly and your service isn't pointing to the right place. Oradim is the "supported" method for removing (renaming?) an Oracle instance, but here's some tips I got when I was new to the NT/2000 world from "Novice DBA". I've sent this before, but you should take a look at your registry settings, they're probably the key to your problem and this document will help you know what to look for: Database Installation involves a set of procedures which need to be followed in order to have a proper working installation. If we follow these procedures the Installation will be fine and usually problems related to improper installation do not arise. But it is not always possible to get a proper installation for the first time. This document is a troubleshooting guide which would help to clear off the mess created by an improper installation in a WindowsNT system. First we need to know that During installation Oracle writes into certain directories (which we would have specified during installation) and also into the WindowsNT registry. WindowsNT registry is a repository of information about all the installed products and configurations on that system. When we are installing Oracle a directory is created in the registry which is name oracle which is present in the HKEY_LOCAL_MACHINE/SOFTWARE/ In the case of an improper installation the problems faced are · We may not be able to uninstall the incomplete installation · We may succeed in uninstalling the incomplete installation but yet face problems with WindowsNT Services. · Every time we log into WindowsNT we may get an error 'at least one system service failed to start' which may be an Oracle service from the earlier installation. · We may get an error while creating a database 'the database with the name you specified already exists please chose another name' which again may be attributed to an improper un-installation.(I am not pretty comfortable with the Oracle's Un-installation utility because I feel it does not uninstall everything) Keeping the above points in mind it would be better if we know where exactly to look in case we are faced with such problems. When oracle is installed it makes entries in the following places 1. The first and the foremost- the directory in which we install the Oracle database (say D:\Ora8i) 2. The second is the inventory it maintains in the directory c:\program files\oracle 3. The third HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE in the registry 4. The other place is HKEY_LOCAL_MACHINE/SYSTEM . Inside this entry there are three nodes controlset1,controlset2 and currentcontrolset. These nodes in turn have 4 nodes out of which 2 are important to us. They are Enum and Services. The Enum node has got two nodes out of which the 'root' node is of great interest to us because it stores details about all the services that are running on a WindowsNT system. The other node of interest from the controlsets is Services. The services node has got a list of services running on a WindowsNT system. In case we need to clean up the system after an incomplete installation we can follow the following steps Delete the home directory where Oracle is installed Delete the folder C:\program files\oracle Note:- This clears off information about any other Oracle utility installed on that system. Delete the registry entry HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE Warning:- This clears off information about any other Oracle utility installed on that system and you may not be able to run those programs again. Delete the Oracle Related services from HKEY_LOCAL_MACHINE/SYSTEM/CONTROLSETx/ENUM/ROOT/ . They will be named with a prefix LEGACY_ORACLE... Note:- You will have to use regedt32.exe to invoke registry editor and not regedit. You will have to use the security menu and give permissions to yourself before deleting these entries. Else it will not work . It is to be noted that there are three control sets and all the three (in reality any 2) need to be cleared off these un-necessary entries. Delete the Oracle Related services from HKEY_LOCAL_MACHINE/SYSTEM/CONTROLSETx/SERVICES . They will have a prefix 'Oracle'. Hope this helps. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Rick_Cale@team health.com To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: ORA-27101 "Shared Memory Realm Does Not Exist" om
Re: Brainbench Oracle certifications
Andrey, The Brainbench exams are good for self-testing your knowledge of the product and exposure to nuances you may not have previously considered or come into contact with. In this regard, it's really much like the OCP, without the "official" stamp of approval. I take their exams for a variety of applications/languages, just to know where my weaknesses lie, and to help me stay abreast of changes I might otherwise not encounter. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Andrey Bronfin esoft.com> cc: Sent by:Subject: Brainbench Oracle certifications [EMAIL PROTECTED] 04/11/2002 04:23 PM Please respond to ORACLE-L Dear gurus ! May i ask for your opinions regarding the value of the Brainbench Oracle 8i Administration certifications. I understand that it can not be compared t othe OCP, but is there any value at all for it ? Thanks a lot in advance. Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: 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: HELP HELP HELP HELP !!!!!!
What version of Oracle are you using, what is your operating system, and what happened to cause you to resart the server several times? I don't think that's going to help you, in fact it may make things worse. Looks like Oracle is trying to perform an instance recovery from a crash and applying redo logs. Be patient and let it do it's thing.Of course if you're on NT/W2K you may have to stop the Oracle Service, delete the password file and Oracle Service, then recreate the service. David A. BarbourOracle DBA, OCPAISD512-414-1002 "Ali TOYGAR" <[EMAIL PROTECTED]>Sent by: [EMAIL PROTECTED]04/10/2002 10:28 PM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Subject: HELP HELP HELP HELP !! I faced with following error. ORA-01033: Oracle startup or shutdown in progress What is the problem. I restart server again and again but problem is not solved.Please HELP ME. -- 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).
Re: Ang: RE: Pl/sql question - if statement
Roland, What ever happened to the Access list you were trying to find? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Ang: RE: Pl/sql question - if statement om 04/09/2002 11:48 AM Please respond to ORACLE-L Yes but then it fails onthe word borttags_flagg, thi serrormessage : PLS-00103: Encountered the symbol "BORTTAGS_FLAGG" when expecting one of the following: . ( * @ % & = - + < / > at in mod not rem then <> or != or ~= >= <= <> and or like I reallydont see what the error is: Roland "John Hallas" <[EMAIL PROTECTED]>@fatcity.com den 2002-04-09 07:58 PST Sänd svar till [EMAIL PROTECTED] Sänt av: [EMAIL PROTECTED] Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Kopia: Don't you need to start of with a quote before the first A If 'A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 '' John -Original Message- [EMAIL PROTECTED] Sent: 09 April 2002 15:43 To: Multiple recipients of list ORACLE-L anyone whom can tell me why this statement fails in a pl/sqll code: I get this error message PLS-00103: Encountered the symbol "||AvdNr||" when expecting one of the following: . ( * @ % & = - + < / > at in mod not rem then <> or != or ~= >= <= <> and or like betwe when i run this statement If A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 '' then lvSQL := 'SELECT ICA_ARTIKEL.FSGPRIS,ICA_ARTIKEL.PANTBELOPP ' || --PBK.LPKORGEANREL.EANREL,PBK.LPK ORGEANREL.VARUTYP ' || 'FROM A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| ' ' || --PBK.LPKORGEANREL ' || 'WHERE ICA_ARTIKEL.EAN=' || EanLPVara || ' ' || 'AND ICA_ARTIKEL.DATUMhttp://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: John Hallas 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourse
Re: Pl/sql question - if statement
Check your quotes. Better yet, create a variable as the string then check the variable. If I understand your code, the first line would look like this: If 'A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG' = 0 THEN I suspect you're going to have problems with the rest of your quoting as well. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Pl/sql question - if statement om 04/09/2002 09:43 AM Please respond to ORACLE-L anyone whom can tell me why this statement fails in a pl/sqll code: I get this error message PLS-00103: Encountered the symbol "||AvdNr||" when expecting one of the following: . ( * @ % & = - + < / > at in mod not rem then <> or != or ~= >= <= <> and or like betwe when i run this statement If A'||AvdNr||'.ICA_ARTIKEL@'||LookUpServerName|| 'BORTTAGS_FLAGG = 0 '' then lvSQL := 'SELECT ICA_ARTIKEL.FSGPRIS,ICA_ARTIKEL.PANTBELOPP ' || --PBK.LPKORGEANREL.EANREL,PBK.LPKORGEANREL.VARUTYP ' || 'FROM A'||AvdNr||'.ICA_ARTIKEL@' ||LookUpServerName|| ' ' || --PBK.LPKORGEANREL ' || 'WHERE ICA_ARTIKEL.EAN=' || EanLPVara || ' ' || 'AND ICA_ARTIKEL.DATUMhttp://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: 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: Please help resolving report generation performance problem...
You mentioned a number of things you have tried to tune the database, so it just may (probably is) the SQL. Rewriting might be the best solution (depending), but you need your stuff now. If you can't tune the SQL, try tuning the execution. If you can run a trace of the report session, use tkprof to get an explain plan, perhaps the judicious addition of indexes might help you in the short term. David A. BarbourOracle DBA, OCPAISD512-414-1002 "Denmark Weatherburne" <[EMAIL PROTECTED]>Sent by: [EMAIL PROTECTED]04/07/2002 10:18 AM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Subject: Please help resolving report generation performance problem... Hi DBA's,I've been trying to isolate the bottleneck with our Oracle database.I work as an Oracle DBA for the Government of a developing country (Belize).Recently, as it is income tax time, the department has to reconcile allwitholdings by the employer with their payment receiptrecords. This involves some data entry and a report generation byemployer (witholder) which lists all witholdings by each employee.This report can generate lots of pages depending on the number of employees.In some cases, the report has to be run overnight, as it takes too long(several hours) to generate.I've tried giving more resources to Oracle. I've tried creating a copyof the production database on another machine to use only for generatingreports. I've increased the size and number of rollback segments. I've tunedsome parameters. However, I have not observedany significant improvement in the report generation performance.I know tuning the SQL might be required, however, I don't have muchexperience in this area. The SQL statemements were written by consultantswho have long left. We do have the source code though.We are running Oracle 8.0.5.2.1 on NT 4.0The NT server is a Dell 4400 with Dual CPU and 1GB RAMWe are using hardware RAID 5.Our database is OLTP with reporting.It is a small database (exported data is about 150 MB).I would appreciate your recommendations and advice.Thanks in advance,Denmark Weatherburne_Chat with friends online, try MSN Messenger: http://messenger.msn.com Report_SQL.zip Description: Zip archive The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. Hourly_Bstat_Estat_Reports.zip Description: Zip archive
Re: Copy tables and indexes etc from one db to another
Roland, I have a theory..., never mind. (Heavy sigh). Have you ever heard of a thing called a db link? Please try looking that up. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Copy tables and indexes etc from one db to another om 04/05/2002 07:18 AM Please respond to ORACLE-L Hallo, anyone whom can tellme the easiest way to copy tables etc from one database to another. Thanks in advance Roland -- 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: 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: sysdba
What is your operating system, database level, and what command are you issuing? Is this the first time this has occurred? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 paPIpapupapePO nec.co.jp>cc: Sent by: Subject: sysdba [EMAIL PROTECTED] m 04/02/2002 11:18 PM Please respond to ORACLE-L i cant connect as sysdba. ORA-01031 - insuffecient privileges. can anybody help me? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: paPIpapupapePO 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: 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: out put of a procedure
Do you have a DBMS_OUTPUT line in your procedure? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Hamid Alavi ovadx.com>cc: Sent by: Subject: out put of a procedure [EMAIL PROTECTED] m 03/29/2002 05:13 PM Please respond to ORACLE-L HI LIST, How can I see the output of my procedure, my procedure return one output, I have tried with set serveroutput on but the procedure successfully completed with NO RETURN value??? Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: 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: Table Insert Lock!!
You mention a lock? Are you getting an error message on attempted insert? Is the transaction committed? How about issuing the command 'rollback' ? David A. BarbourOracle DBA, OCPAISD512-414-1002 [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]03/28/2002 04:43 AM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Subject: Table Insert Lock!! HiI have to revoke insert from a table where I am the owner of the Schema. isit possible. if so? how?.E.g.Owner a have a table t1after inserting 1 rowowner wish to revoke insert for the table t1. because t1 should not havemore than one row.How to incorporate this. it is 8.1.7 on sun Solaris 5.7RegardsAyyappan.SThis communication contains information, which is confidential and may alsobe privileged. It is for the exclusive use of the intended recipient(s). Ifyou are not the intended recipient(s), please note that any distribution,printing, copying or use of this communication or the information in it isstrictly prohibited. If you have received this communication in error,please notify the sender immediately and then destroy any copies of it.Visit us @www.ssiworldwide.com--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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- 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).
Re: Trigger question
Oh my! (Is that gentle enough Jared?) Roland, I admire your ability to participate in this forum using the English language, I certainly could not pose questions within a Swedish discussion group. Since you have the ability to use the language, might I suggest once again you subscribe at http://otn.oracle.com (do they have a Swedish version as well?), then type the word 'trigger' into the search box. Triggers are a wonderful, varied construct and all their glory (including samples of just the type you wish to create) will be revealed. Just a thought. No offense. David A. BarbourOracle DBA, OCPAISD512-414-1002 [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]03/28/2002 03:33 AM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Subject: Trigger question Hallo,anyone who can please helpme with a trigger script that does the following:I want this script to run when I have updated a field in a table.update test set namn = upper(substr(namn,1,1) || substr(namn),2)I want this trigger to fire only for the selected record(row), that is going to be updated. Please help me with this, it might seem simple but I cant get it right.Thanks in advanceRoland S--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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- 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).
Re: Data Conversion procedural
I think I forgot to take my happy pills today. Raymond, What possible input could you be looking for here? Have you designed the database? If not, start there. That requires some business process analysis. When you've designed the DB, you'll know what data elements you need to get out of the old system to populate the new. How you transfer the data depends on a variety of factors, none of which you've mentioned (except you're putting the old system into Oracle). If you're not looking to create and populate a database, are you trying to recreate the functionality? That requires some business process analysis (I sense a theme emerging here). Once that's done, the rest is merely hard. Folks here can (I'm convinced) do just about anything (including metaphysical database administration) and will help you with everything from design questions and administration pointers, to coding tips. But you've got to be just a wee bit more specific. Have fun. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 RAYMOND ro.com.my> cc: Sent by: Subject: Re: Data Conversion procedural [EMAIL PROTECTED] om 03/26/2002 08:23 PM Please respond to ORACLE-L Hi Friend Currently I'm going to do a conversion for our client to convert their system into our Oracle 8i Db.. I have prepare the package/function/procedure... and some of those script for the system. Did you all have any conversion checklist for the purpose ?? Should I do a benchmarking first ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: RAYMOND 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: 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: pL/SQL PROCEDUR
Roland, What a surprise! I thought you were moving to an Access list? Because I've taken a rather perverse interest in the questions you ask, I'll give you a hint: triggers and exception handling. By the way, if no one has answered your question regarding a "table of table definitions", it's probably because they are suffering from shock. You are the DBA, are you not? This information already exists in a number of cleverly designed Oracle supplied views. I suggest you become familiar with the DBA_ views and the V$ views. A simple SQL query (which of course you'll ask for someone to provide an example) should get you all the information your heart desires. Study your craft my friend. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please respond to ORACLE-L Hallo, > > Can anyone give me an example on a pl/sql code, which does the following: > > I have 4 procedures, and I want the following to be logged in a status > table. > > Procedure names > Start_time of procedure > End_time_of procedure > Error_code(if anything goes wrong) > Error_message > > Please give me example onhow to write the code and also tell me how to pick > out the procedure_name, start_time of_procedure, end_time_ptocedure, > error_code, error_message. > > Thanks in advance.And just dontgive me a link, i wantthis real example too. > > Roland S -- 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: 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).
process last non-idle time
>From v$sesstat - is this in seconds since the epoch? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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).
Electronic Laser Forms - Any recommendations?
Can anybody recommend a printing package for Oracle? We have a number of forms that need to be populated with Oracle data. Examples are Report Cards, Progress Reports, Immunization Letters. The format of these changes, so we need to have the ability to modify the ELF in-house. The platform is UNIX (HP-UX), and the printers are HPs(9000). David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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).
Re: Excel to Oracle
sqlldr David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Rick_Cale@team health.com To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Excel to Oracle om 03/18/2002 09:43 AM Please respond to ORACLE-L Hi All, What is the best/quickest way to move data from excel to Oracle? Thanks Rick -- 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: 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 on windows Advance Server is not starting Automatic
Just a thought - You can't install over Terminal Services Client. You must be at a console. If you use Terminal Services, the install will appear to complete properly, but the database will never work properly. Ran into this on my first W2K install. Don't know if this helps, but you're description of the functionality difficulties and errors messages is eerily reminiscent of the problems I encountered. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Praveen Sahni shema.com> cc: Sent by: Subject: RE: Oracle 9i on windows Advance Server is not starting [EMAIL PROTECTED]Automatic 03/05/2002 09:58 PM Please respond to ORACLE-L The services are set to start automatically and version for the Oracle is (Oracle Standard Edition 9.0.1) on windows and we open a tar with oracle india suppport but no help as of now. we have reinstalled Operating system (Windows Advance Server with service pack II) and Oracle Standard Edition 9.0.1 but same error. Oracle SID autostart is set TRUE in Windows Registry. I've forgot to mention one more thing. whenever we restart the system oradim.log shows ORA-01078. Then if we tried to login using system/manager, it gives ORA-01034 and ORA-27101 Oracle is being installed on the cluster environment having two nodes with same configuaration. Windows Advanced server is installed on both systems. we have installed Oracle software (Oracle Standard Edition 9.0.1) on both the systems and created database from an active cluster Node. I switched off the second node whenever I am restarting the system so that only node will be active always. I have reinstalled oracle and created the database through dbca. I am getting the same error messages this time also. I have searched for the similar postings in metalink and tried the following 1.Increase/decreasing the size of SGA 2.commented the dispatchers= (MTS option) in init.ora 3.commented SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora oracle_sid and oracle_home are set properly. Registry entry for Oracle SID PFILE was pointing to e:\oracle\ora91\DATABASE\init.ora when I created database using dbca. When this doesn't worked out, I changed it to d:\oracle\admin\\pfile\init.ora where the init.ora is actually present. Apart from ORA-01078 I am not getting any other errors/logs. Oracle service is starting automatically but the database is not starting. If I manually restart the service/ startup using SQL*PLUS database comes up normally and works fine. Are there any previleges required from OS? (ORA_DBA account is present with Administrator as its member) I am loging in as Administrator. How to check whether the user has required previleges/not? We have created a small DB on the Node (not involving cluster) and its work fine. Please let me know where the problem can be. Thanks in advance Praveen -Original Message- Sent: Wednesday, March 06, 2002 3:13 AM To: Multiple recipients of list ORACLE-L Automatically How was the service created? Is it set to automatically start? Jared.Still @radisys.com To: Multiple recipients of list ORACLE-L Sent by: root<[EMAIL PROTECTED]> cc: Subject: Re: Oracle 9i on windows Advance 03/05/2002 Server is not starting Automatically 01:08 PM Please respond to ORACLE-L It might be possible for someone to help you if you include the
RE: vxfs File System full - it's not, and it's not Oracle (I don'
Thanks John, I felt (still feel) a bit dense asking the question myself, but our SA is basically clueless, the box runs Oracle, so it's an Oracle problem since extents are involved right? Anyway, in between other things, I've been doing some research, and it may have to do with a "lost" inode. I asked the SA about running an fsck on the file system, and he told me he'd get back to me. I was hoping that someone on the list had experienced something similar and could give me some pointers. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Hallas John llnet.net> cc: Sent by:Subject: RE: vxfs File System full - it's not, and it's not Oracle (I [EMAIL PROTECTED] don' 03/01/2002 07:23 AM Please respond to ORACLE-L David, Why does the SA say it is an Oracle issue? The error message shown refers to a LV that is full (allegedly) that happens to contain some files owned by the oracle user. Sorry if I am being a bit dense but I am doing my best :-) John -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 28 February 2002 16:39 To: Multiple recipients of list ORACLE-L think) My sysadmin is complaining about an Oracle(?) error on our HP9000, HP_UX v11.0, running three Oracle 8.1.7.0 instances. His error message is as follows: vxfs: mesg 001: vx_nospace - /dev/vgt001/lvol1 file system full (1 block extent) This file system has my /u001/app/oracle.. OFA compliant stuff on it. A df -k shows me the following: qe2l1:oracle /u001/app/oracle/admin/sasidist/bdump>>df -k . /u001 (/dev/vgt001/lvol1 ) : 7096543 total allocated Kb 1729572 free allocated Kb 5366971 used allocated Kb 75 % allocation used Nothing in any of the alert logs, the databases are up and functioning with several hundred users logged in and working away. The sysadmin has told damagement that it's Oracle's fault the backups aren't working (I don't trust the tape setup, and let them think they're backing up the DBs, but backups are run to disk and they get the compressed TAR'd result on tape - I hope). I have my doubts, but am thinking the error might have something to do with OmniBack, absent Oracle. Metalink doesn't have anything on this, and there are some questions I've found on Google, but no answers yet. Any input (well...almost any input) would be appreciated David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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). = This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information i
vxfs File System full - it's not, and it's not Oracle (I don't think)
My sysadmin is complaining about an Oracle(?) error on our HP9000, HP_UX v11.0, running three Oracle 8.1.7.0 instances. His error message is as follows: vxfs: mesg 001: vx_nospace - /dev/vgt001/lvol1 file system full (1 block extent) This file system has my /u001/app/oracle.. OFA compliant stuff on it. A df -k shows me the following: qe2l1:oracle /u001/app/oracle/admin/sasidist/bdump>>df -k . /u001 (/dev/vgt001/lvol1 ) : 7096543 total allocated Kb 1729572 free allocated Kb 5366971 used allocated Kb 75 % allocation used Nothing in any of the alert logs, the databases are up and functioning with several hundred users logged in and working away. The sysadmin has told damagement that it's Oracle's fault the backups aren't working (I don't trust the tape setup, and let them think they're backing up the DBs, but backups are run to disk and they get the compressed TAR'd result on tape - I hope). I have my doubts, but am thinking the error might have something to do with OmniBack, absent Oracle. Metalink doesn't have anything on this, and there are some questions I've found on Google, but no answers yet. Any input (well...almost any input) would be appreciated David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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).
Re: how to kill Distributed transaction
Do you have a transaction hanging on another database? Any entries in any of the alert logs for the participants? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Harvinder Singh aTech.com> cc: Sent by:Subject: how to kill Distributed transaction [EMAIL PROTECTED] 02/20/2002 12:53 PM Please respond to ORACLE-L Hi, We have 1 transaction hanging even if we restart the database. there is 1 entry in table dba_2pc_pending and 2 entries in dba_2pc_neighbours... How to release this transaction Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh 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: 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: Weird ODBC Issue
Welcome to the real world Mladen. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Gogala, Mladen" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Weird ODBC Issue Sent by: [EMAIL PROTECTED] om 02/18/2002 09:38 AM Please respond to ORACLE-L What good is a table without a primary key? I know that some duhsigners sometimes create them, but the DBA should attempt to block shuch a duhsign. -Original Message- Sent: Monday, February 18, 2002 9:43 AM To: Multiple recipients of list ORACLE-L Do they have primary keys? I seem to remeber that Access needed the Oracle table to have a primary key on it. -Original Message- Sent: Friday, February 15, 2002 4:43 PM To: Multiple recipients of list ORACLE-L No clue. User installed. -Original Message- Sent: Friday, February 15, 2002 4:14 PM To: Multiple recipients of list ORACLE-L What ODBC Driver are you using? I've seen this with certain builds of Microsoft's driver, really quirky on W98. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Bellows, Bambi" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Weird ODBC Issue Sent by: [EMAIL PROTECTED] om 02/15/2002 11:34 AM Please respond to ORACLE-L I'm not exactly sure why, but I have a user who wants to see Oracle tables in Access. Whatever. So, the user can go into our pal SCOTT/TIGER no problem and look at tables from user_tables (not all_tables, which I find weird, but, what the hay). But, if the user tries to go into APPS/APPS, he can only see one table, and that one is owned by ADS. Anyone have similar problems? Any clue as to a resolution? Let me know... Yer pal, Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi 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: 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: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Di
Re: Weird ODBC Issue
What ODBC Driver are you using? I've seen this with certain builds of Microsoft's driver, really quirky on W98. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Bellows, Bambi" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Weird ODBC Issue Sent by: [EMAIL PROTECTED] om 02/15/2002 11:34 AM Please respond to ORACLE-L I'm not exactly sure why, but I have a user who wants to see Oracle tables in Access. Whatever. So, the user can go into our pal SCOTT/TIGER no problem and look at tables from user_tables (not all_tables, which I find weird, but, what the hay). But, if the user tries to go into APPS/APPS, he can only see one table, and that one is owned by ADS. Anyone have similar problems? Any clue as to a resolution? Let me know... Yer pal, Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi 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: 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: ora -01122
You can't restore a datafile from a full export. Tables and tablespaces, yes. That's why I asked about the availability of redo logs. Unfortunately, 1242 is generally a hardware error, usually a defective drive. On Sun, it sometimes is a hiccup, the drive either doesn't start or isn't seen properly for a short period, but the datafile header becomes corrupted as a result. If you're sure the drive is operating properly (get it replaced anyway), can you do a startup mount? Your datafile recovery will go as follows: (Got this some time ago from Metalink I think - might have been off this list, or from the "Backup and Recovery Handbook" - anyway, it works, but I didn't invent it) I'd back up the database first - and in the step to recreate the datafile, change the name and location, using: SVRMGR> alter database create datafile 2> '/dev1/oracle/dbs/mybadfile.dbf' 3> as 4> '/dev2/oracle/dbs/mygoodnewfile.dbf'; SVRMGR>startup mount SVRMGR> select * from v$recover_file; SAMPLE: FILE# ONLINE ERROR CHANGE#TIME -- --- -- -- 11 OFFLINE FILE NOT FOUND 0 01/01/88 00:00:00 (Noting the file number that was reported in the error) SVRMGR> select * from v$datafile where FILE#=11; SAMPLE: FILE# STATUS ENABLED CHECKPOINT BYTES CREATE_BYT NAME -- --- --
Re: Unixscript
Roland,I take my life in my hands, but here goes..The script you are looking for doesn't exist per se. There are a number of variables involved in the transaction you describe (transferring a file from Unix to PC) that need to be defined before a solution can be developed.1. Who will inititiate the transaction, the person requesting the file (user) or the file generator (developer, DBA, Sys Admin, or even perhaps the user)?2. Is the file produced automatically (like a daily report via stored procedured for instance), or on demand, either by a systems person or by the user via some interactive process (web)?3. What type of security is involved/required? Will the transaction take place through a firewall, over the company LAN/WAN/Intranet? How is the user allowed access/authentication into the Unix system? How is the system allowed access/authentication to the PC?These are some basic questions that need to be answered. Cron jobs using ftp or telnet are a possibility. E-Mail. Internet/Intranet delivery via any of a number of ways. The permutations are part of the challenge that keeps us employed, the investigation of the methodology and technology part of the challenge that keeps us employable David A. BarbourOracle DBA, OCPAISD512-414-1002 [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]02/15/2002 03:53 AM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Subject: Unixscript Hallo,Anyone who has a good example on a unix script, which does the following:Copies files from a unix directory. to the hard drive, for instance from the directory /konto/testto the hard drive C:\tempWould appreciate this if you could help me with this.Thanks in advanceRoland--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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- 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).
RE: ora -01122
Just thinking out loud here (anybody feel free to jump in on this) - if you've still got your redo logs, you might be able to try a datafile recovery. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 - Forwarded by David Barbour/CAC/AISD on 02/14/2002 04:51 PM - David Barbour To: [EMAIL PROTECTED] 02/14/2002 cc: 03:50 PM Subject: RE: ora -01122(Document link: David Barbour) Did you make the export before or after the crash? What does your alert log say? Any trace files generated in cdump, udump, bdump? Any system error messages generated? Without being in archivelog mode, given the information you've provided, your only course may be to restore the export. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Hamid Alavi ovadx.com>cc: Sent by: Subject: RE: ora -01122 [EMAIL PROTECTED] m 02/14/2002 02:38 PM Please respond to ORACLE-L Hi, Database shutdown by itseld(don't know why) then I try to started get the error for datafile. We are running oracle 8.1.6 on unix the only backup which i have is full export from the instance(including all schema's). We are in development phase and not running archivelog mode. My last backup was at 10:00 AM today. Thanks all for your help. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Well, looks like you have a recovery scenario on your hands. What version of Oracle are you on? What is your Operating System/platform? In what manner did the database stop that now requires you to start it up? Are you in archivelog mode? When was you last backup? Was it hot or cold? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Hamid Alavi ovadx.com>cc: Sent by: Subject: ora -01122 [EMAIL PROTECTED] m 02/14/2002 01:03 PM Please respond to ORACLE-L Hi list, I have an urgent problem for startup database when I try to stratup database I get this error: ora-01122 database file 29 failed verification check ora-01110 data file 29 databaseQDX.dbf ora-01251 unknown file header version read for file 29 Please if any body have any idea is very very urget Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error
RE: ora -01122
Did you make the export before or after the crash? What does your alert log say? Any trace files generated in cdump, udump, bdump? Any system error messages generated? Without being in archivelog mode, given the information you've provided, your only course may be to restore the export. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Hamid Alavi ovadx.com>cc: Sent by: Subject: RE: ora -01122 [EMAIL PROTECTED] m 02/14/2002 02:38 PM Please respond to ORACLE-L Hi, Database shutdown by itseld(don't know why) then I try to started get the error for datafile. We are running oracle 8.1.6 on unix the only backup which i have is full export from the instance(including all schema's). We are in development phase and not running archivelog mode. My last backup was at 10:00 AM today. Thanks all for your help. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Well, looks like you have a recovery scenario on your hands. What version of Oracle are you on? What is your Operating System/platform? In what manner did the database stop that now requires you to start it up? Are you in archivelog mode? When was you last backup? Was it hot or cold? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Hamid Alavi ovadx.com>cc: Sent by: Subject: ora -01122 [EMAIL PROTECTED] m 02/14/2002 01:03 PM Please respond to ORACLE-L Hi list, I have an urgent problem for startup database when I try to stratup database I get this error: ora-01122 database file 29 failed verification check ora-01110 data file 29 databaseQDX.dbf ora-01251 unknown file header version read for file 29 Please if any body have any idea is very very urget Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists ---
Re: ora -01122
Well, looks like you have a recovery scenario on your hands. What version of Oracle are you on? What is your Operating System/platform? In what manner did the database stop that now requires you to start it up? Are you in archivelog mode? When was you last backup? Was it hot or cold? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Hamid Alavi ovadx.com>cc: Sent by: Subject: ora -01122 [EMAIL PROTECTED] m 02/14/2002 01:03 PM Please respond to ORACLE-L Hi list, I have an urgent problem for startup database when I try to stratup database I get this error: ora-01122 database file 29 failed verification check ora-01110 data file 29 databaseQDX.dbf ora-01251 unknown file header version read for file 29 Please if any body have any idea is very very urget Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: 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: View for Procedure/Function SQL Code
user_source? all_source? dba_source? David A. BarbourOracle DBA, OCPAISD512-414-1002 Abdul Aleem <[EMAIL PROTECTED]>Sent by: [EMAIL PROTECTED]02/13/2002 11:13 PM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Subject: View for Procedure/Function SQL Code Hi!Is there a view to see the code written in the procedure/function code, theparameters, return types etc.TIA!Aleem--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Abdul Aleem INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- 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).
RE: Changing dump destinations in init.ora
Just remember to make the change in your init.ora file if you want it to be permanent. Otherwise, the next time you bounce the DB the destinations will revert to whatever they are in that file. David A. BarbourOracle DBA, OCPAISD512-414-1002 "K Gopalakrishnan" <[EMAIL PROTECTED]>Sent by: [EMAIL PROTECTED]02/13/2002 01:14 PM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Subject: RE: Changing dump destinations in init.ora No need to bounce the instance. You can dynamically chance the locationusing ALTER SYSTEM command.Best Regards,K GopalakrishnanBangalore, INDIA-Original Message-Thomas FSent: Wednesday, February 13, 2002 12:49 PMTo: Multiple recipients of list ORACLE-LNope. Create the new directory, change them in the file and bounce theinstance.Tom MercadanteOracle Certified Professional-Original Message-Sent: Wednesday, February 13, 2002 3:19 PMTo: Multiple recipients of list ORACLE-LDo I have to rebuild the controlfiles if I change any of the dumpdestinationsin my oracle init.ora files.ThanksDarren--Darren Browett P.Eng This messagewas transmittedData Administratorusing 100%recycled electronsInformation and Communication TechnologyCity of CoquitlamP:(604)927 - 3614E:[EMAIL PROTECTED]-Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Browett, Darren INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Mercadante, Thomas F INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing)._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: K Gopalakrishnan INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- 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).
Re: URGENT: need help by point in time recovery
Don't do #1 or #5. Make sure you don't restore redo logs in #2. Step #4 - Startup Mount Step #6 - recover database until time '-MM-DD:HH:MI:SS'using backup controlfile; THEN alter database open resetlogs; David A. Barbour Oracle DBA, OCP AISD 512-414-1002 v.schoen@inpla n.de To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: URGENT: need help by point in time recovery om 02/13/2002 02:32 PM Please respond to ORACLE-L Hi list, I have a urgent problem. One of our developers has deleted all rows of a table on production database (database of a customer from us). We have a nightly cold backup and database is running in archivelog mode. On same server we have a test instance which has same structure as prod instance, only the folders are others. What I like to do is: 1. go to production and backup controlfile to trace 2. copy the cold backup (production) from last night into this test instance folders (datafiles, controlfiles...) 3. copy archive logs of production to archive log folders from test 4. startup testinstance nomaount 5. create new controlfile with backuped controlfile from trace 6. recover database until '-dd-mm hh: 7. export deleted table and import it in production database My question is, if I make a clone of a database from a nightly cold backup, can I recover the database with newer archivelogs. Or is there any other method to get my data back (I don't have a actual export of database)? TIA Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de -- 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).
Re: renaming datafiles
Think about it for just a minute. Focus on the parts: If the database is open. If the database is mounted but closed . David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Bill Becker lin.edu> cc: Sent by: Subject: renaming datafiles [EMAIL PROTECTED] om 02/13/2002 10:58 AM Please respond to ORACLE-L Hello, Oracle 8.1.6 on Solaris 2.7. Our test database is not available to play with for a while, and I was wondering about the following: What is the difference between ALTER TABLESPACE RENAME DATAFILE... and ALTER DATABASE RENAME DATAFILE...? The administrator's guide says "If the tablespace is offline but the database is open, use the ALTER TABLESPACE...RENAME DATAFILE statement. If the database is mounted but closed, use the ALTER DATABASE...RENAME DATAFILE statement." While researching this issue, I came across Doc ID: Note:115424.1 on metalink, which contains an example of renaming/relocating datafiles while the database is open using the ALTER DATABASE command. This appears to contradict the administrator's guide. Which is correct? Can ALTER DATABASE be used in either case (database open, tblspace offline, or database in starup mount mode), while ALTER TABLESPACE can only be used if the database is open and the tblspc is offline? Also, the same note referenced above lists the following steps for moving datafiles while the database is up: 1) alter tablespace tbname read only; 2) copy the datafile(s) with os utility 3) alter tablespace tbname offline; 4) alter database rename datafile '...' to '...'; 5) alter tablespace tbname online; 6) alter tablespace read write; Would the following also work? I am thinking that the only reason the note lists the above method is to minimize the time the tablespace is offline. 1) alter tablespace tbname offline; 2) copy the datafile(s) with os utility 3) alter database rename datafile '...' to '...'; (or, alter tablespace rename datafile '...' to '...', not sure which should be used) 4) alter tablespace tbname online; Thanks to any responders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Becker 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: 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: Tkprof.
Check OTN. Signup is free, , they've never hassled or spammed me, and the documentation is invaluable. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Rajesh Dayal ecom.com>cc: Sent by: Subject: RE: Tkprof. [EMAIL PROTECTED] om 02/05/2002 12:15 AM Please respond to ORACLE-L Just type tkprof on command line (DOS) or on shell prompt (UNIX), You would find the help and all your doubts would be cleared. HTH, Rajesh -Original Message- Sent: Tuesday, February 05, 2002 9:15 AM To: Multiple recipients of list ORACLE-L Hi all I am having a doubt in how to use Tkprof. This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ayyappan S 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: Rajesh Dayal 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: 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: NOHUP SQLPLUS
Run in background with the & and you shouldn't have a terminal problem (others are certainly possible). Try 'nohup sqlplus system/* @long_running.sql &' Test this of course with another procedure before you it's a do or die situation. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Erik Williams wnco.com>cc: Sent by: Subject: NOHUP SQLPLUS [EMAIL PROTECTED] om 02/04/2002 01:12 PM Please respond to ORACLE-L I am going to be executing a long running job this weekend from home. I am going to VPN into the corp network and telnet to the server. I am affraid of loosing my telnet terminal session and the job dying mid way through. The plan is to use 'nohup sqlplus system/* @long_running.sql'. Has anyone used this or run into issues using it? Every time I assume something will 'just work', IT DOESNT! Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams 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: 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: OT : ERP tool for evaluation
I have no idea who told you to "pick up a copy for evaluation," but it shows that person's lack of knowledge about ERP packages. They're complex, and won't work out of the box without configuration. It's the configuration that consumes the bulk of an implementation, both in dollars and time. Even if you go with a completely "standard" install, you'll still need to do a lot of data conversion. That being said, you can't get an evaluation copy of any of these, because they won't work. Besides, none of the vendors want you to find out it'll take 30 days just to install before your your users ever get to see it. Going back to the person who requested you come up with an evaluation copy, if this is their level of understanding in regards to ERP and they're in any type of position to recommend it, your firm will underestimate the cost and complexity of the project, which will either fail and possibly financially ruin your company, or will succeed and financially ruin your company. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Andrey Bronfin esoft.com> cc: Sent by:Subject: OT : ERP tool for evaluation [EMAIL PROTECTED] 02/04/2002 12:07 PM Please respond to ORACLE-L Dear all ! I need to get an ERP package / tools such as Oracle Applications / SAP / PeopleSoft etc Would anyone please suggest where can i get it for evaluation, i.e. free or fairly cheap for a limited time period. Thanks a lot! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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: 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: OCOPY
No
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
"Keith Worley"
lstar.org> cc:
Sent by:Subject: OCOPY
[EMAIL PROTECTED]
01/30/2002 05:15
PM
Please respond to
ORACLE-L
Does the database need to be running in archive log mode in order to use
OCOPY?
Thanks;
Keith Worley
> Confidentiality Disclaimer
This email and any files transmitted with it may contain confidential and
/or proprietary information in the possession of WellStar Health System,
Inc. ("WellStar") and is intended only for the individual or entity to whom
addressed. This email may contain information that is held to be
privileged, confidential and exempt from disclosure under applicable law.
If the reader of this message is not the intended recipient, you are hereby
notified that any unauthorized access, dissemination, distribution or
copying of any information from this email is strictly prohibited, and may
subject you to criminal and/or civil liability. If you have received this
email in error, please notify the sender by reply email and then delete
this email and its attachments from your computer. Thank you.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Keith Worley
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:
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: sqlplus question
Roland, No fair changing your name. UNIX cron, NT @scheduler, dbms_jobs, or a combination. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 lhoska@calibre sys.com To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: sqlplus question om 01/28/2002 04:21 PM Please respond to ORACLE-L Hello, I need to run some script using Oracle Sqlplus. The script is only suppose to run certain days of week. Does anyone have a suggestion how to do that. Thank you. -- 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: 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: Access support
Giving up on Oracle? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Access support om 01/28/2002 09:35 AM Please respond to ORACLE-L Hallo, anyone who knows about a website with good Access tips? Thanks in advance Roland -- 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: 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: FW: Electrical background
Ooops ... Rectifiers convert AC to DC, Inverters convert DC to AC (My wife would be lost when we go car camping without my handy Inverter!). "Guidry, Chris" ctric.com> cc: Sent by:Subject: RE: FW: Electrical background [EMAIL PROTECTED] 01/24/2002 03:10 PM Please respond to ORACLE-L That would be a Rectifier. Inverters change AC to DC. Converters change the frequency of AC to AC. -- Chris J. Guidry P.Eng. EE ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] > -Original Message- > From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, January 24, 2002 10:56 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: FW: Electrical background > > Regular relays do not hum. If it does this means it's switching on and off > at certain frequency on which it's designed. Then it's not a relay it > could > be one of these devices that convert DC to AC. > > -Original Message- > Sent: Thursday, January 24, 2002 10:15 AM > To: Multiple recipients of list ORACLE-L > > > Is it natural for relays to hum? > > -Original Message- > > SO, what did you want? > > Dick Goulet > Ancient Electronics Tech & tinkerer, Also certified relay NUT > > Reply Separator > Author: "Adams; Matthew (GEA; 088130)" <[EMAIL PROTECTED]> > Date: 1/23/2002 10:30 AM > > Sorry folks, that went to the wrong list. I apologize. We now return you > to > your > regularly scheduled Oracle discussion. > > > Matt Adams - GE Appliances - [EMAIL PROTECTED] > > > -Original Message- > > From: Adams, Matthew (GEA, 088130) > > > > > > Anybody got a EE or electronics background? > > I've got a question about relays. > > > > > Matt Adams - GE Appliances - [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mohan, Ross > 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: Khedr, Waleed > 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: Guidry, Chris 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
Re: Moving databases from WIN2K to Unix
Real easy - Precreate your DB on UNIX. Create tablespaces, datafiles, rollbacksegs. Export from NT (sorry, W2K), import to UNIX. We've got a student app the vendor swore would run ONLY on a W2K Oracle DB. Have written web apps for the schools to access/generate reports. Ran out of space, moved it to UNIX (HP_UX), never missed a beat. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Johnson Poovathummoott To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> il cc: Sent by: [EMAIL PROTECTED] om 01/21/2002 05:30 PM Please respond to ORACLE-L Hi All, We plan to move our OLTP databases which were accessed through the internet to Sun Solaris. Could someone who has done such a thing already tell me if there is anything I should look out for in this process? Thanks. __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil 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: 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: HP vs SUN for a UNIX box
IBM David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Babich , Sergey" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: HP vs SUN for a UNIX box Sent by: [EMAIL PROTECTED] om 01/18/2002 12:50 PM Please respond to ORACLE-L Hi, dear listers, My boss has decided to switch production to a UNIX box and now he's asking me for a recommendation between HP and SUN. I am a newbee to UNIX (to put it the softest way). I've heard people say HP is better, but need more than that... The DB itself is about 40G on RAID (currently on Windoze 2k). Any advice is greatly appreciated. Regards, Sergey Babich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey 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: 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: Trouble with imp on 8.1.6
What does your imp command look like? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Rick_Cale@team health.com To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Trouble with imp on 8.1.6 om 01/18/2002 09:00 AM Please respond to ORACLE-L Hi All, I did a successfull export on 8.1.6 for user= I am trying to import on same server into another user. I get following message but no tables are created? I have full privs. Can someone help? Connected to: Oracle8i Release 8.1.6.0.0 - Production JServer Release 8.1.6.0.0 - Production Export file created by EXPORT:V08.01.06 via conventional path import done in WE8ISO8859P1 character set and US7ASCII NCHAR character set import server uses US7ASCII character set (possible charset conversion) Import terminated successfully without warnings. Thanks Rick -- 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: 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 not available ???
Nagaraj, Yes, you may indeed have a problem. You say you backed up the datafiles. Did you get the redo logs and controlfile? How did your DB go down? Did it crash, or were you able to shut it down? If you're not in archivelog mode, are the redo logs that were current at the time of the most recent backup available? David A. BarbourOracle DBA, OCPAISD512-414-1002 "Nagaraj Panyam" <[EMAIL PROTECTED]>Sent by: [EMAIL PROTECTED]01/01/2002 11:55 AM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Subject: RE: oracle not available ??? Hi listI have a database recovery problem.The scenario is like thisa) My database is not in archive mode.b) I have taken a cold back up on two different times. 6 data files inthe morning and 6 in the evening. In between the database was startedand againWas shutdown before taking back up in the evening.I want to recover the database completely but I don't mind losing thedata of the period between the back ups.Can any one have solution.Thanks in advanceNAGARAJ--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Nagaraj Panyam INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- 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).
RE: XP Professional & 9i
Ken, See if your client doesn't have a CSI number with which they'll let you register. Just for grins and giggles, can you divulge the conversion you're working on? David A. BarbourOracle DBA, OCPAISD512-414-1002 Ken Janusz <[EMAIL PROTECTED]>Sent by: [EMAIL PROTECTED]12/29/2001 09:55 AM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Subject: RE: XP Professional & 9i Jared:We are not on MetaStink because my company won't pay for it. It's theirproblem not mine.Ken -Original Message-Sent:Saturday, December 29, 2001 11:15 AMTo:Multiple recipients of list ORACLE-LSubject:Re: XP Professional & 9iThat brings rise to the question "Why aren't youa member of MetaStink?"Have you purchased Oracle Support? If so, you likelyhave access to MetaLink. If not, you need to.You'll never be able to successfully implement an Oraclebased application on 9i without support. You at least needto have access to patches.JaredOn Saturday 29 December 2001 06:25, Ken Janusz wrote:> We are not a member of metastink. I looked at OTN an it's only certified> up to W2000. So, I was wondering if anyone knew if it is cert. for XP> Prof. or when it will be?>> Thanks,> Ken>> -Original Message-> Sent:Saturday, December 29, 2001 7:50 AM> To:Multiple recipients of list ORACLE-L> Subject:Re: XP Professional & 9i>> Ken, go to metalstink and look for the certification matrix.>> joe>> Ken Janusz wrote:> > Will 9i run on XP Professional client? And, no I am not interested in> > putting Linux on my home PC at this time.> >> > Thanks,> > Ken Janusz, CPIM> > Database Conversion Lead> > Sufficient Systems, Inc.> > Minneapolis, MN--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Jared Still INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Ken Janusz INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- 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).
RE: RE: database administration questions
Evelyn Wood David A. BarbourOracle DBA, OCPAISD512-414-1002 "Boivin, Patrice J" <[EMAIL PROTECTED]>Sent by: [EMAIL PROTECTED]12/27/2001 10:50 AM PSTPlease respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: bcc: Subject: RE: RE: database administration questions A problem with RTFM is when the manual is over 10,000 pages long.Regards,Patrice BoivinSystems Analyst (Oracle Certified DBA) -Original Message-Sent:Thursday, December 27, 2001 2:15 PMTo:Multiple recipients of list ORACLE-LSubject:RE: RE: database administration questionsYeah, once they find out this job isn't a cakewalk, they vanish.For those that:* live for challenge* are afraid of nothing and not intimidated by complexity* make that, 'love complexity' )* can't forget about a problem until it's fixed* willing to RTFM til they drop* design and execute tests to understand how things work* RTFM some more* drive technology. Hey, there's more to a good DBA than databases.* did I mention RTFM?* learn from their mistakes* admit they make mistakes* RTFM to minimize mistakesAll others need not apply.Jared"No guts, no glory" ) "Kimberly Smith" To: Multiple recipients oflist ORACLE-L <[EMAIL PROTECTED]> tlink.net> Subject: RE: RE: databaseadministration questions Sent by: [EMAIL PROTECTED] m 12/27/01 09:00 AM Please respond to ORACLE-LYou need to find some new cooks then.-Original Message-[EMAIL PROTECTED]Sent: Thursday, December 27, 2001 6:50 AMTo: Multiple recipients of list ORACLE-LIn our shop we've tried the cross training tact. Problem was that thosewhoaccepted the challenge could not take the heat, so they left the kitchen.Damn!!!Dick GouletReply SeparatorAuthor: "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>Date: 12/26/2001 4:50 PMI quite agree with Kimberly. I used to be a full-fledge Oracle programmerbut wanted to dabble with database administration. I asked my boss whetherIcould be a database administrator. His answer is yes but I still need tomaintain my current systems. Now, I am a databaseadministrator-cum-programmer. I support turnkey projects, automateprocesses for my users, maintain current projects, install/maintaindatabase& support Oracle Applications etc.Prepare for lots of OT but what the heck, U will get to learn a lots ofinteresting things in the process New Bees -Original Message- From: Kimberly Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 27, 2001 1:40 AM To: Multiple recipients of list ORACLE-L Subject: RE: database administration questions If you work on a site like I do you could always crosstrain. I am always looking for suckers (um, people) to be my backup. RightnowI use one from the Unix team and one from the development team. Its theonly way I get to take vacations and what no. Check with your current DBAandsee if they are willing to train you while you are off doing your 'real'job. Of course, there are some folks who are worried about job security (orare just assholes) and they would not give you the time of day. You don'twantto learn from those folks anyway. The excuse, "I'm too busy" is notreally valid either. Training someone allowed me to offload some of my work. -Original Message- [EMAIL PROTECTED] Sent: Wednesday, December 26, 2001 5:30 AM To: Multiple recipients of list ORACLE-L With your current background, your more likely to land ajobas a network administrator LONG before you'll end up in a databaseposition. Access is still looked on as a single user system and frankly I haven't runinto any large scale applications that use it, period. One of my current tasksis working with a forecasting package that states in the manual that Accessshould only be used for the demos. Any other application of the package shoulduse Oracle or DB2. Also a SPC (Statistical Process Control, for those whodon'tknow, don't ask further) package we're evaluating (actually two of them)won't work with Access even for the demos. Therefore, I'd suggest staying withthenetworking world. It will be around as long as database administration, ifnotlonger. Your already trained and certified, and getting a Ciscocertifica
Re: new work group servers recommendations
IBM AIX w/HACMP. If you factor in the service plan costs on all other boxes vs. IBMs 1-3 year we cover everything and after that service is less expensive than any one else's, you'll find the TCO for these units is anywhere from marginally less to way less than any alternative I've found. Haven't run Linux for a high-availability situation, if possible, could be the clear winner. Wintel has a place in the enterprise, but if you're going HA, be prepared to shell out the big bucks. Not a flack - just a satisfied user w/Sun, NT (W2K), and HP_UX experience. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ray Stell <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> .edu>cc: Sent by: Subject: new work group servers recommendations [EMAIL PROTECTED] om 12/17/2001 12:50 PM Please respond to ORACLE-L Shopping for workgroup servers, the sun rep is pushing a V880s with Sun Cluster 3 and OPS. OPS seems like yesterdays news. I was told that Ellison said at openworld that OPS is a signal failure. Anybody gone to intel/9i/RAC or is this stuff not really ready? If you were buying today for the next couple of years and need high availability, what would you go with? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: 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: Cannot Drop Column
Ken, I rarely log into any of my databases as SYS - too much mischief can be made (and I'm just the fumble-fingered guy to make it). There are very few columns owned by SYS. Most of these are in tables designed to support the database. You need to be REAL careful. Could be that the table you're in is currently in use by virtue of the fact you're logged in as SYS. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ken Janusz fsys.com>cc: Sent by: Subject: Cannot Drop Column [EMAIL PROTECTED] om 12/07/2001 10:05 AM Please respond to ORACLE-L 8.1.7 logged in as SYS. Will not let me drop a column because it belongs to SYS. If I am logged in as SYS why can't I drop a column owned by SYS? Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: 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 DB Connection Problem
Ken, You probably could use a DBA for support in your current project. Hasn't the company you're working with provided one? In any case, the error you're getting could be result of one of several things - it's W2K. First - generally the message "shared memory realm not available" means the SID you're using isn't available on that box. Usually due to the DB being down, but it could be for a host of other reasons. On W2K, making Oracle available had two parts, the windoze Oracle Services must be running, and the database must be mounted and open. Are both these conditions satisfied. Second - if your using terminal services client to access the server, depending on the version of the TSC, the SP of W2K, and the version of Oracle, you nay not be able to use SQL Plus from the command line if you are not a member of the "DBA" group, are using the bequeath protocol, or your environmental variables are not properly set. Third - kind of like #2, but check your environment with the SET command. Fourth - you have an incorrect TNS names entry, or your listener is improperly configured, or your sqlnet.ora file has a problem. Troubleshooting connection problems, while it can be almost be reduced to a checklisted science, is really more of an art. Hope this helps. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Ken Janusz fsys.com>cc: Sent by: Subject: Oracle DB Connection Problem [EMAIL PROTECTED] om 12/05/2001 07:30 PM Please respond to ORACLE-L 8.1.7 on Dell W2000 server. When I try to login via sqlplus I get this: ORA-01034 Oracle not available ORA-27101 shared memory realm doesn't exist Then I get: Login: Password: And this error: ORA-12560 TNS: protocol adapter error. Any ideas as to what the problem is? Thanks, Ken Janusz Sufficient Systems, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz 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: 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: Crontabs and Oracle
Thomas, I got called to task before on this, but I didn't save the note, so whoever corrected me, please do so again. In any case, cron jobs in UNIX are (and this is where I was corrected - although what follows should solve your problem) executed by root. This is why Mike suggested running the .profile to properly set up the environment to find and execute sqlplus. The user who "owns" the cron job is invoked by root without all the proper environmental variables set. As an alternative you can explicitly set your variables at the beginning of the shell script as follows (for ksh): #!/bin/ksh export ORACLE_SID=ifas export ORACLE_HOME=/u001/app/oracle/product/8.1.7 export PATH=$PATH:/u001/app/oracle/product/8.1.7/bin export ORACLE_BASE=/u001/app/oracle export HOME=$ORACLE_HOME cd $HOME Hope this helps. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Thomas, Kevin" anais.com> cc: Sent by:Subject: Crontabs and Oracle [EMAIL PROTECTED] 11/28/2001 05:00 AM Please respond to ORACLE-L Guys, I have a Unix shell script that runs and does some things with sqlplus. The script runs fine when I start it up manually just using the command $ host_startup.sh However, If I try to start this host_startup.sh from the Crontab I get this error logged in my mail. >From apt2 Wed Nov 28 08:15:01 2001 Date: Wed, 28 Nov 2001 08:15:01 GMT Message-Id: <[EMAIL PROTECTED]> To: apt2 Content-Length: 143 Your "cron" job on phys-ki-sun4k2 /ki-sun4k2/export/home/apt2/ta_web/host/host_startup.sh produced the following output: sqlplus: Command not found Any ideas? I've specifically said in the shell script where to find the sqlplus binaries, so I'm not sure?! Any help would be much appreciated. Cheers, Kev. "I put instant coffee in a microwave oven and almost went back in time. " __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 21 November 2001 12:20 To: Multiple recipients of list ORACLE-L Have a look at Categoric Xalerts. It is a general purpose Alerting system, not just for DBA and SYSADMs. Their new Java based system is just out. www.categoric.com Steve Parker Technical Consultant LIS -- Logistics & Internet Systems Ltd. E Mail: [EMAIL PROTECTED] -- Kumanan Balasundaram [EMAIL PROTECTED]> cc: Sent by: Subject: Reliable alerting system that is not so costly?? [EMAIL PROTECTED] 21/11/2001 11:50 Please respond to ORACLE-L Hi there, Any of you using or have come across a reliable alert system that can also escalate to different persons based on criteria such as how important that system is? We are looking to invest in such a software. Kumanan Balasundaram Database Administrator, IT QXL ricardo plc www.qxl.com P: +44 (0)208 962 7409 > QXL ricardo plc Registered Office Landmark House, Hammersmith Bridge Road, > London W6 9EJ > Registered in England No 3430894 VAT number - GB 701 8915 43 > > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entiti
Re: SVRMGRL and W2K
Lisa, Got bit by this first time out of the box with W2K. I don't have access to PCAnywhere, so I had to do the install from the console. I have however created a ton of .bat files that perform various functions that I can execute from Terminal Services. I found it necessary to use sqlplus with the 'connect as' string, but it gets me in just fine. If I don't have the script do something completely (backup, startup, shutdown, analyze, etc), I have a generic one that pops up a DOS Prompt screen and puts me at the SQL> prompt with sysdba privileges. Here's how I've done it (Perl is still on my list Jared): First file is login.bat set ORACLE_SID= < These are just for good measure, Registry and Environment SHOULD suffice, but it's Windoze set ORACLE_HOME=F:\oracle\ora81 sqlplus /nolog @F:\oracle\admin\system_scripts\sysconnect.sql exit Next file is sysconnect.sql connect sys/@ as sysdba That's it. Go in through terminal services, run login.bat, and you're home free. Everything else follows. Hope this helps. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Michael Netrusov To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Sent by: [EMAIL PROTECTED] om 11/27/2001 10:25 AM Please respond to ORACLE-L Yes, I've seen it. Oracle Installation, sqlplus, svrmgrl through Terminal Server Client do not work. I used PC Anywhere, everything went fine. HTH, Michael >From: Koivu, Lisa <[EMAIL PROTECTED]> >Subject: svrmgrl and W2k >Date: 27 Nov 01, 03:25 PM >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> -- Original message -- OH MY GOSH this sucks. Is anyone running 8.1.7 EE on W2k? I am trying to start the database (and the listener, for that matter) via Terminal Server and it keeps erring out with ORA-12560 protocol adapter error. I look on Metalink and it just plain says, Go to the console. WHAT? Are you KIDDING! Here's the note: * fact: Oracle Server - Enterprise Edition * fact: RDBMS * fact: MS Windows 2000 * fact: MS Windows NT * symptom: Cannot connect to SVRMGRL * symptom: ORA-12560: TNS:protocol adapter error * symptom: Cannot connect to SVRMGR30 * symptom: ORA-12203: TNS:unable to connect to destination * cause: Bequeath protocol is not supported with Microsoft Terminal Server Client. ORA-12203 is seen on Oracle 8.0.6. ORA-12560 is seen on Oracle8i. fix: Connecting to SVRMGRL is done by using the BEQUEATH protocol which is not available using an MS Windows 2000 Terminal Server Client. To startup the instance, use the the Windows 2000 console to connect to the SVRMGRL. I can do this with W2k, Terminal Server and Standard Edition. Has anyone else seen this ? I am so irked I could scream. (But it could be the hormones). Lisa Koivu Oracle Database Monkey. Fairfield Resorts, Inc. 954-935-4117 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Netrusov 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
RE: Sqlloader - important
I think it's really amazing how many people spotted the error. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Mercadante, Thomas F" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: ate.ny.us> Subject: RE: Sqlloader - important Sent by: [EMAIL PROTECTED] 11/13/2001 10:40 AM Please respond to ORACLE-L You are missing a comma and another single quote: orig==> (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)", new==> (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98','!','97', :KAMPANJTYP_ID)", Hope this helps! :) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 13, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)", KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S -- 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: Mercadante, Thomas F 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: 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: Sqlloader - important
You have mismatched quotes. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Sqlloader - important om 11/13/2001 09:45 AM Please respond to ORACLE-L Hallo, Why does this sqlloader ctl file give me this errormessage? the control file looks like: load data infile 'c:\kam\kampanj.txt' TRUNCATE into table kampanjtyp_kopia FIELDS TERMINATED BY ';' (KAMPANJTYP_ID "DECODE(:KAMPANJTYP_ID,'?','98'!','97', :KAMPANJTYP_ID)", KAMPANJTYP_NAMN) SQL*Loader-944: error preparing insert statement for table KAMPANJTYP_KOPIA. ORA-01756: quoted string not properly terminated Thanks in advance Roland S -- 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: 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: Inserts with different conditions in pl/sql
Use to_char, or to_number or a combination with replace, length, substr, translate, decode etc. to achieve your desired results. Do you have access to Metalink? Did you ever get a subscription to OTN? If you don't have any one of the numerous fine books (many authored by people on this list) which would really give you a much better foundation, OTN has lots of documentation on utilities, PL/SQL and database administration. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Inserts with different conditions in pl/sql om 11/13/2001 02:20 AM Please respond to ORACLE-L Hallo, How can I write in a pl/sql block if I want to do an insert from one table to another table and at the same time translate the value '?' to 98 and the value 'X' to 'Missing info' Both those values can exist in the first table. The datatyupe in table one is varchar2 and in table two it is numberdatatype. Please help me. Thanks in advance. Roland S -- 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: 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: Antwort: ORA - 12560: TNS: protocol adapter error
To find out what it is: In Windoze, type SET at the DOS prompt, in Unix, use the env command. To set it, in Windoze type set ORACLE_SID=, in Unix, it depends on your shell, but you might try export ORACLE_SID =. Somehow, I think this will not completely solve your problems. To look up errors, as well as some troubleshooting guides, you might want to check out OTN (I'm not their flack - I was referred to it my a list member 5+ years ago and it's helped me immensely). http://otn.oracle.com It's free. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "S.Jyotinaraya n" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Antwort: ORA - 12560: TNS: protocol adapter error Sent by: [EMAIL PROTECTED] om 11/12/2001 09:50 PM Please respond to ORACLE-L I am not sure if i have set ORACLE_SID, how could i check if it is set? If it is not set, how do i set it and i set it to what? Thanx in advance Jyotinarayan - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 12, 2001 6:20 PM > > Hi > did you set ORACLE_SID in your environment or registry? > Ivo > > > > > "S.Jyotinaray > an" An: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > o.com> Thema: ORA - 12560: TNS: protocol adapter error > Gesendet von: > root@fatcity. > com > > > 11/12/2001 > 10:30 AM > Bitte > antworten an > ORACLE-L > > > > > > > Hi, > I have installed your Oracle 8i EE trial software. > > When i am trying to connect through SQLPLUS with username: SCOTT and > password: TIGER i am getting the following error :- > "ORA - 12560: TNS: protocol adapter error". > > Could you tell why i am getting this error? > > What other information should i provide you? > > Thanx in advance > Jyotinarayan > > > > -- > 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). _ 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: S.Jyotinarayan 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 comm
Re: Another Oracle DBA gets "The Bullet" WAS: Help!: Job Description for
Thanks folks for the replies I got. Compiled them into a sort of superDeveloper/Data Architect/All-Around wonderful human being job description. The job market in Austin is really poor for us "high-tech" types right now. This was the home or a principal branch office of a large number of failed dot coms and Internet business ventures. A partial list of Austin failures includes (but is by no means limited to): Netpliance Hand Technologies ConnectSouth (my alma mater) DrKoop.Com Garden.Com Furniture.Com carOrder.Com Layoffs in many (most?) surviving companies have further added to the glut of talent out on the streets. Other large Austin employers reducing staff in the tech area include AMD, Motorola, SamSung, IBM, Perficient and CSC. Non-tech companies such as law firms, travel agencies (they're pretty much toast right now anyway), and advertising agencies have been really hurt by the abrupt cessation of money which used to flow from the startups. It's still a great place to live, but a month or two ago, even the Austin American-Statesman noted that the area was experiencing a "brain-drain" as the job-seeker/jobs ratio climbed ever higher. Last week, they posited the major reason for the area not experiencing a total employment tragedy was the abundance of State and Local jobs, which, until about 9 months ago, went begging as private industry vacuumed anybody who could spell "PC" off the street (if you could spell DBA you had it made). The Sunday help-wanted ads have gone from 4 full pages of "Computer Jobs" to less than two columns, and there are very few senior positions available. We even used to have out-of-town companies advertise, but that trend has dried up as well. It anin't pretty folks. Maybe Scott (I still think I ought to drive down just to meet the guy) in San Antonio can give us a more regional perspective. At the height of the frenzy, I know a bunch of people who left positions in SA to come to Austin. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Troiano, Paul (CAP, GEFA)" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Help!: Job Description for Data Architect Sent by: [EMAIL PROTECTED] 11/12/2001 05:40 PM Please respond to ORACLE-L How is the job market in Austin? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 4:00 PM To: Multiple recipients of list ORACLE-L Hey, the job market isn't any better (worse?) here in Austin-by-God, TX than anywhere else. We've got a chance to hire a real talented developer (worked with him before - taught me a lot), but his salary is just a bit more than the school district is used to paying for "programmers." I suggested they come up with a new job description to justify the salary (it's not that great folks - this guy just wants to stay in Austin). "Wonderful idea" says the boss, "what should we call the position to confuse the HR folks?" "Data Architect" I reply. "Great" says he, "write it up and have it on my desk by 5:30." Anybody got one I can shamelessly plagiarize? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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 EXA
Help!: Job Description for Data Architect
Hey, the job market isn't any better (worse?) here in Austin-by-God, TX than anywhere else. We've got a chance to hire a real talented developer (worked with him before - taught me a lot), but his salary is just a bit more than the school district is used to paying for "programmers." I suggested they come up with a new job description to justify the salary (it's not that great folks - this guy just wants to stay in Austin). "Wonderful idea" says the boss, "what should we call the position to confuse the HR folks?" "Data Architect" I reply. "Great" says he, "write it up and have it on my desk by 5:30." Anybody got one I can shamelessly plagiarize? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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).
Re: how to find files that are generated on a particular date
ls -al |grep 'Nov 10' David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Tatireddy, Shrinivas (MED, Keane)"To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: how to find files that are generated on a particular date Sent by: [EMAIL PROTECTED] 11/11/2001 11:35 PM Please respond to ORACLE-L Hi lists does anybody can post me a command In unix how can I find files generated on a particulat date example files generated on Nov 10 regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) 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: 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: Root to connect as system
Is root part of the dba group? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Sujatha Madan <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> wo.net.au> cc: Sent by: Subject: RE: Root to connect as system [EMAIL PROTECTED] 10/29/2001 09:30 PM Please respond to ORACLE-L Ok, I have solved the issue of the listener, however I still cannot get root to log on as system. - My Oracle home is set correct - My Oracle sid is set correct - ld library path is correct - other path;s are correct does anyone have an idea on how to fix this? thanx -Original Message- Sent: Tuesday, 30 October 2001 1:40 PM To: Multiple recipients of list ORACLE-L I have set the SID correct and all the environment variables correctly. What I didn't do was set up the listener and tnsnames. However, when I am trying to set up the listener, for some reason it is not able to find the executables. It is looking in a different directory. The Oracle Home is set correctly. -Original Message- Sent: Tuesday, 30 October 2001 12:20 PM To: Multiple recipients of list ORACLE-L Looks like your oracle sid is set incorrectly and you are trying to connect without using a tns service name Deepak PS: have you set the env variables .. type env at the unix prompt and check if PATH /ORACLE_HOME/ LD_LIBRARY_PATH are set correctly --- Sujatha Madan <[EMAIL PROTECTED]> wrote: > Hi, > > How can I allow root to connect to the database as > system. At the moment > when I try this, I keep getting a ORA-01034: Oracle > not available error, > even though the database is up and running fine. > > Regards, > > Sujatha > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Sujatha Madan > 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). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal 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: Sujatha Madan 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 con
Re: Oracle Installer line mode
AFAIK you MUST use the Java Installer. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Daiminger, Helmut" Gruppe.de>cc: Sent by: Subject: Oracle Installer line mode [EMAIL PROTECTED] 10/25/2001 06:40 AM Please respond to ORACLE-L Hi! Is it possible to run an 8.1.7 installation in line mode on Sun Solaris? Or is it mandatory to use the Java installer? Thanks, Helmut -- 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).
Re: URGENT -- db already exist ???
Gotta love Microsoft. Here's some instructions I got off this list from "Novice DBA" a while back on how to properly delete an Oracle Database on NT/2000: Clearing up the System after an incomplete or improper installation of Oracle - Database Installation involves a set of procedures which need to be followed in order to have a proper working installation. If we follow these procedures the Installation will be fine and usually problems related to improper installation do not arise. But it is not always possible to get a proper installation for the first time. This document is a troubleshooting guide which would help to clear off the mess created by an improper installation in a WindowsNT system. First we need to know that During installation Oracle writes into certain directories (which we would have specified during installation) and also into the WindowsNT registry. WindowsNT registry is a repository of information about all the installed products and configurations on that system. When we are installing Oracle a directory is created in the registry which is name oracle which is present in the HKEY_LOCAL_MACHINE/SOFTWARE/ In the case of an improper installation the problems faced are · We may not be able to uninstall the incomplete installation · We may succeed in uninstalling the incomplete installation but yet face problems with WindowsNT Services. · Every time we log into WindowsNT we may get an error 'at least one system service failed to start' which may be an Oracle service from the earlier installation. · We may get an error while creating a database 'the database with the name you specified already exists please chose another name' which again may be attributed to an improper un-installation.(I am not pretty comfortable with the Oracle's Un-installation utility because I feel it does not uninstall everything) Keeping the above points in mind it would be better if we know where exactly to look in case we are faced with such problems. When oracle is installed it makes entries in the following places 1. The first and the foremost- the directory in which we install the Oracle database (say D:\Ora8i) 2. The second is the inventory it maintains in the directory c:\program files\oracle 3. The third HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE in the registry 4. The other place is HKEY_LOCAL_MACHINE/SYSTEM . Inside this entry there are three nodes controlset1,controlset2 and currentcontrolset. These nodes in turn have 4 nodes out of which 2 are important to us. They are Enum and Services. The Enum node has got two nodes out of which the 'root' node is of great interest to us because it stores details about all the services that are running on a WindowsNT system. The other node of interest from the controlsets is Services. The services node has got a list of services running on a WindowsNT system. In case we need to clean up the system after an incomplete installation we can follow the following steps Delete the home directory where Oracle is installed Delete the folder C:\program files\oracle Note:- This clears off information about any other Oracle utility installed on that system. Delete the registry entry HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE Warning:- This clears off information about any other Oracle utility installed on that system and you may not be able to run those programs again. Delete the Oracle Related services from HKEY_LOCAL_MACHINE/SYSTEM/CONTROLSETx/ENUM/ROOT/ . They will be named with a prefix LEGACY_ORACLE... Note:- You will have to use regedt32.exe to invoke registry editor and not regedit. You will have to use the security menu and give permissions to yourself before deleting these entries. Else it will not work . It is to be noted that there are three control sets and all the three (in reality any 2) need to be cleared off these un-necessary entries. Delete the Oracle Related services from HKEY_LOCAL_MACHINE/SYSTEM/CONTROLSETx/SERVICES . They will have a prefix 'Oracle'. I have also attached a document having the same contents Jared will this get a chance ?? joking?? coz I am a novice David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Leslie Lu ahoo.com>cc: Sent by: Subject: URGENT -- db already exist ??? [EMAIL PROTECTED] om
RE: Unable to rebuild database from hot backup
I'm not sure if the error Jay is getting can be caused by this, but I got bit by it way back - make sure the tablespace that the file is for was taken out of backup mode. If it wasn't, you can apply redo logs all day long and it will never become current. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 John Kanagaraj [EMAIL PROTECTED]> cc: Sent by: Subject: RE: Unable to rebuild database from hot backup [EMAIL PROTECTED] om 10/25/2001 06:55 PM Please respond to ORACLE-L Jay, It is reasonable to assume that your hot backup is NOT ok ;-) This is *possibly* because this particular file (or maybe more files to come) wasn't backed up for a while. Can you look at the timestamp of this file (and other files) in the backup that you restored? That should give you a clue... I think this is what's happening here: Oracle needs to make sure as many logs as needed should be applied to this 'old' file so that the SCN on this particular file matches the latest one found in the system.dbf, so you need to keep applying from that point in time until now Another clue is to trace your archive logs - look at the one that you started applying. The time on that one is probably the time that your backup of that particular file became invalid Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Listen to great commercial-free christian music 24x7 at www.klove.com ** The opinions and statements above are entirely my own and not those of my employer or clients ** > -Original Message- > From: Miller, Jay [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 25, 2001 4:05 PM > To: Multiple recipients of list ORACLE-L > Subject: Unable to rebuild database from hot backup > > > Okay, this is weird. > > I'm trying to rebuilding my QC database from a hot backup. > As always, I > copied all the hot backup files, all the archive logs from > the period of the > hot backup and the control files. > > After doing > recover database using backup controlfile; > > I got > SVRMGR> alter database open resetlogs; > alter database open resetlogs > * > ORA-01113: file 1 needs media recovery > ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf > > Thinking that perhaps I just needed to apply more logs I went > on to apply > another 12 hours worth of archive logs. I still get the same error. > > Now I'm really concerned that my hot backup is invalid for > some reason. > Does anyone have any suggestions for what else I can look at? > > TIA, > Jay Miller > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > 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: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --
Re: Solaris 2.6/8.1.6/Security (Kinda Long)
Skip the public synonym on the local admin view? Create a synonym(not public) for the view, then grant select on it to adm. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Vergara, Michael (TEM)" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Solaris 2.6/8.1.6/Security (Kinda Long) Sent by: [EMAIL PROTECTED] om 10/25/2001 02:35 PM Please respond to ORACLE-L Gurus: This is a question about security, and query-ability. I have a remote database; let's call it REMOTE. I have local users who want to query REMOTE, but I cannot create additional users there without incurring undue amounts of heartache (not to mention heartburn!). I created a local database called SHADOW. The SHADOW database has a DBA-level user who owns a private database link to REMOTE. SHADOW also has local users defined who wish to query REMOTE. As DBA in SHADOW, I created a view (as SELECT *) of one of the tables on REMOTE. I then created a public synonym to this view, and granted select to the local user. No worries. So far...so good. Now an admin-level user wants access to a different table on REMOTE. So I did the same thing as for the local non-admin user. Created a view. Created a public synonym. Granted all to the admin user. Now, however, the local non-admin user can see and query the admin's table! This is not what I want! All privileges are granted through ROLES, the local user gets the 'RO' role, and the admin user gets 'ADM' role. How can I stop the local non-admin user from seeing (and updating, since that view allows updates) the admin's table? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) 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: 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).
Update invalid trigger_text in DBA_TRIGGERS?
I've got 885 triggers with hard-coded fully qualified table names in DBA_TRIGGERS. Problem is, the vendor changed the ownership on these tables, and now I've got 885 invalid triggers. I'd just like to run my grand scheme (not to be confused with schema) past you folks, give you the chance to realize just what an idiot I am, and offer brilliant alternatives that'll cause lasting envy, jealousy, and self-pity - mostly because the suggestions will be simpler, and might actually work. So much for the introduction. I thought I'd just go into DBA_TRIGGERS and run a replace against the trigger_text. Since trigger_text is a long data type, I don't believe I can use a straight update .. set ... replace() in SQL PLUS. My plan therefore is to write a quick PL/SQL piece that will select the long column into a varchar2, do the replace, then update the long column with the edited varchar2 variable. Is this a realistic strategy? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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).
Replacing the pesky '
Gotta love Mondays, We've been through this before, and I usually don't have a problem, but today my brain must think it's the weekend. Hey, I've got a bunch of names like O'Brien and O'Reilley where I need to replace the ' symbol. I've tried every type of combination of single quotes and slashes(escape sequence) I can think of, but I must have missed one, because I can't get it to replace. Any Ideas? Here's the progenitor of the whole mess. 1* select replace(lastname,' ' ') from adst where lastname like 'O%' SQL> / ERROR: ORA-01756: quoted string not properly terminated SQL> David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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).
Re: Repost: Nested loop in PL/SQL
The reasons this doesn't work are fairly numerous. What is it you're
trying to accomplish here? Perhaps if you could explain your requirement,
somebody could help you out. I'm quite surprised you were able to get a
version of this to compile and run even if you did use a 'FOR' loop. Is it
possible we're not seeing all the code?
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
"Feng, Jun"
n.com> cc:
Sent by: Subject: Repost: Nested loop in PL/SQL
[EMAIL PROTECTED]
om
10/02/2001
10:05 AM
Please respond
to ORACLE-L
Sorry, I meant to say doesn't work.
-Original Message-
Sent: Monday, October 01, 2001 6:50 PM
To: Multiple recipients of list ORACLE-L
Could anyone tell me why following nested loop does work? It stopped after
inner loop finished. I tried for loop, it worked ok.
Thanks,
Jun
declare v_plan_id number;
v_channel_id pricing_plan.channel_id%TYPE;
v_row pricing_plan%ROWTYPE;
cursor plan_id is
select distinct pricing_Plan_id from pricing_plan
where CHANNEL_ID = 'GROUP19'
and promotion_cd = 'INFO'
and trunc(end_date) >= trunc(sysdate)
and p_mode = 'LIVE'
group by PRICING_PLAN_ID;
cursor channel_id is
select distinct channel_id from pricing_plan
where CHANNEL_ID not in ('GROUP1','GROUP2', 'GROUP3')
and transaction_type = 'REGISTRATION'
order by channel_id;
begin
open plan_id;
open channel_id;
loop
fetch plan_id into v_plan_id;
exit when plan_id%NOTFOUND;
loop
fetch channel_id into v_channel_id;
exit when channel_id%NOTFOUND;
select * into v_row
from pricing_plan
where PRICING_PLAN_ID = 1;
dbms_output.put_line(v_row.price_cd);
end loop;
end loop;
close plan_id;
close channel_id;
end;
/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Feng, Jun
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: Feng, Jun
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:
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 f
Re: pl/sql question
Yep - here's an example. There is really a whole lot more that goes with this, but I've included the pertinent portions so you can get an idea. Hope this helps. SET DEFINE OFF; CREATE OR REPLACE PROCEDURE Student_Course_Report( fromSchool varchar2, toSchoolvarchar2, fromCourse varchar2, toCoursevarchar2) AS schoolWhereClause varchar2(250); courseWhereClause varchar2(250); TYPE RefCurType IS REF CURSOR; schoolCur RefCurType; v_schoolnum varchar2(3); v_schoolnamevarchar2(35); ACRSVar varchar2(13); BEGIN IF fromSchool = 'All Schools' THEN schoolWhereClause:= ' Where schoolnum not in ( ' || || '800' || || ' , ' || || 'D01' || || ') Order by schoolnum'; END IF; OPEN schoolCur for 'Select schoolnum, name From sasi.asch ' || schoolWhereClause; LOOP Fetch schoolCur into v_schoolnum, v_schoolname; EXIT WHEN schoolCur%NOTFOUND; ACRSVar:= 'sasi.ACRS1'||v_schoolnum; OPEN courseCur for 'Select statecrs1, title, course From ' || ACRSVar || courseWhereClause; LOOP Fetch coursecur into v_statecrs1, v_title, v_course; EXIT WHEN courseCur%NOTFOUND; David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Eric.Chesebro@ chase.comTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: pl/sql question om 10/02/2001 11:50 AM Please respond to ORACLE-L Can I somehow use a variable for the table name in a cursor select? Here is the example: --Declaration Section sSrcTableName VARCHAR2(50) := iFeedNm||'_1_1_' ||TO_CHAR(SYSDATE,'YYMMDD')||'_SRC'; --cursor for tmo daily source records CURSOR cTMODaily IS SELECT* FROM sSrcTableName; -- 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: 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:Determining Oracle status
Dick, I haven't seen oiconnect since v7x. I used to use it (as we've discussed here previously, tnsping and grepping processes for smon, pmon and the like won't provide you with a definitive answer for a variety of reasons), but have since switched to actually logging into the database via a script, running a stored procedure and logging out. If it fails, I'm alerted. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 [EMAIL PROTECTED] om To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Re:Determining Oracle status om 09/18/2001 01:50 PM Please respond to ORACLE-L Barry, Do you get the IOUG-A mag? There was a piece of Pro*C code therein (I'm the author) that did exactly what you want, but does not use SQL*Plus. There is also 'oiconnect' that should be in $ORACLE_HOME/bin. Dick Goulet Reply Separator Author: Barry Deevey <[EMAIL PROTECTED]> Date: 9/18/2001 7:45 AM Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to connect via sqlplus - If it connects its up, if it doesn't then its unavailable. However, the problem is that when it isn't up, the script hangs and does not return anything - I think that this is because sqlplus by default gives you 3 attempts to logon, so even though the logon attempt failed, it is waiting for you to try again, so unfortunately I'm not getting a failed return code. If anybody could tell me how to change this so that it only allows 1 login attempt before 'kicking you out' or whether there is a better method to finding out the status of an instance, I would be extremely grateful to hear from you. TIA for any responses. Best Regards, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey 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: 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: 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 co
Re: Determining Oracle status
Barry, Depending on your shell, start a timer (korn supports TMOUT). If you don't get a valid response within N seconds (trap the signal), you've got a problem. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Barry Deevey fas.co.uk> cc: Sent by: Subject: Determining Oracle status [EMAIL PROTECTED] 09/18/2001 10:45 AM Please respond to ORACLE-L Hi all, I am trying to write a script in unix that determines if a specific oracle instance is available. I'm trying to avoid using the 'ps' command, so I thought the easiest method would be to connect via sqlplus - If it connects its up, if it doesn't then its unavailable. However, the problem is that when it isn't up, the script hangs and does not return anything - I think that this is because sqlplus by default gives you 3 attempts to logon, so even though the logon attempt failed, it is waiting for you to try again, so unfortunately I'm not getting a failed return code. If anybody could tell me how to change this so that it only allows 1 login attempt before 'kicking you out' or whether there is a better method to finding out the status of an instance, I would be extremely grateful to hear from you. TIA for any responses. Best Regards, Barry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey 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: 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: Good/Cheap Backup Agent?
Write your own scripts. Not "inexpensive" considering the labor cost, but highly satisfactory. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Walter K hoo.com> cc: Sent by: Subject: Good/Cheap Backup Agent? [EMAIL PROTECTED] om 09/18/2001 02:05 PM Please respond to ORACLE-L Hi, We're looking for an inexpensive backup agent for our databases. The databases are 8i and are on Sun boxes but we're looking to have the agent/client hosted from an NT box (because it appears to be cheaper that way). What are your recommendations? Do all of the agents work through RMAN these days? Are there any features or caveats I should look for? Thanks! -w __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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: 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: Looking for 24 X 7 Design Considerations
SLA - Service Level Agreement How do you do trending? Monitor the heck out of your DB and plan ahead. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Sandi.McClary@f lyingj.comTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: RE: Looking for 24 X 7 Design Considerations m 09/17/2001 02:05 PM Please respond to ORACLE-L What is SLA? How are you doing trending? Christopher Spence To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Looking for 24 X 7 Design Considerations Sent by: root@fatcity. com 09/17/01 11:00 AM Please respond to ORACLE-L In my opinion, one of the biggest things with 24x7 is planning. Documenting what is normal maintenance either it be for your application or for the database itself. This means finding out how often normal maintenance (index rebuilds, re-orgs, data loads) runs, and how long. This is a good step regardless if the shop is 24x7, this way you know at all times what is needed and when. Then you need to determine which systems are critical to the success of the application, i.e. database, backups, hubs and such. Then I would work on a solution that will provide redundancy for these devices. One thing I like to do is make a list of all types of failure, and then my expected results, and time frame of recovery. Then I would consult with management and determine which are acceptable and which are not. I cannot stress the usefulness of SLA's, either to a customer or to a department (generally it is good to have both). This will give you a baseline you must follow. If you have something that takes 10 seconds, and you say it must be faster than 15 seconds, and one day it becomes 11 or 12, you have a good idea how things are going and can take measures. Finding important areas where you attach a metric. Another thing to be concerned with, and which can be a life saver is trending. This is very important in 24x7 environments so you can say "Ok, in 6 months we are going to add 50Gb and a second tape drive, this is going to cost $10,000 and will take 6 hours of time.". In a 24x7 environment the best thing is to already know the problem. It is the problems that come up unexpectantly that make things very difficult. Preparation and planning is critical to 24x7 environments. Knowing what can happen and what you will do to resolve it ahead time can be a big difference. Hope this helps, "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, September 17, 2001 11:15 AM To: Multiple recipients of list ORACLE-L We currently have 15+ databases (7.3.4 & 8i using IBM AIX and HACMP) that do not have a 24x7 restriction. Now, management is looking to bring in new products that will need to be 24X7. They are looking for costs to determine the viability of such a decision. I have no 24x7 experience and am looking for ideas or options to consider. [At least initially they are stating there can be no downtime for maintenance (upgrades/reorgs)] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow
Re: test schema from prod
Restore a backup of your production DB to another box and rename it. Great practice for recovery as well. If you need help renaming the DB after you've got it restored (big hint - create controlfile), let us know. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Raghu Kota" mail.com>cc: Sent by: Subject: test schema from prod [EMAIL PROTECTED] om 09/17/2001 10:35 AM Please respond to ORACLE-L Hi Friends, I want to create test schema from my production database, What is best way to do that!! Any ideas or ways to create test schema fast!! I appreciate your time. TIA Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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: 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: Subtract 1 month from current date
Ron, The only problem you might have here is in defining what is a 'month.' Is it 30 days, 31 days, 28 days or 29 days? Other wise it's quite simple - Select (sysdate - 30) from dual;<== parentheses are not necessary, I tend to include them for clarity. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Smith, Ron L." To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: om> Subject: Subtract 1 month from current date Sent by: [EMAIL PROTECTED] om 09/17/2001 10:40 AM Please respond to ORACLE-L Can someone tell me how to subtract 1 month from the current date? Also, where can I find answers and examples to this type of coding question? Thanks! Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: 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: User Processes Taking 200 Megs of RAM Upon Connecting
!! Please do not post Off Topic to this List !! What are your hard and soft ulimits? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 tcarlson@tripo s.comTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: User Processes Taking 200 Megs of RAM Upon Connecting om 09/12/2001 09:20 PM Please respond to ORACLE-L Hey gang. New job, new problems. I have just been handed a 8.1.7.0.0 database on solaris 5.8 with a little problem. Everything time a client connects, regardless of type, the OS dedicates over 200+ Megs of RAM (as shown by Top) to the user process. Naturally, this is running the box out of memory. The init.ora has the following parameters: db_block_size = 8192 db_block_buffers = 9652 large_.pool_size = 200 sort_area_size=65342 sort_area_retained_size=65342 There is nothing from any logs or trace files that helps. Plus, I am new to UNIX. Any help you could offer would be greatly appreciated. Todd Carlson www.tripos.com -- 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: 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:the world as we know it is over
Regardless of their nationality, religious beliefs, etc., those who plan to commit suicide attacks have already come to a decision regarding their personal fates. I have no moral, philosophical or ethical compunction about assisting them in achieving that ultimate destiny, albeit slightly earlier than they had planned, and without the loss of additional lives. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 [EMAIL PROTECTED] om To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Re:the world as we know it is over om 09/12/2001 10:55 AM Please respond to ORACLE-L Rachel, Regrettably you've had no drugs or other stuff that will make this a dream. The towers are down and even David can't bring them back. The folks on Public Radio are talking about our world being forever changed, like that doesn't happen every day! What has happen has happen due to some real subhuman individuals who didn't even consider their own safety. Why did it happen is a question that will be asked many times in the near future with no real answers. Part of how it happen is rooted in our American way of life which will change for a time, but I'll bet returns. We love our individual freedom and privacy, which I for one would not appreciate seeing changed. Sure security at airports will tighten up again, no doubt a few heads of security firms that do those checks, will 'roll' in the next few days. And it may take longer to get the an airplane in the future. But would you want it any other way? I'd hate to have to fill out a pile of government forms to get a pass to travel from New Hampshire to New York, but that's the alternative and exactly what those who destroyed the WTC want. Well, I say "Damn them to hell." Lets investigate this mess, find the real culprits be they an individual, a country, or an organization and then go after them with the precision of a brain surgeon. Let us get the culprits while leaving all of the innocents around them unharmed, not in a similar manner that these subhumans did. And for those of Islamic belief, no I do not connect you with this by association. I'll go back to a statement made to me by a very wise old priest, and my apologies to all if the term hits a raw nerve please take the entire statement in context, but he stated: "Niggers come in all colors, creeds, and races. To equate that to those of dark skin only is the worst of all sins." Consequently I believe the following interpretation is also valid: "Terrorists come in all colors, creeds, races and nationalities. To equate that to those of Arab tradition gives the terrorist his greatest victory." Dick Goulet Reply Separator Author: "Rachel Carmichael" <[EMAIL PROTECTED]> Date: 9/11/2001 4:12 PM Would someone please tell me that we all took major drugs and will wake up tomorrow with really bad hangovers and the towers will be back> I work about a mile from what used to be my symbol of home.. Smoke is STILL there, third building collapsed, fires are still raging. I do not understand a mind that could conceive of and execute such a plan. As far as I know, everyone I know who worked in those buildings is safe. But I don't know where everyone I know works. A friend's mom worked in one, halfway in to work today she turned around and decided to call in sick. Same friend's husband is a Port Authority cop (the PA owned and ran those buildings) his beat was those buildings. It wasn't his shift. I have more stories like that. I know I live in a dangerous world. In a
Re: slightly OT: Way to prevent FTP users from changing dirs?
Jay, When they log in have their .profile (located in a directory other than that they will have access to) specify they operate in a restricted shell environment. Check out your man pages or other documentation on setting up either rsh or rksh. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Jay Weinshenker ntric.net>cc: Sent by: Subject: slightly OT: Way to prevent FTP users from changing [EMAIL PROTECTED]dirs? m 09/12/2001 10:35 AM Please respond to ORACLE-L Solaris 2.6 Any hints on how to do this? I can prevent them from being able to telnet in, but once they ftp in, they can go pretty much anywhere... I've been told in the past that you could prevent a FTP user from being able to leave the directory they start off in, but I have no idea how to implement this.. hints? And please, don't start telling me about setting/removing no world permissions on a directory... that's not what I'm talking about. J -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Weinshenker 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: 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: OT: STOP THE PRESS!!
All those people. We may look back at this as the day the history of the world was changed. I fear this has enormous implications for the way in which our society has previously conducted itself. My heart aches. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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).
RE: Logging into Windows 2000 "Advanced" Server - Solved, Thanks
Thanks folks, The SET command was what I needed. It turns out that the network folks installed some new software on the server and somehow trashed the Oracle environment. Even though I manually set my environmental variables, I still was unable to connect to the instance. Oracle support told me this was an indication on Windows 2000 that my binaries needed to be relinked, and the only way to accomplish this on 2000 was to reinstall Oracle. I did, and it's now working. Live and learn. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Walthour, Jon (GEAE, To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Compaq)" cc: Sent by: [EMAIL PROTECTED] om 09/09/2001 07:20 AM Please respond to ORACLE-L Thank you for the correction, Mohammad. Jon Walthour -Original Message- Sent: Sunday, September 09, 2001 1:10 AM To: Multiple recipients of list ORACLE-L David, Although Jon has given you almost complete solution but your answer to login as sqlplus is sqlplus "/ as sysdba" and you will connected as sys...This is also courtsy of Jon who gave this answer to someone couple of days back... Regards MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Sat, 08 Sep 2001 20:30:17 -0800 The ORA-1113 message suggests that you have a file that needs media recovery, which makes sense considering the abrupt shutdown. Instead of opening the database, mount it first through SVRMGRL, the type "recover database". You may be asked for some archive logs if you're in archivelog mode. Just follow the directions that Oracle provides. You should be able to do a full recovery if the file is not permanently damaged. My guess is that the db may just be out of sync and media recovery will just get things back in sync. After the media recovery finishes, run "alter database open". To do this, go to a command prompt and type "set" to see all your environment variables. To use SVRMGRL, you need to set your ORACLE_SID variable. To do this, enter "set ORACLE_SID=". The run SVRMGRL, connect internal, and mount the database. Then recover it and open it. For example: C:\>set oracle_sid=mydb C:\>svrmgrl Oracle Server Manager Release 3.1.7.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.7.2.1 - Production With the Partitioning option JServer Release 8.1.7.2.1 - Production SVRMGR> connect internal Connected. SVRMGR> startup mount ORACLE instance started. Total System Global Area 52193308 bytes Fixed Size 75804 bytes Variable Size10342400 bytes Database Buffers 41697280 bytes Redo Buffers77824 bytes Database mounted. SVRMGR>recover database Database recovered. (There may be more to this step to do any media recovery.) SVRMGR> alter database open; Statement processed. SVRMGR> ... and on you go ... Hope this helps. Jon Walthour -Original Message- Sent: Saturday, September 08, 2001 8:45 PM To: Multiple recipients of list ORACLE-L Hope somebody can help. Our network personnel rebooted a Windows 2000 production box without shutting down Oracle. I now have the following error in my alert log: Sat Sep 08 13:45:08 200
Logging into Windows 2000 "Advanced" Server
Hope somebody can help. Our network personnel rebooted a Windows 2000 production box without shutting down Oracle. I now have the following error in my alert log: Sat Sep 08 13:45:08 2001 Database mounted in Exclusive Mode. Completed: alter database mount exclusive Sat Sep 08 13:45:08 2001 alter database open ORA-1113 signalled during: alter database open... Metalink says to check my environment variables. Is there an equivalent of the UNIX env command on NT? I'm not sure exactly where the environment is defined here. I'd also like to access this database from the command line to manually start it up. Having had no success with the "as SYSDBA" options for sqlplus on either UNIX or NT, I figure I must be using the wrong syntax. I know I can't use terminal services client (because the bequeath protocol doesn't work), but here's what I'm gettiing after I explicitly set the ORACLE_SID (Metalink says the double quotes are mandatory): sqlplus "/ connect as sysdba" Usage: SQLPLUS [ [] [] [] ] where ::= - | -? | [ [-M ] [-R ] [-S] ] ::= [/][@] | / | /NOLOG ::= @[.] [ ...] "-" displays the usage syntax "-?" displays the SQL*Plus version banner "-M " uses HTML markup options "-R " uses restricted mode "-S" uses silent mode TIA - David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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).
RE: [1] oerr
Jack, For some reason or another I asked a similar question a couple of months ago. It might have been Scott down in San Antonio that told me the .msg file is on UNIX only, David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Jack C. Applewhite" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: [1] oerr Sent by: [EMAIL PROTECTED] 09/07/2001 02:56 PM Please respond to ORACLE-L Our Win2k 8.1.6 EE installation only has three *.msg files - one for DRG (interMedia) and two for hs (heterogeneous services). The DRG message file is truly ascii, but the hs *.msg files are really *.msb. All the RDBMS message files are *.msb - not a single *.msg. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Friday, September 07, 2001 2:21 PM To: Multiple recipients of list ORACLE-L I don't have an NT database in front of me now, but I thought it didn't have both the oraus.msg and oraus.msb files. Is that correct? Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite 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: 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: Cloning Database failed
Recreate the control file. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Miller, Jay" house.com> cc: Sent by: Subject: Cloning Database failed [EMAIL PROTECTED] 09/07/2001 10:32 AM Please respond to ORACLE-L I went to replace my QC database from production yesterday (we do this about once a month) and discovered that there wasn't enough room in one of the filesystems to copy all the hot backup files. No problem I thought, I just copied one of the larger files to a different filesystem, mounted the database, and renamed to file to point to the new location. I then did my recovery, but when I tried to do ALTER DATABASE OPEN RESETLOGS I got ORA-01113: file 1 needs media recovery ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf' I tried applying more archive logs, eventually applying over 10 hours worth. Still got the error. I redid it this morning in case I had copied the wrong file somewhere, but once again... I'm now assuming that the problem was caused by my having renamed the file. Can anyone confirm or deny this and give me a suggestion on how to resolve the issue? I'm considering rebuilding the control file without an index tablespace to free up space but now I'm afraid that I'll get the same error. It's not a high priority since my SA just called to let me know he was able to find a few extra Meg for the filesystem (I was only short a frustrating 300K), but I'd still like to know what the problem was and any suggestions (in case it happens again in the future). Oracle 8.0.4.3, Solaris 2.5.1 TIA, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay 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: 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: How do you audit a DBA?
Yeah, and try getting the auditor in at 3am, weekends, or over a three-day holiday when you REALLY need root (that's Administrator for you Windoze folks) privileges. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Rachel Carmichael" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: How do you audit a DBA? Sent by: [EMAIL PROTECTED] om 09/07/2001 08:50 AM Please respond to ORACLE-L "The point is, you only need one, single trusted person to hold the administrator account (someone from your audit firm, for example) and almost everything can be done by sub-administrators who only have the precise permissions they need and no more. In theory, anyway :0)" There's that "single point of failure" again! so... the auditor is more trusted than the DBA? Who audits the auditor? >From: "Guy Hammond" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: How do you audit a DBA? >Date: Fri, 07 Sep 2001 01:45:06 -0800 > >There is an administrator account, but individual users can configure >access control lists on their files (right-click, properties, security) >that would prevent the administrator from reading them. The only way >that an administrator could then read them would be to "take ownership" >first. Unlike Unix, ownership of a file is taken rather than given, so >even if an Administrator read a confidential file, the OS would not let >then erase traces of having done so. If you wanted to steal a file, you >could obviously back it up to tape (if you have the Backup Operator >role) restore it to another system, take ownership there and read it >(unless it was encrypted of course) but there's only so much an OS can >do about physical security. > >The point is, you only need one, single trusted person to hold the >administrator account (someone from your audit firm, for example) and >almost everything can be done by sub-administrators who only have the >precise permissions they need and no more. In theory, anyway :0) > >g > > > >-Original Message- >Sent: Thursday, September 06, 2001 2:41 PM >To: Multiple recipients of list ORACLE-L > > >but doesn't there have to be ONE account/role in NT that can assign all >the >others? how else could you set up a role or continue to set them up? > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Guy Hammond > 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/intl.asp -- 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
RE: Scripts for Rebuilding Indexes Nightly on Solaris
David - Use cron. Nightly might be excessive. Kick off a shell script (remember that cron executes as root, so you need to set your environment) and create your own script dynamically (following code is use for backups also) in a manner like: rebuild_index.sh #!/bin/ksh export PATH=$PATH:/u001/app/oracle/product/8.1.7/bin export ORACLE_SID=ifas export PATH=$PATH:/$ORACLE_HOME/bin export ORACLE_HOME=/u001/app/oracle/product/8.1.7 export ORACLE_BASE=/u001/app/oracle sqlplus < > @/usr/local/bin/rebuild_index exit rebuild_index.sql spool rebuild_index.sql Select 'Alter index ' || index_name || ' rebuild;' from dba_indexes; # add selection caveats if desired spool off !chmod 777 /u014/oradata/ifastrn/rebuild_index.sql @/u014/oradata/ifastrn/rebuild_index exit Lots of variations possible. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Kimberly Smith <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> jitsu.com> cc: Sent by: Subject: RE: Scripts for Rebuilding Indexes Nightly on Solaris [EMAIL PROTECTED] 09/06/2001 11:57 AM Please respond to ORACLE-L Nightly? That is a lot. Are you really entering that much data on a daily basis? -Original Message- From: David Wagoner [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 8:57 AM To: Multiple recipients of list ORACLE-L Subject: Scripts for Rebuilding Indexes Nightly on Solaris Does anyone have any good scripts for rebuilding indexes nightly on Solaris UNIX that they'd be willing to share? Also, in your experience is it better to run this through UNIX cron jobs than using the Oracle OEM job scheduler? I suspect the cron job will be the favorable answer. Thanks in advance, David Wagoner Oracle DBA -- 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).
RE: sql*loader datatype question
Check your positioning. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Koivu, Lisa" field.com> cc: Sent by:Subject: RE: sql*loader datatype question [EMAIL PROTECTED] 08/30/2001 02:46 PM Please respond to ORACLE-L Well noo it's fixed-length and I think I'd end up with a big jumble, wouldn't I? No delims in the file. -Original Message- From: Bala, Prakash [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 2:48 PM To: Multiple recipients of list ORACLE-L Subject:RE: sql*loader datatype question Lisa, Have you tried loading without specifying any datatype and length in the control file? Just a thought... Prakash -Original Message- Sent: Thursday, August 30, 2001 1:33 PM To: Multiple recipients of list ORACLE-L I'm hitting a wall here. I'm trying to load data into a large table. Two of the fields are phone numbers (10 digits). The database field is defined as number(10). When I try to load these records, they err out with an error similar to below. Record 858: Rejected - Error on table INV_OWNER.FPSITE, column FPS_AFFIL_LTD_PTS_FPS. ORA-01722: invalid number So I change the fields to character, get the data in and it truly is all 10-digit numbers. I'm wondering if I'm missing something in the format. The doco says that INTEGER EXTERNAL is to be used for "human readable" numbers, non-binary, when you want to specify the length. The length I've chosen is correct. I can even create a table with number(10) columns and insert the varchar(10) phone number data into it! What am I missing? I really do not want to change all my number fields to character. It would defeat the purpose. I have a feeling I'm missing some sort of conversion in SQL*Loader but I don't see it off the top of my head. Thanks in advance for any suggestions. Lisa Koivu wanna-be DBA Hand Holder (that's what I've been doing this morning with an ex-coworker) and DBA Ft. Lauderdale, FL, USA The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yo
Re: sql*loader datatype question
Lisa, Can you show us the control file and a couple of lines of sample data? Are you sure you don't have an unprintable character before/after the phone number? Is this occurring for all the phone numbers? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Koivu, Lisa" field.com> cc: Sent by:Subject: sql*loader datatype question [EMAIL PROTECTED] 08/30/2001 12:33 PM Please respond to ORACLE-L I'm hitting a wall here. I'm trying to load data into a large table. Two of the fields are phone numbers (10 digits). The database field is defined as number(10). When I try to load these records, they err out with an error similar to below. Record 858: Rejected - Error on table INV_OWNER.FPSITE, column FPS_AFFIL_LTD_PTS_FPS. ORA-01722: invalid number So I change the fields to character, get the data in and it truly is all 10-digit numbers. I'm wondering if I'm missing something in the format. The doco says that INTEGER EXTERNAL is to be used for "human readable" numbers, non-binary, when you want to specify the length. The length I've chosen is correct. I can even create a table with number(10) columns and insert the varchar(10) phone number data into it! What am I missing? I really do not want to change all my number fields to character. It would defeat the purpose. I have a feeling I'm missing some sort of conversion in SQL*Loader but I don't see it off the top of my head. Thanks in advance for any suggestions. Lisa Koivu wanna-be DBA Hand Holder (that's what I've been doing this morning with an ex-coworker) and DBA Ft. Lauderdale, FL, USA The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -- 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).
Re: ora - 4031 while inserting into a parent table
Raganath,
Sounds like you got some bad SQL operating. Usually the error you are
seeing is caused not by the shared pool being too small (although if it's
too small for you're trying to do, nothing will help), but rather by
excessive fragmentation making the requisite amount of continuous free
space unavailable.
Your remark that this is an insert involving 42 tables from another DB sort
of reinforces my suspicions. One of the things I found out (from this list
last year) was that you need to commit across DB links after DML to free
memory. Make sure you're using bind variables. Make sure you're sharing
SQL. Try using fully qualified table names.
You could try flushing the shared pool to see if this resolves your
problem, but you run the risk of losing sequences unless you've specified
they should not be flushed using dbms_shared_pool.keep.
The kqls heap message might also indicate library cache problems. Oracle
suggests using the following to determine which parameters you need to
address in tuning:
First determine if the ORA-04031 was a result of fragmentation in the
library
cache or in the shared pool reserved space by issuing the following query:
SELECT free_space, avg_free_size, used_space,
avg_used_size, request_failures, last_failure_size
FROM v$shared_pool_reserved;
The ORA-04031 is a result of lack of contiguous space in the shared
pool
reserved space if:
REQUEST_FAILURES is > 0 and LAST_FAILURE_SIZE is >
SHARED_POOL_RESERVED_MIN_ALLOC.
To resolve this consider increasing SHARED_POOL_RESERVED_MIN_ALLOC to
lower
the number of objects being cached into the shared pool reserved space
and
increase SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE to increase
the
available memory in the shared pool reserved space.
The ORA-04031 is a result of lack of contiguous space in the library
cache if:
REQUEST_FAILURES is > 0 and LAST_FAILURE_SIZE is <
SHARED_POOL_RESERVED_MIN_ALLOC
or
REQUEST_FAILURES is 0 and LAST_FAILURE_SIZE is <
SHARED_POOL_RESERVED_MIN_ALLOC
The first step would be to consider lowering
SHARED_POOL_RESERVED_MIN_ALLOC to
put more objects into the shared pool reserved space and increase
SHARED_POOL_SIZE.
Note that _shared_pool_reserved_min_alloc is a hidden parameter in
8i.
If all else fails, increase the size of the shared pool again.
Hope some of this helps.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
"Ranganath K"
group.com> cc:
Sent by:Subject: ora - 4031 while inserting
into a parent table
[EMAIL PROTECTED]
08/30/2001 09:37
AM
Please respond to
ORACLE-L
Dear DBA Gurus,
I am getting the following error while inserting into a schema's parent
table which is being referred by 42 tables of another schema.
ORA-04031: unable to allocate 2196 bytes of shared memory ("shared
pool","RA_VOLUME_PLAN_POOL","KQLS heap","KQLS MEM BLOCK");
How do I resolve this? I increased the shared_pool_size from 15mb to 30mb
and shared_pool_reserved_size from 1mb to 5mb but it didn't solve the
problem. I also set the _db_cached_cursors parameter to 0 and bounced the
database but in vain. BTW I am using oracle 8.1.6 enterprise edition on
Sun
Solaris 2.7. Any help in this regard will be very much appreciated.
TIA and Regards,
Ranganath
DISCLAIMER: This correspondence is confidential and intended for the named
recipient(s) only. If you are not the named recipient and receive this
correspondence in error, you must not copy, distribute or take any action
in
reliance
Re: Spooling output of a select statement to a file through stored
Ranganath,
First you have to specify a place where Oracle may write the file. You do
this by setting the UTL_DIR parameter in your init.ora file. Make
sure that the Oracle user has write permission on the directory(ies) you
specify. You'll need to bounce the DB to have this parameter take effect.
Your code will look something like this(this is for an NT Box):
CREATE or REPLACE .
AS
CURSOR XXX IS..
vocstu_report utl_file.file_type;
BEGIN
vocstu_report:= utl_file.fopen('F:
\oracle\admin\reports','vocstu_report.txt','W');
(All your processing here)
utl_file.put_line(vocstu_report,
RPAD(v_lastname,25,' ') ||
RPAD(v_firstname,15,' ') ||
RPAD(v_gender,6,' ') ||
RPAD(v_grade,5,' ') ||
RPAD(v_ethniccode,6,' ') ||
RPAD(v_altid1,13,' ') ||
RPAD(v_AGATInd,5,' ') ||
RPAD(v_STXPInd,4,' '));
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
"Ranganath K"
group.com> cc:
Sent by:Subject: Spooling output of a select
statement to a file through
[EMAIL PROTECTED] stored procedure
08/29/2001 06:00
AM
Please respond to
ORACLE-L
Dear DBA Gurus,
How do I spool output of a select statement to a file through
stored
procedure. The stored procedure should take the directory and path of the
file to be spooled to on the client machine. I know we can do this using
UTL_FILE package. But I don't want to write to a file in Oracle Database
server machine rather I want to write the output to a file in client
machine. Please note that I want to do this through a Pl/Sql procedure or
a
pl/sql program so that the procedure can be called from the front end which
is Java/C++. How do I do this? Any help in this regard will be duly
appreciated.
Thanks and Regards,
Ranganath
DISCLAIMER: This correspondence is confidential and intended for the named
recipient(s) only. If you are not the named recipient and receive this
correspondence in error, you must not copy, distribute or take any action
in
reliance on it and you should delete it from your system and notify the
sender immediately. Unless otherwise stated, any views or opinions
expressed
are solely those of the author and do not represent those of Subex Systems
Limited.
www.subexgroup.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ranganath K
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:
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
Re: !! *Very* important Oracle-L message !!
I didn't put OT in the header because I think this is very on topic. I will be emailing Bruce to see what he needs, or feels is a fair contribution for my participation in this list through the years. I have gained so much from the members of this list. Without those who participate, both past and present, I would never have progressed as far along the DBA route as I have. Ofttimes, I'll read about a problem someone has posted here and, although I can't help them, I do copious research to further my education and knowledge. Many of these problems have subsequently cropped up within my DB's, and I am much better prepared to handle them as a result. I also save, research, and test many of the scripts posted here. Some work, some don't, some can afford to be tweaked, but playing with them has given me a deeper understanding of what goes into being a DBA (plus I've now got a great toolkit - just need to learn PERL!). I pay for my subscription to the daily newspaper. This forum is at least as valuable to me as the newspaper (I even get the comic section here). There is a cost to the Internet - that's why many of us have jobs. I urge the members of this community to search their conciouses and give what they can to help this forum prosper. Someday I'd like to make it to OOW and meet some of you (heck, I've thought about driving down to San Antonio just to meet Scott. Does Mladen ever leave his cave?) Regards, David A. Barbour Oracle DBA, OCP AISD 512-414-1002 -- 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).
RE: tab ascii value
John,
Here's a message I got from Dennis Heisler off this list last week. The
method works quite well:
David,
There are a number of different ways to do it. One method I use is to
define the codes in the package header
ie: FONT_COURIER10 varchar2(15) := chr(27) || '(s0p10h12vsb3T'
Then, in the package body, when I want to print a special code I either
use utl_file.put() or utl_file.put_line(FONT_COURIER10 || 'Text Goes
Here').
Dennis
Good Luck.
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Hallas John
llnet.net> cc:
Sent by:Subject: RE: tab ascii value
[EMAIL PROTECTED]
08/28/2001 08:05
AM
Please respond to
ORACLE-L
Srinivas,
I have managed the following PL/SQL but I have not worked out how to show
the tab and CR return characters etc. Perhaps someone else can help
John
SCRIPT start xx
declare
V_chr varchar2(3);
ctr number;
begin
for ctr in 1..255 loop
select chr(ctr) into V_chr from dual;
-- dbms_output.put_line(V_chr);
dbms_output.put_line('Chr value '||ctr||' = '||V_chr||' ');
end loop;
end;
SCRIPT ends
Chr value 1 =
Chr value 2 =
Chr value 3 =
Chr value 4 =
Chr value 5 =
Chr value 6 =
Chr value 7 =
Chr value 8 =
Chr value 9 =
Chr value 10 =
Chr value 11 =
Chr value 12 =
Chr value 13 =
Chr value 14 =
Chr value 15 =
Chr value 16 =
Chr value 17 =
Chr value 18 =
Chr value 19 =
Chr value 20 =
Chr value 21 =
Chr value 22 =
Chr value 23 =
Chr value 24 =
Chr value 25 =
Chr value 26 =
Chr value 27 =
hr value 28 =
Chr value 29 =
Chr value 30 =
Chr value 31 =
Chr value 32 =
Chr value 33 = !
Chr value 34 = "
Chr value 35 = #
Chr value 36 = $
Chr value 37 = %
Chr value 38 = &
Chr value 39 = '
Chr value 40 = (
Chr value 41 = )
Chr value 42 = *
Chr value 43 = +
Chr value 44 = ,
Chr value 45 = -
Chr value 46 = .
Chr value 47 = /
Chr value 48 = 0
Chr value 49 = 1
Chr value 50 = 2
Chr value 51 = 3
Chr value 52 = 4
Chr value 53 = 5
Chr value 54 = 6
Chr value 55 = 7
Chr value 56 = 8
Chr value 57 = 9
Chr value 58 = :
Chr value 59 = ;
Chr value 60 = <
Chr value 61 = =
Chr value 62 = >
Chr value 63 = ?
Chr value 64 = @
Chr value 65 = A
Chr value 66 = B
Chr value 67 = C
Chr value 68 = D
Chr value 69 = E
Chr value 70 = F
Chr value 71 = G
Chr value 72 = H
Chr value 73 = I
Chr value 74 = J
Chr value 75 = K
Chr value 76 = L
Chr value 77 = M
Chr value 78 = N
Chr value 79 = O
Chr value 80 = P
Chr value 81 = Q
Chr value 82 = R
Chr value 83 = S
Chr value 84 = T
Chr value 85 = U
Chr value 86 = V
Chr value 87 = W
Chr value 88 = X
Chr value 89 = Y
Chr value 90 = Z
Chr value 91 = [
Chr value 92 = \
Chr value 93 = ]
Chr value 94 = ^
Chr value 95 = _
Chr value 96 = `
Chr value 97 = a
Chr value 98 = b
Chr value 99 = c
Chr value 100 = d
Chr value 101 = e
Chr value 102 = f
Chr value 103 = g
Chr value 104 = h
Chr value 105 = i
Chr value 106 = j
Chr value 107 = k
Chr value 108 = l
Chr value 109 = m
Chr value 110 = n
Chr value 111 = o
Chr value 112 = p
Chr value 113 = q
Chr value 114 = r
Chr value 115 = s
Chr value 116 = t
Chr value 117 = u
Chr value 118 = v
Chr value 119 = w
Chr value 120 = x
Chr value 121 = y
Chr value 122 = z
Chr value 123 = {
Chr value 124 = |
Chr value 125 = }
Chr value 126 = ~
Chr value 127 =
Chr value 128 = ?
Chr value 129 = ?
Chr value 130 = ?
Chr value 131 = ?
Chr value 132 = ?
Chr value 133 = ?
Chr value 134 = ?
Chr value 135 = ?
Chr value 136 = ?
Chr value 137 = ?
Chr value 138 = ?
Chr value 139 = ?
Chr value 140 = ?
Chr value 141 = ?
Chr value 142 = ?
Chr value 143 = ?
Chr value 144 = ?
Chr value 145 = ?
Chr value 146 = ?
Chr value 147 = ?
Chr value 148 = ?
Chr v
RE: ORA-10027 in ps/sql block
Check the loop exit. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Thomas, Kevin" anais.com> cc: Sent by:Subject: RE: ORA-10027 in ps/sql block [EMAIL PROTECTED] 08/28/2001 03:16 AM Please respond to ORACLE-L What does the code look like? -Original Message- Sent: 27 August 2001 18:56 To: Multiple recipients of list ORACLE-L I have a developer here who is trying to populate a cursor. Every time he runs his code he gets the above error stating that the buffer is too small. We have tried explicitly setting the buffer to 1,000,000 bytes. This is FAR greater than needed for the amount of data requested. No matter what buffer size we set he still gets the overflow. We have tried both of the following ideas from metalink Any ideas? Rodd Holman Doc ID: Note:1005230.6Content Type: TEXT/PLAIN 26-AUG-1994 Type: PROBLEM Last Revision Date: 13-JAN-1995 Status: PUBLISHED Problem Description: Problem Explanation: NEW PROBLEM Solution: INCREASE THE SIZE OF THE BUFFER Solution Description: = Increase the size of the buffer. The size of the buffer must be an integer between 2,000 and 1,000,000. Solution Explanation: = Use one of the following two methods to increase the size of the buffer: 1. At the SQL*PLUS or SQL*DBA prompt, type SET SERVEROUTPUT ON SIZE n where n is an integer between 2,000 and 1,000,000. Example: To increase the buffer size to 10,000 type SET SERVEROUTPUT ON SIZE 1 2. Inside the PL/SQL block type DBMS_OUTPUT.ENABLE(n) where n is an integer between 2,000 and 1,000,000. See Appendix A of the Oracle7 Server Application Developer's Guide for an explanation of the ENABLE command. . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Holman, Rodney 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: Thomas, Kevin 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: 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, in
