OraFAQ Forum: Server Administration » password required to login as sysdba

Home » RDBMS Server » Server Administration » password required to login as sysdba

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

password required to login as sysdba [message #205834]

Mon, 27 November 2006 18:30

orcldba2001
Messages: 1
Registered: November 2006
Location: USA

Junior Member

Oracle version 9.2.0.4.0
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
oracle_sid

However when I try to login without a password

sqlplus

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

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

Enter user-name: /as sysdba
ERROR:
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

Report message to a moderator

Re: password required to login as sysdba [message #205924 is a reply to message #205834]

Tue, 28 November 2006 02:55

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Try to connect with "SYS/ AS SYSDBA". Hit ENTER when asked for a password.

Report message to a moderator

Re: password required to login as sysdba [message #206979 is a reply to message #205834]

Sat, 02 December 2006 22:59

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi
also you can try

C:\>sqlplus " / as sysdba"

SQL*Plus: Release 10.1.0.2.0 - 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 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>

Report message to a moderator

Re: password required to login as sysdba [message #207234 is a reply to message #206979]

Mon, 04 December 2006 15:28

hmunke
Messages: 1
Registered: December 2006

Junior Member

hi,

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"

SQLNET.AUTHENTICATION_SERVICES=(NTS, ...)

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]
or
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")

Report message to a moderator

Previous Topic:	Oracle start/shutdown with non sysdba account
Next Topic:	OracleXe and Visualstudio 2005

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:55:04 CDT 2024