{"id":2320,"date":"2019-06-03T14:49:56","date_gmt":"2019-06-03T17:49:56","guid":{"rendered":"https:\/\/zmsolution.laraclaud.com.br\/?p=2320"},"modified":"2019-06-04T13:55:57","modified_gmt":"2019-06-04T16:55:57","slug":"alterando-o-character-do-oracle","status":"publish","type":"post","link":"http:\/\/zmsolution.com\/alterando-o-character-do-oracle\/","title":{"rendered":"Alterando o CHARACTER do Oracle"},"content":{"rendered":"<p>Nesse post vamos altera o\u00a0CHARACTER\u00a0 do banco de dados Oracle.<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"lang:default decode:true \">conn \/ as sysdba\r\nsho parameter CLUSTER_DATABASE\r\nsho parameter PARALLEL_SERVER\r\n2. Execute the following commands in sqlplus connected as \"\/ AS SYSDBA\":\r\n\r\nconn \/ as sysdba\r\n\r\nSHUTDOWN IMMEDIATE;\r\nSTARTUP MOUNT;\r\nALTER SYSTEM ENABLE RESTRICTED SESSION;\r\nALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;\r\nALTER SYSTEM SET AQ_TM_PROCESSES=0;\r\nALTER DATABASE OPEN;\r\nALTER DATABASE CHARACTER SET INTERNAL_USE WE8ISO8859P1;\r\nSHUTDOWN IMMEDIATE;<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000;\">Cuidado..valide bem antes antes de fazer isso..<\/span><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nesse post vamos altera o\u00a0CHARACTER\u00a0 do banco de dados Oracle. &nbsp; conn \/ as sysdba sho parameter CLUSTER_DATABASE sho parameter PARALLEL_SERVER 2. Execute the following commands in sqlplus connected as &#8220;\/ AS SYSDBA&#8221;: conn \/ as sysdba SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER SYSTEM ENABLE RESTRICTED SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; ALTER SYSTEM SET AQ_TM_PROCESSES=0; ALTER DATABASE OPEN; ALTER DATABASE CHARACTER SET INTERNAL_USE WE8ISO8859P1; SHUTDOWN IMMEDIATE; &nbsp; &nbsp; Cuidado..valide bem antes antes de fazer isso..<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[21,1],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/2320"}],"collection":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/comments?post=2320"}],"version-history":[{"count":0,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/posts\/2320\/revisions"}],"wp:attachment":[{"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/media?parent=2320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/categories?post=2320"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zmsolution.com\/wp-json\/wp\/v2\/tags?post=2320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}