{"id":192,"date":"2018-04-24T18:51:30","date_gmt":"2018-04-24T21:51:30","guid":{"rendered":"http:\/\/rodrigosilvaesilva.com.br\/?p=192"},"modified":"2018-04-24T18:51:30","modified_gmt":"2018-04-24T21:51:30","slug":"ora-01017-sec_case_sensitive_logon","status":"publish","type":"post","link":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/2018\/04\/24\/ora-01017-sec_case_sensitive_logon\/","title":{"rendered":"ORA-01017 \u2013 SEC_CASE_SENSITIVE_LOGON"},"content":{"rendered":"

Quando \u00e9 habilitado o parametro de SEC_CASE_SENSITIVE_LOGON no Oracle 12.2.0.1, o usu\u00e1rio SYS para de autenticar.<\/p>\n

Para contornar esse problema aplicamos a seguinte solu\u00e7\u00e3o desabilitando senha case sensitive<\/p>\n

SQL> alter system set sec_case_sensitive_logon=false scope=spfile;\nSQL> \nSQL> shutdown immediate; \nSQL> \nSQL> startup \nORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance<\/pre>\n
Editar o arquivo sqlnet.ora<\/p>\n
[oracle@bdora ~]$ vim $ORACLE_HOME\/network\/admin\/sqlnet.ora\n\nAdicionar linha abaixo\n \nSQLNET.ALLOWED_LOGON_VERSION_SERVER=11<\/pre>\n
Verificando par\u00e2metro de PASSWORD_VERSION<\/p>\n
SQL > select username, password_versions from DBA_USERS where username IN ('SYSTEM','SYS');\n\nUSERNAME   PASSWORD_VERSIONS\n---------- -----------------\nSYS        10G 11G 12C\nSYSTEM     10G 11G 12C\n<\/pre>\n
\u00c9 necess\u00e1rio alterar a senha do usu\u00e1rio.<\/p>\n
alter user NOME_USUARIO identified by SENHA;<\/pre>\n
 <\/p>\n
Fonte: Andr\u00e9 Spadini<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Quando \u00e9 habilitado o parametro de SEC_CASE_SENSITIVE_LOGON no Oracle 12.2.0.1, o usu\u00e1rio SYS para de autenticar. Para contornar esse problema aplicamos a seguinte solu\u00e7\u00e3o desabilitando senha case sensitive SQL> alter system set sec_case_sensitive_logon=false scope=spfile; SQL> SQL> shutdown immediate; SQL> SQL> startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance Editar o arquivo sqlnet.ora [oracle@bdora…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[214,289,322,338],"class_list":["post-192","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-ora-01017","tag-password_version","tag-sec_case_sensitive_logon","tag-sqlnet-ora"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/192","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=192"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/192\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=192"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=192"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}