Search Results

I tried sqlplus to connect to my database , but seems like SQLPLUS is not there
sqlplus -s user/rap_user_1@PTNC1
-ksh: sqlplus: not found [No such file or directory]
$ sqlplus

Hi,

I want to write a shell script which connect to my database with the following credentials :

User name : user
PWD : rap_user_1

Hostname : app.Unix.Gsm1900.Org
Port : 7862
SID :...

Export data from database in Excel sheet with the help of Shell script and automated the report every day in the mornig.

I want to change the permission of a dir to 777 after every hour in a background process.I do not have the access to the crontab , is there another way of doing it a scrit of some thing like that ....

Hi I have a function :

Make_Report()
{
trx_report=`sqlplus -s $conn_str << @@
set echo off;
set pages 0;
set feedback...

yupppie , thanks evry one.

oh got it , i m new to this thts y :

so lets go now to nest step , i m getting this error now

Running Script to capture ORACLE Erros
./nvora2.sh: line 14: syntax error near unexpected token...

Running Script to capture ORACLE Erros
./nvora2.sh: line 8: if[ -n ]: command not found

---------- Post updated at 05:03 PM ---------- Previous update was at 05:00 PM ----------

#!/bin/sh...

#!/bin/sh
echo "Running Script to capture ORACLE Erros"
# Change Directory to the actual logs path
cd /home/nv8510/lognew
err_var=`grep -in "ORA-" *`

if[-n $var] then
echo "THESE ARE...

i want to learn this awk :0

I am trying to grep the oracle erros evry day from the logs file. My problem is :

-rw-r----- 1 tibcolm tibco 17438361 Apr 5 11:59 RetryService-RetryService.log
-rw-r----- 1 tibcolm tibco 245303...

No :( , but checkinG THAT now :)

---------- Post updated at 08:03 AM ---------- Previous update was at 07:49 AM ----------

Still not able to figure it iut from there , my case i want to create...

How to create a file in UNIX which is password protected ?


Thanks and Regards,
Neeraj

got it now , i thought + was for concatenation , but i was wrong it is used for many occurences.
thanks a lot ahamed

nv8510@:/home/nv8510>grep -o ^[0-9][0-9]\.[0-9][0-9]$ input_file
grep: illegal option -- o
usage: grep [-E|-F] [-c|-l|-q] [-bhinsvwx] -e pattern_list...
[-f pattern_file...] [file...]...

Yes Aahemd , thats the prb :(

---------- Post updated at 11:40 PM ---------- Previous update was at 11:39 PM ----------

It Will always be 2didit.2digit

DAta in the file :

10.5.67.2
19.23.45.6
12.222.34.4
23.24
12.34.45.4
24.45.56.7
16989.2657268.2687.2789
1234.45.56.67
1134.45

I want to display only 23.24 in the output.

I tried...

By Mistake i created a directory named "-lrt" in one of my working directories and now i am not able to delete it , please suggest hw to delete this directory now ?

Thanks in advance.

Hi ALL,
Having a input file address :

10.245.673.269
10.22.673.256
10.23.673.266
10.245.673.263
10.25.673.269

I just want to print the IP address which is having two digits at its second...

Thanks Anurag and Michael , its worked fin and i had a successfull deployment today :) thanks for your help.

Thanks Arung it is working , one more thing just i case i want to display these duplicate value and not to delete them , can you give me the command for the same ?

Hi All,
i need ti delete two duplicate processss which are running on the same device type (column 1) and port ID (column 2). here is the sample data
p1sc1m1 15517 11325 0 01:00:24 ? 0:00...