h

Nu inseamna deloc ca-i ajuti pe oameni daca incerci sa faci intotdeauna pentru ei ceea ce ar putea face si ei insisi.

how to export to csv an oracle table

The original  script can be found here : http://www.oracle-base.com/dba/miscellaneous/csv.sql

learn db2 by oracle concepts

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

ORA-00060: Deadlock detected

In an OLTP environment, when you encounter this error check if you have bitmap indexes on you transactional tables.

This type of index may be a cause for ORA-60 .See also : http://www.oratechinfo.co.uk/deadlocks.html

'row cache lock' Causing Slowness On 11.2 Databases

Many Processes Waits Too Short For 'row cache lock' Causing Slowness On 11.2 Databases [ID 1162566.1]

problems with new feature in 11g : failed login delay

In Oracle Database 11G there is a new 'feature' related to hacking prevention:

Logon Delays:

A hacker may attempt a brute force hack to break into your Oracle Database. In this case they try constant logons to the database using some form of a word list. Oracle 11g includes a logon delay that takes effect after the third failed password entry attempt. This makes the brute force hacking more difficult. After the third failed logon attempt, Oracle will incrementally delay subsequent logon or password prompts up to a maximum of 10 seconds. No delay will occur if the logon is successful.

BUT there is a problem/bug , until OracleDatabase version 11.2.0.2  ( or 11.1.0.7.5 - not yet released ) . You can encounter this bug and experience high library cache contention , when you have both users connecting with good passwords and users connecting with bad passwords :

RMAN compressed backups contain corrupted blocks

RMAN compressed backups contain corrupted blocks for non-standard block sizes [ID 1273902.1]

Oracle Database 11g - Architecture Diagram

http://jhdba.wordpress.com/2010/12/15/oracle-database-11g-interactive-quick-reference/

kxtotolc_lobopt

ORA-00600 [kxtotolc_lobopt] When Getting An Explain For a Statement With Bind Variables (Doc ID 1050592.1)

PARALLEL_MAX_SERVERS

 Default value Derived from the values of CPU_COUNT, PARALLEL_THREADS_PER_CPU, and PGA_AGGREGATE_TARGET

how to authentificate oracle users in active directory

Configuring Oracle Advanced Security Option (ASO) with Microsoft Windows Server 2003 Active Directory Kerberos KDC (Doc ID 331252.1)

 

How to create OracleContext in Microsoft Active Directory

Creating an OracleContext in Microsoft Windows 2003 Active Directory [ID 361192.1]


 

kksfbc child completion

Database Hung With "kksfbc child completion" and "Cursor: Pin X" Waits (Doc ID 430555.1)

 

raza

O raza de lumina

Despre frumusetea pierduta a vietii - Andrei Plesu

Daca ma gândesc bine, reprosul esential pe care îl am de facut tarii si vremurilor este ca ma împiedica sa ma bucur de frumusetea vietii. Din când în când, îmi dau seama ca traiesc într-o lume fara cer, fara copaci si gradini, fara extaze bucolice, fara ape, pajisti si nori. 

how to install oracle spatial 10g/11g

Steps for Manual Installation / Verification of Spatial 10g / 11g (Doc ID 270588.1)

when my oracle support (MOS) is slow

There is also the HTML-based site at supporthtml.oracle.com for the main (Flash-based) site ( support.oracle.com )

Thread-1 ERROR main: nmectl.c

Grid Control Agent Startup Fails on AIX Server due to Invalid Timezone Setting at the OS [ID 825933.1]
      Modified 19-NOV-2010     Type PROBLEM     Status PUBLISHED  
 

EMCLI ( for GRID 11G)

Enterprise Manager Command Line Interface Download

ORA-1122

ORA-1122 Signalled During ALTER DATABASE OPEN after a Resize Operation [ID 556481.1]

how to compare 2 awr reports

A very good article : http://oracledoug.com/serendipity/index.php?/archives/1513-AWR-Differences-Report.html

also : http://www.dbasupport.com/oracle/ora10g/self_managed.shtml

ORA-01200 , ORA-01110 and ORA-01122

Please be aware that the note below is not an official one.
You may apply what is written below, but on your own risk.

how to use more than 3G in Linux x86

Solution: install a x64 linux or  add PAE ( see below )

$ sudo apt-get update
$ sudo apt-get install linux-headers-server linux-image-server linux-server

http://www.cyberciti.biz/faq/ubuntu-linux-4gb-ram-limitation-solution/

rman recovery scenarios

the source :
http://momendba.blogspot.com/2010/09/rman-backup-recovery-most-essential-but.html 

 

ORA-30012

ORA-30012 Database Does Not Start With UNDO_MANAGEMENT=AUTO [ID 258506.1]

Foame

Paradoxul  dietei: Cand vrei sa slabesti trebuie sa fii satul tot timpul iar cand vrei sa iei in greutate trebuie sa-ti fie foame tot timpul.

PASSWORD_LIFE_TIME in Oracle 11G

In the default profile in Oracle Database 11g, the parameter PASSWORD_LIFE_TIME is set to 180

oracle 11Gr2 on vmware ORA-24324 ORA-24323

 In order to start an oracle database 11gr2 on a virtual linux x86 machine, you have to apply patch 8670579(from metalink)

SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 29 21:33:17 2010

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

Enter user-name: / as sysdba
Connected to an idle instance.

SQL> startup;
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel
SQL> quit



  PATCH  8670579    DBBETA :NETCA/DBCA FAILED WITH HOTSPOT VIRTUAL MACHINE    11.2.0.1.0         Linux x86 (American English)    General    Oracle Database Family    26 Feb 2010    1.1 MB   

OCM Adrian Neagu

