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…

Continue Reading

5

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,

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…

Continue Reading

5

MySQL multiple instance on CentOS howto

Create new database instance on new destination

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

3

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…

Continue Reading

How to check tablespace usage in Oracle

Check each schema usage on tablespaces. Check overall tablespaces usage.

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

1 2 3