Home » RDBMS Server » Security » how to generate user and password manually
how to generate user and password manually [message #564637] Mon, 27 August 2012 04:36 Go to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
i forget my system password and i cant login to my database,and its not letting me in as sys/manager as sysdba

guys can you please let me know how to generate new user and password....
Re: how to generate user and password manually [message #564638 is a reply to message #564637] Mon, 27 August 2012 04:45 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
hi guys can you please let me know how to genearte passowrd file in 10g 32bit windows version......

thanks in advance
Re: how to generate user and password manually [message #564640 is a reply to message #564638] Mon, 27 August 2012 04:51 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
create a new password file with the orapwd utility, then you will be able to connect as sys with the sysdba role using whatever password you choose.
c:\users\john\home>where orapwd
c:\app\john\product\11.2.0\dbhome_1\BIN\orapwd.exe

c:\users\john\home>orapwd -help
Usage: orapwd file=<fname> entries=<users> force=<y/n> ignorecase=<y/n> nosysdba=<y/n>

  where
    file - name of password file (required),
    password - password for SYS will be prompted if not specified at command line,
    entries - maximum number of distinct DBA (optional),
    force - whether to overwrite existing file (optional),
    ignorecase - passwords are case-insensitive (optional),
    nosysdba - whether to shut out the SYSDBA logon (optional Database Vault only).

  There must be no spaces around the equal-to (=) character.

c:\users\john\home>

Re: how to generate user and password manually [message #564643 is a reply to message #564637] Mon, 27 August 2012 05:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you are on the database server with an OS account that is in the ORA_DBA group then you can always connect "/ as sysdba" (with no use of password file) and change SYSTEM password.

Regards
Michel
Re: how to generate user and password manually [message #564644 is a reply to message #564643] Mon, 27 August 2012 06:07 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
No iam not in the ORA_DBA group,and can you please tell me how to genearte the password file...

iam new to the DBA,really appriciate if you guide me to genearte new password file,so as to login as sysdba and then i reset the system password,onece i login

can you tell me the commands for the windows to generate password for windows....
Re: how to generate user and password manually [message #564647 is a reply to message #564644] Mon, 27 August 2012 06:15 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
can you please tell me the commands to genearte the password file for windows version....

thanks in advance
Re: how to generate user and password manually [message #564648 is a reply to message #564644] Mon, 27 August 2012 06:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
No iam not in the ORA_DBA group,


So ask you DBA, or sysadmin.

Quote:
can you please tell me how to genearte the password file...


Is this not what John showed you?

Quote:
iam new to the DBA,really appriciate if you guide me to genearte new password file,so as to login as sysdba and then i reset the system password,onece i login


Database 2 Day DBA
Oracle DBA Lite

Regards
Michel
Re: how to generate user and password manually [message #564650 is a reply to message #564648] Mon, 27 August 2012 06:47 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
can you please tell me is this right


command is below :

Open Command Prompt

Goto oracle_home\bin directory and execute below :

orapwd file=<location of password_file> password=manager entries=5

Then open sqlplus and login as

sys/manager as sysdba
Re: how to generate user and password manually [message #564651 is a reply to message #564650] Mon, 27 August 2012 06:51 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
but when iam following it give me error unable to open password file

C:\Users\administrator>cd C:\oracle\product\10.2.0\db_2\bin

C:\oracle\product\10.2.0\db_2\bin>orapwd file=C:\oracle\product\10.2.0\admin\orc
l password=manager entries=5

OPW-00001: Unable to open password-file
Re: how to generate user and password manually [message #564652 is a reply to message #564651] Mon, 27 August 2012 06:53 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
can you please tell me what changes should i do,where should i do changes
Re: how to generate user and password manually [message #564653 is a reply to message #564652] Mon, 27 August 2012 06:56 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You've been given enough hints. Now read for tyourself.
http://docs.oracle.com/cd/B19306_01/win.102/b14304/admin.htm#sthref281
Re: how to generate user and password manually [message #564654 is a reply to message #564652] Mon, 27 August 2012 06:57 Go to previous messageGo to next message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
is this not the right location of password file

please this the top urgent can anyone guide me through this....

watson iam following you but iam getting above error....
Re: how to generate user and password manually [message #564659 is a reply to message #564654] Mon, 27 August 2012 07:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is noting urgent in a forum but for you to read OraFAQ Forum Guide and not use IM/SMS speak.

Quote:
is this not the right location of password file


The answer is in the first sentence of the link John provided you.

Regards
Michel
Re: how to generate user and password manually [message #564663 is a reply to message #564654] Mon, 27 August 2012 07:21 Go to previous message
sam524
Messages: 77
Registered: July 2012
Location: sydney
Member
thanks for the documentation guys it really help me out .....
Previous Topic: Export Policies and Import to another database?
Next Topic: privileges for stats
Goto Forum:
  


Current Time: Thu Mar 28 08:46:45 CDT 2024