2010-12-28

h

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

2010-12-21

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

2010-12-20

'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]


2010-12-15

Oracle Database 11g - Architecture Diagram

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

2010-12-14

kxtotolc_lobopt

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

2010-12-13

PARALLEL_MAX_SERVERS

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

2010-12-10

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]


 

2010-12-08

kksfbc child completion

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

 

2010-11-28

raza

O raza de lumina

2010-11-26

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)

2010-11-23

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 )

2010-11-20

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  
 

2010-11-16

EMCLI ( for GRID 11G)

Enterprise Manager Command Line Interface Download

2010-11-11

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.


2010-11-10

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/

2010-11-08

ORA-30012

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

2010-10-31

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


2010-10-29

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]

2010-10-26

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]


2010-10-19

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.

2010-10-15

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

2010-10-07

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ă.


2010-10-01

utl_mail how to send emails from oracle

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

2010-09-29

let's do it romania - ValiU

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


2010-09-27

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

2010-09-26

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"



2010-09-20

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

2010-09-17

tdposync

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

2010-09-14

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.

2010-09-10

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

2010-09-09

2010-09-07

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]
 

2010-09-02

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.

2010-09-01

Oracle Data Masking

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

2010-08-31

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.

2010-08-30

ORA-00569: Failed to acquire global enqueue

Error on rac : Error 569 occured while spilling buffered messages


2010-08-27

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"  

2010-08-26

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]


2010-08-24

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

2010-08-19

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]

2010-08-18

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]


2010-08-17

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]

2010-08-11

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]

2010-08-08

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]

2010-08-04

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>

2010-08-02

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]

2010-08-01

2010-07-31

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…

2010-07-23

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

2010-07-22

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

2010-07-21

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]

2010-07-14

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

2010-07-09

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

2010-07-08

"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!"

2010-07-05

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 

2010-07-02

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:

2010-06-14

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. 

2010-06-08

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).

2010-06-02

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..

2010-05-25

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

2010-05-13

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.



2010-05-11

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. 


2010-05-10

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.

2010-05-06

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

2010-05-04

FUNCTION BASED INDEX

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


2010-05-03

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


2010-04-29

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.

2010-04-27

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


2010-04-15

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


2010-04-14

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.

2010-04-13

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

2010-04-12

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

2010-04-01

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 

 




2010-03-31

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.

2010-03-25

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.

2010-03-23

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

2010-03-22

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;
}


2010-03-11

Oscar si Tanti Roz

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

2010-03-09

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.

2010-03-05

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]

2010-02-27

Revigorant

Locul potrivit :

2010-02-25

Crede si nu cerceta

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

Mi casa e su casa

Muncim degeaba

 

2010-02-24

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.

2010-02-09

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.

2010-02-06

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

2010-01-21

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

2010-01-17

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