How to install DRUPAL in ubuntu

1. Install Apache HTTP Server

sudo apt-get install apache2

2. Install MySQL Database Server
sudo apt-get install mysql-server-5.0 -d

3. Install PHP5 and Apache PHP5 module
sudo apt-get install php5 libapache2-mod-php5 -d

4. Install phpMyAdmin (Optional)
sudo apt-get install phpmyadmin

5. Install MySQL Administrator (Optional)
sudo apt-get install mysql-admin

6. Open php.ini
gksudo gedit /etc/php5/apache2/php.ini

7. Add the following line in the php.ini
extension=mysql.so

8. Open apache2.conf
gksudo gedit /etc/apache2/apache2.conf

9.Add the following line of code inside apache2.conf to setup phpmyadmin under Apache
Include /etc/phpmyadmin/apache.conf

10. Now restart Apache
sudo /etc/init.d/apache2 restart

11. Go To http://localhost/phpmyadmin
Login using your MySQL user name and password that you have set when installing MySQL server.Create a database for drupal.  In my case I created a database named “drupaldb”.

12. Install GD module for php5
sudo apt-get install php5-gd

13. Download the latest stable Drupal from here.
In my case I am using drupal-6.9.  Change to your default download directory.

14. Extract the drupal-6.9.tar.gz to your default web directory.

sudo tar -xvf drupal-6.9.tar.gz  -C /var/www/

15. Change to drupal sites default directory
cd  /var/www/drupal-6.9/sites/default

16. Make a copy of default.settings.php file as settings.php
sudo cp default.settings.php settings.php

17. Make the settings.php as writable
sudo chmod a+w settings.php

18. Make the sites/default directory as writable
sudo chmod a+w /var/www/drupal-6.9/sites/default

19. Now restart Apache
sudo /etc/init.d/apache2 restart.

How to Install PHP in Linux

yum install php-common php-gd php-mcrypt php-pear php-pecl-memcache php-mhash php-mysql php-xml

Check Db scheduler jobs

select owner,job_name,state from dba_scheduler_jobs where owner=’ACME’;

To remove blank lines : Linux command:

grep -v ‘^$’ 1_Original.log > temp.log

How to Lock/Unlock user Account in Oracle

# Log in oracle server

# sqlplus /as sysdba

# ALTER USER username ACCOUNT LOCK;

# ALTER USER username ACCOUNT UNLOCK;