Erro ao realizar conexão sqlplus
|
1 2 3 4 5 6 |
SQL*Plus: Release 11.2.0.1.0 Production on Mon May 13 19:06:57 2019 Copyright (c) 1982, 2010, Oracle. All rights reserved. ERROR: ORA-28040: No matching authentication protocol |
Editar o arquivo sqlnet.ora e adicionar a linha abaixo
|
1 2 3 4 |
vi $ORACLE_HOME/network/admin/sqlnet.ora SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8 SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 |
Resolvido!
Erro ao criar usuário:
|
1 2 3 4 5 6 |
SQL> create user rsilva identified by password; create user rsilva identified by password * ERROR at line 1: ORA-28003: password verification for the specified password failed ORA-20023: Password must contain at least 2 uppercase character(s) |
Desabilitar senha complexa
|
1 |
SQL> alter profile default limit password_verify_function null; |
Desabilitar tempo de reuso de senha
|
1 |
SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME UNLIMITED; |
Desabilitar máximo de reusos da senha
|
1 |
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_MAX UNLIMITED; |
Consultando alterações realizadas.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
SQL> select * from dba_profiles where profile='DEFAULT'; PROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP --------------- ---------------------------- -------- ---------- --- --- --- DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED NO NO NO DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED NO NO NO DEFAULT CPU_PER_SESSION KERNEL UNLIMITED NO NO NO DEFAULT CPU_PER_CALL KERNEL UNLIMITED NO NO NO DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED NO NO NO DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED NO NO NO DEFAULT IDLE_TIME KERNEL UNLIMITED NO NO NO DEFAULT CONNECT_TIME KERNEL UNLIMITED NO NO NO DEFAULT PRIVATE_SGA KERNEL UNLIMITED NO NO NO DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 3 NO NO NO DEFAULT PASSWORD_LIFE_TIME PASSWORD 60 NO NO NO PROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP --------------- ---------------------------- -------- ---------- --- --- --- DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED NO NO NO DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED NO NO NO DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL NO NO NO DEFAULT PASSWORD_LOCK_TIME PASSWORD 1 NO NO NO DEFAULT PASSWORD_GRACE_TIME PASSWORD 7 NO NO NO DEFAULT INACTIVE_ACCOUNT_TIME PASSWORD UNLIMITED NO NO NO 17 rows selected. |
Listando os Jobs de Backup
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[root@bancora bin]# dbcli list-jobs ID Description Created Status ---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ---------- c58393ad-5ae3-4c7b-928c-d9fdbfabf5de Create Regular-L1 Backup with TAG-DBTRegular-L115563549458327dN for Db:OLTP in OSS:bALsAUuq3uHr5GJzB2pU April 27, 2019 5:50:18 AM BRT Success bc0cb3df-0661-4297-8a4d-b74a434f222a Delete Backup for Database name: OLTP_iad1f9 April 27, 2019 6:38:33 AM BRT Success 02c3e0fb-dcd0-439e-b968-82f9c3df3f0e Create Regular-L0 Backup with TAG-DBTRegular-L01556441408120FW0 for Db:OLTP in OSS:bALsAUuq3uHr5GJzB2pU April 28, 2019 5:51:17 AM BRT Success eafe6e54-6e83-4113-9d5c-d9c2d9b56849 Delete Backup for Database name: OLTP_iad1f9 April 28, 2019 7:33:24 AM BRT Success efd8511c-dced-4876-ab7e-1860271a6ff6 Create Regular-L1 Backup with TAG-DBTRegular-L11556527793681Wxh for Db:OLTP in OSS:bALsAUuq3uHr5GJzB2pU April 29, 2019 5:50:43 AM BRT Success 9c26115e-2be1-4011-a87e-6bd9979ec8cb Delete Backup for Database name: OLTP_iad1f9 April 29, 2019 6:23:52 AM BRT Success 761bfcd8-09f2-481b-b385-43d80bb603ec Update objectstoreSwift:bALsAUuq3uHr5GJzB2pU April 30, 2019 6:01:49 AM BRT Success a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5 Create Regular-L1 Backup with TAG-DBTRegular-L11556614192021uTg for Db:OLTP in OSS:bALsAUuq3uHr5GJzB2pU April 30, 2019 6:04:17 AM BRT Failure 7042dbf8-210f-45cf-98e2-6f6ea7f045d1 Create Regular-L0 Backup with TAG-DBTRegular-L01556700598241tWQ for Db:OLTP in OSS:bALsAUuq3uHr5GJzB2pU May 1, 2019 5:51:00 AM BRT Failure |
Analisando os logs do backup
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 |
[root@bancora ~]# dbcli describe-job -i a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5 -j { "jobId" : "a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5", "status" : "Failure", "message" : "DCS-10045:Validation error encountered: Window mismatch of backupconfig(30) and db recovery window(10).", "reports" : [ { "taskId" : "TaskZLockWrapper_251", "taskName" : "task:TaskZLockWrapper_251", "taskResult" : "DCS-10045:Validation error encountered: Window mismatch of backupconfig(30) and db recovery window(10).", "startTime" : "April 30, 2019 06:04:19 AM BRT", "endTime" : "April 30, 2019 06:04:32 AM BRT", "status" : "Failure", "taskDescription" : null, "parentTaskId" : "TaskServiceRequest_250", "jobId" : "a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5", "tags" : [ ], "reportLevel" : "Error", "updatedTime" : "April 30, 2019 06:04:32 AM BRT" }, { "taskId" : "TaskSequential_252", "taskName" : "task:TaskSequential_252", "taskResult" : "DCS-10045:Validation error encountered: Window mismatch of backupconfig(30) and db recovery window(10).", "startTime" : "April 30, 2019 06:04:19 AM BRT", "endTime" : "April 30, 2019 06:04:32 AM BRT", "status" : "Failure", "taskDescription" : null, "parentTaskId" : "TaskZLockWrapper_251", "jobId" : "a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5", "tags" : [ ], "reportLevel" : "Error", "updatedTime" : "April 30, 2019 06:04:32 AM BRT" }, { "taskId" : "TaskParallel_253", "taskName" : "Validate backup config", "taskResult" : "", "startTime" : "April 30, 2019 06:04:19 AM BRT", "endTime" : "April 30, 2019 06:04:19 AM BRT", "status" : "Success", "taskDescription" : null, "parentTaskId" : "TaskSequential_252", "jobId" : "a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5", "tags" : [ ], "reportLevel" : "Info", "updatedTime" : "April 30, 2019 06:04:19 AM BRT" }, { "taskId" : "TaskParallel_256", "taskName" : "Database container validation", "taskResult" : "", "startTime" : "April 30, 2019 06:04:19 AM BRT", "endTime" : "April 30, 2019 06:04:20 AM BRT", "status" : "Success", "taskDescription" : null, "parentTaskId" : "TaskSequential_252", "jobId" : "a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5", "tags" : [ ], "reportLevel" : "Info", "updatedTime" : "April 30, 2019 06:04:20 AM BRT" }, { "taskId" : "TaskParallel_259", "taskName" : "libopc existence check", "taskResult" : "", "startTime" : "April 30, 2019 06:04:20 AM BRT", "endTime" : "April 30, 2019 06:04:20 AM BRT", "status" : "Success", "taskDescription" : null, "parentTaskId" : "TaskSequential_252", "jobId" : "a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5", "tags" : [ ], "reportLevel" : "Info", "updatedTime" : "April 30, 2019 06:04:20 AM BRT" }, { "taskId" : "TaskZJsonRpcExt_262", "taskName" : "Backup Validations", "taskResult" : "Successfully validated for database backup", "startTime" : "April 30, 2019 06:04:20 AM BRT", "endTime" : "April 30, 2019 06:04:29 AM BRT", "status" : "Success", "taskDescription" : null, "parentTaskId" : "TaskSequential_252", "jobId" : "a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5", "tags" : [ ], "reportLevel" : "Info", "updatedTime" : "April 30, 2019 06:04:29 AM BRT" }, { "taskId" : "TaskZJsonRpcExt_264", "taskName" : "Recovery Window validation", "taskResult" : "DCS-10045:Validation error encountered: Window mismatch of backupconfig(30) and db recovery window(10).", "startTime" : "April 30, 2019 06:04:29 AM BRT", "endTime" : "April 30, 2019 06:04:32 AM BRT", "status" : "Failure", "taskDescription" : null, "parentTaskId" : "TaskSequential_252", "jobId" : "a404d09d-ea2d-4cfd-b643-5bba1f4fc2a5", "tags" : [ ], "reportLevel" : "Error", "updatedTime" : "April 30, 2019 06:04:32 AM BRT" } ], "createTimestamp" : "April 30, 2019 06:04:17 AM BRT", "resourceList" : [ ], "description" : "Create Regular-L1 Backup with TAG-DBTRegular-L11556614192021uTg for Db:OLTP in OSS:bALsAUuq3uHr5GJzB2pU", "updatedTime" : "April 30, 2019 06:04:32 AM BRT" } |
Listando a política retenção do backup
|
1 2 3 4 5 |
[root@bancora ~]# dbcli list-backupconfigs ID Name RecoveryWindow CrosscheckEnabled BackupDestination ---------------------------------------- -------------------- ---------------- ------------------- -------------------- 29156be7-1539-4d7f-8dca-fda994bfd13e bALsAUuq3uHr5GJzB2pU_BC 30 true ObjectStore |
Verificando a retenção do RMAN
|
1 2 3 |
RMAN> show all CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 10 DAYS; |
Esse problema pode acontecer se o recovery_window foi atualizado pelo comando RMAN, não pelo comando dbcli. Atualizando o recovery_window pelo comando dbcli i = ID w = RecoveryWindow
|
1 |
[root@bancora ~]# dbcli update-backupconfig -i 29156be7-1539-4d7f-8dca-fda994bfd13e -w 10 |
Listando…
Erro ORA-12713: Character data loss in NCHAR/CHAR conversion
|
1 2 3 4 5 6 |
channel ORA_DISK_1: starting piece 1 at 13-APR-19 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/13/2019 12:17:45 ORA-12713: Character data loss in NCHAR/CHAR conversion |
Causa: Identificado que as aspas estava invertidas. BACKUP DATABASE TAG ‘NOCOMPRESS’; Solução: Acerta aspas para ” BACKUP DATABASE TAG ‘NOCOMPRESS’; Resolvido!
ORA-19806: cannot make duplex backups in recovery area
|
1 2 3 4 5 6 |
channel ORA_DISK_1: starting piece 1 at 13-APR-19 RMAN-00571: =================================================== ======== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ======= ======== RMAN-00571: =================================================== ======== RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/13/2019 01:01:14 ORA-19806: cannot make duplex backups in recovery area |
List parâmetros
|
1 2 3 |
RMAN> SHOW ALL; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2; CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'DISK' TO 2; |
Causa: Backup duplex para a área de recuperação não é suportado. Solução: Remover a opção duplex.