INDEXLEME ONEMLI
Arkadaþlar , Form içinde yaptýðýnýz ORDER BY, GROUP BY gibi fonksiyonlarý hangi tablolarýn hangi alanlarýnda yaptýðýnýzý bir yerlere lütfen yazýn. Bu alanlarda index yaratýlacaktýr. Form da blok propertilerinde order by yaparsanýz onu da yazýn . Bunyamin Your Databored Administrator
INDEXLEME ONEMLI
Arkadaþlar , Form içinde yaptýðýnýz ORDER BY, GROUP BY gibi fonksiyonlarý hangi tablolarýn hangi alanlarýnda yaptýðýnýzý bir yerlere lütfen yazýn. Bu alanlarda index yaratýlacaktýr. Form da blok propertilerinde order by yaparsanýz onu da yazýn . Bunyamin Your Databored Administrator
RE: INDEXLEME ONEMLI
Nope, I still don't understand it, even the second time around. Like the Databored Administrator bit though !!! -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: 03 September 2001 09:20To: Multiple recipients of list ORACLE-LSubject: INDEXLEME ONEMLI Arkadalar , Form içinde yaptnz ORDER BY, GROUP BY gibi fonksiyonlar hangi tablolarn hangi alanlarnda yaptnz bir yerlere lütfen yazn. Bu alanlarda index yaratlacaktr. Form da blok propertilerinde order by yaparsanz onu da yazn . Bunyamin Your Databored Administrator The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
ORA-27146: post/wait initialization failed
Hi Using Oracle 8.1.6.3 on Solaris 2.7. I get this error ORA-27146: post/wait initialization failed when trying to startup my database.. if I reboot the machine then it starts up without problems.. From reading previous e-mails.. I'm led to belive that the semaphores need to be increased. Does anyone know how to do this, also how to calculate how much to increase by etc Regards -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal 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: INDEXLEME ONEMLI
Yes. :- Dne po 3. zá?í 2001 10:20 jste napsal(a): Arkadaþlar , Form içinde yaptýðýnýz ORDER BY, GROUP BY gibi fonksiyonlarý hangi tablolarýn hangi alanlarýnda yaptýðýnýzý bir yerlere lütfen yazýn. Bu alanlarda index yaratýlacaktýr. Form da blok propertilerinde order by yaparsanýz onu da yazýn . Bunyamin Your Databored Administrator Content-Type: text/html; charset=iso-8859-9; name=P?íloha: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: Duhvelopers and DB-ehs?
OOooh, that's something I want to be able to do is to send email to us in case of problems...I can send email from OraForms using Outlook but I've not got round to checking out how I send email from a Unix box via pl/sql or the likesany suggestions? K. hit any user to continue __ 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: 31 August 2001 17:38 To: Multiple recipients of list ORACLE-L we have homegrown shell scripts -- page us, email us, send daily status of the world reports... works! From: Thomas, Kevin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 05:47:12 -0800 Database monitoring toolsthrrp! We wrote our own using Java and lots of SQL are shell scripts...patchy but it works ;-) __ 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: 31 August 2001 14:17 To: Multiple recipients of list ORACLE-L I've got 11 databases (and just found out I'll probably have a new one, a semi, sort of, kind of data warehouse -- I need those books!) and there is me, my junior DBA who is not so junior anymore, and one consultant. And my CTO thinks that the DBAs are really just extra programming resources. So half the time we are doing non-DBA work. Oh yeah, and we don't have any of those high-falutin' database monitoring tools either :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 02:55:26 -0800 Bloody Hell, we have half that amount of systems yet only two DBAs. What on earth do they do with the rest of their time. -Original Message- Sent: 31 August 2001 09:40 To: Multiple recipients of list ORACLE-L LOL...with 31 systems to support 24/7/365 if you threw a stone in any direction you would hit a DBA. At the last count I believe we had 12...!! __ 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: 30 August 2001 17:22 To: Multiple recipients of list ORACLE-L Sounds like your company is looking for a new DBA? :- Jan Pruner Dne ?t 30. srpen 2001 17:26 jste napsal(a): I have to say I resent being called a duhveloper, granted the majority couldn't tune a banjo let alone tune a piece of SQL, but as a techie (and we all are), I find this list invaluable for getting advice on a wide range of topics, not just keeping a DB up and running or tuned...I don't call you guys names, and let's face it you DB-ehs? couldn't write a decent application if your lives depended on it... (blue touch-paper lit, retire a distance, do not re-approach once lit, and wait for fireworks) hit any user to continue __ 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: 30 August 2001 15:46 To: Multiple recipients of list ORACLE-L no, those posts keep us underworked DBAs from killing the duhvelopers who make us do the same thing over and over and over and who never listen when we tell them the correct way to design the tables. :) From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: !! Keeping the list alive Date: Thu, 30 Aug 2001 04:00:52 -0800 Just look at the number of OT postings in the last couple of months... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 7:58 PM To: Multiple recipients of list ORACLE-L Subject:RE: !! Keeping the list alive You're surprised at those willing to pay? You have to realize that most DBAs are over-payed and under-worked ducking -Original Message- From: [EMAIL PROTECTED]
Shutdown and archivelog mode
Hi Using Oracle 8.1.6.3 on solaris 2.7. I am trying to put my database in archivelog mode. When I try to shutdown the database using shutdown immediate, it just sits there for ages.. (left it for 30 mins). I've cancelled this and done a shutdown abort. (tried normal shutdown after that, same) Due to this when I try to put it archivelog mode after shutdown abort I get a message saying that the database can't be put into archivelog mode because recovery is needed. TIA -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal 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: NLS_LANG
No way, only recreate the database. Jan Pruner Dne pá 31. srpen 2001 18:08 jste napsal(a): Does anyone know how or if it is possible to change the NLS_LANG value for a database that has already been created? I believe the answer is no, but I wanted a sanity check (Lord knows I need one). Thanks. Todd Carlson Oracle 8i Certified DBA Bunge North America -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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).
Oracle for SGI Irix installation
I have a problem with intallation oracle 8.1.6 to SGI Irix 6.5.12. When i start RunInstaller and click to the Next bar of Welcome window, I can see the following errors: 39861:/CDROM/install/../stage/Components/oracle.swd.jre/1.1.6.2/1/DataFiles/Expanded/jre/irix/bin/../bin/sgi/native_threads/jre: rld: Fatal Error: Cannot Successfully map soname '../stage/Components/oracle.swd.oui/1.7.0.18.0/1/DataFiles/Expanded/bin/irix/liboraInstaller.so' under any of the filenames ../stage/Components/oracle.swd.oui/1.7.0.18.0/1/DataFiles/Expanded/bin/irix/liboraInstaller.so (../stage/Components/oracle.swd.oui/1.7.0.18.0/1/DataFiles/Expanded/bin/irix/liboraInstaller.so) java.lang.UnsatisfiedLinkError: ../stage/Components/oracle.swd.oui/1.7.0.18.0/1/DataFiles/Expanded/bin/irix/liboraInstaller.so at java.lang.Runtime.load(Runtime.java:397) at java.lang.System.load(System.java:553) at at oracle.sysman.oii.oiip.oiipg.OiipgEnvironment.getEnv(OiipgEnvironment.java:81) at oracle.sysman.oii.oiif.oiifp.OiifpWizLocPanel.refreshCombos(OiifpWizLocPanel.java:1098) at oracle.sysman.oii.oiif.oiifp.OiifpWizLocPanel.init(OiifpWizLocPanel.java:384) ... Could anybody advice me? Thanks in advance. Pavla Lokajova -- University of Ostrava Czech Republic -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pavla Lokajova 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: INDEXLEME ONEMLI
Sorry for the email . I wanted to send it to a friend but send it to list wrongly . SORRY bunyamin - Original Message - From: Robertson Lee - lerobe To: Multiple recipients of list ORACLE-L Sent: Monday, September 03, 2001 12:20 PM Subject: RE: INDEXLEME ONEMLI Nope, I still don't understand it, even the second time around. Like the Databored Administrator bit though !!! -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: 03 September 2001 09:20To: Multiple recipients of list ORACLE-LSubject: INDEXLEME ONEMLI Arkadalar , Form içinde yaptnz ORDER BY, GROUP BY gibi fonksiyonlar hangi tablolarn hangi alanlarnda yaptnz bir yerlere lütfen yazn. Bu alanlarda index yaratlacaktr. Form da blok propertilerinde order by yaparsanz onu da yazn . Bunyamin Your Databored AdministratorThe information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.
RE: OT: RE: Duhvelopers and DB-ehs?
well if you didn't keep paying me in bloomin' bananas me and me mates would never have gone on strike!! ;-) LOL hit any user to continue __ 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 From: Jacques Kilchoer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 12:20:26 -0800 I am in charge of 273 databases at sites throughout the world, some of them in places with no electricity where we have an elephant on a treadmill supplying power. I personally had to once step in for the elephant when he was feeling under the weather. All of these databases are 26 x 8, meaning 26 hours a day eight days a week since we have to deal with the additional day caused by the international date line, and two extra hours because of some places have weird time zones. On certain days the International Time committee adds a leap second to the day which means that on those days I have to work an extra second * 273 databases which adds up to several minutes. On 19 of those databases, due to the lack of funds for storage, I have to do a backup to paper, i.e. I have to manually read every table through select statements and write them down on paper using a broken pencil. We are planning on sending a few databases out onto satellites, one of them on a probe to Neptune. I will also be in charge of the backup/uptime for those mission-critical systems, since they will be used as the back-end for a website that receives thousands of hits per minute (a Britney Spears fan club site). I am the only human DBA. We have three helper monkeys at remote locations but they are currently on strike. I have to run off now because the coffee machine is broken and no one is here to fix it except me. I had to carve my own coffe cup out of wood because I can't afford ceramic. _ 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-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).
Re: OT Re: INDEXLEME ONEMLI
Well... I guess Bunyamin was trying to warn their developers about indexing and he has sent it wrong. Gints, it is Turkish not Turkic. Anyway, we are at the quarter finals, hoping to get the cup.. Okan Never argue with an idiot, they will drag you down to their level and beat you with experience (Dilberts Rules of Order) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 03, 2001 12:26 PM Although there is European Basketball Championship in Turkey and I'm a big fan of it, I don't know Turkic (I suppose so) now ;))) Gints Plivna IT Sist?mas, Mer?e?a 13, LV1050 R?ga http://www.itsystems.lv/gints/ Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] bunyamink@havelscc: an.com.tr Subject: INDEXLEME ONEMLI Sent by: [EMAIL PROTECTED] 2001.09.03 10:20 Please respond to ORACLE-L Arkadaþlar , Form içinde yaptýðýnýz ORDER BY, GROUP BY gibi fonksiyonlarý hangi tablolarýn hangi alanlarýnda yaptýðýnýzý bir yerlere lütfen yazýn. Bu alanlarda index yaratýlacaktýr. Form da blok propertilerinde order by yaparsanýz onu da yazýn . Bunyamin Your Databored Administrator -- 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: Okan CIMEN 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).
OT Re: INDEXLEME ONEMLI
Although there is European Basketball Championship in Turkey and I'm a big fan of it, I don't know Turkic (I suppose so) now ;))) Gints Plivna IT Sist?mas, Mer?e?a 13, LV1050 R?ga http://www.itsystems.lv/gints/ Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] bunyamink@havelscc: an.com.tr Subject: INDEXLEME ONEMLI Sent by: [EMAIL PROTECTED] 2001.09.03 10:20 Please respond to ORACLE-L Arkadaþlar , Form içinde yaptýðýnýz ORDER BY, GROUP BY gibi fonksiyonlarý hangi tablolarýn hangi alanlarýnda yaptýðýnýzý bir yerlere lütfen yazýn. Bu alanlarda index yaratýlacaktýr. Form da blok propertilerinde order by yaparsanýz onu da yazýn . Bunyamin Your Databored Administrator -- 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).
UNIX LINKS QUESTION ??
My unix knowledge is low and I want to develop it . But I search for a tutorial for Oracle People especially DBA's. IS there a source on web including the directory structure, oratab or other things to administer a database on Unix system ? I' ll be so happy for your helps . Thank you
a little sql question
hi every body, I need to insert in the end of a sql script, the number of rows returned. how can i do that ? thanks !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim 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: Duhvelopers and DB-ehs?
Hi Don, and well done for taking the step back towards a normal life...(whatever the heck that is!)... LOL hit any user to continue __ 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 http://www.calanais.com/ -Original Message- Sent: 01 September 2001 02:26 To: Multiple recipients of list ORACLE-L OK. I've resisted the temptation so far, but (puffing out chest)... In one job in my distant past, at a turnkey software/systems shop, four (initially two) of us used to administer about half a dozen in house Oracle servers and remotely administer about 2-3 dozen of our clients' database servers. They were scattered all over the US and Canada and we all did database and Unix systems administration part time. About 80% of our time was spent in custom software/systems design and development. Everybody got Oracle DBA training, but nobody was a full-time DBA or systems administrator. (A very novel approach that resulted in very few deeply imbedded application performance issues!) From late 1997 until mid-1999 I administered up to about 45 Oracle databases (each was 10-200 GB OLTP) by myself - including design/modeling, code reviews and tuning, physical server configuration (sizing systems, creating raw devices, etc.), and production database administration. I was the only Oracle DBA in the entire company for my first 18 months there! We actually had about 12 distinct Oracle-based application systems, most with distinct dev, functional test, performance test, and production databases. These were spread over more than 40 Sun servers ranging from Ultra 2s to E10Ks. Three of the production systems were on Sun PDB cluster and Oracle parallel server. Critical? At least four were the core components of the trading systems at one of the world's largest online brokerages - serious 24 x forever with (usually) million+ dollar costs for any downtime. Actually the number was about 24 databases until Jan 1999. At that time, they gave me some help - the guy who was the (only) DBA for the Informix system (which was phased out the following Fall) - to retrain as an Oracle DBA. Two weeks later I was asked to create 21 new databases on 17 new servers - within nine days. I made it with a little under an hour to spare. That brought the total up to about 45. By August, the ex-Informix DBA was doing Oracle full time and they had hired some more help (all with no significant Oracle experience!) - and, of course, added another 20-30 databases! When I left a couple of months ago (no surprise is it?) we had 42 production Oracle databases on 35 production servers, with a total of over 160 databases on over 120 servers, administered by 6 DBAs. We also had over 100 other servers (Web servers, WebLogic servers, Tuxedo servers, etc.) that had the Oracle client (including Pro*C)installed - which we also maintained. Of course I was working an average of about 95 hours/week much of that time... And sleeping less than half that. For none of these did I ever have any significant 3rd party tools (BMC Patrol, etc.). I did develop a *LOT* of homegrown scripts and automation though. [I still prefer, with a very few select exceptions, homegrown tools over commercial tools.] The other key was in *ADAMANTLY INSISTING* on being able to set things up right at the start. Having enough space on (at least most) test systems to load (or clone) production-sized databases helped also. This sounds kinda like When I was a kid, we had to walk five miles to school in neck-deep snow - uphill both ways! doesn't it? Unfortunately, its true. I have references and the complete lack of an outside life to prove it! Since I left, I've been decompressing and going through social rehabilitation [Hi, my name is Don. I haven't been on a bridge call in over two months. (Smattering of applause...)] -Don Granaman [certifiable OraSaurus and shameless braggart] PS: Most of, and certainly the best of, the DBA's I've ever worked with had significant prior experience as developers (not duhvelopers). - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Friday, August 31, 2001 12:18 PM Yeah, well, in a previous life I was in charge of 27 databases on 9 servers ALL BY MYSELF. Didn't have anybody working with me, man. Zilch. Nada. And, of course, I'm not going to talk about the nature of the systems 'cause then it wouldn't sound so impressive --Walt Weaver Bozeman, Montana -Original Message- Sent: Friday, August 31, 2001 10:38 AM To: Multiple recipients of list ORACLE-L We do about the same number with 6 DBAs... (not that that means sh*t without talking about the nature of the systems, of course) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED]
How to remove the old service of Oracle from win2k
Hi, Experts: After I tried with difference listener name in Win2K, it generated some services. Something like: OracleTNSListener80, OracleTNSListener80list804, OracleTNSListener80List805 and so on. They were generated automatically each time I start the listener with a new listener name. But how can I remove them? Thanks. B.R. --- ÍæתÒÂʳסÐÐÒ»Ìõ½Ö http://adinfo.21cn.com 21CN¶ÌÐÅÏëµã¾Íµã http://www.21cn.com/21cnhtm/duanxin/index.html ×ã²»³ö»§£¬ÏíÊÜרҵÓÊÏä·þÎñ http://www.21cn.net/extend/gb/Charge.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: WinterSun Zha 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: Duhvelopers and DB-ehs?
- PACKAGE utl_smtp AS /*** * OVERVIEW * * This package provides SMTP client-side access functionality in PL/SQL. * With this package, a PL/SQL program can send electronic mails via SMTP. * This package does not allow the PL/SQL program to receive e-mails via * SMTP. The user of this package should be familiar with the SMTP protocol * as defined in RFC 821 and RFC 1869. * * This package is meant to provide an API to SMTP protocol directly. Users * may find it useful to define additional helper routines to encapsulate * the interaction with a SMTP server. */ - JP Dne po 3. zá?í 2001 11:40 jste napsal(a): OOooh, that's something I want to be able to do is to send email to us in case of problems...I can send email from OraForms using Outlook but I've not got round to checking out how I send email from a Unix box via pl/sql or the likesany suggestions? K. hit any user to continue __ 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: 31 August 2001 17:38 To: Multiple recipients of list ORACLE-L we have homegrown shell scripts -- page us, email us, send daily status of the world reports... works! From: Thomas, Kevin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 05:47:12 -0800 Database monitoring toolsthrrp! We wrote our own using Java and lots of SQL are shell scripts...patchy but it works ;-) __ 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: 31 August 2001 14:17 To: Multiple recipients of list ORACLE-L I've got 11 databases (and just found out I'll probably have a new one, a semi, sort of, kind of data warehouse -- I need those books!) and there is me, my junior DBA who is not so junior anymore, and one consultant. And my CTO thinks that the DBAs are really just extra programming resources. So half the time we are doing non-DBA work. Oh yeah, and we don't have any of those high-falutin' database monitoring tools either :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 02:55:26 -0800 Bloody Hell, we have half that amount of systems yet only two DBAs. What on earth do they do with the rest of their time. -Original Message- Sent: 31 August 2001 09:40 To: Multiple recipients of list ORACLE-L LOL...with 31 systems to support 24/7/365 if you threw a stone in any direction you would hit a DBA. At the last count I believe we had 12...!! __ 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: 30 August 2001 17:22 To: Multiple recipients of list ORACLE-L Sounds like your company is looking for a new DBA? :- Jan Pruner Dne ?t 30. srpen 2001 17:26 jste napsal(a): I have to say I resent being called a duhveloper, granted the majority couldn't tune a banjo let alone tune a piece of SQL, but as a techie (and we all are), I find this list invaluable for getting advice on a wide range of topics, not just keeping a DB up and running or tuned...I don't call you guys names, and let's face it you DB-ehs? couldn't write a decent application if your lives depended on it... (blue touch-paper lit, retire a distance, do not re-approach once lit, and wait for fireworks) hit any user to continue __ 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: 30 August 2001 15:46 To: Multiple recipients of list ORACLE-L no, those posts keep us underworked DBAs from killing the duhvelopers who make us do the same thing over and over and over and who never listen when we tell them the correct way to design the tables. :) From: Boivin,
Smallest possible instance.
Hello all, Does anybody know the smallest possible size (SGA etc.) that an instance can be, and still run and accept connections? We have a test laptop that will be running Oracle 8.1.7, along with some of our tools against it, so the instances only need to accept around 2-3 connections.. If you have a sample init file or something like that also, that would be great.. Cheers Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: Duhvelopers and DB-ehs?
Use UTL_SMTP http://technet.oracle.com/doc/oracle8i_816/server.816/a76936/utl_smtp.ht m g -Original Message- Sent: Monday, September 03, 2001 10:41 AM To: Multiple recipients of list ORACLE-L OOooh, that's something I want to be able to do is to send email to us in case of problems...I can send email from OraForms using Outlook but I've not got round to checking out how I send email from a Unix box via pl/sql or the likesany suggestions? K. hit any user to continue __ 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 -- 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).
Re: Duhvelopers and DB-ehs?
Hi, take a look at the UTL_SMTP package. | Regards, | | Stefan Jahnke | | BOV AG | | @:D2 Vodafone, Abt.: FBOM | | Tel.: 0211/533-4893| Thomas, Kevin schrieb: OOooh, that's something I want to be able to do is to send email to us in case of problems...I can send email from OraForms using Outlook but I've not got round to checking out how I send email from a Unix box via pl/sql or the likesany suggestions? K. hit any user to continue __ 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: 31 August 2001 17:38 To: Multiple recipients of list ORACLE-L we have homegrown shell scripts -- page us, email us, send daily status of= t he world reports... works! From: Thomas, Kevin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 05:47:12 -0800 Database monitoring toolsthrrp! We wrote our own using Java and lots of SQL are shell scripts...patchy but it works ;-) __ 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: 31 August 2001 14:17 To: Multiple recipients of list ORACLE-L I've got 11 databases (and just found out I'll probably have a new one, a semi, sort of, kind of data warehouse -- I need those books!) and there is me, my junior DBA who is not so junior anymore, and one consultant. And my CTO thinks that the DBAs are really just extra programming=20 resources. So half the time we are doing non-DBA work. Oh yeah, and we don't have any of those high-falutin' database monitoring tools either :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 02:55:26 -0800 Bloody Hell, we have half that amount of systems yet only two DBAs. What= on earth do they do with the rest of their time. -Original Message- Sent: 31 August 2001 09:40 To: Multiple recipients of list ORACLE-L LOL...with 31 systems to support 24/7/365 if you threw a stone in any direction you would hit a DBA. At the last count I believe we had 12...!! __ 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: 30 August 2001 17:22 To: Multiple recipients of list ORACLE-L Sounds like your company is looking for a new DBA? :- Jan Pruner Dne ?t 30. srpen 2001 17:26 jste napsal(a): I have to say I resent being called a duhveloper, granted the majority couldn't tune a banjo let alone tune a piece of SQL, but as a techie (and we all are), I find this list invaluable for getting advice on a wide range of topics, not just keeping a DB up and running or tuned...I don't=20 call you guys names, and let's face it you DB-ehs? couldn't write a decent application if your lives depended on it... (blue touch-paper lit, retire a distance, do not re-approach once lit, and wait for fireworks) hit any user to continue __ 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: 30 August 2001 15:46 To: Multiple recipients of list ORACLE-L no, those posts keep us underworked DBAs from killing the=20 duhvelopers who make us do the same thing over and over and over and who never listen when we tell them the correct way to design the tables. :) From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: !! Keeping the list alive Date: Thu, 30 Aug 2001 04:00:52 -0800 Just look at the number of OT postings in the last couple of=20 months... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des syst=E8mes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | R=E9gion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL
RE: Duhvelopers and DB-ehs?
Thanks Jan, I'll check and see if we have access to this package... hit any user to continue __ 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: 03 September 2001 11:36 To: Multiple recipients of list ORACLE-L - PACKAGE utl_smtp AS /*** * OVERVIEW * * This package provides SMTP client-side access functionality in PL/SQL. * With this package, a PL/SQL program can send electronic mails via SMTP. * This package does not allow the PL/SQL program to receive e-mails via * SMTP. The user of this package should be familiar with the SMTP protocol * as defined in RFC 821 and RFC 1869. * * This package is meant to provide an API to SMTP protocol directly. Users * may find it useful to define additional helper routines to encapsulate * the interaction with a SMTP server. */ - JP Dne po 3. zá?í 2001 11:40 jste napsal(a): OOooh, that's something I want to be able to do is to send email to us in case of problems...I can send email from OraForms using Outlook but I've not got round to checking out how I send email from a Unix box via pl/sql or the likesany suggestions? K. hit any user to continue __ 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: 31 August 2001 17:38 To: Multiple recipients of list ORACLE-L we have homegrown shell scripts -- page us, email us, send daily status of the world reports... works! From: Thomas, Kevin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 05:47:12 -0800 Database monitoring toolsthrrp! We wrote our own using Java and lots of SQL are shell scripts...patchy but it works ;-) __ 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: 31 August 2001 14:17 To: Multiple recipients of list ORACLE-L I've got 11 databases (and just found out I'll probably have a new one, a semi, sort of, kind of data warehouse -- I need those books!) and there is me, my junior DBA who is not so junior anymore, and one consultant. And my CTO thinks that the DBAs are really just extra programming resources. So half the time we are doing non-DBA work. Oh yeah, and we don't have any of those high-falutin' database monitoring tools either :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 02:55:26 -0800 Bloody Hell, we have half that amount of systems yet only two DBAs. What on earth do they do with the rest of their time. -Original Message- Sent: 31 August 2001 09:40 To: Multiple recipients of list ORACLE-L LOL...with 31 systems to support 24/7/365 if you threw a stone in any direction you would hit a DBA. At the last count I believe we had 12...!! __ 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: 30 August 2001 17:22 To: Multiple recipients of list ORACLE-L Sounds like your company is looking for a new DBA? :- Jan Pruner Dne ?t 30. srpen 2001 17:26 jste napsal(a): I have to say I resent being called a duhveloper, granted the majority couldn't tune a banjo let alone tune a piece of SQL, but as a techie (and we all are), I find this list invaluable for getting advice on a wide range of topics, not just keeping a DB up and running or tuned...I don't call you guys names, and let's face it you DB-ehs? couldn't write a decent application if your lives depended on it... (blue touch-paper lit, retire a distance, do not re-approach once lit, and wait for fireworks) hit any user to continue __ 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
Re: OT Re: INDEXLEME ONEMLI
Yes Okan , thank you. bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 03, 2001 1:20 PM Well... I guess Bunyamin was trying to warn their developers about indexing and he has sent it wrong. Gints, it is Turkish not Turkic. Anyway, we are at the quarter finals, hoping to get the cup.. Okan Never argue with an idiot, they will drag you down to their level and beat you with experience (Dilberts Rules of Order) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 03, 2001 12:26 PM Although there is European Basketball Championship in Turkey and I'm a big fan of it, I don't know Turkic (I suppose so) now ;))) Gints Plivna IT Sist?mas, Mer?e?a 13, LV1050 R?ga http://www.itsystems.lv/gints/ Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] bunyamink@havelscc: an.com.tr Subject: INDEXLEME ONEMLI Sent by: [EMAIL PROTECTED] 2001.09.03 10:20 Please respond to ORACLE-L Arkadaþlar , Form içinde yaptýðýnýz ORDER BY, GROUP BY gibi fonksiyonlarý hangi tablolarýn hangi alanlarýnda yaptýðýnýzý bir yerlere lütfen yazýn. Bu alanlarda index yaratýlacaktýr. Form da blok propertilerinde order by yaparsanýz onu da yazýn . Bunyamin Your Databored Administrator -- 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: Okan CIMEN 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: Bunyamin K. Karadeniz 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).
OEM on HPUX
Guys, has anyone set up Enterprise Manager 9.0.1 on HPUX? More specifically the Intelligent (now there's a misnomer!!) Agent? When I try to autodiscover nodes, it says the Agent is not running. I then run agentctl status and get the message Required configuration file snmp_ro.ora not found This file is in $ORACLE_HOME/network/admin, is owned by the ORACLE user and the directory specified above is in PATH. Anybody got any clues?? TIA
Re: Duhvelopers and DB-ehs?
... or the likesany suggestions? will be much more easier to hire some office-girl and let she mail it manualy than drive some developer to write the code :-))) JP Dne po 3. zá?í 2001 13:10 jste napsal(a): Thanks Jan, I'll check and see if we have access to this package... hit any user to continue __ 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: 03 September 2001 11:36 To: Multiple recipients of list ORACLE-L --- - - PACKAGE utl_smtp AS /*** * OVERVIEW * * This package provides SMTP client-side access functionality in PL/SQL. * With this package, a PL/SQL program can send electronic mails via SMTP. * This package does not allow the PL/SQL program to receive e-mails via * SMTP. The user of this package should be familiar with the SMTP protocol * as defined in RFC 821 and RFC 1869. * * This package is meant to provide an API to SMTP protocol directly. Users * may find it useful to define additional helper routines to encapsulate * the interaction with a SMTP server. */ --- - - JP Dne po 3. zá?í 2001 11:40 jste napsal(a): OOooh, that's something I want to be able to do is to send email to us in case of problems...I can send email from OraForms using Outlook but I've not got round to checking out how I send email from a Unix box via pl/sql or the likesany suggestions? K. hit any user to continue __ 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: 31 August 2001 17:38 To: Multiple recipients of list ORACLE-L we have homegrown shell scripts -- page us, email us, send daily status of the world reports... works! From: Thomas, Kevin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 05:47:12 -0800 Database monitoring toolsthrrp! We wrote our own using Java and lots of SQL are shell scripts...patchy but it works ;-) __ 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: 31 August 2001 14:17 To: Multiple recipients of list ORACLE-L I've got 11 databases (and just found out I'll probably have a new one, a semi, sort of, kind of data warehouse -- I need those books!) and there is me, my junior DBA who is not so junior anymore, and one consultant. And my CTO thinks that the DBAs are really just extra programming resources. So half the time we are doing non-DBA work. Oh yeah, and we don't have any of those high-falutin' database monitoring tools either :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 02:55:26 -0800 Bloody Hell, we have half that amount of systems yet only two DBAs. What on earth do they do with the rest of their time. -Original Message- Sent: 31 August 2001 09:40 To: Multiple recipients of list ORACLE-L LOL...with 31 systems to support 24/7/365 if you threw a stone in any direction you would hit a DBA. At the last count I believe we had 12...!! __ 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: 30 August 2001 17:22 To: Multiple recipients of list ORACLE-L Sounds like your company is looking for a new DBA? :- Jan Pruner Dne ?t 30. srpen 2001 17:26 jste napsal(a): I have to say I resent being called a duhveloper, granted the majority couldn't tune a banjo let alone tune a piece of SQL, but as a techie (and we all are), I find this list invaluable for getting advice on a wide range of topics, not just keeping a DB up and running or tuned...I don't call you guys names, and let's face it you DB-ehs? couldn't write a decent application if your lives depended on
RE: a little sql question
set feedback on Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : Djaroud Salim [mailto:[EMAIL PROTECTED]] Envoyé : lundi 3 septembre 2001 10:30 À : Multiple recipients of list ORACLE-L Objet : a little sql question hi every body, I need to insert in the end of a sql script, the number of rows returned. how can i do that ? thanks !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim 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: INF/MEKKAOUI 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: Shutdown and archivelog mode
do a shutdown normal ALWAYS after issuing a shutdown abort. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 03, 2001 3:16 PM Hi Using Oracle 8.1.6.3 on solaris 2.7. I am trying to put my database in archivelog mode. When I try to shutdown the database using shutdown immediate, it just sits there for ages.. (left it for 30 mins). I've cancelled this and done a shutdown abort. (tried normal shutdown after that, same) Due to this when I try to put it archivelog mode after shutdown abort I get a message saying that the database can't be put into archivelog mode because recovery is needed. TIA -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saurabh Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to remove the old service of Oracle from win2k
in the RESKIT, you have a tool called SRVINSTW.exe that allows you to add/remove services. /Maya -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of WinterSun Zhao Sent: Monday, September 03, 2001 12:45 PM To: Multiple recipients of list ORACLE-L Subject: How to remove the old service of Oracle from win2k Hi, Experts: After I tried with difference listener name in Win2K, it generated some services. Something like: OracleTNSListener80, OracleTNSListener80list804, OracleTNSListener80List805 and so on. They were generated automatically each time I start the listener with a new listener name. But how can I remove them? Thanks. B.R. --- ÍæתÒÂʳסÐÐÒ»Ìõ½Ö http://adinfo.21cn.com 21CN¶ÌÐÅÏëµã¾Íµã http://www.21cn.com/21cnhtm/duanxin/index.html ×ã²»³ö»§£¬ÏíÊÜרҵÓÊÏä·þÎñ http://www.21cn.net/extend/gb/Charge.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: WinterSun Zha 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).æ¬zǶ¨}ø©ND ±@Bm§ÿðà +iöªrºØh¬Æ²h§§êÈ4Dæk¤zyÞ®ÚÞ§(V +r5ëp¢¹z»âqëçÎwó9ÔPó9ßÎtçT8'è®xæåÂ'µêçzÖqë,üÆ¢)à.+-±:Ã*.®Ç¥}úèØb²f¢)à+-±éÝjq +j)fzËëh.+-êî}«\Ü¢ièµá $ì¥éex(|¸¬´k«¹©Ý{azg¬±¨àØw%¹×)Þríj)â +I@ND º+¶§jg¨~f¢)à+-Ê°j{m¡·«zj/y×ë¢f(ºf²j[(±éݶ³Ü¢i×è®az¸§~æjبX¤z˱Êân)à
Re: Shutdown and archivelog mode
Sajid, The db must be cleanly shutdown (normal or immediate) in order to change the archivelog mode. A shutdown immediate may not shutdown immediately for several reasons, most commonly: 1. There is an uncommitted transaction that needs to roll back. 2. SMON is deallocating temp segments and there are a very large # of them to deallocate (usually due to the default extent sizes for the temporary tablespace being too low). See metalink note 61997.1 for an excellent discussion on this. HTH, -- Anita --- Sajid Iqbal [EMAIL PROTECTED] wrote: Hi Using Oracle 8.1.6.3 on solaris 2.7. I am trying to put my database in archivelog mode. When I try to shutdown the database using shutdown immediate, it just sits there for ages.. (left it for 30 mins). I've cancelled this and done a shutdown abort. (tried normal shutdown after that, same) Due to this when I try to put it archivelog mode after shutdown abort I get a message saying that the database can't be put into archivelog mode because recovery is needed. TIA -- Sajid Iqbal __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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: ergent help: ora-27091 on system tablespace
Corruption in the system datafile takes special handling so if you haven't already done so I highly recommend logging a tar with support. If you are unable to even cp or dd the file then you most likely have a problem with the file at the OS level and you need to get that issue resolved. As to your recovery situations, it depends on when your last backup was taken and if the db is in archivelog mode. The best method if the db is in archivelog mode is to identify a backup containing a clean version of the datafile (i.e. one in which dbv doesn't report any errors), restore that datafile from backup, and recover it. Since this is a datafile belonging to the system tablespace you will need to shutdown the db and do this from a mount stage. I would highly recommend doing a full db export for safekeeping in the event that there are any problems with your backups. HTH, -- Anita --- chao zhu [EMAIL PROTECTED] wrote: hi, gurus: when i do a fulldatabase export, oracle error 27091 appeard: . . exporting table MHNK EXP-8: ORACLE error 1115 encountered ORA-01115: IO error reading block from file 1 (block # 13095) ORA-01110: data file 1: '/oracle/DEV/sapdata1/system_1/system.data1' ORA-27091: skgfqio: unable to queue I/O IBM AIX RISC System/6000 Error: 5: I/O error Additional information: 13094 . exporting table MHNKA EXP-8: ORACLE error 1115 encountered ORA-01115: IO error reading block from file 1 (block # 13095) ORA-01110: data file 1: '/oracle/DEV/sapdata1/system_1/system.data1' ORA-27091: skgfqio: unable to queue I/O IBM AIX RISC System/6000 Error: 5: I/O error Additional information: 13094 i checked the table, no record. and no such 27091 message in alertsid.log. i checked dba_extents, with block_id between 13094 and 13096, the table is a SAPR3 table:agr_1250? isn't a system table! i run dbverify and it reported error message: DEV_SVC:oradev 13 dbv file=system.data1 blocksize=8192 DBVERIFY: Release 8.1.7.0.0 - Production on Sun Sep 2 16:49:10 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. DBVERIFY - Verification starting : FILE = system.data1 DBV-00102: File I/O error on FILE (system.data1) during verification read operation (-2) so, it seems the datafile has corrupted, and i do not know when it corrupted. Shall i just recreate the tables affected, or restore the database. If restore, when to begin? I do not know when it corrupted, since no error message in alertsid.log? And now i cannot backup the corrupted datafile, neither through cp or dd.It always abort at the middle of the datafile. thanks. _ Do You Yahoo!? ???â??! http://mail.yahoo.com.cn font color=#FF?D???Æ??û-?4D/font ?D??! http://cn.chat.yahoo.com/c/roomlist.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?gb2312?q?chao=20zhu?= 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 email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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).
IMP-00069 error when importing 8.1.7 export
Hi list, I have a problem when importing a 8.1.7 export to my 8.1.7.0.1 Oracle on Linux. Export was done with characterset UTF8, I tried to import with characterset WE8ISO8859P1, WE8ISO8859P1 and UTF8; nothing works. Any help is welcome. TIA Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker 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: Analyze all indexed columns
Iain, This is covered in greater detail in the SQL Reference manual under the Analyze command, but here's a summary of the basics. Computing/estimating statistics on the table (without a FOR clause) calculates/estimates stats for the table and its indexes. The for clause has the following options: For Table - table stats only For Columns column_list All Columns For All Indexed Columns - gathers column stats on the specified columns, all columns, or only the indexed columns. If the SIZE option is also included, then histogram information is gathered as well. For more details on histograms see metalink note 1031826.6 Histograms: An Overview Some key details to consider before using histograms: * they are not used with bind variables. * they are useful only if the data is heavily skewed (i.e. it's not uniformly distributed) HTH, -- Anita --- Nicoll, Iain (Calanais) [EMAIL PROTECTED] wrote: Apologies for what is probably a really simple question but what is the default behaviour of analyze table table_name compute statistics and would analyze table table_name compute statistics for table for indexed columns for all indexes be any better/worse than analyzing separately eg analyze table table_name compute statistics analyze table table_name compute statistics for all indexed columns analyze index index_name compute statistics Version is Oracle 7.3. The only references I've got access to don't appear to make it clear. TIA Iain Nicoll __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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 remove the old service of Oracle from win2k
A sneaky little trick on 8.0.6 and below is to use oradim to remove the service. ORADIMxx -DELETE -SRVC service_name where ORADIMxx is oradim73 or oradim80 service_name is the name of the service to be deleted (it is not case sensitive) Be very careful as you can use this to delete non-Oracle services as well, so use at your own risk! They fixed oradim in 8i and above so that it can be used to delete only services named oracleservicesid HTH, -- Anita --- WinterSun Zhao [EMAIL PROTECTED] wrote: Hi, Experts: After I tried with difference listener name in Win2K, it generated some services. Something like: OracleTNSListener80, OracleTNSListener80list804, OracleTNSListener80List805 and so on. They were generated automatically each time I start the listener with a new listener name. But how can I remove them? Thanks. B.R. __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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: NLS_LANG
Jan and Todd, In Oracle8 and above this can be done provided you want to convert the db to a strict superset of the existing character set (e.g. US7ASCII to WE8ISO8859P1). Otherwise the only supported option is to recreate the db via export/import. See the following metalink docs: Note: 123670.1 Use Scanner Utility before Altering the Database Character Set Note: 66320.1 V8: Changing the Database National Character Set Note: 119164.1 Changing Database Character set - Valid Superset definitions HTH, -- Anita --- Jan Pruner [EMAIL PROTECTED] wrote: No way, only recreate the database. Jan Pruner Dne p?1. srpen 2001 18:08 jste napsal(a): Does anyone know how or if it is possible to change the NLS_LANG value for a database that has already been created? I believe the answer is no, but I wanted a sanity check (Lord knows I need one). Thanks. Todd Carlson Oracle 8i Certified DBA Bunge North America __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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).
OL$ and OL$HINTS Tablespace
Listers, I don't have access to Metalink so I can't check this out. Does Oracle support moving the OL$ and OL$HINTS tables to a different tablespace, or, do they frown upon this? I know they used to have note talking about moving the AUD$ table and index to a different tablespace, but, it seems like someone mentioned that Oracle now frowns upon that as well. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins 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).
migrating from 8.0.5 to 8.1.7
hi migrator, any one have problems with packages or stored procedures ?? wait a feedback ! thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim 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 LINKS QUESTION ??
I have not used this, but Don Burleson has a book : Unix for Oracle DBAs Pocket Reference http://www.oreilly.com/catalog/unixoracledbapr/ HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Bunyamin K. Karadeniz [SMTP:[EMAIL PROTECTED]] Sent: Monday, September 03, 2001 5:30 AM To: Multiple recipients of list ORACLE-L Subject: UNIX LINKS QUESTION ?? My unix knowledge is low and I want to develop it . But I search for a tutorial for Oracle People especially DBA's. IS there a source on web including the directory structure, oratab or other things to administer a database on Unix system ? I' ll be so happy for your helps . Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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-27146: post/wait initialization failed
Hi, You can find the info you're looking for in the install guide , chapter 2 Pre-installation Configuring the Kernel for Oracle8i. I had to increase the semaphores when I tried to create a 2nd instance on my server, it was working fine at first db creation. I used the default values that doc provided and increased the SEMMNS to 500. /Maya Hi Using Oracle 8.1.6.3 on Solaris 2.7. I get this error ORA-27146: post/wait initialization failed when trying to startup my database.. if I reboot the machine then it starts up without problems.. From reading previous e-mails.. I'm led to belive that the semaphores need to be increased. Does anyone know how to do this, also how to calculate how much to increase by etc Regards -- Sajid Iqbal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sajid Iqbal 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).æ¬zǶ¨}ø©ND ±@Bm§ÿðà +iöªrºØh¬Æ²h§§êÈ4Dæk¤zyÞ®ÚÞ§(V +r5ëp¢¹z»âqëçÎwó9ÔPó9ßÎtçT8'è®xæåÂ'µêçzÖqë,üÆ¢)à.+-±:Ã*.®Ç¥}úèØb²f¢)à+-±éÝjq +j)fzËëh.+-êî}«\Ü¢ièµá $ì¥éex(|¸¬´k«¹©Ý{azg¬±¨àØw%¹×)Þríj)â +I@ND º+¶§jg¨~f¢)à+-Ê°j{m¡·«zj/y×ë¢f(ºf²j[(±éݶ³Ü¢i×è®az¸§~æjبX¤z˱Êân)à
Re: NLS_LANG
Nice, but it never works for me. I have tried to convert from ee8mswin1250 to utf8 and it didn't convert right the czech signs. JP Dne po 3. zá?í 2001 15:50 jste napsal(a): Jan and Todd, In Oracle8 and above this can be done provided you want to convert the db to a strict superset of the existing character set (e.g. US7ASCII to WE8ISO8859P1). Otherwise the only supported option is to recreate the db via export/import. See the following metalink docs: Note: 123670.1 Use Scanner Utility before Altering the Database Character Set Note: 66320.1 V8: Changing the Database National Character Set Note: 119164.1 Changing Database Character set - Valid Superset definitions HTH, -- Anita --- Jan Pruner [EMAIL PROTECTED] wrote: No way, only recreate the database. Jan Pruner Dne p?1. srpen 2001 18:08 jste napsal(a): Does anyone know how or if it is possible to change the NLS_LANG value for a database that has already been created? I believe the answer is no, but I wanted a sanity check (Lord knows I need one). Thanks. Todd Carlson Oracle 8i Certified DBA Bunge North America __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: INDEXLEME ONEMLI
Thank you Rahul , It worked perfect . :)) Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 03, 2001 4:25 PM instead of ORDER BY use YADAYADA BU , it will work :-) -- From: Jan Pruner[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Monday, September 03, 2001 4:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: INDEXLEME ONEMLI Yes. :- Dne po 3. zá?í 2001 10:20 jste napsal(a): Arkadaþlar , Form içinde yaptýðýnýz ORDER BY, GROUP BY gibi fonksiyonlarý hangi tablolarýn hangi alanlarýnda yaptýðýnýzý bir yerlere lütfen yazýn. Bu alanlarda index yaratýlacaktýr. Form da blok propertilerinde order by yaparsanýz onu da yazýn . Bunyamin Your Databored Administrator Content-Type: text/html; charset=iso-8859-9; name=P?íloha: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: Rahul 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: Bunyamin K. Karadeniz 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: IMP-00069 error when importing 8.1.7 export
Hi, can you export your 81700 db with the 81701 exp utility? oli [EMAIL PROTECTED] wrote: Hi list, I have a problem when importing a 8.1.7 export to my 8.1.7.0.1 Oracle on Linux. Export was done with characterset UTF8, I tried to import with characterset WE8ISO8859P1, WE8ISO8859P1 and UTF8; nothing works. Any help is welcome. TIA Volker Schön E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schoen Volker 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). -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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: !! Keeping the list alive
Man, I remember the day when there were about 60 IT staff here. Now, I believe its under 20 or will be very shortly. It was a tough week here last week. We had to match what our client was letting go so we did that no problem. Pretty much everyone is off to another project from us. But to come in every morning and see the Fujitsu HR department catching people at the door before going into the Fab to give them their walking papers was tough. Its the first place I have worked at that has gone through that (while I was there). I believe some upper management will get their papers this week. -Original Message- Sent: Saturday, September 01, 2001 9:05 PM To: Multiple recipients of list ORACLE-L if 40 is small, is 16 microscopic? (and of that 16, 5 are consultants) From: Jared Still [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: !! Keeping the list alive Date: Sat, 01 Sep 2001 12:35:23 -0800 Just to add to my previous comment: I'm working at a company with small ( 40 or so ) IS shop. The weak do not survive in this environment. The developers I work with here are great. They're bright, hard working and un-egotistical. They are even will to take direction from the DBA in database related matters. Not a duhveloper in the bunch. Ya gotta love it! Jared On Thursday 30 August 2001 14:16, you wrote: Um, Kevin, if the shoe doesn't fit, then don't wear it. :) Not all developers are duhvelopers, in fact, most of the ones I know are very good, but the ones that are duhvelopers require so much attention that it kind of wears on you. :) And some of us DB-ehs can do just fine writing apps, thank you, but we choose a path that requires less 'direction' from users. ;) Jared Thomas, Kevin Kevin.Thomas@cal To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] anais.com cc: Sent by:Subject: RE: !! Keeping the list alive [EMAIL PROTECTED] 08/30/01 08:26 AM Please respond to ORACLE-L I have to say I resent being called a duhveloper, granted the majority couldn't tune a banjo let alone tune a piece of SQL, but as a techie (and we all are), I find this list invaluable for getting advice on a wide range of topics, not just keeping a DB up and running or tuned...I don't call you guys names, and let's face it you DB-ehs? couldn't write a decent application if your lives depended on it... (blue touch-paper lit, retire a distance, do not re-approach once lit, and wait for fireworks) hit any user to continue __ 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: 30 August 2001 15:46 To: Multiple recipients of list ORACLE-L no, those posts keep us underworked DBAs from killing the duhvelopers who make us do the same thing over and over and over and who never listen when we tell them the correct way to design the tables. :) From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: !! Keeping the list alive Date: Thu, 30 Aug 2001 04:00:52 -0800 Just look at the number of OT postings in the last couple of months... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 7:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: !! Keeping the list alive You're surprised at those willing to pay? You have to realize that most DBAs are over-payed and under-worked ducking -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:43 PM To: Multiple recipients of list ORACLE-L Subject: !! Keeping the list alive This list is apparently a more valuable resource to many of you than I realized. I'm literally bowled over by the generosity. I've received so many emails about
RE: OT RE: database consistency tools ?
Um, headphones? I would die to be able to play music at work. For some reasons safety won't let us. They claim its because then we can't hear the overheads. Damn, I can't remember the last time I was able to make one out anyway -Original Message- Sent: Friday, August 31, 2001 4:46 PM To: Multiple recipients of list ORACLE-L not where I work, everyone has their personal stereo (company provided, we are a music site, in part) cranked up way too high. Interesting sounds when you combine hip-hop, heavy metal and classic rock From: Koivu, Lisa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT RE: database consistency tools ? Date: Fri, 31 Aug 2001 12:20:29 -0800 If the DBA screams bloody murder and loses his or her mind, does anybody hear? -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 3:07 PM To: Multiple recipients of list ORACLE-L Subject:RE: OT RE: database consistency tools ? Yea yea yeait's like If God is All Powerful, can He make a rock so heavy even He can't pick it up? -Original Message- Sent: Friday, August 31, 2001 2:21 PM To: Multiple recipients of list ORACLE-L SHE dares to say she ain't no goddess. From: Mohan, Ross [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT RE: database consistency tools ? Date: Fri, 31 Aug 2001 08:47:15 -0800 NoRachel is God(dess). Dare anyway say She Know Less? EG -Original Message- Sent: Friday, August 31, 2001 12:23 PM To: Multiple recipients of list ORACLE-L you all really have an overinflated idea of my knowledge base. sheesh! From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: database consistency tools ? Date: Fri, 31 Aug 2001 05:27:31 -0800 Me too, plus Informix (plus DB26000 for about 2 months) although as with Oracle Rachel has probably forgotten more than I know :-) Lee -Original Message- Sent: 31 August 2001 10:35 To: Multiple recipients of list ORACLE-L oh brother, here we go again. Do I dare tell you I was an Ingres DBA too? :) From: Joe Testa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: database consistency tools ? Date: Thu, 30 Aug 2001 18:05:29 -0800 Rachel, you were a sybase DBA, the goddess notches another one on her belt. joe Rachel Carmichael wrote: Jared, having been a sybase dba (I know, forgive me for straying)... we ran dbcc a lot. Oracle equivalent (poor equivalent) would be analyze table validate structure maybe? Rachel SNIP -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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-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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally
RE: Duhvelopers and DB-ehs?
well, we don't send it out of pl/sql directly, we run shell scripts that run the sql, then use shell to check the results and if it meets the send a message criteria, we use mail or mailx to send it. you can use pipes to call unix shell programs though From: Thomas, Kevin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Mon, 03 Sep 2001 01:40:35 -0800 OOooh, that's something I want to be able to do is to send email to us in case of problems...I can send email from OraForms using Outlook but I've not got round to checking out how I send email from a Unix box via pl/sql or the likesany suggestions? K. hit any user to continue __ 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: 31 August 2001 17:38 To: Multiple recipients of list ORACLE-L we have homegrown shell scripts -- page us, email us, send daily status of the world reports... works! From: Thomas, Kevin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 05:47:12 -0800 Database monitoring toolsthrrp! We wrote our own using Java and lots of SQL are shell scripts...patchy but it works ;-) __ 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: 31 August 2001 14:17 To: Multiple recipients of list ORACLE-L I've got 11 databases (and just found out I'll probably have a new one, a semi, sort of, kind of data warehouse -- I need those books!) and there is me, my junior DBA who is not so junior anymore, and one consultant. And my CTO thinks that the DBAs are really just extra programming resources. So half the time we are doing non-DBA work. Oh yeah, and we don't have any of those high-falutin' database monitoring tools either :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 02:55:26 -0800 Bloody Hell, we have half that amount of systems yet only two DBAs. What on earth do they do with the rest of their time. -Original Message- Sent: 31 August 2001 09:40 To: Multiple recipients of list ORACLE-L LOL...with 31 systems to support 24/7/365 if you threw a stone in any direction you would hit a DBA. At the last count I believe we had 12...!! __ 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: 30 August 2001 17:22 To: Multiple recipients of list ORACLE-L Sounds like your company is looking for a new DBA? :- Jan Pruner Dne ?t 30. srpen 2001 17:26 jste napsal(a): I have to say I resent being called a duhveloper, granted the majority couldn't tune a banjo let alone tune a piece of SQL, but as a techie (and we all are), I find this list invaluable for getting advice on a wide range of topics, not just keeping a DB up and running or tuned...I don't call you guys names, and let's face it you DB-ehs? couldn't write a decent application if your lives depended on it... (blue touch-paper lit, retire a distance, do not re-approach once lit, and wait for fireworks) hit any user to continue __ 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: 30 August 2001 15:46 To: Multiple recipients of list ORACLE-L no, those posts keep us underworked DBAs from killing the duhvelopers who make us do the same thing over and over and over and who never listen when we tell them the correct way to design the tables. :) From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: !! Keeping the list alive Date: Thu, 30 Aug 2001 04:00:52 -0800 Just look at the number of OT postings in the last couple of months... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch |
Re: tablespace corrupted and no backup , how to remove it ?
Why would you be annoyed that the database doesn't open with a corrupted tablespace? That's what';s SUPPOSED to happen. okay, we just did this a few days ago but here it is again: startup mount alter database datafile 'filename' offline drop; (repeat this for every datafile in the tablespace) alter database open; drop tablespace tablespace name including contents; that will get rid of the tablespace From: Maya Kenner [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: tablespace corrupted and no backup , how to remove it ? Date: Mon, 03 Sep 2001 06:10:22 -0800 Hello, I succeed corrupting a tablespace but now I am a little bit annnoyed as my db does not want to go in OPEN mode, I would like to remove this tablespace but I failed. Any idea how to? Thanks, Maya _ 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-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).
Standby database
Hi All, I'm resaerching standby database on 8.0.5 here and have a question. Setting up the standby database is quite well documented, but how to configure the clients in such a way that they will first try the primary site and if that's not responding try the standby site. Oracle documentation did not give me satisfactory result. 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: 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: OL$ and OL$HINTS Tablespace
yes they do support it. hth connor --- Larry Elkins [EMAIL PROTECTED] wrote: Listers, I don't have access to Metalink so I can't check this out. Does Oracle support moving the OL$ and OL$HINTS tables to a different tablespace, or, do they frown upon this? I know they used to have note talking about moving the AUD$ table and index to a different tablespace, but, it seems like someone mentioned that Oracle now frowns upon that as well. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: !! Keeping the list alive
Time to chip in my horror story (and why I'll never do permie again). Company in OZ decided to cut down numbers. Bosses walked around with security guards into each persons office and tell them they have 5 minutes to leave to premises and give them a ticket which has a 15minute after-hours timeslot in which they will have a supervised cleanout of their desk/office etc. They were marched down the lift and out into the street. I only knew this because the girl that gave me a lift to work phoned me from home and said sorry, can't take you home, my job is gone So - if you ever get a chance to work for BHP in Australia :-( Cheers Connor --- Kimberly Smith [EMAIL PROTECTED] wrote: Man, I remember the day when there were about 60 IT staff here. Now, I believe its under 20 or will be very shortly. It was a tough week here last week. We had to match what our client was letting go so we did that no problem. Pretty much everyone is off to another project from us. But to come in every morning and see the Fujitsu HR department catching people at the door before going into the Fab to give them their walking papers was tough. Its the first place I have worked at that has gone through that (while I was there). I believe some upper management will get their papers this week. -Original Message- Sent: Saturday, September 01, 2001 9:05 PM To: Multiple recipients of list ORACLE-L if 40 is small, is 16 microscopic? (and of that 16, 5 are consultants) From: Jared Still [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: !! Keeping the list alive Date: Sat, 01 Sep 2001 12:35:23 -0800 Just to add to my previous comment: I'm working at a company with small ( 40 or so ) IS shop. The weak do not survive in this environment. The developers I work with here are great. They're bright, hard working and un-egotistical. They are even will to take direction from the DBA in database related matters. Not a duhveloper in the bunch. Ya gotta love it! Jared On Thursday 30 August 2001 14:16, you wrote: Um, Kevin, if the shoe doesn't fit, then don't wear it. :) Not all developers are duhvelopers, in fact, most of the ones I know are very good, but the ones that are duhvelopers require so much attention that it kind of wears on you. :) And some of us DB-ehs can do just fine writing apps, thank you, but we choose a path that requires less 'direction' from users. ;) Jared Thomas, Kevin Kevin.Thomas@cal To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] anais.com cc: Sent by: Subject: RE: !! Keeping the list alive [EMAIL PROTECTED] 08/30/01 08:26 AM Please respond to ORACLE-L I have to say I resent being called a duhveloper, granted the majority couldn't tune a banjo let alone tune a piece of SQL, but as a techie (and we all are), I find this list invaluable for getting advice on a wide range of topics, not just keeping a DB up and running or tuned...I don't call you guys names, and let's face it you DB-ehs? couldn't write a decent application if your lives depended on it... (blue touch-paper lit, retire a distance, do not re-approach once lit, and wait for fireworks) hit any user to continue __ 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: 30 August 2001 15:46 To: Multiple recipients of list ORACLE-L no, those posts keep us underworked DBAs from killing the duhvelopers who make us do the same thing over and over and over and who never listen when we tell them the correct way to design the tables. :) From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: !! Keeping the list alive Date: Thu, 30 Aug 2001 04:00:52 -0800 Just look at the number of OT postings in the last couple of months... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent:
RE: Duhvelopers and DB-ehs?
Yea, I've got the 'running the unix shell script' part down...did you see the mails someone sent re: utl_smtp?? hit any user to continue __ 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: 03 September 2001 17:35 To: Multiple recipients of list ORACLE-L well, we don't send it out of pl/sql directly, we run shell scripts that run the sql, then use shell to check the results and if it meets the send a message criteria, we use mail or mailx to send it. you can use pipes to call unix shell programs though From: Thomas, Kevin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Mon, 03 Sep 2001 01:40:35 -0800 OOooh, that's something I want to be able to do is to send email to us in case of problems...I can send email from OraForms using Outlook but I've not got round to checking out how I send email from a Unix box via pl/sql or the likesany suggestions? K. hit any user to continue __ 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: 31 August 2001 17:38 To: Multiple recipients of list ORACLE-L we have homegrown shell scripts -- page us, email us, send daily status of the world reports... works! From: Thomas, Kevin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 05:47:12 -0800 Database monitoring toolsthrrp! We wrote our own using Java and lots of SQL are shell scripts...patchy but it works ;-) __ 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: 31 August 2001 14:17 To: Multiple recipients of list ORACLE-L I've got 11 databases (and just found out I'll probably have a new one, a semi, sort of, kind of data warehouse -- I need those books!) and there is me, my junior DBA who is not so junior anymore, and one consultant. And my CTO thinks that the DBAs are really just extra programming resources. So half the time we are doing non-DBA work. Oh yeah, and we don't have any of those high-falutin' database monitoring tools either :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 02:55:26 -0800 Bloody Hell, we have half that amount of systems yet only two DBAs. What on earth do they do with the rest of their time. -Original Message- Sent: 31 August 2001 09:40 To: Multiple recipients of list ORACLE-L LOL...with 31 systems to support 24/7/365 if you threw a stone in any direction you would hit a DBA. At the last count I believe we had 12...!! __ 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: 30 August 2001 17:22 To: Multiple recipients of list ORACLE-L Sounds like your company is looking for a new DBA? :- Jan Pruner Dne ?t 30. srpen 2001 17:26 jste napsal(a): I have to say I resent being called a duhveloper, granted the majority couldn't tune a banjo let alone tune a piece of SQL, but as a techie (and we all are), I find this list invaluable for getting advice on a wide range of topics, not just keeping a DB up and running or tuned...I don't call you guys names, and let's face it you DB-ehs? couldn't write a decent application if your lives depended on it... (blue touch-paper lit, retire a distance, do not re-approach once lit, and wait for fireworks) hit any user to continue __ 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: 30 August 2001 15:46 To: Multiple recipients of list ORACLE-L no, those posts keep us underworked DBAs from killing the duhvelopers who make us do the same thing over and over and over and who never listen when we tell them the correct way to design the tables. :) From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L
SEMAPHORES AND ORACLE
Hi listers, AIX 4.3.3.0, Oracle 8.1.7 I have been recieving ORA-01041on some clients with Hostdef extension doesn't exist I searched Metalink looking for some answers and all the info points to semaphores configuration vrs oracle processes. Oracle processes is set to 500, but I don't know where to look at semaphores parameters. I found some info that says I should look at SEMMNS kernel parameter, but can't find where and how to look for it. I will appreciate any info on this topic, thanks! Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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: !! Keeping the list alive
That is disgraceful. Here when people were let go they were at least treated properly, given good packages (over and above what was legally required), and the services of a careers counciller to help them prepare their cv, brush up on interview techniques contact reqruitement agencies etc. Even if they were pissed at being out of a job, they had no complaints as to how the company treated them. Steven H. -Original Message- McDonald Sent: 03 September 2001 18:25 To: Multiple recipients of list ORACLE-L Time to chip in my horror story (and why I'll never do permie again). Company in OZ decided to cut down numbers. Bosses walked around with security guards into each persons office and tell them they have 5 minutes to leave to premises and give them a ticket which has a 15minute after-hours timeslot in which they will have a supervised cleanout of their desk/office etc. They were marched down the lift and out into the street. I only knew this because the girl that gave me a lift to work phoned me from home and said sorry, can't take you home, my job is gone So - if you ever get a chance to work for BHP in Australia :-( Cheers Connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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: SEMAPHORES AND ORACLE
Veronica, Oracle on AIX doesn't use semaphores, as AIX has it's own post-wait driver and Oracle doesn't need it's own, hence no semaphores. Details: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=15566.1 Any other errors, stuff in the alert.log, etc? Jared On Monday 03 September 2001 10:55, Veronica Levin wrote: Hi listers, AIX 4.3.3.0, Oracle 8.1.7 I have been recieving ORA-01041on some clients with Hostdef extension doesn't exist I searched Metalink looking for some answers and all the info points to semaphores configuration vrs oracle processes. Oracle processes is set to 500, but I don't know where to look at semaphores parameters. I found some info that says I should look at SEMMNS kernel parameter, but can't find where and how to look for it. I will appreciate any info on this topic, thanks! Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- 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-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).
PL/SQL HEXTONUMBER
Dear lists ! Does anyone have a PL/SQL procedure converting a hexadecimal value to a decimal one , please ? Thanks a lot in advance ! DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -- 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).
Re: PL/SQL HEXTONUMBER
http://www.jlcomp.demon.co.uk/faq/base_convert.html --- Andrey Bronfin [EMAIL PROTECTED] wrote: Dear lists ! Does anyone have a PL/SQL procedure converting a hexadecimal value to a decimal one , please ? Thanks a lot in advance ! DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -- 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
Calling C++ component from PL/SQL
Hi all, I have requirement of calling C++ component from PL/SQL. What should I do for this? For calling Java Class we have to first run initjvm.sql to load dbms_java packagae and then publish Java class. Then after we can call java class as function in PL/SQL. Similarly what are the steps for calling C++ component from PL/SQL. Any help will be highly appriciated. Thanks, Bhamini _ 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: Bhamini Desaic 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 remove the old service of Oracle from win2k
WinterSun Zhao wrote: Hi, Experts: After I tried with difference listener name in Win2K, it generated some services. Something like: OracleTNSListener80, OracleTNSListener80list804, OracleTNSListener80List805 and so on. They were generated automatically each time I start the listener with a new listener name. But how can I remove them? Thanks. B.R. Before removing services (or performing any sort of operations on the registry) I would highly recommend exporting the registry with regedit.exe. It could mean the difference between a restore/re-install of the OS vs. just importing the previous version of the registry. That's about 3 hours of downtime. repentantly yours, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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: Smallest possible instance.
Mark Leith wrote: Hello all, Does anybody know the smallest possible size (SGA etc.) that an instance can be, and still run and accept connections? We have a test laptop that will be running Oracle 8.1.7, along with some of our tools against it, so the instances only need to accept around 2-3 connections.. If you have a sample init file or something like that also, that would be great.. Cheers Mark Mark, I had 8.1.7.0.2 running on a laptop (W2K Pro) with only 80 MB of RAM. I think that the SGA was around 48 MB total, with only 8 MB set aside for db_block_buffers. Are you using Java? You can reclaim 20 MB by not using the default settings for java_pool_size. I'd try to disable as many operating system services as you can - or at least set them to manual, so that they don't acquire resources at boot time. I'd also create the database elsewhere (on a machine with more horsepower) and move it over to the laptop. hth, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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: Datawarehouse suggestions?
ÌÌÌ X-Declude-Sender: [EMAIL PROTECTED] [63.26.83.129] X-Declude-Spoolname: Deec20e6.SMD X-Note: This E-mail was sent from 1cust129.tnt1.circleville.oh.da.uu.net. ([63.26.83.129]). X-Note: Please send abuse reports to [EMAIL PROTECTED] I wish i could its my stupid dialup and i've already notified them, some jerk on their end rewrites headers and the a$$hole puts the headers in the body, i've already put them on notice, if they dont get it changed i'll take my money elsewhere. Sorry everyone. joe Rajesh Dayal wrote: Joe, This is just a humble suggestion We would be obliged if you could remove all LLL's from your mail. With so many of these, your mail doesn't fit into preview pane and not to mention, wastage of bandwidth, space etc. Hope you won't disappoint Rajesh Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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: !! Keeping the list alive
I went through several major cuts when I worked at Citibank. The first one was the one best handled... by the time anyone was told about it, it was if you are here listening to me, you are NOT one of the ones let go Worst was when we knew how many would be let go... and knew that they had let go one less than that number... and there was one person out on vacation. And they didn't catch him at the door. That was awkward to say the least From: Kimberly Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: !! Keeping the list alive Date: Mon, 03 Sep 2001 08:20:27 -0800 Man, I remember the day when there were about 60 IT staff here. Now, I believe its under 20 or will be very shortly. It was a tough week here last week. We had to match what our client was letting go so we did that no problem. Pretty much everyone is off to another project from us. But to come in every morning and see the Fujitsu HR department catching people at the door before going into the Fab to give them their walking papers was tough. Its the first place I have worked at that has gone through that (while I was there). I believe some upper management will get their papers this week. -Original Message- Sent: Saturday, September 01, 2001 9:05 PM To: Multiple recipients of list ORACLE-L if 40 is small, is 16 microscopic? (and of that 16, 5 are consultants) From: Jared Still [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: !! Keeping the list alive Date: Sat, 01 Sep 2001 12:35:23 -0800 Just to add to my previous comment: I'm working at a company with small ( 40 or so ) IS shop. The weak do not survive in this environment. The developers I work with here are great. They're bright, hard working and un-egotistical. They are even will to take direction from the DBA in database related matters. Not a duhveloper in the bunch. Ya gotta love it! Jared On Thursday 30 August 2001 14:16, you wrote: Um, Kevin, if the shoe doesn't fit, then don't wear it. :) Not all developers are duhvelopers, in fact, most of the ones I know are very good, but the ones that are duhvelopers require so much attention that it kind of wears on you. :) And some of us DB-ehs can do just fine writing apps, thank you, but we choose a path that requires less 'direction' from users. ;) Jared Thomas, Kevin Kevin.Thomas@cal To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] anais.com cc: Sent by:Subject: RE: !! Keeping the list alive [EMAIL PROTECTED] 08/30/01 08:26 AM Please respond to ORACLE-L I have to say I resent being called a duhveloper, granted the majority couldn't tune a banjo let alone tune a piece of SQL, but as a techie (and we all are), I find this list invaluable for getting advice on a wide range of topics, not just keeping a DB up and running or tuned...I don't call you guys names, and let's face it you DB-ehs? couldn't write a decent application if your lives depended on it... (blue touch-paper lit, retire a distance, do not re-approach once lit, and wait for fireworks) hit any user to continue __ 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: 30 August 2001 15:46 To: Multiple recipients of list ORACLE-L no, those posts keep us underworked DBAs from killing the duhvelopers who make us do the same thing over and over and over and who never listen when we tell them the correct way to design the tables. :) From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: !! Keeping the list alive Date: Thu, 30 Aug 2001 04:00:52 -0800 Just look at the number of OT postings in the last couple of months... : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 7:58 PM To: Multiple recipients of list ORACLE-L
Re: Standby database
On Mon, Sep 03, 2001 at 08:45:24AM -0800, [EMAIL PROTECTED] wrote: Hi All, I'm resaerching standby database on 8.0.5 here and have a question. Setting up the standby database is quite well documented, but how to configure the clients in such a way that they will first try the primary site and if that's not responding try the standby site. Oracle documentation did not give me satisfactory result. -- I don't think you want to do what you are saying. For standby environment you would need to have some manual intervention at the prod failure (well, I guess you could script it, but I wouldn't). What I'd do is configure the old prod host ip address on the new prod host (the old standby that has been activated). That way you don't have to mess with a dns restart. You may need to clear some arp caches in some layer 2 3 network elements along the way, however. As an alternative, you could move the dns pointer record for the db from the old prod host dns entry to the old standby entry, which isn't a standby anymore, it is the new prod host. Whichever is easier. === 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).
RE: Duhvelopers and DB-ehs?
yup I did... and I also have a friend who has had tons of trouble setting up mail via utl_smtp it's definitely a way to go though. it won't monitor things like disk space in the OS and you have to configure it and then set up the job in EACH db, instead of running through a list of databases in a single shell script. I tend to like doing things once :) From: Thomas, Kevin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Mon, 03 Sep 2001 09:40:38 -0800 Yea, I've got the 'running the unix shell script' part down...did you see the mails someone sent re: utl_smtp?? hit any user to continue __ 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: 03 September 2001 17:35 To: Multiple recipients of list ORACLE-L well, we don't send it out of pl/sql directly, we run shell scripts that run the sql, then use shell to check the results and if it meets the send a message criteria, we use mail or mailx to send it. you can use pipes to call unix shell programs though From: Thomas, Kevin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Mon, 03 Sep 2001 01:40:35 -0800 OOooh, that's something I want to be able to do is to send email to us in case of problems...I can send email from OraForms using Outlook but I've not got round to checking out how I send email from a Unix box via pl/sql or the likesany suggestions? K. hit any user to continue __ 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: 31 August 2001 17:38 To: Multiple recipients of list ORACLE-L we have homegrown shell scripts -- page us, email us, send daily status of the world reports... works! From: Thomas, Kevin [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 05:47:12 -0800 Database monitoring toolsthrrp! We wrote our own using Java and lots of SQL are shell scripts...patchy but it works ;-) __ 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: 31 August 2001 14:17 To: Multiple recipients of list ORACLE-L I've got 11 databases (and just found out I'll probably have a new one, a semi, sort of, kind of data warehouse -- I need those books!) and there is me, my junior DBA who is not so junior anymore, and one consultant. And my CTO thinks that the DBAs are really just extra programming resources. So half the time we are doing non-DBA work. Oh yeah, and we don't have any of those high-falutin' database monitoring tools either :) From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Duhvelopers and DB-ehs? Date: Fri, 31 Aug 2001 02:55:26 -0800 Bloody Hell, we have half that amount of systems yet only two DBAs. What on earth do they do with the rest of their time. -Original Message- Sent: 31 August 2001 09:40 To: Multiple recipients of list ORACLE-L LOL...with 31 systems to support 24/7/365 if you threw a stone in any direction you would hit a DBA. At the last count I believe we had 12...!! __ 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: 30 August 2001 17:22 To: Multiple recipients of list ORACLE-L Sounds like your company is looking for a new DBA? :- Jan Pruner Dne ?t 30. srpen 2001 17:26 jste napsal(a): I have to say I resent being called a duhveloper, granted the majority couldn't tune a banjo let alone tune a piece of SQL, but as a techie (and we all are), I find this list invaluable for getting advice on a wide range of topics, not just keeping a DB up and running or tuned...I don't call you guys names, and let's face it you DB-ehs? couldn't write a decent application if your lives depended on it... (blue touch-paper lit, retire a distance, do not re-approach once lit, and wait for fireworks) hit any user to continue
RE: OT RE: database consistency tools ?
well, the only announcements we ever hear are the monthly test of the fire alarms that seem to go off twice a week. From: Kimberly Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT RE: database consistency tools ? Date: Mon, 03 Sep 2001 08:05:20 -0800 Um, headphones? I would die to be able to play music at work. For some reasons safety won't let us. They claim its because then we can't hear the overheads. Damn, I can't remember the last time I was able to make one out anyway -Original Message- Sent: Friday, August 31, 2001 4:46 PM To: Multiple recipients of list ORACLE-L not where I work, everyone has their personal stereo (company provided, we are a music site, in part) cranked up way too high. Interesting sounds when you combine hip-hop, heavy metal and classic rock From: Koivu, Lisa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT RE: database consistency tools ? Date: Fri, 31 Aug 2001 12:20:29 -0800 If the DBA screams bloody murder and loses his or her mind, does anybody hear? -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Friday, August 31, 2001 3:07 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT RE: database consistency tools ? Yea yea yeait's like If God is All Powerful, can He make a rock so heavy even He can't pick it up? -Original Message- Sent: Friday, August 31, 2001 2:21 PM To: Multiple recipients of list ORACLE-L SHE dares to say she ain't no goddess. From: Mohan, Ross [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT RE: database consistency tools ? Date: Fri, 31 Aug 2001 08:47:15 -0800 NoRachel is God(dess). Dare anyway say She Know Less? EG -Original Message- Sent: Friday, August 31, 2001 12:23 PM To: Multiple recipients of list ORACLE-L you all really have an overinflated idea of my knowledge base. sheesh! From: Robertson Lee - lerobe [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: database consistency tools ? Date: Fri, 31 Aug 2001 05:27:31 -0800 Me too, plus Informix (plus DB26000 for about 2 months) although as with Oracle Rachel has probably forgotten more than I know :-) Lee -Original Message- Sent: 31 August 2001 10:35 To: Multiple recipients of list ORACLE-L oh brother, here we go again. Do I dare tell you I was an Ingres DBA too? :) From: Joe Testa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: database consistency tools ? Date: Thu, 30 Aug 2001 18:05:29 -0800 Rachel, you were a sybase DBA, the goddess notches another one on her belt. joe Rachel Carmichael wrote: Jared, having been a sybase dba (I know, forgive me for straying)... we ran dbcc a lot. Oracle equivalent (poor equivalent) would be analyze table validate structure maybe? Rachel SNIP -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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
Re: Standby database
Well, you can configure the tnsnames.ora to check multiple listeners, so you do that... the first listener/port you check is the primary, the second is the standby From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Standby database Date: Mon, 03 Sep 2001 08:45:24 -0800 Hi All, I'm resaerching standby database on 8.0.5 here and have a question. Setting up the standby database is quite well documented, but how to configure the clients in such a way that they will first try the primary site and if that's not responding try the standby site. Oracle documentation did not give me satisfactory result. 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: 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-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-600/ora07445
ÌÌÌ X-Declude-Sender: [EMAIL PROTECTED] [63.26.83.243] X-Declude-Spoolname: D1f8e13e.SMD X-Note: This E-mail was sent from 1cust243.tnt1.circleville.oh.da.uu.net. ([63.26.83.243]). X-Note: Please send abuse reports to [EMAIL PROTECTED] usually 600/7445 errors need called into support, that would be the 1st thing i'd do. joe Seema Singh wrote: Hi I have oracle8.1.7 on Solaris 2.7. I am getting following error message in my alert log. ORA-07445: exception encountered: core dump [dredseek()+388] [SIGSEGV] [Address not mapped to object] [97552987] [] [] and ORA-00600: internal error code, arguments: [12700], [80087], [121694549], [23], [], [], [], [] What could be reason?Please suggest. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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).
gzip'ing rman backups
Hi folks, I want to gzip up my rman backups, which are to disk. I do a full at the weekend, and archive logs daily. I know that rman cant cope with zipped files, and I will have to unzip them myself before attempting a restore. My question is - does rman ever check existing backup files - will it look for the last full backup before backing up todays archive logs etc - or once backed up, does it ignore backup files until I ask for a restore? My databases's are OLTP, with a datafile | tablespace containing each days partitions. Apart from system, rbs there are only transaction tablespaces (one per day) in the database. Assuming I can switch each transaction table to read only at end of day, back it up as a datafile using rman, and back up rbs system, then I can can discard all archive logs for that day - right? So a typical scenario will have 14 datafiles backed up (the DB keeps 2 weeks data), each with RBS system from that day, and archivelogs for the last day only for PIT recovery. Im about to spend a few days testing this out - anyone know if it will work/fail? Thanks Mark Teehan Singapore. ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Teehan 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: How to remove the old service of Oracle from win2k
Hi, Bardeen: Thank you for your help. Because I had set my default Oracle_home pointed to the home of oracle8.1.7, so I removed the services of Oracle8 failed. With your help, I set the oracle_home to the home of Oracle8 and then I used oradim80 and I can remove the services I didnot need. Thank you very much! Wintersun Zhao [EMAIL PROTECTED] A sneaky little trick on 8.0.6 and below is to use oradim to remove the service. ORADIMxx -DELETE -SRVC service_name where ORADIMxx is oradim73 or oradim80 service_name is the name of the service to be deleted (it is not case sensitive) Be very careful as you can use this to delete non-Oracle services as well, so use at your own risk! They fixed oradim in 8i and above so that it can be used to delete only services named oracleservicesid HTH, -- Anita --- WinterSun Zhao [EMAIL PROTECTED] wrote: Hi, Experts: After I tried with difference listener name in Win2K, it generated some services. Something like: OracleTNSListener80, OracleTNSListener80list804, OracleTNSListener80List805 and so on. They were generated automatically each time I start the listener with a new listener name. But how can I remove them? Thanks. B.R. __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com --- ÍæתÒÂʳסÐÐÒ»Ìõ½Ö http://adinfo.21cn.com 21CN¶ÌÐÅÏëµã¾Íµã http://www.21cn.com/21cnhtm/duanxin/index.html ×ã²»³ö»§£¬ÏíÊÜרҵÓÊÏä·þÎñ http://www.21cn.net/extend/gb/Charge.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: WinterSun Zha 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: How to remove the old service of Oracle from win2k
Hi, Bardeen: Thank you for your help. Because I had set my default Oracle_home pointed to the home of oracle8.1.7, so I removed the services of Oracle8 failed. With your help, I set the oracle_home to the home of Oracle8 and then I used oradim80 and I can remove the services I didnot need. Thank you very much! Wintersun Zhao [EMAIL PROTECTED] A sneaky little trick on 8.0.6 and below is to use oradim to remove the service. ORADIMxx -DELETE -SRVC service_name where ORADIMxx is oradim73 or oradim80 service_name is the name of the service to be deleted (it is not case sensitive) Be very careful as you can use this to delete non-Oracle services as well, so use at your own risk! They fixed oradim in 8i and above so that it can be used to delete only services named oracleservicesid HTH, -- Anita --- WinterSun Zhao [EMAIL PROTECTED] wrote: Hi, Experts: After I tried with difference listener name in Win2K, it generated some services. Something like: OracleTNSListener80, OracleTNSListener80list804, OracleTNSListener80List805 and so on. They were generated automatically each time I start the listener with a new listener name. But how can I remove them? Thanks. B.R. __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com --- ÍæתÒÂʳסÐÐÒ»Ìõ½Ö http://adinfo.21cn.com 21CN¶ÌÐÅÏëµã¾Íµã http://www.21cn.com/21cnhtm/duanxin/index.html ×ã²»³ö»§£¬ÏíÊÜרҵÓÊÏä·þÎñ http://www.21cn.net/extend/gb/Charge.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: WinterSun Zha 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: How to remove the old service of Oracle from win2k
Hi, Paul: Thank you for your help. The problem had been solved with the help of A. Bardeen ([EMAIL PROTECTED]). Thank you. WinterSun Zhao wrote: Hi, Experts: After I tried with difference listener name in Win2K, it generated some services. Something like: OracleTNSListener80, OracleTNSListener80list804, OracleTNSListener80List805 and so on. They were generated automatically each time I start the listener with a new listener name. But how can I remove them? Thanks. B.R. Before removing services (or performing any sort of operations on the registry) I would highly recommend exporting the registry with regedit.exe. It could mean the difference between a restore/re-install of the OS vs. just importing the previous version of the registry. That's about 3 hours of downtime. repentantly yours, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake 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). --- ÍæתÒÂʳסÐÐÒ»Ìõ½Ö http://adinfo.21cn.com 21CN¶ÌÐÅÏëµã¾Íµã http://www.21cn.com/21cnhtm/duanxin/index.html ×ã²»³ö»§£¬ÏíÊÜרҵÓÊÏä·þÎñ http://www.21cn.net/extend/gb/Charge.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: WinterSun Zha 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: SEMAPHORES AND ORACLE
If you're on 8.1.7.0.0 it may be a bug. Apply the latest patch. [EMAIL PROTECTED] 09/03/01 16:10 PM Veronica, Oracle on AIX doesn't use semaphores, as AIX has it's own post-wait driver and Oracle doesn't need it's own, hence no semaphores. Details: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=15566.1 Any other errors, stuff in the alert.log, etc? Jared On Monday 03 September 2001 10:55, Veronica Levin wrote: Hi listers, AIX 4.3.3.0, Oracle 8.1.7 I have been recieving ORA-01041on some clients with Hostdef extension doesn't exist I searched Metalink looking for some answers and all the info points to semaphores configuration vrs oracle processes. Oracle processes is set to 500, but I don't know where to look at semaphores parameters. I found some info that says I should look at SEMMNS kernel parameter, but can't find where and how to look for it. I will appreciate any info on this topic, thanks! Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- 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-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 commandfor other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mario Alberto Ramos Arellano 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: gzip'ing rman backups
hi mark, does rman ever check existing backup files - will it look for the last full backup before backing up todays archive logs etc RMAN simply backs up whatever u ask it to back up (db/tblspace, etc) .. it does not do any sanity checks.. note that it records all entries for succesfull backups in the catalog db ( most of it in the target control file also) back it up as a datafile using rman, and back up rbs system, then I can can discard all archive logs for that day - right? after every full db backup, u no longer need the archives. but folks still kep em to ensure that in case restore using current full backup fails, then they could restore using the not current full db backup. ur method will work assuming that all other tablespaces other than ur transaction tablespaces do not change and are static .. so u will be able to restore 100% even if u deleted ur archives at the end of the day. (its a risky approach all the same .. i feel) hth deepak --- Mark Teehan [EMAIL PROTECTED] wrote: Hi folks, I want to gzip up my rman backups, which are to disk. I do a full at the weekend, and archive logs daily. I know that rman cant cope with zipped files, and I will have to unzip them myself before attempting a restore. My question is - does rman ever check existing backup files - will it look for the last full backup before backing up todays archive logs etc - or once backed up, does it ignore backup files until I ask for a restore? My databases's are OLTP, with a datafile | tablespace containing each days partitions. Apart from system, rbs there are only transaction tablespaces (one per day) in the database. Assuming I can switch each transaction table to read only at end of day, back it up as a datafile using rman, and back up rbs system, then I can can discard all archive logs for that day - right? So a typical scenario will have 14 datafiles backed up (the DB keeps 2 weeks data), each with RBS system from that day, and archivelogs for the last day only for PIT recovery. Im about to spend a few days testing this out - anyone know if it will work/fail? Thanks Mark Teehan Singapore. ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Teehan 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 email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.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).
Re: ergent help: ora-27091 on system tablespace
hi, bardeen: Thanks for your reply. The database has a valid backup, and after the backup, no further operation is done.So, what i shall do is only to restore that full backup and it is OK. Now i wantto know why this happen, and if the disk is error itself.For Oracle doesnot know it: without any relevant message in alert file. thank u very much. --- A. Bardeen [EMAIL PROTECTED] µÄÕýÎÄ£º Corruption in the system datafile takes special handling so if you haven't already done so I highly recommend logging a tar with support. If you are unable to even cp or dd the file then you most likely have a problem with the file at the OS level and you need to get that issue resolved. As to your recovery situations, it depends on when your last backup was taken and if the db is in archivelog mode. The best method if the db is in archivelog mode is to identify a backup containing a clean version of the datafile (i.e. one in which dbv doesn't report any errors), restore that datafile from backup, and recover it. Since this is a datafile belonging to the system tablespace you will need to shutdown the db and do this from a mount stage. I would highly recommend doing a full db export for safekeeping in the event that there are any problems with your backups. HTH, -- Anita --- chao zhu [EMAIL PROTECTED] wrote: hi, gurus: when i do a fulldatabase export, oracle error 27091 appeard: . . exporting table MHNK EXP-8: ORACLE error 1115 encountered ORA-01115: IO error reading block from file 1 (block # 13095) ORA-01110: data file 1: '/oracle/DEV/sapdata1/system_1/system.data1' ORA-27091: skgfqio: unable to queue I/O IBM AIX RISC System/6000 Error: 5: I/O error Additional information: 13094 . exporting table MHNKA EXP-8: ORACLE error 1115 encountered ORA-01115: IO error reading block from file 1 (block # 13095) ORA-01110: data file 1: '/oracle/DEV/sapdata1/system_1/system.data1' ORA-27091: skgfqio: unable to queue I/O IBM AIX RISC System/6000 Error: 5: I/O error Additional information: 13094 i checked the table, no record. and no such 27091 message in alertsid.log. i checked dba_extents, with block_id between 13094 and 13096, the table is a SAPR3 table:agr_1250? isn't a system table! i run dbverify and it reported error message: DEV_SVC:oradev 13 dbv file=system.data1 blocksize=8192 DBVERIFY: Release 8.1.7.0.0 - Production on Sun Sep 2 16:49:10 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. DBVERIFY - Verification starting : FILE = system.data1 DBV-00102: File I/O error on FILE (system.data1) during verification read operation (-2) so, it seems the datafile has corrupted, and i do not know when it corrupted. Shall i just recreate the tables affected, or restore the database. If restore, when to begin? I do not know when it corrupted, since no error message in alertsid.log? And now i cannot backup the corrupted datafile, neither through cp or dd.It always abort at the middle of the datafile. thanks. _ Do You Yahoo!? ???â??! http://mail.yahoo.com.cn font color=#FF?D???Ã??û-?4D/font ?D??! http://cn.chat.yahoo.com/c/roomlist.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?gb2312?q?chao=20zhu?= 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 email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com _ Do You Yahoo!? µÇ¼Ãâ·ÑÑÅ»¢µçÓÊ! http://mail.yahoo.com.cn font color=#FFÎÞÁÄ£¿ÓôÃÆ£¿¸ßÐË£¿Ã»ÀíÓÉ£¿¶¼À´ÁÄÌì°É£¡/font¡ª¡ª ÑÅ»¢È«ÐÂÁÄÌìÊÒ! http://cn.chat.yahoo.com/c/roomlist.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?gb2312?q?chao=20zhu?= 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
RE: !! Keeping the list alive
someties i think life sucks .. screw oracle and 9i .. give me some nice vacation time here .. i need a break ;) .. like most of ya'll in the list enjoy deepak --- Steven Hovington [EMAIL PROTECTED] wrote: That is disgraceful. Here when people were let go they were at least treated properly, given good packages (over and above what was legally required), and the services of a careers counciller to help them prepare their cv, brush up on interview techniques contact reqruitement agencies etc. Even if they were pissed at being out of a job, they had no complaints as to how the company treated them. Steven H. -Original Message- McDonald Sent: 03 September 2001 18:25 To: Multiple recipients of list ORACLE-L Time to chip in my horror story (and why I'll never do permie again). Company in OZ decided to cut down numbers. Bosses walked around with security guards into each persons office and tell them they have 5 minutes to leave to premises and give them a ticket which has a 15minute after-hours timeslot in which they will have a supervised cleanout of their desk/office etc. They were marched down the lift and out into the street. I only knew this because the girl that gave me a lift to work phoned me from home and said sorry, can't take you home, my job is gone So - if you ever get a chance to work for BHP in Australia :-( Cheers Connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Hovington 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 email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.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).