Using oracle easy connect does it really connect to the remote DB

oraclesqlplus

I tried connecting to remote host db using :

 sqlplus abc/abc@hostname1:1000/ABC

And tried printing

!hostname

it still shows me local hostname from which I am running and not HOSTNAME1.

So if I want statistics or run a script on that remote host .. Would it not do that..
i.e. Do I actually get data from remote host?

Is it bcoz !hostname is not a linux command and not a DB command?

Best Answer

The answer is very simple. The ! prefix in sqlplus executes the following text as a command in the local shell.

In your case it's executing the Unix hostname command locally.

Query v$instance to check the name of the machine you're connected to.

There are ways to execute local Unix commands via the database, but it's seen as a huge security hole, so I won't document them here.

ssh (assuming Unix) into the database host instead.

Related Solutions

Sqlplus consuming 99% CPU

The Oracle client version, strace output and system uptime details combined indicate this could be Oracle bug 4612267 for which a patch is available. The problem is supposed to be resolvable by either rebooting or applying the patch.

user@server:~ $ uptime
  9:54am  up 254 days  0:26,  5 users,  load average: 1.39, 1.56, 1.75
user@server:~ $ genezi -v
Client Shared Library 32-bit - 10.02.00.01.00

I had requested the patch be applied to our server to confirm if the patch fixed the issue. Unfortunately someone randomly rebooted the server before the patch could be applied - end result is that sqlplus is functioning again, which is good for me, but means I can't confirm if the patch would have fixed the issue without a reboot.

Cannot remotely connect to oracle express

More often than not, a firewall on the database vm is the culprit. You can test this with

telnet oraclehost 1521

from your mac. This should give a quick response. If it does not give a quick response, like not response at all, a firewall is blocking the request. In that case allow traffic on port 1521, or disable the firewall.

Best Answer

Related Solutions

Sqlplus consuming 99% CPU

Cannot remotely connect to oracle express

Related Question