AusCERT's Secuirty adviory - Oracle redirect denial of service
and the Middle East. For more information, visit the Internet Security Systems web site at www.iss.net or call 888-901-7477. Copyright (c) 2001 Internet Security Systems, Inc. Permission is hereby granted for the redistribution of this Alert electronically. It is not to be edited in any way without express consent of the X-Force. If you wish to reprint the whole or any part of this Alert in any other medium excluding electronic medium, please e-mail [EMAIL PROTECTED] for permission. Disclaimer The information within this paper may change without notice. Use of this information constitutes acceptance for use in an AS IS condition. There are NO warranties with regard to this information. In no event shall the author be liable for any damages whatsoever arising out of or in connection with the use or spread of this information. Any use of this information is at the user's own risk. X-Force PGP Key available at: http://xforce.iss.net/sensitive.php as well as on MIT's PGP key server and PGP.com's key server. Please send suggestions, updates, and comments to: X-Force [EMAIL PROTECTED] of Internet Security Systems, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long (ITS, Limestone Ave) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Perl question
Hi Jared, Thank you for your advice. Without setting LD_LIBRARY_PATH before the installation I got the message ld.so.1: perl: fatal: libgdbm.so.2: open failed: No such file or directory during the Configure step. So I tried the installation again and this time not setting the LD_LIBRARY_PATH but also ran a truss. I found out that the script tried to open /usr/lib/libdgbm.so.2 (which did not exist), not /usr/local/lib/libgdbm.so.2 (which did exist). So I created a symbolic link from /usr/lib to /usr/local/lib and tried the Configure run again. It worked fine. Thanks Long -Original Message- Sent: Saturday, 16 June 2001 6:16 PM To: Multiple recipients of list ORACLE-L Sorry to tell you this Long, but the reason you are having this problem is that you compiled Perl by setting LD_LIBRARY_PATH=/usr/local/lib. This shouldn't be done. It should be compiled *without* setting LD_LIBRARY_PATH, other than for Oracle software. I saw that you did this in a previous post, thought you'd discover it pretty quick. :) You will have to recompile Perl to fix this. I don't recall which option in the configuration you set the libraries at, as it's been a few months since I've had to do it. You can read more about the evils of LD_LIBRARY_PATH at http://www.cis.ohio-state.edu/~barr/ldpath.html We're stuck with it for Oracle though. Jared On Friday 15 June 2001 02:05, Nguyen, Long (ITS, Limestone Ave) wrote: Hi, The Perl 5.005_03 software on my Solaris 2.6 box did not have the GDBM_file module in it, so I removed it, installed GNU gdbm software, and re-installed Perl 5.005_03 that I got from CPAN. However now every time I run Perl the system gives me this message ld.so.1: perl: fatal: libgdbm.so.2: open failed: No such file or directory It did not happen with the old Perl copy. If I set LD_LIBRARY_PATH=/usr/local/lib then run Perl, there is no problem. Do you know why How can I 'link' this LD_LIBRARY_PATH setting into Perl so that I do not need to have it explicitly set every time I run Perl. (And also I do not want other users on teh system to explicitly set it in order to run Perl). Thanks Long -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long (ITS, Limestone Ave) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT RE: Forever running Analyze
Thanks Chris for letting mw know. And sorry Ross that I did not see the humour in your message. Long -Original Message-From: Christopher Spence [mailto:[EMAIL PROTECTED]]Sent: Friday, 15 June 2001 12:07 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT RE: Forever running Analyze It was a joke. Generally when there is a :) or a :-) or something similar near the end of a comment, it is ussually noted to be sarcastic. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: Nguyen, Long (ITS, Limestone Ave) [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 14, 2001 1:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT RE: Forever running Analyze Sorry Ross, maybe I missed it, but I did not see any rudeness in Alex's message. Long -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Thursday, 14 June 2001 2:57 AMTo: Multiple recipients of list ORACLE-LSubject: OT RE: Forever running Analyze Alex, I cannot believe how incredibly rude you are. ;- Ross -Original Message-From: Hillman, Alex [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 13, 2001 11:07 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Forever running Analyze Looks like nobody offered to increase sort_area_size for the session that is doing analyze -at least to such size that it will require only one merge phase. See Steve Adams web site for formula how to calculate the size, but I think that 20M should be more than enough. Alex Hillman [Hillman, Alex] -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 5:31 PMTo: Multiple recipients of list ORACLE-LSubject: Forever running Analyze Hi folks; We have an Analyze running that is taking forever. Here is the setup: The table is about 250 bytes wide. The table is normally100,000 rows The table has grown to over 4,000,000 rows. There is one index on 1 column. We used the Compute Statistics options Does anyone have any suggestions on how we can get this analyze to complete and still generate worthwile statistics ?? Thanks Kevin
OT: Perl question
Hi, The Perl 5.005_03 software on my Solaris 2.6 box did not have the GDBM_file module in it, so I removed it, installed GNU gdbm software, and re-installed Perl 5.005_03 that I got from CPAN. However now every time I run Perl the system gives me this message ld.so.1: perl: fatal: libgdbm.so.2: open failed: No such file or directory It did not happen with the old Perl copy. If I set LD_LIBRARY_PATH=/usr/local/lib then run Perl, there is no problem. Do you know why How can I 'link' this LD_LIBRARY_PATH setting into Perl so that I do not need to have it explicitly set every time I run Perl. (And also I do not want other users on teh system to explicitly set it in order to run Perl). Thanks Long -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long (ITS, Limestone Ave) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 SPAM : Become an Oracle Certified DBA in 5 Weeks
Yep. Long -Original Message- Sent: Wednesday, 13 June 2001 11:16 PM To: Multiple recipients of list ORACLE-L Did anyone else on the list get this stupid spam besides me? thanks, joe -Original Message- To: [EMAIL PROTECTED] Sent: 6/12/01 5:48 PM OraKnowledge eBoot Camp for the Oracle8i DBA Track OraKnowledge has created a blended e-learning program that GUARANTEES Oracle DBAs will become certified. The 5-week program combines the best of self-paced and instructor-led e-learning utilizing: * Syllabus for Success * Certification Exam Guides * Pre-assessment tests * Live, virtual classroom instruction from an OCP * 24 x 7 OCP Mentoring * eFlash Cards * Hundreds of Practice Questions * Guarantee Seats are available for our July 16th (EST) and July 18th (PST) start dates!! Visit http://www.oraknowledge.com for more information. To UNSUBSCRIBE from our list, reply to this email and replace the subject line with UNSUBSCRIBE. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long (ITS, Limestone Ave) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Perl module question
Hi, I did export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib and ran ./Configure again. This time it completed OK. Cheers Long -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, 14 June 2001 3:41 PM To: Multiple recipients of list ORACLE-L Thanks Tommy and Jared for the advice. I have downloaded perl5.005_03.tar.gz from CPAN, unzip and untar it and started the installation. So I ran sh configure and accepted default answer for all the questions asked. However after pressing ENTER for the two questions Any additinal cc flags? [-I/usr/local/include] Any additional ld flags? (NOT including libraries) [ -L/usr/local/lib] the configure script compiled a simple try.c program and ran it, but failed. The error messages were Checking your choice of compiler and flag for coherency I've tried compile and link the following simple program: #include stdio.h main() { printf(O\n; exit(0); } I used the command: gcc -O -I/usr/local/include -L/usr/local/lib -o try try.c -lsocket -lnsl -lgdbm -lgl -lm -lc -lcrypt ./try and I got the following ld.so.1: ./try: fatal: libgdbm.so.2: open failed: No such file or directory Killed The program compiled OK, but exist with status 137. (The supplied flags or libraries might be incorect). You have a problem . Shall I abort Configure? [Y] BUT, the file /usr/local/lib/libgdbm.so.2 does exist and is a link to /usr/local/lib/libgdbm.so.2.0.0 . So, I do not understand. Please help. Thanks Long Long Nguyen Oracle DBA CSIRO Information Technology Services [EMAIL PROTECTED] Phone 02 6276 6646 Mobile0418 612 269 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long (ITS, Limestone Ave) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nguyen, Long (ITS, Limestone Ave) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Perl module question
Hi, I am installing a request tracking software (WREQ) which requires Perl 5 with GDBM support. I could not find GDBM_File.pm under /usr/local on my Solaris 2.6 machine. The command perl -e 'use GDBM_File;' gave the message: Can't locate GDBM_File in @INC (@INC contains ) Questions: 1) Do you know if a standard perl installation should contain GDBM_File module? If yes then I will try to re-install the Perl software. 2) I also downloaded Gnu gdbm and installed it on the machine. It seems to install a number of .so and .a files in /usr/local/lib (but I could not find GDBM_File.pm anywhere). Do I need to link the software into Perl somehow so GDBM_File.pm module is created in the Perl library? Thanks Long -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long (ITS, Limestone Ave) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Perl module question
Thanks Tommy and Jared for the advice. I have downloaded perl5.005_03.tar.gz from CPAN, unzip and untar it and started the installation. So I ran sh configure and accepted default answer for all the questions asked. However after pressing ENTER for the two questions Any additinal cc flags? [-I/usr/local/include] Any additional ld flags? (NOT including libraries) [ -L/usr/local/lib] the configure script compiled a simple try.c program and ran it, but failed. The error messages were Checking your choice of compiler and flag for coherency I've tried compile and link the following simple program: #include stdio.h main() { printf(O\n; exit(0); } I used the command: gcc -O -I/usr/local/include -L/usr/local/lib -o try try.c -lsocket -lnsl -lgdbm -lgl -lm -lc -lcrypt ./try and I got the following ld.so.1: ./try: fatal: libgdbm.so.2: open failed: No such file or directory Killed The program compiled OK, but exist with status 137. (The supplied flags or libraries might be incorect). You have a problem . Shall I abort Configure? [Y] BUT, the file /usr/local/lib/libgdbm.so.2 does exist and is a link to /usr/local/lib/libgdbm.so.2.0.0 . So, I do not understand. Please help. Thanks Long Long Nguyen Oracle DBA CSIRO Information Technology Services [EMAIL PROTECTED] Phone 02 6276 6646 Mobile0418 612 269 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long (ITS, Limestone Ave) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT RE: Forever running Analyze
Sorry Ross, maybe I missed it, but I did not see any rudeness in Alex's message. Long -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Thursday, 14 June 2001 2:57 AMTo: Multiple recipients of list ORACLE-LSubject: OT RE: Forever running Analyze Alex, I cannot believe how incredibly rude you are. ;- Ross -Original Message-From: Hillman, Alex [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 13, 2001 11:07 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Forever running Analyze Looks like nobody offered to increase sort_area_size for the session that is doing analyze -at least to such size that it will require only one merge phase. See Steve Adams web site for formula how to calculate the size, but I think that 20M should be more than enough. Alex Hillman [Hillman, Alex] -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 5:31 PMTo: Multiple recipients of list ORACLE-LSubject: Forever running Analyze Hi folks; We have an Analyze running that is taking forever. Here is the setup: The table is about 250 bytes wide. The table is normally100,000 rows The table has grown to over 4,000,000 rows. There is one index on 1 column. We used the Compute Statistics options Does anyone have any suggestions on how we can get this analyze to complete and still generate worthwile statistics ?? Thanks Kevin
RE: export causes segmentation fault
Thanks Danisment and Suzy. I have forwarded your suggestions to my friend. Regards Long -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long (ITS, Limestone Ave) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
export causes segmentation fault
://www.orafaq.com -- Author: Nguyen, Long (ITS, Limestone Ave) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ODBC driver setup is not started
Thanks Mike. My user tried agin later and had no more problem! She could not explain why. There was no change to the PC and teh PC was not rebooted. I talked to another user who had the same problem s'time ago. He said that his problem was caused by him not logging on as an Administrator of the PC. Long Another user here had the smae problem before and she said -Original Message- Sent: Friday, 18 May 2001 10:30 PM To: Multiple recipients of list ORACLE-L In my case it was because of bad PATH variable. It must have "c:\orant\bin" (or wherever you installed) in it. I changed it in (as I remember) Start/Control Panel, System, Environment variables HTH Mike "Nguyen, Long (ITS, Limestone Ave)" wrote: Hi, A user had just installed Oracle Client 8.0.5 on NT4 machine. When she got into Setting\Control Panel\ODBC admin and clicked on the Add button, selected the Oracle ODBC driver 8.0.5 and click Finish, the ODBC Driver Setup screen did not appear. Did anyone come across this problem and know what went wrong here? Thanks a lot. Long -- Ing. Michal Zaschke DB Administrator Sokolovska uhelna, a.s. phone: +420-168-645417 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michal Zaschke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nguyen, Long (ITS, Limestone Ave) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ODBC Driver setup does not launch
Hi, A user has just installed Oracle Clien 8.0.5 on NT 4 machine. She then went to configure a system DSN in ODBC. She ckicked Od button, highlighted the Oracle ODB 8.0.5 driver and clicked Finish, but then the ODBC 8 Driver setup did not appear. Anyone experienced this problem? and if so, how did you get around the problem. Many thanks Long -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long (ITS, Limestone Ave) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ODBC driver setup is not started
Hi, A user had just installed Oracle Client 8.0.5 on NT4 machine. When she got into Setting\Control Panel\ODBC admin and clicked on the Add button, selected the Oracle ODBC driver 8.0.5 and click Finish, the ODBC Driver Setup screen did not appear. Did anyone come across this problem and know what went wrong here? Thanks a lot. Long -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long (ITS, Limestone Ave) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Monitoring Tools
I am using OEM and its diagnostic pack for the monitoring. I have given me a lot of frustration. I found that once you get something works with OEM, do not touch it, since it is very sensitive to changes. OEM support from Oracle WWS has not been good either. So, my suggestion is, if you look at OEM, you should also look at other software as well. Long -Original Message- Sent: Tuesday, March 13, 2001 13:17 To: Multiple recipients of list ORACLE-L Hi all! I'm in the processing of evaluating different Oracle Monitoring tools. Any suggestions? Thanks. Zhong It's another beautiful day! --- This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nguyen, Long INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OEM day today?
I don't know about publicity but if you install OEM 2.2 (Management Pack I think) you would see a product in there that allows the monitoring of SQL Server. Long -Original Message- Sent: Wednesday, 14 March 2001 8:11 AM To: Multiple recipients of list ORACLE-L Since today seems to be the official OEM day on the list, here is something I just discovered (may not be news to others). OEM supports MS SQL Server services. While "discovering" one of Oracle databases running on Win2k, I noticed new entry in Console tree: SQLServers. Upon starting Data Gatherer on that lonely Windoz box, I was able to fire up Performance Manager (part of Diagnostics pack) and view all sorts of interesting info about SQL Server databases. Has this been publicized by Oracle anywhere? Gary Weber -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nguyen, Long INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Solaris memory usage question
Hi, The "vmstat -s" command shows the number of revolutions of clock hand. My SA says that if it increases by 3 or more per minute (i.e. 1 or more per 20 seconds) thhen it indicates a shortage of real memory. I have searched for information on the clock hand revolutions and have not been able to find it. Could someone explain to me what is is. Many thanks. Long -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8i On solaris
I found that the 'oinstall' group causes confusion in term of Unix file permissions. It is still not clear to me what's the advantages of having the 'oinstall' and whether it is a 'must'. Long -Original Message- Sent: Saturday, 24 February 2001 10:11 AM To: Multiple recipients of list ORACLE-L Follow the installation guide VERY CAREFULLY. Most people fail to install Oracle on Unix because they don't read the instructions. You must modify kernal parameters and do other Unix admin steps prior to installation. One thing to ignore (at least in my opinion) -- the instruction to create an "oinstall" user. I've found this causes more trouble than it's worth when it comes to patching. Just use the "oracle" user in the "dba" group. Go to technet.oracle.com for the installation guide. Regards, Diana -Original Message- Sent: Friday, February 23, 2001 11:06 AM To: Multiple recipients of list ORACLE-L Hi everyone: I am about to install Oracle 8i Enterprise on Sun Solaris version 10. Any Practical documentation or site which could help me on installing and configuring this system will be appreciated. I was away from Unix for a while. I have already checked the Oracle.com. I appreciate your help in advance. Majid -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Majid Kazemi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Diana Duncan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nguyen, Long INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A basic forms question
Thanks for teh info. Regards Long -Original Message- Sent: Wednesday, 21 February 2001 11:46 AM To: Multiple recipients of list ORACLE-L You'll get those messages when the calling form's FMX was created with a newer version of Oracle Forms than the called form's FMX. Maybe the calling form was converted to Forms 6 and the called form is still in Forms 5 format. Just re-compile the older FMB using Forms 6 (or whatever your most current version is) and you should be able to run the form. -Original Message- From: Nguyen, Long [mailto:[EMAIL PROTECTED]] Sent: Monday, February 19, 2001 10:00 PM To: Multiple recipients of list ORACLE-L Subject: A basic forms question Hi, A user aksed me (a DBA) the question below about forms: I have been trying to open some Oracle forms but it always gives me this message: "form was created by an old version of form builder" or "cannot open form". Do you know what this mean? I looked at the fmb files and appears to be dated the 9/2/00 when the fmx files are dated the 9/6/00. Is there a way to fix this? It's the same for the other computers in our office but somehow you can open the forms without any hiccups. Also, Is it possible to import the structure of Oracle forms to Access or you have to build them from scratch in Access. So far, we've only been able to import the data from Oracle to Access only. I never use forms so do not know the answer. It seems that the user was using a newer version of forms to open an a form created in an old version. For Forms do you need to upgrade old forms when you upgrade the forms software? Also pls answer the Access question if you can. Much appreciated. Many thanks. Long -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
A basic forms question
Hi, A user aksed me (a DBA) the question below about forms: I have been trying to open some Oracle forms but it always gives me this message: "form was created by an old version of form builder" or "cannot open form". Do you know what this mean? I looked at the fmb files and appears to be dated the 9/2/00 when the fmx files are dated the 9/6/00. Is there a way to fix this? It's the same for the other computers in our office but somehow you can open the forms without any hiccups. Also, Is it possible to import the structure of Oracle forms to Access or you have to build them from scratch in Access. So far, we've only been able to import the data from Oracle to Access only. I never use forms so do not know the answer. It seems that the user was using a newer version of forms to open an a form created in an old version. For Forms do you need to upgrade old forms when you upgrade the forms software? Also pls answer the Access question if you can. Much appreciated. Many thanks. Long -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
LIKE with CLOB
Hi ALL, A question about CLOB: can we use LIKE operator in a SELECT statement for a CLOB column? Thanks Long -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A Solaris question on memory usage
Thanks David. You are right, I did not notice that the private figure actually included the SGA size as well. Regards Long -Original Message- Sent: Thursday, 8 February 2001 7:55 PM To: Multiple recipients of list ORACLE-L Long pmap seems to include portions of the SGA in the Private and Resident columns, not the Shared one. On solaris, this shows up as a line with (shmid=0x...) in the Mapped File column. To get a more sensible memory usage, I suppose that you would have to subtract these from total (the size is different for background and user processes ) and then add the size of the SGA once. Regards David Lord -Original Message- Sent: 08 February 2001 04:35 To: Multiple recipients of list ORACLE-L Good day, I am looking at how Oracle and other applications running on a Solaris 2.6 server are using memory. The server has 512 MB of RAM. I issued the "/usr/proc/bin/pmap $pid" command to display memory usage info and used the figure from the "total KB" line of the output (the last line of the output). When I add up the figures for all Oracle processes the sum of the Private areas for all Oracle processes on teh system is 1.5 GB. I do not understand this. How can this be greater than the physical RAM amount (which is 512 MB)? As I understand the Private amount is the Resident amount less the Shared amount, so the Private amount for a process would be the physical memory amount used exclusive by the process and not shared with other processes. If you could help me to understand more about this stuff, very much appreciate. I am trying to see if we need to up the RAM on the system. Thanks Long -Original Message- Sent: Thursday, 21 December 2000 3:13 AM To: Multiple recipients of list ORACLE-L In a query I found the total no of blocks used ,total size ,minextents,maxextents ,empty blocks of a table. But In index i am unable to find free / Empty blocks . but i find leaf blovks ,avg no. of leaf blocks . Please tell me how can I found free or empty blocks of a Index. Regards, Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nguyen, Long INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord David INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nguyen, Long INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT s
A Solaris question on memory usage
Good day, I am looking at how Oracle and other applications running on a Solaris 2.6 server are using memory. The server has 512 MB of RAM. I issued the "/usr/proc/bin/pmap $pid" command to display memory usage info and used the figure from the "total KB" line of the output (the last line of the output). When I add up the figures for all Oracle processes the sum of the Private areas for all Oracle processes on teh system is 1.5 GB. I do not understand this. How can this be greater than the physical RAM amount (which is 512 MB)? As I understand the Private amount is the Resident amount less the Shared amount, so the Private amount for a process would be the physical memory amount used exclusive by the process and not shared with other processes. If you could help me to understand more about this stuff, very much appreciate. I am trying to see if we need to up the RAM on the system. Thanks Long -Original Message- Sent: Thursday, 21 December 2000 3:13 AM To: Multiple recipients of list ORACLE-L In a query I found the total no of blocks used ,total size ,minextents,maxextents ,empty blocks of a table. But In index i am unable to find free / Empty blocks . but i find leaf blovks ,avg no. of leaf blocks . Please tell me how can I found free or empty blocks of a Index. Regards, Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Nguyen, Long INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).