Oracle Database - How to connect SYS as SYSDBA without password

Card Puncher Data Processing

About

When you connect as sysdba issuing a 'CONNECT / AS SYSDBA', Oracle checks if your account is a member of the os group 'ORA_sid_DBA' or 'ORA_DBA' group.

Operating System Group UNIX User Group Windows User Group
OSDBA dba ORA_DBA
OSOPER oper ORA_OPER

Check

To make a user an administrative user simply:

SQLNET.AUTHENTICATION_SERVICES = (NTS)

  • Create a LOCAL user
  • Create a local NT group ORA_DBA or ORA_sid_DBA where 'sid' is in upper case
  • Add the user to the ORA_DBA or ORA_sid_DBA group
  • Check for registry variable called LOCAL in the 9.2 Oracle Home Key in the registry. If this is set, unset the registry variable.

That user should now be able to “connect / as sysdba”

Support

If the check requirements are not met, you receive an ORA-01031 error.

C:\Documents and Settings\gerardnico>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jun 9 14:28:12 2009

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

ERROR:
ORA-01031: insufficient privileges

Reference





Discover More
Card Puncher Data Processing
Oracle Database - How to change the password for the account SYS/SYSTEM ?

You must connect with the SYSDBA privilege. If you don't remember the sys password, you can perform a OS authentication. Check this article for more information : If you don't give the SYS password...
Card Puncher Data Processing
Oracle Database - Privileges

A user can connect with different levels of privileges: namely for the database: SYSDBA (the root or administrator of the database) and SYSOPER. SYSOPER allows a user to perform basic operational...
Card Puncher Data Processing
Oracle Database - User, Security

User User Description SYS The SYS user owns all base tables and user-accessable view of the data dictionary (Oracle configuration information). No Oracle user should ever alter (update, delete, or...



Share this page:
Follow us:
Task Runner