2011-12-24

The opatch minimum version check for patch ... while applying PSU for grid infrastructure

In case you need to apply PSU for GI ( grid infrastructure )  and you have the error below :
The opatch minimum version check for patch /app/grid/OPatch/PSU4_GI/12827731 failed for /app/grid
The opatch minimum version check for patch /app/grid/OPatch/PSU4_GI/12827726 failed for /app/grid
Opatch version check failed for oracle home /app/grid
Opatch version check failed

2011-12-23

solution for rmcup

LESS="-X"
export LESS





Many terminals, such as xterm, support a feature known as rmcup. It
restores the screen to what it looked like before a program was run. The situation
also occurs with any full-screen terminal program, such as man or less; the
program’s text disappears after you quit the program, and the prompt
“window” is restored http://blogs.oracle.com/samf/entry/smcup_rmcup_hate 

graphical remote connection to linux ( from windows )

http://martincarstenbach.wordpress.com/2011/11/08/installing-freenx-on-opensuse-11-4/#more-1086

2011-12-15

gipchaInternalResolve: failed to resolve ret gipcretKeyNotFound

CRSD Fails to Start due to GIPC Communication Failure with Master [ID 1337730.1]

2011-12-14

how to see undo space usage

the original link :  http://oracledisect.blogspot.com/2011/11/who-is-using-your-undo-space-improved.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+oracledbdisected+%28Oracle+Database+Disected%29

Then the script for Oracle 11g is as follows:
set pagesize 400
set linesize 140
col name for a25
col program for a50
col username for a12
col osuser for a12
SELECT a.inst_id, a.sid, c.username, c.osuser, c.program, b.name,
a.value, d.used_urec, d.used_ublk
FROM gv$sesstat a, v$statname b, gv$session c, gv$transaction d
WHERE a.statistic# = b.statistic#
AND a.inst_id = c.inst_id
AND a.sid = c.sid
AND c.inst_id = d.inst_id
AND c.saddr = d.ses_addr
AND a.statistic# = 284
AND a.value > 0
ORDER BY a.value DESC

If you want to run this script on versions 10g1 and 10g2, just replace the statistic# with 176.

28

http://www.sfatulmedicului.ro/Cardiopatia-ischemica-si-Infarctul-miocardic/infarctul-miocardic-si-angina-instabila_161

2011-12-09

SSD for oracle databases

http://www.pythian.com/news/28797/de-confusing-ssd-for-oracle-databases/

* Placing redo logs on SSD is not recommended. Exadata now has a “Smart Flash Logging” feature that uses redo logs on SSD. Note that it uses redo logs *also* on SSD. This feature allows Oracle to write redo in parallel to a file on SSD and a file on the magnetic disk, and finish the operation when one of the calls is successful. This is a no-lose situation that can only improve performance. This is not the case if you place your redo logs on both SSD and magnetic disks yourself, in which case the redo write will finish when the slowest device finishes writing, making it a no-win situation.

2011-12-07

Direct NFS: please check that oradism is setuid

check also : http://dbamohsin.wordpress.com/2010/11/26/direct-nfs/

from note Direct NFS: FAQ [ID 954425.1]

What is oradism? When is it used by Direct NFS?

Direct NFS client uses oradism executable to perform functions that require root privileges. oradism is configured by default on a single instance and for RAC if not using shared $ORACLE_HOME.

It is used for the following special purposes:
Direct NFS client needs root privileges to start communication with the NFS filer. It uses oradism to obtain the root file handle for the exported volume and the NFS server port and NFS mount port. Once the root handle and port information is obtained, all future communication is issued by Oracle user processes using normal privileges.

Oradism executable need always to be owned by root otherwise instance will not come up and returns the error:
Direct NFS: please check that oradism is setuid

You could also try :  chown oracle:oinstall oradism    and chmod 4755 oradism

Also, you could try :  chown root:oinstall oradism      and chmod 4755 oradism

script to check baddata (number or varchar2 ) in the oracle database

Baddata Script To Check Database For Corrupt column data [ID 428526.1]

Check also this note/post : http://oradbastuff.blogspot.com/2011/11/typ2-len1-192.html

This script can be useful in case of the following errors :

Note:94185.1   - ALERT: JDBC Drivers May Insert Invalid Year 2000 Dates
Note:91207.1   - Warning for Client Code which directly manipulates Oracle DATE datatype values
Note:979657.8  - OCI allows invalid numbers to be inserted into the database
Note:4338390.8 - JDBC clients can insert corrupt data


The script can be downloaded here:
  Notepart:428526.1:BADDATA

2011-12-06

ORA-00245: control file backup operation failed

RAC BACKUP FAILS WITH ORA-00245: CONTROL FILE BACKUP OPERATION FAILED [ID 1268725.1]

ORA-38856

RMAN Duplicate from RAC backup fails ORA-38856 [ID 334899.1]

2011-11-27

expdp slow after upgrade from 11.1.0.6 to 11.1.0.7

DataPump Export (EXPDP) Runs Very Slow After Upgrade From 11.1.0.6 to 11.1.0.7 (Doc ID 1075468.1)

2011-11-25

ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not mapped to object]

This error can occur , when you migrated from 32bit to 64 bit :
The solution can be found in
DB CONVERSION: 32 bit -->64 Bit Broke OLAP OPTION [ID 386990.1]

2011-11-23

how to send attachment from linux coomand line

A very good article : http://www.cyberciti.biz/tips/sending-mail-with-attachment.html

You must have mutt installed
Use mutt command as follows to send an email with attachment:
$ mutt -s "Test mail" -a /tmp/file.tar.gz vivek@nixcraft.co.in < /tmp/mailmessage.txt
Where,
  • vivek@nixcraft.co.in - is the recipient
  • /tmp/mailmessage.txt - is the main body of the e-mail (read message from the file "mailmessage.txt")
  • /tmp/file.tar.gz - is an attachment (with option -a)
  • "Test mail" - is a subject line (option -s)

Another way is to use uuencode and mail ... but uuencode takes more time .

2011-11-22

ORA-00600: internal error code, arguments: [ddfnetCFull-4], [Invalid Handle], [], [], [], [], [], [], [], [], [], []

There are bugs related to ORA-600 ddfnetCFull  in 11.2.0.2 release

Bug 12977043: ORA-600 [DDFNETCFULL-4] WHEN USING A SHARED PUBLIC DBLINK

WORKAROUND:
-----------
Use PUBLIC database link instead of SHARED PUBLIC database link

INS-35351

P: [INS-35351] Inconsistant Versions Detected.

S: Verify active version of clusterware (output of "$GRID_HOME/bin/crsctl query crs activeversion") is equal or higher than the database software that's being installed.
bug 12311806

2011-11-21

Typ=2 Len=1: 192

the following note/bug is related to http://oradbastuff.blogspot.com/2011/11/ora-07445-intelnewmemcpy382-sigill.html 


Batch Insert Of Data Sometimes Leaves "~" (Tilde) In A Number Field Using The -d64 Parameter In The Command Line [ID 1134992.1]

2011-11-18

how to copy statistics between partitions

