Synonym is an alternative name for a table, view, sequence, procedure, stored function, package, materialized view, Java class schema object,…
Tag 12c
While installing Oracle 12c on Linux you can get this error. The solution is very easy just unset the ORA_CRS_HOME…
One of the best sites for scripts related to checking library cache locks… http://allappsdba.blogspot.qa/2012/04/to-check-library-cache-lock-contention.html
ORA-00245: control file backup failed; target is likely on a local file system RMAN-08132: WARNING: cannot update recovery area reclaimable…
A 600 slide presentation by Oracle DB Product Manager Mike Dietrich, to upgrade and migrate to Oracle 12c. Upgrade_and_Migrate_12c
After a memory upgrade in our RAC servers, the Cluster wasn’t coming up after a reboot. We first tried to…
prompt ************************************ prompt **** ASH OVERALL WAIT PROFILE prompt ************************************ set lines 999 SELECT MIN(sample_time) min_ash_available,sysdate-MIN(sample_time) available duration FROM v$active_session_history;…
http://gavinsoorma.com/2012/11/ash-and-awr-performance-tuning-scripts/
Install and Configure Oracle Application Express Apex 5.0, 4.2.6, 4.2.x with Embedded PL/SQL Gateway
1. Download Software as Zip file from OTN http://www.oracle.com/technetwork/developer- tools/apex/downloads/index.html 2.Unzip apex_5.0_en.zip Software to ORACLE_HOME directory, it will create a…
Since it was announced in Early 2010 that Oracle GoldenGate will be the RoadMap for Replication for Oracle Database, The…
Starting Testing for In-Memory Column Store on 12.1.0.2. Will post the results for the test very soon on the blog.
Oracle Transparent Data Encryption using Oracle Wallet If you wish to use a wallet specifically for TDE, then you must…
Oracle has just announced a suite of new Engineered systems. Of particular significance is the announcement of the Generation 6…
For running a single SQL Command via sqlplus on multiple servers, we have to first do a few pre-requisites 1.…
We had an interesting scenario where we did a full rman refresh of a standby database becuase the archivelogs went…
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor TNS-12541: TNS:no listener TNS-00511: No listener ERROR: ORA-12560:…
Change OEM SYSMAN password Incase you have forgotten the sysman password 1. Login to Cloud Control 12c database SQL> alter…
ACFS stands for ASM Cluster filesystem, which is basically a cluster filesystem on top of ASM Diskgroups. It is similar to…
1) Query on old standby database (new primary) SQL> SELECT TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) FROM V$DATABASE; TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) —————————————- 12496643189 2) Flash back the…
The below command will not import the dump, but will just create a .sql file with the DDL statements impdp…
set lines 999 select GROUP_NUMBER,NAME,TOTAL_MB/1024/1024 as “Total Space in TB” ,FREE_MB/1024/1024 as “Free Space in TB” ,DATABASE_COMPATIBILITY from v$asm_diskgroup;
— Move SPFILE to ASM RAC — Already we have a PFILE called initmove.ora which was created previously from spfile…
Oracle has released Enterprise manager 12c RC4 version. It is available to download, link below http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/index.html
Very well explained article why Storage Snapshots are not the best way for backing up an Oracle database. http://www.oracle.com/technetwork/database/features/availability/rman-fra-snapshot-322251.html?utm_content=buffer67053&utm_medium=social&utm_source=facebook.com&utm_campaign=buffer