Sunday, November 30, 2008

ORACLE DATABASE- ENABLE/DISABLE ALL TRIGGERS

ENABLE:
begin
for i in (select table_name from user_triggers
) LOOP
execute immediate 'alter table '||i.table_name||' enable all triggers '||'';
end loop;
end;


DISABLE:
begin
for i in (select table_name from user_triggers
) LOOP
execute immediate 'alter table '||i.table_name||' disable all triggers '||'';
end loop;
end;

Configuring Pidgin 2.5.2 for Google Apps

Google's instructions for configuring Pidgin with Google Talk have a broken link to instructions for using Google Apps with a corporate domain.

So here's how I configured Pidgin to work with a corporate Google Apps account:

1. Select "Add/Edit" from the Accounts menu, then press the "Add" button.

2. Fill in fields on the basic tab.

* Protocol: XMPP
* Screen name: johndoe
* Server: example.com (Your domain name here)
* Resource: Home
* Password: ********
* Local alias: John

3. Fill in fields on the advanced tab.
* [ ] Require SSL/TLS
* [ ] Force old (port 5223) SSL
* [ ] Allow plaintext over unencrypted streams
* Connect port: 5222
* Connect server: talk.google.com
* File transfer proxies : proxy.jabber.org
* Proxy type: Use Global Proxy Settings


4. Press "Save".

Posted by David Noble at 1:42 PM

Tags: im

source:http://collaboration.dnoble.org/2007/05/configuring-pidgin-for-google-apps.html

Monday, November 24, 2008

Remove temp files in Fedora

Just by a single command in console.

yum clean all

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.