When dealing with partitioned tables the Optimizer relies on both the statistics for the entire table (global statistics) as well as the statistics for the individual partitions (partition statistics) to select a good execution plan for a SQL statement. If the query needs to access only a single partition, the Optimizer uses only the statistics of the accessed partition. If the query access more than one partition, it uses a combination of global and partition statistics.
It is very common with range partitioned tables to have a new partition added to an existing table, and rows inserted into just that partition. If end-users start to query the newly inserted data before statistics have been gathered, it is possible to get a suboptimal execution plan due to stale statistics. One of the most common cases occurs when the value supplied in a where clause predicate is outside the domain of values represented by the [minimum, maximum] column statistics. This is known as an „out-of-range‟ error. In this case, the Optimizer prorates the selectivity based on the distance between the predicate value, and the maximum value (assuming the value is higher than the max), that is, the farther the value is from the maximum or minimum value, the lower the selectivity will be.
The "Out of Range" condition can be prevented by using the DBMS_STATS.COPY_TABLE_STATS procedure (available from Oracle Database 10.2.0.4 onwards). This procedure copies the statistics of a representative source [sub] partition to the newly created and empty destination [sub] partition. It also copies the statistics of the dependent objects: columns, local (partitioned) indexes, etc. The minimum and maximum values of the partitioning column are adjusted as follows;


It can also scale the statistics (such as the number of blocks, or number of rows) based on the given scale_factor. The following command copies the statistics from SALES_Q3_2011 range partition to the SALES_Q4_2011 partition of the SALES table and scales the basic statistics by a factor of 2.
BEGIN
DBMS_STATS.COPY_TABLE_STATS('SH','SALES','SALES_Q3_2002','SALES_Q4_2002', 2);
END;
/

how to compare statistics

One of the key reasons an execution plan can differ from one system to another is because the Optimizer statistics on each system are different, for example when data on a test system is not 100% in sync with real production system. To identify differences in statistics, the DBMS_STATS.DIFF_TABLE_STATS_* functions can be used to compare statistics for a table from two different sources.

In the example below, we compare the current dictionary statistics for the EMP table with the statistics for EMP in the statistics table TAB1; the SQL statement will generate a report .

SELECT report, maxdiffpct
FROM table(DBMS_STATS.DIFF_TABLE_STATS_IN_STATTAB(‘SCOTT’,’EMP’,’TAB1’ ));

2011-11-17

ORA-07445 [__INTEL_NEW_MEMCPY()+382] [SIGILL]

an ugly oracle bug which apeears in 11.2.0.2 (with or without PSU ).
see also http://marist89.blogspot.com/2011/09/interesting-error.html

The original cause may be  here : http://oradbastuff.blogspot.com/2011/06/bug-of-jdbc-102-with-jdk-15.html 

intel_new_memcpy ( __INTEL_NEW_MEMCPY ) problems are related to bad data

ORA-04030: (Kxs-Heap-W,Qesagetnewbuf:Buffer) With Invalid Numeric Data [ID 1321682.1]

2011-11-16

oracle statistics

http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/1354477.pdf

Oracle Database 11g introduced a new sampling algorithm that is hash based and provides deterministic statistics. This new approach has the accuracy close to a 100% sample but with the cost of, at most, a 10% sample. The new algorithm is used when ESTIMATE_PERCENT is set to AUTO_SAMPLE_SIZE (the default)

It is highly recommended that from Oracle Database 11g onward you let ESTIMATE_PRECENT default.

The METHOD_OPT parameter controls the creation of histograms during statistics collection. Histograms are a special type of column statistic created when the data in a table column has a non-uniform distribution.

A unique column will not have a histogram created on it if it is only seen in equality predicates.


how to clear caches in linux

http://www.linuxinsight.com/proc_sys_vm_drop_caches.html
To free pagecache, dentries and inodes:
  • echo 3 > /proc/sys/vm/drop_caches
As this is a non-destructive operation, and dirty objects are not freeable, the user should run "sync" first in order to make sure all cached objects are freed.

2011-11-14

_ksmg_granule_size

'startup migrate' failed with ORA-64 while upgrading to 10.2.0.2 with DBUA [ID 386855.1]

2011-11-12

oracle kernel parameters in suse

How to permanently set kernel parameters on Linux [ID 242529.1]

qmkmgetConfig

ORA-07445 [qmkmgetConfig()+52] During Catupgrd.sql (11.2.0.1) [ID 1127179.1]

2011-11-11

ora.cvu

http://oraclehandson.wordpress.com/2010/11/01/whats-new-in-oracle-11-2-0-2/

New resource ora.cvu (Cluster Verification Utility) is added in 11.2.0.2
This resource invokes cluster verification utility (I guess it is executed after every 6 hours) and store it’s output in $GRID_HOME/log/nodename/cvu/cvulog/cvu20101101111536.log
Detail trace of this utility is also saved under  $GRID_HOME/log/nodename/cvu/cvutrc
-rw-r–r–   1 oragrid  oinstall 5720101 Nov  1 11:16 cvutrace.log.0
-rw-r–r–   1 oragrid  oinstall 26213985 Nov  1 05:15 cvutrace.log.3

segfault error 6 in exectask after upgrade to 11G

see also : http://juliandyke.wordpress.com/2010/10/25/investigating-cvu-failures/
exectask -getfileinfo Dumps Core When Executing cluvfy [ID 1359659.1]

CLSR-0002

Srvctl Start Service' Fails With PRKP-1030, CRS-0215 And ORA-1003, CLSR-0002 In Database Imon Logs [ID 818997.1]

installation / relink of oracle binaries is slow on NETAPP NFS mount

Relink of binaries on NetApp NFS filesystems is slow [ID 602858.1]

X_$KGLLK and X_$KSLEI after upgrade to 11G

Invalid X_$ Views & Synonyms After Upgrading to 11g [ID 878623.1]

2011-11-10

rollback segment needs recovery

In case there are some problems ( incomple or unfininshed recovery, media error ) , youo probably have a rollback segment that is in the state  needs recovery .

In this case, the best way is to follow this link : http://www.runningoracle.com/product_info.php?products_id=283  .

Put the following event
event="10015 trace name context forever, level 10"
 Find the rollback segment that is corrupted ( eg _SYSSMU6$ )  and put it offline in the init parameter file.
_offline_rollback_segments=_SYSSMU6$
 
You can also see if there is an active transaction in your database (see note 1291009.1)
 
SELECT KTUXEUSN, KTUXESLT, KTUXESQN, /* Transaction ID */
              KTUXESTA Status,
              KTUXECFL Flags
               FROM x$ktuxe
     WHERE ktuxesta!='INACTIVE' ;

do not put redo logs on SSD disks

Oracle’s redo log is a frequent source of intensive IO and, by design, Oracle sessions will normally wait for
redo log IO to complete. However, the nature of redo log IO operations is essentially optimal for magnetic
disk but least suitable for solid state disk. Redo log IO consists almost entirely of sequential write operations,
which are the worst case for solid state disk and the best case for magnetic spinning disk. Placing
redo logs on solid state disk is generally not recommended

