OraFAQ Forum: Security » how to generate user and password manually

Home » RDBMS Server » Security » how to generate user and password manually

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

how to generate user and password manually [message #564637]

Mon, 27 August 2012 04:36

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....

Report message to a moderator

Re: how to generate user and password manually [message #564638 is a reply to message #564637]

Mon, 27 August 2012 04:45

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

Report message to a moderator

Re: how to generate user and password manually [message #564640 is a reply to message #564638]

Mon, 27 August 2012 04:51

John Watson
Messages: 8968
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>

Report message to a moderator

Re: how to generate user and password manually [message #564643 is a reply to message #564637]

Mon, 27 August 2012 05:43

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

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

Report message to a moderator

Re: how to generate user and password manually [message #564644 is a reply to message #564643]

Mon, 27 August 2012 06:07

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....

Report message to a moderator

Re: how to generate user and password manually [message #564647 is a reply to message #564644]

Mon, 27 August 2012 06:15

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

Report message to a moderator

Re: how to generate user and password manually [message #564648 is a reply to message #564644]

Mon, 27 August 2012 06:17

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

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

Report message to a moderator

Re: how to generate user and password manually [message #564650 is a reply to message #564648]

Mon, 27 August 2012 06:47

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

Report message to a moderator

Re: how to generate user and password manually [message #564651 is a reply to message #564650]

Mon, 27 August 2012 06:51

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

Report message to a moderator

Re: how to generate user and password manually [message #564652 is a reply to message #564651]

Mon, 27 August 2012 06:53

sam524
Messages: 77
Registered: July 2012
Location: sydney

Member

can you please tell me what changes should i do,where should i do changes

Report message to a moderator

Re: how to generate user and password manually [message #564653 is a reply to message #564652]

Mon, 27 August 2012 06:56

John Watson
Messages: 8968
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

Report message to a moderator

Re: how to generate user and password manually [message #564654 is a reply to message #564652]

Mon, 27 August 2012 06:57

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....

Report message to a moderator

Re: how to generate user and password manually [message #564659 is a reply to message #564654]

Mon, 27 August 2012 07:13

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

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

Report message to a moderator

Re: how to generate user and password manually [message #564663 is a reply to message #564654]

Mon, 27 August 2012 07:21

sam524
Messages: 77
Registered: July 2012
Location: sydney

Member

thanks for the documentation guys it really help me out .....

Report message to a moderator

Previous Topic:	Export Policies and Import to another database?
Next Topic:	privileges for stats

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 06:35:36 CDT 2025