Questions on java

2003-07-04 Thread purushottam krishna hegde
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

2003-07-04 Thread Saminathan_Seerangan
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

Re: FTP command -without user interaction

2003-07-04 Thread Amit Nargotra
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

RE: Oracle 9 on redhat 9...kernal settings

2003-07-04 Thread Jack van Zanen
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

RE: RE: Performance

2003-07-04 Thread Stephane Faroult
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

AW: calling an external procedure

2003-07-04 Thread Foelz.Frank
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 _

RE: {SPAM?} Re: {SPAM?} Re: fine grained access

2003-07-04 Thread Robson, Peter
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

Re: Oracle 9 on redhat 9...kernal settings

2003-07-04 Thread Jared Still
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

Re: Questions on java

2003-07-04 Thread Jared Still
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

RE: Oracle 9 on redhat 9...kernal settings

2003-07-04 Thread Markus Reger
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.

Re: FTP command -without user interaction

2003-07-04 Thread Amit Nargotra
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

RE: Oracle DBA 9i Books ever needed.

2003-07-04 Thread Gudmundur Bjarni Josepsson
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

Re: Oracle DBA 9i Books ever needed.

2003-07-04 Thread Nuno Souto
- 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

Re: Questions on java

2003-07-04 Thread Ryan
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

Re: Questions on java

2003-07-04 Thread Tanel Poder
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,

RE: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger !

2003-07-04 Thread Jamadagni, Rajendra
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

Re: Oracle 9 on redhat 9...kernal settings

2003-07-04 Thread Jared Still
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

Re: RE: Should percent increase higher than 0 in 817?

2003-07-04 Thread Kirtikumar Deshpande
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:

Re: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger !

2003-07-04 Thread Mladen Gogala
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

Re: Oracle 9 on redhat 9...kernal settings

2003-07-04 Thread Mladen Gogala
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

RE: Oracle 9 on redhat 9...kernal settings

2003-07-04 Thread Jack van Zanen
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

RE: Oracle 9 on redhat 9...kernal settings

2003-07-04 Thread Jack van Zanen
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

Advice needed

2003-07-04 Thread Patrick Van der Sande
--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

Re: [PMX:##] Re: cannot disable or drop the ON DATABASE

2003-07-04 Thread Gilles PARC
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

RE: Filesystem for Linux production database server?

2003-07-04 Thread Craig I. Hagan
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

Re: Oracle 9 on redhat 9...kernal settings

2003-07-04 Thread Craig I. Hagan
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