When IO bottlenecks are limited to specific segments (tables, partitions, or indexes) then relocating those
segments to solid state disk will almost always be effective in optimizing IO to those segments, regardless of
the type of IO to which the segments are subjected

from guy harrison  blog : http://guyharrison.squarespace.com/blog/2011/10/27/using-flash-disk-for-redo-on-exadata.html

you don't need RAC

a very good white paper http://www.my-idconcept.de/downloads/You_Probably_Dont_Need_RAC.pdf

One way of looking at availability is this: If you have a standalone Unix box it will
usually give you 99.9% availability over a year (some say 99.5, some say 99.9). It just runs. And so does Oracle usually. If you have a two-node Unix cluster the availability over a year drops to 98%.

If you need to cover your behind politically in your organisation, you can choose to buy clusters, Oracle, RAC and what have you, and then you can safely say: “We’ve bought the most expensive equipment known to man. It cannot possibly be our fault if something goes wrong or the system goes down”.
Otherwise, you probably don’t need RAC. Alternatives will usually be cheaper , easier to manage and quite sufficient.

directio and NFS

Potential Lost Writes: RAC on NAS using NFS may not use DIRECTIO or HP on NFS [ID 566545.1]

Symptoms
  • When RAC is used, O_DIRECT is the default option to open files in NFS.  However, there are some cases where O_DIRECT is not used and the database may lose a write.  For this case the NFS mount point options are in accordance with Note 359515.1
  • There is another case that is specific to HP when NFS is used without the forcedirectio IO option where the database may end up losing IO.
  •  Lost IO may cause different errors like:
ORA-600 [4193]
ORA-600 [4194]
ORA-600 [4137]
ORA-600 [3020] in a media recovery
ORA-600 [kccchb_3]
ORA-600 [kdsgrp1]
ORA-600 [qertbFetchByRowID]
ORA-600 [kcbz_check_objd_typ_3]
ORA-1499 on "analyze table validate structure cascade"
ORA-8102 on delete/update
  • Some of these errors are signs of logical corruptions on undo segments, redo log files and inconsistencies between tables and indexes.

Cause

  • There are some cases where O_DIRECT is not used in RAC environment due to unpublished bug 5856342.  Without this fix in a RAC environment using NFS the database may lose a write unless DIRECTIO is explicitly specified.
@ See Bug 7006179

  • There is another case that is HP specific where Oracle does not check for forcedirectio in the mount options due to Bug 6922729.  See Note 6922729.8

Solution

  • For Bug 5856342 in order to prevent this issue install an Oracle RDBMS version greater than 10.2.0.3 or specify DIRECTIO in the database parameter file like:
filesystemio_options=DIRECTIO or SETALL
  • For Bug 6922729 (HP specific) install an one off patch for it or specify forcedirectio in the mount options for Oracle Files.  See Note 6922729.8



2011-11-08

List of Patches Available for Oracle Warehouse Builder 11.2

List of Patches Available for OWB 11.2 [ID 1271208.1]

How To Connect With The Oracle Warehouse Builder 11.2.0.2 Client to an OWB 11.2.0.3 Repository

How To Connect With The OWB 11.2.0.2 Client to an OWB 11.2.0.3 Repository [ID 1361915.1]

how to increase stability for your Intel server

In case of HP Proliant G7 series server not used as virtualized server, there are some recommendations ,  in order to improve stability on your Intel x64 server :

Bios settings:
 intel virtualization technology   --> disabled
 intel hyperthreading options     ---> disabled
 intel turbo boost technology    ---> disabled
 intel vt-d                                 ----> disabled
 processor core disabled         --->  all cores enabled


2011-11-03

ktspNextL1

Update: you could disable the automated scheduled job AUTO_SPACE_ADVISOR_JOB
BEGIN
DBMS_SCHEDULER.DISABLE(
name=>'"SYS"."AUTO_SPACE_ADVISOR_PROG"',
force=>TRUE);
END;
/


ORA-600 [ktspNextL1:4] ORA-600 [ktspNextL1:4] from SYS.DBMS_SPACE/SYS.DBMS_ADVISOR/WRI$_ADV_OBJSPACE_TREND_DATA [ID 841158.1]

2011-11-02

error linking INS_EMDB.MK IN SLES 11

SLES 11: ERROR INVOKING TARGET 'COLLECTOR' OF MAKEFILE '$O_H/SYSMAN/LIB/INS_EMDB.MK' [ID 957982.1]

2011-11-01

Oracle NoSQL

http://dbmsmusings.blogspot.com/2011/10/overview-of-oracle-nosql-database.html

Like most NoSQL systems, the Oracle NoSQL database does not support joins. It only supports simple read, write, update, and delete operations on key-value pairs.

2011-10-31

Oracle GoldenGate how to

Unlike Active Data Guard, GoldenGate captures primary database changes by reading redo records from disk, transforming those records into a platform independent trail file format, and transmitting the trail file to the target database. GoldenGate maintains a logical replica by converting the trail file into SQL and applying SQL to the target database. The target database is open read-write while synchronization occurs.  While this provides substantial flexibility as a replication solution when compared to Data Guard, care must be taken to insure that the target database is not modified independent of the source, unless it is explicitly desired to do so. 

http://gavinsoorma.com/2010/02/goldengate-concepts-and-architecture/

NFS and Oracle GoldenGate

Oracle GoldenGate Best Practice: NFS Mount options for use with GoldenGate [ID 1232303.1]

2011-10-26

Job AUTO_SPACE_ADVISOR_JOB takes too long

The Job AUTO_SPACE_ADVISOR_JOB Takes Long Time And Result In Status STOPPED [ID 1069782.1]

11G password in DBA_USERS

User Passwords Are No Longer Visible In DBA_USERS As Of 11g [ID 735651.1]

2011-10-06

timp

'Ai puţin timp la dispoziţie, aşa ca nu îl irosi trăind vieţile altora'
Steve Jobs

ORA-19587 ORA-27091 ORA-27067




Can RMAN restore from Backupset Copied From Tape? [ID 1111603.1]


2011-09-30

how to see status of rollback for smon

select sysdate,b.name useg, b.inst# instid, b.status$ status, a.ktuxeusn
xid_usn, a.ktuxeslt xid_slot, a.ktuxesqn xid_seq, a.ktuxesiz undoblocks
from x$ktuxe a, undo$ b
where a.ktuxesta = 'ACTIVE' and a.ktuxecfl like '%DEAD%'
and a.ktuxeusn = b.us#;

2011-09-28

ORA-29770: global enqueue process LCK0

ORA-29770 LMHB Terminates Instance as LMON Waited for Control File IO or LIBRARY CACHE or ROW CACHE Event for too Long [ID 1197674.1]

how to free filesystem cache in Linux

echo 1 > /proc/sys/vm/drop_caches ( as of 2.6 kernel )
http://mtj.wordpress.com/2006/10/18/clearing-linux-filesystem-read-cache/

2011-09-26

you don't need RAC

