in reply to Re: Connect to Remote oracle DB
in thread Connect to Remote oracle DB

It's says "bash: sqlplus: command not found" When I used "`" backtick
my $memp = qx{ssh -o stricthostkeychecking=no $db_hosts `sqlplus -s $ +db_string<<EOF show parameter memory; exit EOF`};
it says " bash: ERROR:: command not found bash: change: command not found "

Replies are listed 'Best First'.
Re^3: Connect to Remote oracle DB
by riverron (Sexton) on Feb 16, 2012 at 04:08 UTC

    my first guess is you don't have the sqlplus binary in your PATH on the target server.

    have you tried running it from the command line?

    what do you get when you run:

    ssh -o StrictHostKeyChecking=no <your_db_host> sqlplus <your_connect_s +tring>
    on your *nix shell?

      it's says:bash: sqlplus: command not found But sqlplus is working fine on both my local host and remote db. Any way I Decided to use DBI ,Thank you very much for your great help.