Categories
11g Add new tag Blogroll certification

one more OCE certification

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!

Categories
Add new tag Blogroll event sql xml

Speaking in Stockholm

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 🙂

Categories
11g Add new tag dba installation support

11g release 1 patchset 1

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.

Categories
Add new tag Blogroll dba support

DITO

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

Categories
Add new tag Blogroll installation support

10.2.0.4 aix

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

Categories
Add new tag Blogroll dba

10.2.0.4/Unix

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

Still waiting for AIX…

Categories
Add new tag Blogroll

Welcome Oracle Ace Marco Gralike

blog.gralike.com

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

Categories
Add new tag Blogroll dba installation

Linux 10.2.0.4 for x86_64 is out

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

Categories
Add new tag Blogroll installation

Linux 10.2.0.4 for x86_64 is out

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

Categories
Add new tag Blogroll event

Baton Rouge Oracle User Group

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

Categories
Add new tag Blogroll support

Software Configuration Manager

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

Categories
Add new tag Blogroll dba installation

Oracle 10.2.0.4

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.

select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
Categories
Add new tag Blogroll

Tom Kyte tour in Europe

« 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 😈

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

Categories
Add new tag Blogroll

10.2.0.4 probably not available before 2008

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 😈

Categories
Add new tag Blogroll openworld07 sql

SQL Model Unconference

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

Categories
Add new tag Blogroll event openworld07 sql

SQL Model – Oracle Wiki

SQL Model – Oracle Wiki

My unconference is Thursday at 2pm

Categories
Add new tag Blogroll

next patchset for Oracle 10gR2

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

Categories
11g Add new tag Blogroll

Oracle 11g for Windows is out

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

Oracle Database Download

Categories
Add new tag Blogroll event openworld07 sql

Oracle OpenWorld Unconference

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

Categories
11g Add new tag Blogroll

11g on Linux x86_64

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

Happy Birthday Niall
Download Oracle Database

Categories
Add new tag Blogroll

Database Internals Newsletter October 2007

Oracle Support started a series about database internals.

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

Note 460494.1

Categories
Add new tag Blogroll installation ldap oid

installing OID 10.1.4.2 Preview 1

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

Categories
Add new tag Blogroll

Oracle ACE Director

Congratulation to Eddie Awad for becoming an Oracle ACE Director !

Categories
Add new tag Blogroll openworld07

Oracle OpenWorld 2007

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

Categories
11g Add new tag Blogroll

download 11g today

http://www.oracle.com/technology/software/products/database/index.html

Categories
Add new tag Blogroll license

9iR2 Desupport

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

Categories
11g Add new tag Blogroll

oracle 11g hits the streets

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

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

Categories
Add new tag Blogroll certification sql sqlplus

Oracle Certified SQL Expert

Oracle Certification Program: Exam Details

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

Categories
11g Add new tag Blogroll

11g launch in 15 days

watch the launch event live
http://www.oracle.com/pls/ebn/live_viewer.main?p_shows_id=5717957

Categories
11g Add new tag Blogroll

11g new feature course

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

Categories
Add new tag Blogroll installation

10.1.0.5 is the terminal patchset

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