| balaji |
Posted: Sep 23, 2008 11:33:03 AM |
Total Post: 162
Joined: May, 2008
|
I removed old password file and recreated new password file to connect to database as sys user with different password ( as oracle) .Below is the command for creating 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. 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 |
|
|
 GOPU |
| Posted: Sep 23, 2008 02:29:18 PM |  |
|
Total Post: 340
Joined: Apr, 2008
|
i think you need to restart the database.
|
|
|
|
|
| balaji |
| Posted: Sep 24, 2008 12:43:03 PM | |
|
Total Post: 162
Joined: May, 2008
|
hi gopu,
i tried as u said,but still i can able to login using sysdba as password for sys user
Regards,
Balaji
|
|
|
|
|
| sam |
| Posted: Sep 26, 2008 07:20:15 AM | |
|
Total Post: 1
Joined: May, 2008
|
try with any other password like 1234 or asdf any thing
|
|
|
|
|
| chai |
| Posted: Sep 26, 2008 07:50:53 AM | |
|
Total Post: 117
Joined: Jul, 2008
|
orapwd file=D:\oracle\product\10.2.0\db_1\database\PWD.ora password=oracle entries=5
In the above command, the naming format of password file on windows operating system should be(i think) PWD<sid>
orapwd file=D:\oracle\product\10.2.0\db_1\database\PWDtest password=oracle entries=5
Hope you have set remote_login_passwordfile parameter value to exclusive or shared.
Try with this let see whether it works or not.
|
|
|
|
|
| balaji |
| Posted: Sep 27, 2008 10:31:58 PM | |
|
Total Post: 162
Joined: May, 2008
|
i have tried as u said chai ,but still i am not able to connect database .im getting the below error.
ORA-01031: insufficient privileges
Regards,
|
|
|
|
|
| chai |
| Posted: Sep 29, 2008 02:30:57 AM | |
|
Total Post: 117
Joined: Jul, 2008
|
ORA-01031: insufficient privileges
Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. When Trusted Oracle is configure in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the current login.
Action: Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the the appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label.
Is it throwing error for sys user?
|
|
|
|
|
| chai |
| Posted: Sep 29, 2008 02:36:08 AM | |
|
Total Post: 117
Joined: Jul, 2008
|
Just try creating password file once again.
step 1: shut down database. create a password file. start the database.
step 2: shut down database. set the parameter and restart the database.
step 3: Not mandatory step. Sometimes if passowrd file is not working comment the line given below in sqlnet.ora
#SQLNET.AUTHENTICATION_SERVICES= (NTS) save and exit.
step 4: Login to database.
|
|
|
|
|
| balaji |
| Posted: Nov 08, 2008 08:28:15 PM | |
|
Total Post: 162
Joined: May, 2008
|
thanks for your information.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
