Re: connect from windows
- From: "David Fitzjarrell" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "oratune@xxxxxxxxx" for DMARC)
- To: Maaz Anjum <maazanjum@xxxxxxxxx>, Brian Zelli <Brian.Zelli@xxxxxxxxxxxxxxx>
- Date: Thu, 24 Apr 2014 08:49:54 -0700 (PDT)
Windows installations create the ORA_DBA group.
David Fitzjarrell
Primary author, "Oracle Exadata Survival Guide"
On Thursday, April 24, 2014 9:48 AM, Maaz Anjum <maazanjum@xxxxxxxxx> wrote:
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]
>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] 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:
