Without using DBI/DBD, i need to run the given below script in PERL in different oracle databases in a single server.
PERL Script:
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...
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)
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)
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)
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)
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)
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)
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)
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)
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
LEARN ABOUT DEBIAN
dbd::firebirdembedded
FirebirdEmbedded(3pm) User Contributed Perl Documentation FirebirdEmbedded(3pm)NAME
DBD::FirebirdEmbedded - embedded Firebird server (and client)
SYNOPSIS
use DBI;
$dbh = DBI->connect("dbi:FirebirdEmbedded:db=$dbname", undef, undef);
# See the DBI module documentation for full details
DESCRIPTION
DBD::FirebirdEmbedded is a variant of DBD::FirebirdEmbedded, linked with the Firebird embedded library, libfbembed. In addition to the
ability to work with remote Firebird servers (which DBD::FirebirdEmbedded has, being linked with the Firebird client library, libfbclient),
DBD::FirebirdEmbedded can be used to work with Firebird databases without the need of a dedicated Firebird server.
The following things should be set up first:
Username/password
These should be unset. Both in the "DBI->connection(...)" call and in the environment ("ISC_USER", "ISC_PASSWORD", "DBI_USER",
"DBI_PASSWORD" variables).
Firebird lock directory
The "FIREBIRD_LOCK" environment variable should be set to some place where the process can write. Note that if you plan for several
processes to access the database file directly, they all should have "FIREBIRD_LOCK" set to the same directory, or else database
corruption will occur.
No "host" in the DSN
Obviously, do not set any host when calling "DBI->connection(...)", not even "localhost".
Permissions to read/write the database
Obviously, the process needs to be able to read/write the database file.
COMPARISON WITH DBD ::FIREBIRD
DBD::FirebirdEmbedded provides exactly the same functionality as the Firebird server of the same version as the libfbembed library. It
still can work with remote datases, in which case the use is exactly the same (DSN, environment) as with the regular DBD::FirebirdEmbedded.
Pros
Standalone work with Firebird databases
No need to setup/administer a Firebird server. All the server functionality is available via the libfbembed library. Shared access to
databases is still possible (but read "Firebird lock directory" above).
No network latency
Working directly with the database file elliminates possible network delays (even if the server is on the local host).
Cons
Memory footprint
The libfbembed library contains a fully functional Firebird server and is therefore bigger than the ordinary client library,
libfbclient.
Setup complexity
It is very important to make sure that all processes that access a given database use the same lock directory. See "Firebird lock
directory" above.
SEE ALSO
DBD::FirebirdEmbedded
perl v5.14.2 2011-11-15 FirebirdEmbedded(3pm)