http://www.my-idconcept.de/downloads/You_Probably_Dont_Need_RAC.pdf
RAC is very cool technology. But it’s expensive.
So let’s play around with Larry’s vision of cheap Intel-based Linux clusters. Let’s buy those two cheap, 4-cpu Intel boxes and put them together in a cluster with Oracle9i and RAC on top:
Price for the hardware: About US$15.000,- or so .
Price for the OS (Linux): About US$0.50,- or thereabout (it depends!)
Price for Oracle w/ RAC: US$480.000,-

So that’s half a million to Oracle. Put another way: It’s 1 dollar to the box movers for every 32 dollars Oracle gets.
Psychologically it’s hard for the customers to understand that they have to buy something that expensive to run on such cheap hardware. The gap is too big, and Oracle will need to address it soon.

There’s nothing like RAC on the market, but that doesn’t mean you have to buy RAC. I usually joke that it’s like buying a car for US$10.000,- that has all the facilities you need from a good and stable car. Airbags and ABS brakes are US$500.000,- extra, by the way. Well, airbags and ABS are wonderful to have and
they increase your security. But it’s a lot of money compared to the basic car price.

2011-09-23

slow datapump export in 10.2.0.4

Export Slow After Applying 10.2.0.4 Patchset On Top Of 10.2.0.3 [ID 783835.1]

Symptoms

Export is slow after applying patchset 10.2.0.4.0 on top of 10.2.0.3.

An export (exp) that previously took approximately 8 hours now takes 2 days after applying the patchset 10.2.0.4.0.

Cause

The cause of slow performance is incorrect statistics.

You have to narrow down where the possible bottlenecks are by tracing the exp process:

-- Determine SPID of export process
select distinct (p.spid), s.sid, s.serial#
from   v$process p, v$session s, v$mystat m
where  s.PADDR = p.ADDR and lower (s.program) like '%exp%';

-- connect to the process as sysdba
connect / as sysdba
oradebug setospid xxxx <-- use SPID here
oradebug unlimit

-- Create process state dumps
oradebug dump errorstack 3
... wait 30 seconds
oradebug dump errorstack 3
... wait 30 seconds
oradebug dump errorstack 3

This generates a trace file in your user_dump_dest (from sqlplus: show parameter user_dump_dest).

When reviewing the file you saw the following:

Current SQL statement for this session:
SELECT CNO, CNAME, TYPE, CONDITION, CONDLENGTH, ENABLED, DEFER, INAME, IDXSYSGEND FROM SYS.EXU8CON WHERE OBJID = :1 AND TYPE IN (1, 2, 3, 7, 11, 12, 14, 15, 16, 17) ORDER BY CNO
Also, from the RDA, the AWR report seems to indicate that there is a lot of CPU time spent on
querying constraints.  Specifically, the following query:

SELECT CNO, CNAME, TYPE, CONDITION, CONDLENGTH, ENABLED, DEFER, INAME, IDXSYSGEND FROM SYS.EXU8CON WHERE OBJID = :1 AND TYPE IN (1, 2, 3, 7, 11, 12, 14, 15, 16, 17) ORDER BY CNO
You can use the trace file generated from the "oradebug dump errorstack 3" to get the bind variable for the above query.  Search the trace file for "Current cursor": Current cursor: 57, pgadep: 0 ...and then search on "Cursor#57"

Bind#0
oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00
oacflg=00 fl2=1000000 frm=00 csi=00 siz=24 off=0
kxsbbbfp=800003ffefcf2ec0 bln=22 avl=04 flg=05
value=535520 <---- This is your Bind Variable's value.

Now you can determine how long it is taking to complete that query:

SQL> set pages 1000 lines 132
SQL> set autotrace on
SQL> SELECT CNO, CNAME, TYPE, CONDITION, CONDLENGTH, ENABLED, DEFER, INAME, IDXSYSGEND FROM SYS.EXU8CON WHERE OBJID = 535520 AND TYPE IN (1, 2, 3, 7, 11, 12, 14, 15, 16, 17) ORDER BY CNO ;

That should tell you how long it takes to to complete that query.

Solution

Workarounds:

1.  Export with constraints=n

Or:

2. Gather dictionary stats again and run the query again.

SQL> exec dbms_stats.gather_dictionary_stats;

SQL> set pages 1000 lines 132
SQL> set autotrace on
SQL> SELECT CNO, CNAME, TYPE, CONDITION, CONDLENGTH, ENABLED, DEFER, INAME, IDXSYSGEND
     FROM SYS.EXU8CON
     WHERE OBJID = 535520 AND TYPE IN (1, 2, 3, 7, 11, 12, 14, 15, 16, 17)
     ORDER BY CNO ;

Compare times for query to run before and after statistics are gathered.

11.2.0.3 is here

11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER is available for linux x86 and linux x86-64

See patch 10404530 on metalink

2011-09-20

fast_start_parallel_rollback

DATABASE HANG DUE TO PARALLEL TRANSACTION RECOVERY [ID 464246.1]

2011-09-16

filesystemio_options and disk_asynch_io

What do filesystemio_options and disk_asynch_io Do?

disk_asynch_io is a kind of master switch, which turns on or off Async I/O to database files on any type of storage, whether it's raw device or filesystem. The filesystemio_options parameter gives finer control over I/O to database files on filesystems. It allows you to turn off async I/O to filesystem files but keep async I/O to raw devices if the "master" switch disk_asynch_io is set to true.

Instance initialization parameter filesystemio_options has four options:
1. "asynch" : means buffered I/O + Async I/O
2. "directIO" : means Direct I/O only
3. "setall" : means Direct I/O + Async I/O
4. "none" : disables Async I/O and Direct I/O

One should always use at least Direct I/O with OCFS/OCFS2. In fact one does not have choice as the database automatically adds that mode whenever it sees the file is on an OCFS volume or OCFS2 volume mounted with the datavolume mount option.
If the user wants aio with OCFS/OCFS2, use setall.
If the user wants aio with ASM/ASMlib, he is expected to set disk_asynch_io=true, this is because ASM bypasses the filesystem layer in this case and ASM I/O is entirely controlled by DISK_ASYNCH_IO parameter. AIO needs to be enabled/disabled by setting disk_asynch_io to parameter values TRUE/FALSE, please see Note 413389.1 .

kksfbc child completion

Session or job spins on 'kksfbc child completion' wait [ID 1354066.1]

2011-09-13

ORA-24247

ORA-24247 Trying To Send Email Using UTL_SMTP from 11gR1 (11.1.0.6) or higher [ID 557070.1]

less rights when running oracle procedures

stored procedures run with the base privs of the OWNER of the procedure 

2011-09-12

ASM and FILESYSTEMIO_OPTIONS + DISK_ASYNCH_IO

ASM Inherently Performs Asynchronous I/O Regardless of filesystemio_options Parameter [ID 751463.1]

direct I/O for Oracle Databases

Pros and Cons of Using Direct I/O for Databases [ID 1005087.1]


meet db2

http://www.ibm.com/developerworks/data/library/techarticle/dm-0907oracleappsondb2/ 
http://www.ibm.com/developerworks/data/library/techarticle/dm-0401gupta/

