how to import a big mysql database backup in phpmyadmin

The first things to check (or ask your host provider to check) are the values of upload_max_filesizememory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP. One user also said that post_max_size and memory_limit need to be larger than upload_max_filesize.

ORA-20001 with DBMS_STATS dba_tab_statistics

You may encounter the error bellow https://forums.oracle.com/forums/thread.jspa?threadID=2296034
elect * from sys.dba_tab_statistics
ORA-20001: BIN$PV5XQQHLSAYJ0KPMEY1MHG==$0 is an invalid identifier
ORA-06512: in "SYS-DBMS_STATS", Line 2082
ORA-06512: in "SYS-DBMS_STATS", Line 2098
ORA-06512: in "SYS-DBMS_STATS", Line 26789

Soluition: purge dba_recyclebin;


Opatch version check failed

The error message :
The opatch minimum version  check for patch /oradata/patches_oracle_software/13696242_GI_DB/13696242/custom/server/13696242 failed  for /product/11gR2/db_1
The opatch minimum version  check for patch /oradata/patches_oracle_software/13696242_GI_DB/13696224 failed  for /product/11gR2/db_1
Opatch version check failed for oracle home  /product/11gR2/db_1
Opatch version  check failed
update the opatch version for the failed homes and retry

Cause : upgrade also the OPatch from the Oracle database software .

See also the oracle metalink below for other possible causes


ORA-24315 in PHP function oci_connect

ORA-24315 When Calling PHP Program [ID 1446995.1]


Cannot re-create tempfile .. the same name file exists

When you enable direct IO for an oracle database ( filesystemio_options = directio     or filesystemio_options = setall ) , you may encounter  this error in alert.log , when opening the database .

Cannot re-create tempfile  the same name file exists

how to format a block which is not used , in rman

Use RMAN to format corrupt data block which is not part of any object [ID 1459778.1]

PLS-00201: identifier 'SYS.DBMS_EXPORT_EXTENSION' must be declared

Schema Import Fails With Error PLS-201 Identifier SYS.DBMS_EXPORT_EXTENSION Must Be Declared [ID 445135.]

meniu logan

Meniu diagnosticare Bord Logan


temporary tablespace in ramfs

One good article : http://www.thegeekstuff.com/2008/11/overview-of-ramfs-and-tmpfs-on-linux/

The idea is to user your RAM in order to put there the temporary tablespace ( I suppose you have a box with a lot of GB for RAM ).

Sometimes , your database could have a bottleneck in your temporary tablespace ( in case of large sorts ) .
RAMFS is  a good filesystem which resides in your RAM memory. This means that the data in RAMFS get lost forever when there is a electrical problem  and your server is restarted or stopped .

This is not such a big problem in our case, because in OracleDB,  temporary tablespace  does not contain persistent information and is not subject to the recovery mechanism .

Read and write in your ramfs filesystem will be very fast.
In case your server is restarted, we can switch to the old temporary tablespace ( alter database default temporary tablespace temp; )

As root:

mkdir /ramfs
mount -t ramfs -o size=500m ramfs /ramfs

In your oracle database ( as user sys or system ) :
create temporary tablespace temp_ramfs tempfile '/ramfs/temp_ramfs.dbf' size 10M autoextend on next 10M maxsize 32G;

alter database default temporary tablespace temp_volatil ;


how to resolve a hang in database

Starting from 11g, there is a welcome change though – there’s a new V$WAIT_CHAINS view, which lists all the hangs it has detected, it’s RAC-aware and is accessible via plain SQL. No need to run oradebug anymore, assuming that you are able to log on to query that V$ view :-)


log files in OBIEE




what is a bubble ?


netapp cifs: file is in use by another user

BUG 530748 http://support.netapp.com/NOW/cgi-bin/bol?Type=Detail&Display=530748

 While editing a file, Microsoft office 2007 writes the content to a temporary 
 file and renames the temporary file to the original file name while saving. 
 When this happens the file's create time stamp will reflect the create 
 time stamp of the temproary file which would be different from the original 
 create time of the file. So after this happens, windows client will have to 
 send a CIFS request to restore the create time stamp to the original value. 
 However, this request will be sent only when the share permission is set to
 full control. In all other cases the create time will have the modified time.

Solutions :
1. Change the share permission to full control.
2. Upgrade to Office 2010.

Another workaround 
Increase  CIFS Max Multiplex



MRP Recovery Failed With ORA-19909 [ID 554358.1]



ORA-00843, ORA-00849 When Trying To Change SGA_TARGET With MEMORY_MAX_TARGET=0 Being Active [ID 1397761.1]


FRM-92095 Error When Running Forms Using JRE 7 (JRE 1.7) [ID 1348436.1]


how to download the latest version of Oracle Jinitiator

the download link https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=7410076&aru=10480495&release=3013100&plat_lang=2000P&patch_num_id=1005083&

OMS version not checked yet

11g Agent Upload Fails with "OMS version not checked Yet". [ID 1265052.1]

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.

Right After Install, the Grid Control Agent Generates ERROR-Agent is blocked. Blocked reason is: Agent is out-of-sync with repository [ID 1307816.1]

how to install Oracle GRID Control Agent in silent mode

Case Study: How to Install the Management Agent with the Silent Method on OEL 5.3 (x86_64) [ID 1068076.1]

how to deinstall oracle agent


Using Class of Secure Transport (COST) to Restrict Instance Registration [ID 1453883.1]