Archive

Archive for the ‘Add new tag’ Category

one more OCE certification

November 19th, 2008 7 comments

I have passed my Oracle 9i Certified Master exam in 2004. Since then the 10g exam has been in preparation.

Well, according to dba10gocm_upgrade the OCM Upgrade exam content has not been finalized.

There is also an OCM Member restricted website. In case you have the password, you can read :
More Great Benefits Coming Soon . . .

Soon=Forever+a few centuries?

According to Paul answer to my comment on his blog : we are developing a one-day upgrade exam for 10g OCM to 11g OCM and will include a streamlined path for 9i OCM to 11g OCM

Ok, I am a bit pessimistic about the future of OCM. As OCM Gregory Guillou posted on my previous blog post :
It doesn’t really make any sense to have an upgrade exam for the what ? 50 9i OCM ?

Since about last year there is a way more succesful exam suite. The Oracle Certified Expert. I did myself pass the rac and sql ones.

Ok, the news :
There is a new Oracle Certified Expert exam which is called : Oracle Database 11g Performance Tuning Certified Expert

The exam is in Beta now, good luck to you!

Tags:

Speaking in Stockholm

November 7th, 2008 4 comments

It’s a great honor for me to be invited to speak in Sweden in December 10-11 !

I am optimistic in getting a few copies of my book to give away :)

Tags:

11g release 1 patchset 1

September 20th, 2008 5 comments

I just notice on Sven Blog that 11.1.0.7 is available. I have recently upgraded my connection at home so it took a bit less than half an hour to download this 1.5G patchset


$ wget -O p6890831_111070_Linux-x86-64.zip http://oracle-updates.oracle…
–10:17:40– http://oracle-updates.oracle.com/ARUConnect/p6890831_111070_Linux-x86-64..
Resolving oracle-updates.oracle.com… 87.248.199.23, 87.248.199.24
Connecting to oracle-updates.oracle.com|87.248.199.23|:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 1,613,366,248 (1.5G) [application/zip]

100%[==================================>] 1,613,366,248 891.73K/s

