in reply to Connect to Remote oracle DB

In what fashion does it not work? Do you get errors? Are there errors in the logs on the host? Do you know through some other means that you can connect to the database from the client?

True laziness is hard work

Replies are listed 'Best First'.
Re^2: Connect to Remote oracle DB
by charithd (Acolyte) on Feb 14, 2012 at 04:02 UTC
    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`};

    [download]
    it says " bash: ERROR:: command not found bash: change: command not found "
[reply]
[d/l]

      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>

      [download]
      on your *nix shell?

[reply]
[d/l]
        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.
[reply]
[d/l]

In Section Seekers of Perl Wisdom