Urgent Please help me out here!!! Post: 302409480

Sponsored Content

Top Forums Shell Programming and Scripting Urgent Please help me out here!!! Post 302409480 by appu.dba on Thursday 1st of April 2010 09:54:16 AM

04-01-2010

Registered User

Urgent Please help me out here!!!

Hi,

Without using DBI/DBD, i need to run the given below script in PERL in different oracle databases in a single server.

PERL Script:

Code:

#!usr/bin/perl -w
 
$c=`ps -ef |grep -v grep|grep pmon|sed -e 's/.*_//|sort -u >dbname.log`;
$cnt=`ps -ef |grep -v grep|grep pmon|sed -e 's/.*_//|sort -u |awk 'END {print NR-0}'`;
$qry=`sqlplus "/as sysdba" <<EOF
select name from v\\\\$database;
exit;
EOF`;
$i=1;
while($i<=$cnt)
{
$dbn=`awk 'NR==$i' dbname.log`;
$dbname = trim($dbn);
$p=`cat /etc/oratab |grep $dbname|grep -v "#"|gawk -F: {print \$2'}`;
$ENV{'ORACLE_SID'}="$dbname";
$ENV{'ORACLE_HOME'}="$p";
print $qry;
$i++;
}
exit 0;
 
sub trim 
{
my $s = shift;
$s =~s/^\s+|\s+$//g;
return $s;
}

the given result is unable to export ORACLE_SID,ORACLE_HOME? so no output.one more question please let me know how to set this parameter ORACLE_SID,ORACLE_HOME and PATH.

Thanks,
Appu Ramu

Last edited by pludi; 04-01-2010 at 11:16 AM.. Reason: code tags, please...

appu.dba

View Public Profile for appu.dba

Find all posts by appu.dba

9 More Discussions You Might Find Interesting

1. Solaris

Need Help Urgent

Hi. My E250 server (Solaris 8) running oracle database gets hangup in between. I checked the logs in /var/adm/messages but could not find anything related to this. can anyone help me out? bala

2. UNIX for Advanced & Expert Users

URGENT,URGENT- Need help tape drive installation

Hi, I am trying to attach tape drive to sun V890 running Solaris 9 on it. I have installed HBA(qlogic) in slot 1 of 0-8 slots and booted the system. I do not see HBAin prtdiag output. The tape drive is not attached to HBA. The tape drive I am going to attach is Sony AIT3. 1.How can I make...

3. UNIX for Advanced & Expert Users

need help urgent...........

Hi friends.. I am using the below command to search few files from many folders which is under one folder.. i mean let say the path is A/B/C...and inside C...i have 1-10 folder... the below command is working fine.... for i in 1 3 5 7; do find /A/B/C/${i} -name "*.txt" -o -name "*.csv"...

4. Red Hat

urgent

abb 117.96.113.21 cgg 101.2.104.42 cgg 110.227.247.236 desk 203.20.35.28 png 1.39.242.241 png 1.39.242.241 rzx 101.2.104.42 rzx 115.246.160.36 abb 49.138.242.187 how to find the count of this file wtrto ip thnx in advance

5. Shell Programming and Scripting

Urgent!!

Hi I have a file containing DE 3'UTR in Homo sapiens alpha-1-B glycoprotein (A1BG), mRNA. SQ Sequence 216 BP; 37 A; 58 C; 69 G; 52 T; 0 other; DE 3'UTR in Homo sapiens alpha-1-B glycoprotein (A1BG), mRNA. SQ Sequence 1844 BP; 358 A; 483 C; 434 G; 569 T; 0 other; DE 3'UTR in Homo...

6. Shell Programming and Scripting

Need Urgent help

Hi friends, I need urgent help here: Issue: I need to create shell script that will find the files & throw an error through job (autosys) when file not found. Daily we use to receive 3 files from a system. Obstacles: 1) All 3 files names are same. 2) Timestamp is same. 3)...

7. Shell Programming and Scripting

Need urgent help

Hi geeks, I'm trying to write a below script, but it throws an error, please check and correct me. #!/bin/bash #The below script will extract the string error1 error2 and error3 and also it will count and list the occurrence count1='grep -i "error1" test.txt | wc -l' count2='grep -i "error2"...

8. Shell Programming and Scripting

Urgent !!

Hello All, I want to use scp for copying multiple files ( files locations are stored in an array ) from remote server from different locations without prompting password every time . I will supply password once and it should be able to copy every file mentioned in an array. eg :- array have ...

9. Shell Programming and Scripting

URGENT Reading a file and assessing the syntax shell script URGENT

I am trying to write a shell script which takes an input file as an arguement in the terminal e.g. bash shellscriptname.sh input.txt. I would like for the file to be read line by line each time checking if the .txt file contains certain words or letters(validating the syntax). If the line being...

LEARN ABOUT PHP

zgrep

ZGREP(1)						      General Commands Manual							  ZGREP(1)

NAME

       zgrep - search possibly compressed files for a regular expression

SYNOPSIS

       zgrep [ grep_options ] [ -e ] pattern filename...

DESCRIPTION

       Zgrep  invokes  grep  on  compressed  or  gzipped  files.   These  grep	options  will  cause  zgrep  to  terminate  with  an  error  code:
       (-[drRzZ]|--di*|--exc*|--inc*|--rec*|--nu*).  All other options specified are passed directly to grep.  If no file is specified,  then  the
       standard input is decompressed if necessary and fed to grep.  Otherwise the given files are uncompressed if necessary and fed to grep.

       If the GREP environment variable is set, zgrep uses it as the grep program to be invoked.

EXIT CODE

       2 - An option that is not supported was specified.

AUTHOR

       Charles Levert (charles@comm.polymtl.ca)

SEE ALSO

       grep(1), gzexe(1), gzip(1), zdiff(1), zforce(1), zmore(1), znew(1)

																	  ZGREP(1)