10:47:31 (879.89 KB/s) – `p6890831_111070_Linux-x86-64.zip’ saved [1613366248/1613366248]

$ unzip p6890831_111070_Linux-x86-64.zip
$ cd Disk1
$ ./runInstaller
Starting Oracle Universal Installer…
Preparing to launch Oracle Universal Installer from
Oracle Universal Installer, Version 11.1.0.7.0 Production
Copyright (C) 1999, 2008, Oracle. All rights reserved.

$ su -
root’s password:
# /u00/app/oracle/product/11.1/db_1/root.sh
Running Oracle 11g root.sh script…
# exit
$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 – Production on Sat Sep 20 11:10:35 2008

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup quiet migrate
ORACLE instance started.
Database mounted.
Database opened.
SQL> set time on
11:42:21 SQL> sho parameter sga_target

NAME TYPE VALUE
———————————— ———– ——————————
sga_target big integer 200M
11:42:25 SQL> alter system set sga_target=300m scope=spfile;

System altered.

11:42:28 SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
11:42:43 SQL> startup quiet migrate
ORACLE instance started.
Database mounted.
Database opened.
11:43:01 SQL> @?/rdbms/admin/catupgrd

11:54:03 SQL> Rem END catupgrd.sql
11:54:03 SQL> startup
ORACLE instance started.

Total System Global Area 313159680 bytes
Fixed Size 2159272 bytes
Variable Size 226495832 bytes
Database Buffers 79691776 bytes
Redo Buffers 4812800 bytes
Database mounted.
Database opened.
11:56:28 SQL> select comp_name,status,version from dba_registry;

COMP_NAME STATUS VERSION
———————————– ——– ———-
Oracle Ultra Search VALID 11.1.0.7.0
Oracle XML Database VALID 11.1.0.7.0
Oracle Text VALID 11.1.0.7.0
Oracle Expression Filter VALID 11.1.0.7.0
Oracle Rules Manager VALID 11.1.0.7.0
Oracle Workspace Manager VALID 11.1.0.7.0
Oracle Database Catalog Views VALID 11.1.0.7.0
Oracle Database Packages and Types VALID 11.1.0.7.0
JServer JAVA Virtual Machine VALID 11.1.0.7.0
Oracle XDK VALID 11.1.0.7.0
Oracle Database Java Packages VALID 11.1.0.7.0

My first try with 200Mb sga target did not succeeded. But with 300Mb sga target it worked fine.

Tags:

DITO

May 22nd, 2008 3 comments

I never used Oracle Web Conference OWC, for security reason. Today I created one SR and read first time about Demo It To Oracle (DITO). This is basically a link CamStudio.org, which is a tool that records AVI file and converts AVI to flash SWF file. This is nice to have because you do need to grant access to your desktop to Oracle Support and you can record what’s happening on your screen !

Let’s have a look

defaultsysdate.swf

Tags:

10.2.0.4 aix

May 15th, 2008 5 comments

I just noticed 10.2.0.4 is out. I started downloading 1,916,781 KB !

Tags:

10.2.0.4/Unix

May 1st, 2008 No comments

Unix users will enjoy this : 10.2.0.4 is available on Solaris and HPUX
patchset 6810189

Still waiting for AIX…

Tags:

Welcome Oracle Ace Marco Gralike

April 8th, 2008 1 comment

blog.gralike.com

Marco is one of the top expert with XML and Database. Congrats Marco for receiving the Ace trophee :)

Tags:

Linux 10.2.0.4 for x86_64 is out

March 17th, 2008 3 comments

While Linux x86_64 just came out, Unix Releases like HPUX, AIX and SunSolaris will probably not be available before third week of April.

Tags:

Linux 10.2.0.4 for x86_64 is out

March 17th, 2008 No comments

While Linux x86_64 just came out, Unix Releases like HPUX, AIX and SunSolaris will probably not be available before third week of April.

Tags:

Baton Rouge Oracle User Group

March 11th, 2008 2 comments

I will be speaking about SQL Model at Baton Rouge Oracle User Group, Thursday, March 20, 2008 from 11:30am to 1:30pm.

Check http://www.broug.org for details

Tags:

Software Configuration Manager

March 6th, 2008 7 comments

I just noticed today the Web 2.0 interface of metalink :

csm

The URL is http://csm.oracle.com, like Coftware Sonfiguration Manager (or maybe Configuration Software Manager).
[edit: original name is: Configuration Support Manager]

It seems nice, you can customize the portal with drag and drop, their is a blog too http://blogs.oracle.com/supportportal and a feedback button I am going to use right now!

Enjoy the new interface to read and update your SR :)

sr.png

Tags:

Oracle 10.2.0.4

February 24th, 2008 8 comments

Sven’s Technik-Blog » Blog Archive » Oracle 10.2.0.4 für Linux x86 ist verfügbar…

Patchset 6810189 is now available for Download on Metalink.

[[code]]czozMzI6XCJzZWxlY3QgKiBmcm9tIHYkdmVyc2lvbjsNCg0KQkFOTkVSDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS17WyYqJl19LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KT3JhY2xlIERhdGFiYXNlIDEwZyBFbnRlcnByaXNlIEVkaXRpb24gUmVsZXtbJiomXX1hc2UgMTAuMi4wLjQuMCAtIFByb2QNClBML1NRTCBSZWxlYXNlIDEwLjIuMC40LjAgLSBQcm9kdWN0aW9uDQpDT1JFICAgIDEwLjIue1smKiZdfTAuNC4wICAgICAgUHJvZHVjdGlvbg0KVE5TIGZvciBMaW51eDogVmVyc2lvbiAxMC4yLjAuNC4wIC0gUHJvZHVjdGlvbg0KTkxTUlR7WyYqJl19TCBWZXJzaW9uIDEwLjIuMC40LjAgLSBQcm9kdWN0aW9uDQpcIjt7WyYqJl19[[/code]]

Tags:

Tom Kyte tour in Europe

December 4th, 2007 No comments

« Ask Tom Live » European Tour 2008

 City Date Price Register
Madrid 28 – 29 January 924 ** Click here
London 25 – 26 February £1,101 * Click here
Berlin 6 – 7 May € 1,474 ** Click here
* This price is valid until 31 January 2008 only
** This price is valid until 29 February 2008 only

Note that if you register after Feb 29th for the Madrid event (which is in January), the price is no longer valid :twisted:

I am also surprised to see such a price difference for the same course between the different events.

Tags:

10.2.0.4 probably not available before 2008

November 27th, 2007 7 comments

I blogged here that 10.2.0.4 was announced for 2007Q4. Well, I have rechecked metalink and the tentative date for Linux is now 2008Q1 :?

Lutz posted about some 10.2.0.4 Beta tests, I did not even know that some customers got beta version of the metalink patchsets :twisted:

Tags:

SQL Model Unconference

November 16th, 2007 7 comments

I have enjoyed speaking at the unconference very much. I chose not to use anything else than a SQL file to demonstrate the capabilities.

Thanks to the audience for coming. Here is the SQL file I used for the demo

SQLMODEL.SQL

Tags:

SQL Model – Oracle Wiki

November 13th, 2007 1 comment

SQL Model – Oracle Wiki

My unconference is Thursday at 2pm

Tags:

next patchset for Oracle 10gR2

October 29th, 2007 3 comments

10.2.0.4 should be available this year on Linux x86. Check Metalink Certification for different plateforms.

Certify – Additional Info Oracle Database – Enterprise Edition Version 10gR2 On Linux (x86)



Operating System: Linux (x86) Version SLES-10
Oracle Database – Enterprise Edition Version 10gR2
N/A Version N/A
Status: Certified
Product Version Note:
None available for this product.
Certification Note:
Existing patch sets:
     10.2.0.2
     10.2.0.3 
     10.2.0.4 Q4CY2007

Tags:

Oracle 11g for Windows is out

October 23rd, 2007 2 comments

I just read on Renaps Blog that Oracle 11g for Windows is out.

Oracle Database Download

Tags:

Oracle OpenWorld Unconference

October 19th, 2007 2 comments

Oracle OpenWorld will host the
Oracle OpenWorld Unconference

On the wiki.oracle.com Wiki, you can create your own unconference session.

I have proposed a session about SQL Model :
SQL Model

Tags:

11g on Linux x86_64

October 12th, 2007 11 comments

Niall Litchfield just wrote about 11g availability on 64bits linux.

Happy Birthday Niall
Download Oracle Database

Tags:

Database Internals Newsletter October 2007

October 12th, 2007 5 comments

Oracle Support started a series about database internals.

Oracle Corporation
Oracle Headquarters Campus
DATABASE INTERNALS
NEWSLETTER
Volume 1: October,
2007

Note 460494.1

Tags:

installing OID 10.1.4.2 Preview 1

September 6th, 2007 3 comments

Download oracle-oid-10.1.4.2.0-1.0.i386.rpm
Download oracle-xe-univ-10.2.0.1-1.0.i386.rpm

Install the rpm
# rpm -i oracle-*.i386.rpm

In SLES 10, there is no /bin/cut, let’s create a link as root to avoid a mistake when running config-oid.sh
# ln -s /usr/bin/cut /bin/cut

Run the configure script as root
# /etc/init.d/oracle-oid configure
That’s all folks! It created an Oracle XE 10gR2 database, and configured a running database. Excellent!

LDAP Server is running and configured.

$ ldapsearch  cn=orcladmin dn
cn=orcladmin, cn=Users, dc=com

There is a nice video to run on linux : oracleauthenticationservices_demo.vvl
Save the file, set the display, then

$ chmod +x oracleauthenticationservices_demo.vvl
$ ./oracleauthenticationservices_demo.vvl

It shows also how to use Oracle LDAP Server OID to identify your Linux users with the preview of Oracle Authentication Service

Tags:

Oracle ACE Director

August 15th, 2007 1 comment

Congratulation to Eddie Awad for becoming an Oracle ACE Director !

Tags:

Oracle OpenWorld 2007

August 13th, 2007 3 comments

I will go to Oracle OpenWorld in San Francisco this year again

Join Me at Oracle OpenWorld Connect!

Tags:

download 11g today

August 10th, 2007 1 comment
Tags:

9iR2 Desupport

August 8th, 2007 2 comments

REMINDER: Premier Support for Oracle Database 9.2 ends in July 2007 The 9iR2 premier support just ended.

Now the 9i is under Extended Support. The good news, it is free until July 2008!
First year Extended Support fee waived for Oracle9i Database Release 9.2

Tags:

oracle 11g hits the streets

July 13th, 2007 Comments off

I read on this site that Oracle11g GA is for 2007 August

http://www.dba-oracle.com/t_oracle_11g_hits_the_streets.htm

Tags:

Oracle Certified SQL Expert

July 10th, 2007 28 comments

Oracle Certification Program: Exam Details

I immediately registered for this exam and will do it next week, I just cannot wait for this one…

Tags:

11g launch in 15 days

June 26th, 2007 No comments
Tags:

11g new feature course

June 21st, 2007 No comments

Lutz announced his 11g courses in Switzerland in this postOracle University Switzerland announces brand new Oracle 11g courses

Tags:

10.1.0.5 is the terminal patchset

June 5th, 2007 1 comment

I just read on the General Notes For Oracle Database – Enterprise Edition in Metalink that 10.1.0.5 is the terminal patchset for 10gR1

Tags: