Month: March 2020

Solaris zone or Oracle VM Server? An interesting story

The story was about a project which the system is running on Solaris SPARC platform. I was told the system is a Solaris zone and I had the access of the global zone. From the global zone, I could see 3 non-global zones and one of them was the system I needed to work on. … Continue reading Solaris zone or Oracle VM Server? An interesting story

You are not allowed to access to (crontab) because of pam configuration.

One day you notice you cannot access the crontab for a particular user on an Oracle Linux system. The messages are when "crontab -l" is executed: Authentication token is no longer valid; new one requiredYou (user) are not allowed to access to (crontab) because of pam configuration. If nothing has changed on this system, it's … Continue reading You are not allowed to access to (crontab) because of pam configuration.

RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

Quite often we run into “RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece” when restoring a controlfile from autobackup, especially when trying to restore the backup from a differnt machine and a recovery catalog -- a database schema that contains the RMAN repository data for one or more target … Continue reading RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

Disable or add hint for queries you cannot touch the query text

Yesterday I was asked to look into an query performance issue with a legacy product which is still running on Oracle 11g (11.2.0.4). The query has a hard-coded hint which caused a full table scan, and in turn, that caused a lot of I/O because the table is quite large. Since this is a legacy … Continue reading Disable or add hint for queries you cannot touch the query text