Monthly Archives: March 2015

How many different type of wait event parameters in Oracle 12c (12.1.0.2)


PARAMETER1 COUNT(*) —————————————————————- ———- name|mode 463 456 type|mode 200 address 50 file# 40 sleeptime/senderid 40 cellhash# 22 location 19 count 18 17 driver id 16 group 16 group# 14 Session ID 13 2=>GoldenGate 1=>XStream 0=>Streams 12 session_id 8 where 8 idn 7 sleep time 7 function_id 7 waittime 6 blkno 5 p1 5 filectx 5 […]

Database link with SSL SQL*Net encryption


SQL> connect anar/password Connected. SQL> select instance_name from v$instance; INSTANCE_NAME —————- KBAZER2 SQL> create database link KBAZER1 connect to anar identified by password using ‘KBAZER1_tcps’; Database link created. SQL> select instance_name from v$instance@KBAZER1; INSTANCE_NAME —————- KBAZER1 From listener.log: 2015-03-15 18:30:47.2801020 +10:00 2015-03-15 18:30:47 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=KBAZER1)(CID=(PROGRAM=oracle)(HOST=SONUNW)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcps)(HOST=x.x.9.27)(PORT=2854)) * establish * KBAZER1 * 0

The database is down. Please specify the host credentials to access database restart and diagnostics tools


The database is down. Please specify the host credentials to access database restart and diagnostics tools. Enterprise manager shows that database is down but in real it is not. [oracle@oel6 trace]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Fri Sep 13 10:38:01 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: […]

It’s a great honor and proud for me..


Some months ago, I had the great opportunity to be profiled for the Peer-to-Peer column of the Oracle Magazine, which is an international publication published by Oracle on a monthly basis.So, It’s a great honor and proud for me that my profile featured in Peer to Peer section of Oracle Magazine in March/April 2015 issue […]

RA-01503 ORA-01189 When trying to Recreate Controlfile


SYMPTOMS Sun Aug 17 14:04:07 2014 Media Recovery failed with error 16433 Slave exiting with ORA-283 exception Errors in file /oradump/prod/edwp/logs/diag/diag/rdbms/ edwprod/EDWPROD/trace/EDWPROD_pr00_32964892.trc: ORA-00283: recovery session canceled due to errors ORA-16433: The database must be opened in read/write mode. Recovery Slave PR00 previously exited with exception 283 ORA-283 signalled during: ALTER DATABASE RECOVER database using backup […]

Running Oracle Processes


select sid, process, program from v$session s join v$bgprocess using (paddr) where s.status = ‘ACTIVE’

Create PDB with Oracle Database 12c


[oracle@anar12c ~]$ sqlplus sys/password@cdbanardb as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Sun Dec 8 22:04:50 2014 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> ! mkdir /u01/app/oracle/oradata/cdbanardb/pdb1 SQL> create pluggable database […]