RE: Client-server Forms6i against Oracle 9i (9.2.0.4) database?
encoded content removed -- binaries not allowed by ListGuru The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. winmail.dat
RE: 9iAS v 1.0.2.2.0 Installation Problem
I remember the command window that opens and doesn't do anything. closing it manually is what I was told so the install can continue. I think their were also some places where it opened windows behind the installer, minimize the installer or check the task bar. *** Brian L. Anderson SA/DBA Darton College [EMAIL PROTECTED] --- spamtrap: [EMAIL PROTECTED] -Original Message- From: Luis deUrioste [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Subject: 9iAS v 1.0.2.2.0 Installation Problem We are trying to install 9iAS 1.0.2.2.0 on a Dell Poweredge 2650 / P4 2Gig, we have succesfully installed this software in older model machines. When we try to run the installer from the distribuition media we get an error that the installer did not run because it was probably aborted and to run setup again. We bypassed this by downloading the OUI 2.8.18.2 (installer 2.2) and that way we were able to run the installation. Everything seems to run fine until we get towards the end a CMD windows is display and it hangs, we closed it manually. Then a new CMD window is displayed and some script flashes trhough, after this the installation gets to 99% and it hangs. The installer shows that is installing a .gif file and it stays there. Can somebody shed some light on me, and prompt me on a solution path? I spent hours serching through Metalink and havn't found anything that helped. I submitted a TAR, but you guys know it may take a while and I'm pressed for time. T.I.A.. Luis Octavio de Urioste Systems Analyst PH. (850) 454.2943 e-mail: [EMAIL PROTECTED] Vertex Aerospace LLC -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luis deUrioste INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Congratulations Arup (DBA of the Year)
related the method of milking a nanny goat who has mastitis (yes, carefully and gently for starters, watch the horns...) :-) Is this going to be a session at Hotsos or OracleWorld? ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hey Jared
Come on, be fair, M$ is not that unstable/insecure. It's all the 3rd party products, how do you expect them to be stable/secure with all the unknown applications people install. Windows would be a wonderful OS, if people would just quit installing applications. Solitaire runs. ;) -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 4:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: Hey Jared Security hole with M$? That would definitely the 1st one! I mean, it's not like the security holes are regular thing with M$. M$ operating systems are known as rock solid and completely secure products. Fox news are fair and balanced. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: date checking ???
From a sql perspective, you want to trunc(now), to get rid of the time. As for how to do this in java, I don't know. -Original Message- From: Andrea Oracle [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 6:49 PM To: Multiple recipients of list ORACLE-L Subject: date checking ??? Hi all, May I ask a javascript question?? (sorry to post here!) below is a form checking input date. The input date cann't be earlier than today. But it also compares hours and minutes which I don't want. Suppose you input 08/20/2003, it thinks it's 08/20/2003 00:00:00 which is earlier than now (08/20/2003 15:30:00). How to solve this?? Thank you! html head script function validate(){ var obj = document.forms(shipping); //$$ sending date cannot be earlier than today now = new Date(); sDate = obj.p_sending_date.value; sDate = sDate.substring(0,2) + / + sDate.substring(3,5) + / + sDate.substring(6,10); inputDate = new Date(sDate); if (inputDate now) { alert(Sending date cannot be earlier than today.); }else{ alert(ok); } } /script /head body form name=shipping input type=text name=p_sending_date input type=submit value=submit onClick=validate(); /form /body /html __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to tell Oracle the directories of script files
Keep in mind that, unless they've changed the function, spool also searches the sqlpath for files. If you say: spool modify_users.sql select 'alter user '||username||'whatever;' from dba_users; spool off Spool just looked in your current directory for a file named modify_users.sql to replace, then it followed your sqlpath for a file to replace (file permissions allowing), if it doesn't find one then it creates one in your current directory. -Original Message- From: Stephen Andert [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 2:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: How to tell Oracle the directories of script files export SQLPATH=/usr/users/oracle/dba/scripts:/app/oracle/admin before you run SQL*Plus HTH Stephen [EMAIL PROTECTED] 08/14/03 11:09AM Hello, Suppose I have some SQL scripts in my /home/user directories, /usr/local/bin directories, etc. If I start 'sqlplus' from console in /home/user directories, I can load/execute the script by doing: SQL @scriptname But what if I don't start sqlplus from that directories? How do I tell Oracle to find the scripts in /home/user, then if it's not there in /usr/local/bin, for example? So that I can be anywhere in the filesystem when starting sqlplus and can execute my SQL script. Just like the $PATH environment variables in *nix system that tell the shell where to find executables, is there a similar thing for Oracle? Thanks for any help. RDB -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - /\ ASCII Ribbon Campaign against HTML \ / email and proprietary format X attachments. / \ - Have you been used by Microsoft today? Choose your life. Choose freedom. Choose LINUX. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dba age
I claim 36, making me the youngest DBA here. Of course, myself is the oldest DBA here at 36. And I is the average of our ages. Me, myself, and I work pretty well together, if you ignore all the arguments. -Original Message- From: Freeman Robert - IL [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: dba age Well I *AM* 37, and I don't feel old. I'm actually the youngest DBA in my group, and it seems like I'm always the youngest wherever I go... Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 7/23/2003 12:14 PM King Arthur: Old woman! Dennis: Man. KA: Sorry. Old man! Whose castle is that? D: I'm 37! KA: What? D: I'm 37, I'm not old! KA: Well, I can't just call you 'man'. D: Well, you could say 'Dennis'. KA: I didn't know you were called Dennis. D: You never bothered to find out, did you? At least I'm only on the cusp of 35. And I have 6 years experience with Oracle. I've lost whole databases, even, thanks to WindohsNoT running Oracle7. My experience tells me not to put Oracle on Windohs. YMMV. I've experienced upgrades, patches, and migrations -- oh my! I've experienced the joy that isn't OiD 9.0.2. I've experienced a developer who could have sworn he was in the test DB. I've experienced successful recovery with zero data loss and no downtime during core business hours. I've experienced AutoRAID. I've experienced BAARF. I've experienced Intel, Alpha, SPARC, and PA-RISC. Duhvelopers have experienced my wrath. I have experienced my own wrath during moments of Duh. I've experienced this list, with it's many helpful and some not so helpful members. And yet, there's so much I haven't experienced. Like lunch today. Standing in for Paul Harvey, I'm Rich Jesse. Good Day! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HP-UX 11i/9.2.0.3/Strange Executions
, :A94 , :A95 , :A96 , :A97 , :A98 , :A99 , :A100 , :A101 , :A102 , :A103 , :A104 , :A105 , :A106 , :A107 , :A108 , :A109 , :A110 , :A111 , :A112 , :A113 , :A114 , :A115 , :A116 , :A117 , :A118 , :A119 , :A120 , :A121 , :A122 , :A123 , :A124 , :A 125 , :A126 , :A127 , :A128 , :A129 , :A130 , :A131 , :A132 , :A133 , :A134 , :A135 , :A136 , :A137 , :A138 , :A139 , :A140 , :A141 , :A142 , :A143 , :A144 , :A145 , :A146 , :A147 , :A148 , :A149 , :A150 , :A151 , :A152 , :A153 , :A154 , :A155 , :A156 , :A157 , :A158 , :A159 , :A160 , :A161 , :A162 , :A163 , :A164 , :A165 , :A166 , :A167 , :A168 , :A169 , :A170 , :A171 , :A172 , :A173 , :A174 , :A175 , :A176 , :A177 , :A178 , :A179 , :A1 80 , :A181 , :A182 , :A183 , :A184 , :A185 , :A186 , :A187 , :A188 , :A189 , :A190 , :A191 , :A192 , :A193 , :A194 , :A195 , :A196 , :A197 , :A198 , :A199 , :A200 , :A201 , :A202 , :A203 , :A204 , :A205 , :A206 , :A207 , :A208 , :A209 , :A210 , :A211 , :A212 , :A213 , :A214 , :A215 , :A216 , : A217 , :A218 , :A219 , :A220 , :A221 , :A222 , :A223 , :A224 , :A225 , :A226 , :A227 , :A228 , :A229 , :A230 , :A231 , :A232 , :A233 , :A234 , :A23 5 , :A236 , :A237 , :A238 , :A239 , :A240 , :A241 , :A242 , :A243 , :A244 , :A245 , :A246 , :A247 , :A248 , :A249 , :A250 , :A251 , :A252 , :A253 , :A254 , :A255 , :A256 , :A257 , :A258 , :A259 , :A260 , :A261 ) ) AND T_01 . SPRAS = :A262 - Call Stack Trace - --- == = Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MySQL in the future?
you are better served by our commercial license is not necessarily the same as: you must buy our commercial license. Either way, if you want to verify the license needs for your specific situation, contact the company. -Original Message- From: Jacques Kilchoer [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2003 6:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: MySQL in the future? It seems (almost) clear to me from the text at http://www.mysql.com/products/licensing.html This is our licensing policy in brief: Our software is 100% GPL, and if yours is also 100% GPL (or OSI compliant), then you never have to pay us for the licences. In all other instances, you are better served by our commercial licence. If your application is 100% GPL (Gnu Public License) then you can use mySQL for free. If your application is NOT 100% GPL then you can use mySQL but you have to pay for it. -Original Message- From: Richard Ji [mailto:[EMAIL PROTECTED] What? Are you sure? My understanding is if I make changes to MySql code or some addon to MySql I need to submit my changes bakc to public and GPL. That what the whole dispute between MySQL the company and the community before, right? But my application too? For just using it? What about all those sites -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 10i
They have but it's an added feature, and you thought the current license was expensive. -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 4:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: 10i I thought the database was going to manage itself! Now I'm disappointed, I thought they were going to implement just one nice big GUI button that does everything. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: make utility in Solaris 8
Check SUNWsprot and SUNWbtool, these were needed for a 9ias installation on a core solaris 8 install. -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 9:06 AM To: Multiple recipients of list ORACLE-L Subject: RE: make utility in Solaris 8 Ross - I'm far from a Solaris guru, but since I don't see where you received a reply, here goes. The Oracle install may fail because it can't complete the make process. This happens, and requires a fix. But what makes (no pun intended) you think the root cause is that the Solaris make utility was improperly installed? Now if you are coming from a Micro$oft background, that might be a reasonable reaction. ;-) Are you receiving some error messages during make? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 25, 2003 12:04 AM To: Multiple recipients of list ORACLE-L Env. Solaris 8 Oracle 817 My apologies for this OT posting. I know we have quite a lot of Solaris gurus here. It appears the make utility was not installed properly as the Oracle install keeps failing. Can anyone tell what the SUN package name where make is in? Apologies again. Rgds, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ross Collado INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Remove killed session from v$session
It should disappear eventually, it sometimes takes a while. Try the immediate clause next time, they don't usually hang around. alter system kill session 'sid,serial' immediate; -Original Message- From: Stefan Jahnke [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Subject: Remove killed session from v$session Hi list Is there any way to remove a killed session from v$session. Is it even necessary to do that ? I ran this: select spid, status, osuser, s.program from v$process p, v$session s where p.addr=s.paddr To check for the killed processes' spid in order to remove the thread (it's 9.2 on win2k) with orakill. But for the killed process, no process is shown. So, what's left ? Should I even bother or just wait till Oracle removes the killed session ? Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sun=/var/messages HP-UX=???
Actually /var/adm/messages on hpux is the message file, which my solaris 8(2.8) machine is also using /var/adm/messages, maybe I changed this, I don't remember. /var/adm/syslog/ is the default syslog directory equivalent to /var/log/ on solaris. -Original Message- From: Nelson, Allan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: Sun=/var/messages HP-UX=??? /var/adm/syslog/syslog.log is the hp-ux equivelant. -Original Message- Sent: Thursday, March 13, 2003 12:59 AM To: Multiple recipients of list ORACLE-L I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log files worth monitoring? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sun=/var/messages HP-UX=???
hpux 11.0 man dmesg shows the standard setup using /var/adm/messages. dmesg looks in a system buffer for recently printed diagnostic messages and prints them on the standard output. The messages are those printed by the system when unusual events occur (such as when system tables overflow or the system crashes). If the - argument is specified, dmesg computes (incrementally) the new messages since the last time it was run and places these on the standard output. This is typically used with cron (see cron(1)) to produce the error log /var/adm/messages by running the command: /usr/sbin/dmesg - /var/adm/messages every 10 minutes. The arguments core and system allow substitution for the defaults /dev/kmem and /stand/vmunix respectively, where core should be a file containing the image of the kernel virtual memory saved by the savecore(1M) command and system should be the corresponding kernel. If the system is booted with a kernel other than /stand/vmunix say /stand/vmunix_new, dmesg must be passed this name, the command must be, /usr/sbin/dmesg [-] /dev/kmem /stand/vmunix_new WARNINGS The system error message buffer is of small, finite size. dmesg is run only every few minutes, so there is no guarantee that all error messages will be logged. AUTHOR dmesg was developed by the University of California, Berkeley. FILES /var/adm/messageserror log (conventional location) /var/adm/msgbuf memory scratch file for - option /dev/kmemspecial file containing the image of kernel virtual memory /stand/vmunixthe kernel, system name list -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 3:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: Sun=/var/messages HP-UX=??? What version of HP-UX? Here is what I get on HP-UX 11.0: df2hp105 [IWHA]: ll /var/adm/me* /var/adm/me* not found - Kirti -Original Message- Sent: Friday, March 14, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Actually /var/adm/messages on hpux is the message file, which my solaris 8(2.8) machine is also using /var/adm/messages, maybe I changed this, I don't remember. /var/adm/syslog/ is the default syslog directory equivalent to /var/log/ on solaris. -Original Message- From: Nelson, Allan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Subject: RE: Sun=/var/messages HP-UX=??? /var/adm/syslog/syslog.log is the hp-ux equivelant. -Original Message- Sent: Thursday, March 13, 2003 12:59 AM To: Multiple recipients of list ORACLE-L I monitor /var/messages on my Sun boxes, does HP-UX have anytype of OS log files worth monitoring? Thanks, Ethan -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Send Mail in Unix
I use mutt which has the option to attach a file. mutt -s 'subject' -a filename user@mailserver /dev/null would send an attachment with no body, put a file instead of /dev/null if you want a body for the message. With mailx in unix, I've been told it can be done by piping through uuencode or something, but I haven't done that. I'm also sure it can be done with perl, some of the perl guru's on the list might be able to provide details. -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Subject: Send Mail in Unix All, I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun Unix box to myself when the batch job runs. Anybody been able to do this? I can send the text of the file, but what I really want to do is to send the file (it's an Excel Spreadsheet). thanks in advance. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: help set nomail
:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 9:52 AM To: Multiple recipients of list ORACLE-L Subject: help set nomail Hi All my machine has been rebuilt, with my outlook file lost, thus I do not have the mail that describes how to set my account not to receive mail until I say so. I sent a message to [EMAIL PROTECTED] with content : set nomail Oracle-L. This came back as an invalid list. Could someone please tell me how to set my account not to receive any mail, as I am preparing to fly to Dallas for the symposium, and have a few other errands to run before and after. TIA. Regards: Ferenc Mantfeld -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQLPlus Substitution Variables
Something like this, perhaps. accept var1 char prompt 'What grantee? '; select * from dba_sys_privs where grantee = upper('var1'); -Original Message- From: Erik Williams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Subject: SQLPlus Substitution Variables I am using substitution variables in SQLPlus, but don't want to be prompted for their values. I want to set them at the start of the script. Kind of like a preprocessor directive. Is this possible? Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i installation - Basic Qs
on the client pc: Right click exceed - tools - configuration - security - host access control list I use file: click edit and add the ip address to let the db server connect to the x-server on your pc. -Original Message- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 9:39 AM To: Multiple recipients of list ORACLE-L Subject: Oracle 9i installation - Basic Qs Oracle 9i installation on Solaris being attempted # xhost + Message - unable to open display : export DISPLAY=PC Client IP address:0.0 # xhost + Xlib : connection to client refused PC Client IP Address Xlib : cannot set display to PC Client IP Address NOTE - Installation being initiated from a laptop using Exceed Hummingbird software to simulate Xwindows Console Any Solutions ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: moving from dedicated connections to MTS
Doc: 125021.1 talks about firewalls. Look for USE_SHARED_SOCKET to keep the dedicated connections. -Original Message- From: Yechiel Adar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 11:24 AM To: Multiple recipients of list ORACLE-L Subject: moving from dedicated connections to MTS Hello all First a little background. We work with oracle 8.1.6.3.4 on NT or win2000 servers. The technical people have just move an application server behind a firewall. The application servers access a database that is a central repository of user connections (i.e. all applications on the intranet access this database for each page for each user). They saw that the application works fine for a while and then they get access denied. They track it down to the port numbers in the firewall. We are working with dedicated connections and it seems that the port numbers for each connections are climbing up until they exceeded the range of open ports in the firewall. They said that they had the same problems in another server, they brought an outside guy (of course without telling the DBA group) and he solved the problem. They brought me the init.ora file of that database (I can not access it via the firewall) and showed me the parameters that made the difference. The guy put in: mts_dispatchers= ... port=8000) (5 dispatchers). Since they want me to do it on a central and essential database I want to ask you guys: 1) Any gotcha moving from dedicated connections to MTS? 2) Is each dispatcher assigned for the current sql command and then released or is it assigned for the duration of the session? 3) What is the ratio of users per dispatcher? 4) Is there a way to tell oracle to reuse port numbers for dedicated connections that were closed? 5) Anything else you care to share. Sorry if my questions are somewhat trivial but we need a decision tomorrow morning (in 18 hours) as they start doing some training session on the system on Sunday and time is short. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: AW: Off Topic, slightly - Crystal Reports internal format
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: Anderson, Brian 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: Rename Oracle User
If you haven't already done this, the find's are unneeded. How about replacing 1,3,4 with: create dba group usermod -l oracle -g dba oracle2 Since the ownership's in UNIX are by UID, if the username is changed then all the files are now owned by the new username(same UID). shutdown BACKUP usermod update scripts startup -Original Message- From: Todd Carlson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 10:24 AM To: Multiple recipients of list ORACLE-L Subject: Rename Oracle User Solaris 5.8 Oracle 8.1.7.2 Has anyone successfully renamed the Oracle user on a solaris box? At the moment I don't a test box and this is a rarely used development system. The current Oracle user and group are oracle2 and dba2. We have to change it to match our standards, i.e. oracle dba. The plan is to (after a full system backup): 1) Create the correct local user group with the same home directory. 2) Shutdown all Oracle processes. 3) Find . -user oracle2 -exec chown oracle {} \; 4) Find . -user dba2 -exec chgrp dba {} \; 5) Modify all scripts to use the correct group user. 6) Pray. 7) Start the database and listener. 8) Check for functionality errors. 9) Shut everything down and take a full system backup. Am I missing anything? Is there any problems with the method? Thanks, Todd Carlson Oracle Database Administrator Tripos, Inc. (314) 647-8837 Ext.3246 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Todd Carlson 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: Anderson, Brian 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: lsnrctl - can I remove world executable privileges?
lsnrctl EOF set password pass start listener EOF -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 1:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: lsnrctl - can I remove world executable privileges? Thanks, I'll probably do this also now, after I change the permissions. How does one code a password into a script to stop and start the listener? Jay Miller -Original Message- Sent: Tuesday, November 20, 2001 11:30 AM To: Multiple recipients of list ORACLE-L Give the listener a password. -Original Message- Sent: Tuesday, November 20, 2001 7:56 AM To: Multiple recipients of list ORACLE-L Had a bit of a shock this morning. I never knew that the lsnrctl was -rwxr-x--x by default and a random unix user shut down the listener on our production database. Is there any reason not to change the privileges on this file, making it -rwxr-x---? Is there a reason it's set this way? This seems like a big security hole. Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith 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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: Intelligent Agent
I don't have 8.0.3 or Tru64 UNIX to look at, but on HPUX we have $ORACLE_HOME/network/lib in the SHLIB_PATH. Check if the library it is looking for is in $OH/network/lib, and try adding that to your env. I recently installed Compaq's Tru64 UNIX 5.1a on an Alpha 2100 server I had lying around. It is to be used for minimal software development with Oracle and general testing. I was able to get Oracle installed (8.0.3) without much of a hitch. The problem arose when I tried starting the listener (lsnrctl start). It gave the Fatal Error: Cannot map library libclntsh.so.1.0. I was able to fix the problem by resetting the LD_LIBRARY_PATH variable to include $ORACLE_HOME/lib and $ORACLE_HOME/obackup. After the change, the listener started up, and I was able to mount the database. My issue is with the Enterprise Manager's Intelligent Agent - dbsnmp. When I try to run dbsnmp_start under lsnrctl, I'm getting the library map error again, but the variable is set correctly. Is there another variable I'm not aware of? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: financial problems with fatcity.com
Do we get a t-shirt, like for PBS? My 5-year old son got a great DragonTales t-shirt. Now we have to think of a caption for the t-shirt. Didn't we already cover the T-shirt question a while back? Help!!! Are You An Idiot? ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How do you audit a DBA?
This has been discussed before, I'll try to summarize it as I remember. Sure, you could put triggers, turn on auditing, whatever. But the DBA by nature of his job function, can disable, remove, whatever you turn on. So it basically comes down to trusting your DBA, or getting a new DBA. -Original Message- From: Dave Leach [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Subject: How do you audit a DBA? Anyone who can help, I've been asked if Oracle can somehow audit the DBA ie. Raise an alert if the DBA were to execute DML statements against sensitive tables, this assumes the DBA has the SYS password. I thought this was a pretty reasonable question but couldn't think of an answer. My trail of though was maybe an email alert to a designated member of staff sent via a trigger on the table. Any comments would be very appreciated. Dave Leach -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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 do you audit a DBA?
I want to be required to take 2 weeks vacation. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 3:37 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: How do you audit a DBA? Dick, Actually, many states are work at will -- which means the company can fire you because. No reason, just because. The idea of sending the DBA off on a training course -- NYS has a similar concept in the state banking laws. Anyone working for a state-chartered bank who has more than 2 weeks of vacation is required to take two weeks consecutively, those with 2 weeks or less have to take a week. The theory is, if you are cooking the books it should come to light in that time period. Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: Disaster recovery
I need to do some documenting too. Person probably driving the bus ;-) (That person thats been stalking you) Oracle Versions Patches installed File system layout Instances mapped to Oracle Homes log files (methods for checking/trimming) scripts/tools (what/where/when/why) listener info (name/port) passwords (available from a secure location) backup practices -Original Message- From: O'Neill, Sean [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 5:46 AM To: Multiple recipients of list ORACLE-L Subject: Disaster recovery I have to document our Oracle databases for the case where I'm e.g. hit by the proverbial bus. So if you DBA folk were to come on site to pick up the tab and start managing our databases what information would you like to be able to refer to, to allow you get up to speed as quickly as possible with our set-up. Rachel and Bruce, thanx for your input on this. Some points ya'll made I had not considered. I'm sure there are more. Come on folks let's hear your input on this. I'll publish a list to the list when it looks as though all avenues have been explored!. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: database upgrade policy?
Just for the PLEASURE of using OUI! -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 6:07 PM To: Multiple recipients of list ORACLE-L Subject: RE: database upgrade policy? I have people here who just want to upgrade for the sake of upgrading...rrggg..ok.:) KK -Original Message- Sent: Wednesday, August 22, 2001 5:01 PM To: Multiple recipients of list ORACLE-L Well, we wanted to upgrade from 8.0.4 to 8.1.6 last year because it had been desupported. We got most of the machines upgraded except for the main production machine. I wanted to upgrade that last September. I have finally gotten permission to tentatively schedule the for next month (one year later), just in time for the 8.1.6 desupport notice. Sigh. -Original Message- Sent: Wednesday, August 22, 2001 3:36 PM To: Multiple recipients of list ORACLE-L Lisa, You need some work to do Certifiable Gimp Monkey?? Stub you toe while swinging on the trapeze? ROR mô¿ôm [EMAIL PROTECTED] 08/22/01 12:45PM Don't upgrade unless there is a very good reason. All of these are candidates 1. current oracle version is unstable 2. specific bug addressed by an upgrade/patch, as identified by support 3. need to utilize new feature 4. desupport date coming up. If it works, don't fix it! Don't do it just for fun. Because it can turn into HELL. Lisa Koivu Certifiable Gimp Monkey (and DBA) Ft. Lauderdale, FL, USA -Original Message- From: Mark Marsden [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 11:45 To: Multiple recipients of list ORACLE-L Subject:database upgrade policy? Hi Listers I'm on 8.1.6.0.0 and wondering about upgrading to 8.1.6.3.1(?) as I get the occasional ORA-600/ORA-7445. Do you upgrade to the latest subversion as a matter of policy (and not test very much) to prevent possible errors or only upgrade if you have problems? Do you upgrade to major versions (7 to 8.0 to 8.1) for increased functionality, cos Oracle are desupporting (the main reason we upgrade) or to improve the CV ;-) with the possible downside of instability. Mark. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: Code Red
Can read all about sadmind at cert. http://www.cert.org/advisories/CA-2001-11.html -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 10:11 AM To: Multiple recipients of list ORACLE-L Subject: RE: Code Red Paul, Thanks for the assist, I tried to find the name on line but definatly couldn't find it. Interesting thing though, we don't have Solaris machines here, so I am assuming it can exploit the NT weakness on it's own! KK -Original Message- Vincent Sent: Wednesday, August 08, 2001 5:46 AM To: Multiple recipients of list ORACLE-L We got that a few weeks ago - exactly the same message on one of our NT servers. This was before people were talking about Code Red. Apparently it's known as the sadmind virus. It exploits a weakness in Solaris security to get into a Solaris server. From there, it sniffs out any NT servers (or networked workstations) which are running IIS, and then exploits an NT security loophole to replace the default webpage on the NT server with that f*** the US Government message. Our sysadmins tell me this is well documented at all the usual virus information websites. Just look under sadmind. Paul Vincent Database Administrator, University of Central England -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: 07 August 2001 18:27 To: Multiple recipients of list ORACLE-L Subject: RE: Code Red Yeah, that's what I read. I had applied the patch and I don't have Code red or Code Red II, however it appears that I have something else. It doesn't seem to have worked but it looks like someone tried to deface our website. It's just a message that says f--k the us government and f--k poisonbox, not sure what to do with it yet. KK -Original Message- Brian Sent: Tuesday, August 07, 2001 12:56 PM To: Multiple recipients of list ORACLE-L The worm is just memory resident, so a reboot should get rid of it, BUT without the patch, you'll get it right back. The problem for the new version is it deposits a trojan backdoor on your server. Mcafee dat 4152 is supposed to find the trojan, I'm sure other virus scanners are releasing versions also. Check with your anti-virus site. -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Subject: Code Red So does anyone know how to get rid of the virus if you got it? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Anderson, Brian 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: Kevin Kostyszyn 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: Paul
RE: Code Red
The trouble with code red was that it went through port 80, which is left open by firewalls because that is the port used for HTTP pages (WWW). Closing that would mean no one could access Web pages. So firewalls won't help you re. things like that. You can now go through any ports that are left open, and there is software out there to detect ports that were left open. Start up apache on port 80 and you can see the hits from code red in the log files. I'm waiting for them to get really advanced code red 6, The IIS hunter killer, which scans for ports running IIS, and hits it at other ports. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: For those who got Code Red in the face
I would check quickly for these files, http://vil.nai.com/vil/virusSummary.asp?virus_k=99177 Presence of the files: c:\inetpub\scripts\root.exe c:\progra~1\common~1\system\MSADC\root.exe d:\inetpub\scripts\root.exe d:\progra~1\common~1\system\MSADC\root.exe. Also make sure your virus protection is up to date, it should let you know if the back door put in by the latest code red is on your machine. -Original Message- From: Jack C. Applewhite [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 6:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: For those who got Code Red in the face Our webserver got hit a couple of weeks ago. It got cleaned up and the security patch(es) applied. I thought nothing more about it. However, I think it or a variant got three of our other Win2k servers that don't run IIS at all. Yesterday I found a strange process, VMGR32.exe, chewing up 50% CPU on our production db server. The file, in C:\WinNT\System32, was dated 07/30/2001 08:40pm. Another file, acer4.exe, of exactly the same size, 272KB, had exactly the same datetime. Neither file shows the usual Version tab in the Properties window (after right click on the file). I searched the Microsoft site and did a Google search on both, with zero hits. Suspicious... I checked out http://www.net-security.org/text/articles/coverage/code-red/ but couldn't see any similarities until it suggested running netstat -an to see if your server was connecting to dozens of random IP addresses at port :80. I did and ours was! I changed the service Remote Administration Service (which loads VMGR32.exe) to Manual and rebooted the servers. The connections to random IP addresses at port :80 have stopped and VMGR32.exe is no longer running as a process. I also installed Win2k Service Pack 2. I hope I've squashed this worm! Have I? Are the port :80 connections and VMGR32.exe related or have I been chasing the wrong culprit? The NT sysadmin at our colocation facility isn't a lot of help (one reason we're looking to switch pretty soon!), so I'm kind of at a loss. Any suggestions? Thanks. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- [EMAIL PROTECTED] Sent: Monday, August 06, 2001 2:24 PM To: Multiple recipients of list ORACLE-L New worm targets same systems as Code Red Security analysts warned that a new and potentially dangerous worm began circulating over the weekend, targeting the same Windows-based servers as the high-profile Code Red worm. http://computerworld.com/nlt/1%2C3590%2CNAV47_STO62834_NLTAM%2C00.html -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: Code Red
The worm is just memory resident, so a reboot should get rid of it, BUT without the patch, you'll get it right back. The problem for the new version is it deposits a trojan backdoor on your server. Mcafee dat 4152 is supposed to find the trojan, I'm sure other virus scanners are releasing versions also. Check with your anti-virus site. -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Subject: Code Red So does anyone know how to get rid of the virus if you got it? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Anderson, Brian 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: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED
= (Address = (Protocol = TCP) (Host=ora2000) (Port=1521))) Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). W±ëzØ¡÷r9,B¶Yà §©Ê뢷jSz7jSzɨ¡Êrq´(È×ÂSIê?ÇóYßÎçQ_ÎçÓjpz jX¢¹hû-'z×ëqdzóSXEUR¸¶ÄDCTLº»*÷¢kSÉSX'X¶Çu©1¨(tm)ëj ¸´k¹ör+r?¢×\²--)¡ò²Ñ®æv)...é²Æxb)-çjXyʵ¨Sx5%9,B®Ø©¡ùSX'X·*Á© ¶?é½ç®?¢éÉ©¢ÇvØBr?jw¢º...êú(tm)«¢y'ënÇ?¸ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: computer history stories - Now: Age discrimination?
In South Georgia, the standard practice is to carry a disposable cup. -Original Message- Sent: Monday, August 06, 2001 3:00 PM To: Multiple recipients of list ORACLE-L -Original Message- From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]] There are about 1200 permanent employees here. You can't spit without hitting someone with a physics doctorate Try aiming downwards at a spittoon or a trash can instead of sending your projectiles in a horizontal trajectory. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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 -- suggestions to ensure nerdiness in potential IT staff
I remember a turtle, BUT he spoke to Mr. Owl, and the answer was 3. For those not in the US, it's from an old TV commercial. I started playing on Commodore-64's in high school in 1982. I've still got some of those Verbatim 5.25 disks in the closet at home. What is the language that uses a turtle for teaching children about computers? What language was it based on? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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 -- suggestions to ensure nerdiness in potential IT staff
How would you convert a 1-sided 5 ¼ diskette into a 2-sided one? Flip the floppy and cut a notch. I actually used scissors. I loved it when they came out with those precise clippers. ***I just used a plain hole punch What colour were the Verbatim 5 ¼ diskette pockets? Was it grey? Was that 3Ms? I remember paying 50 bucks for 10 floppies. I thought it was a great deal!! *** It was pink What IBM PS/2 model was listed as having a 2.88M diskette drive? Sorry, I went with all the generic PCs. *** I don't remember what IBM had them, but my old generic 486 has one. Did the first macintosh computer come with a handle? *** No, I don't believe it did. Extremely important entertainment bonus question: What cartridges came with the Atari 2600 game system upon initial purchase? Asteroids, I think. I never got an Atari, but I would guess pong. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: Largest Oracle Databases
Actually, speaking from a state college, the official policy is you get forwarded around and put on hold for a couple hours, until you get to someone sitting in a closet somewhere at the public information desk, who will research your question and send it right to you in 6 - 8 months. -Original Message- Sent: Tuesday, July 31, 2001 10:31 AM To: Multiple recipients of list ORACLE-L yeppers thats exactly what i'm saying they have to tell you the metrics but not what they store. joe [EMAIL PROTECTED] 07/31/01 09:55AM Are you saying that if I called up the CIA and said Hey guys, I was just wondering how many bytes you db's are and what platform your using they would HAVE to tell me:? That's sweet!!! I'll give them and the NSA a call, if I disappear, you'll know why:) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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: Anderson, Brian 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 SCRIPT ISSUE - URGENT
for i in `ls` do YourScript.shl $i done Unless you are also processing your newfile.dat in the script you need to make unique names for the output files. Something like: sed s/Report by Hosts/$IP| Report by Hosts/ $FN new_${FN}.dat so you will get an output file from each input file. -Original Message- From: Johan Muller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 10:26 AM To: Multiple recipients of list ORACLE-L Subject: UNIX SCRIPT ISSUE - URGENT I need to extract the first 16 bytes of a filename (AIX 4.3) which consists of an IP address (nnn.nnn.nnn.nnn), and move that to first 16 positions in the file itself, plus adding a pipe (|) sign for a delimiter, and save the IP address as a file name with a .dat extension, before loading the contents into a table. My predecessor concocted the following: #!/usr/bin/ksh FN=$1 IP=`echo $FN|cut -c1-16` sed s/Report by Hosts/$IP| Report by Hosts/ $FN newfile.dat #-- End of file which is great for a single file at a time. Right now I have to perform this surgery on 19 986 files, which is in one place. Using the script above would take me over 20 000 hours. Any way I can grab the files one at the time based on a ls command, and invoke the script, and to end up when the last file has been processed. ALTERNATIVE: Each file contains the IP address which has to move into the first position after a string on line 13 which you guessed it: is called 'IP Address:'. Is their a way vi could be used to achieve the same result? Any input would be appreciated, Johan Muller __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller 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: Anderson, Brian 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: tnsnames.ora in clients
We use a shared tnsnames.ora from a NT server. -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED]] Sent: Monday, July 23, 2001 2:33 PM To: Multiple recipients of list ORACLE-L Subject: Re: tnsnames.ora in clients Does this method of sharing the tnsnames work for you? What operating system are you using? I use Novell and when I tried this method of sharing the tnsnames it wouls not work. We had to resolve to downloading the latest copy to the users when they logged in. ROR mª¿ªm [EMAIL PROTECTED] 07/23/01 11:41AM You can write a script and each time when a user logs into a domain it will check and copy the latest tnsnames.ora file. Or you can just place the tnsnames.ora file on the network drive and point everyone to it. [EMAIL PROTECTED] 07/23/01 10:55AM Hello All, Good morning! I would like to know how the 'tnsnames.ora' file on all client(windows) machines can be updated automatically whenever something changed on central 'tnsnames.ora' file. Is this the process still being used extensively or else advanced features like ONS. Your suggestions are highly appreciated. Thanks, Suren Consultant DBA Sony -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra 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: Richard Ji 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: Ron Rogers 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: Anderson, Brian 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: Exp/Imp - suppress screen output?
1 is standard output 2 is standard error -Original Message- From: Michael E. Cupp, Jr. [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 10:41 AM To: Multiple recipients of list ORACLE-L Subject: RE: Exp/Imp - suppress screen output? Why 1 /dev/null 2dev/null and not just /dev/null -Original Message- Surendra Sent: Friday, July 20, 2001 10:15 AM To: Multiple recipients of list ORACLE-L use this.. exp usn/pwd all your other parameters 1/dev/null 2dev/null Suren -Original Message- Sent: Friday, July 20, 2001 9:15 AM To: Multiple recipients of list ORACLE-L Does anyone know of a way, within Unix, to suppress the screen output from the Export and Import utilities? Thanks! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra 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: Michael E. Cupp, Jr. 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: Anderson, Brian 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: some thing strange with user_tables vs real table
Wow, I actually know the answer to this one. It's a known result of tables from Access, they can end up lower case, mixed case, whatever. You have to use the quotes around the name, like you did in the second select. You could get rid of this by: create table new_tmp_april as select * from 'tmp_april'; So new_tmp_april would be a regular oracle named table. -Original Message- From: Ari, Rama [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 4:32 PM To: Multiple recipients of list ORACLE-L Subject: some thing strange with user_tables vs real table One of our programmer had imported a table from ACESS database. When I query user_tables I get following result. SQL select table_name from user_tables where table_name= 'TMP_APRIL' no rows selected SQL select table_name from user_tables where table_name= 'tmp_april' TABLE_NAME -- tmp_april When I query tmp_april table I get following result. SQL select count(*) from tmp_april; select count(*) from tmp_april * ERROR at line 1: ORA-00942: table or view does not exist SQL select count(*) from TMP_APRIL; select count(*) from tmp_april * ERROR at line 1: ORA-00942: table or view does not exist For some reason, table name has been stored as tmp_april (lower case). When we create table it supposed to store table name with upper case. Did any one had similar kind of problem? Thanks in Advance, Rama Ari Database Administrator [EMAIL PROTECTED] 610.964.5128 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ari, Rama 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: Anderson, Brian 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: Could not Connect to 8.1.6
I haven't tried it, or seen it myself, but some people here in the state have said there is a problem connecting from an 8.0.5 home to an 8.1.6 database. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 28, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Subject: Re: Could not Connect to 8.1.6 Did you update your listener? And TNSNAMES? -- Reply Separator -- Author: [EMAIL PROTECTED] (N J Neog) Date: 4/27/01 9:40 PM Hi all, We 3 Oracle server as follows. A. Oracle8 Enterprise Edition 8.0.5 B. Oracle8i Enterprise Edition 8.1.5 C. Oracle8i Enterprise Edition 8.1.6 was Installed Recently. All are in Digital Unix The problem is From a Unix user if my ORACLE_HOME is pointing to database A(8.0.5) or B(8.1.5), we can connect from Sqlplus to Oracle Server A and B not to C (8.1.6.) But If ORACLE_HOME is pointing to C(8.1.6), Sql Plus can connect to all database. Is there a problem with 8.1.6 ? or had we Installed 8.1.6 wrongly ? Any suggestion how to rectify it assuming my ORACLE_HOME always points to 8.1.5 or 8.0.5. Thanks in advance Regards. Naba J Neog -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle's ftp site
ftp://external-ftp.us.oracle.com ftp://205.227.44.220 ftp://oracle-ftp.oracle.com These worked for me. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] -Original Message- From: Murray, Margaret [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 11:01 AM To: Multiple recipients of list ORACLE-L Subject: Oracle's ftp site Anybody know where oracle has moved (hidden) their ftp address now? What doesn't work: ftp://external-ftp.us.oracle.com ftp://209.246.5.40 ftp://205.227.44.220 ftp://oracle-ftp.oracle.com In case it helps, the error I get says "An error occurred reading the contents of the folder. Make sure the file name is valid and you have permission to access the location specified. Details: The connection with the server was reset." Thanks for any help, Margaret Murray -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret 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: Anderson, Brian 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).
Further OT: Dr. Strangelove
Or was it "Purity of Essence" Protect your bodily fluids. If you don't get the President on the phone, you'll have to answer to the Coca-Cola Company. A GREAT MOVIE. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] Michael Sun wrote: Peace on earth and de-fragmented Oracle database everywhere. "Peace on earth" was the password from the movie called "Dr. Strangelove", in my opinion one of the best movies ever made. De-fragmented databases are not an issue any more now that we have locally mismanaged tablespaces. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: stupid DBA
http://www.darwinawards.com excerpt: Literary Reference The existence of Darwin Awards shows that we apparently do need common sense warnings like, "Caution: Batman cape does not enable wearer to fly." OF COURSE, you have to have the SUPERMAN cape to FLY!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: newbie Q: what is the maximum number of logfile member per gr
Look in docs for CREATE DATABASE command, maxlogfiles and maxlogmembers are defined at database creation and stored in the control files. To change it you must recreate control files. You probably don't want to oversize this by much, as the control files grow to leave space for the log entries. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] -Original Message- From: Dulce L. Cajigas [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 4:50 AM To: Multiple recipients of list ORACLE-L Subject: newbie Q: what is the maximum number of logfile member per group? We tried adding an additional member to an existing group but an error message told us that we can not add another member becoz the maximum is 2 only. What file should i check to see where it was set up initially. thank you so much and hoping for an answer. dulce -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dulce L. Cajigas 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: Anderson, Brian 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: Exp/imp into different version
Sure is. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] -Original Message- From: Connie Milliken [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Subject: Exp/imp into different version Is is possible to take a full database export from Oracle 8.0.5/HPUX and import it into Oracle 8.1.6/HPUX? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken 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: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle being scalable
move the tml back up to the .h (wintergrp.html) http://www.oracle.com/ip/deploy/database/featurestory/index.ht ml?wintergrp.h tml -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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 : Sinclair was RE: Metalink Again
I've got my Commodore 64. Brian L. Anderson Flunky/SA/DBA/DERT Darton College [EMAIL PROTECTED] Any more spectrum owners out there that want to admit to it ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: Oracle *Chocolate* Monitoring Tools/Friday Recipe
-Original Message- Just keep the supply of Diet Coke coming. :) Make that "Tab", for me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: problem with UTL_FILE.FILE OPEN
I believe * is valid (though I can't find the page in a book right now), though it could be dangerous, utl_file writes as oracle, make sure some duhveloper doesn't overwrite/append to your datafiles. Look at the UTL_FILE.FOPEN commands and verify the paths. lv_log_file:= UTL_FILE.FOPEN('/dir1/dir2/dir3','logfile.dat','A'); Brian L. Anderson Flunky/SA/DBA Darton College [EMAIL PROTECTED] -Original Message- From: Dasko, Dan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 10:07 AM To: Multiple recipients of list ORACLE-L Subject: RE: problem with UTL_FILE.FILE OPEN I thought that a directory had to be specified by name in initora. I don't think you can specify a wildcard or a higher level directory. I could be wrong. Dan -Original Message- Sent: Wednesday, March 14, 2001 5:16 AM To: Multiple recipients of list ORACLE-L List hi! Oracle817 on AIX. (64 bit) We have defined in initora file UTL_FILE_DIR=* When we start function UTL_FILE.FOPEN it raises exception INVALID_PATH. Everything is set and available (permissions are 777). Do you have any idea what's wrong? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?ISO-8859-2?Q?Sonja_=A9ehovi=E6?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dasko, Dan 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: Anderson, Brian 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: questions: security on the unix
Mine are all 640. Check who owns the datafiles. Brian L. Anderson Flunky/SA/DBA Darton College [EMAIL PROTECTED] -Original Message- From: Mitchell [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 1:32 PM To: Multiple recipients of list ORACLE-L Subject: Re: questions: security on the unix DBAs Whis is right security for oracle datafile. 640 or 777 or others. I found today in my AIX that some oracle datafile is 777 or some are 660. But when I chmod 644 for those 777 files. The user could not do update and I had to change back. what is wrong How about sys file. Mine is 666 currently. I think should be 640. Any idea? Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell 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: Anderson, Brian 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: OFFTOPIC: Spam, Death, the Universe, and Everything
Wasn't Eddy Haskell the friend of Wally on "Leave it to Beaver" who always caused trouble. -Original Message- I just sent out a team of hunter/killer mercenaries to kill EVERYONE associated with Eddy Haskell, OraKnowledge, OCP, Oracle, and having anything to do with data, information, or the Internet in general. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: this drove me crazy!!!
select * from table where 1 = 1 /* and insert into table ... */; seems to work fine as long as it is formatted with the proper characters surrounding the statement. Why do you want to put an insert into a select? Is the desire to select the records that are being inserted or what? Brian L. Anderson Flunky/SA/DBA Darton College [EMAIL PROTECTED] -Original Message- From: Abdul Aleem [mailto:[EMAIL PROTECTED]] Sent: Monday, February 12, 2001 7:42 AM To: Multiple recipients of list ORACLE-L Subject: RE: this drove me crazy!!! Yes! he can, as a matter of fact he can even write a complete song in WHERE clause, its just that it won't work :) HTH! -Original Message- Sent: Sunday, February 11, 2001 1:25 AM To: Multiple recipients of list ORACLE-L Subject: Re: this drove me crazy!!! I think your customer is just testing your treshold for insanity [EMAIL PROTECTED] wrote: Hi d.b.a people, how r u? I'm an Oracle DBA and my customer told me something that drove me crazy,he told me that he could write an 'insert statement' in the 'where' clause of a 'select' statement. Is this true? and if so,could you kindly tell me how? thanks alot Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MOHAMMAD AMER 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 own FREE, personal Netscape Webmail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem 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: Anderson, Brian 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).