When I tried to duplicate one of the databases using the RMAN duplicate, I’ve encountered the block corruption errors on the SYSAUX tablespace. The root cause of corruptions is still unknown to me. With further investigation, I’ve learned that the corrupt blocks do not belong to any objects. (The query used to identify them will […]
During a new setup of our 11g R1 (18.104.22.168) on Solaris platform, initially the system is provided with only single path to disks (LUNs) on SAN. Later the sys admins would like to enable the multipathing. 🙁 Obviously, it is expected that the disk paths will be changed. This will not only affect the ASM […]
Oracle 11g Release 2 for Windows was just released this month. With the availability of the grid infrastructure in this version, I plan to install it on my Windows 7 desktop to see what it can do even if it is just on stand alone environment. In order for database to use Automatic Storage Management […]
I wrote in my previous post about the Access Control Lists to Network Services (e.g., UTL_HTTP, UTL_SMTP, UTL_TCP, etc.) in Oracle 11g. However, it did not cover another PL/SQL network utility package named UTL_INADDR which retrieves host names and IP addresses of local and remote hosts. You can read some usage samples of the UTL_INADDR […]
Oracle Database 11g Release 2 (22.214.171.124.0) for Solaris (SPARC) (64-bit) platform is now available for download.
Our organization requires a regular password change on some database accounts for security compliance. If this account is used in the database link in other database, that database link has to be dropped and recreated with an updated password. This changes in 11gR2 because it now offers the alter database link to change password. No […]