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 →

Advertisement

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 →