Re: How login as sysdba with sqlnet.authentication=none

This probably will not work if domain server is not reachable or the authentication is set to NONE.

If you try to connect via a local listener with remote password file exclusive, you should be able to connect as sysdba:

sqlplus system/manager_at_service as sysdba

• Vlad

On 4/16/07, Richard J. Goulet <rgoulet_at_kanbay.com> wrote:
>
> It's 'connect "sys as sysdba"'
>
>
> ........................................................................
> .............................................................
> Kanbay
> Richard J. Goulet, Senior Oracle DBA
> 45 Bartlett ST | Marlborough, MA 01752 USA
> Tel: 508.573.1978 | Fax: 508.229.2019 | Cell: 508.742.5795
> rgoulet_at_kanbay.com
> ........................................................................
> .............................................................
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of GovindanK
> Sent: Monday, April 16, 2007 2:45 PM
> To: cemail_219_at_hotmail.com; oracle-l_at_freelists.org
> Subject: Re: How login as sysdba with sqlnet.authentication=none
>
> Solaris64 Bit 10gRel2
>
> $ cat sqlnet.ora
> #SQLNET.ORA Network Configuration File
> SQLNET.AUTHENTICATION_SERVICES=(NONE)
>
> $ sqlplus /nolog
> SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 12 17:49:20 2007
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
> SQL> connect / as sysdba
> ERROR:
> ORA-01031: insufficient privileges
> SQL> quit
>
> $ sqlplus "sys as sysdba"
> SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 13 11:17:02 2007
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
> Enter password:
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit
> Production With the Partitioning, OLAP and Data Mining options
> SQL>
>
> RMAN scripts connect since they connect using user/passwd using tns.
>
> HTH
> GovindanK
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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