[ClusterLabs Developers] [EXTERNAL] Re: Pacemaker scripts for Oracle

Wed Jun 14 13:17:27 UTC 2023

Hi Ken,

I had a look there and it just confused the heck out of me.  I don’t think a pull request is for me.  I'll just explain my issue/query and maybe you can post it on somewhere or let me know how and where I should...

Here we go: -

When you create an Oracle Listener (oralsnr) resource with "pcs resource create", one of the parameters it requires is "sid" and the documentation asks you to enter the ORACLE_SID for that.

I think this should be changed to ask for a "TNS Entry" because...

1) All the oralsnr script does is tnsping that value so we should be able to call it what we want and create an appropriate tnsnames.ora entry for it.
2) Using the ORACLE_SID is not ideal as there may already be a tnsnames.ora entry bearing that name and using it for dual purposes is dangerous (what if someone decided it was no longer required and removed it?).
3) It makes no sense to use the ORACLE_SID, that is the database identifier.  This is the listener so if anything the listener name would be more appropriate.

In practice there doesn't seem to be any problem setting any desired value for "sid".  I have been using the listener name as it makes more sense and I can then have a dedicated tnsnames.ora entry with that name (it can be a simple one without any connect data clause as nobody/nothing will be using it for a database connection) therefore avoiding any risk of it being accidently removed or of it being used for other purposes.

My problem is, people are averse to doing this because it goes against what the documentation says, despite the fact it makes much more sense to do as I have described above.

Therefore, I think this is really just a documentation issue and I think it should be amended to state that "sid" should be the name of a (dedicated) tnsnames.ora entry for the service to tnsping.

Cheers,
Adrian.

-----Original Message-----
From: Ken Gaillot <kgaillot at redhat.com>
Sent: Monday, June 12, 2023 2:32 PM
To: developers at clusterlabs.org
Cc: Golding, Adrian (Senior Database Engineer) <Adrian.Golding at sky.uk>
Subject: [EXTERNAL] Re: [ClusterLabs Developers] Pacemaker scripts for Oracle

On Fri, 2023-06-09 at 08:14 +0000, Golding, Adrian (Senior Database
Engineer) via Developers wrote:
> Hi,
>
> I would like to ask how I get approach a documentation enhancement for
> the "oralsnr" pacemaker script.

Hi Adrian,

That is part of the resource-agents project. You can file a pull request at:

 https://github.com/ClusterLabs/resource-agents

>
> I won’t explain here as I’m not sure I am emailing the correct address
> but am happy to explain if I get a response to this.
>
> Cheers,
> Adrian.
>
> Adrian Golding
> Senior Database Engineer
> Technology Services
> Comms & Infrastructure
>
> Sky UK
> Email: adrian.golding at sky.uk
> Desk:  +44 207 032 7523
>
> Information in this email including any attachments may be privileged,
> confidential and is intended exclusively for the addressee. The views
> expressed may not be official policy, but the personal views of the
> originator. If you have received it in error, please notify the sender
> by return e-mail and delete it from your system. You should not
> reproduce, distribute, store, retransmit, use or disclose its contents
> to anyone. Please note we reserve the right to monitor all e-mail
> communication through our internal and external networks. SKY and the
> SKY marks are trademarks of Sky Limited and Sky International AG and
> are used under licence.
>
> Sky UK Limited (Registration No. 2906991), Sky-In-Home Service Limited
> (Registration No. 2067075), Sky Subscribers Services Limited
> (Registration No. 2340150) and Sky CP Limited (Registration No.
> 9513259) are direct or indirect subsidiaries of Sky Limited
> (Registration No. 2247735). All of the companies mentioned in this
> paragraph are incorporated in England and Wales and share the same
> registered office at Grant Way, Isleworth, Middlesex TW7 5QD
> _______________________________________________
> Manage your subscription:
> https://lists.clusterlabs.org/mailman/listinfo/developers
>
> ClusterLabs home: https://www.clusterlabs.org/
--
Ken Gaillot <kgaillot at redhat.com>

--------------------------------------------------------------------
This email is from an external source. Please do not open attachments or click links from an unknown or suspicious origin. Phishing attempts can be reported by using the report message button in Outlook or sending them as an attachment to phishing at sky.uk. Thank you
--------------------------------------------------------------------

Information in this email including any attachments may be privileged, confidential and is intended exclusively for the addressee. The views expressed may not be official policy, but the personal views of the originator. If you have received it in error, please notify the sender by return e-mail and delete it from your system. You should not reproduce, distribute, store, retransmit, use or disclose its contents to anyone. Please note we reserve the right to monitor all e-mail communication through our internal and external networks. SKY and the SKY marks are trademarks of Sky Limited and Sky International AG and are used under licence.

Sky UK Limited (Registration No. 2906991), Sky-In-Home Service Limited (Registration No. 2067075), Sky Subscribers Services Limited (Registration No. 2340150) and Sky CP Limited (Registration No. 9513259) are direct or indirect subsidiaries of Sky Limited (Registration No. 2247735). All of the companies mentioned in this paragraph are incorporated in England and Wales and share the same registered office at Grant Way, Isleworth, Middlesex TW7 5QD