Category: Premium Content

How To Install Oracle Client In Silent Mode Using Response File

Due to X-Window unavailability, installation of 12.2 Oracle client has to be done through silent mode with response file.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe
Log in

How to Upgrade AWS RDS PostgreSQL With Extensions(2)

In another post “how to upgrade aws rds Postgresql with extensions(1)” we have demonstrated how to upgrade AWS PostgreSQL RDS 9.5.23-R1 to AWS PostgreSQL RDS 9.6.20-R1 with PostGIS extension. According to AWS doc about PostGIS extension:

If a database uses the PostGIS extension, you can’t skip major versions for some source to target combinations. For these circumstances, upgrade in steps to the next major version one step at a time until you reach the desired target version.

So in this post, we will show how to upgrade AWS PostgreSQL RDS 9.6.20-R1 with PostGIS extension to AWS PostgreSQL RDS 10.15-R1.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe
Log in

Tasks of After Major Version Upgrade

  • Run the ANALYZE operation to refresh the pg_statistic table.
  • Optionally, use Amazon RDS to view two logs that the pg_upgrade utility produces. These are pg_upgrade_internal.log and pg_upgrade_server.log. Amazon RDS appends a timestamp to the file name for these logs. You can view these logs as you can any other log. For more information, see Amazon RDS database log files.You can also upload the upgrade logs to Amazon CloudWatch Logs. For more information, see Publishing PostgreSQL logs to CloudWatch Logs.
  • To verify that everything works as expected, test your application on the upgraded database with a similar workload. After the upgrade is verified, you can delete this test instance.

How to Upgrade AWS RDS PostgreSQL With Extensions(1)

One of the client just received notifications about end of support for AWS PostgreSQL RDS 9.5. They do have a couple of PostgreSQL RDS 9.5 in AWS. Some of them are using PostGIS extensions.

This post demonstrates step by step how to upgrade AWS PostgreSQL RDS 9.5.23-R1 to AWS PostgreSQL RDS 9.6.20-R1. Certainly the upgrading method in this post can be applied to other versions as well like AWS PostgreSQL RDS 10, 11 and 12, etc.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe
Log in

Failed to connect to ASM instance. The connection is closed: The connection is closed

One client OEM reports the following incidents intermittently from OEM 13c.

Host=racnode1.virtuallab
Target type=Automatic Storage Management
Target name=+ASM1_racnode1.virtuallab
Categories=Availability
Message=Failed to connect to ASM instance. The connection is closed: The connection is closed
Severity=Fatal
Event reported time=20/12/2020 09:19:01AM EST
Target Lifecycle Status=Test
Operating System=LINUX
Platform=X86_64
Associated Incident Id=12345
Associated Incident Status=New
Associated Incident Owner=oracle
Associated Incident Acknowledged By Owner=No
Associated Incident Priority=High
Associated Incident Escalation Level=0
Event Type=Target Availability
Event name=Status
Availability status=Down

Let’s do some investigations, and provide the easy workaround if patches are unavailable to some clients.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe
Log in

How to Check Process Memory Usage in Linux

This post demonstrates how to check a process memory usage in Linux. While there are system resource issues, it is always helpful to identify the root cause by checking suspected process memory usage, which can be memory leaking from time to time.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe
Log in