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:…
Tag oracle
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
Install VSFTP RPM from the DVD media *Mount the Media and go to Directory cd /media rpm -ivh vsftpd-2.2.2-11.el6.x86_64.rpm Configure…
One of the best books I have read on any Oracle technology. Must read if you need to know practical…
Mogens Norgaard ( He is Danish, and my Danish is rubbish. So i hope i got his name right :D)…
<div style=”margin-bottom:5px”> <strong> <a href=”https://www.slideshare.net/OracleMKTPR20/database-consolidation-on-oracle-exadata-13603279″ title=”Database consolidation on oracle exadata” target=”_blank”>Database consolidation on oracle exadata</a> </strong> from <strong><a href=”http://www.slideshare.net/OracleMKTPR20″ target=”_blank”>Oracle…
— Count number of sessions oracle for 7 days, Provided you keep data that long — [sourcecode language=”sql”] select to_char(BEGIN_INTERVAL_TIME,’HH24′), ROUND(SUM(CURRENT_UTILIZATION)/COUNT(*))…
Oracle has released the much anticipated patchset release to Oracle 11gR2 database. The patch is available on My Oracle Support search…
In case you want to search a string or any other number in all tables inside a schema. Then there…
This error occurs when an expression is divided by zero. It is considered a logical error in Oracle. In mathematics,…
Just finished installing Oracle 12c on Cent OS 6.3. From the looks of it 12c looks like a winner. Oracle…
In this exercise we will copy a file residing on a filesystem onto ASM disk. [sourcecode language=”sql”] SQL> create or…
Oracle Locking Mechanism Probably the best article out their explaining Oracle’s locking mechanism. Oracle Guru Arup Nanda explains the mystical…
Flashing Back a Failed Primary Database into a Physical Standby Database The following steps assume the user has already performed…
————- Drop Database Manually Oracle ——————— 1. First get the datafiles, control files and redo log files location Login to…
Well to put it across in a few words. A trigger is a part of a transaction and not a…
Suppose you need to fire a trigger based on the change of value of a column and then perform some…