Re: connect from windows
- From: Maaz Anjum <maazanjum@xxxxxxxxx>
- To: Brian Zelli <Brian.Zelli@xxxxxxxxxxxxxxx>
- Date: Thu, 24 Apr 2014 11:48:03 -0400
Is the user you are connect to the windows server part of the "dba" group?
I can't recall the actual name of the group under windows, its either "dba"
or "ora_dba".
On Thu, Apr 24, 2014 at 11:38 AM, Zelli, Brian
<Brian.Zelli@xxxxxxxxxxxxxxx>wrote:
> Ok, the funny thing is I can connect with my 10g instances that way but
> not the 11g. I checked the sqlnet’s on both instances and they are the
> same. Why does 10g work and not 11g. I still get insufficient privileges……
>
>
>
>
>
> Brian
>
>
>
>
>
> *From:* David Fitzjarrell [mailto:oratune@xxxxxxxxx]
> *Sent:* Wednesday, April 23, 2014 4:18 PM
> *To:* Zelli, Brian; Uzzell, Stephan; oracle-l (oracle-l@xxxxxxxxxxxxx)
> *Subject:* Re: connect from windows
>
>
>
> And you don't have sufficient privileges on Windows. Your unix/linux
> account isn't associated with the ORA_DBA group in Windows so O/S
> authentication for SYS (/ as sysdba) fails. You can login across the
> network with the actual SYS password:
>
> sqlplus sys/rapunzel@tower as sysdba
>
> as an example and you should get connected.
>
> I suspect the sqlnet.ora on the Windows server is set to use NTS
> authentication.
>
>
>
>
>
> David Fitzjarrell
> Primary author, "Oracle Exadata Survival Guide"
>
> On Wednesday, April 23, 2014 1:40 PM, "Zelli, Brian" <
> Brian.Zelli@xxxxxxxxxxxxxxx> wrote:
>
> Ok, I try that and get ORA-01031:insufficient privileges…….
>
>
>
>
>
> Brian
>
>
>
>
>
> *From:* Uzzell, Stephan [mailto:SUzzell@xxxxxxxxxx <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*
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [
> mailto:oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx>] *On
> Behalf Of *Zelli, Brian
> *Sent:* Wednesday, 23 April, 2014 15:26
> *To:* oracle-l (oracle-l@xxxxxxxxxxxxx)
> *Subject:* connect from windows
>
>
>
> 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
>
>
>
> Why doesn’t this work? I’ve been googling and come up empty. Is there
> any way to get this to work?
>
>
>
> Brian
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
>
--
A life yet to be lived...
Other related posts:
