Next wednesday, Dec 7th, starts the Tom Kyte workshop in Zurich. In the evening we will have a dinner in Zurich. Drop me a comment if you intend to come !
Month: November 2005
ansi literals
the first time I saw ansi literals was in June 2004 in a post on otn forum by alex goodmann. I just cannot stop using them, it is so handy! Whenever I specify a date (or a timestamp or even a time), with Ansi Date, I do not rely on the NLS parameters, nor I […]
Welcome to Switzerland
I will attend Tom Kyte 3-days session in Zurich in 2 weeks. I am immensely impatient to follow his workshop ! I hope palindnilap will be there too 😉 I invited him to come to my home to go to Tom Workshop, and to have a game of xiangqi on the brand new wooden board […]
post from palindnilap
I just answered a question about the data dictionary on forums.oracle.com. It is all about the dictionary views. How many tables should I know in the dictionary ? SQL> select count(*) from dict; 1857 Well, that’s too much. But I can remove the GV$ view, which contain the instance for RAC, and the DBA_ ALL_ […]
tom kyte in Zurich
Tom Kyte is coming to Zurich next month! http://www.digicomp.ch/tomkyte
oracle voyage worm
I wrote a mini script to protect my customer from being attacked by an “oracle voyage worm” variant : revoke CREATE DATABASE LINK from CONNECT; revoke ALL on SYS.UTL_FILE from PUBLIC; revoke ALL on SYS.UTL_HTTP from PUBLIC; revoke ALL on SYS.UTL_SMTP from PUBLIC; revoke ALL on SYS.UTL_TCP from PUBLIC; grant EXECUTE on SYS.UTL_FILE to XDB; […]
10.1.0.4 management agent for Unix
I just found in my RSS feed that a new agent has been released. 10.1.0.4 for AIX5L. Well, if you go to the OEM download page, you will see only 10.1.0.2 version for AIX, HPUX, Solaris Sparc. But by clicking on the link, for example Grid Control (10.1.0.2) for AIX5L Based Systems, you will find […]
10.2.0.1 hidden parameters
In order to get a clean database configuration, I add the following two hidden parameters in my 10.2.0.1 parameter file. Do not hurl that loud, I hear you from here! Well, as I said already about the _pga_max_size, I never recommend using hidden parameters when you can do the same without. However, I am going […]
no more tnsnames
with netca, it is easy to configure your sqlnet.ora to use LDAP instead of tnsnames.ora. The ldap.ora and sqlnet.ora are updated… than it works, sqlplus user@db is correctly looking in the ldap oracle content
ldap day 2
what can I do with LDAP? what is the difference between LDAP and Oracle Internet Directory? Well, there is quite a lot of interresting documents, pictures and faq on otn : OTN Directory homepage Directory Admin guide Identity Management ReferenceLDAP is a directory server, the info are stored in an Oracle 10.1.0.4.2 database. When you […]
ldap server
My ldap server is up and running on my notebook with SLES9. Next, next, next, install. That is it. Oracle Application Server creates a 10.1.0.4.2 database and start the Oracle Internet Directory – understand LDAP server – automatically. It can then be configured with the web interface.
Details regarding the 10g DBA OCM requirements will be available in December
Well, when 10g certification came out, it said : “will be available in late 2004”. In March 2005, I contacted Oracle University in Germany. They said : keep watching oracle.com/education. Later, it said : “will be available in mid 2005”. In Open World, I met the certification principal, who meant it will start in December […]
Chinese Chess
In case you like this game and live in Zurich, I will be playing the swiss championship tomorrow.
hierarchy
what is a hierarchy? I enjoy reading the wikipedia definition : http://en.wikipedia.org/wiki/Hierarchy In the doc the hierarchy is as a parent-child connection, CONNECT BY PRIOR defines the relationship. However, it is possible to have under certain circumstances to connect to a child, regardsless of the parent. This is no longer a practical relation. Sterile variant […]
Connect by to generate rows
I just want to clarify something today : I do not like the connect by level
10gR2 Grid Control is out!
Oracle Enterprise Manager Downloads: oem download this is a great announcement!