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. The Oracle Clusterware installation process creates the voting diskand the OCR on shared storage.

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.
[root@]# ocrconfig -add +DATA
PROT-30: The Oracle Cluster Registry location to be added is not usable
PROC-50: The Oracle Cluster Registry location to be added is inaccessible on nodes Node203.

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.
New password:
Retype new password:
passwd: all authentication tokens updated successfully.
[root@Test]# exit

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: Go to em12c installation directory and invoke the runInstaller with deinstall option.

Oracle Sql Query to Find Out Number Of Weeks Between Two Dates

select  abs(to_number(to_char(to_date('&FromDT_dd_mon_yyyy','dd-mon-yyyy'), 'WW'))
  2* - to_number(to_char(to_date('&ToDT_dd_mon_yyyy','dd-mon-yyyy'),'WW')) ) "Number of weeks" from dual

Database Connection Using SQLPLUS Without tnsnames.ora from Command Line

Here is the method to connect to the oracle database using sqlplus without configuring the TNSNAMES from the OS prompt.
Syntax:  sqlplus username/password@Host_name:Listener_port/database_Service_name
Where you must know the username and password for the database.
You can use following options to find out the hostname, Listener port and database service name What is the Reward Point Conversion rate / Value in Rupee or Paise? is the one of the trustworthy Indian government website for the online money making through data entry. But one of the major concern which I face is the slowness of the website. Most of the time the website is utter slow to load the snippets. Your patience is important for this activity at least for these initial days J. Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google