Thursday, November 20, 2008

RESOLVE ORA-00600 in Openbravo

Just change your Openbravo properties line in Tomcat,AppsOpenbravo,Config as following


bbdd.sessionConfig=ALTER SESSION SET NLS_DATE_FORMAT='DD-MM-YYYY' NLS_NUMERIC_CHARACTERS='.,' "_optimizer_filter_pred_pullup"=false

Saturday, November 15, 2008

Oracle SQL Developer problem - backspace / delete button not working - quick fix

Oracle SQL Developer problem - backspace / delete button not working - quick fix

November 15, 2008

Whenever I have to deal with Oracle 10g projects at work, Oracle SQL Developer always comes in handy.

However yesterday, the backspace and delete button inside the SQL query editor, all of a sudden, stopped working!
I tried restarting the Oracle SQL Developer, even restarting the computer, but the problem persisted.

I didn’t want to uninstall/re-install the application, so I went on to search the Oracle official forums.
Seems like other people had the exact same problem, and the solution was quite simple!

To resolve the problem you have to go to:
Tools -> Preferences -> Accelerators -> Load Preset -> Default -> OK


source--http://decoding.wordpress.com/2008/01/09/oracle-sql-developer-problem-backspace-delete-button-not-working-quick-fix/

Friday, November 14, 2008

UNINSTALL AND INSTALL MYSQL ON FEDORA 9

Uninstall MySQL on fedora

yum remove mysql

Install MySQL on fedora

1. Use yum to install both mysql command line tool and the server:yum -y install mysql mysql-server
2. Enable the MySQL service:/sbin/chkconfig mysqld on
3. Start the MySQL server:/sbin/service mysqld start
4. Set the MySQL root password:mysqladmin -u root password 'new-password'The quotes around the new password are required.

Saturday, September 6, 2008

ORA-12519 error

ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;