2012-05-25

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;

2012-05-24

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

2012-05-23

2012-05-21

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

2012-05-10

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 ;



2012-05-09

2012-05-08

what is a bubble ?

http://www.businesspundit.com/10-most-bizarre-economic-bubbles-in-history/

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.
or
2. Upgrade to Office 2010.

Another workaround 
https://kb.netapp.com/support/index?page=content&id=3011249
Increase  CIFS Max Multiplex

2012-05-04

ORA-19909

MRP Recovery Failed With ORA-19909 [ID 554358.1]

2012-05-03

ORA-849

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

FRM-92095

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

2012-05-02

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 11.1.0.1.0 Management Agent with the Silent Method on OEL 5.3 (x86_64) [ID 1068076.1]

how to deinstall oracle agent


SECURE_REGISTER_LISTENER

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