Where is password file in oracle 11g

In the past, many people were not aware of the simple fact that Oracle passwords were not case-sensitive. In Oracle 11g, passwords became case-sensitive. The Oracle 11g password file can store passwords as case-sensitive or case-insensitive. The password file creation utility evaluates the new parameter ignorecase to allow case-sensitive passwords or restrict passwords to case insensitivity.

In order to create a password file with orapwd, which allows case-sensitive passwords, set ignorecase to N. Feel free to ask questions on our Oracle forum. Verify experience! Please help. It is possible to connect to the database without specifying a password. Once you've done that you can then reset the passwords. I'm assuming that you've installed the database on your machine; if not you'll first need to connect to the machine the database is running on.

Ensure your user account is a member of the dba group. How you do this depends on what OS you are running. This should log you in to the database as SYS. Note: I haven't tried any of this on Oracle 12c; I'm assuming they haven't changed things since Oracle 11g. One more check, while oracle installation and database confiuration assistant setup, if you configure any database then you might have given password and checked the same password for all other accounts..

If so, then you try with the password which you have given in your database configuration assistant setup. At the last step of installation, a window will appear showing cloning database files.. After copying,there will be a option.. How are we doing?

You can see his article for more information. You can use below code to get the password script. Thanks Laurent for the information. So I reset the password again.

I have added a small note and referred your link too. Pingback: ora This site uses Akismet to reduce spam. Learn how your comment data is processed. Skip to content. Let's try to create a password with symbols:. User altered. Not all symbols can be used in 11g passwords without special care, not even when you are using double quotes.

A new 11 g database uses case sensitive passwords by default if it was created with the database configuration assistant DBCA. A 10g database which is upgraded with the database upgrade assistant DBUA also uses case sensitive passwords by default but only for newly created user accounts.