2012-05-28
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_filesize, memory_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
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
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
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.]
2012-05-17
how to tune performance in oracle sun zfs storage 7420
Sun Storage 7000 Unified Storage System: Configuration and tuning for NFS performance [ID 1213725.1]
2012-05-14
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:
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
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 :-)
http://blog.tanelpoder.com/2012/05/08/oradebug-hanganalyze-with-a-prelim-connection-and-error-can-not-perform-hang-analysis-dump-without-a-process-state-object-and-a-session-state-object/?utm_source=rss&utm_medium=rss&utm_campaign=oradebug-hanganalyze-with-a-prelim-connection-and-error-can-not-perform-hang-analysis-dump-without-a-process-state-object-and-a-session-state-object
http://blog.tanelpoder.com/2012/05/08/oradebug-hanganalyze-with-a-prelim-connection-and-error-can-not-perform-hang-analysis-dump-without-a-process-state-object-and-a-session-state-object/?utm_source=rss&utm_medium=rss&utm_campaign=oradebug-hanganalyze-with-a-prelim-connection-and-error-can-not-perform-hang-analysis-dump-without-a-process-state-object-and-a-session-state-object
2012-05-08
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
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]
2012-05-02
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]
SECURE_REGISTER_LISTENER
Using Class of Secure Transport (COST) to Restrict Instance Registration [ID 1453883.1]