Search Results

I am running plsql using printf on a shell, but i am getting some strange error, can someone point what exactly am i missing,



$ echo $SHELL
/bin/bash
$ printf "
> SET serveroutput ON...

Hi All,

I am trying to achieve threading inside each process of multiprocessing. I have 2 queues one for multiprocess (process) & another inside each process. when i execute it got hung after...

Thanks a lot @clx perfectly Working !!!

Hi Team,

I have a wrapper script which i have pasted below, it internally calls one python script to generate Environmental in a file called /home/oracle/myenv.sh, when i execute this script...

Thanks a lot ... perfectly working !!

Hi Bakunin,
Thanks for the reply

- Hostlist usually less than 15 hosts only. So it wont go until 26
- I am using bash shell & linux OS
- I need a output in single line like i mentioned...

Hi All,
I have a input file as below. Input file may contain more hostlists.

sample Input file
$ cat hostlist.lst
cs18-db1-1-sjl
cs22-db1-1-was
na88-db1-1-chi
...

thanks RudiC & Scrutinizer perfectly working !!!!

Thanks for you reply, It throwing some code error. Can you pls check


$ cat aa
#!/bin/bash
set -x
nodecount=10
host=na7-db1-1-chi
IFS=- read -A H <<< "$host"
C=({A..Z})
for ((i=1;...

Hi Team,
Pls help to get the desired output.

I have a input like below

nodecount=10
host=na7-db1-1-chi


nodecount can be 10 or 8 based on this we need a output (in single line) like...

Thanks for your email,

My intention is to make use of only that password function inside the perl script & avoid from the password prompt each and every time

Regards
Kannan

thanks for your reply !

Sorry i forgot the attachment. Pls find the link to see the script.

https://drive.google.com/file/d/0B3Q72L1SBsJFOG5VM1ZCWmxKbzQ/edit?usp=sharing

Regards
Kannan

Thanks for your reply !

My intention is to ssh mutiple hosts from jump server without passing the password each and every time. We have perl script to accept the password & run to the mutliple...

Hi All,

I am currently writing script to get the details for lot of hosts from jump server. Means each and every time it will ssh to the host and get the information. To achieve that I need to...

Thanks all for the valuable reply !!!

thanks perfectly working !

Hi Team,

I am getting input like below

$ ps -ef | grep pmon | grep -v asm | grep -v grep
oracle 3246 1 0 00:03 ? 00:00:01 ora_pmon_racora1
oracle 4367 1 0 00:03 ? ...

Thanks a lot ... for your help !!!!

Thanks a lot for your reply ... But i got the output like below .. which means one disk is repeated in 2 .sql files. Thanks !!

$ more asm_disk_add_1.sql
set echo on timing on feedback on
spool...

Hi Team,
I have a input file like below

$ cat disklist.txt
disk1
disk2
disk3
disk4
disk5
disk6
disk7
disk8
disk9
diskA
diskB
diskC
diskD

I wanted to split this contents into...

Thanks all for the reply !!! its working fine !!!

Thanks for the reply. I am getting below error while using the above code

$ awk -v p="$(date --date '1 day ago' +'%a %b %d')" '$0 ~ p {f=1} f==1 && /ORA-/ {print}' alert_APDSPRD.log
date: illegal...

Thanks for the reply. simple grep statement will collect all the ORA- errors from alertlog file (Contains all records) .. But I need only previous day ORA- errors ...

Hi All,

I want to get the all ORA- related errors from attached logfile for previous day. Pls help. Thanks !

Regards
Kamal

Thanks a lot for your help