DOAG2015 OracleText presentation available for Download!

This year at DOAG conference in Nuremberg i was talking about Oracle Text, beginning with the architecture and till some examples using Oracle Text.

It was a pleasure for me to be a speaker at DOAG2015 again!

The conference was once more great! Really looking forward to DOAG2016.

Save the date for #DOAG2016: 15. – 18.11.2016, Nuremberg

Presentation Download here:
Oracle Text: AllesTextOderWas?

~Benedikt.

,

Leave a comment

Disable Oracle RECYCLEBIN in 11g database

Hi guys,

in this article i would like to explain, how to disable RECYCLEBIN in oracle database 11g.

oracle@localhost [DB: ORADBN] [/home/oracle]
$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 27 13:27:22 2015

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 option
SQL>
SQL> show parameter recyclebin;

NAME                                 TYPE        VALUE
———————————— ———– ——————————
recyclebin                           string      ON
SQL>

To disable RECYCLEBIN execute following command:

SQL> alter system set recyclebin=off deferred;
System altered.
SQL>

Now let’s check the Change:

SQL> show parameter recyclebin;
NAME                                 TYPE        VALUE
———————————— ———– ——————————
recyclebin                           string      ON
SQL>

Well, recyclebin seems still be active. But be careful – deferred means it only will effect subsequent sessions. So for check the Change, you have to Logout and Login again.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning option
oracle@localhost [DB: ORADBN] [/home/oracle]
$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 27 13:33:36 2015
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 option
SQL> show parameter recyclebin;
NAME                                 TYPE        VALUE
———————————— ———– ——————————
recyclebin                           string      OFF
SQL>

Finally recyclebin is disabled.

Stay tuned,
Benedikt

, ,

Leave a comment

Oracle Statspack und SQL zur Performanceanalyse – Kostenlos aber effektiv

Sie möchten mehr zu Performanceanalyse mit Oracle Statspack und SQL erfahren?

Durch Informatik aktuell hatte ich die Gelegenheit, zu diesem interessanten Thema einen Aritkel zu verfassen:

http://www.informatik-aktuell.de/betrieb/datenbanken/oracle-statspack-und-sql-zur-performanceanalyse-kostenlos-aber-effektiv.html

, ,

Leave a comment

Oracle 11gR2 on Solaris 11: ORA-00371: not enough shared pool memory during instance startup with default shared_pool_size

Dear folks,

today i ran into an oracle bug. On Oracle Solaris 11 the Database (11.2.0.4.3) will not start with default shared_pool_size in init.ora parameter-file.

SQL> startup nomount pfile=’/home/oracle/pfile/pinit.ora’;
ORA-00371: not enough shared pool memory, should be atleast ‘XXXXXX’ bytes

The paramter file pinit.ora contains no SHARED_POOL_SIZE parameter. To solve the problem please use the workaround of setting the SHARED_POOL_SIZE parameter to a sufficient value. This bug will be fixed in 12.1.

Oracle Documentation Note:
https://support.oracle.com/epmos/faces/DocumentDisplay?id=1560386.1

The issue was investigated in the unpuplished Bug 13606499 – PHSB: DEFAULT MEMORY PARAMETER (INIT.ORA) IS NOT BIG ENOUGH TO START A INSTANCE

Stay tuned,
Benedikt

, , , , ,

Leave a comment

my #DOAG2014 presentation is available for download

Today i was speaking for the first time at DOAG conference in Nuremberg. Amazing, how many people joined my session about “Kostenlos aber effektiv: Performanceanalyse mit Statspack und SQL*”. Thanks a lot to everyone!

You can find my presentation under the following link:
http://www.performing-databases.com/index.php?id=38&L=1 …

Regards,
Benedikt

Leave a comment

Oracle Database Upgrade to 11gR2 fails with – ORA-01722

Last days i tried to migrate a database to the latest 11.2.0.4.3 release on Solaris OS.

During the upgrade following error occured:

SQL > SELECT TO_NUMBER(‘DATA_VAULT_OPTION_ON’) FROM v$option
     2      WHERE
     3      value=’TRUE’ and parameter = ‘Oracle Database Vault’;

SELECT TO_NUMBER(‘DATA_VAULT_OPTION_ON’) from v$option;

ERROR at line 1:
ORA-01722: invalid number

After investigating some time in analysis, i found MOS note 1409844.1 that describes how to fix the Problem:
Catupgrd Returns: Ora-01722 Select To_number(‘DATA_VAULT_OPTION_ON’) from v$option
Link: https://support.oracle.com/epmos/faces/DocContentDisplay?id=1409844.1

As described in the Note, follow the steps and disable the Data Vault Option for the new environment before starting upgrade the database:

$ chopt disable dv

Afterwards start the upgrade again, you will confirm, that ORA-01722 has been fixed. Optionally you can after successful migration re-enable the Database Vault Option again:

$ chopt enable dv

Hopefully this Blog Post will help in solving your problems.

Benedikt Nahlovsky

, , ,

1 Comment

Kostenlos aber effektiv: Performanceanalyse mit Statspack und SQL* at #DOAG2014

I am so happy – DOAG e.V. accepted my talk for DOAG conference 2014 in Nuremberg. It is the first time for me to visit DOAG conference as speaker, looking forward to tell the guys something about best practices for Performance Analysis with Statspack and SQL*.

The talk will be in german, here is the abstract:

Der Vortrag “Kostenlos aber effektiv: Performanceanalyse mit Statspack und SQL*” stellt Möglichkeiten dar, mit Hilfe von Statspack und SQL Plus / SQL Developer die Datenbankleistung zu analysieren. Best Practices zu Installation, Konfiguration und Nutzung von Statspack aus bewährter Praxis werden gezeigt. Anhand von fünf W-Fragen berichtet der Vortrag über die Taktik zur Lösungsfindung und Problembehebung.

Hope to see you in Nuremberg, 18th – 20th November 2014 at CCN East.

Regards,
Benedikt

 

, , , , , ,

Leave a comment