specific

"Unii dintre noi sunt zidari, alţii sunt avocaţi şi încă alţii sunt ingineri sau prestidigitatori. Fiecare însă are felul său de a lucra, propria scară de performanţă şi propriile repere şi etaloane, specifice domeniului.
Atunci când eşti cu adevărat bun în ceva îţi dai seama cât de puţin şti de fapt şi cât mai ai de învăţat (pe de o parte); lucrezi cu pasiune şi cu dăruire la a ajunge mai bun şi la a învăţa de la alţii (pe de altă parte).
Atunci când eşti bun, pui pasiune în ceea ce faci, faci cu dragoste ceea ce faci şi asta se simte în fiinţa ta şi, cu timpul, constaţi că ajungi să pui pasiune şi dragoste în tot ceea ce faci."

by Radu Mihailescu

2011-09-07

oracle and emc recoverpoint

white paper : http://levipereira.files.wordpress.com/2011/06/recoverpoint_oracle_db_protect_wp.pdf

ro

s-a facut un studiu si romanii sunt printre cei mai nefericiti, aprox 80% s-au declarat nefericiti..suntem la acelasi nivel cu tari unde foametea omoara multi sau au un regim dictatorial.
Romanii nu au suficiente scuze pentru atata nefericire...
Noi ne consideram nefericiti ca nu avem apartamente/case si masini frumoasa ca aia pe care ii vedem la televizor. Oricat am avem nu ne mai ajunge si vrem tot mai mult, de parca de acolo ar veni fericirea...

problem with impdp and jobs

IMPDP doesn't remap Database Jobs to new User Schema [ID 1122424.1]

2011-09-06

Cannot find a rule to create target install from dependencies

"Relink All" On AIX5L Reports "Make: 1254-002 Cannot Find A Rule To Create Target Install From Dependencies" [ID 602079.1]

runcluvfy hangs at timezone

./runcluvfy.sh stage -pre crsinst -n node1,node2 -fixup -verbose

hangs while checking for time zone syncronization:

Check: Time zone consistency
<<hang>>


From our past experience, we have noted that 11.2 install/upgrade hangs at "Check: Time zone consistency" if user installing Grid Infrastructure has entered an interactive shell in the profile script.
Please check the profile script for the O/S user oracle or grid for anything interactive and disable it.

If you are unsure about anything interactive then please upload the login shell profile for O/S user oracle or grid and we will check it.
Problem was solved by commenting the 'IF' statement and the 'bash' command in file '.profile'. Thanks! You may close the SR.

2011-09-04

ORA-30926

How to Troubleshoot ORA-30926 Errors? [ID 471956.1]

2011-08-31

grid control agent stops when uploading

when the filesystems are more than 95% occupied,  the grid control agent stops :

http://blog.contractoracle.com/2009/05/emd-upload-error-upload-was-successful.html

#Solution
To implement the solution, please execute the following steps:

1. Update the AGENT OH/sysman/config/emd.properties with the parameter:
uploadMaxDiscUsedPct=99
uploadMaxDiskUsedPctFloor=99

2. Stop the agent: emctl stop agent
3. Start the agent: emctl start agent
4. Upload to the OMS: emctl upload

2011-08-30

how to import in oracle 10G a dump taken from a 11G database

The main problem : you want to use datapump ( expdp/impdp ) in order to move data between databases ( from 11G to 10G ).

In the default mode, this is not possible ( an 11G dump will not be recognized to a 10G database )

Solution: expdp directory=... schemas=.... version=10.2 ( this command should be performed on 11G database)

rq and libnnz10.so

OFSRQ Failed with Fatal libnnz10.so after Upgrading to RDBMS 11G R1 [ID 865087.1]

2011-08-07

how to transfer/copy putty settings from a computer to another

A very good article : http://downloadsquad.switched.com/2007/02/01/howto-transfer-your-putty-settings-between-computers/


