Search Results

I have PERL code to connect to Oracle database using DBI.

e.g.

$PERL -e "use DBI; DBI->connect(qw(DBI:Oracle:db111 testu testpass));"



by using DBI , if remote DB added to tnsnames.ora ,...

we are using kerberos authentication for the Oracle database. For automation jobs we are adding service accounts to keytab. does anybody using Kerberos authentication for jobs running through CORN ?...

I am installing Authen::Krb5::Easy and during make test I am getting the follwing error :


kinit not ok 2
error was: could not get initial credentials: Cannot contact any KDC for...

but, after creating TAR using syntax above , during the exatrct :

e.g.

/opt/tmp/perl5.16.3/lib/site_perl/5.16.3/x86_64-linux/DBD/Oracle.pm


and after done with extract :


ls -la...

I am creating TAR from list of flies.


tar -cvf abc_xyz.tar -T /opt/oracle/file_list.lst

and I am getting the follwing error :


tar: Removing leading `/' from member names

how to fix...

gcc is 64-bit .


LD_RUN_PATH="/opt/oracle/product/11.2.0/racdb11204/lib" gcc -m32 -shared -O2 -L/usr/local/lib -fstack-protector Oracle.o dbdimp.o oci8.o -o blib/arch/auto/DBD/Oracle/Oracle.so...

I am installing Oracle DBD to PERL 5.16.3 and during make test , I am running into this error :rm -f blib/arch/auto/DBD/Oracle/Oracle.so
LD_RUN_PATH="/opt/oracle/product/11.2.0/racdb11204/lib" gcc...

I am writing a code like this in KSH .

#!/bin/ksh
echo is this SQL query ? yes or no
read answer
case $answer in
yes|Yes|y)
echo got a positive answer
...

In PERL , $0 variable displays program name ( if we use inside script) .likewise is there a way to display program name and it's arguments passed to script .

e.g.


test.pl -a1 -b3 -c4
...

I have PERL program( which uses diff modules inside the program) and running it using installed PERL ( PERL 5.8.8) on unix box.

Now I want to run these programs on a diff unix box , but, they...

I have dir structure like this :


/opt/oracle/product/abc/sqlplus/admin/
/opt/oracle/product/def/sqlplus/admin
/opt/oracle/product/ghi/sqlplus/admin
...

SSH altogether will be disabled. I am looking for other alternatives ( if anybody used / using now) ....

Thanks

Hi,

I am using SSH to execute unix commands on remote machines. But, SSH will be diabled soon and I am looking for other alternatives to execute remote scripts/commands, without SSH . any...

hi,

I am using PERL one liner for oracle database connection as :

$PERL -e "use DBI; DBI->connect(qw(DBI:Oracle:SID user passwd));"

is there a way to append select statement to this...

I tried to use this command in PERL code. when I run this on shell , it's working fine.

grep -v "^#" /oratab | awk -F: '$1 == "'$server'" {print $2}'

inside PERL

$ohome = `grep -v "^#"...

I have perl script and in the first line we are invoking .sh script to set ENV variables.

e..g

eval '. $envfile; exec $PERL -S $0 "$@"'

I want to change some of the env variables while the...

Thanks ... when copied from word doc, it added those characters.

Thanks

Hi,

I have perl code inside my script.



while (1) {
* * * * *print "Enter 'n' for New , 'e' for Existing or 'q' to quit: ";
* * * * *chomp($response = <STDIN>);
* * * * *die "Exiting...

regular ssh command ...


$ ssh oracle@server





Thanks

I trying to do ssh from server a to server b ( password less setup) ...it's failing with following error ...


debug1: SSH2_MSG_SERVICE_ACCEPT received
debug2: key: /opt/oracle/.ssh/identity (0)...

I have file like this ...


$ cat /etc/sysconfig/clock
ZONE="US/Arizona"
UTC=true
ARC=false


I want to get value of ZONE into variable and I am writing like this ..


d_var=`cat...

$ echo $SHELL
/bin/bash


when logging in we are setting environment using .sh script


#!/bin/bash
PERL=/opt/10gperl/perl-5.8.8/bin/perl; export PERL



later if we want to change the...

I am trying to copy file . On the remote host I have dir structure as ...

/opt/product/11.2.0/

and underneath 11.2.0 I have db and db112 dirs.. and there are sub dirs underneath db and db112.....

Thanks...

[[ /opt/oracle/product/11.2.0/racdb == /opt/oracle/product/11.2.0/* ]]

is there any special operators to match the above ?

Thanks

Hi,

I need help with search and replace for the following string using vi ..



if [[ "$ORACLE_HOME" = "/opt/oracle/product/11.2.0/racdb" || "$ORACLE_HOME" = "/opt/oracrs/gridsw/11202" ]];then...