Home » RDBMS Server » Security » Password file (merged)
Password file (merged) [message #256116] Fri, 03 August 2007 01:32 Go to next message
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
Re: PASSWORD FILE [message #256140 is a reply to message #256116] Fri, 03 August 2007 02:24 Go to previous messageGo to next message
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
Re: PASSWORD FILE [message #256257 is a reply to message #256140] Fri, 03 August 2007 10:33 Go to previous messageGo to next message
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


Re: PASSWORD FILE [message #256420 is a reply to message #256257] Sat, 04 August 2007 11:07 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

thanks dreamz for the help.
Password file [message #256961 is a reply to message #256116] Tue, 07 August 2007 05:06 Go to previous messageGo to next message
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
Re: Password file [message #256978 is a reply to message #256961] Tue, 07 August 2007 05:24 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: Password file [message #257198 is a reply to message #257094] Tue, 07 August 2007 13:34 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

thanks
Re: Password file [message #257615 is a reply to message #257198] Wed, 08 August 2007 15:21 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Did you figure that?
Previous Topic: Tracking down a user
Next Topic: IB_ENCODEDATE
Goto Forum:
  


Current Time: Sat Dec 07 04:32:28 CST 2024