OraFAQ Forum: Server Administration » Password file recreation

Home » RDBMS Server » Server Administration » Password file recreation (Oracle 10.2.0.1.0,Windows)

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

Password file recreation [message #350535]

Thu, 25 September 2008 05:44

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

I removed old password file and recreated new password file to connect to database as sys user with different password ( oracle as password) .Below is the command which i created i password file on windows.

orapwd file=D:\oracle\product\10.2.0\db_1\database\PWD.ora password=oracle entries=5

When i connect using sys as sysdba and password as sysdba i was still able to connect to the database after recreating password file . But i dont want that to happen that. I want sys user to connect only using 'oracle' as password.(which i have set it in the password file creation)

can anybody tell me how to do that??

Regards,
Balaji

Report message to a moderator

Re: Password file recreation [message #350537 is a reply to message #350535]

Thu, 25 September 2008 05:50

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do you mean you connect without password or with a password that is not oracle?

Regards
Michel

Report message to a moderator

Re: Password file recreation [message #350545 is a reply to message #350537]

Thu, 25 September 2008 06:12

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

i can able to connect with oracle as password as well as sysdba as password for 'sys' user after recreating password file.

Do i need to shutdown the database before creating password file?

Report message to a moderator

Re: Password file recreation [message #350552 is a reply to message #350545]

Thu, 25 September 2008 06:44

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Execute an "alter user" on SYS to synchronize both.

Regards
Michel

Report message to a moderator

Re: Password file recreation [message #350601 is a reply to message #350552]

Thu, 25 September 2008 10:12

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

i dont get you michel what you are saying.Please come again with thesteps.

Report message to a moderator

Re: Password file recreation [message #350607 is a reply to message #350601]

Thu, 25 September 2008 10:34

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

alter user sys identified by oracle;

Regards
Michel

[Updated on: Thu, 25 September 2008 10:34]

Report message to a moderator

Re: Password file recreation [message #350683 is a reply to message #350601]

Thu, 25 September 2008 22:04

ora110
Messages: 42
Registered: September 2007
Location: China

Member

pls check your sqlnet.ora file。
sqlnet.authentication_services=none
It force you connecting the database using a password.

Report message to a moderator

Re: Password file recreation [message #350904 is a reply to message #350683]

Sat, 27 September 2008 04:50

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Yes, your right but this is not OP looking for.

As michal suggestion "alter user sys identified by oracle" will help in OP doubt.

OP want to connect only with ORACLE(password).

Report message to a moderator

Re: Password file recreation [message #350912 is a reply to message #350904]

Sat, 27 September 2008 08:58

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

what is OP taj?

Report message to a moderator

Re: Password file recreation [message #350922 is a reply to message #350912]

Sat, 27 September 2008 12:04

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

OP= Original Poster.
A good link: http://www.acronymfinder.com/

Regards
Michel

Report message to a moderator

Re: Password file recreation [message #350938 is a reply to message #350922]

Sat, 27 September 2008 21:30

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

hi michel, i have executed the 'alter user' command. after that when trying to connect database using oracle as password, it is not connecting to database and as sysdba indeed.

below is the error im getting while trying to connect database.

ORA-01031: insufficient privileges

i did changes in sqlnet.ora

sqlnet.authentication_services=none

Regards,

[Updated on: Sat, 27 September 2008 21:34]

Report message to a moderator

Re: Password file recreation [message #350949 is a reply to message #350938]

Sun, 28 September 2008 00:57

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

i have executed the 'alter user' command. after that when trying to connect database using oracle as password, it is not connecting to database and as sysdba indeed.

Don't describe what you did, post it.
You miss something but we can't see it as you don't and can't tell us what it is because you miss it.

So restart from the beginning, put back NT in sqlnet.authentication_services, connect as sysdba, change SYS password to oracle, set remote_login_passwordfile to exclusive, recreate the password file with password oracle.

Note that password file is used ONLY for remote connection not local one.

Regards
Michel

Report message to a moderator

Re: Password file recreation [message #350968 is a reply to message #350949]

Sun, 28 September 2008 07:03

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

i did all the steps which u have said.but im still getting the same error. (insufficent privileges)

Report message to a moderator

Re: Password file recreation [message #350973 is a reply to message #350968]

Sun, 28 September 2008 08:16

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Don't describe what you did, post it.
You miss something but we can't see it as you don't and can't tell us what it is because you miss it.

Regards
Michel

Report message to a moderator

Re: Password file recreation [message #351468 is a reply to message #350973]

Wed, 01 October 2008 00:50

naveenmelbourne
Messages: 15
Registered: August 2007

Junior Member

Hi,

It could be silly reply.
Is parameter set to REMOTE_LOGIN_PASSWORD=EXCLUSIVE?

could you please check this. I might be wrong. But just an idea

Thank you

Naveen

Report message to a moderator

Re: Password file recreation [message #351471 is a reply to message #351468]

Wed, 01 October 2008 01:01

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

[quote title=Michel Cadot wrote on Sun, 28 September 2008 07:57]

Quote:

So restart from the beginning, put back NT in sqlnet.authentication_services, connect as sysdba, change SYS password to oracle, set remote_login_passwordfile to exclusive, recreate the password file with password oracle.

I hope OP did it as he said:

Quote:

i did all the steps which u have said

But of course, he did not prove he did it.

Regards
Michel

Report message to a moderator

Re: Password file recreation [message #351821 is a reply to message #351468]

Fri, 03 October 2008 06:24

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Sorry michel, i havnt tried your steps yet.Was busy in other work.Will ping you once i do all the steps.

Thanks & Regards,
Balaji

[Updated on: Fri, 03 October 2008 06:30]

Report message to a moderator

Previous Topic:	Parents key not found
Next Topic:	Safely remove OCM (ORACLE_OCM) after applying patch set 3

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 02:03:54 CDT 2024