Joords Oracle DBA blog

Oracle 11gR2 is out for Linux, and I decided to upgrade one of my existing 11.1.0.6 database with ASM to 11.2.0.1. Direct upgrade to 11gR2 is supported from 9.2.0.8 or higher, 10.1.0.5 or higher, 10.2.0.2 or higher and 11.1.0.6 or higher. If you have a database 9.2.0.6 then first you need to upgrade to intermediate release i.e 9.2.0.8 then to 11.2.0.1.     9.2.0.6==>9.2.0.8==>11.2.0.1     8.1.7.0==>8.1.7.4==>10.2.0.4==>11.2.0.1 I will show a upgrade of an existing Single Instance 11.1.0.6 database with ASM, having same ORACLE_HOME, to Oracle 11gR2 with ASM. The Oracle environment is a Dataguard structure bases on 11.1.06 with ASM. The new situation will be one ASM instance with 11.2 and Oracle instance 11.1.0.6 The upgrade needs to be performed in two phases: Done       1. Upgrade the ASM instance of one of the DG’s Pending   2. Upgrade the other ASM instance of the DG ...

ZFS is a new kind of file system that provides simple administration, transactional semantics, end-to-end data integrity, and immense scalability. See on opensolaris . what is ZFS. New Information Update Configuring Oracle Solaris ZFS and your Oracle Database – A white Paper which provides planning information and step-by-step instructions for configuring and maintaining Oracle Solaris ZFS file systems for an Oracle database.

Using UTL_DBWS to make a Database Callout to a Document Style Web service provides a method for consuming a Document Style Web Service using the UTL_DBWS package. This package is essentially a PL/SQL wrapper over JPublisher.

When the node reboots CRS does not start automatically de oracle RAC databases See CRS does not autostart when run parallel(Suse) is set to true for more information

Configuring oracle ASMlib on multipath disks on Linux describes the steps required to configure the Linux specific ASM library provided by Oracle (herin "ASMLib") to access multipath disks. It assumes that the multipath disks are already configured with whatever tools are provided by the storage. See also: Technet Configuring Oracle ASMLib on Multipath Disks Configuring udev and device mapper for Oracle RAC 10g Release 2

Imagine a situation where your Oracle database has become corrupted and your backup could either not be restored or was too out-of-date to be worth restoration. The only solution is Data Unloading (DUL) tool by Oracle. Click on Data Unloading (DUL) Oracle Internal tool for more information

In 10g is is not possible to do this . To add a listener to the RAC node you need NETCA to do this. This tool will ceate the listener and does the OCR registration. TNS_ADMIN is often used as a user environment variable on database servers. If you are using this variable in a RAC environment, you need to set this in the cluser respository (OCR). Do this by using the following command: servctl setenv database -d db_name -t TNS_ADMIN=tns_admin_path    With 11.1, you can now use the srvctl add listener command to add the listener resource to the OCR. However, it’s simpler to use NETCA rac-server1$ export ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 rac-server1$ export PATH=/bin:rac-server1$ netca /silent /responsefile /network/install/netca_typ.rsp /nodeinfo rac-server5 Click on RAC 10g: Adding Listener OCR and TNS-admin for more information

crsctl.bin: error while loading shared libraries: libnnz11.so: cannot restore segment prot after reloc: permission denied Click on ASM on Single Node on linux: Error Failed configure CSS  for the sollution