Unix/Linux Go Back    

Showing results 1 to 25 of 500
Search took 0.13 seconds.
Search: Posts Made By: radoulov
Forum: UNIX for Dummies Questions & Answers Linux 04-09-2015
Replies: 8
Views: 1,981
Posted By radoulov
Try: LC_ALL=C tree

Try:
LC_ALL=C tree
Forum: Shell Programming and Scripting Linux 03-04-2015
Replies: 23
Views: 1,772
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.
Forum: Shell Programming and Scripting Linux 03-04-2015
Replies: 23
Views: 1,772
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?
Forum: Shell Programming and Scripting Linux 03-04-2015
Replies: 23
Views: 1,772
Posted By radoulov
No, as far as I know ...

No, as far as I know ...
Forum: Shell Programming and Scripting Linux 03-04-2015
Replies: 23
Views: 1,772
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.
Forum: Shell Programming and Scripting Linux 03-04-2015
Replies: 23
Views: 1,772
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
...
Forum: Shell Programming and Scripting Linux 03-04-2015
Replies: 23
Views: 1,772
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)?
Forum: Shell Programming and Scripting Linux 03-04-2015
Replies: 23
Views: 1,772
Posted By radoulov
Try addning the ORACLE SID: my...

Try addning the ORACLE SID:

my $ORACLE_SID="your_sid";
$ENV{ORACLE_SID}=$ORACLE_SID;
Forum: Shell Programming and Scripting Linux 03-04-2015
Replies: 23
Views: 1,772
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;
Forum: Shell Programming and Scripting Linux 03-04-2015
Replies: 23
Views: 1,772
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...
Forum: Shell Programming and Scripting Linux 03-04-2015
Replies: 23
Views: 1,772
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.
Forum: Shell Programming and Scripting Linux 03-03-2015
Replies: 23
Views: 1,772
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:...
Forum: Shell Programming and Scripting Linux 02-18-2015
Replies: 7
Views: 1,131
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:...
Forum: Shell Programming and Scripting Linux 02-18-2015
Replies: 5
Views: 513
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
Forum: Shell Programming and Scripting Linux 02-18-2015
Replies: 5
Views: 513
Posted By radoulov
Try: sed '/^dns\.com$/,+2d' /tmp/temp.txt

Try:
sed '/^dns\.com$/,+2d' /tmp/temp.txt
Forum: Shell Programming and Scripting Linux 09-20-2014
Replies: 14
Views: 4,260
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
}<>'
Forum: UNIX for Dummies Questions & Answers Linux 09-15-2014
Replies: 14
Views: 1,649
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).
Forum: UNIX for Dummies Questions & Answers Linux 09-15-2014
Replies: 14
Views: 1,649
Posted By radoulov
You're welcome! Just use the correct forum :)

You're welcome! Just use the correct forum :)
Forum: UNIX for Dummies Questions & Answers Linux 09-15-2014
Replies: 14
Views: 1,649
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.
Forum: UNIX for Dummies Questions & Answers Linux 09-15-2014
Replies: 14
Views: 1,649
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...
Forum: UNIX for Dummies Questions & Answers Linux 09-15-2014
Replies: 14
Views: 1,649
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...
Forum: UNIX for Dummies Questions & Answers Linux 09-15-2014
Replies: 14
Views: 1,649
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 Linux 08-25-2014
Replies: 6
Views: 856
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).
Forum: Shell Programming and Scripting Linux 07-31-2014
Replies: 8
Views: 1,955
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:...
Forum: Shell Programming and Scripting Linux 07-31-2014
Replies: 8
Views: 1,955
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 08:01 AM.