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

Query
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

digitizeindia.gov.in: What is the Reward Point Conversion rate / Value in Rupee or Paise?

Digitizeindia.gov.in 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.

digitizeindia.gov.in: Snippets have exhausted. Please try again later

Digitizeindia.gov.in is the one of the trustworthy Indian government website for the online money making through data entry. It works based on the online data entry work. The snippets are the scanned documents from the different government organizations. Most of the time you will get enough snippets for the data entry. But at least some days or during particular time you may face the following pop up with message “Snippets have exhausted. Please try again later”

2 Ways to Run / Execute OS (Unix, Linux, Windows) Commands, Shell Script from SQLPLUS or SQL prompt

OS Commands Execution
You can use either ! or host keyword to execute OS commands or to run shell script from the sqlplus / sql prompt.

Here are some examples for OS command execution
SQL> !pwd
/home/oracle

SQL> host pwd
/home/oracle

Fix Oracleasm Deletedisk Command Failed with Unable to Clear Disk “Disk Name”

Error Description
Oracleasm deletedisk diskname failed with following error
# oracleasm deletedisk OCR_VOTE
Clearing disk header: failed
Unable to clear disk "OCR_VOTE"

 

acehints.com Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google