El otro día tuve el siguiente error al activar el dataguard en OCI
Este error no aclara donde puede estar el problema, así que vamos a mirar el JOB a ver que es lo que nos dice:
[root@~]# dbcli list-jobs | grep Failure | tail -2
d29455a0-f6ad-4a9d-8fd7-8eb4306a23e3 Validate DG Config Creation Sunday, March 10, 2024, 01:46:32 CET Failure
Con el paso anterior obtenemos el identificador del JOB, para mirar tanto el log como el detalle del JOB.
Detalle del job: "dbcli describe-job -i <id_job> -l Verbose"
Ruta del log: /opt/oracle/dcs/log/jobs/<id_job>.log
[root@~]# dbcli describe-job -i 7fe217d7-a6b4-40aa-b00e-8f8c793e7197 -l Verbose
Job details
----------------------------------------------------------------
ID: 7fe217d7-a6b4-40aa-b00e-8f8c793e7197
Description: Validate DG Config Creation
Status: Failure
Created: March 10, 2024 at 1:49:52 AM CET
Progress: 0%
Message: DCS-10045:Validation error encountered: invalid database logon credentials;
logon denied.
Error Code: DCS-10045
Cause: Parameter validation failed.
Action: Provide the correct parameter values for the operation.
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
task:TaskZLockWrapper_27301 March 10, 2024 at 1:49:52 AM CET March 10, 2024 at 1:49:53 AM CET Failure
Validate create dataguard config task March 10, 2024 at 1:49:52 AM CET March 10, 2024 at 1:49:53 AM CET Failure
Validate create dataguard config task March 10, 2024 at 1:49:52 AM CET March 10, 2024 at 1:49:53 AM CET Failure
Y a nivel de log:
[root@~]# dbcli list-jobs | tail -2
fb0729d5-7563-4dce-b886-c12310543466 Validate DG Config Creation Sunday, March 10, 2024, 13:37:54 CET Success
[root@~]# tail -5 /opt/oracle/dcs/log/jobs/7fe217d7-a6b4-40aa-b00e-8f8c793e7197.log
[2024-03-10 01:49:53,628] FINE [ReportRecorder_TaskZJsonRpcExt_27421 : JobId=7fe217d7-a6b4-40aa-b00e-8f8c793e7197] com.oracle.dcs.agent.zk.DCSZQueue: Node not yet received for: /nodes/node_1/cmd-out-q with prefix:1017_51478_
[2024-03-10 01:49:53,647] FINE [ReportRecorder_TaskZJsonRpcExt_27421 : JobId=7fe217d7-a6b4-40aa-b00e-8f8c793e7197] com.oracle.dcs.agent.task.TaskZJsonRpc: Got response from node node_1's out-queue with prefix as 1017_51478_
Detail: set task result as DCS-10045:Validation error encountered: invalid database logon credentials;
logon denied.
Parece ser que tenemos un problema con la wallet, así que vamos a generarla de nuevo.
El primer paso es siempre hacer un backup del fichero de inicio de sesión y después generarlo
[oracle@~]$ mv /opt/oracle/dcs/commonstore/wallets/$ORACLE_UNQNAME/tde/cwallet.sso /opt/oracle/dcs/commonstore/wallets/$ORACLE_UNQNAME/tde/cwallet.sso.old
--- cerramos el inicio de sesión automático
SQL> alter system set wallet close;
-- abrimos la wallet con la pass
SQL> alter system set wallet open identified by "XXXX";
-- restablecemos la clave maestra
SQL> alter system set encryption key identified by "XXXX";
SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY "XXXX" with backup;
SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY "XXX" WITH BACKUP CONTAINER=ALL;
-- Nos conectamos a la PDB
SQL> alter session set container=XXXX;
SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY "XXXX" with backup;
Relanzamos de nuevo el JOB
[root@~]# dbcli describe-job -i fb0729d5-7563-4dce-b886-c12310543466 -l Verbose
Job details
----------------------------------------------------------------
ID: fb0729d5-7563-4dce-b886-c12310543466
Description: Validate DG Config Creation
Status: Success
Created: March 10, 2024 at 1:37:54 PM CET
Progress: 100%
Message:
Error Code:
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
task:TaskZLockWrapper_28374 March 10, 2024 at 1:37:55 PM CET March 10, 2024 at 1:37:58 PM CET Success
Validate create dataguard config task March 10, 2024 at 1:37:55 PM CET March 10, 2024 at 1:37:58 PM CET Success
Validate create dataguard config task March 10, 2024 at 1:37:55 PM CET March 10, 2024 at 1:37:58 PM CET Success
Perfecto, el JOB ha superado el paso de validación. Espero que os sirva.