Questions on java
hi all, can i post questions on java and j2ee PF here? waiting for +ve response for all of u thanking all purushottam hegde Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month!
RE: FTP command -without user interaction
Hi Bruce, Thanks for you response. Yes it is Windows environment. I did follow exactly what you have mentioned in your mail, but i have problem in login. Could you please let me where i'm going wrong? D:\Oracletype ftp_script.txt open psrsndb2 oracle temp123 cd sami get 1.sql quit D:\Oracleftp -s:ftp_script.txt ftp open psrsndb2 Connected to psrsndb2.i2.com. 220 psrsndb2 FTP server (SunOS 5.8) ready. User (psrsndb2.i2.com:(none)): 331 Password required for oracle . 530 Login incorrect. Login failed. ftp ftp cd sami 530 Please login with USER and PASS. ftp get 1.sql 530 Please login with USER and PASS. 530 Please login with USER and PASS. ftp quit 221 Goodbye. D:\Oracleftp psrsndb2 Connected to psrsndb2.i2.com. 220 psrsndb2 FTP server (SunOS 5.8) ready. User (psrsndb2.i2.com:(none)): oracle 331 Password required for oracle. Password: 230 User oracle logged in. ftp cd sami 250 CWD command successful. ftp get 1.sql 200 PORT command successful. 150 ASCII data connection for 1.sql (10.153.11.3,4723) (238 bytes). 226 ASCII Transfer complete. ftp: 245 bytes received in 0.00Seconds 245000.00Kbytes/sec. ftp bye 221 Goodbye. D:\Oracle Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] To malco.riotinto.co Multiple recipients of list m.au ORACLE-L [EMAIL PROTECTED] Sent by: cc [EMAIL PROTECTED] .com Subject RE: FTP command -without user interaction 07/04/2003 11:59 AM Please respond to [EMAIL PROTECTED] com What OS? Since you say batch file I will presume Windows. Use the -s:filename parameter and pass a scriptfile to the ftp command You can generate the scriptfile on the fly with echo commands and symbol redirection: eg: echo verbose off %ftp_tfile% echo open %ftp_tgt_node% %ftp_tfile% echo %ftp_tgt_user% %ftp_tfile% echo %ftp_tgt_pwd% %ftp_tfile% echo type ascii %ftp_tfile% echo cd %3 %ftp_tfile% echo put %1%2 %ftp_tfile% echo bye %ftp_tfile% rem Do the actual ftp using this script file rem TYPE %ftp_tfile% ftp -s:%ftp_tfile% Example: C:\Temptype ftpscript.ftp open mynode username secretpassword type ascii cd sys$login get login.com bye C:\Tempftp -s:ftpscript.ftp ftp open mynode Connected to mynode. 220 mynode FTP Server (Version V4.1-12) Ready. User (mynode:(none)): 331 Username USERNAME requires a Password. 230 User logged in. ftp ftp type ascii 200 TYPE set to ASCII. ftp cd sys$login 250 CWD command succesful. ftp get login.com 200 PORT command successful. 150 Opening data connection for login.com (a.b.c.d,2828) 226 Transfer complete. ftp: 1570 bytes received in 0.20Seconds 7.85Kbytes/sec. ftp bye 221 Goodbye. C:\Temp HTH, Bruce Reardon -Original Message- Sent: Friday, 4 July 2003 4:09 PM Hi All, How to execute FTP command without interaction. Basically i want to supply hostname,username,passwors,filename thru batch script. For example ftp hostname userName passWord fileName Could someone help me to do the same? Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City
Re: FTP command -without user interaction
That was about ftp. That is fine. Can anyone help on how to execute the batch file (.bat) or windows executable file (.exe) using Oracle Procedure...? Thanks, Amit Nargotra - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 04, 2003 11:59 AM What OS? Since you say batch file I will presume Windows. Use the -s:filename parameter and pass a scriptfile to the ftp command You can generate the scriptfile on the fly with echo commands and symbol redirection: eg: echo verbose off %ftp_tfile% echo open %ftp_tgt_node% %ftp_tfile% echo %ftp_tgt_user% %ftp_tfile% echo %ftp_tgt_pwd% %ftp_tfile% echo type ascii %ftp_tfile% echo cd %3 %ftp_tfile% echo put %1%2 %ftp_tfile% echo bye %ftp_tfile% rem Do the actual ftp using this script file rem TYPE %ftp_tfile% ftp -s:%ftp_tfile% Example: C:\Temptype ftpscript.ftp open mynode username secretpassword type ascii cd sys$login get login.com bye C:\Tempftp -s:ftpscript.ftp ftp open mynode Connected to mynode. 220 mynode FTP Server (Version V4.1-12) Ready. User (mynode:(none)): 331 Username USERNAME requires a Password. 230 User logged in. ftp ftp type ascii 200 TYPE set to ASCII. ftp cd sys$login 250 CWD command succesful. ftp get login.com 200 PORT command successful. 150 Opening data connection for login.com (a.b.c.d,2828) 226 Transfer complete. ftp: 1570 bytes received in 0.20Seconds 7.85Kbytes/sec. ftp bye 221 Goodbye. C:\Temp HTH, Bruce Reardon -Original Message- Sent: Friday, 4 July 2003 4:09 PM Hi All, How to execute FTP command without interaction. Basically i want to supply hostname,username,passwors,filename thru batch script. For example ftp hostname userName passWord fileName Could someone help me to do the same? Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) 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: Amit Nargotra 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 9 on redhat 9...kernal settings
Hi Jared, I ventured into my first red hat install not to long ago, but these parameters do do need a kernel rebuild (afaik) Jack -Original Message- Sent: Thursday, July 03, 2003 7:21 PM To: Multiple recipients of list ORACLE-L Unless you've run into errors requiring adjustment of these parameters, don't bother with them. I've run 4 databases on a 2Gig RAM RH 7.1 box without ever touching these. Modifying them requires rebuilding the kernel, which can be quite a hassle. It also invalidates Oracle support on linux. Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 01:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle 9 on redhat 9...kernal settings I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to. shmmax, shmmni, shmall, sem JD -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: RE: Performance
Ramon, Whatever the plan, your stats border on the insignificant (I mean these are very small values and it shouldn't even take 2mn to run). Set TIMED_STATISTICS to TRUE if this is not already done and check system events. There is something unorthodox going on - not purely a matter of SQL processing. - --- Original Message --- - From: Ramon E. Estevez [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thu, 03 Jul 2003 07:30:37 Stephane, I continue having the same problem, in LAB 2 minutes and in PRODUCTION forever. I made the changes you indicate me. This is the explain plan in LAB, NO STATISTICS with data from yesterday Execution Plan 0 SELECT STATEMENT Optimizer=CHOOSE 10 SORT (GROUP BY) 21 NESTED LOOPS 32 VIEW 43 SORT (GROUP BY) 54 TABLE ACCESS (BY INDEX ROWID) OF 'TCON_ACUM' 65 INDEX (RANGE SCAN) OF 'IDX_ACUM_02' (NON-UNIQUE) 72 TABLE ACCESS (BY INDEX ROWID) OF 'TCON_ACUM' 87 INDEX (RANGE SCAN) OF 'IDX_ACUM_02' (NON-UNIQUE) Statistics 0 recursive calls 0 db block gets 311 consistent gets 0 physical reads 0 redo size 353 bytes sent via SQL*Net to client 1159 bytes received via SQL*Net from client 3 SQL*Net roundtrips to/from client 2 sorts (memory) 0 sorts (disk) 1 rows processed - This the explain plan in PRODUCTION. Execution Plan 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=9 Card=1 Bytes=53) 10 SORT (GROUP BY) (Cost=9 Card=1 Bytes=53) 21 NESTED LOOPS (Cost=7 Card=1 Bytes=53) 32 VIEW (Cost=6 Card=1 Bytes=15) 43 SORT (GROUP BY) (Cost=6 Card=1 Bytes=26) 54 TABLE ACCESS (FULL) OF 'TCON_ACUM' (Cost=4 Card=1 Bytes=26) 62 TABLE ACCESS (BY INDEX ROWID) OF 'TCON_ACUM' (Cost=2 C ard=1 Bytes=38) 76 INDEX (RANGE SCAN) OF 'IDX_ACUM_02' (NON-UNIQUE) (Co st=3 Card=1) Statistics 0 recursive calls 4 db block gets 108 consistent gets 0 physical reads 0 redo size 245 bytes sent via SQL*Net to client 981 bytes received via SQL*Net from client 3 SQL*Net roundtrips to/from client 2 sorts (memory) 0 sorts (disk) 1 rows processed Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Stephane Faroult Sent: Tuesday, July 01, 2003 4:16 PM To: Multiple recipients of list ORACLE-L Ramon, I have had a closer look at your coe. My gut feeling is that SELECT MAX(A.ACM_FECACUM), Nvl(A.ACM_ACUMDBANT,0) - nvl(A.ACM_ACUMCRANT,0) + nvl(A.ACM_ACUMDB,0)- nvl(A.ACM_ACUMCR,0) into vFechaIni, vSaldoAnt from tcon_acum A, (select ACM_Oficina, ACM_Moneda, nvl(max(TRUNC(ACM_FECACUM)), '2001/01/01') MAXFECACUM FROM TCON_ACUM WHERE Acm_codigo = pCuenta AND ACM_Sucursal = i GROUP BY ACM_Oficina, ACM_Moneda) T where A.acm_codigo= pCuenta AND A.acm_sucursal = i AND T.ACM_Oficina = A.ACM_Oficina AND T.ACM_Moneda = A.ACM_MOneda AND TRUNC(A.ACM_FECACUM) = T.MAXFECACUM GROUP BY Nvl(A.ACM_ACUMDBANT,0), nvl(A.ACM_ACUMCRANT,0), nvl(A.ACM_ACUMDB,0), nvl(A.ACM_ACUMCR,0); nvl(A.ACM_ACUMDB,0),nvl(A.ACM_ACUMCR,0); would return the same thing as what you have, only faster. On first readin I had not noticed that you IN (SELECT ...) was correlated. Ouch. If ACM_CODIGO and ACM_SUCURSAL are indexed (and the index is discriminant enough), and if (ACM_OFICINA, ACM_MONEDA) are also separately indexed (with the same restriction as before), it should run reasonably fast. Ramon E. Estevez wrote: Tks Stephane and Madlen, Still the same problem. I added the hint /*+ FIRST_ROWS */ to the query that invoke the function and it changed from FTS to use Index but still have the same problem. I added the same hint to the function and Nothing. I checked the v$session_wait during the execution of the procedure and the only thing that Was waiting was SQL NET TO CLIENT MESSAGE. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Stephane Faroult Sent: Friday, June 27, 2003 6:15 PM To: Multiple recipients of list ORACLE-L Ramon, This is not a strange case at all; I find quite customary to see dazzling fast queries in a development environment crawl
AW: calling an external procedure
This line jumps out: create library zPrintString as 'c:/newsys/bin/PrintString.dll'; Any difference if you change those to backslashes? :-))) yes, indeed ! that's it ! works perfectly now ! TNX to all of you, who helped a blind man ;-) Frank _ Confidentiality Notes This email and any files transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the authorised recipient, any use, disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited. If you received this in error, please contact the sender and delete the material from any computer. E-mail messages are not necessarily secure. Scheidt Bachmann does not accept responsibility for any changes made to this message after it was sent. Thank you for your cooperation! Diese E-Mail und alle angehängten Dateien ist ausschließlich für die Person / Personen bestimmt, an die diese adressiert ist und könnte vertrauliche und / oder rechtlich geschützte Informationen enthalten. Sollten Sie nicht der für diese E-Mail bestimmte Adressat oder nicht zum Empfang berechtigt sein, ist Ihnen jeder Gebrauch, sowie jede Veröffentlichung, Vervielfältigung oder Weitergabe wie auch das Ergreifen oder Unterlassen von Maßnahmen im Vertrauen auf erlangte Information untersagt. Sollten Sie diese E-Mail irrtümlich erhalten haben, benachrichtigen Sie bitte den Absender und löschen diese E-Mail von jedem Computer. E-Mail-Mitteilungen sind nicht notwendigerweise sicher. Scheidt Bachmann übernimmt keine Verantwortung für Veränderungen dieser Mitteilung, die nach dem Senden vorgenommen wurden. Herzlichen Dank für Ihre Unterstützung! - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Foelz.Frank 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: {SPAM?} Re: {SPAM?} Re: fine grained access
Then AUDIT it is (we don't have 9) - thanks, Arup... peter edinburgh Are you interested to know whether a select statement ran againt a particular table, only? Then AUDIT command will do the job nicely. However, if you want to record 'what' was selected from that table, you need Fine Grained Auditing, which requires Oracle 9i. HTH. Arup Nanda www.prolignece.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 03, 2003 6:35 AM Interesting threads. May I just seek the advice of the list on the alternative means by which one might capture read only activity? We want to know if a 'select' statement is run against particular tables. peter edinburgh -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED] Sent: 02 July 2003 16:46 To: Multiple recipients of list ORACLE-L Subject: {SPAM?} Re: fine grained access Fine grained access control doesn't tell you who did what, it restricts users from doing certain things. If you want to just capture the changes, not the actual update statement, you can do this via triggers which insert into a copy of the table, with the additional columns of timestamp and user --- [EMAIL PROTECTED] wrote: Hi list We have a dozen authorisation tables who are visibible for end-users and changeable for application owners. What our security officer wants is that he can see who changed something in those tables (including timestamp and update statement) Is FGA the solution for this ? Anyone with a few tips/hints how to do this with FGA ? thanks vr.gr. Geo Kor Sr. System Engineer IDM Db RDW Voertuiginformatie en -toelating Ict Bedrijf Holland * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter 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 --
Re: Oracle 9 on redhat 9...kernal settings
Must have changed when I wasn't looking. On Friday 04 July 2003 01:34, Jack van Zanen wrote: Hi Jared, I ventured into my first red hat install not to long ago, but these parameters do do need a kernel rebuild (afaik) Jack -Original Message- Sent: Thursday, July 03, 2003 7:21 PM To: Multiple recipients of list ORACLE-L Unless you've run into errors requiring adjustment of these parameters, don't bother with them. I've run 4 databases on a 2Gig RAM RH 7.1 box without ever touching these. Modifying them requires rebuilding the kernel, which can be quite a hassle. It also invalidates Oracle support on linux. Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 01:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle 9 on redhat 9...kernal settings I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to. shmmax, shmmni, shmall, sem JD -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Questions on java
Yes, but you may not get any answers. On Friday 04 July 2003 00:59, purushottam krishna hegde wrote: hi all, can i post questions on java and j2ee PF here? waiting for +ve response for all of u thanking all purushottam hegde - Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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 9 on redhat 9...kernal settings
standard kernel : no rebuild. just use sysctl -p after writing yr preeferred settings into /etc/sysctl.conf for advanced linux guys: they can be set directly - but the previous way is more convinient. in case you don't set them yr installation might hnag when creating the database instance. in this case just install the database later. means start dbassiost fter setting the kernel params. doesn't need a complete re-install. kr [EMAIL PROTECTED] 07/04/03 10:34 AM Hi Jared, I ventured into my first red hat install not to long ago, but these parameters do do need a kernel rebuild (afaik) Jack -Original Message- Sent: Thursday, July 03, 2003 7:21 PM To: Multiple recipients of list ORACLE-L Unless you've run into errors requiring adjustment of these parameters, don't bother with them. I've run 4 databases on a 2Gig RAM RH 7.1 box without ever touching these. Modifying them requires rebuilding the kernel, which can be quite a hassle. It also invalidates Oracle support on linux. Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 01:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle 9 on redhat 9...kernal settings I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to. shmmax, shmmni, shmall, sem JD -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: Markus Reger 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: FTP command -without user interaction
YOu have to check for your password. I am using same kind of job for working with this batch file. All I do is use two files.. One batch file and other the parameter file... Below is the copy of the same... === Batch File === ftp -v -n -s:amit.txt o--o--o === amit.txt contents === open 192.168.26.45 user anonymous try@ verbose prompt ascii cd d/smsc5/server/input/ put amit.aut close o-o--o Hope this helps Amit Nargotra - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 04, 2003 1:39 PM Hi Bruce, Thanks for you response. Yes it is Windows environment. I did follow exactly what you have mentioned in your mail, but i have problem in login. Could you please let me where i'm going wrong? D:\Oracletype ftp_script.txt open psrsndb2 oracle temp123 cd sami get 1.sql quit D:\Oracleftp -s:ftp_script.txt ftp open psrsndb2 Connected to psrsndb2.i2.com. 220 psrsndb2 FTP server (SunOS 5.8) ready. User (psrsndb2.i2.com:(none)): 331 Password required for oracle . 530 Login incorrect. Login failed. ftp ftp cd sami 530 Please login with USER and PASS. ftp get 1.sql 530 Please login with USER and PASS. 530 Please login with USER and PASS. ftp quit 221 Goodbye. D:\Oracleftp psrsndb2 Connected to psrsndb2.i2.com. 220 psrsndb2 FTP server (SunOS 5.8) ready. User (psrsndb2.i2.com:(none)): oracle 331 Password required for oracle. Password: 230 User oracle logged in. ftp cd sami 250 CWD command successful. ftp get 1.sql 200 PORT command successful. 150 ASCII data connection for 1.sql (10.153.11.3,4723) (238 bytes). 226 ASCII Transfer complete. ftp: 245 bytes received in 0.00Seconds 245000.00Kbytes/sec. ftp bye 221 Goodbye. D:\Oracle Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] To malco.riotinto.co Multiple recipients of list m.au ORACLE-L [EMAIL PROTECTED] Sent by: cc [EMAIL PROTECTED] .com Subject RE: FTP command -without user interaction 07/04/2003 11:59 AM Please respond to [EMAIL PROTECTED] com What OS? Since you say batch file I will presume Windows. Use the -s:filename parameter and pass a scriptfile to the ftp command You can generate the scriptfile on the fly with echo commands and symbol redirection: eg: echo verbose off %ftp_tfile% echo open %ftp_tgt_node% %ftp_tfile% echo %ftp_tgt_user% %ftp_tfile% echo %ftp_tgt_pwd% %ftp_tfile% echo type ascii %ftp_tfile% echo cd %3 %ftp_tfile% echo put %1%2 %ftp_tfile% echo bye %ftp_tfile% rem Do the actual ftp using this script file rem TYPE %ftp_tfile% ftp -s:%ftp_tfile% Example: C:\Temptype ftpscript.ftp open mynode username secretpassword type ascii cd sys$login get login.com bye C:\Tempftp -s:ftpscript.ftp ftp open mynode Connected to mynode. 220 mynode FTP Server (Version V4.1-12) Ready. User (mynode:(none)): 331 Username USERNAME requires a Password. 230 User logged in. ftp ftp type ascii 200 TYPE set to ASCII. ftp cd sys$login 250 CWD command succesful. ftp get login.com 200 PORT command successful. 150 Opening data connection for login.com (a.b.c.d,2828) 226 Transfer complete. ftp: 1570 bytes received in 0.20Seconds 7.85Kbytes/sec. ftp bye 221 Goodbye. C:\Temp HTH, Bruce Reardon -Original Message- Sent: Friday, 4 July 2003 4:09 PM Hi All, How to execute FTP command without interaction. Basically i want to supply hostname,username,passwors,filename thru batch script. For example ftp hostname userName passWord fileName Could someone help me to do the same? Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--
RE: Oracle DBA 9i Books ever needed.
in the Hogwarts school of Oracle Wizardry Cary Dumbledore is probably the headmaster Yes, and only because he looks very much like him. who will have the role of Lord Voldemort? There really is only one possible answer to this but I won't say it public :-) Regards, Harry Þessi póstur var sendur með vefpósti mi, http://www.mi.is -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gudmundur Bjarni Josepsson 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 DBA 9i Books ever needed.
- Original Message - okay, now Jared will perform the crucias (sp? I don't have the book with me, I finished it and it's home) curse on me if I don't stop here and take this to the OT list. Back on topic, reparo is for db recovery! dr, I promise! sorry, Jared Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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: Questions on java
best pl,ace ive seen for java questions are the sun.com forums. - Original Message - From: purushottam krishna hegde To: Multiple recipients of list ORACLE-L Sent: Friday, July 04, 2003 3:59 AM Subject: Questions on java hi all, can i post questions on java and j2ee PF here? waiting for +ve response for all of u thanking all purushottam hegde Do you Yahoo!?SBC Yahoo! DSL - Now only $29.95 per month!
Re: Questions on java
Hi! IMO, better not to ask offtopic questions, since this is a mailinglist there's no possibility to fine-grained control which mails hit our mailboxes. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 04, 2003 12:59 PM Yes, but you may not get any answers. On Friday 04 July 2003 00:59, purushottam krishna hegde wrote: hi all, can i post questions on java and j2ee PF here? waiting for +ve response for all of u thanking all purushottam hegde - Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Tanel Poder 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: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger !
Title: RE: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger This will teach you that you should be _very_ careful when dealing with sys schema. what's that parameter to disable sys triggers ?? 1. Call OWS 2. If this is production DB, keep your resume ready. Raj -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 03, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Subject: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger At first glance it appears that you have created a self referencing trigger. You can't drop it, because dropping it fires the trigger. Check metalink, open a TAR, etc. Jared rahul sharma [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 03:40 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: cannot disable or drop the ON DATABASE trigger Help list... i have created the following in 8.1.5 instance CREATE OR REPLACE TRIGGER DDL_TRIGGER BEFORE CREATE OR ALTER OR DROP ON DATABASE BEGIN null; END; / and now i cannot drop or disable this trigger ERROR at line 1: ORA-04045: errors during recompilation/revalidation of SYS.DDL_TRIGGER i'm loggin into svrmgrl and connecting as internal to try drop or disable.. is this a bug ?? TIA Rahul.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: Oracle 9 on redhat 9...kernal settings
Nice. I haven't even looked at setting these parms in linux in a couple years, didn't know this was available. So, how do you set SHMMAX, etc on linux using sysctl? The man pages weren't much help. Jared On Friday 04 July 2003 03:24, Markus Reger wrote: standard kernel : no rebuild. just use sysctl -p after writing yr preeferred settings into /etc/sysctl.conf for advanced linux guys: they can be set directly - but the previous way is more convinient. in case you don't set them yr installation might hnag when creating the database instance. in this case just install the database later. means start dbassiost fter setting the kernel params. doesn't need a complete re-install. kr [EMAIL PROTECTED] 07/04/03 10:34 AM Hi Jared, I ventured into my first red hat install not to long ago, but these parameters do do need a kernel rebuild (afaik) Jack -Original Message- Sent: Thursday, July 03, 2003 7:21 PM To: Multiple recipients of list ORACLE-L Unless you've run into errors requiring adjustment of these parameters, don't bother with them. I've run 4 databases on a 2Gig RAM RH 7.1 box without ever touching these. Modifying them requires rebuilding the kernel, which can be quite a hassle. It also invalidates Oracle support on linux. Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 01:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle 9 on redhat 9...kernal settings I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to. shmmax, shmmni, shmall, sem JD -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: RE: Should percent increase higher than 0 in 817?
Yes, it does. (Sorry, Dan :). From OEM I see it set to 32765. OEM (9i R2) is still a bit dumb when it comes to undo segments, as it allowed me to *attempt* to change Rollback Segment _SYSSMU1$ to alter its maxextents. I received an error, of course, and alert log contained following: Fri Jul 4 11:15:48 2003 /* OracleOEM */ ALTER ROLLBACK SEGMENT _SYSSMU1$ STORAGE ( MAXEXTENTS UNLIMITED) Fri Jul 4 11:15:48 2003 ORA-30019 signalled during: /* OracleOEM */ ALTER ROLLBACK SEGMENT _SYSSMU1$... In OEM, I got to the Edit window for Rollback Segments via Tablespace - Dependencies route ;) - Kirti --- [EMAIL PROTECTED] wrote: Don't know. I bet Dan Fink does. He's in the air right now on his way to Portland, so I guess he won't be answering this. I can ask him at lunch. :) Jared Ryan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/02/2003 03:50 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: RE: Should percent increase higher than 0 in 817? does the 32k limit hold in 9i with undo tablespaces? - Original Message - To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 5:31 PM Due to bugs and limitations in the internal structure of rollback segments. ie. they aren't allowed more than 32k extents. See MetaLink note 50380.1 Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/02/2003 01:55 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: RE: Should percent increase higher than 0 in 817? i read this somewhere. why is it a bad idea to use maxextents unlimited in your rollback tablespaces? From: Goulet, Dick [EMAIL PROTECTED] Date: 2003/07/02 Wed PM 04:40:45 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Should percent increase higher than 0 in 817? Guang, In temp I really don't watch anything. In Rollback I watch for segments that are approaching maxextents and just plain running out of space. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, July 02, 2003 3:51 PM To: Multiple recipients of list ORACLE-L What are the things that we should be monitoring in ROLLBACK or TEMP tablespace? So far I don't have any script to monitor ROLLBACK or TEMP (havn't had any problem though). I too thought Oracle would take care of rollback and temp ts space management. Right or wrong? Guang snip __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger !
Parameter to disable database triggers is: _system_trig_enabled = FALSE This is 9i parameter. Alternatively, if you start the database up in the migrate mode, system triggers will be disable (startup migrate is what you need) On 2003.07.04 10:54, Jamadagni, Rajendra wrote: This will teach you that you should be _very_ careful when dealing with sys schema. what's that parameter to disable sys triggers ?? 1. Call OWS 2. If this is production DB, keep your resume ready. Raj -Original Message- Sent: Thursday, July 03, 2003 1:39 PM To: Multiple recipients of list ORACLE-L At first glance it appears that you have created a self referencing trigger. You can't drop it, because dropping it fires the trigger. Check metalink, open a TAR, etc. Jared rahul sharma [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 03:40 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:cannot disable or drop the ON DATABASE trigger Help list... i have created the following in 8.1.5 instance CREATE OR REPLACE TRIGGER DDL_TRIGGER BEFORE CREATE OR ALTER OR DROP ON DATABASE BEGIN null; END; / and now i cannot drop or disable this trigger ERROR at line 1: ORA-04045: errors during recompilation/revalidation of SYS.DDL_TRIGGER i'm loggin into svrmgrl and connecting as internal to try drop or disable.. is this a bug ?? TIA Rahul.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2 -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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 9 on redhat 9...kernal settings
The macho way is: echo 1073741824 /proc/sys/kernel/shmmax. If you put the line kernel.shmmax = 1073741824 in your /etc/sysctl.conf, RH Linux will do that for you during the next startup. When you do that, you should remember two things: a) Don't panic! b) Always have your documentation CD and a towel with you. Now, it's the time for me to hit the beach (Golf Beach, Milford CT if somebody is interested.) Happy 4th of July to everybody! On 2003.07.04 13:39, Jared Still wrote: Nice. I haven't even looked at setting these parms in linux in a couple years, didn't know this was available. So, how do you set SHMMAX, etc on linux using sysctl? The man pages weren't much help. Jared On Friday 04 July 2003 03:24, Markus Reger wrote: standard kernel : no rebuild. just use sysctl -p after writing yr preeferred settings into /etc/sysctl.conf for advanced linux guys: they can be set directly - but the previous way is more convinient. in case you don't set them yr installation might hnag when creating the database instance. in this case just install the database later. means start dbassiost fter setting the kernel params. doesn't need a complete re-install. kr [EMAIL PROTECTED] 07/04/03 10:34 AM Hi Jared, I ventured into my first red hat install not to long ago, but these parameters do do need a kernel rebuild (afaik) Jack -Original Message- Sent: Thursday, July 03, 2003 7:21 PM To: Multiple recipients of list ORACLE-L Unless you've run into errors requiring adjustment of these parameters, don't bother with them. I've run 4 databases on a 2Gig RAM RH 7.1 box without ever touching these. Modifying them requires rebuilding the kernel, which can be quite a hassle. It also invalidates Oracle support on linux. Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 01:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com cc: Subject:Oracle 9 on redhat 9...kernal settings I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to. shmmax, shmmni, shmall, sem JD -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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 9 on redhat 9...kernal settings
Hi Jared, The link I send earlier this thread explains in detail how to set this Happy Holidays Jacob A. van Zanen -Original Message- Sent: Friday, July 04, 2003 7:39 PM To: Multiple recipients of list ORACLE-L Nice. I haven't even looked at setting these parms in linux in a couple years, didn't know this was available. So, how do you set SHMMAX, etc on linux using sysctl? The man pages weren't much help. Jared On Friday 04 July 2003 03:24, Markus Reger wrote: standard kernel : no rebuild. just use sysctl -p after writing yr preeferred settings into /etc/sysctl.conf for advanced linux guys: they can be set directly - but the previous way is more convinient. in case you don't set them yr installation might hnag when creating the database instance. in this case just install the database later. means start dbassiost fter setting the kernel params. doesn't need a complete re-install. kr [EMAIL PROTECTED] 07/04/03 10:34 AM Hi Jared, I ventured into my first red hat install not to long ago, but these parameters do do need a kernel rebuild (afaik) Jack -Original Message- Sent: Thursday, July 03, 2003 7:21 PM To: Multiple recipients of list ORACLE-L Unless you've run into errors requiring adjustment of these parameters, don't bother with them. I've run 4 databases on a 2Gig RAM RH 7.1 box without ever touching these. Modifying them requires rebuilding the kernel, which can be quite a hassle. It also invalidates Oracle support on linux. Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 01:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle 9 on redhat 9...kernal settings I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to. shmmax, shmmni, shmall, sem JD -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Jack van Zanen 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 9 on redhat 9...kernal settings
http://codah.net/install-oracle9iR2-on-redhat9.html -Original Message- Sent: Friday, July 04, 2003 7:39 PM To: Multiple recipients of list ORACLE-L Nice. I haven't even looked at setting these parms in linux in a couple years, didn't know this was available. So, how do you set SHMMAX, etc on linux using sysctl? The man pages weren't much help. Jared On Friday 04 July 2003 03:24, Markus Reger wrote: standard kernel : no rebuild. just use sysctl -p after writing yr preeferred settings into /etc/sysctl.conf for advanced linux guys: they can be set directly - but the previous way is more convinient. in case you don't set them yr installation might hnag when creating the database instance. in this case just install the database later. means start dbassiost fter setting the kernel params. doesn't need a complete re-install. kr [EMAIL PROTECTED] 07/04/03 10:34 AM Hi Jared, I ventured into my first red hat install not to long ago, but these parameters do do need a kernel rebuild (afaik) Jack -Original Message- Sent: Thursday, July 03, 2003 7:21 PM To: Multiple recipients of list ORACLE-L Unless you've run into errors requiring adjustment of these parameters, don't bother with them. I've run 4 databases on a 2Gig RAM RH 7.1 box without ever touching these. Modifying them requires rebuilding the kernel, which can be quite a hassle. It also invalidates Oracle support on linux. Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 01:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle 9 on redhat 9...kernal settings I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to. shmmax, shmmni, shmall, sem JD -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: Jack van Zanen 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).
Advice needed
--Boundary-00=_6LRIG6G0 Content-Type: Multipart/Alternative; boundary=Boundary-00=_6LRIBHK0 --Boundary-00=_6LRIBHK0 Content-Type: Text/Plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable =0D Dear,=0D =0D The following machine has been bought but not yet installed : =0D SUN FIRE 6800 =0D 12 CPU a 1,2 Ghz =0D 24 GB Memory =0D 4 X 36 GB internal disks =0D 4 X 14 X 36 GB SAN 15k rpm 2 RAID Controllers (4 T4) =0D Preconfigured with 1 RAID 5 volume 1 Hot spare =0D 2 GB PCI fibre channel network adapter =0D =0D Now my concerns and questions : =0D =0D 1) What RAID architecture must we implement ?? =0D SUN suggest to use RAID 5. At first I do not agree. I always thought RAID 0+1 or RAID 1+0 was better=0D than RAID 5 certainly for write operations. SUN says the performance will= be=0D the same because of the number of disks. Is this true ?? =0D I guess they will spread parity over all disks. =0D =0D According to SUN we need to invest more, before in our case RAID 0+1 or R= AID 1+0 can be more=0D performant than RAID 5. I do not know yet what we should invest in. It ha= s something to do with the connection to the disks.=0D =0D What about restoring 1 data file ? Since SUN suggest to setup RAID 5 over all disks, is it still possible to restore 1 datafile ?=0D Does somebody know the answers to my questions ?=0D =0D SUN is coming over on wednesday to discuss SAN config and I want to be prepared. I will not take anything for granted.=0D =0D 2) What about the file systems ? =0D I know that the more database files are spread over different disks the better. =0D Two databases will be installed.=0D I propose the following file systems :=0D =0D /sid1 -- contains application files and admin directory=0D /sid1/dbs - contains datafiles for SYSTEM,UNDO,TEMP REDO log files.=0D /sid1/dbs/data - contains DATA tablespaces datafiles=0D /sid1/dbs/index -- contains INDEX tablespaces datafiles=0D /sid1/dbs/arch -- contains archived REDO log files=0D =0D The same for sid2.=0D I want to be certain that sid1 will not influence the performance of sid2= =2E Sid1 will be production, sid2 will be a test environment.=0D Is this setup possible with RAID 5 ??=0D =0D Can somebody advice me ?=0D =0D Rgds,=0D =0D Patrick Van der Sande=0D Managing Director =0D ANDES Consulting BVBA=0D email : [EMAIL PROTECTED] website : http://www.andes-consulting.be --Boundary-00=_6LRIBHK0 Content-Type: Text/HTML; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable meta http-equiv=3DContent-Type content=3Dtext/html; charset=3Diso-885= 9-1html head meta name=3DGENERATOR content=3DIncrediMail 1.0=0D !--IncrdiXMLRemarkStart IncrdiX-Info X-FIDFLAVOR00-NONE---/X-FID X-FVER2.0/X-FVER X-CNT;/X-CNT /IncrdiX-Info IncrdiXMLRemarkEnd-- =0A/head BODY background=3D bgColor=3D#ff style=3DBACKGROUND-POSITION: 0px= 0px; FONT-SIZE: 10pt; MARGIN: 1px; FONT-FAMILY: Arial scroll=3Dyes ORGY= POS=3D0 X-FVER=3D2.0 TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 id=3DINCREDIMAINTABLE w= idth=3D95% TR TD id=3DINCREDITEXTREGION width=3D100% style=3DPADDING-RIGHT: 7px; PA= DDING-LEFT: 7px; FONT-SIZE: 10pt; FONT-FAMILY: Arial=20 DIVnbsp;/DIV DIVSTRONGDear,/STRONG/DIV DIVSTRONG/STRONGnbsp;/DIV DIVThe following machine has been bought but not yet installed : = BRSUN=20 FIRE 6800 BR12 CPU a 1,2 Ghz BR24 GB Memory BR4 X 36 GB inter= nal=20 disks BR4 X 14 X 36 GB SAN 15k rpm 2 RAID Controllers (4 T4)=20 BRPreconfigured with 1 RAID 5 volume amp; 1 Hot spare BR2 GB P= CI=20 fibre channel network adapter BRBRNow my concerns and questions= :=20 BR/DIV DIV1) What RAID architecture must we implement ?? BRSUN suggest= to use=20 RAID 5. At first I do not agree. I always thought RAID 0+1 or RAID = 1+0 was=20 betterBRthan RAID 5 certainly for write operations. SUN says the=20 performance will beBRthe same because of the number of disks. Is = this=20 true ?? BRI guess they will spread parity over all=20 disks.nbsp;BR/DIV DIVAccording to SUNnbsp;we need to invest more, before in our ca= se RAID=20 0+1 or RAID 1+0 can be moreBRperformant than RAID 5. I do not kno= w yet=20 what we should invest in. It has something to do with thenbsp;conn= ection=20 tonbsp;the disks./DIV DIVnbsp;/DIV DIVWhat about restoring 1 data file ? Since SUN suggest to setup = RAID 5=20 over all disks, is it still possible to restore 1 datafile ?/DIV DIVDoes somebody know the answers to my questions ?/DIV DIVnbsp;/DIV DIVSUN is coming over on wednesday to discuss SAN config and I wa= nt to=20 be prepared. I will not take anything for granted.BR/DIV DIV2) What about the file systems ? BRI know that the more data= base=20 files are spread over different disks the better. BRTwo databases= will=20 be
Re: [PMX:##] Re: cannot disable or drop the ON DATABASE
Hi Rahul in your case (8i ) put _system_trig_enabled = FALSE in your init.ora file, bounce the DB and drop the trigger. Nota : In 9i you can use alter system set _system_trig_enabled=false; HTH you wrote: Help list... i have created the following in 8.1.5 instance CREATE OR REPLACE TRIGGER DDL_TRIGGER BEFORE CREATE OR ALTER OR DROP ON DATABASE BEGIN null; END; / and now i cannot drop or disable this trigger ERROR at line 1: ORA-04045: errors during recompilation/revalidation of SYS.DDL_TRIGGER i'm loggin into svrmgrl and connecting as internal to try drop or disable.. is this a bug ?? TIA Rahul.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul 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). Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC 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: Filesystem for Linux production database server?
As far as the max-readahead option, I don't understand the specific relevance to fibre-attached storage. I would imagine, though admittedly I no longer have large storage arrays to play with, that setting readahead to be higher could damage performance against arrays with intelligent caching algorithms. Having the OS handle read-ahead this has less to do with the caching than bw utilization. (someone ought to test for async) and/or for filesystem io. Also, this is only for reads (obviously). nutshell is that the default fs *max* readahead is the current block (4k) + 31blocks for a total of ~128k. If you mess with a lot of io to fibre arrays (through fs or raw) you'll find that 128k sized io's is right at the base of the ramp-up for efficiently using your bus bandwidth for streaming io's (e.g. range or fast full scans). If you look at what happens, you start with current block + min-readahead blocks (default is 7) for a total of 64k. if the readahead is successful, then it doubles the number of pages read ahead for that file. repeat until you are at max-readahead. This PITA is that you really are trading streaming io throughput for a percentage of random io with a caveat that a higher readahead change much if you don't do that much sequential io happening (e.g. an OLTP database). rather than the array will likely fool the array into thinking that the i/o patterns are more sequential than they are. This will cause them to pre-allocate cache regions and pre-fetch more tracks off disk, which could adversely impact performance. again, this comes back to *know* your io pattern. A large db_multiblock_read setting can yield similar results if used incorrectly (the trick with fs readahead is that there is variance) Totally separate from that, Redhat strongly advises _against_ tuning that parameter. if you are doing async io, yes. Likewise, if you know what is really going on under the hood and understand your io patterns, then it is handy to have. I happen to be doing I/O testing right now anyway, so maybe I'll gen up some workloads on different filesystems and go nuts. whatcha got for storage and machines? [reply to me offline] -- craig .-... . -.-. .-. . --- . ... ... .- --. . Craig I. Hagan hagan(at)cih.com Never let your sense of morals prevent you from doing what is right. - Mayor Hardin from Isaac Asimov's Foundation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig I. Hagan 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 9 on redhat 9...kernal settings
Nice. I haven't even looked at setting these parms in linux in a couple years, didn't know this was available. some are 2.4.x things, others are 2.2.x changes. So, how do you set SHMMAX, etc on linux using sysctl? if you aren't sure, run sysctl -a /tmp/foo which basically dumps your entire proc layout. for shmmax, the variable is kernel.shmmax, so you'd add a line: kernel.shmmax = ## then run sysctl -p -- craig The man pages weren't much help. Jared On Friday 04 July 2003 03:24, Markus Reger wrote: standard kernel : no rebuild. just use sysctl -p after writing yr preeferred settings into /etc/sysctl.conf for advanced linux guys: they can be set directly - but the previous way is more convinient. in case you don't set them yr installation might hnag when creating the database instance. in this case just install the database later. means start dbassiost fter setting the kernel params. doesn't need a complete re-install. kr [EMAIL PROTECTED] 07/04/03 10:34 AM Hi Jared, I ventured into my first red hat install not to long ago, but these parameters do do need a kernel rebuild (afaik) Jack -Original Message- Sent: Thursday, July 03, 2003 7:21 PM To: Multiple recipients of list ORACLE-L Unless you've run into errors requiring adjustment of these parameters, don't bother with them. I've run 4 databases on a 2Gig RAM RH 7.1 box without ever touching these. Modifying them requires rebuilding the kernel, which can be quite a hassle. It also invalidates Oracle support on linux. Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 01:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle 9 on redhat 9...kernal settings I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to. shmmax, shmmni, shmall, sem JD -- .-... . -.-. .-. . --- . ... ... .- --. . Craig I. Hagan hagan(at)cih.com Never let your sense of morals prevent you from doing what is right. - Mayor Hardin from Isaac Asimov's Foundation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig I. Hagan 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).