Re: connect from windows

  • From: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 23 Apr 2014 13:50:44 -0600

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@xxxxxxxxxx]
*Sent:* Wednesday, April 23, 2014 3:28 PM
*To:* Zelli, Brian; oracle-l (oracle-l@xxxxxxxxxxxxx)
*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 /@<DB> as sysdba 

*Stephan Uzzell*

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2014