Error : The request could not be mapped to any database. Check the request URL is correct, and that URL…
Tag 12c
— Go to Directory location for Statspack Install scripts on the VMDB host —cd /u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/admin — From cdb$root — sqlplus…
Amazon Web Services has been gaining popularity in the last few years since cloud computing has been in the spotlight.…
One of my readers today send me an error they got while restoring a database via RMAN RMAN> startup mount;…
If you are going to work on Oracle Database in cloud or in environments where X11 client or server is…
1. Add Encryption Wallet in sqlnet.ora Location $ORACLE_HOME/network/admin [oracle@localhost admin]$ vi sqlnet.ora ENCRYPTION_WALLET_LOCATION = (SOURCE =(METHOD = FILE)(METHOD_DATA = (DIRECTORY…
Upgrade from Exadata X4-2 11g (11.2.0.4) to Exadata X7-2 12CR1 (12.1.0.2.0) : ASM to ASM Oracle Database 11.2.0.3and 11.2.0.4 to…
Error in Alert Log: Errors in file /u03/app/oracle/diag/rdbms/primeprd/primeprd1/trace/primeprd1_ora_303370.trc (incident=1070393): ORA-00600: internal error code, arguments: [audins:Invalid_param_type_for_binding], [], [], [], [], [],…
spool index_rebuild.sql select ‘alter index ‘||owner||’.’||index_name ||’ rebuild online nologging;’ from dba_indexes where owner=upper(‘SAMPLE’); spool off
The new PL/SQL procedure REDEF_TABLE in Oracle 12c lets you redefine a table online in a single step. It can…
One of the amazing features of Oracle Database 12c is that now you can do a logical restore from…
This is caused by a mismatch between the character set in which the table radm_fptm$ is created and in which…
Oracle 12c TDE on RAC Database with Physical Standby RAC. The Oracle Database Home has Multiple Instances, due to which…
The Unified Auditing in Oracle 12c can Grow the SYSAUX table to a large size. In our case it grew…
The Below Script will generate output if percentage of tablespace space left free is less tan 20%. You can easily…
First Install UTL_MAIL ### To install UTL_MAIL: [code language=”sql”] sqlplus sys/**** @$ORACLE_HOME/rdbms/admin/utlmail.sql @$ORACLE_HOME/rdbms/admin/prvtmail.plb [/code] ### Create a Reporting User ###…
The script below can be used to check the Disk Group Space Free and also Check Directory sizes for each…
Setup for the Environment ——————- Exadata X4-2 Quater Rack n Primary and Standby Site Grid Version : 12.1.0.2 DB Home…
1 ) Set the environment variable also via srvctl @ oracle user. export ORACLE_UNQNAME=’$ORACLE_HOME/bin/srvctl config database |grep -w ${ORACLE_SID%?}’ srvctl…
Configure 12c dataguard broker using the below command onPrimary database server primeprd – > tnsnames for primary database primedr-> tnsnames…
Query to check sessions writing to flashcache on Exadata select se.sid, sn.name, s.value, se.program from v$sesstat s natural join v$statname…
Before we begin this is a note from the Oracle Website The name of these bundle patches was changed to…
export MMSG=/tmp/$$.mail export ADDR=”shadab@easyoradba.com” export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 export ORACLE_SID=orcl file=/tmp/${$}_`date +%Y%m%d` sqlplus -s “/as sysdba” << .eof > $file set pages…
Synonym is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class schema object,…