Introduction
Setting up Disaster Recovery (DR) in Oracle Database Cloud Service (DBCS) through the Oracle Cloud Infrastructure (OCI) console is an essential part of ensuring business continuity. However, this process can sometimes surface errors that interrupt DR configuration.
This post outlines what causes this error during DR setup and how you can resolve it quickly.
Error:- DCS-10045: Validation error encountered: invalid database logon credentials; logon denied.
Issue: – When you initiate DR creation from the OCI console, the system attempts to connect to the target database using the provided credentials and service details. If the relevant database service is unavailable or inactive, even valid credentials will not authenticate, triggering this error.
Typical Scenario: The required database service (following the <DB UNQNAME>.<dbdomain> pattern) is missing, not started, or not properly registered in the Oracle environment.
Step-by-Step Solution
Confirm the Database Service Name
Identify the correct service name for your Oracle database. This will commonly be a combination of your database’s unique name (UNQNAME) and its domain (dbdomain). This service must exist and be running for the DR setup to succeed.
Start the Required Service
Log in to your database as a user with sufficient privileges and initiate the relevant service using the following command:
exec dbms_service.start_service(‘XXXX’, DBMS_SERVICE.ALL_INSTANCES);
Replace ‘XXXX’ with your actual database service name (e.g., UNQNAME.dbdomain).
The DBMS_SERVICE.ALL_INSTANCES argument ensures the service is started on all nodes in a clustered or RAC environment.
If the service does not exist, you may first need to create it using dbms_service.create_service.
Verify Service Registration
After starting the service:
Check your listener and service registration using:
select name from gv$active_services;
Confirm the service name appears in the list and is registered with the database listener.
Retry DR Configuration
Once the service is running and registered, reattempt the DR creation process from the OCI console. The error should now be resolved if the service and credentials are correct.
Additional Troubleshooting Tips
- Ensure all security groups and network rules permit the necessary traffic (usually on port 1521).
- Double-check connection strings and DNS configurations, especially in cross-region DR setups.
- If the error persists, review OCI console error logs for further details.
Conclusion
The DCS-10045 error during DR creation in Oracle DBCS typically stems from an inactive or missing database service rather than truly invalid credentials. By starting the appropriate service across all instances, you can restore connectivity and move forward with your DR configuration confidently. Regular service monitoring and verification can prevent these issues in the future.
Taking these steps will ensure a smoother disaster recovery setup and enhance your Oracle cloud environment’s reliability.
