Monthly Archives: August 2016

Uninstall XML Database: Oracle 11g


$ cd $ORACLE_HOME/rdbms/admin bash-4.1$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 25 09:20:00 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options […]

ORA-24248: XML DB extensible security not installed


bash-4.1$ cd $ORACLE_HOME/rdbms/admin bash-4.1$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 25 09:20:00 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options […]

CATPROC – Packages and Types Invalid in Dba_registry


Dba_registry shows ‘Packages and Types’ as invalid. How it can be validated. SQL> select comp_name, version, status from dba_registry; COMP_NAME VERSION STATUS —————————————- ———- ———- Oracle XML Database 10.2.0.1.0 VALID Oracle Database Catalog Views 10.2.0.1.0 VALID Oracle Database Packages and Types 10.2.0.1.0 INVALID JServer JAVA Virtual Machine 10.2.0.1.0 VALID Oracle XDK 10.2.0.1.0 VALID Oracle Database […]

Exadata: socket open error: Port no: 8888. Received errorno 111. Connection refused


When I checked the Exadata cell storage log Alert seen such an error : MS process is not alive. Pid is missing. Exadata Cell Storage Alert log: [root@bakuexa1celadm03 trace]# cat rstrc_15083_mmt.trc Trace file /opt/oracle/cell/log/diag/asm/cell/bakuexa1celadm03/trace/rstrc_15083_mmt.trc ORACLE_HOME = /opt/oracle/cell System name: Linux Node name: bakuexa1celadm03.kfsaz.local Release: 2.6.39-400.264.6.el6uek.x86_64 Version: #1 SMP Tue Dec 1 16:41:42 PST 2015 Machine: […]

ORA-15025: could not open disk “/dev/rdsk/emcpower2a” ORA-27041: unable to open file SVR4 Error: 13: Permission denied Additional information: 3


Issue ====== Getting frequent errors as below Mon Jun 20 18:58:09 2016 Errors in file /u01/app/oracle/diag/rdbms/aztest/AZTEST1/trace/AZTEST1_ora_16361.trc: ORA-15025: could not open disk “/dev/rdsk/emcpower2a” ORA-27041: unable to open file SVR4 Error: 13: Permission denied Additional information: 3 WARNING: failed to read mirror side 1 of virtual extent 23 logical extent 0 of file 259 in group [1.443862875] […]

Oracle / Grid permission and group owner will not work ORA-12547: TNS:lost contact (RAC environment)


root@bakuabsutdb1:/u02/app/11.2.0/grid > su – grid Password: Oracle Corporation      SunOS 5.11      11.3    September 2015 -bash-4.1$ bash bash-4.1$ . .profile_asm bash-4.1$ srvctl stop database -d AZTEST -o immediate root@bakuabsutdb1:~# su – oracle Oracle Corporation      SunOS 5.11      11.3    September 2015 You have mail. bash-4.1$ . .profile_aztest bash-4.1$ cd $ORACLE_HOME/bin bash-4.1$ ls -ltr oracle -rwsr-s–x   1 oracle   asmadmin 258286384 […]

Drop Database Manually


1. Login to sqlplus as sysdba and execute below script : oradba@ANARDB:~$ export ORACLE_SID=ANARDB oradba@ANARDB:~$ sqlplus SQL> select name from v$database; NAME ——— ANARDB 2. Open the set server output on to get the result from below query. SQL> set serveroutput on; 3. Execute the query to get the information of datafiles, control files and […]