Recent content by vikramkalsi

We require a Web Server Load Balancing software for our development environment to simulate our Production environment which is using a HP SA7200 hardware based SLB. The development environment has two nodes running Apache 1.3.12. We are using Jserv and modplsql modules. The minimum features...

I missed one thing - it need not be content aware, even a NAT based load balancer would do. -Vikram Kalsi ---------------------------------------------------- "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe...

Hi Group, We require a Web Server Load Balancing software for our development environment to simulate our Production environment which is using a HP SA7200 hardware based SLB. The development environment has two nodes running Apache 1.3.12. We are using Jserv and modplsql modules. The minimum...

Hi lleemon, That should not be difficult - In the last_month.sh script replace --------Start Code-------------- typeset -Z2 month=${month} echo $month $year --------End Code-------------- With --------Start Code-------------- case $month in 1) mon="Jan";; 2)...

faq80-2236 can be modified for your purpose - # File-name: last_month.sh #-------------------------------------- # Returns the last month #-------------------------------------- # Input: Default: # $1 - mm Current month # $2 - yyyy Current year...

Another way to ensure that the file has completely arrived can be to FTP another file (a small file with just 1 char will also do) after the Actual file and keep checking for the existence of this file - as soon as this file is detected we know that the 1st FTP must be over. Then delete the...

Hi, Use the -h flag with chown - #chown -h user3 /scripts Hope this helps. Regards -Vikram Kalsi ---------------------------------------- We learn most when we have to invent - Piaget

Yes Nitin, there is a way - by using autonomous transactions. Consider procedure t1p and function t1f - create or replace procedure t1p as PRAGMA AUTONOMOUS_TRANSACTION; begin insert into temp_table values (51,'51'); commit; end; create or replace function t1f return varchar2 as...

Hi, There are some Restrictions on PL/SQL Functions when called from SQL. Read the following excerpt - -----------START----------------- Stored functions in SQL offer tremendous power. As you might expect, however, power introduces the possibility of abuse and the need for responsible action...

Hi, Check out http://www.ibiblio.org/pub/Linux/docs/HOWTO/SSL-RedHat-HOWTO You can order a free trial certificate from http://www.verisign.com/products/site/index.html OR you can even use the default certificate & key that comes with Apache - only thing that happens in this case is that you...

It is quite impossible to predict a database failure. However, you can be notified if the database has gone down or crashed and even restart the database in such a scenario. I can think of two ways for notification - A monitoring shell script (unix only) and through Oracle Enterprise Manager...

Check out thread186-264726 for oracle version info. Regards, -Vikram.

Hi, I have a script yesterday.sh which calculates yesterday's date or the date before the supplied arguments. You can run this in a loop to get the date prior to a week. You can try to modify the script to get 7 days back date directly, but I think it will amount to almost the same logic...

This is an extract from http://www.hp.com/products1/unix/operating/ - HP-UX 11i is the UNIX® operating environment (OE) that powers e-services and HP-UX servers on both PA-RISC and Itanium™ processor families. Elsewhere - HP-UX 11i is the latest release of HP-UX for PA architecture, and was...