SQLPLUS from a remote server

Shell Programming and Scripting
1

Hi,
I am trying to connect to Oracle server (installed in HP UNIX) from some other HP UNIX server using sqlplus

Can you somebody advice me method to connect to Database without user ID and password field or atleast password field from Remote Server

Regards,
Giri

2

It is easy to connect to another UNIX server via ssh and then run and use sqlplus.

Tilen

3

I did not understand you, please explain it further

4

Let's say, you have 2 unix servers. The 1st one has installed the Oracle database and you wish to connect to this one to use sqlplus on it but from the 2nd server. On the 1st server you shall install the open-ssh utility and run the sshd service, and install the open-ssh utility on the 2nd server too. Then lets login into the 2nd server. Via ssh connect to the 1st server (ssh <user>@<1st_server_name>), type the password in and voila... you're connected to the 2nd server. Then just run the sqlplus application and start to work.

Does mybe that solve your problem?

Tilen

5

Thanks for the reply.

My requirement is, I want to use SQLPLUS in a batch job and usage and password is not allowed as per copmany's security polocy

So, I am checknig out for alternatives in connecting to Database with "sqlplus /" sort of option without Security viloation

6

Oh. Erm ... with the ssh-utility you can also execute a command on the remote machine without need of entering a password. That's verry useful for scripts.

For example: ssh <user>@<address> "<anny command>"

I think, you can run and use sqlplus from a script, on a remote machine. But this utility is for UNIX environment so if you want to test this logic on windows, I recommend you to install the Cygwin environment.