Re: [oracle_br] Re: Sessão com 1 hora a mais.
Muito obrigado pela ajuda Chiappa. Para solucionar o problema foi preciso
adicionar um parâmetro dentro do LISTENER.ora. Segue:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = XUXA)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1)
(SID_NAME = XUXA)
(ENVS='TZ=GRNLNDST3')
)..
Em Segunda-feira, 25 de Abril de 2016 16:44, "jlchia...@yahoo.com.br
[oracle_br]" escreveu:
Duas possibilidades :
a) cfrme
http://www.oraclebuffer.com/oracle-internals/oracle-database-timezone-mismatch-between-local-and-remote-connections/
mostra vc talvez tenha diferença de ambiente / TZ entre listener e prompt de
comando, EM ESPECIAL se vc tá usando ASM, onde via de regra o Listener roda
junto com o ASM num usuário "GRID", separado do usuário "ORACLE"
ou
b) vc tem uma misconfig de NLS na máquina-cliente, ie, vc tem variáveis NLS
e/ou de timezone (ORA_SDTZ, talvez) mal-configuradas
ou
c) no sistema operacional da máquina-cliente há variáveis/configs de timezone
inapropriadas
[]s
Chiappa #yiv5252655340 -- #yiv5252655340ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5252655340
#yiv5252655340ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5252655340
#yiv5252655340ygrp-mkp #yiv5252655340hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5252655340 #yiv5252655340ygrp-mkp #yiv5252655340ads
{margin-bottom:10px;}#yiv5252655340 #yiv5252655340ygrp-mkp .yiv5252655340ad
{padding:0 0;}#yiv5252655340 #yiv5252655340ygrp-mkp .yiv5252655340ad p
{margin:0;}#yiv5252655340 #yiv5252655340ygrp-mkp .yiv5252655340ad a
{color:#ff;text-decoration:none;}#yiv5252655340 #yiv5252655340ygrp-sponsor
#yiv5252655340ygrp-lc {font-family:Arial;}#yiv5252655340
#yiv5252655340ygrp-sponsor #yiv5252655340ygrp-lc #yiv5252655340hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5252655340
#yiv5252655340ygrp-sponsor #yiv5252655340ygrp-lc .yiv5252655340ad
{margin-bottom:10px;padding:0 0;}#yiv5252655340 #yiv5252655340actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5252655340
#yiv5252655340activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5252655340
#yiv5252655340activity span {font-weight:700;}#yiv5252655340
#yiv5252655340activity span:first-child
{text-transform:uppercase;}#yiv5252655340 #yiv5252655340activity span a
{color:#5085b6;text-decoration:none;}#yiv5252655340 #yiv5252655340activity span
span {color:#ff7900;}#yiv5252655340 #yiv5252655340activity span
.yiv5252655340underline {text-decoration:underline;}#yiv5252655340
.yiv5252655340attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5252655340 .yiv5252655340attach div a
{text-decoration:none;}#yiv5252655340 .yiv5252655340attach img
{border:none;padding-right:5px;}#yiv5252655340 .yiv5252655340attach label
{display:block;margin-bottom:5px;}#yiv5252655340 .yiv5252655340attach label a
{text-decoration:none;}#yiv5252655340 blockquote {margin:0 0 0
4px;}#yiv5252655340 .yiv5252655340bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5252655340
.yiv5252655340bold a {text-decoration:none;}#yiv5252655340 dd.yiv5252655340last
p a {font-family:Verdana;font-weight:700;}#yiv5252655340 dd.yiv5252655340last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5252655340
dd.yiv5252655340last p span.yiv5252655340yshortcuts
{margin-right:0;}#yiv5252655340 div.yiv5252655340attach-table div div a
{text-decoration:none;}#yiv5252655340 div.yiv5252655340attach-table
{width:400px;}#yiv5252655340 div.yiv5252655340file-title a, #yiv5252655340
div.yiv5252655340file-title a:active, #yiv5252655340
div.yiv5252655340file-title a:hover, #yiv5252655340 div.yiv5252655340file-title
a:visited {text-decoration:none;}#yiv5252655340 div.yiv5252655340photo-title a,
#yiv5252655340 div.yiv5252655340photo-title a:active, #yiv5252655340
div.yiv5252655340photo-title a:hover, #yiv5252655340
div.yiv5252655340photo-title a:visited {text-decoration:none;}#yiv5252655340
div#yiv5252655340ygrp-mlmsg #yiv5252655340ygrp-msg p a
span.yiv5252655340yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5252655340
.yiv5252655340green {color:#628c2a;}#yiv5252655340 .yiv5252655340MsoNormal
{margin:0 0 0 0;}#yiv5252655340 o {font-size:0;}#yiv5252655340
#yiv5252655340photos div {float:left;width:72px;}#yiv5252655340
#yiv5252655340photos div div {border:1px solid
#66;height:62px;overflow:hidden;width:62px;}#yiv5252655340
#yiv5252655340photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5252655340
#yiv5252655340reco-category {font-size:77%;}#yiv5252655340
#yiv5252655340reco-desc {font-size:77%;}#yiv5252655340 .yiv5252655340replbq
{margin:4px;}#yiv5252655340 #yiv5252655340ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px
Re: [oracle_br] Manual Data Protector
Muito obrigado pela ajuda Chiappa. Para solucionar o problema foi preciso
adicionar um parâmetro dentro do LISTENER.ora. Segue:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = XUXA)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1)
(SID_NAME = XUXA)
(ENVS='TZ=GRNLNDST3')
)..
Depois de adicionar o parâmetro (ENVS='TZ=GRNLNDST3') e restartar o listener o
problema foi solucionado.
Em Sexta-feira, 22 de Abril de 2016 12:53, "Eduardo Dornelles
eod.edua...@gmail.com [oracle_br]" escreveu:
Boa tarde pessoal.
Alguém tem um manual do Data Protector? De preferência em português... meu
inglês ainda é muito ruim.
Muito obrigado.
At.te,Eduardo Dornelles #yiv3188052441 #yiv3188052441 --
#yiv3188052441ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv3188052441 #yiv3188052441ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv3188052441 #yiv3188052441ygrp-mkp #yiv3188052441hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3188052441 #yiv3188052441ygrp-mkp #yiv3188052441ads
{margin-bottom:10px;}#yiv3188052441 #yiv3188052441ygrp-mkp .yiv3188052441ad
{padding:0 0;}#yiv3188052441 #yiv3188052441ygrp-mkp .yiv3188052441ad p
{margin:0;}#yiv3188052441 #yiv3188052441ygrp-mkp .yiv3188052441ad a
{color:#ff;text-decoration:none;}#yiv3188052441 #yiv3188052441ygrp-sponsor
#yiv3188052441ygrp-lc {font-family:Arial;}#yiv3188052441
#yiv3188052441ygrp-sponsor #yiv3188052441ygrp-lc #yiv3188052441hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3188052441
#yiv3188052441ygrp-sponsor #yiv3188052441ygrp-lc .yiv3188052441ad
{margin-bottom:10px;padding:0 0;}#yiv3188052441 #yiv3188052441actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3188052441
#yiv3188052441activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3188052441
#yiv3188052441activity span {font-weight:700;}#yiv3188052441
#yiv3188052441activity span:first-child
{text-transform:uppercase;}#yiv3188052441 #yiv3188052441activity span a
{color:#5085b6;text-decoration:none;}#yiv3188052441 #yiv3188052441activity span
span {color:#ff7900;}#yiv3188052441 #yiv3188052441activity span
.yiv3188052441underline {text-decoration:underline;}#yiv3188052441
.yiv3188052441attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3188052441 .yiv3188052441attach div a
{text-decoration:none;}#yiv3188052441 .yiv3188052441attach img
{border:none;padding-right:5px;}#yiv3188052441 .yiv3188052441attach label
{display:block;margin-bottom:5px;}#yiv3188052441 .yiv3188052441attach label a
{text-decoration:none;}#yiv3188052441 blockquote {margin:0 0 0
4px;}#yiv3188052441 .yiv3188052441bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3188052441
.yiv3188052441bold a {text-decoration:none;}#yiv3188052441 dd.yiv3188052441last
p a {font-family:Verdana;font-weight:700;}#yiv3188052441 dd.yiv3188052441last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3188052441
dd.yiv3188052441last p span.yiv3188052441yshortcuts
{margin-right:0;}#yiv3188052441 div.yiv3188052441attach-table div div a
{text-decoration:none;}#yiv3188052441 div.yiv3188052441attach-table
{width:400px;}#yiv3188052441 div.yiv3188052441file-title a, #yiv3188052441
div.yiv3188052441file-title a:active, #yiv3188052441
div.yiv3188052441file-title a:hover, #yiv3188052441 div.yiv3188052441file-title
a:visited {text-decoration:none;}#yiv3188052441 div.yiv3188052441photo-title a,
#yiv3188052441 div.yiv3188052441photo-title a:active, #yiv3188052441
div.yiv3188052441photo-title a:hover, #yiv3188052441
div.yiv3188052441photo-title a:visited {text-decoration:none;}#yiv3188052441
div#yiv3188052441ygrp-mlmsg #yiv3188052441ygrp-msg p a
span.yiv3188052441yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3188052441
.yiv3188052441green {color:#628c2a;}#yiv3188052441 .yiv3188052441MsoNormal
{margin:0 0 0 0;}#yiv3188052441 o {font-size:0;}#yiv3188052441
#yiv3188052441photos div {float:left;width:72px;}#yiv3188052441
#yiv3188052441photos div div {border:1px solid
#66;height:62px;overflow:hidden;width:62px;}#yiv3188052441
#yiv3188052441photos div label
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3188052441
#yiv3188052441reco-category {font-size:77%;}#yiv3188052441
#yiv3188052441reco-desc {font-size:77%;}#yiv3188052441 .yiv3188052441replbq
{margin:4px;}#yiv3188052441 #yiv3188052441ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3188052441 #yiv3188052441ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3188052441
#yiv3188052441ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3188052441
#yiv3188052441ygrp-mlmsg select, #yiv3188052441 input, #yiv3188052441 textarea
{font:99% Arial, Helvetica, clean
