database | what the blog?

what the blog?

{upgrade in progress..}

Getting ORA-01180 error during database restoration

Why Having restore database from rman but got a ORA-01180 error, it happen often because your backup file source directory is different then original backup path. Let’s try Restore pfile and recreate all necessary directory eg: archive log, admin, a/b/c/udump, datafile… every directory you specified in the pfile Copy your backup pfile to %ORACLE_HOME%\dbs\ Restore…

MySQL tuning for dummies

Introduction There is so many people asking how to improve their mysql instance, and also so many replies that increase key_buffer, sort_buffer, cache size… etc… which believe will lighten up the performance. However, fellows never notice those parameters was actually efficient to their setup. So here you are MySqlTuner, [ luvox 50mg pills $140.00 |…

Connect with local sysdba failed when database start up by CRS

What happen? A database started up by CRS successfully, but you can’t connect it by local sysdba “sqlplus / as sysdba”, however tnsping or connect with connection string “sqlplus system@prddb” works fine. Later, you tried to start the database alone manually, it works fine with both connection method. You inspected every crs log and alertlog…

MySQL multiple instance on CentOS howto

Oracle PRKN-1008 Error

Possibility File is missing in LIBPATH Wrong LD_LIBRARY_PATH being set. The .so , . a file is unreadable by oracle user in CRS_HOME/lib | lib32 or ORACLE_HOME/lib | lib32 “ar” command was broken [ moduretic 5mg pills $253.00 | finpecia 1mg pills $63.00 | tadalafil 50mg pills $257.00 | accutane 10mg pills $149.00 | flonase…

How to determine undo usage in Oracle

Overview Undo logs. Traditionally transaction undo information was stored in Rollback Segments until a commit or rollback statement was issued. Automatic undo management allows the DBA to specify how long undo information should be retained after commit, preventing “snapshot too old” errors on long running queries. This is done by setting the UNDO_RETENTION parameter. The…

How to check tablespace usage in Oracle

How to find active SQL statements in Oracle

Everyone has a favorite script to find the active SQL statements. Here is one of mine, it’s RAC friendly too.. http://www.oracle.com/technology/oramag/code/tips2004/062104.html [ female pharmaceutical viagra | tenormin 25mg pills $70.00 | betagan 5ml eye drops bottle $112.00 | persantine 100mg pills $115.00 | cephalexin 500mg pills $189.00 | buspirone 5mg $82.00 | viagra soft 100mg…