Saturday, 29 March 2025

Filled under:

 // Assuming `etcd_health` is the variable holding the output

var etcd_health = state.etcd_health;  // Retrieve `etcd_health` from the state


// Check if etcd_health is defined and is a string

if (etcd_health && typeof etcd_health === 'string') {

    // Check if the string contains "healthy"

    var status = "unhealthy";  // Default status


    if (etcd_health.includes("healthy")) {

        status = "healthy";

    }


    // Save the status in the state for later use

    state.etcd_status = status;

    // You can store a debug message for later viewing

    state.debug_message = "ETCD Health Status: " + status;

} else {

    // Handle the case where `etcd_health` is undefined or not a string

    state.etcd_status = "unknown";  // Default status for error cases

    state.debug_message = "Error: 'etcd_health' is undefined or not a string.";

}


Posted By Nikhil02:38
Filled under:

 // Ensure etcd_health is defined before using .includes()

var etcd_health = state.etcd_health;  // Assuming `etcd_health` is the variable holding the output


// Check if etcd_health is defined and not null

if (etcd_health && typeof etcd_health === 'string') {

    // Check if the string contains "healthy"

    var status = "unhealthy";  // Default status


    if (etcd_health.includes("healthy")) {

        status = "healthy";

    }


    // Log the status for debugging

    console.log("ETCD cluster status:", status);


    // Optionally store the status for use in later states

    state.etcd_status = status;

} else {

    // Handle the case when etcd_health is undefined or null

    console.log("Error: 'etcd_health' is undefined or not a string.");

    state.etcd_status = "unknown";  // Set a default or error state

}


Posted By Nikhil02:35
Filled under:

 let etcd_health = "healthy"; // Example input

let status;


if (typeof etcd_health === "string" && etcd_health.includes("unhealthy")) {

    status = "not_good";

} else {

    status = "good";

}


console.log(status);

Posted By Nikhil02:21
Filled under:

 let clusterHealth = "unhealthy"; // Example value, replace this dynamically

let statusMessage;


if (clusterHealth.includes("unhealthy")) {

    statusMessage = "Cluster is not healthy";

} else {

    statusMessage = "Cluster is healthy";

}


console.log(statusMessage); // This is just for testing, you can remove it.

Posted By Nikhil01:47

Thursday, 27 March 2025

Filled under:

 Request for Confirmation on Privileges and Role Assignment for Account [Account ID/Name]

Dear [Application Team],

I hope this message finds you well.

As part of our regular review, we noticed some deviations concerning the privileges assigned to the account [Account ID/Name]. Specifically, the account currently holds certain privileges and roles that appear to be outside the standard compliance guidelines.

Could you please confirm whether these privileges and the associated role were explicitly requested by your team? If this is not the case, would you like us to revoke these privileges and roles to ensure compliance?

Please note that while the account is currently in a locked state, we wanted to confirm this with you before taking any further action.

Looking forward to your response.

Posted By Nikhil02:46

Tuesday, 25 March 2025

Filled under:

 

Subject: Oracle Discoverer Connectivity – Not in DBA Scope

