Category Oracle İntroduction

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 […]

Solaris 11 javac: command not found


root@bakuabsutdb:~# cd /tmp/ root@bakuabsutdb:/tmp# ls Baku Baku.solaris hmptemp hsperfdata_root root@bakuabsutdb:/tmp# root@bakuabsutdb:/tmp# root@bakuabsutdb:/tmp# root@bakuabsutdb:/tmp# root@bakuabsutdb:/tmp# root@bakuabsutdb:/tmp# ls Baku Baku.solaris hmptemp hsperfdata_root Java_Timezone root@bakuabsutdb:/tmp# root@bakuabsutdb:/tmp# root@bakuabsutdb:/tmp# cd Java_Timezone/ root@bakuabsutdb:/tmp/Java_Timezone# root@bakuabsutdb:/tmp/Java_Timezone# ls azerbaycan.zip once sonra TimeZoneTest.class tzdata2016c.tar.gz tzupdater.jar verify.bat deneme1 once_anar1 sonra_anar TimeZoneTest.java tzdata2016c.tar.gz.sha512 tzupdater.jar_backup verify.sh java once_yeni sonra_anar1 tzdata2016b.tar.gz tzupdater-2_0_3-2015b.zip update.bat New_Java_Timezone once_yeni2 sonra_yeni tzdata2016b.tar.gz.sha512 tzupdater-2.0.3-2015b update.sh […]

Upgrade Exadata ibswitches


root@anarexadatatest02:~# /u01/app/11.2.0.3/grid/bin/crsctl stat res -t ——————————————————————————– NAME TARGET STATE SERVER STATE_DETAILS ——————————————————————————– Local Resources ——————————————————————————– ora.DATAC1.dg ONLINE ONLINE anarexadatatest01 ONLINE ONLINE anarexadatatest02 ora.DBFS_DG.dg ONLINE ONLINE anarexadatatest01 ONLINE ONLINE anarexadatatest02 ora.LISTENER.lsnr ONLINE ONLINE anarexadatatest01 ONLINE ONLINE anarexadatatest02 ora.RECOC1.dg ONLINE ONLINE anarexadatatest01 ONLINE ONLINE anarexadatatest02 ora.asm ONLINE ONLINE anarexadatatest01 Started ONLINE ONLINE anarexadatatest02 Started ora.gsd OFFLINE OFFLINE […]