Pay attention to the fact you must export only the branch :  [HKEY_CURRENT_USER\Software\SimonTatham . You can encounter the error : error accessing the registry if you exported a branch that does not exist in you new computer machine

how to have a centralized tnsnames.ora

a very good article : http://blog.ronnyegner-consulting.de/2009/09/30/storing-oracle-database-connection-strings-in-openldap-instead-of-oid/

Check also : http://oracle-cookies.blogspot.com/2007/01/get-tnsnamesora-from-openldap.html

chopt

Enabling and Disabling Oracle Database Options ( 11.2 ) :

ORA-27146, ORA-27301, ORA-27302

Unable to Start Database ORA-27146, ORA-27301, ORA-27302 [ID 189979.1]

problems with database versions < 11.2 in GRID Infrastructure 11.2

Pre 11.2 Database Issues in 11gR2 Grid Infrastructure Environment [ID 948456.1]

how to upgrade to grid infrastructure 11.2

Things to Consider Before Upgrading to 11.2.0.2 Grid Infrastructure [ID 1312225.1]

2011-08-05

REP-770 / REP-736 / REP-1247

Reports With Attached PLX Causes Reports Server Hangs/Crashes Intermittently or REP-770 / REP-736 / REP-1247 [ID 1232385.1]

WMSYS.OWM_MIG_PKG

Post-Upgrade Status Script utlu112s.sql Fails with ORA-942 [ID 1051991.1]

SQL Monitoring

Real-Time SQL Monitoring in 11g [ID 1229904.1]

ORA-04043: object XDB_DATASTORE_PROC does not exist

Catupgrd.sql Gives ORA-4043 Error On XDB_DATASTORE_PROC [ID 360907.1]

Automatic Statistics Collection in 10G

How to Disable Automatic Statistics Collection in 10G ? [ID 311836.1]

automatic collection of statistics in 11G

How to Disable Automatic Statistics Collection in 11g [ID 1056968.1]

2011-08-02

Exception 50125

Exception 50125 CORBA.OBJECT_NOT_EXIST when Reportservername.dat File is Corrupted [ID 560595.1]

2011-08-01

ora de educatie

1991.  Profesoara povesteste jenata, copiii asculta cu respiratia taiata.
2011.  Copiii se intrec sa povesteasca, profesoara asculta cu respiratia taiata.

2011-07-27

how to reduce noise in your car

www.installdr.com/TechDocs/999503.pdf

how to see error messages in english

In order to see Oracle error messages in English, you must have in your registry, under HKEY_LOCAL_MACHINE... Software...Oracle  , for key NLS_LANG, the following value :  AMERICAN_AMERICA.WE8ISO8859P1

how to change hostname or domain for oracle application server

http://download.oracle.com/docs/cd/B14099_19/core.1012/b13995/host.htm#CIHJIBAG
Follow these steps for each middle-tier instance on your host. Be sure to complete the steps entirely for one middle-tier instance before you move on to the next.
  1. Log in to the host as the user that installed the middle-tier instance.
  2. Make sure your ORACLE_HOME environment variable is set to the middle-tier Oracle home. Do not use a trailing slash (UNIX) or backslash (Windows) when specifying the variable.
  3. On UNIX systems, set the LD_LIBRARY_PATH, LD_LIBRARY_PATH_64, LIB_PATH, or SHLIB_PATH environment variables to the proper values. The actual environment variables and values that you must set depend on the type of your UNIX operating system.
  4. Run the following commands in the middle-tier Oracle home:
    • On UNIX systems:
      cd ORACLE_HOME/chgip/scripts
      ./chgiphost.sh -mid
      
      
    • On Windows systems:
      cd ORACLE_HOME\chgip\scripts
      cmd /c chgiphost.bat -mid 
       
      Verify the logs 

2011-07-21

how to see how much cpu your oracle instance consumes

An excellent article: http://dboptimizer.com/2011/07/21/oracle-cpu-time/

Starting in 10g Oracle records both the CPU used by the instance as well as the load on the system in v$sysmetric. This is awesome as we can see how busy the system is and how much of the CPU Oracle is responsible for:
col metric_name for a25
col metric_unit for a25
select metric_name, value, metric_unit from v$sysmetric where metric_name like'%CPU%' where group_id=2;
 
 
with AASSTAT as (
           select
                 decode(n.wait_class,'User I/O','User I/O',
                                     'Commit','Commit',
                                     'Wait')                               CLASS,
                 sum(round(m.time_waited/m.INTSIZE_CSEC,3))                AAS
           from  v$waitclassmetric  m,
                 v$system_wait_class n
           where m.wait_class_id=n.wait_class_id
             and n.wait_class != 'Idle'
           group by  decode(n.wait_class,'User I/O','User I/O', 'Commit','Commit', 'Wait')
          union
             select 'CPU_ORA_CONSUMED'                                     CLASS,
                    round(value/100,3)                                     AAS
             from v$sysmetric
             where metric_name='CPU Usage Per Sec'
               and group_id=2
          union
            select 'CPU_OS'                                                CLASS ,
                    round((prcnt.busy*parameter.cpu_count)/100,3)          AAS
            from
              ( select value busy from v$sysmetric where metric_name='Host CPU Utilization (%)' and group_id=2 ) prcnt,
              ( select value cpu_count from v$parameter where name='cpu_count' )  parameter
          union
             select
               'CPU_ORA_DEMAND'                                            CLASS,
               nvl(round( sum(decode(session_state,'ON CPU',1,0))/60,2),0) AAS
             from v$active_session_history ash
             where SAMPLE_TIME > sysdate - (60/(24*60*60))
)
select
       ( decode(sign(CPU_OS-CPU_ORA_CONSUMED), -1, 0, (CPU_OS - CPU_ORA_CONSUMED )) +
       CPU_ORA_CONSUMED +
        decode(sign(CPU_ORA_DEMAND-CPU_ORA_CONSUMED), -1, 0, (CPU_ORA_DEMAND - CPU_ORA_CONSUMED ))) CPU_TOTAL,
       decode(sign(CPU_OS-CPU_ORA_CONSUMED), -1, 0, (CPU_OS - CPU_ORA_CONSUMED )) CPU_OS,
       CPU_ORA_CONSUMED CPU_ORA,
       decode(sign(CPU_ORA_DEMAND-CPU_ORA_CONSUMED), -1, 0, (CPU_ORA_DEMAND - CPU_ORA_CONSUMED )) CPU_ORA_WAIT,
       COMMIT,
       READIO,
       WAIT
from (
select
       sum(decode(CLASS,'CPU_ORA_CONSUMED',AAS,0)) CPU_ORA_CONSUMED,
       sum(decode(CLASS,'CPU_ORA_DEMAND'  ,AAS,0)) CPU_ORA_DEMAND,
       sum(decode(CLASS,'CPU_OS'          ,AAS,0)) CPU_OS,
       sum(decode(CLASS,'Commit'          ,AAS,0)) COMMIT,
       sum(decode(CLASS,'User I/O'        ,AAS,0)) READIO,
       sum(decode(CLASS,'Wait'            ,AAS,0)) WAIT
from AASSTAT)
/
 

norocul se termina

http://tudorgalos.ro/2011/07/a-i-se-da-in-gura/

bind peeking in Oracle Siebel

Siebel Bind peeking performance degradation future enhancement [ID 1273535.1]

_optim_peek_user_binds

A very good article about bind peeking in Oracle Database 10G : http://www.pythian.com/news/867/stabilize-oracle-10gs-bind-peeking-behaviour-by-cutting-histograms/

exec dbms_scheduler.disable('SYS.GATHER_STATS_JOB');

here are three things that might put you at risk of unstable plans due to bind variable peeking. Those are histograms, partitions, and range-based predicates.

histograms and bind variable peeking can cause an unstable plan.

In 10G, bind variable peeking happens only on a hard parse, which means that all following executions will use the same plan, regardless of the bind variable value.

It might be a good idea to wipe out all histograms in a database (gather your stats with FOR ALL COLUMNS SIZE 1 clause), and manually add them when you decide that you really need one.

 

2011-07-20

11.2.0.2.3

PSU 11.2.0.2.3 contains all fixes previously released in PSU 11.2.0.2.2 and the following new fixes:

2011-07-19

faster index creation

A good article : http://iggyfernandez.wordpress.com/2011/07/04/take-that-exadata-fast-index-creation-using-noparallel/

Leverage the Oracle cache! This is one case where “direct path reads” and parallelism hurt instead of helping. The trick is to use NOPARALLEL so that data is loaded into shared memory using “db file scattered reads”—instead of being loaded into private memory using direct path reads—and to run multiple CREATE INDEX statements simultaneously. In the words of David Aldridge, you’ll get “get 1 index creation process performing the physical reads and the other 9 (for example) processes greedily waiting for the blocks to load into the buffer.”

how to find the patch number for oracle database

Quick Reference to Patchset Patch Numbers [ID 753736.1]


how to install OFSA client

How to Install the latest OFSA 4.5.x Client Patch [ID 263144.1]

how to install OFSA 4.5.39 for AIX ( RQ Manager )

1. Download from metalink patch number 2902123 ( for AIX 32 bit OFSA_32_p2902123_450_AIX.zip ) and 4959183  (p4959183_450_AIX.zip this patch is required in order to run OFSA RQ manager woth Oracle Database 10G )

2. Create a folder ( ex : /home/oracle/ofsa )


3. Unzip the first patch(2902123) in the folder created before


4. Apply the second patch ( 4959183 )
Copy the p4959183_450_AIX.zip file to the folder
Type the following command to extract the files from patch:  unzip -o p4959183_450_AIX.zip

5. Set OFSA_HOME correctly  in .profile ( or .bash_profile )

6. Run .postinstall (we will find it in the folder created at step 2 )
When asked, provide the following information:
Remove tmp <y>
Do not use TPOL <n
7. Edit $OFSA_HOME/bin/rq and replace INSTALL_DIR with OFSA_HOME


8.   Modifiy $OFSA_HOME/etc/OFS.INI and set the corresponding values


9. Start RQ manager ( you should have already an entry in tnsnames.ora for the OFSA oracle database )



2011-07-18

how to see only the execution plan in oracle database

The easiest way :  in sqlplus type : set autot trace exp  and then the desired statement;

exadata x2-8 hardware specifications

The Exadata Database Machine X2-8 is a full rack system with 2 database servers  and 14 Exadata Storage Servers. Each  database server comes with 64 Intel CPU cores (8 x eight-core Intel® Xeon® X7560 processors) and 1 TB of memory

exadata x2-2 hardware specifications

how to expand your exadata

http://blog.oracle-ninja.com/2011/07/exadata-storage-expansion-rack/

Three versions of the Exadata Storage Expansion Rack are available. From the Full Rack configuration with 18 Exadata Storage Servers; to the Half Rack with 9 Exadata Storage Servers; to the Quarter Rack system with 4 Exadata Storage Servers; there is a configuration that fits any application.

All three versions of the expansion rack are delivered with the same 2 TB High Capacity SAS disks, and Exadata Smart Flash Cache, available in the Exadata Database Machine.

Exadata Storage Expansion Quarter Rack : 96 TB of raw disk data capacity

Ora-00245 and ORA-17500 after upgrade to 11.2

After Upgrade To 11.2.0.2 We Recieve Ora-00245 During Autobackup Of The Controlfile. [ID 1308378.1]

2011-07-15

ORA-21561 : OID generation failed

The error below may happen also during creation of a new database.
The problem is that /etc/hosts is not properly configured (usually  It does not contain an entry for the name of the server )

Connection Via 10.2.0.3 SQL*Net Fails With Error ORA-21561: OID Generation Failed [ID 559981.1]

aix packages requirements for installing oracle database

Required OS packages:
bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.perfstat
bos.perf.libperfstat
bos.perf.proctools

ORA-01019

ORA-01019 Error Starting OFSA RQ on Oracle 10g/11g [ID 357464.1]

2011-07-11

semget failed, errno = 17, file ipcmutex.cpp, line 167

Mapping Rules Fail with User Requested Termination / Semget Failed Errors [ID 748700.1]

2011-07-08

rman with VTL deduplication

http://www.backupcentral.com/phpBB2/two-way-mirrors-of-external-mailing-lists-3/ibm-tsm-13/data-deduplication-60390/

According to Dilligent, when RMAN uses Multiplexing, it intermingles the
data from each RMAN so the data block will be different every time so the
blocks are different, similar to Multiplexing with Netbackup

1) Do the best you can to put like data together. (ie all Oracle
DB Backups go to the same de-dupe VirtualTape head (Repository),

2) Turn off all compression (Client and DB's)

3) Oracle Specific
Do not use RMAN's Multiplexing in RMAN will combine 4
Channels together and the backup data then will be unique every time thus
not allowing for de-duping)
Use the File Seq=1 (Then run multiple channels)

