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.