Home » RDBMS Server » Server Administration » Password file recreation (Oracle 10.2.0.1.0,Windows)
Password file recreation [message #350535] Thu, 25 September 2008 05:44 Go to next message
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
Re: Password file recreation [message #350537 is a reply to message #350535] Thu, 25 September 2008 05:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
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

Re: Password file recreation [message #350545 is a reply to message #350537] Thu, 25 September 2008 06:12 Go to previous messageGo to next message
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?

Re: Password file recreation [message #350552 is a reply to message #350545] Thu, 25 September 2008 06:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Execute an "alter user" on SYS to synchronize both.

Regards
Michel
Re: Password file recreation [message #350601 is a reply to message #350552] Thu, 25 September 2008 10:12 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

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

Re: Password file recreation [message #350607 is a reply to message #350601] Thu, 25 September 2008 10:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
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 Go to previous messageGo to next message
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.
Re: Password file recreation [message #350904 is a reply to message #350683] Sat, 27 September 2008 04:50 Go to previous messageGo to next message
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).
Re: Password file recreation [message #350912 is a reply to message #350904] Sat, 27 September 2008 08:58 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

what is OP taj?
Re: Password file recreation [message #350922 is a reply to message #350912] Sat, 27 September 2008 12:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OP= Original Poster.
A good link: http://www.acronymfinder.com/

Regards
Michel
Re: Password file recreation [message #350938 is a reply to message #350922] Sat, 27 September 2008 21:30 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
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
Re: Password file recreation [message #350968 is a reply to message #350949] Sun, 28 September 2008 07:03 Go to previous messageGo to next message
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)
Re: Password file recreation [message #350973 is a reply to message #350968] Sun, 28 September 2008 08:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
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
Re: Password file recreation [message #351468 is a reply to message #350973] Wed, 01 October 2008 00:50 Go to previous messageGo to next message
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
Re: Password file recreation [message #351471 is a reply to message #351468] Wed, 01 October 2008 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
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

Re: Password file recreation [message #351821 is a reply to message #351468] Fri, 03 October 2008 06:24 Go to previous message
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:
  


Current Time: Thu Dec 08 22:20:04 CST 2016

Total time taken to generate the page: 0.18399 seconds