4) Do not Mix Windows and Unix data, It wont de-dupe well.

2011-07-04

datapump and long columns

If you are on 10.2.0.4 or prior versions of 10g Release 2, tables with long columns may not propagate properly in datapump. Therefore, they have to be migrated separately using the traditional export/import utilities. The fix to this issue is part of 10.2.0.5.

ORA-00600: internal error code, arguments: [kgscLogOff-notempty]

ORA-600 [kgscLogOff-notempty] On Session Logoff [ID 413120.1]

a new feature of 11G: direct read in case of a table bigger than %2 of buffer cache

An excellent article : http://coskan.wordpress.com/2011/06/24/plan-is-same-wait-profile-is-different/

"From the ouput above, you can see PRD database is doing direct path reads and QA database is using db_file_scattered reads and PRD is 3 times slower for each run. Somehow oracle favours doing 11G direct path implementation for full table scan (Links for direct path Doug Burns,Alex Fatkulin, Dion Cho ) on PROD. If you read the links you can see that this has to do something with the memory the buffer cache and small table threshold (for more information about this threshold Charles Hooper-great discussion with Jonathan Lewis on comments, Tanel Poder )."

There have been changes in 11g in the heuristics to choose between direct path reads or reads through buffer cache for serial table scans.
In 10g, serial table scans for "large" tables used to go through cache (by default) which is not the case anymore in 11g (where this decision to read via direct path or through cache is based on various stats).

2011-07-03

ORA-00600: internal error code, arguments: [2037] ORA-07445: exception encountered: core dump [kcbs_dump_adv_state]



During Startup (Open Database) Alert Log Shows ORA-600[2037] and ORA-7445[kcbs_dump_adv_state] (Doc ID 551993.1)

2011-07-02

How_to_stop_gather_stats_after_index_rebuild

How to stop collecting index statistics during an index rebuild :

Oracle 10g, by default, collects statistics for an index during 
index creation.  It is done by design. 
The internal parameter "_optimizer_compute_index_stats", is set to
TRUE by default.



 alter session  set "_optimizer_compute_index_stats"=FALSE;
 
IN this case, the time for rebuilding the index is much lower : 
15% faster for an index rebuild

2011-06-30

understand AWR

Understand each field of AWR [ID 884046.1]

cursor_sharing = ‘SIMILAR’ no more available in 11G

ANNOUNCEMENT: Deprecating the cursor_sharing = ‘SIMILAR’ setting [ID 1169017.1]

2011-06-29

Px Query caused Latch Free Waits

Px Query Caused Latch Free Waits [ID 1306688.1]

PX DEQ CREDIT SEND BLKD

Tips to Reduce Waits for "PX DEQ CREDIT SEND BLKD" at Database Level [ID 738464.1]

2011-06-23

Murphy

"orice persoană urcă pînă cînd atinge limita de incompetenţă"

Murphy

"orice persoană urcă pînă cînd atinge limita de incompetenţă"

2011-06-22

ORA-38788: More standby database recovery is needed

Creating Restore Point Or Open Read Only on Physical Standby Database Fails With ORA-38784 ORA-38788 OR ORA-16004 ORA-01196 ORA-01110 [ID 845013.1]


2011-06-15

Connections to 11g TNS Listener are slow

Connections To 11g TNS Listener are Slow. (Doc ID 561429.1)

ORA-32701 Possible hangs up to hang ID=0 detected


Bug 10013431  Hang / ORA-32701 during / after startup in RAC

 This note gives a brief overview of bug 10013431 (Doc ID 10013431.8 )

This problem is introduced in 11.2.0.2 .

Shortly after or during instance startup in RAC, one or many of the instances
end up in a hang state waiting for a LB or NB DLM resource.

Rediscovery Notes:
 - RAC on 11.2.0.2 
 - a hang occurs shortly after instance startup where there is no blocking
   session to be found from system state or hang analysis
 - Alert messages like below may be seen;
 "ORA-32701: Possible hangs up to hang ID=0 detected"
 
 
This bug is fixed in 11.2.0.2.1 ( 11GR2 patchset 1, PSU1 ) 

2011-06-14

banii

"De multe ori, banii costa prea mult"

a bug of JDBC 10.2 with JDK 1.5

original link : http://marist89.blogspot.com/2008/12/bug-part-ii.html
Oracle (the database software) let a bad piece of data in. Oracle says the client should type the data when binding. I agree. But I also think that the server shouldn't let non-numeric data into numeric columns, regardless. I contend that this is a bug on the server side as well as a bug on the client side. This is only one specific case of a Java program inserting bad data.

