Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from smtp-aa.freelists.org (smtp-aa.freelists.org [23.23.80.81]) by malta2546.startdedicated.com (Postfix) with ESMTPS id 3C4051003FC6D3 for ; Thu, 11 Nov 2021 23:01:53 +0100 (CET) Received: from turing.freelists.org (ip-10-0-0-164.ec2.internal [10.0.0.164]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits)) (No client certificate requested) by smtp-aa.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id AFF804A346; Thu, 11 Nov 2021 22:01:51 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id 995453FB5F; Thu, 11 Nov 2021 22:01:51 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1636668111; bh=qSqM0LjKLSo9KDtNSi+bUuOrsql1F1PtpYsLH1/P6BE=; h=From:Sender:Sender:From; b=SYprJiX/AtBZ0jpJEtfL1djNciZ6SgyDMtiprTHIJHQZHCZ7aYRRRH/HXVnqZ6UOf NuxfW8sL1VSH/QfPzzlz5zt8NfugTJI7200SEArh2WupHNLwMIqjRF1bUMPzr/qYuz 55wM/rm29EdU8iejV35pOQZTOMHfqWAaxRuo85DA= X-Virus-Scanned: by FreeLists at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id tWbOeinkMucX; Thu, 11 Nov 2021 22:01:51 +0000 (UTC) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id 780483FB79; Thu, 11 Nov 2021 22:01:48 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1636668109; bh=qSqM0LjKLSo9KDtNSi+bUuOrsql1F1PtpYsLH1/P6BE=; h=From:Sender:Sender:From; b=q2vXpJBY6MIfqYF27POU3b6eiWeWRbAb88IsjeZsZ/38a7O/Bt4l2oTEP5CF99Fja FoUErtTiMcXU7pKzl3GXo0Hx4E3T8bsNIMgl4WA7RlJOqhm29k5r2IbceBbgNFPWT8 PyHsOX9NvyKWAzJLYZV02AFpcJuoIxl47BWID10c= Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 11 Nov 2021 22:01:46 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id B3B543FB5F for ; Thu, 11 Nov 2021 22:01:46 +0000 (UTC) Authentication-Results: turing.freelists.org; dkim=pass (2048-bit key; unprotected) header.d=quest.com header.i=@quest.com header.a=rsa-sha256 header.s=selector1 header.b=YzUhw12X; dkim-atps=neutral Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id QBcSChnNL-ZU for ; Thu, 11 Nov 2021 22:01:46 +0000 (UTC) Received: from NAM10-DM6-obe.outbound.protection.outlook.com (mail-dm6nam10on2099.outbound.protection.outlook.com [40.107.93.99]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by turing.freelists.org (Postfix) with ESMTPS id 6EC213F7B4 for ; Thu, 11 Nov 2021 22:01:46 +0000 (UTC) ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=YqXyMR/EXyxgumOUUQwmi7wmadyO/zqtu9uFcrNASVCDanhZ3yzV4bQgX7DYeeGUKn2DOngAI9lWUPxEZcjvDjUK/vCKiMEB7VChm6edyndAk+MXbmtksKy+8CChn+hsAnwovxEI1moEX1IS8M+2FA4HwHZaIynyMPfXHwWnfu4yEz2YW9+InsqaVpfSUWboOSKNijfRSXpxI7RR55Q7bT1jiuL5DI+bD+9P6nKfSa62wFtojgFw1R9PZejy/XopgDS9RmUr5lDnJNUyvPGGm+cpjAb0jeS4rZ2UVVNERRIsYvGpbsSJHWkiRLyvatDfUPtJjZGOxGFGoycOCly3EA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=VR9iFnXrTMO2rZjuosV0Is9Q0/mnSa2UKZ5nZHOzzXI=; b=FkRz+s1r37sGj8tzi0nPyy91JqtVVuoap/44j8sf+osKuIJ4KZRZETf60oHXKTgys5yqv5/bAVZPsyylot4Qh+QAabPyq/32Dh6/n8sxZ3fIF7lHB8Dabr+Iza2+iBRLXEBuTgmVRCKa4OgYKI8f2ueJVSIipkZGs+wnG+Cw/bLwTZvAbveYu/DCpBjVGjwEhCSFI9k3uPCN2kJwurZC0OBgD0HV3tfN6mZ7OIxd82ygVLGqjgdcc9bP6vU9Z1DcNV6zAvFdSiorDqt61E9aIFgMs9mhtvqPH1i5qKVEHOyQEbi03cl1HqkMz03erWP6ZEt/U7VIX5qHoR+C0Htu8g== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=quest.com; dmarc=pass action=none header.from=quest.com; dkim=pass header.d=quest.com; arc=none Received: from CO1PR19MB4984.namprd19.prod.outlook.com (2603:10b6:303:f5::12) by CO1PR19MB4949.namprd19.prod.outlook.com (2603:10b6:303:db::8) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4690.17; Thu, 11 Nov 2021 22:01:45 +0000 Received: from CO1PR19MB4984.namprd19.prod.outlook.com ([fe80::f0bc:d512:22e1:810c]) by CO1PR19MB4984.namprd19.prod.outlook.com ([fe80::f0bc:d512:22e1:810c%9]) with mapi id 15.20.4690.019; Thu, 11 Nov 2021 22:01:45 +0000 From: "Clay Jackson" ("Clay.Jackson") To: james Jose CC: "oracle-l@freelists.org" Subject: RE: ODA Time Zone Thread-Topic: ODA Time Zone Date: Thu, 11 Nov 2021 22:01:45 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=quest.com; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: e8de0887-722c-4e4f-c518-08d9a55eda04 x-ms-traffictypediagnostic: CO1PR19MB4949: x-ms-oob-tlc-oobclassifiers: OLM:8273; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:CO1PR19MB4984.namprd19.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(366004)(9686003)(4326008)(6916009)(5660300002)(86362001)(52536014)(26005)(38070700005)(186003)(8676002)(76116006)(8936002)(33656002)(71200400001)(2906002)(38100700002)(83380400001)(7696005)(55016002)(7116003)(122000001)(66476007)(66556008)(316002)(66446008)(166002)(64756008)(6506007)(53546011)(3480700007)(508600001)(66946007);DIR:OUT;SFP:1102; Content-Type: multipart/alternative; boundary="_000_CO1PR19MB498470F91764DC5B110308979B949CO1PR19MB4984namp_" MIME-Version: 1.0 X-OriginatorOrg: quest.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: CO1PR19MB4984.namprd19.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: e8de0887-722c-4e4f-c518-08d9a55eda04 X-MS-Exchange-CrossTenant-originalarrivaltime: 11 Nov 2021 22:01:45.2163 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 91c369b5-1c9e-439c-989c-1867ec606603 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 0MRz/7O4h07ObSXSmCyZFoG/ugRy7euJ5HvayEiXIeKdCUXu1oMhlDbdX/6bVHST/F+WHqRhzK0C70n/jMuniQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: CO1PR19MB4949 X-FreeLists-DMARC-Sender: Clay.Jackson@quest.com X-archive-position: 81361 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Clay.Jackson@quest.com Precedence: normal Reply-To: Clay.Jackson@quest.com List-Help: List-Unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-Subscribe: List-Owner: List-post: List-Archive: X-list: oracle-l --_000_CO1PR19MB498470F91764DC5B110308979B949CO1PR19MB4984namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Not sure about specific "oda functionalities", which is one of the reasons = I suggested you force Oracle to fix it, especially if they're supposed to = be providing you with "managed" (perhaps they forgot to put "mis" in front = of that) services. I'd certainly shut down databases or anything else I cared about before I m= ade that change; and be prepared for "anomalies". On one of the servers, = it will suddenly be earlier than before and on the other, an hour will "nev= er happen". If you have application code that depends on non-localized dat= e/times to track things, you may see some of those "anomalies". In a "perfect world", "systems" would account for this sort of thing; but,= I have yet to find said "perfect world". At least you're running NTP, so= when you get the timezones straightened out, you should be OK. Good luck! Clay Jackson From: james Jose Sent: Thursday, November 11, 2021 12:05 PM To: Clay Jackson (cjackson) Cc: oracle-l@freelists.org Subject: Re: ODA Time Zone CAUTION: This email originated from outside of the organization. Do not fol= low guidance, click links, or open attachments unless you recognize the sen= der and know the content is safe. also we can easily go and run below command on both nodes of oda without br= eaking any other oda functionalities? /usr/bin/timedatectl set-timezone America/Chicago On Thu, Nov 11, 2021 at 1:52 PM james Jose > wrote: Thanks Clay Jackson!! ntpq command returns and peers retrurned list of servers as you can see bel= ow % ntpq ntpq> peers remote refid st t when poll reach delay offset jit= ter =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D ns1.xxx .INIT. 16 u - 1024 0 0.000 0.000 0.000 ftp8.xxx .INIT. 16 u - 1024 0 0.000 0= .000 0.000 ntp14.xxx .INIT. 16 u - 1024 0 0.000 0.000 0.000 xx-xxx-xx-xx x.x.1x.x 4 u 36 1024 0 0.269 116.726 0.000 li1x7.memb .INIT. 16 u - 1024 0 0.000 0.000 0.000 ntpq> On Thu, Nov 11, 2021 at 1:43 PM Clay Jackson (cjackson) > wrote: I found this in MOS Document 2250865.1 (oracle.com) It uses timedatectl and looks pretty straightforward. That said - if your agreement with Oracle calls for them to manage your ODA= s, (at least IMHO) this is a HUGE screw-up. It should be worthy of a Sev = 1 SR and if necessary Duty Manager Escalation; and you should make THEM fix= it ASAP. You should also make sure you're running NTP (Network Time Protocol) on bot= h nodes. A quick way to do that is to run "ntpq" from the Unix command li= ne. If it comes back, use the "peers" command, and if you see a list of se= rvers, you should be good. If it doesn't come back, or you don't see a li= st of servers, that's ANOTHER issue. Clay Jackson (Charter "Dinosaur") From: oracle-l-bounce@freelists.org <= oracle-l-bounce@freelists.org> On Beh= alf Of james Jose Sent: Thursday, November 11, 2021 11:31 AM To: oracle-l@freelists.org Subject: ODA Time Zone CAUTION: This email originated from outside of the organization. Do not fol= low guidance, click links, or open attachments unless you recognize the sen= der and know the content is safe. We have recently bought two node cluster ODAs and we are running oracle 12c= and the configuration of ODA is given below, ODA X8 2 HA High Availability Configuration. Oracle had set it up on the wrong time zone and one is on EST time zone and= another is on MT. Seems like changing time zone on ODA is challenging one and oracle is not a= ble to help us yet. any tho --_000_CO1PR19MB498470F91764DC5B110308979B949CO1PR19MB4984namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Not sure about specific “oda functionalities&#= 8221;, which is one of the reasons  I suggested you force Oracle to fi= x it, especially if they’re supposed to be providing you with “= managed” (perhaps they forgot to put “mis” in front of th= at) services.

 

I’d certainly shut down databases or anything = else I cared about before I made that change; and be prepared for “an= omalies”.   On one of the servers, it will suddenly be earl= ier than before and on the other, an hour will “never happen”.&= nbsp; If you have application code that depends on non-localized date/times to t= rack things, you may see some of those “anomalies”.<= /p>

 

In a “perfect world”,  “syste= ms” would account for this sort of thing; but, I have yet to find sai= d “perfect world”.   At least you’re running NT= P, so when you get the timezones straightened out, you should be OK.

 

Good luck!

 

Clay Jackson

 

 

From: james Jose <josej8661@gmail.com> =
Sent: Thursday, November 11, 2021 12:05 PM
To: Clay Jackson (cjackson) <Clay.Jackson@quest.com>
Cc: oracle-l@freelists.org
Subject: Re: ODA Time Zone

 

<= span style=3D"font-size:10.0pt;color:#9C6500">CAUTION: This email originated from outside of t= he organization. Do not follow guidance, click links, or open attachments unless you recognize the sender and know = the content is safe.

 

also we can easily go and run below command on both = nodes of oda without breaking any other oda functionalities?

/usr/bin/timedatectl set-timezone America/Chicago<= /span>

 

On Thu, Nov 11, 2021 at 1:52 PM james Jose <josej8661@gmail.com> wrote:

Thanks Clay Jackson!!

ntpq command returns and peers retrurned list of ser= vers as you can see below

 

% ntpq

ntpq> peers
     remote           refid   =    st t when poll reach   delay   offset  jitter =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D
 ns1.xxx .INIT.          16 u    - = 1024    0    0.000    0.000   0.000
 ftp8.xxx .INIT.       &= nbsp;  16 u    - 1024    0    0.000 &nbs= p;  0.000   0.000
 ntp14.xxx .INIT.        16 u    - 1024 =    0    0.000    0.000   0.000
 xx-xxx-xx-xx x.x.1x.x  4 u   36 1024    0   =  0.269  116.726   0.000
 li1x7.memb .INIT.       16 u    - 1024  = ;  0    0.000    0.000   0.000
ntpq>

 

On Thu, Nov 11, 2021 at 1:43 PM Clay Jackson (cjacks= on) <Clay.Ja= ckson@quest.com> wrote:

I found this in MOS

 

Document 2250865.1 (oracle.com)

 

It uses timedatectl and looks pretty straightforward.

 

That said – if your agreement with Oracle calls for them to = manage your ODAs, (at least IMHO) this is a HUGE screw-up.   It s= hould be worthy of a Sev 1 SR and if necessary Duty Manager Escalation; and you should make THEM fix it ASAP.

 

You should also make sure you’re running NTP (Network Time P= rotocol) on both nodes.   A quick way to do that is to run “= ;ntpq” from the Unix command line.  If it comes back, use the “peers” command, and if you see a list of servers, you sho= uld be good.   If it doesn’t come back, or you don’t = see a list of servers, that’s ANOTHER issue.

 

Clay Jackson (Charter “Dinosaur”)

 

 

 

From: oracle-l= -bounce@freelists.org <oracle-l-bounce@freelists.org> On Behalf Of james Jose
Sent: Thursday, November 11, 2021 11:31 AM
To: orac= le-l@freelists.org
Subject: ODA Time Zone

 

CAUTION: This email originated from outside = of the organization. Do not follow guidance, click links, or open attachmen= ts unless you recognize the sender and know the content is safe.

 

We have recently bought two node cluster ODAs and we are running o= racle 12c and the configuration of ODA is given below,

 

ODA X8 2 HA High Availability Configuration.

 

Oracle had set it up on the wrong time zone and one is on EST time= zone and another is on MT. 

 

Seems like changing time zone on ODA is challenging one and oracle= is not able to help us yet. any tho

--_000_CO1PR19MB498470F91764DC5B110308979B949CO1PR19MB4984namp_-- -- http://www.freelists.org/webpage/oracle-l