Hi [User's Name],

This issue is outside the scope of the Database team, as we only handle database-related matters. As mentioned in the KB article, please contact the migration team for assistance. Meanwhile, checking Stack Overflow for similar issues or posting a question there may help.

Best,
[Your Name]
Database Team

Posted By Nikhil17:28
Filled under:

 Thank you for assigning the issue. I acknowledge the request and will look into it.

Since this was reported by users in US hours, some details or troubleshooting performed by our team available during these hours would have helped in taking this further. Anyways, I will try to find a mutual time to connect with the team.

Hi [User's Name],
Please suggest a suitable time to connect. As we are in different time zones and I have some deliverables in hand, there may be a slight delay in my response in case I am unable to connect immediately.

Also, could you confirm if a ticket has already been raised for this and whether the escalation POCs of the respective regions have been contacted? If not, please proceed with raising a ticket.

Let me know your availability so we can coordinate accordingly.

Posted By Nikhil05:30

Monday, 24 March 2025

Filled under:

 Thank you for reaching out regarding the issue you're experiencing with the backup history in the Backup-Affirmation tool.

Please note that the DBA team primarily handles database-related tasks and does not have full oversight of the Backup-Affirmation tool. For checking backup details, I would recommend using the Simpana-Report tool, which provides more comprehensive backup information.

If you continue to encounter issues or need additional assistance with the Backup-Affirmation tool, I kindly suggest contacting the owner of the tool, as it is not directly managed by the DBA team.

Please let me know if you need any further assistance.

Posted By Nikhil01:56

Sunday, 23 March 2025

Filled under:

 

Here’s a professional and balanced way to start the conversation during the call:


**"Thank you all for joining the call. I appreciate the opportunity to align expectations and ensure smooth collaboration between the database and application teams.

While working on this project, I’ve observed a few challenges that I’d like to discuss to improve efficiency and coordination. One key aspect is availability—our team is fully committed to supporting the application team, but there have been instances where issues across multiple environments, including both production and development, are being treated with the same level of urgency. Understanding the priority structure will help us manage resources effectively.

Additionally, call scheduling has been a bit unpredictable at times. While we do align on a specific time, there have been cases where the actual call happens at a different time, which makes it difficult to plan effectively. If we can bring more consistency to the scheduling, it would certainly help in providing the best possible support.

I’d love to hear your thoughts on how we can establish a more structured approach that works for both teams. Our goal is to ensure that all critical issues are addressed promptly without compromising operational efficiency."**


This keeps the conversation constructive while highlighting the concerns. Let me know if you’d like to adjust the tone further!

Posted By Nikhil18:56

Saturday, 22 March 2025

Filled under:

 

MS Teams Message:

"Hello Team,

The BCM activity for DC isolation has been successfully completed one hour ahead of schedule with no issues encountered.

Additionally, there is a pre-market open call scheduled on Monday at 4 AM SGT. I have forwarded the invite to Rocky, who will be representing from the DB side.

Let me know if you have any questions.

Thanks!"

Posted By Nikhil02:17

Friday, 21 March 2025

Filled under:

Thank you so much for the outstanding coordination and dedication as always  in making the BCM activity a success!


Your meticulous planning, quick responses, and valuable insights were key in ensuring a smooth execution. Your teamwork and commitment are truly appreciated—thank you.

Posted By Nikhil21:01
Filled under:

 I wanted to check how the recent ticket report was generated, as it seems to include cancelled tickets from 2021 or tickets in different queues. Also, could you clarify why only specific members were assigned to DB restore tickets?

Posted By Nikhil04:13

Thursday, 20 March 2025

Filled under:

 

Subject: Notification: BCM Activity Scheduled for Tomorrow – Database Team Involvement

Dear [Database Leads' Names],

I would like to inform you that the BCM activity is scheduled for tomorrow during early APAC hours. All planning and discussions with the infrastructure teams have been completed, and resource allocation from our team has been finalized. Below are the execution details:

Execution Timelines

Application & Database Details

The respective DBAs will be available for support during the activity. Please let me know if you have any questions or need further details.

Best Regards,
[Your Name]
[Your Role]
[Your Contact Information]

Posted By Nikhil18:16

Wednesday, 19 March 2025

Filled under:

 We have updated the ticket creation page to include radio buttons that, when selected, display relevant self-service options before users raise a ticket. Since our team performs the same self-service tasks after ticket creation, this update helps redirect users to the self-service page earlier, encourages them to review related solutions, and ensures more accurate issue descriptions when tickets are necessary.

Additionally, we have modified another page, which I will demonstrate in tomorrow’s call.

Posted By Nikhil05:06
Filled under:

 We acknowledge your request to proceed with the BCM on the planned date, and we are considering this change accordingly. However, we would like to highlight that throughout the past few weeks of planning, we had not received any updates via the central portal. While we appreciate the database list provided over email, we had previously requested clarification regarding the target databases (attached email for reference) since they are not hosted in Sydney, but did not receive a response.

To ensure a smooth execution, we would need additional details before we approve the change and plan the resource. Please note that this is crucial, as there are other databases scheduled in the early APAC hours, and we have only one resource from Singapore managing tasks for both Oracle and PostgreSQL.

Kindly provide the following details at the earliest:

  1. Which component of this setup is hosted in Sydney?
  2. At what time should the DB team proceed with the database task?
  3. Which site should be the new leader before isolation?
  4. Who will be the application team’s point of contact during the activity?

Your prompt response will help us plan accordingly and avoid last-minute issues.

Posted By Nikhil04:57

Monday, 17 March 2025

Filled under:

 Assistance for TOAD Issues on User Machines


Important Notice


The Infrastructure Team handles core TOAD-related issues, not the Database Team. If you are facing problems due to workspace restarts, drive migrations, or missing drives, your TOAD files may need to be restored manually. Follow the steps below to resolve the issue.


Steps to Restore Missing TOAD Files


1. Check for Backup:


Look for a backup of your TOAD settings or workspaces in your user profile or backup folder.




2. Locate the Default TOAD Directory:


Navigate to C:\Users\<your_username>\AppData\Roaming\Quest Software\Toad for Oracle\<version>


If the files are missing, proceed to the next step.




3. Restore from Previous Version (if available):


Right-click the folder where TOAD settings were stored.


Select Properties > Previous Versions and check if a restore point is available.




4. Manually Copy Files (if backed up elsewhere):


If you have a backup, copy the necessary TOAD configuration files back to the appropriate location.




5. Reconfigure Drive Mapping (if applicable):


If the drive was migrated, check with IT support to ensure the correct mapping is available.




6. Restart TOAD:


Close and reopen TOAD to check if your settings are restored.





Related Assist Articles


For more help, refer to the following articles:


[Restoring TOAD Settings from Backup]


[TOAD Workspace Recovery Guide]


[Drive Mapping Issues and Solutions]



For 

further assistance, please contact the Infrastructure Team.


Posted By Nikhil21:13

Friday, 14 March 2025

Filled under:

 

Subject: Transmit Database Server Patching Incomplete Due to Tanium Issues & Lack of Acknowledgment

Hi Team,

The transmit database server patching could not be completed due to issues on the Tanium side. Additionally, there was a lack of response acknowledgment from the application team at the start of the activity and from the Unix patching team when the Tanium issue was identified.

We need to address these challenges to ensure smoother execution in the future. Please advise on the next steps for rescheduling the patching.

Let me know if further details are required.

Best regards,
[Your Name]

Posted By Nikhil22:29
Filled under:

 

Subject: Urgent: Awaiting Application Team’s Confirmation for Scheduled Patching

Dear [Application Team],

As you are aware, the patching activity is scheduled for [date & time], and we are currently awaiting your confirmation to proceed. However, we have noticed that this delay in response has been a recurring issue in the past, impacting the overall schedule and execution.

To ensure a smooth and timely patching process, we request your prompt confirmation at the earliest. Please acknowledge and confirm the go-ahead so that we can proceed as planned.

Looking forward to your swift response.

Best regards,
[Your Name]
[Your Team/Department]
[Your Contact Information]

Posted By Nikhil19:25

Thursday, 13 March 2025

Filled under:

 

Subject: Assistance with Your Request

Dear [User's Name],

Thank you for reaching out. I have referred to our available assist articles and believe they contain the information you’re looking for. You can find the relevant details here: [Insert Link to Assist Articles].

Additionally, I have created the cast for now. However, as I understand, this action is typically performed by a super user. It would be good to check from your end whether your dbowner privilege also allows you to do this.

Please review the provided information, and let me know if anything is missing or if you need further clarification. I’d be happy to assist you further.

Best regards,
[Your Name]
[Your Position]

Posted By Nikhil20:51
Filled under:

 

Subject: Follow-up on Backup-Related Strike Alerts

Hi [Recipient's Name],

I have checked into the issue regarding backup-related strike alerts not appearing. Here are my findings:

  • There haven’t been many incoming strike alerts in the DB queue for March.
  • The backup queue does have some tickets related to Oracle, which aligns with the expected logic, as those specific errors should generate tickets in their queue.
  • However, there are several databases that did not generate incidents automatically. Upon checking in BigPanda, I couldn’t find associated alerts for these databases.

Before we request the backup team to investigate further, we need a second round of checks to confirm our findings. Below is the list of databases that did not create incidents, but for which the backup team manually created incidents:

[List of Databases]

Let me know how you’d like to proceed.

Best,
[Your Name]

Posted By Nikhil18:43

Thursday, 6 March 2025

Filled under:

 We assume that backup failure issues have reduced to some extent, and there might be very few instances where escalation is required. That said, we always strive to allocate resources promptly to take immediate action if a ticket is pending for resolution.

However, we have observed that in some cases, strike alerts are not being generated, and as a result, we are only noticing failures when a manual ticket is raised by the backup team. We may need to investigate why strike alerts are not appearing for certain instances.

In the meantime, if there is a need for escalation, please feel free to include Abigail to ensure the necessary traction.

Let us know if you need any further clarification.

Best regards,
[Your Name]
[Your Team]

Is this conversation helpful so far?

Posted By Nikhil22:19

Wednesday, 5 March 2025

Filled under:

 I sincerely apologize for the lack of acknowledgment on this issue while I was on vacation. I understand that repeated follow-ups were needed, and I appreciate your patience. The backup failure has now been resolved.

We truly value our collaboration with the infra team and recognize the importance of prompt responses. If you ever encounter a similar situation where there's no response, please don’t hesitate to escalate to our APAC Escalation Manager or Chapter Leader to ensure a quicker resolution.

Thanks again for your support. Let me know if any further verification is needed.

Posted By Nikhil07:11
Filled under:

 I have now investigated and resolved the backup failure. I truly appreciate your follow-ups and patience while this was pending. Thank you for bringing it to our attention and for your continued support.

Please let me know if you notice any further issues.

Posted By Nikhil07:00