Category Archives: Oracle

How to compile all Oracle DB 11gR2 Invalid Objects

Posted on September 19, 2012 by Ahmed Tawfik

Login to SQLPlus Run the following statement: “@?/rdbms/admin/utlrp.sql”

Posted in Oracle | Tagged , , , , , , | Leave a comment

How to query Oracle DB 11g for user account status

Posted on September 4, 2012 by Ahmed Tawfik

select USERNAME,ACCOUNT_STATUS from dba_users where USERNAME=’PUT_YOUR_USER_NAME_HERE’; Sample output: USERNAME                                    ACCOUNT_STATUS ——————————           ——————————– SADMIN           … Continue reading →

Posted in Oracle | Tagged , , , | Leave a comment

How to run the Oracle Data Pump Command as sysdba

Posted on August 25, 2012 by Ahmed Tawfik

If you have access to the Oracle DB server OS and user (e.g. via ssh or telnet), then you don’t need to have credentials for any DB user to be able to run the data pump commands, all you have … Continue reading →

Posted in Oracle | Tagged , , , , , | Leave a comment

Oracle TimesTen In-memory Database Quick Commands & Tips

Posted on August 6, 2012 by Ahmed Tawfik

Commands to Start TimesTen Service: ./ttdaemonadmin -start ./ttdaemonadmin -startserver Commands to Stop TimesTen Service: ./ttdaemonadmin -stopserver ./ttdaemonadmin -stop Command to get status of TimesTen DB: ./ttstatus Note: Important to notice is whether the Data is loaded into RAM or not … Continue reading →

Posted in Oracle | Tagged , , , , , | Leave a comment

Oracle DB Installation on AIX Tip

Posted on April 11, 2011 by Ahmed Tawfik

If you’re using Windows and running an X-server, such as XMing, and you’re willing to run the Oracle Installer, you might face the following warning: “Warning: Cannot convert string “-*-lucida-medium-r-*-*-*-*-*-*-*-*-iso8859-1″ to type FontStruct” Followed by a NullPointer Exception. This is … Continue reading →

Posted in Oracle | Tagged , , | Leave a comment