http://education.oracle.com/education/otn/oct19_10/aneagu.html

when to rebuild indexes - SYS_OP_LBID

Script to investigate a b-tree index structure [ID 989186.1]

a free diagnostic tool

http://tech.e2sn.com/oracle-scripts-and-tools/session-snapper

alege ce iubesti si apoi iubeste ce-ai ales

kernel: oracle: page allocation failure.

On Linux machines you may encounter errors like :

 kernel: Out of Memory: Killed process 18061 (oracle).
 kernel: oracle: page allocation failure. order:0, mode:0xd0

next_date for dbms_job

Does DBMS_JOB Recompute the NEXT_DATE Interval After or Before Executing the Procedure or Job[ID 166917.1]

timp

Trăim pe fugă, mâncăm pe fugă, iubim pe fugă, dormim pe fugă. Între dimineaţă şi seară, e sprintul. Ne trezim că trec anotimpurile peste noi. Apropos, e toamnă de mult... Anii fug si ei. Ne ardem viaţa în birouri rigide, în zgomotul tastelor şi al aparatelor de aer conditionat, închişi în calculatoare,
despre care ne amăgim că ne-ar fi ferestre spre lume.

lista mea

http://angunn.wordpress.com/2010/05/04/lista-mea-de-m-am-saturat/

http://angunn.wordpress.com/2010/10/15/frustrari-personale/

Ora-28232

ORA-28232: invalid input length for obfuscation toolkit
ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI", line 0
ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT", line 153

fast-food

Calitatea ingredientelor este minima: fast food-ul este prin excelenta o mancare ieftina, dar cu o valoare adaugata mare, 500-1000% sau chiar mai mult. Costurile auxiliare(altele decat cele cu materia prima) sunt mari: localurile se afla in locuri circulate, scumpe, marile lanturi de fast food “baga” sume colosale in publicitate iar cele mici in spagi.

how to load images, videos and all multimedia stuff in oracle database

http://www.xor.com.au/data/workshop/workshop_mm.pdf

how to change the language of database error messages

Purpose of this document : To explain how to change the language of the Oracle RDBMS error messages.

condus in ro

- Ce accident, Doamne iartă-mă! nu mă rabd eu, că nu ştiam amu cum să ies din jenă.

utl_mail how to send emails from oracle

How to send emails with or without attachments using PL/SQL.

let's do it romania - ValiU