2011-06-10

ORA-3136 WARNING: inbound connection timed out

A possible cause may be SGA latch contention 
The theory is that while the shared_pool was being re-sized in the SGA, Oracle grabbed a latch. The memory resize operation took a while and while Oracle held that latch, nobody could login.

See the following link : http://marist89.blogspot.com/2009/08/sga-latch-contention.html 


2011-06-08

Memory Notification: Library Cache Object loaded into SGA

Memory Notification: Library Cache Object Loaded Into Sga [ID 330239.1]

2011-06-06

java jvm and oracle ilearning

Is A Java Virtual Machine (JVM) Required For ILearning Client Machines? (Doc ID 413598.1)


oracle ilearning

Oracle iLearning Release 5.0 

kkpo_rcinfo_defstg

UPDATE: bug 10373381 is fixed in PSU2 ( 11.2.0.2.2 ) - see below

ORA-00600[KKPO_RCINFO_DEFSTG:OBJNOTFOUND] ON 11.2 DATABASES AFTER UPGRADE [ID 1308400.1]


2011-06-01

ASM Crashes as HAIP Does not Failover When Two or More Private Network Fails

ASM Crashes as HAIP Does not Failover When Two or More Private Network Fails (Doc ID 1323995.1):

 

ofsa 4.5.39 and oracle 11g

Certification: Is OFSA 4.5.39 Certified with Oracle RDBMS 11G? (Doc ID 762238.1)

 

OFSA 4.5.39 and above is certified with Oracle RDBMS 11G Release 1 and 2.

2011-05-31

FORCE LOGGING is irrelevant in NOARCHIVELOG mode

FORCE LOGGING is irrelevant in NOARCHIVELOG mode; this was a change introduced in 11g.


ORA-27302: Failure Occurred At: Skgpalive1

ORA-27300, ORA-27301, ORA-27302: Failure Occurred At: Skgpalive1 During 'Shutdown' [ID 356640.1]


2011-05-27

controlfile sequential read

In case this wait event is very annoying in you awr reports, see if there is any datafile offline or in recover.

2011-05-23

ORA-39726

Bug 6512811 - ORA-39726 adding column to table after it is uncompressed (by ALTER TABLE .. MOVE) [ID 6512811.8]

kdiblcfls

ORA-00600: internal error code, arguments: [kdiblcfls:rowidIllegal], [130], [128], [], [], [], [], []

This error is likely to be linked to the ORA-28604  . Drop the indexes on the table involved and then recreate them

2011-05-19

ORA-600 [kcblasm_1]

ORA-600 [kcblasm_1] When a SELECT With Hash Join Is Involved [ID 1133845.1]


2011-05-18

ORA-600 [prshntcb-1]

Bug 8705594  OERI [prshntcb-1] when PARALLEL hint syntax reversed

2011-05-09

consum

"Concluzia e trista- consumam din ce in ce mai mult, mai ales lucruri de care nu avem nevoie. In urma cu ceva vreme o prietena imi spunea urmatoarele: cu cat castigi mai mult, cu atat consumi mai mult si nevoile iti cresc. Si in ciuda eforturilor noastre, intotdeauna va exista ceva mai bun decat ceea ce avem noi, cel putin cand vine vorba de partea materiala.
Mersul la cumparaturi a devenit si la noi o modalitate de distractie, de a scapa de stres, de nervi, de a depasi depresii etc. De abia imi mai aduc aminte timpurile in care mergeam la cumparaturi fiindca aveam nevoie de ceva: ghete noi deoarece perechea veche imi ramasese mica, un tricou nou pentru a-l inlocui pe cel agatat etc. Bineinteles, pe atunci eram copil iar hainele nu valorau prea mult in mintea mea. Acum, am nevoie costume pentru munca dar si de tinute pentru timpul liber. Citeam pe undeva ca astazi purtam, in medie, de patru ori mai multe haine decat se purtau acum 25-30 de ani. Cumparam mai mult si mai prost, nu in sensul de calitate si pret, ci de armonizare cu venitul si posibilitatile noastre.
"

http://smartwoman.hotnews.ro/ne-umplem-cosurile-de-parca-am-face-provizii-in-caz-de-foamete-golim-rafturile-ca-sa-scapam-de-depresie-ca-sa-sarbatorim-ca-sa-nu-ne-plictisim.html

ORA-12839: cannot modify an object in parallel after modifying

Mappings Fail with ORA-12839 Ater Upgrade Oracle Database From 10.2.0.2 To 10.2.0.5 [ID 1314402.1]

2011-05-08

ORA-00600: internal error code, arguments: [4454]

ORA-00600: internal error code, arguments: [4454]
Large SQL Statement Fails With ORA-600 [4454] [ID 353190.1]

DBMS_SPACE.CREATE_TABLE_COST

This procedure is used in capacity planning to determine the size of the table given various attributes. The size of the object can vary widely based on the tablespace storage attributes, tablespace block size, and so on. There are two overloads of this procedure.
·         The first version takes the column information of the table as argument and outputs the table size.
·         The second version takes the average row size of the table as argument and outputs the table size.

2011-05-04

To start a pre11gR2 database in 11gR2 Grid Infrastructure environment, node(s) must be pinned.

Document TitlePre 11.2 Database Issues in 11gR2 Grid Infrastructure Environment (Doc ID 948456.1)

gipchaLowerProcessNode: no valid interfaces found to node

11.2.0.2 Grid Infrastructure upgrade/install on >1 node cluster failing with "gipchaLowerProcessNode: no valid interfaces found to node" in crsd.log (Doc ID 1280234.1)

how to download grid infrastructure 11.2.0.2

11.2.0.2 Patchset Location For Grid Infrastructure And RDBMS.

Doc ID 1223673.1

 

memory resize operations in 11G

http://blogs.oracle.com/UPGRADE/2011/03/new_hidden_parameters_in_oracl.html

2011-04-29

Downshifting

  • Making a list of weekly purchases and eliminating non-essential items
  • Cutting up a credit card
  • Not buying impulsively for instant gratification
  • Hand-making items
  • Donating, recycling or reusing old items
  • Buying quality secondhand goods
http://en.wikipedia.org/wiki/Downshifting

Document TitleOCR Corruption after Adding/Removing voting disk to a cluster when CRS stack is running

OCR Corruption after Adding/Removing voting disk to a cluster when CRS stack is running (Doc ID 390880.1)

how to ADD/REMOVE/REPLACE/MOVE ocr and voting disks

Document TitleOCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE) (Doc ID 428681.1)

REP-0124: Unable to write to the temporary file

UPDATE: this error may also be caused by lack (or low) of disk space on your application server ( check C or D drive in case you have windows )

CSTRSCCRP Ends In Error Rep-0124 Unable To Write To The Temp [ID 751482.1]

2011-04-28

Initial Extent Size of a Partition Changed To 8MB From 64KB

Initial Extent Size of a Partition Changed To 8MB From 64KB [ID 1295484.1]