Urgent Please help me out here!!!


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Urgent Please help me out here!!!
# 1  
Old 04-01-2010
Question 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...
# 2  
Old 04-02-2010
Suggest you take a look at:
Environment variables in Perl / use Env
# 3  
Old 04-05-2010
Hence Not working...
# 4  
Old 04-05-2010
Have you got the env perl module installed?
# 5  
Old 04-05-2010
Hi,

i have mention that we don't install DBI,DBD,ENV...etc.
please do let know any idea
Thanks,
Appu
# 6  
Old 04-05-2010
Quote:
Originally Posted by appu.dba
...please do let know any idea
...
You will need the ENV Perl module if you want to make your script work.

tyler_durden
# 7  
Old 04-05-2010
In the HP-UX Server, we are not allow to install any package for PERL.
That why i'm trying to set the given parameter.

i have already work out using DBI,DBD is working fine.

and the question it should be work with default package with coming under perl intallation and not includes ENV,DBD,DBI...etc packages in the BOX.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. 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... (1 Reply)
Discussion started by: Gurdza32
1 Replies

2. 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 ... (1 Reply)
Discussion started by: manpav
1 Replies

3. 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"... (4 Replies)
Discussion started by: naren nandale
4 Replies

4. 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)... (1 Reply)
Discussion started by: tush
1 Replies

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... (1 Reply)
Discussion started by: jyotirmoy21
1 Replies

6. 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 (4 Replies)
Discussion started by: himanshu1.singh
4 Replies

7. 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"... (3 Replies)
Discussion started by: sapan123
3 Replies

8. 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 Replies)
Discussion started by: sriny
3 Replies

9. 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 (3 Replies)
Discussion started by: balaji_prk
3 Replies
Login or Register to Ask a Question