As we are living the world of technology. Each and every second we can find that n number of user name and Password are created by the user. We as best DBA of the Globe. It is our ought too to maintain all credentials in the correct manner. Let’s have look on the steps to resolve the issue RMAN-04006.
Case 1:
SQL> show parameter REMOTE_LOGIN_PASSWORD NAME TYPE VALUE remote_login_passwordfile string EXCLUSIVE SQL>show parameter REMOTE_OS_AUTHENT NAME TYPE VALUE remote_os_authent boolean FALSE
By default remote_login_passwordfile is EXCLUSIVE and remote_os_authent is FALSE. If you have something else here then make them EXCLUSIVE and FALSE which should resolve the problem.
SQL> alter system set REMOTE_LOGIN_PASSWORD= EXCLUSIVE SQL> alter system set REMOTE_OS_AUTHENT = FALSE
Case 2:
We have such problem where I never explicitly set a password for the SYS user in the newly created database and I could still connect locally. I have fixed that by the following way:
1. Execute the following command in primary/target database.
SQL>ALTER USER SYS IDENTIFIED BY NEW_PASSWORD;
2. The command update the password file automatically
$ORACLE_HOME/dbs/orapwORACLE_SID
3. Copy password file to standby server
Thank you for giving most valuable time .
Today’s thought
“The Way Get Started Is To Quit Talking And Begin Doing.” – Walt Disney
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
