Author: Laurent Schneider

There is a new INSIDE OCP column in the Oracle Magazine this month (May-June 2006 Edition). It is about the Application Server exam. In the magazine, it is referenced as 1Z1-311, but the beta phase ended half a year ago, so the exam is now production 1Z0-311. I could guess most answers, and I hope […]

I bought a new PC at Eastern. I have installed 100Gb partition for Linux and 100Gb for Windows. I tried Fedora Core 5 and OpenSuse 10.0, in 64bit mode. I currently spend most of my “free” time to prepare the OCA Application Server certification, next friday (28th). Tonight I borrowed a game from a friend […]

Oracle Release a solaris release for the intel/amd 64bits platform. This is the first release ever from oracle on solaris x86-64. Download Oracle Database 10g Release 2 (10.2.0.1.0) for Solaris Operating System (x86-64) now

isqlplus and sqlplusw (gui sqlplus windows) will be desupported in 2010. Read Note 359855.1 and Note 359859.1 on Metalink. Oracle recommends migrating to Raptor (SQLDeveloper) or to Application Express (HTMLDB) or command line sqlplus. Oracle Support apparently does not know that Raptor changed name before going to production, well, names change so often, it is […]

Last week I gave an internal 2-days dba course. All three students had good experience of filesystem backup and unix, but hardly any oracle experience. I figured out recovery is more complex than I thought! By explaining to other, how often do you realise do you do not know the answer yourself? It has been […]

I was yesterday at Oracle Days. I have met a dozen of people I know, and was pleased to see Troy, who gave me one more tip for installing EM grid on a high availability cluster. I also saw Lutz, which announced me the workshop with Jonathan Lewis in a few weeks www.digicomp.ch/jlewis I took […]

The 10g OCM practicum, expected for 2004, is now officially launched. Oracle Database 10g Certified Master Exam Well, depending on your country, you will get a ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275. In this case, just change your country to United States. Then you will see the details. If you […]

the patchset 1 of database 10gR2 is available on AIX, HPUX, Solaris, Linux and Windows yet. download patch 4547817 on metalink As a habit of changing name of everything, the catpatch sql script has been renamed to catupgrd

I will be at the exhibition booth from LC Systems on the Oracle Technology Days, Thursday 16th March, 2006.

Well, it is now renamed to SQL Developer. There is now an expected “Save password” checkbox to save the password… apart from the name, it looks quite similar to raptor 😉

There is no to_char function available for intervals. Or at least it does not work as expected SQL> select to_char(interval ‘1234’ second, ‘HH24:MM’) from dual; TO_CHAR(INTERVAL’12 ——————- +00 00:20:34.000000 I just write my own one, with some new format elements For interval day to second, I have DDD number of days, HH number of hours […]

check on metalink for availability: patch 4505133

I am waiting for eomgc 10gR2 for AIX so I check the download page often. Instead of adding new plateforms, I notice they just removed Solaris ! Oracle Enterprise Manager 10g Grid Control Release 2 (10.2.0.1) for Solaris Operating System (SPARC) google cache

I just download and installed Oracle Application 10g Release 3 on my linux box. The version released this week is very light! No ldap, no database, well, a light one… Application Server 10g Release 3 x86: 531 MB Included: * Oracle HTTP Server * Oracle Application Server Containers for J2EE (OC4J) * Oracle Enterprise Manager […]

it will be a good week ! I found an elegant way to solve a query with recursive pl/sql. an user wanted to have DHSGHDADSFDF translated in DHSGAF, that is, duplicated chars removed, order retained. here is my function : create or replace function f(v varchar2) return varchar2 is begin if (v is null) then […]

raptor product page I have not checked the differences with 3.0 yet, probably bug fixes with “do not save passwords”

This is THE release I have been waiting for, a raptor which does NOT save the password on your local PC. Save a password, even encrypted, on you local PC allows every one with physical access to your PC to get access to your productive database, which may be high-secured and with controlled physical access. […]

Using Static Expressions with Conditional Compilation defines the kind of expression you can use with conditional compilation… I got one question on forums.oracle.com today, an user wanted to use bitand and could not. I wrote my answer but, … , the site is down and eventually my answer did not get accepted. So, to translate […]

most of the time I use set autot trace exp in order to get the execution plan. It seems more easy than explain plan for [query]; followed by select * from table (dbms_xplan.display);. However, take care, set autotrace traceonly explain does modify the rows if you explain a plan for insert/update/delete. SQL> set autot trace […]

this is a 10gR2 new feature. It is no longer necessary to recreate the control file to increase those parameters. Actually, you do not have to change them, they change “automatically” Demo SQL> CREATE DATABASE MAXDATAFILES 5 MAXINSTANCES 1 MAXLOGFILES 2 MAXLOGMEMBERS 1 extent management local default tablespace users default temporary tablespace temp undo tablespace […]

Pete Finnigan just mentioned a bug, which allow any user in any oracle version to get dba privilege Imperva discovers a critical access control bypass in login bug. This is incredible! Well, Pete urged you to apply CPU2006January asap.

A good way to learn is to try to answer user questions. Instead of referencing other posts, I tried today to answer that frequently asked question myself on developpez.com (french forum) SQL> create table test ( my_long long); Table created. SQL> insert into test values (‘hello toto !’); 1 row created. SQL> exec for r […]

a few improvement described in the readme.txt. One of this is big-tnsfile support. always missing is a way to NOT SAVE the password on the client!

Last friday I installed RAC on my Suse10. Today, I installed Grid Control. Of course it is not supported. The packages I neeeded additionaly are db1 and openmotif. It did not work 100%. I finally started the iasconsole (emctl start iasconsole), and within the iasconsole, I restarted the failed elements. I created the repository manually […]

$ echo clear screen|sqlplus scott/tiger SQL> columns cleared breaks cleared computes cleared but if I quit properly, it does not report that $ echo “clear screen quit”|sqlplus scott/tiger SQL> a good reason to improve the quality of your shell script by quitting at the end 😉

Hi, [EDIT] I did read Dizwell article about Linux 10g Laptop RAC. The article is no longer available [/EDIT] I have just installed RAC 10gR2 on Suse10. The document above guided me thru the steps. Specific Suse10 : – raw devices are configured by editing /etc/raw with values like raw1:loop1 and must be activated with […]

When I quit ftp command line, I do not type quit, nor bye, because it is too long. I rather type “by”. Does it sound strange and meaningless to abbreviate “bye” in “by” ? Well, I have a few favorites SQL> set lin 999 SQL> rollb SQL> spo f SQL> shu SQL> spo off

An unlocked user is a security problem. Currently, all my unlocked users have only CREATE SESSION as system privilege, evtl ALTER SESSION. Except SYS, SYSTEM and DBSNMP To minimize this security problem, I implemented the following strategy on my test system. 1) delete password file, set remote_login_passwordfile=NONE, O7_DICTIONARY_ACCESSIBILITY=FALSE 2) alter user SYSTEM account lock; 3a) […]

on otn : forums.oracle.com 1) SQL and PL/SQL 2) Database General 3) iSQL*Plus 4) Documentation Feedback when otn is down or too slow, I read the metalink forums. Especially SQL*Plus and Oracle PL/SQL. If necessary, I post questions on the DBA Administration forum. to post questions/comments specific to security, I go to Pete Finnigan’s Oracle […]

I just noticed this morning that idle events are very easily identifiable by a new column called wait_class in 10gR2 To ignore idle event, I just wrote select WAIT_CLASS, event from ( select * from V$SYSTEM_EVENT where WAIT_CLASS#!=6 order by TIME_WAITED_MICRO desc) where rownum