Oracle Certified Master
just released today http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
only in Enterprise Edition at the moment, and now available on HPUX, zLinux and AIX
#oracle12c #db12102 is out for a bunch of platform #aix #os390 #hpux #zlinux
— laurentsch (@laurentsch) November 17, 2014
This is the first and last patchset for 12cR1
#oracle 12.1.0.2 is the last patch set for Release 12.1.
— laurentsch (@laurentsch) October 9, 2014
In the past, most of my customers skipped R1 releases. That is, 8.1.7 -> 9.2 -> 10.2 -> 11.2. SAP does the same. For the very first time SAP plans to go to 12.1.0.2 + some PSU in spring 2015. But only to avoid running out of support and without any fancy feature like Multitenant or in Memory.
#oracle 12.1.0.2 is the last patch set for Release 12.1.
— laurentsch (@laurentsch) October 9, 2014
12.1.0.2, which is not available on AIX yet, will be the last patchset of 12cR1. It is the first and only patchset for that release. It is actually more than a patchset, as it introduced in memory database and JSON in the database.
The next release is expected beginning of 2016 on Linux. 11.2.0.4 patching ends January 2018.
Should I I go to an already aborted release or should I buy extended support for 11.2.0.4 until 2018 ?
Probably I will go both ways, depending on the applications.
#db12cR2 release announced for 2016, Doc ID 742060.1
— laurentsch (@laurentsch) September 5, 2014
I just started using the New My Oracle Support User Interface
It is a zero-flash interface with more capabilities than the “html” interface we used the previous years. It still provides about the same browser experience as the flash one.
Have a try… according to Oracle : “it will eventually replace the Flash version”
To my French speaking readers : eventually does not mean “éventuellement” but rather “à l’occasion”.
Google Translate is quite ok this time : “elle finira par remplacer la version Flash”
I was trying to find a workaround for a bug in 11.2.0.2
SELECT * FROM
(SELECT 2 B FROM DUAL WHERE DUMMY = 'Y'),
(SELECT 3 C FROM DUAL WHERE DUMMY LIKE '%')
WHERE C = B(+);
B C
---------- ----------
2 3
---------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 4 | 4 (0)| 00:00:01 |
| 1 | NESTED LOOPS OUTER| | 1 | 4 | 4 (0)| 00:00:01 |
|* 2 | TABLE ACCESS FULL| DUAL | 1 | 2 | 2 (0)| 00:00:01 |
|* 3 | TABLE ACCESS FULL| DUAL | 1 | 2 | 2 (0)| 00:00:01 |
---------------------------------------------------------------------------
As dummy is not Y, B could not be 2.
Ok, I tried :
alter session set "_optimizer_random_plan"=1;
SELECT * FROM
(SELECT 2 B FROM DUAL WHERE DUMMY = 'Y'),
(SELECT 3 C FROM DUAL WHERE DUMMY LIKE '%')
WHERE C = B(+);
B C
---------- ----------
3
Execution Plan
----------------------------------------------------------
Plan hash value: 837538736
-------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost |
-------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1146 | 5730 | 27G|
| 1 | MERGE JOIN OUTER | | 603K| 2946K| 27G|
|* 2 | TABLE ACCESS FULL | DUAL | 392K| 767K| 136K|
| 3 | VIEW | | 2 | 6 | 69180 |
|* 4 | FILTER | | | | |
|* 5 | TABLE ACCESS FULL| DUAL | 123K| 240K| 69180 |
-------------------------------------------------------------
Cool, I got correct results! the fact that the cost jumped from 4 to 27 Billions is just a minor annoyance I suppose 😈
I also tried
alter session set "_optimizer_random_plan"=0; -- default
alter session set "_complex_view_merging"=false;
SELECT * FROM
(SELECT 2 B FROM DUAL WHERE DUMMY = 'Y'),
(SELECT 3 C FROM DUAL WHERE DUMMY LIKE '%')
WHERE C = B(+);
B C
---------- ----------
3
-----------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-----------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 5 | 2 (0)| 00:00:01 |
| 1 | NESTED LOOPS OUTER | | 1 | 5 | 2 (0)| 00:00:01 |
|* 2 | TABLE ACCESS FULL | DUAL | 1 | 2 | 2 (0)| 00:00:01 |
| 3 | VIEW | | 1 | 3 | | |
|* 4 | FILTER | | | | | |
|* 5 | TABLE ACCESS FULL| DUAL | 1 | 2 | 2 (0)| 00:00:01 |
-----------------------------------------------------------------------------
The first thing I did is opening a SR, now I am impatiently waiting for Oracle Support guidance…
Just installed Oracle 11gR2 patchset 2 on Solaris Sparc 64bit, it works like a charm, waiting for the AIX patchset impatiently
https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=10404530
You got an internal error and want to create a zip of all relevant files.
First, let’s generate an internal error. I found a quick way to generate an ora-600 or an ora-700 (which is a harmless ora-600 in 11g, read 737878.1) on oradeblog
SQL> oradebug unit_test dbke_test dde_flow_kge_soft foo bar baz
Statement processed.Now start the command line interface, and set the ORACLE HOME
$ adrcli
adrci> show home
ADR Homes:
diag/tnslsnr/precision/listener
diag/tnslsnr/localhost/listener
diag/rdbms/lsc02/LSC02
diag/rdbms/lsc03/LSC03
diag/rdbms/lsc01/LSC01
adrci> set homepath diag/rdbms/lsc02/LSC02
adrci> show home
ADR Homes:
diag/rdbms/lsc02/LSC02
Check the incidents :
adrci> show incident
ADR Home = /u01/app/oracle/diag/rdbms/lsc02/LSC02:
*************************************************************************
INCIDENT_ID PROBLEM_KEY CREATE_TIME
-------------------- ----------------- ---------------------------------
53065 ORA 700 [foo] 2011-03-14 18:20:24 +01:00
1 rows fetched
Create the package metadata :
adrci> IPS CREATE PACKAGE INCIDENT 53065
Created package 1 based on incident id 53065, correlation level typical
adrci> ips SHOW PACKAGE 1
DETAILS FOR PACKAGE 1:
PACKAGE_ID 1
PACKAGE_NAME ORA700foo_20110314182607
PACKAGE_DESCRIPTION
DRIVING_PROBLEM 1
DRIVING_PROBLEM_KEY ORA 700 [foo]
DRIVING_INCIDENT 53065
DRIVING_INCIDENT_TIME 2011-03-14 18:20:24.304000 +01:00
STATUS New (0)
CORRELATION_LEVEL Typical (2)
PROBLEMS 1 main problems, 0 correlated problems
INCIDENTS 1 main incidents, 0 correlated incidents
INCLUDED_FILES 4
SEQUENCES Last 0, last full 0, last base 0
UNPACKED FALSE
CREATE_TIME 2011-03-14 18:26:07.566961 +01:00
UPDATE_TIME 2011-03-14 18:26:07.620324 +01:00
BEGIN_TIME N/A
END_TIME N/A
FLAGS 0
The metadata files (in $ORACLE_BASE/rdbms/db_name/sid/*.ams) are in an Oracle binary format
Create the package zip file :
adrci> IPS GENERATE PACKAGE 1 in /home/lsc/foo
Generated package 1 in file /home/lsc/foo/ORA700foo_20110314182607_COM_1.zip,
mode complete
This zip file contains all traces and alerts that you may ever need to diagnose/resolve the analysis
adrci> ips show files package 1
FILE_ID 1
FILE_LOCATION <ADR_HOME>/incident/incdir_53065
FILE_NAME LSC02_ora_14163_i53065.trm
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2
FILE_LOCATION <ADR_HOME>/incident/incdir_53065
FILE_NAME LSC02_ora_14163_i53065.trc
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 3
FILE_LOCATION <ADR_HOME>/trace
FILE_NAME LSC02_ora_14163.trc
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 4
FILE_LOCATION <ADR_HOME>/trace
FILE_NAME LSC02_ora_14163.trm
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 5
FILE_LOCATION <ADR_HOME>/alert
FILE_NAME log.xml
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 6
FILE_LOCATION <ADR_HOME>/trace
FILE_NAME alert_LSC02.log
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 7
FILE_LOCATION <ADR_HOME>/trace
FILE_NAME LSC02_diag_5247.trc
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 8
FILE_LOCATION <ADR_HOME>/trace
FILE_NAME LSC02_diag_5247.trm
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 12
FILE_LOCATION <ADR_HOME>/trace
FILE_NAME LSC02_mmon_5265.trc
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 13
FILE_LOCATION <ADR_HOME>/trace
FILE_NAME LSC02_mmon_5265.trm
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2007
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME IPS_CONFIGURATION.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2008
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME IPS_PACKAGE.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2009
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME IPS_PACKAGE_INCIDENT.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2010
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME IPS_PACKAGE_FILE.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2011
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME IPS_PACKAGE_HISTORY.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2012
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME IPS_FILE_METADATA.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2013
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME IPS_FILE_COPY_LOG.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2014
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_ACTION_DEF.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2015
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_ACTION_PARAMETER_DEF.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2016
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_ACTION.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2017
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_ACTION_PARAMETER.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2018
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_INCIDENT_TYPE.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2019
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME DDE_USER_INCIDENT_ACTION_MAP.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2020
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME INCIDENT.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2021
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME INCCKEY.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2022
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME INCIDENT_FILE.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2023
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME PROBLEM.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2024
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME HM_RUN.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2025
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/export
FILE_NAME EM_USER_ACTIVITY.dmp
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2026
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1
FILE_NAME config.xml
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2027
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1/crs
FILE_NAME crsdiag.log
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2028
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1
FILE_NAME metadata.xml
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2029
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1
FILE_NAME manifest_1_1.xml
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2030
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1
FILE_NAME manifest_1_1.html
LAST_SEQUENCE 1
EXCLUDE Included
FILE_ID 2031
FILE_LOCATION <ADR_HOME>/incpkg/pkg_1/seq_1
FILE_NAME manifest_1_1.txt
LAST_SEQUENCE 1
EXCLUDE Included
Even an html file
| Package ID | 1 |
|---|---|
| Creation time | 2011-03-14 18:26:07.566961 +01:00 |
| Archive time | 2011-03-14 18:37:14.499389 +01:00 |
| Sequence | 1 |
| Package mode | Complete |
| Package status | Generating |
| Package flags | Flags: (No flags set) |
| Main problems | 1 |
|---|---|
| Correlated problems | 0 |
| Main incidents | 1 |
| Correlated incidents | 0 |
| Product | rdbms |
|---|---|
| Target | lsc02 |
| Instance | LSC02 |
| ADR base | /u01/app/oracle |
| ADR home | /u01/app/oracle/diag/rdbms/lsc02/LSC02 |
| Problem ID | Problem key | Incidents included | Incidents total |
|---|---|---|---|
| 1 | ORA 700 [foo] | 1 | 1 |
| Problem ID | Problem key | Incidents included | Incidents total |
|---|
| Incident ID | Problem ID | Error Message | Incident time |
|---|---|---|---|
| 53065 | 1 | ORA-700 [foo] [bar] [baz] | 2011-03-14 18:20:24.304000 +01:00 |
| Incident ID | Problem ID | Error Message | Incident time |
|---|
| File name | Location | Size | File time |
|---|---|---|---|
| LSC02_ora_14163_i53065.trm | <ADR_HOME>/incident/incdir_53065 | 54828 | 2011-03-14 18:20:26.000000 +01:00 |
| LSC02_ora_14163_i53065.trc | <ADR_HOME>/incident/incdir_53065 | 2433968 | 2011-03-14 18:20:26.000000 +01:00 |
| LSC02_ora_14163.trc | <ADR_HOME>/trace | 1308 | 2011-03-14 18:20:26.000000 +01:00 |
| LSC02_ora_14163.trm | <ADR_HOME>/trace | 210 | 2011-03-14 18:20:24.000000 +01:00 |
| log.xml | <ADR_HOME>/alert | 885849 | 2011-03-14 18:20:27.000000 +01:00 |
| alert_LSC02.log | <ADR_HOME>/trace | 164969 | 2011-03-14 18:20:27.000000 +01:00 |
| LSC02_diag_5247.trc | <ADR_HOME>/trace | 1287 | 2011-03-14 18:20:26.000000 +01:00 |
| LSC02_diag_5247.trm | <ADR_HOME>/trace | 77 | 2011-03-14 18:20:26.000000 +01:00 |
| LSC02_mmon_5265.trc | <ADR_HOME>/trace | 8703 | 2011-03-14 18:33:43.000000 +01:00 |
| LSC02_mmon_5265.trm | <ADR_HOME>/trace | 838 | 2011-03-14 18:33:43.000000 +01:00 |
| IPS_CONFIGURATION.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 2818 | 2011-03-14 18:37:13.000000 +01:00 |
| IPS_PACKAGE.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 476 | 2011-03-14 18:37:13.000000 +01:00 |
| IPS_PACKAGE_INCIDENT.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 193 | 2011-03-14 18:37:13.000000 +01:00 |
| IPS_PACKAGE_FILE.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 1126 | 2011-03-14 18:37:14.000000 +01:00 |
| IPS_PACKAGE_HISTORY.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 280 | 2011-03-14 18:37:13.000000 +01:00 |
| IPS_FILE_METADATA.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 2888 | 2011-03-14 18:37:14.000000 +01:00 |
| IPS_FILE_COPY_LOG.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 214 | 2011-03-14 18:37:14.000000 +01:00 |
| DDE_USER_ACTION_DEF.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 908 | 2011-03-14 18:37:13.000000 +01:00 |
| DDE_USER_ACTION_PARAMETER_DEF.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 708 | 2011-03-14 18:37:13.000000 +01:00 |
| DDE_USER_ACTION.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 204 | 2011-03-14 18:37:13.000000 +01:00 |
| DDE_USER_ACTION_PARAMETER.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 198 | 2011-03-14 18:37:13.000000 +01:00 |
| DDE_USER_INCIDENT_TYPE.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 353 | 2011-03-14 18:37:13.000000 +01:00 |
| DDE_USER_INCIDENT_ACTION_MAP.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 166 | 2011-03-14 18:37:13.000000 +01:00 |
| INCIDENT.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 700 | 2011-03-14 18:37:13.000000 +01:00 |
| INCCKEY.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 303 | 2011-03-14 18:37:13.000000 +01:00 |
| INCIDENT_FILE.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 268 | 2011-03-14 18:37:13.000000 +01:00 |
| PROBLEM.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 395 | 2011-03-14 18:37:13.000000 +01:00 |
| HM_RUN.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 342 | 2011-03-14 18:37:14.000000 +01:00 |
| EM_USER_ACTIVITY.dmp | <ADR_HOME>/incpkg/pkg_1/seq_1/export | 207 | 2011-03-14 18:37:14.000000 +01:00 |
| config.xml | <ADR_HOME>/incpkg/pkg_1/seq_1 | 56180 | 2011-03-14 18:37:14.000000 +01:00 |
| crsdiag.log | <ADR_HOME>/incpkg/pkg_1/seq_1/crs | 184 | 2011-03-14 18:37:14.000000 +01:00 |
| metadata.xml | <ADR_HOME>/incpkg/pkg_1/seq_1 | 556 | 2011-03-14 18:37:14.000000 +01:00 |
But did Oracle Support ever asked you for an ADR package? Or do they still ask for RDA
I used to select, zip and send traces files manually, I may consider ADR packages by my next ORA-600 !
patch 10098816 is available for download
I have read on Surachart Opun’s blog that 11.2.0.2 is available, but also that the patchset is now a full installation.
In the past, if you wanted to have 9.2.0.8 or 10.2.0.5, you needed to install both the base version, 9.2.0.1 or 10.2.0.1 and the patchset, 9.2.0.8 or 10.2.0.5. Very often the patchset itself was bigger and took more time than the base database installation.
According to Note 1189783.1, it is now possible to install 11.2.0.2 without having to install both 11.2.0.1 + a patchset.
if you are installing Oracle Database on a system without an existing Oracle Database installation, then you can simply install the release 11.2.0.2 patch set
I like this 🙂
I just came back from diving, parasailing, safari and more fun in Egypt. On my blog I saw a comment from Nicolas regarding the availability of the terminal patchset for 10gR2
Note 161818.1: Oracle Database Releases Status Summary
10.2.0.5: Patchset 8202632
It is quite a while I have not posted anything of interest, I pretty apologize to my faithful readers… the reason for being offline are multiple, one of them, I cannot access my blog from my workplace yet.
Ok, the last hint from my dba regarding Oracle Support :
If flash really drives you nuts, go for html : supporthtml.oracle.com
It is quite a long time I did shot the pianist in my blog… probably patience and perseverance are better than aggressive behavior, but today I have been transfixed by an answer from metalink.
Sometimes the issues I submit are a bit exotic but there it was a join with one view using one function and dual returning wrong results. Reproducible at will on any db 10.2.0.4 and below.
After 2 weeks the helpful engineer told me it is fixed with patch 6471020 and in 11g. I asked if he tried it but he said no. As the patch is not available on my platform I asked if could try it but then he came back with an amazing workaround he became from an ARE (advanced resolution engineer) :
Remove the function from the view.
Unreal
HPUX Itanium, Sun Sparc/x86_64, AIX –> october-december 2009
Windows, HPUX Risc –> april-june 2010
Ref: Release Schedule of Current Database Patch Sets
Dates will change, keep an eye on the schedule, and do not base your business on expected dates ! Please be patient 🙂
I just read a post from Barry Mc Gillin about apex on MacOsX.
After having being using Vista for one year, I would really welcome a Mac as my next notebook. But what about Oracle Database on Mac OS X?
According to otn, the latest release as of today is a deprecated 10gR1 for the deprecated platform PowerPC.
However, according to metalink, a 10gR2 is planned for the first quarter of 2009 (sic)
Db 10gR2 on MacOS X Intel
And 11g is planned too Db 11gR1 on MacOS X Intel, Schedule to be announced.
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.
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
I just noticed 10.2.0.4 is out. I started downloading 1,916,781 KB !
I just noticed today the Web 2.0 interface of metalink :
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 🙂
as of today, 24-AUG-2007, here is the certification matrix for Linux x86
| OS | Product | Status |
| SLES-10 | 11g | Certified |
| Red Hat Enterprise AS/ES 5 | 11g | Certified |
| Red Hat Enterprise AS/ES 4 | 11g | Certified |
| Oracle Enterprise Linux 5 | 11g | Certified |
| Oracle Enterprise Linux 4 | 11g | Certified |