It's all about the answers!

Ask a question

How to configure table space folder for data warehouse with Oracle RAC?


ankur sharma (66212228) | asked May 06 '13, 2:50 a.m.
JAZZ DEVELOPER
In system requirement https://jazz.net/library/article/1109, we mentioned support Oracle RAC 11gR2 for CLM 401 and 402. With Oracle RAC, in jts/setup step "Configure Data Warehouse", how to configure the "Database Table Space Folder"

2 answers



permanent link
ankur sharma (66212228) | answered May 06 '13, 2:53 a.m.
JAZZ DEVELOPER
Thanks @ffusier  (Frederic Fusier) for the answer.

 For the cluster, the database location can be:
com.ibm.team.datawarehouse.db.jdbc.location=thin\:dwDBuser/{password}@//{dwh-server}\:1521/{db-instance}
Hence, all table spaces files are located in /u01/oradata/{db-instance} directory 

The entry for "Database Table Space Folder" is an initially empty directory with same access rights that above directory.
that is: com.ibm.team.datawarehouse.db.base.folder=/u01/oradata/{jazz-dwh}

permanent link
Zaid Md (11) | answered Oct 13, 3:26 a.m.
edited Oct 13, 5:07 a.m. by Ralph Schoon (58.9k23642)
Oracle RAC database uses files that are external to the database, then the external files must be located on shared storage that is accessible to all nodes.

Each node must use the same mount point to access the file.

Acceptable shared file systems include Database File System (DBFS), Oracle Automatic Storage Management Cluster File System (Oracle ACFS), or a supported network file system (NFS) using the Direct NFS Client.
The database directory object used to write and read files external to the database must point to a shared storage location.
Each node must use the same mount point for the same shared storage location.
For example, each node can have a directory object called DPUMP for the mount point 
C:\app\acfsmounts\dpump, 
which accesses Oracle ACFS shared storage.

Disclaimer: There is no checking of the contents of the external files or directory object specified as part of the external table to ensure that the directory contents are consistent on each node. To avoid unpredictable results, you must ensure that the same file is accessed from all nodes, or that the same file is used on all nodes.


Comments
Ralph Schoon commented Oct 13, 5:07 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

I consider this spam, based on the ad link that I removed.  

Your answer


Register or to post your answer.