Error Description:
Data Pump export (expdp) with transport_tablespace failed with following error.
Expdp failed with ORA-39047 ORA-39047: Jobs of type TRANSPORTABLE cannot use multiple execution streams
How to Copy and Multiplex Oracle OCR into Different Disk Group
[root@]# ocrcheck Status of Oracle Cluster Registry is as follows : Version : 4 Total space (kbytes) : 409568 Used space (kbytes) : 1712
Check/Find Location and Status of Oracle OCR and VOTEDISK
What is OCR and Voting disk:
The voting disk is a file that manages information about node membership, and the OCR is a file that manages cluster and Oracle RAC database configuration information.
PROC-50 PROT-30: The Oracle Cluster Registry location to be added is not usable
Error Description:
Oracleasm listdisks shows the disk but Ocrconfig -add command failed with following error message.
Settings to Run SQLPLUS from Other or Non-Oracle User
Add a new unix user as readuser
[root@Test]# useradd readuser [root@Test]# passwd readuser Changing password for user readuser.
Steps to Remove / Deinstall Oracle OEM, OMS from Unix Server
You have to use OUI with deinstall option to remove the components
installed by the OEM or OMS. See the steps below.
Step 1:
Oracle Sql Query to Find Out Number Of Weeks Between Two Dates
In this post I would like to give a query to find out the number of weeks between two dates.
Query
