Search Results

Search: Posts Made By: radoulov
12,438
Posted By radoulov
Try: LC_ALL=C tree
Try:
LC_ALL=C tree
5,520
Posted By radoulov
You provided two values for sid, is the second...
You provided two values for sid, is the second one correct?
my $sid = "dbd";
Please just post the exact text from your terminal including the commands executed.
5,520
Posted By radoulov
Could you post the exact output from your...
Could you post the exact output from your terminal from both the successful and the failing execution?
5,520
Posted By radoulov
No, as far as I know ...
No, as far as I know ...
5,520
Posted By radoulov
Double check the SQL statement: select tname...
Double check the SQL statement:
select tname from tab where rownum <6
Try to execute it from some other clinet (like sqlplus) with the user defined in the Perl script.
5,520
Posted By radoulov
I suppose you'll need to change you...
I suppose you'll need to change you LD_LIBRARY_PATH when switching between Oracle versions.
I would use a wrapper shell script to invoke the Perl script correctly,something like this:
#!/bin/bash
...
5,520
Posted By radoulov
Do you get the error while executing the script...
Do you get the error while executing the script interactively - on the command line - or you get it on a scheduled execution (via cron)?
5,520
Posted By radoulov
Try addning the ORACLE SID: my...
Try addning the ORACLE SID:

my $ORACLE_SID="your_sid";
$ENV{ORACLE_SID}=$ORACLE_SID;
5,520
Posted By radoulov
export is a shell builtin, remove the line that...
export is a shell builtin, remove the line that starts with "export" and change the declaration like this:
my $ORACLE_HOME = "/oracle/product/10.2.0";
$ENV{ORACLE_HOME} = $ORACLE_HOME;
5,520
Posted By radoulov
No, you need: my $ORACLE_HOME =...
No, you need:
my $ORACLE_HOME = "/oracle/product/10.2.0";
#You may also need to set the ORACLE SID
#my $ORACLE_SID="your_sid";

$ENV{ORACLE_HOME}=$ORACLE_HOME;
# Uncomment if you set ORACLE SID...
5,520
Posted By radoulov
Just put them on top of your script. See orafaq...
Just put them on top of your script. See orafaq (http://www.orafaq.com/wiki/Perl) "Setting the Oracle environment" for more.
5,520
Posted By radoulov
The error indicates that the Perl script is...
The error indicates that the Perl script is executed in a different environment (most probably via cron). Make sure all necessary Oracle related variables are set before invoking the Perl script:...
3,615
Posted By radoulov
You could try something like this: arr1=(a1...
You could try something like this:

arr1=(a1 b1 c1)
arr2=(a2 b2 c2)

a() {
typeset -n _my_arr1=$1 _my_arr2=$2
printf '%s\n' first: "${_my_arr1[@]}"
printf '%s\n' second:...
1,228
Posted By radoulov
Following up on MadeInGermany's more standard sed...
Following up on MadeInGermany's more standard sed solution,
I suppose the OP needs something like this:
sed '/^dns\.com$/ {N;N;d;}' /tmp/temp.txt
1,228
Posted By radoulov
Try: sed '/^dns\.com$/,+2d' /tmp/temp.txt
Try:
sed '/^dns\.com$/,+2d' /tmp/temp.txt
6,120
Posted By radoulov
With Perl: ls -lh | perl -e' @l{ K, M, G, T,...
With Perl:
ls -lh | perl -e'
@l{ K, M, G, T, P, E, Z, Y } = ( 1 .. 8 );
print sort {
($aa) = $a =~ /(\w)\s+/;
($bb) = $b =~ /(\w)\s+/;
$l{$aa} <=> $l{$bb} || $a <=> $b
}<>'
4,111
Posted By radoulov
Either use a VM with Linux and ask here or, if...
Either use a VM with Linux and ask here or, if you choose Windows, post on the Oracle Forums (https://community.oracle.com/community/database/general_questions/installation).
4,111
Posted By radoulov
You're welcome! Just use the correct forum :)
You're welcome! Just use the correct forum :)
4,111
Posted By radoulov
Yes, you can. You can also use Oracle VirtualBox...
Yes, you can. You can also use Oracle VirtualBox on Windows to setup
a VM with Oracle Linux (or CentOS) and install Oracle Database on it.
4,111
Posted By radoulov
Yes, you may be able to install Oracle 11.2 XE...
Yes,
you may be able to install Oracle 11.2 XE (Express Edition) on Ubuntu,
but it's still not supported.
As the post suggests, you need to install oracle-xe-11.2.0-1.0.x86_64.rpm, not only the...
4,111
Posted By radoulov
As I said, you should use a supported platform...
As I said, you should use a supported platform (not Debian/Ubuntu!).
You can use either the official documentation (http://docs.oracle.com/database/121/LTDQI/E54543-03.pdf) or the quick guides on...
4,111
Posted By radoulov
You have installed only the client. You're not...
You have installed only the client. You're not able to connect as there's no database ...
Oracle Database Server is not supported on Ubuntu, you can use a free supported
platform like Oracle Linux.
Forum: Linux 08-25-2014
1,695
Posted By radoulov
Check Troubleshooting Guide for ORA-12545 /...
Check Troubleshooting Guide for ORA-12545 / TNS-12545 Connect failed because target host or object does not exist (Doc ID 553328.1) on MOS (https://www.unix.com/support.oracle.com).
6,667
Posted By radoulov
For multi-line output use a loop: ...
For multi-line output use a loop:
zsh-5.0.2[user]% awk 'BEGIN {
while (("ls /etc | head" | getline _out) > 0)
print "Got:", _out
}'
Got: alternatives
Got: bash.bash_logout
Got:...
6,667
Posted By radoulov
You can store the output of an external command...
You can store the output of an external command invoked from inside awk,
but you should not use the system function for that:
zsh-5.0.2[user]% awk 'BEGIN { "date" | getline dt; print "Got", dt }'...
Showing results 1 to 25 of 500

 
All times are GMT -4. The time now is 10:47 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy