Re: remote access
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Sun, 10 May 2009 17:05:05 -0500
Message-ID: <N5INl.18868$8_3.5021_at_flpi147.ffdc.sbc.com>
Robert Klemme wrote:
>> Oracle 11g installed on Vista.
>> Standard port 1521.
>> Can connect locally using sqlplus
>> but not remotely.
>>
>> Is there a security setting that needs to be changed
>> within EM to allow this in the same way that Express
>> Edition has one? Searched settings and docs but no luck.
Date: Sun, 10 May 2009 17:05:05 -0500
Message-ID: <N5INl.18868$8_3.5021_at_flpi147.ffdc.sbc.com>
Robert Klemme wrote:
> On 10.05.2009 23:07, Chris P. Bacon wrote:
>> Oracle 11g installed on Vista.
>> Standard port 1521.
>> Can connect locally using sqlplus
>> but not remotely.
>>
>> Is there a security setting that needs to be changed
>> within EM to allow this in the same way that Express
>> Edition has one? Searched settings and docs but no luck.
> > I'd first check Vista's firewall. The port will be closed by default. > > Kind regards > > robert
is the listener configured on localhost 127.0.0.1 or the IP address of server? If you are going to be connecting remotely, I would recommend setting STATIC IP addresses (10.?.?.? or 192.168.?.?) and configuring the listener appropriately.
The other question would be what is your definition of "remotely"?
1) local network
2) internet->your local network?
You would need to understand the security risks with the latter before embarking on that ship... you could get sunk if you are not careful.
If you don't know what you are doing, you should get in touch with a security expert to assist you in properly configuring your network to handle it. Received on Sun May 10 2009 - 17:05:05 CDT