Re: connect from windows
- From: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 23 Apr 2014 13:40:09 -0600
On 23/04/2014 1:25 PM, Zelli, Brian wrote:
Ok, I am trying to connect from windows to unix with sqlplus from the
command line.
I set the SID and enter
Sqlplus /nolog
SQL>connect /as sysdba
Gets me the ORA-12560:TNS:protocol adapter error
Simplistically,
That command syntax uses the 'bequeath adapter' which basically says
"Connect to the database instance via shared memory on the local machine".
To go across the network, you MUST use a network protocol (effectively
using the @alias or @host:port/service technique). The listener on the
other end must be operational and creates the server process that works
as your proxy.
That said, YMV but ... accessing the database across the network as
SYSDBA is generally considered a security risk, is generally flagged by
various audits to be disabled, and is generally a 'not good thing'.
/Hans
Other related posts:
