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:

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.

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.

2.      The command update the password file automatically

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

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.