Author Archives: anargodjaev

Exadata Storage Sever X4-2


Exadata Storage Sever X4-2 Advertisements

Exadata Database Machine X4-2


Exadata Database Machine X4-2

Exadata Storage Expansion Rack X3


Exadata Storage Expansion Rack X3

Exadata Storage Sever X3-2


Exadata Storage Sever X3-2

Exadata Storage Expansion Rack X2


Exadata Storage Expansion Rack X2

Exadata Storage Sever X2-2


Exadata Storage Sever X2-2

Exadata Database Machine X2-8


Exadata Database Machine X2-8

Exadata Database Machine X2-2


Exadata Database Machine X2-2

Pkg update Exadata


root@exadata02:~# cd /u01/staging/SOLARIS11.2/ root@exadata02:/u01/staging/SOLARIS11.2# ls -ltrh total 21828629 -rw-r–r– 1 root root 1.7G Aug 22 11:02 p19298012_1100_Solaris86-64_1of4.zip -rw-r–r– 1 root root 1.2G Aug 22 11:04 p21518848_1100_Solaris86-64_2of3.zip -rw-r–r– 1 root root 1.8G Aug 22 11:04 p19298012_1100_Solaris86-64_2of4.zip -rw-r–r– 1 root root 1.8G Aug 22 11:05 p19298012_1100_Solaris86-64_3of4.zip -rw-r–r– 1 root root 1.7G Aug 22 11:06 p19298012_1100_Solaris86-64_4of4.zip -rw-r–r– 1 […]

HOW to open database in restrict mode


bash-3.2$ sqlplus “/ as sysdba”; SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 5 11:06:43 2016 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount ORACLE instance started. Total System Global Area 2.0583E+10 bytes Fixed Size 2168240 bytes Variable Size 5167385168 bytes Database Buffers 1.5368E+10 bytes Redo Buffers 45907968 […]

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


hen 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@anarexaceladm03 trace]# cat rstrc_15083_mmt.trc Trace file /opt/oracle/cell/log/diag/asm/cell/anarexaceladm03/trace/rstrc_15083_mmt.trc ORACLE_HOME = /opt/oracle/cell System name: Linux Node name: anarexaceladm03.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/ANARTEST/ANARTEST1/trace/ANARTEST1_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@anaruatdb1:/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 ANARTEST -o immediate root@anaruatdb1:~# su – oracle Oracle Corporation      SunOS 5.11      11.3    September 2015 You have mail. bash-4.1$ . .profile_ANARTEST 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 […]

SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.


PROBLEM : Connecting with sqlplus you get: bash-3.2$ sqlplus / as sysdba; SQL*Plus: Release 11.2.0.4.0 Production on Thu Jul 21 15:42:49 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, OLAP, Data Mining and Real Application Testing options SQL> conn […]

enable_novalidate_constraint


select ‘ alter table ‘||table_name|| ‘ enable novalidate constraint ‘ ||constraint_name ||’;’ from user_constraints where table_name =’TABLE_NAME’

create a new user (with privs) like an existing


set pages 0 feed off veri off lines 500 accept oldname prompt “Enter user to model new user to: ” accept newname prompt “Enter new user name: ” — accept psw prompt “Enter new user’s password: ” — Create user… select ‘create user &&newname identified by values ”’||password||””|| — select ‘create user &&newname identified by […]