Tag Archives: Oracle

Oracle TimesTen In-memory Database Quick Commands & Tips

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

Force install Oracle 10g Client on Redhat 5

Source: http://publib.boulder.ibm.com/infocenter/director/v6r1x/index.jsp?topic=/director.tbs_6.1/fqm0_r_tbs_oracle_10gR2_client_will_not_install.html

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

Oracle DB Installation on AIX Tip

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

Create a folder for importing an Oracle dump file

Generally speaking, in Oracle DB, for you to be able to import a dump file, you have to use a predefined list of directories in order to read the dump file from, don’t know why, but that’s how it goes. … Continue reading

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

Temporary Tablespace in Oracle 10g

Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. For example, if you join two large tables, and Oracle cannot do the sort in memory, space will be allocated in a temporary … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment