Home » RDBMS Server » Server Administration » password required to login as sysdba
password required to login as sysdba [message #205834] Mon, 27 November 2006 18:30 Go to next message
Messages: 1
Registered: November 2006
Location: USA
Junior Member
Oracle version
OS = Windows 2000 server

I have a domain account on a server and I am a member of
ORA_DBA and Adminstrator group

I open a command window and set
oracle_home and

However when I try to login without a password


SQL*Plus: Release - Production on Mon Nov 27 13:08:28 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: /as sysdba
ORA-01031: insufficient privileges

Is it possible that Oracle software was installed by a user who was not a part of the ora_dba group. In that case how do I find out which group
Re: password required to login as sysdba [message #205924 is a reply to message #205834] Tue, 28 November 2006 02:55 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Try to connect with "SYS/ AS SYSDBA". Hit ENTER when asked for a password.
Re: password required to login as sysdba [message #206979 is a reply to message #205834] Sat, 02 December 2006 22:59 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

also you can try
C:\>sqlplus " / as sysdba"

SQL*Plus: Release - Production on Sun Dec 3 08:58:09 2006

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release - Production
With the Partitioning, OLAP and Data Mining options

Re: password required to login as sysdba [message #207234 is a reply to message #206979] Mon, 04 December 2006 15:28 Go to previous message
Messages: 1
Registered: December 2006
Junior Member

you have two possibilities.

1. when you will connect to database without a password
- check that you a member of DBA-Group (local machine group)
- check your "$ORACLE_HOME/network/admin/sqlnet.ora"


2. (re)create a new password file with ORAPWD-Utility

2.1 recreate a new password file on UNIX (case sensitive)

prompt> orapwd file={$ORACLE_HOME}/dbs/orapw<SID> password=<new_password> [entries=5]
2.2 WINDOWS (ORACLE 9 backwards)

prompt> orapwd file={%ORACLE_HOME%}/database/PWD<SID>.ORA password=<new_password> [entries=5]

- from ORACLE 10g upwards, the password file stored on windows also in "{%ORACLE_HOME%}/dbs/"

- restart the services and you can use the new_password
("/ as sysdba")
Previous Topic: Oracle start/shutdown with non sysdba account
Next Topic: OracleXe and Visualstudio 2005
Goto Forum:

Current Time: Wed Oct 26 01:06:59 CDT 2016

Total time taken to generate the page: 0.11203 seconds