Mesajul si pozele de la ValiU ( coordonator Valea Jiului pentru proiectul Let's do it Romania ):

exadata v3 ( x2-8 )

x2-2 and x2-8 are the next releases for exadata v2.

x2-8  has fewer but way bigger database servers. That means that x2-8 will scale better with the less RAC overhead for the databases

mentalitate balcanica

Discutiile cu parintii si prietenii de acasa , din romania, merg de obicei pe un tipar binecunoscut:
- De cat timp lucrezi acolo?
- De 3 ani.
- Wau... super!... si cat castigi?
- Destul de bine... cam XXXX lire/luna.
- Si... ti-ai luat casa acolo?
- NU
- Ah... Dar ce masina ti-ai luat?
- NU mi-am luat masina... oricum nu s-ar merita sa o folosesc prin Londra...
- Aha... Si... te-ai casatorit?
- NU inca...
- Pai si atunci... de ce te chinui acolo?


http://infoeconomice.blogspot.com/2010/09/visul-romanesc.html

dacă laşi un om să vorbească destul de mult, se va face singur de râs

"dacă laşi un om să vorbească destul de mult, se va face singur de râs"

Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.

Unable to Connect to Database with Oracle Client Software for Windows [ID 215255.1]

Errors in ASM, after upgrade to 11gR2

Alert: Querying v$asm_file Gives ORA-15196 After ASM Was Upgraded From 10gR2 To 11gR2 [ID 1145365.1]

cu cine se culca femeile ?

-Pana la 14 ani cu papusile
-de la 15 la 35 cu cine vor
-de la 35 la 45 cu cine gasesc
-de la 45 la 55 cu cine le doresc
-de la 55 la 65 cu geamul deschis
-de la 65 la 75 cu usa deschisa
-dupa 75 mor din cauza curentului !

postcapitalism

Masina vs. Bicicleta

tdposync

Remove Backups From Tivoli not available in RMAN catalog [ID 1209740.1]

cancerul e maladia tristetii caci atunci cand esti trist in adancul sufletului , organismul uita sa se apere

http://think.hotnews.ro/cum-traiesti-cand-pierzi-pe-cineva-drag-temerarii-invata-sa-supravietuiasca.html

Corpul moare primul. Obiceiurile urmează

http://www.realinromania-blog.com/corpul-moare-primul-obiceiurile-urmeaza/

11.2.0.2 ( 11G release 2, patch set 2 ) released

you can download from here  : 10098816

maxBlockTime

Long Running Query / Procedure Causes Web Deployed Forms to Disconnect [ID 271611.1]
 
The end user may see the errors FRM-92100 or FRM-92101 or FRM-92102 e.g.

FRM-92101: A failure has occured on the Server.
You will need to reestablish your session.

singuri acasa

"Gândiţi-vă că sunteţi părinte şi vă întrebaţi pentru care dintre copiii dumneavoastră să cumpăraţi haine şi rechizite pentru şcoală fiindcă nu aveţi bani pentru toţi"

Există 350.000 de copii ai căror părinţi au trebuit să plece în Italia şi Spania pentru a le trimite bani copiilor. Aceşti copii nu se bucură de dragostea şi atenţia părinţilor

...în peste 20% dintre case s-a redus numărul meselor zilnice, aproape jumătate dintre familii au fost nevoite să-şi vândă lucruri din casă şi 44 de procente au început să dea şi din uneltele agricole sau animalele care pe termen lung le erau singurele mijloace de subzistenţă.

http://www.evz.ro/detalii/stiri/copiii-romaniei-in-fata-crizei-singuri-acasa-si-saraci-905487.html

how to enable logging for oracle forms on application server

Forms Servlet Logging Explained [ID 219471.1]

kernel: program nmhs is using a deprecated SCSI ioctl, please convert it to SG_IO

Error - program nmhs is using a deprecated SCSI ioctl, please convert it to SG_IO in /var/log/messages [ID 566547.1]
 

CURSOR_SPACE_FOR_TIME has been deprecated in 10.2.0.5

CURSOR_SPACE_FOR_TIME Has Been Deprecated [ID 565424.1]

CURSOR_SPACE_FOR_TIME has been deprecated in 10.2.0.5 and 11.1.0.7.

CURSOR_SPACE_FOR_TIME was originally introduced to try and help reduce latch contention by keeping cursors in memory in the SGA rather than allowing their data to be flushed from the shared pool. Such latch contention is avoided in current releases by the use of cursor mutexes and so this parameter is no longer relevant.

Note:
This alert is to warn that CURSOR_SPACE_FOR_TIME will be deprecated in these Patch Sets.

Systems running with CURSOR_SPACE_FOR_TIME = TRUE may encounter some rare scenarios which can lead to logical data corruption.

Woraround: 
Customers currently using CURSOR_SPACE_FOR_TIME=TRUE are advised to change the setting to FALSE (the default),  or at least assess the impact of such a change prior to applying the 10.2.0.5 or 11.1.0.7 Patch Set.

Oracle Data Masking

How To Use Data masking Feature In Grid Control [ID 736833.1]

emotiile ne fraieresc

Starea de suferinta nu vine din cauze problemei ci din teama ca suntem incapabili sa rezolvam aceea situatie.

Suferinta nu iti apare imediat cand cineva iti fura masina, ci cand te gandesti ca … nu o poti recupera.  Suferinta nu iti apare imediat cand iubita/iubitul te paraseste ci cand te gandesti ca nu o sa mai ai aceea fericire langa tine.

Suferinta nu iti apare imediat ce ai fost dat afara de la servici ci in momentul in care te gandesti ca nu o sa faci rost de alt loc de munca imediat.

ORA-00569: Failed to acquire global enqueue

Error on rac : Error 569 occured while spilling buffered messages

v$session_longops for ASM

In ASM, you can query the V$ASM_OPERATION view to determine the amount of time remaining for the drop/rebalance operation to complete.

ORA-08104

Session Was Killed During The Rebuild Of Index ORA-8104 [ID 375856.1]

Loto

"Bursa este un mod de a lua banii oamenilor care se cred destepti. Pentru prosti se foloseste Loto"  

opiino: Attach failed! error=-1 ifvp=0

"Opiino: Attach Failed! Error=-1 Ifvp=0" Written In Udump File [ID 399727.1]

begin backup - shutdown

What happens when you forget a tablespace in begin backup, before a shutdown immediat

Cannot Open Database With Tablespaces still in Hot Backup Mode [ID 1017140.102]

real scalability

http://highscalability.com/google-architecture  
"Now that you have a good storage system, how do you do anything with so much data? Let's say you have many TBs of data stored across a 1000 machines. Databases don't scale or cost effectively scale to those levels. That's where MapReduce comes in."

http://highscalability.com/youtube-architecture    Youtube runs on mysql. Cool!
The team:
2 sysadmins, 2 scalability software architects
2 feature developers, 2 network engineers, 1 DBA

the database behind twitter

Twitter is running on cassandra ( a NOSQL database )--> nosql  database means non-relationational database

http://guyharrison.squarespace.com/blog/2010/8/23/playing-with-cassandra-and-oracle.html

lipsa

http://balonul-imobiliar.blogspot.com/2010/08/oricum-ar-fi-murit.html

transfer time, not seek time

Exadata uses at least a 4 MB Automatic Storage Management (ASM) allocation unit (AU) [more on ASM basics]. This means that there is at least 4 MB of contiguous physical data laid out on the HDD which translates into 4 MB of contiguous data streamed off of disk for full table scans before the head needs to perform a seek. With such large I/O requests the HDDs are able to spend nearly all the time transferring data, and very little time finding it and that is what matters most. Clearly if Exadata is able to stream data off of disk at 125 MB/s per disk (near physics speed for this type of workload) then any alleged “contention” is really not an issue. In many multi-user data warehouse workloads for PoCs, I’ve observed that each Exadata Storage Server is able to perform very close or at the data sheet physical HDD I/O rate of 1500 MB/s per server.

ORA-33262: Analytic workspace EXPRESS does not exist

ORA-39127 ORA-37002 ORA-33262 During Expdp After Upgrade To 10g. No Errors If Using Exp [ID 741232.1]

2012 - the end

Stau de vorba 2 mayasi:
Unu: Bah, am ramas fara piatra si nu mai am pe ce continua calendarul..
Celalalt: S-ar putea ca in viitor sa se crizeze cineva din cauza asta…..

RErelease patchset 10.2.0.5 for linux 32bit

Patch Set 10.2.0.5 rereleased on Linux x86 (32 bit) [ID 1156958.1]

ORA-14404: partitioned table contains partitions in a different tablespace

How to drop an offlined tablespace, if partitions from a partitioned table resides in it [ID 267125.1]

Configuring the Oracle Messaging Gateway Agent on Windows

Metalink note id : ID 188833.1

the small approach

A boy, one who is athletically very talented but not too bright, takes on a job as a stripe painter for the highway department. The department gives him bucket of paint and a brush and drives him out to the highway he’s supposed to paint. His first day on the job, he paints a stripe almost seven miles long. This is an utterly stunning feat, for no one previously had ever painted more than five miles in a day. The department was ecstatic. Apparently, this boy’s true calling was to paint roadways.

Exadata best practices

Oracle Sun Database Machine Application Best Practices for Data Warehousing [ID 1094934.1]

alter system set "_BACKUP_KSFQ_BUFSZ"=1048576;

RMAN Restore Performance from Tape is Very Poor [ID 850988.1]

stripe size for filesystems

http://www.circle4.com/jaqui/eserver/eserver-tuningaixandoracle-oct08.pdf

GPFS and Oracle

IBM General Parallel File System (GPFS) and Oracle RAC [ID 302806.1]

La 3 luni de la lansarea I'Velo ajunge la 105.000 de inchirieri

Program de functionare centre ( 2010 ) :

ORA-04030 (QERHJ hash-joi,kllcqas:kllsltba)

This is not an Oracle memory resource issue since
connecting via SQL*Net is using less PGA for the session than
a local connection which is successful.

Client Connection Fails with ORA-04030 (QERHJ hash-joi,kllcqas:kllsltba) [ID 470604.1]

no parallel hint when sorting or grouping

an useful article http://dbakevlar.blogspot.com/2010/02/lead-developer-and-i-have-been-working.html

11.2.0.1.1 ( 11.2.0.1 PSU1 )

Patch:9352237 13 APR 2010

11.2.0.1.2 ( 11.2.0.1 PSU2 )

Patch 9654983  13.07.2010

OFSA - ORA-01019: unable to allocate memory in the user side

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

When starting the OFSA Request Queue (RQ) using the "rq" or "mrq" scripts in the $OFSA_HOME/bin directory on Oracle 10g, the following error may occur:
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:
OCI Function:   [0] - olon(), orlon()
Oracle Error:   [1019] - ORA-01019: unable to allocate memory in the user side
Driver Function:         drv_oci::Connect()
MB(AttachDB()) Error attaching to database: <database name>

Error 376 encountered while recovering transaction

Messages in the alert.log (ORA-00376 Error 376 encountered while recovering transaction) after partial restore and open resetlogs. [ID 283846.1]

oracle db - bad performance if you have more than 255 columns in a table

http://tech.e2sn.com/oracle/exadata/performance-troubleshooting/exadata-smart-scan-performance

"you should be more aggressive with patching your Exadata cell & Database software as there are lots of bugs out there"

ro-it

Un italian angajeaza sa-i vopseasca gardul cere imprejmuia casa 3 romani. Dis-de-dimineata, inainte de a pleca la serviciu, italianul le da celor 3 instructiunile:
-Aveti aici 3 galeti de vopsea care va vor ajunde sa vopsiti tot gardul. In bucatarie e mancare, cand o sa va vina foame, va puteti servi. Aaa, era sa uit. Ati vazut calul pe care il tin inchis in spatele curtii? Sa nu cumva sa lasati poarta dechisa sa scape de acolo ca nu stiu ce fac cu voi. S-a inteles?
-Am inteles sefu,raspund romanii intr-un glas.
Pleaca italianul, iar romanii se apuca de treaba. Nu dupa mult timp, unul din ei zice:
-Ma, mie mi-a venit foame, hai sa vedem ce are asta de mancare!
Bucataria italianului, plina de bunatati. Dupa un ospat pe cinste, romanii cauta si ceva de baut, dar nu gasesc decat apa si suc. Atunci, unul dintre ei zice:
-Ma, stiu eu cum sa facem rost de bautura. Mergem si vindem o galeata de vopsea, cumparam bautura, iar vopseaua de ramane o mai diluam, o mai “lungim” si terminam noi gardul. Dupa ce au baut s-au apucat de vopsit, dar cand mai aveau vreo 3 m din gard se termina vopseaua.
-Acum ce dracu facem? De unde luam vopsea? Italianul o sa-si dea seama ca noi am luat-o…
-Ma fratilor, las’ pe mine,zice unul mai istet, ca stiu eu cum facem. Mai strangem putina vopsea pe pensula si dam pe botul la cal, iar cand va veni italianul ii vom spune ca acesta a scapat si a mancat-o.
Zis si facut. Pe seara, ajunge si italianul acasa.
-Ma, ce-ati facut cu vopseaua? Eu am calculat la fix si trebuia sa va ajunga.
-Sefu’, ne pare tare rau, dar a scapat calul si a mancat-o.
La auzul acestor vorbe, italianul intra in casa, ia pusca si nici una nici doua, impsca calul.
-Ce naiba dom’le, pt o galeata de vopsea ai omorat saracul animal? Iti cumparam noi alta…
-Ba fratilor, vedeti voi casa asta? Tot cu romani am facut-o. Da-l in mortii mamii lui de cal ca mi-a mai mancat 30 de saci de ciment, 800 de caramizi, 4 grinzi…

ora-24005 must use dbms_aqadm.drop_queue_table

When you try to drop a user, you can encounter the following message :

ora-24005 must use dbms_aqadm.drop_queue_table

how to tune linux for oracle

An excellent article : here

best way for stripping

Oracle recommends the SAME principle (SAME = stripe and mirror everything) with a stripe size of 1 MB.

Don't put database files on ACFS ( Oracle Automatic Storage Management Cluster File System )

Create Oracle Database data files directly on Oracle ASM storage for best performance because Oracle ACFS does not support directIO for file read and write operations in 11g Release 2 (11.2).

ERROR-Agent is blocked. Blocked reason is: Agent is out-of-sync with repository

Communication: Agent to OMS Communication Fails if the Agent is Blocked and Re-synchronization is not Successful [ID 1054605.1]

Enterprise Manager Grid Control - Version: 10.2.0.5 to 10.2.0.5 - Release: 10.2 to 10.2
Information in this document applies to any platform.

Symptoms

After upgrading the OMS and Agent to 10.2.0.5 version, getting the following error in &lt;&gt;/sysman/log/emagent.trc:

Did not receive valid response to ping "ERROR-Agent is blocked. Blocked reason is: Agent is out-of-sync with repository. This most likely means that the agent was reinstalled or recovered. Please contact an EM administrator to unblock the agent by performing an agent resync from the console. Please contact EM adminstrator to unblock the agent"

Cause

The Agent is blocked in the Grid Console due to the "clean-start procedure" followed on the Agent side which included deletion of the &lt;&gt;/sysman/emd/agntstmp.txt.
Re-synchronization of the Agent from Console should help in resumption of the communication. But as per the error from the re-synchronization has failed due to "ORA-20206: Target does not exist: agentmachine.domain:host"

It was found that the &lt;&gt;/sysman/emd/targets.xml file on the Agent host did not have the 'Target TYPE' of 'host' in it. The cause for the missing 'host' entry is not clear.


Note: Although it is not normally advisable to edit the targets.xml file directly, this is an exception.
To correct this problem, follow these steps:

1. Stop the Agent

cd <<AGENT_HOME>>/bin
emctl stop agent

2. Take a backup of the <<AGENT_HOME>>/sysman/emd/targets/xml.
    Edit the file and add the following line:

...
  <Target TYPE="host" NAME="agentmachine.domain"/>
</Targets>

  To identify the agent hostname, open the <<AGENT_HOME>>/sysman/config/emd.properties file and check the parameter EMD_URL. For example:

EMD_URL=https://agenthostname.domain:1830/emd/main/

The hostname of the Agent machine in this case is the agenthostname.domain.

3. Start the Agent

cd <<AGENT_HOME>>/bin
emctl start agent

4. In the Grid Console, Navigate to Setup -> Agents -> click on the Agent name.

5. In the Agent home page, click on the link for 'Resynchronize Agent'
Choose the 'Unblock Agent' option and click Continue

Message file sp1.msb not found on windows

Several ORACLE_HOMEs in MS Windows - Error 6 Initializing SQL*Plus. Sp1.Msb Not Found And SP2-750 [metalink ID 466554.1]

Aix specific tunning for oracle

If you store your datafiles in filesystems each filesystem should have own log device  or use INLINE log
Tune JFS log buffer

• ioo -p -o j2_dynamicBufferPreallocation=256 -o

• ioo -p -o pv_min_pbuf=4096

• vmo -p -o minperm%=3 -o maxperm%=90 -o maxclient%=90 -o lru_file_repage=0 -o strict_maxperm=0

Oracle 10g slow truncate

Truncate Takes A Long Time -- Waits on RO enqueue [metalink ID 286363.1]

how to build your own exadata

Exadata (2)  is a new product ( less than 1 year ).

The key of its performance is the Sun Flash Accelerator F20 PCIe Card  ( 4x96GB =384GB flash cache per each exadata storage server ( a.k.a cell ) ) and level 2 SGA cache from 11Gr2

"main class could not be found, program will exit!"

JVM Launcher - "Cannot Find main class" on install of Oracle Enterprise Edition [ID 244132.1]

Symptom(s)
~~~~~~~~~~
Running setup.exe from disk1 results in JVM Launcher dialog with error message: 
"main class could not be found, program will exit!"

AIXTHREAD_SCOPE

Why should AIXTHREAD_SCOPE be set to 'S' on AIX during an RDBMS installation?

Jumbo Frames with RAC

original link : http://blogs.sun.com/glennf/entry/jumbo_frames_with_oracle_rac

After months looking at "other things", they finally were convinced to try this "Best Practice" with Jumbo Frames. Immediately, they saw:

• 50% reduction in CPU overhead
• 75% reduction in Global cache buffer waits
• IP Reassemblies dropped by 10x 

ORA-04063: package body "ORACLE_OCM.MGMT_DB_LL_METRICS" has errors

OEM recommends that EXECUTE privilege being revoked from PUBLIC. After revoking the privilege, the  following errors appeared in alert log:

Access a secure web page(web service) from pl/sql

A Simple Example of Using UTL_HTTP to Access a Secure Web Page [ID 265616.1]
		Modified 26-NOV-2008     Type BULLETIN     Status PUBLISHED

PURPOSE
-------

Step by step guide to configuring UTL_HTTP for https. 

How to extract datafiles from the ASM

https://twiki.cern.ch/twiki/bin/viewfile/PSSGroup/HAandPerf?rev=1.4&filename=ASM_metadata_30012006.html

1. We find the disk group and file number of the database spfile:

sys@+ASM1> select GROUP_NUMBER,FILE_NUMBER,BYTES from v$asm_file where type='PARAMETERFILE';

GROUP_NUMBER FILE_NUMBER      BYTES

------------ ----------- ----------

           1         267       3584

2. We find the number and location of the extents where the spfile is written:

sys@+ASM1> select DISK_KFFXP,AU_KFFXP,PXN_KFFXP,XNUM_KFFXP,LXN_KFFXP from x$kffxp where GROUP_KFFXP=1 and NUMBER_KFFXP=267;

DISK_KFFXP   AU_KFFXP  PXN_KFFXP XNUM_KFFXP  LXN_KFFXP

---------- ---------- ---------- ---------- ----------

        24       3820          0          0          0

         0        176          1          0          1

3. From steps 1. and 2. above we know that the spfile is 3584 bytes long and is stored in 2 mirrored extents: one on disk 0, the other on disk 24 (on disk group). We can find the OS path of the disks with the following query (note the test system used was on Linux using asmlib):

sys@+ASM1> select failgroup,disk_number,path from v$asm_disk where GROUP_NUMBER=1 and DISK_NUMBER in (0,24);    

FAILGROUP  DISK_NUMBER PATH

---------- ----------- --------------------

FG1                 24 ORCL:ITSTOR08_2_EXT

FG2                  0 ORCL:ITSTOR11_10_EXT

4.  We can now confirm with OS commands that the mapping is correct. ‘dd’ allows the sysadmin to read the disks directly (bs=1M is the block size, while skip=176 means that the command starts reading at the offset 176M) . Using the disk name found in step 3 (only disk 0 demonstrated here) and the offsets found in step 2 we can confirm that the spfile data is at the expected physical location.

$ dd if=/dev/oracleasm/disks/ITSTOR11_10_EXT bs=1M count=1 skip=176|strings|head -4

test12.__db_cache_size=1476395008

test11.__db_cache_size=1476395008

test12.__java_pool_size=16777216

test11.__java_pool_size=16777216

How To Super-Size Work Area Memory Size Used By Sessions

Metalink note : 453540.1

How to super-size the work area memory size that can be used by any session in the database?
See also : http://dba-blog.blogspot.com/2005/08/pgamaxsize-hidden-parameter.html and  http://www.jlcomp.demon.co.uk/snark.html

Solution

With the automatic PGA management mode, you can control the size for the work area sizes (e.g. for a big sort).

Monitoring 10g Database Alert Log Errors in Enterprise Manager

Metalink note : 976982.1

putin

Putin si Medvedev stau de vorba.
- Trebuie sa desfiintam fusurile astea orare, creeaza numai probleme, spune Putin.
- De ce? - intreaba Medvedev
- Sun la Beijing sa-i felicit de ziua nationala, si-mi spun ca e maine , sun la Varsovia sa exprim condoleante si-mi spun ca avionul inca n-a decolat..

11.2.0.2 ( 11G release 2, patch set 2 )

11.2.0.2 will be available on oct 2010 ( see metalink note Release Schedule of Current Database Releases [ID 742060.1] )

Plaiul Foii

http://www.bzb.ro/index.php?page_name=stire_detalii&id_stire=55741

Elicopterul SMURD, chemat la Plaiul Foii pentru a salva viaţa unei fetiţe de 6 ani

Secure Oracle Application Server 10g ( SSL )

Implementing Secure Sockets Layer (SSL) on OAS 10g [ID 646241.1]
 
How To Setup and Configure SSO/OHS for SSL [ID 351341.1] 

PLS-201: identifier 'UNDEFINED' must be declared

A very strange error.
No information on metalink about it.

IBM AIX 6.1: Number of TCP Connections Limited - ORA-12547, Tnsping Yields TNS-12547 id 1084443.1

Connections to the database via the listener (i.e. TCP)  are limited in number and testing reveals that this number is consistent.  A shutdown of database and listener will resolve the issue until   number of TCP connections is established again.  Local or bequeath connections are NOT exhibiting this problem so local connections to the database are not failing at the time that this issue is reproducible. 

reasons

nu credeti ce vi se spune doar pentru ca cine spune e "credibil"... incercati sa gasiti si motivele pentru care vi se spune ceva

Nu exista premiu la final, doar amaraciunea ca am trait fara sa ascultam “melodia vietii”.

Cica omului la nastere i se baga in cap (educatie) tot felul de chestii, printre care si aceea ca orice face trebuie sa aiba un sens, un beneficiu, iar acest beneficiu sa se masoare intr-un castig oarecare. Daca nu castigi nimic, mai bine nu fa. Si ajunge, incet incet, sa traiasca precum intr-o competitie, de fapt un sir de competitii pe care (i se spune) ca trebuie sa le castige. Traieste cu sentimentul ca realizeaza ceva, ca tot efortul lui urmeaza sa fie rasplatit in curand. Este o cursa nebuna in care fugim cu totii, cat putem de tare, si atunci cand depasim pe unul sau pe altul avem impresia ca suntem “mai in fata” si ca o sa primim premiul cel mare.

FRM-92120

The error : FRM-92120: Registry file https:///:/OA_JAVA/oracle/forms/registry/Registry.dat is missing

write CLOB data to a file

I had some problems with the function described here : http://www.dbforums.com/oracle/1624851-clob-blob.html and here : http://www.dba-oracle.com/t_read_blob.htm

FUNCTION BASED INDEX

In Oracle 9i&10G, in order to use function based indexes, you have to set :

10.2.0.5 is here !

Patchset 8202632 :Description 10.2.0.5.0 PATCH SET FOR ORACLE DATABASE SERVER (only for linux)

Size : 1.1  G

Creating an OracleContext in Microsoft Windows 2003 Active Directory

metalink note ID 361192.1:

Purpose
An LDAP Schema is a collection of related entries (attributes, objectclasses) stored within an LDAP directory. An LDAP Context refers to all information relating to entries (users, groups, etc.) as well as their state.

Patching on 10.2.0.4 RAC on Sun Sparc (64 bit) can cause inventory corruption [ID 784774.1]

Description:
When patching on 10.2.0.4 on Sun Soaris, the inventory information on the remote nodes can get corrupted due to the unpublished bug 7364519.
The actual patch is applied correctly on all remote nodes.  The problem is with the inventory on remote nodes.
This problem does not affect other platform.

Download Applications Desktop Integrator -- ADI

Patch numbers for download of ADI : 3966101 ( base release 7.2 ) and 7286213 ( patch bundle 11 )

Grid Console Login Page Displays the Login Screen along with Message "HTTP/1.1 200 OK.."

The Grid Control login page displays the Login Form as well as the following message below it: ( note 758280.1 )

HTTP/1.1 200 OK Date: Thu, 07 Feb 2008 09:06:56 GMT Server:
Oracle-Application-Server-10g/10.1.2.0.2 Oracle-HTTP-Server Connection: close Transfer-Encoding:
chunked Content-Type: text/html; charset=iso-8859-1

ORA-27061: skgfospo: waiting for async I/Os failed

Database crashes producing ORA-27061 [ID 452866.1]
 
ORA-27061: skgfospo: waiting for async I/Os failed
IBM AIX RISC System/6000 Error: 22: Invalid argument

ORA-06512: at "SYS.DBMS_STATS", line 13437

ORA-00909: invalid number of arguments
ORA-06512: at "SYS.DBMS_STATS", line 13437
ORA-06512: at "SYS.DBMS_STATS", line 13457
ORA-06512: at line 2

Rostul

Când te desparţi din vina ta, încerci o vreme să te lupţi cu ireversibilul, îţi dai seama că n-are sens, te lamentezi de formă şi renunţi. Când te desparţi din vina celuilalt, ai nevoie de o perioadă de timp ca să înţelegi ce s-a întâmplat. Iei povestea de la capăt, pas cu pas şi te chinui să pricepi ce n-a fost bine şi unde ar fi trebuit ca lucrurile să apuce pe alt drum.
La fel se întâmplă şi atunci când te desparţi de ţara ta. Dezamăgit, înşelat, mânios, îndurerat. Nu ţi-e uşor s-o laşi. Ţara şi mama nu ţi le alegi. Te aşezi pe celălalt mal al lumii şi cauţi răspunsul: ce s-a întâmplat cu ţara mea de-am fost nevoit s-o părăsesc.
României i-a dispărut rostul. E o ţară fără rost, în orice sens vreţi voi. O ţară cu oameni fără rost, cu oraşe fără rost, cu drumuri fără rost, cu bani, muzică, maşini şi ţoale fără rost, cu relaţii şi discuţii fără rost, cu minciuni şi înşelătorii care nu duc nicăieri.

Save as xml the result of a cursor - dbms_xmlgen.getxml

select dbms_xmlgen.getxml('select reports.rep1(-1, null, ''01-01-2000'', ''01-04-2001'', null, null, null) from dual') xml from dual

EUL5_BATCH_USER

An error message is displayed whenever you try to submit a scheduled workbook as a Discoverer user(note 282829.1):

Database Error - ORA-04068: existing state of packages has been discarded
ORA-04063: package body
".EUL5_BATCH_USER" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 2

how to see the number of rows deleted

http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28419/d_sql.htm#i996963

agentiademplinitdorinte

"Nu mai vreau să fiu din carne şi oase, pentru că alea se strică cu timpul. Mi as dori sa fiu om de zăpadă. Atunci cu siguranţă voi vedea multe zâmbete şi sunt convins că nu mă va deranja nimeni"  Mile Carpenisan 

 

Connection lost contact between Primary and Standby

ORA - 03135 : connection lost contact while shipping from Primary Server to Standby server [ID 739522.1]

Changes

There may be a firewall rule changed or the firewall is newly installed.

See procedure/packege code in PL/SQL Developer

In PL/SQL Developer : "Source of ...  is not available"

Solution :   If you've PL/SQL developer, check tools>preferences>options>use DBA views if available.

Recover dropped oracle procedure

--- recover the dropped/changed procedure PROCEDURE_SALES 

select text from dba_source
     as of timestamp systimestamp - interval '15' minute 
     where name='PROCEDURE_SALES' and type = 'PACKAGE BODY'
order by line asc;

Slow Oracle Net Connections

From note [ID 1076022.1]  : Troubleshooting Slow Oracle Net Connections

Solutions here included purge of the old audit files, disabling auditing, etc

URSS

A Russian tourist arrives at London's Heathrow airport.
As he fills out the entry form, the immigration officer asks him:
-Occupation?
The Russian promptly replies:
-No, no, just visiting!

The perfect rman script backup

The perfect rman script backup:
run
{
allocate channel t1 type disk;
BACKUP AS COMPRESSED BACKUPSET check logical INCREMENTAL LEVEL 0 DATABASE filesperset 1 plus archivelog format '/mnt/u05/backuptest/backup_%d_set%s_piece%p_copy%c_%T_%U' TAG = DB_BACK_FULL_DAILY ;
backup current controlfile format '/mnt/u05/backuptest/backup_controlfile_%d_DBID%I_%T_%U.ctl' TAG=CTL_BACK_FULL_DAILY;
backup spfile format '/mnt/u05/backuptest/backup_parameter_%d_DBID%I_%T_%U.ctl' TAG=PARAM_BACK_FULL_DAILY ;
delete obsolete;
release channel t1;
}

Oscar si Tanti Roz

"...din orice moment al vietii tale poti incepe sa ti-o si traiesti"

banc DE

Un african, tocmai recunoscut ca azilant, se plimba mândru pe strazile noului sau oras.

El se adreseaza primului întâlnit, spunându-i: "Multumesc draga germanule, va multumesc ca m-ati primit în tara voastra minunata, ca mi-ati oferit ajutor, adapost si asigurare medicala.

11.1 new features

Oracle Database 11.1 New Features : Summary [ID 466931.1]

How to fix Nologging Changes

Rolling a Standby Forward using an RMAN Incremental Backup To Fix The Nologging Changes [ID 958181.1]

Daca nu iti pasa de nimic vei trai mai mult

Paradoxul anti-agging : http://www.cristianmargarit.ro/2010/03/sanatate/paradoxul-anti-aging

Stresul: inamicul public numarul 1 : http://www.itex.ro/blog/consultanta-gratuita/inamicul-public-numarul-1-stresul/

Revigorant

Locul potrivit :

Crede si nu cerceta

"Trupul e o slugă bună, dar un stăpân hain"

Mi casa e su casa

Muncim degeaba

 

10.2.0.5 will be released in Q2 2010

Din nota :742060.1

Platform		10.2.0.4	10.2.0.5	11.1.0.7	11.2.0.1
Linux x86		22-FEB-2008	Q2CY2010	18-SEP-2008	1-SEP-2009
Linux x86-64		17-MAR-2008	Q2CY2010	18-SEP-2008	1-SEP-2009
Linux Itanium		24-SEP-2008	Q1CY2011	Not planned	Sched TBA
IBM Linux on POWER		9-JAN-2009 Patching for previous release ended 9-Apr-09	Q1CY2011	Not planned	Sched TBA
IBM Linux on System z		16-DEC-2008 Patching for previous release ended 16-Mar-09	Q4CY2010	Not planned	Q1CY2011
HP-UX PA-RISC (64-bit)		02-JUN-2008	Q4CY2010	11-Nov-2008	Q2CY2010
HP-UX Itanium		30-APR-2008	Q2CY2010	06-OCT-2008	22-DEC-2009
Sun Solaris SPARC (64-bit)		30-APR-2008	Q2CY2010	06-OCT-2008	6-Nov-2009
Sun Solaris x86-64 (64-bit)		13-NOV-2008	Q2CY2010	Not planned	25-Nov-2009
IBM AIX on POWER Systems		15-MAY-2008	Q2CY2010	06-OCT-2008	22-DEC-2009
Microsoft Windows (32-bit)		17-MAR-2008	Q3CY2010	10-OCT-2008	Q1CY2010
Microsoft Windows x64 (64-bit)		16-MAY-2008	Q3CY2010	13-NOV-2008	Q1CY2010
Microsoft Windows Itanium (64-bit)		2-FEB-2009 Patching for previous release ended 2-May-09	Q4CY2010	Not planned	Sched TBA
Apple Mac OS X (PowerPC)		Platform Obsolete	Platform Obsolete	Platform Obsolete	Platform Obsolete
Apple Mac OS X (Intel)		10-April-2009 Single Instance only	Sched TBA	Not planned	Sched TBA
HP Tru64 UNIX		20-FEB-2009 Patching for previous release ended 20-May-09	Q1CY2011	Platform Obsolete	Platform Obsolete
Sun Solaris x86 (32-bit)		14-Nov-2008 Last patch set for this platform	Platform Obsolete	Platform Obsolete	Platform Obsolete
HP OpenVMS Alpha		15-Dec-2008	Q3CY2011	Platform Obsolete	Platform Obsolete
HP OpenVMS Itanium		15-Dec-2008	Q3CY2011	Not planned	Q4CY2010
IBM z/OS on System z		Sched TBA	Sched TBA	Unsupported Platform (see Note:461234.1)	Unsupported Platform (see Note:461234.1)

Steinhardt

English translate
“Cînd un om reuşeşte să facă ceva ce i-a solicitat mult efort, în el începe să lucreze trufia. Cel ce slăbeşte, se uită cu dispreţ la graşi, iar cel ce s-a lăsat de fumat răsuceşte nasul dispreţuitor cînd altul se bălăceşte, încă, în viciul său.

Exadata2 - dimensiuni maxime

 

ORA-600 [kkxprpic8]

Versiune DB : 9.2.0.8

Symptoms: ORA-600 [kkxprpic8] when executing a query referencing PL/SQL objects. 

This is due to an invalid object being encountered.  Check the underlying trace file generated for any invalid objects and recompile them, e.g. search for "status=INVL", then look above for the object name:

dbms_sys_sql

http://oradbatips.blogspot.com/2010/01/tip-84-create-private-db-link-for-user.html

With dbms_sys_sql, you are able to parse and execute SQL as other users.

SQLPLUS hangs in linux

Sfat : upgrade la 10.2.0.4

Metalink note id : 361680.1

Cause
Bug.4930777/4612267 SQLPLUS HANGS ON MACHINES WITH LARGE UPTIME -- EVEN SQLPLUS HANGS

which says it happens when machine is up for more than 248 days.

Checked in truss output and uptime output exactly maching these symtoms...


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

1.Download one off patch from metalink for bug 4612267 ( 10.2.0.1 )
2. apply patch and rerun sqlplus.

OR
Reboot Server

RadioFranceInternational

Radio france international din linie de comanda, in linux :
mpg123 http://mp3.live.tv-radio.com/franceinter/all/franceinterhautdebit.mp3

k10temp

Pe o placa de baza noua  , linuxul a ramas acelasi Ubuntu 9.10 - the Karmic Koala .

Dupa upgrade-ul hardware, nu mai merge mbmon sau gkrellm , pentru citirea temperaturii de la procesor.

Solutia : modulul de kernel k10temp sau upgrade la kernel-ul 2.6.32 ( inca in teste )

Patch Set Update January 2010

Noi release-uri, incepand cu 12 IAN 2010:

• Database 11.1.0.7.2
• Database 10.2.0.4.3  Patch:9119284
• CRS 11.1.0.7.2 Patch:8705958
  
• CRS 10.2.0.4.3 not yet released
  
• Enterprise Manager Grid Control - OMS 10.2.0.5.2
• Enterprise Manager Grid Control - Agent 10.2.0.5.2

SMARTCTL && hddtemp

Pentru a vedea informatii despre starea hard disk-ului, pe linux sunt necesare doua pachete ( hddtemp si smartmontools ).

Comenzile sunt :
sudo smartctl -i -H -c /dev/sda
sudo hddtemp /dev/sda