Password file recreation [message #350535] |
Thu, 25 September 2008 05:44 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
balaji1482
Messages: 312 Registered: July 2007 Location: INDIA
|
Senior Member |
![YES](/forum/theme/orafaq/images/yahoo.png)
|
|
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 #350938 is a reply to message #350922] |
Sat, 27 September 2008 21:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
balaji1482
Messages: 312 Registered: July 2007 Location: INDIA
|
Senior Member |
![YES](/forum/theme/orafaq/images/yahoo.png)
|
|
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68680 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 #351471 is a reply to message #351468] |
Wed, 01 October 2008 01:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68680 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
|
|
|
|