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 …
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,
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 …
Create new database instance on new destination
Possibility File is missing in LIBPATH Wrong LD_LIBRARY_PATH being set. The .so , . a file is unreadable by oracle user in …
Overview Undo logs. Traditionally transaction undo information was stored in Rollback Segments until a commit or rollback statement was issued. Automatic undo …
Check each schema usage on tablespaces. Check overall tablespaces usage.
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