Home » RDBMS Server » Security » SYS Password (Oracle 10.2.0.4.0 on Windows server 2003 enterprise edition )
SYS Password [message #514238] Sat, 02 July 2011 15:59 Go to next message
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....
Re: SYS Password [message #514239 is a reply to message #514238] Sat, 02 July 2011 16:11 Go to previous messageGo to next message
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?
Re: SYS Password [message #514240 is a reply to message #514239] Sat, 02 July 2011 16:18 Go to previous messageGo to next message
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 ?
Re: SYS Password [message #514241 is a reply to message #514240] Sat, 02 July 2011 16:21 Go to previous messageGo to next message
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.

Re: SYS Password [message #514242 is a reply to message #514241] Sat, 02 July 2011 16:35 Go to previous messageGo to next message
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.
Re: SYS Password [message #514243 is a reply to message #514242] Sat, 02 July 2011 16:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>It worked yesterday only.
Something changed.
Software does not spontaneously break.
Re: SYS Password [message #514261 is a reply to message #514242] Sun, 03 July 2011 04:48 Go to previous messageGo to next message
John Watson
Messages: 8922
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
Re: SYS Password [message #514304 is a reply to message #514261] Sun, 03 July 2011 15:26 Go to previous messageGo to next message
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.
Re: SYS Password [message #514305 is a reply to message #514304] Sun, 03 July 2011 15:46 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: SYS Password [message #514344 is a reply to message #514305] Mon, 04 July 2011 03:23 Go to previous messageGo to next message
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:

Re: SYS Password [message #514349 is a reply to message #514344] Mon, 04 July 2011 04:03 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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

Re: SYS Password [message #514352 is a reply to message #514349] Mon, 04 July 2011 04:16 Go to previous messageGo to next message
John Watson
Messages: 8922
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?
Re: SYS Password [message #514356 is a reply to message #514349] Mon, 04 July 2011 04:27 Go to previous messageGo to next message
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:

Re: SYS Password [message #514358 is a reply to message #514352] Mon, 04 July 2011 04:32 Go to previous messageGo to next message
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
Re: SYS Password [message #514360 is a reply to message #514358] Mon, 04 July 2011 04:48 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
and the command you used to vreate the passwordfile?
Re: SYS Password [message #514362 is a reply to message #514360] Mon, 04 July 2011 05:02 Go to previous messageGo to next message
raj9999
Messages: 49
Registered: June 2011
Member
orapwd file=C:\oracle\product\10.2.0\db_1\database\PWDtestdb.ora entries=5 password=nom321

Re: SYS Password [message #514376 is a reply to message #514362] Mon, 04 July 2011 06:38 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Well, that looks as though it should work. I can't suggest anything else. Sorry!
Re: SYS Password [message #514477 is a reply to message #514362] Tue, 05 July 2011 01:22 Go to previous messageGo to next message
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
Re: SYS Password [message #514763 is a reply to message #514477] Wed, 06 July 2011 06:47 Go to previous messageGo to next message
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
Re: SYS Password [message #515692 is a reply to message #514238] Tue, 12 July 2011 23:17 Go to previous messageGo to next message
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
Re: SYS Password [message #522775 is a reply to message #515692] Tue, 13 September 2011 12:20 Go to previous messageGo to next message
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)
Re: SYS Password [message #522776 is a reply to message #522775] Tue, 13 September 2011 12:37 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: User should be able to read all the objects of an user
Next Topic: os authentication issue
Goto Forum:
  


Current Time: Fri Mar 29 00:48:03 CDT 2024