OraFAQ Forum: Security » Password file (merged)

Home » RDBMS Server » Security » Password file (merged)

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

Password file (merged) [message #256116]

Fri, 03 August 2007 01:32

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

hi guys,

i created a password file with the following steps: (oracle_sid=bala01)

1. orapwd file=orapwdbala01 password=sys_pass entries=20

2. Alter SYSTEM SET remote_login_passwordfile=EXLUSIVE SCOPE=SPFILE;

When i tried to grant the new password to the user say:

grant sysdba to scott

im getting an error
error opening password file

Regards,
Balaji

Report message to a moderator

Re: PASSWORD FILE [message #256140 is a reply to message #256116]

Fri, 03 August 2007 02:24

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

Senior Member
Account Moderator

1/ Is password file in the correct directory?
2/ Did you restart the database?

Regards
Michel

Report message to a moderator

Re: PASSWORD FILE [message #256257 is a reply to message #256140]

Fri, 03 August 2007 10:33

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

$ cd $ORACLE_HOME/dbs
$ rm orapwQLINK3
$ orapwd file=orapwQLINK3 password=oracle entries=5
$ sqlplus sys as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Aug 3 15:30:57 2007

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

Enter password:

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

SQL> show parameter remote_login_passwordfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE
SQL> create user dreamz identified by dreamz;

User created.

SQL> grant sysdba,sysoper to dreamz;

Grant succeeded.
SQL>  select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
SYS                            TRUE  TRUE
DREAMZ                         TRUE  TRUE

Report message to a moderator

Re: PASSWORD FILE [message #256420 is a reply to message #256257]

Sat, 04 August 2007 11:07

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

thanks dreamz for the help.

Report message to a moderator

Password file [message #256961 is a reply to message #256116]

Tue, 07 August 2007 05:06

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

hi all,

I have problem while starting up my database on windows.
pls find attach the snapshot of the error from the attachment.

i created a password file with name=orapwdorcl9i password= oracle entries=20

when i tried to grant the new password to user scott im getting an error.

Kindly revert me with the solution.

Regards,
Balaji

Attachment: password file.doc
(Size: 79.50KB, Downloaded 2494 times)

Report message to a moderator

Re: Password file [message #256978 is a reply to message #256961]

Tue, 07 August 2007 05:24

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

Senior Member
Account Moderator

Continue on your previous topic.
You have to know that no sensible person will load a doc file.

Regards
Michel

[Updated on: Tue, 07 August 2007 05:27]

Report message to a moderator

Re: Password file [message #257094 is a reply to message #256978]

Tue, 07 August 2007 10:19

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

ORA-01990:	error opening password file 'string'
Cause:	An attempt to open the specified password file failed because of one of the following errors:

    * An operating system error occurred.
    * ORAPWD is already running, so the password file is locked.

The environment variables ORA_sid_PWFILE and ORA_PWFILE are not set.
Action:	Check for the above causes and correct as necessary.

Report message to a moderator