Search Results

Yes, issue was with $PATH, it worked after correction.

Thanks !!

Hi,

running below korn shell script

#!/bin/ksh
chk_dump()
{
CNT=`ls *.dmp|grep $DATE|wc -l`
if [$CNT -gt 0]; then
echo "delete_dumpfile"
else
echo "start_exp"
fi
}

chk_dump

...

Hi,

script1.sh
script2.sh
script3.sh

From above, script1.sh is the main script which is executed from root user, creates installation directory, changing ownership and execution rights...

I am directly accessing Linux machine. No putty.

Hi,

How to change the value after the symbol '@' ?

[oracle@mac1~]$

i.e. @mac1

I want to change it to @prod2

Also need to change the same in the title bar on the top when we open a new...

Hi,

Os is Solaris10

and below is the error message:

[root@/users/mac] # unrar e FILE1.rar
-bash: /usr/bin/unrar: Invalid argument

Hi,

I could able to get one solution over net, in which it mentions to install "rar" utility and then copy "rar" as well as "unrar" to /bin directory, after that run the below command.

unrar e...

Hi,

I have two .rar files on unix server.

but how to unrar these files ??

Hi,

Instead of 'print' I want the values of @F to be used/added as below in the command:

LOCATION...

Hi,

xtremly sorry .. I am not getting the solution mention by you

but want to insert the file names as shown below in bold:

CREATE TABLE PROD_BKP
(
Column1 NUMBER(20),
Column2...

Hi,

can u please explain the below line :

print map {qq|\x27$_\x27|} @F;

Hi,

It works.

Now, I want the stored array values to be used as below in the further code :-

For example:
...

Hi,

[oracle@andews:/oracle/backup] $ ls
prod_bkp_140611_13_30_05.txt
prod_bkp_140611_14_30_05.txt
prod_bkp_140611_15_30_05.txt
prod_bkp_140611_16_30_05.txt

[oracle@andews:/oracle/backup] $...

yes this is the o/p of ls command.

I want to assign this o/p to the array variable for the further processing in code.

how to assign this values to array variable ?

Hi,

There are total 100 files in the backup directory with the name format as below:

prod_bkp_140611_13_30_05.txt
prod_bkp_140611_14_30_05.txt
prod_bkp_140611_15_30_05.txt...

Hi,

Below is the code to execute the procedure "dbms_job.broken" from the shell script.

on executing manually, it works properly without any error.

but it is not working when scheduled using...

Hi,

After setting Oracle_home within the script, it worked and got the desired o/p. File name appears as it was desired as mentioned below
...

Hi,

'eval' seems not working.

Below is the script which is saved to a particular file (cron_script.sh) using '>>'and this script is scheduled using crontab utility.

Now, every time when the...

Hi,

$1 and $2 values will get their values from the preceeding select query which are thenafter assigned to var1 and var2 variables.

Regards

Hi,

su - oracle<<EOC
export PATH=${PATH}:${ORACLE_HOME}/bin
exit
EOC
set `sqlplus -S $user_name/$password@$tns<<EOS
set head off
select min(time),max(time) from products;
exit;
EOS`...

Hi,

I tried as per your suggestions, but unfortunately didnt worked out. On executing the perl script Export command gets started, but asks for the parameters which are already specified with the...

Hi,

Want to initaite the Oracle's Export utility from the perl script,but getting error as mentioned below:

Script

#!/usr/bin/perl -w
my $username="system";
my $password = "manager";
my...

Hi,

executing below command for export in cygwin, though I have already mentioned the username and password with the command but on execution it again asks for username, what modification is...

Hi,

cls
@echo off
echo.
echo ======================
echo EXECUTING POST SCRIPT
echo ======================
echo.
SET /p username=Enter username:
echo.
SET /p password=Enter password:...

Hi,

Batch script gets executed without any error, but on execution some of the partial contents of the batch file gets appended at the end of the file which is currently in execution, hence the...