OraFAQ Forum: Security » SYS Password

Home » RDBMS Server » Security » SYS Password (Oracle 10.2.0.4.0 on Windows server 2003 enterprise edition )

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

SYS Password [message #514238]

Sat, 02 July 2011 15:59

raj9999
Messages: 49
Registered: June 2011

Member

Hi,

I am not able to login in the database with sys user. when i am trying with sqlplus "/as sysdba" it is showing
ERROR:
ORA-01031: insufficient privileges.

& when i am trying with sqlplus sys as sysdba it is showing

ERROR:
ORA-01017: invalid username/password; logon denied.

I login with system user and changed the password of sys nd then tried login with sys but same result.

remote_login_passwordfile is set to NONE nd i am login through that user only by which i was always able to login.

Kindly help urgently....

Report message to a moderator

Re: SYS Password [message #514239 is a reply to message #514238]

Sat, 02 July 2011 16:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

When was last time "/ as sysdba" worked OK?
What changed since then?

Report message to a moderator

Re: SYS Password [message #514240 is a reply to message #514239]

Sat, 02 July 2011 16:18

raj9999
Messages: 49
Registered: June 2011

Member

It worked yesterday only.
Server admin has today created some new user id's but i guess it should not hamper our issue.
Also, i am logging with the same user as earlier.
Is there anything on the server side which can be checked ?

Report message to a moderator

Re: SYS Password [message #514241 is a reply to message #514240]

Sat, 02 July 2011 16:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is there anything on the server side which can be checked ?
sqlplus
/ as sysdba

above only works when logged onto DB Server as same OS user that owns Oracle software installation.

Report message to a moderator

Re: SYS Password [message #514242 is a reply to message #514241]

Sat, 02 July 2011 16:35

raj9999
Messages: 49
Registered: June 2011

Member

>above only works when logged onto DB Server as same OS user that owns Oracle software installation.

That's true.
It is the same user through which installation was done and i used to login with this user only.

Report message to a moderator

Re: SYS Password [message #514243 is a reply to message #514242]

Sat, 02 July 2011 16:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>It worked yesterday only.
Something changed.
Software does not spontaneously break.

Report message to a moderator

Re: SYS Password [message #514261 is a reply to message #514242]

Sun, 03 July 2011 04:48

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Quote:

Server admin has today created some new user id's

If your sysadmin has been messing about with the UIDs and GIDs you could get this problem: just because the OS user name and group name are those that installed the software, doesn't mean that the UIDs and GIDs haven't been changed.

You will need to set up password file authentication. Set your REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE, create a new password file, and connect with,
connect sys/password as sysdba

Report message to a moderator

Re: SYS Password [message #514304 is a reply to message #514261]

Sun, 03 July 2011 15:26

raj9999
Messages: 49
Registered: June 2011

Member

I tried login after creating a new password file but got the same error.

REMOTE_LOGIN_PASSWORDFILE has already been set to EXCLUSIVE.

Report message to a moderator

Re: SYS Password [message #514305 is a reply to message #514304]

Sun, 03 July 2011 15:46

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

You have to show what you are doing. Did you, for example, do this:

c:\users\john\home>sqlplus sys/oracle as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sun Jul 3 21:44:23 2011

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

orcl>

SayingQuote:

II tried login after creating a new password file but got the same error.

doesn't really explain what you did.

Report message to a moderator

Re: SYS Password [message #514344 is a reply to message #514305]

Mon, 04 July 2011 03:23

raj9999
Messages: 49
Registered: June 2011

Member

This is what i am trying to do...

C:\oracle\product\10.2.0\db_1>sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jul 4 13:45:06 2011

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

ERROR:
ORA-01031: insufficient privileges


Enter user-name:
C:\oracle\product\10.2.0\db_1>
C:\oracle\product\10.2.0\db_1>
C:\oracle\product\10.2.0\db_1>sqlplus sys/nom321 as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jul 4 13:45:15 2011

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

Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:

Report message to a moderator

Re: SYS Password [message #514349 is a reply to message #514344]

Mon, 04 July 2011 04:03

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What happens if you specify the database? Such as

sqlplus sys/nom321@database_name_here as sysdba
                  -------------------
                     ^
                     |
                  Right here

Report message to a moderator

Re: SYS Password [message #514352 is a reply to message #514349]

Mon, 04 July 2011 04:16

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

And what about the password file? Did you, for example, do this:

alter system set remote_login_passwordfile=exclusive;

and this:

orapwd file=%ORACLE_HOME%\database\PWDsid.ora password=nom321

where SID is the name of your instance? Please can you show the relevant parameters:

sho parameter instance_name
sho parameter remote_login_passwordfile

and the command you used to vreate the passwordfile?

Report message to a moderator

Re: SYS Password [message #514356 is a reply to message #514349]

Mon, 04 July 2011 04:27

raj9999
Messages: 49
Registered: June 2011

Member

Here it is the output

C:\oracle\product\10.2.0\db_1>sqlplus sys/nom321@testdb as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jul 4 14:46:22 2011

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

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:

Report message to a moderator

Re: SYS Password [message #514358 is a reply to message #514352]

Mon, 04 July 2011 04:32

raj9999
Messages: 49
Registered: June 2011

Member

Here is the output.

SQL> sho parameter instance_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- --------------
instance_name                        string      TESTDB
SQL>
SQL>
SQL> sho parameter remote_login_passwordfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------
remote_login_passwordfile            string      EXCLUSIVE

Also, the password file is already there at the
C:\oracle\product\10.2.0\db_1\database path
with name
PWDtestdb.ora

Report message to a moderator

Re: SYS Password [message #514360 is a reply to message #514358]

Mon, 04 July 2011 04:48

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Quote:

and the command you used to vreate the passwordfile?

Report message to a moderator

Re: SYS Password [message #514362 is a reply to message #514360]

Mon, 04 July 2011 05:02

raj9999
Messages: 49
Registered: June 2011

Member

orapwd file=C:\oracle\product\10.2.0\db_1\database\PWDtestdb.ora entries=5 password=nom321

Report message to a moderator

Re: SYS Password [message #514376 is a reply to message #514362]

Mon, 04 July 2011 06:38

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Well, that looks as though it should work. I can't suggest anything else. Sorry!

Report message to a moderator

Re: SYS Password [message #514477 is a reply to message #514362]

Tue, 05 July 2011 01:22

x-oracle
Messages: 380
Registered: April 2011
Location: gujarat

Senior Member

sctom try to do this

u install oracle on c so start it by this

C:\oracle\product\10.2.0\db_1> cd bin

C:\oracle\product\10.2.0\db_1\bin>sqlplus sys as sysdba

connected ..

i think its work on you

Report message to a moderator

Re: SYS Password [message #514763 is a reply to message #514477]

Wed, 06 July 2011 06:47

raj9999
Messages: 49
Registered: June 2011

Member

Shaan121,

That u do in case u get the error while intializing sqlplus.

Well i got the solution as below.

1. Make remote_login_passwordfile =exclusive
2. Shut down the database
3. Create New password file through orapwd
4. Add ORA_DBA group (Right click on My Computer=> manage=> Local Users and Groups ) to OS user ( from which u have tried to login as sys without password)
5. startup

Report message to a moderator

Re: SYS Password [message #515692 is a reply to message #514238]

Tue, 12 July 2011 23:17

fmfbakhtiari
Messages: 2
Registered: July 2011
Location: tehran

Junior Member

hi
you must create file orapwd again same allow:
>orapwd file=$ORACLE_HOME/dbs/orapw[SID] PASSWORD= entries=5

Report message to a moderator

Re: SYS Password [message #522775 is a reply to message #515692]

Tue, 13 September 2011 12:20

liziis
Messages: 1
Registered: September 2011
Location: denver

Junior Member

for ORA-01031: insufficient privileges, try recreating your password file

orapwd file=$ORACLE_HOME/dbs/orapw(put your db name here) password=abc (sys password)

Report message to a moderator

Re: SYS Password [message #522776 is a reply to message #522775]

Tue, 13 September 2011 12:37

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In addition to just repead the previous answer, you don't understand that password file has NOTHING to do with LOCAL connections "/ as sysdba", NOTHING.

Regards
Michel

Report message to a moderator

Previous Topic:	User should be able to read all the objects of an user
Next Topic:	os authentication issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 05:12:49 CST 2024