Expdp failed with ORA-39047 ORA-39047: Jobs of type TRANSPORTABLE cannot use multiple execution streams

Error Description:
Data Pump export (expdp) with transport_tablespace failed with following error.
date;expdp dumpfile=TTS.dmp%u logfile=TTS.log directory=TTS transport_tablespaces=USERS PARALLEL 16;date
Fri Jul 21 05:00:39 CUT 2017

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
         Available space (kbytes) :     407856

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

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

SQL> host pwd

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"

Oracle 12c Data Redaction (Full, Partial, Random, Regular Expression) Implementation Examples

Let’s first create a sample test table 'TEST_DATA' under REDACT schema.
SQL> grant EXECUTE ON sys.dbms_redact TO REDACT;

Grant succeeded.

SQL> grant connect, resource to REDACT;

Grant succeeded.

Sample table created with following data

ERROR: OMS_HOST cannot be null. Pass OMS_HOST value either as command-line arguments or in response file

Error Description
Manual OEM agent deployment failed with following error.
[oracle@xlracnde101 agent12c]$ ./agentDeploy.sh AGENT_BASE_DIR=/u01/app/oracle/agent12c RESPONSE_FILE=/u01/app/oracle/agent12c/agent.rsp

3 Ways to Invoke / Open Vi Editor by ed Command in SQLPLUS

Generally, SQLPLUS takes the default editor by the OS. You can bypass the OS default editor using following settings. There are 3 option to set vi as the editor for the sqlplus command.
Option 1: define_editor=’vi’ - Temporary for each sqlplus session

Fix terminating the instance due to error 27625; Instance terminated by RBAL, pid = ; summary=[abnormal instance termination]

Error description
ASM instance is down with following messages in the alert.log file.
NOTE: ASMB mounting group 2 (DATA_T1)
Fri Sep 16 01:39:42 2016
WARNING: cellinit.ora is missing. RBAL is terminating the instance.
RBAL (ospid: 11489): terminating the instance due to error 27625

Silent Installation of OEM 12c agent: manually using emcli, scripts and response file

We need to install the OEM agent in the target server which we need to monitor from the OEM console. Generally, we can do this by OEM console itself. If it allows the agent installation through OEM is well and good as it is the easiest way. Sometimes we as DBA faces issues in installing the agents in the target server by the OEM console add host, target options. In such situations we can use below method to install the agent in the target server and easy we get it monitored from the OEM.  

onewaycopyAction : Source File dropdb.pl" does not exists or is not readable; Cannot copy file from 'dropdb.pl' to '/u01/app/12.1.0/grid/crs/install/dropdb.pl'

Error Description
Opatch napply failed with following error
[grid@ patch]$ /u01/app/12.1.0/grid/OPatch/opatch napply -oh /u01/app/12.1.0/grid -local /u01/installs/patch/23273629/23054327
Oracle Interim Patch Installer version
Copyright (c) 2016, Oracle Corporation.  All rights reserved.

Steps to Recover Database from RMAN Backup TAG

RMAN Script
Hear the RMAN tag is TAG='TAG20160921T013645'
run {
allocate channel ch1 device type DISK;
allocate channel ch2 device type DISK;

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