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. |
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.
Verificando ACL
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
SQL> SELECT PRINCIPAL, HOST, lower_port, upper_port, acl, 'connect' AS PRIVILEGE, DECODE(DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE_ACLID(aclid, PRINCIPAL, 'connect'), 1,'GRANTED', 0,'DENIED', NULL) PRIVILEGE_STATUS FROM DBA_NETWORK_ACLS JOIN DBA_NETWORK_ACL_PRIVILEGES USING (ACL, ACLID) UNION ALL SELECT PRINCIPAL, HOST, NULL lower_port, NULL upper_port, acl, 'resolve' AS PRIVILEGE, DECODE(DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE_ACLID(aclid, PRINCIPAL, 'resolve'), 1,'GRANTED', 0,'DENIED', NULL) PRIVILEGE_STATUS FROM DBA_NETWORK_ACLS JOIN DBA_NETWORK_ACL_PRIVILEGES USING (ACL, ACLID); PRINCIPA HOST LOWER_PORT UPPER_PORT ACL PRIVILEGE PRIVILE -------- ----- ---------- ---------- ---------------------- ------------ ------- CPD * /sys/acls/ACL_TI.xml connect GRANTED CPD * /sys/acls/ACL_TI.xml connect GRANTED CPD * /sys/acls/ACL_TI.xml resolve GRANTED CPD * /sys/acls/ACL_TI.xml resolve GRANTED |
Dropando ACL
|
1 2 3 4 5 6 7 8 |
SQL> BEGIN DBMS_NETWORK_ACL_ADMIN.DROP_ACL( acl => '/sys/acls/ACL_TI.xml'); END; / PL/SQL procedure successfully completed. |
Verificando ACL
|
1 2 3 4 5 6 7 8 9 10 11 12 |
SQL> SELECT PRINCIPAL, HOST, lower_port, upper_port, acl, 'connect' AS PRIVILEGE, DECODE(DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE_ACLID(aclid, PRINCIPAL, 'connect'), 1,'GRANTED', 0,'DENIED', NULL) PRIVILEGE_STATUS FROM DBA_NETWORK_ACLS JOIN DBA_NETWORK_ACL_PRIVILEGES USING (ACL, ACLID) UNION ALL SELECT PRINCIPAL, HOST, NULL lower_port, NULL upper_port, acl, 'resolve' AS PRIVILEGE, DECODE(DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE_ACLID(aclid, PRINCIPAL, 'resolve'), 1,'GRANTED', 0,'DENIED', NULL) PRIVILEGE_STATUS FROM DBA_NETWORK_ACLS 9 JOIN DBA_NETWORK_ACL_PRIVILEGES USING (ACL, ACLID); no rows selected |