Re: connect from windows

From: Maaz Anjum <maazanjum_at_gmail.com>
Date: Thu, 24 Apr 2014 11:48:03 -0400
Message-ID: <CA+zcOQ8CeqvuEedXPk_3KLumtBzRX7E-u47nPLvNfv8A9kfZTg_at_mail.gmail.com>



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_at_roswellpark.org>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_at_yahoo.com]
> *Sent:* Wednesday, April 23, 2014 4:18 PM
> *To:* Zelli, Brian; Uzzell, Stephan; oracle-l (oracle-l_at_freelists.org)
> *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_at_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_at_RoswellPark.org> wrote:
>
> Ok, I try that and get ORA-01031:insufficient privileges…….
>
>
>
>
>
> Brian
>
>
>
>
>
> *From:* Uzzell, Stephan [mailto:SUzzell_at_MICROS.COM <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*
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [
> mailto:oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>] *On
> Behalf Of *Zelli, Brian
> *Sent:* Wednesday, 23 April, 2014 15:26
> *To:* oracle-l (oracle-l_at_freelists.org)
> *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...

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 24 2014 - 17:48:03 CEST

Original text of this message