Re: connect from windows

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Wed, 23 Apr 2014 13:50:44 -0600
Message-ID: <53581994.4090103_at_gmail.com>

You might want to read the DBA manual that discusses this. There are a few implications, conditions, settings, assumptions and concerns.

The relevant section starts at
http://docs.oracle.com/cd/E11882_01/server.112/e25494/dba.htm#ADMIN11040 - in partcular, look at Figure 1-2 and the section "Selecting an Authentication Method for Database Administrators".

See also
http://docs.oracle.com/cd/E11882_01/network.112/e36292/authentication.htm#DBSEG99824 and see a related Forum discussion at
https://community.oracle.com/thread/2190725?tstart=0

/Hans

On 23/04/2014 1:39 PM, Zelli, Brian wrote:
>
> Ok, I try that and get ORA-01031:insufficient privileges.......
>
> Brian
>
> *From:*Uzzell, Stephan [mailto:SUzzell_at_MICROS.COM]
> *Sent:* Wednesday, April 23, 2014 3:28 PM
> *To:* Zelli, Brian; oracle-l (oracle-l_at_freelists.org)
> *Cc:* Uzzell, Stephan
> *Subject:* RE: connect from windows
>
> Pretty sure if you're setting the SID that only allows a local
> connection... to connect to a DB on a different server you'd need to
> go through the listener... connect /_at_<DB> as sysdba
>
> *Stephan Uzzell*
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 23 2014 - 21:50:44 CEST