When trying to perform certain user security actions, I get the following error:
ORA-46953: The password file is not in the 12.2 format.
How do I migrate a 12.1 password file to 12.2? Or, is this even necessary?
Add a comment
|
1 Answer
You can migrate the password file with the input_file option of orapwd.
Example:
[oracle@o71 ~]$ orapwd file=test format=12
Enter password for SYS:
[oracle@o71 ~]$ orapwd describe file=test
Password file Description : format=12
[oracle@o71 ~]$ orapwd file=test2 input_file=test format=12.2
[oracle@o71 ~]$ orapwd describe file=test2
Password file Description : format=12.2
answered Sep 16, 2019 at 20:22
-
Excellent! Now (being new at Oracle DBA), how do I locate the password file?– DarrellSep 16, 2019 at 20:28
-
Darrell what operation fails, the password file might be listed in the Listener.ora File, in the client connection string or the client connection properties.– eckesSep 16, 2019 at 20:38
-
@Darrell The password file is located by default in
$ORACLE_HOME/dbson Linux/UNIX platforms and%ORACLE_HOME%\databaseon Windows. If the database is configured with Grid Infrastructure, the password file can be at a custom location, which you can view withsrvctl config database -d DB_UNIQUE_NAMEwhereDB_UNIQUE_NAMEis the unique name of the database. Sep 16, 2019 at 20:45 -
@eckes No, the password file is not listed at any of those locations. Sep 16, 2019 at 20:45
-
@BalazsPapp yes Right, the Location of wallets are there, the password file is not.– eckesSep 16, 2019 at 20:46