dbname:/u01/app/oracle/product/10.2.0/db_1:N

to something like

dbname:/u01/app/oracle/product/10.2.0/db_1:Y

Copy&paste the boot script code that follows into /etc/init.d/dbora (the file dbora doesn’t exists, so create it) and modify the bold values to reflect your installation:

#!/bin/sh
# description: Oracle auto start-stop script.
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.

ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME PATH

ORA_HOME=/u01/app/oracle/product/10.2.0/db_1
ORA_OWNER=oracle

if [ ! -f $ORA_HOME/bin/dbstart ]
then
    echo "Oracle startup: cannot start"
    exit
fi

case "$1" in
    'start')
        # Start the Oracle databases:
        # The following command assumes that the oracle login
        # will not prompt the user for any values
        su $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME"
        ;;
    'stop')
        # Stop the Oracle databases:
        # The following command assumes that the oracle login
        # will not prompt the user for any values
        su $ORA_OWNER -c "$ORA_HOME/bin/dbshut $ORA_HOME"
        ;;
esac

Assign proper script privileges:

chmod 750 /etc/init.d/dbora

Create the symbolic links related to boot runlevels [since I'm a long-time-Slackware-user and pretty new to Ubuntu, I'm not well versed about Ubuntu boot system so feel free to correct me (the comments are at the end of the post)]:

ln -s /etc/init.d/dbora /etc/rc0.d/k01dbora
ln -s /etc/init.d/dbora /etc/rc1.d/k01dbora
ln -s /etc/init.d/dbora /etc/rc2.d/S99dbora
ln -s /etc/init.d/dbora /etc/rc3.d/S99dbora
ln -s /etc/init.d/dbora /etc/rc4.d/S99dbora

at the end you should have something like this:

lrwxrwxrwx 1 root root   17 2008-07-16 14:16 /etc/rc0.d/k01dbora -> /etc/init.d/dbora
lrwxrwxrwx 1 root root   17 2008-07-16 14:16 /etc/rc1.d/k01dbora -> /etc/init.d/dbora
lrwxrwxrwx 1 root root   17 2008-07-16 14:16 /etc/rc2.d/S99dbora -> /etc/init.d/dbora
lrwxrwxrwx 1 root root   17 2008-07-16 14:16 /etc/rc3.d/S99dbora -> /etc/init.d/dbora
lrwxrwxrwx 1 root root   17 2008-07-16 14:16 /etc/rc4.d/S99dbora -> /etc/init.d/dbora

Release 2 bug: inside /u01/app/oracle/product/10.2.0/db_1/bin/dbstart there is a bug that will prevent the listener to start (Failed to auto-start Oracle Net Listener using /ade/vikrkuma_new/oracle/bin/tnslsnr); to solve change line 78 from

ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle/bin/tnslsnr

to

ORACLE_HOME_LISTNER=$ORACLE_HOME

(in this article a modified version of the script at http://www.oracle-base.com/articles/linux/AutomatingDatabaseStartupAndShutdownOnLinux.php)

Here is a simple howto on how to have an auto incremented numeric column value on Oracle Database using a sequence and a trigger (if you find some errors please use the comments):

Tested on: Oracle Database 10g Enterprise Edition

Precondition: a numeric type (INTEGER is ok) column in a table (in this example the schema is PROVA01 and the table is UTENTI with ID as column).

1. Log in Oracle Enterprise Manager (probably http://servername:1158/em/) as user with proper privileges (SYS as SYSDBA will work);
2. Go to “Administration”;
3. Under “Schemas > Database Objects” open “Sequence”;
4. Select proper schema (in this how to is PROVA01, the table is UTENTI and the field is ID);
5. Create a new sequence by filling:
   1. Name: choose a name, something like UTENTI_ID_SEQ should be fine;
   2. Schema: select PROVA01;
   3. Max value: no limit;
   4. Min value: enter value 1;
   5. Increment: 1;
   6. Start: 1;
   7. De-select “Use Cache”
   8. When done click “OK” button (the screenshot is in italian)
      
6. Return back to administration page and go to “Programs > Triggers” and create a new trigger:
   1. Name: TRIGGER_SEQ_UTENTI is a good choice;
   2. Schema: PROVA01;
   3. Select “Replace if exists”
   4. Trigger body (in bold values you may change):

      BEGIN
      SELECT UTENTI_ID_SEQ.NEXTVAL
      INTO   :NEW.ID
      FROM   DUAL;
      END UTENTE_SEQ_TRIGGER;

   5. Go to “Event” tab and configure the trigger:
      1. “Execute the trigger” on Table;
      2. Table: in this case PROVA01.UTENTI;
      3. Start trigger: before;
      4. Event: INSERT;
   6. Go to “Advanced” and select “FOR EACH ROW”;
7. Save the trigger and, if any, check out the errors.

Test the sequence and trigger by inserting a new table row, the ID value will be auto-inserted (and incremented).

The data gathered by the 2007 Survey spotlighted the identikit of the “person who make web sites”: male (82,8%) white (84,6%), aged between 25 and 32 years (43,6%), from United States (48,1%) and developer (25,3%).

The full findings are available here http://www.alistapart.com/articles/2007surveyresults.

This script simply loads the MeSH terms (the value of “/DescriptorRecordSet > DescriptorRecord > DescriptorName > String” XML tag) that can be found in the MeSH XML formatted version of the vocabulay (http://www.nlm.nih.gov/mesh/filelist.html) into a MySQL relational database.

Download the script or read it:

/**
 * @author Arjuna Del Toso
 * @url http://arjuna.deltoso.net/
 * 
 * @FAQ: what the hell is this?

 * A simple, very simple, program to load the MESH Terms to a MySQL database
 * 
 * @USAGE
 * 1-configure some stuff in the code ("//: CHANGE A VALUE HERE" string is a placeholder for what to change);
 * 2-install the required packages (jdbc connector [http://www.mysql.com/products/connector/j/] and dom4j [http://www.dom4j.org/]);
 * 3-compile it ($javac mesh2database.java);

 * 4-put the MESH Descriptor XML file and the MESH Descriptor DTD file in the current directory;
 * 5-run the program ($java mesh2database) and wait;
 * 6-enjoy the 20.000+ records inserted in your database.
 * 
 */

// Some imports in order to run this program; you need

// the jdbc driver for connecting to MySQL database
// and the dom4j package for XML manipulation
import java.io.File;
import org.dom4j.Document;
import org.dom4j.DocumentException;

import org.dom4j.Element;
import org.dom4j.ElementHandler;
import org.dom4j.ElementPath;
import org.dom4j.io.SAXReader;

import java.sql.*;

// a very fanciful name
public class mesh2database {

	// all work done here
	public static void main(String[] args) throws SQLException {

		// load the jdbc driver

		try {
			Class.forName("com.mysql.jdbc.Driver").newInstance();
		} catch (InstantiationException e1) {
		} catch (IllegalAccessException e1) {
		} catch (ClassNotFoundException e1) {}

		// the connection to mysql db

//: CHANGE A VALUE HERE
//: set your database values
		final Connection con = DriverManager.getConnection("jdbc:mysql://localhost/table", "user", "password");
		// a preparedStatement in the hope to improve speed

//: CHANGE A VALUE HERE
//: configure to match your database schema
		final PreparedStatement s = con.prepareStatement("INSERT IGNORE INTO `table`.`mesh` (`id` , `mesh` ) VALUES (NULL , ?)");

		// the MESH Descriptors XML file,
		// can be found at http://www.nlm.nih.gov/mesh/

//: CHANGE A VALUE HERE
//: insert the path to your mesh file
		File file = new File("desc2007");

		// enable pruning mode to call me back as each node is complete

		SAXReader reader = new SAXReader(false);

		reader.addHandler( "/DescriptorRecordSet/DescriptorRecord/DescriptorName/String",
				new ElementHandler() {
			public void onStart(ElementPath path) {}
			public void onEnd(ElementPath path) {
				// process a single element

				Element meshDescriptorValue = path.getCurrent();
				Element descname = meshDescriptorValue.getParent();
				Element descrecord = descname.getParent();

				// remove .toLowerCase() if you are Case Sensitive  

				String meshHeading = meshDescriptorValue.getText().toLowerCase();

				// i just don't want something like
				// "DNA Degradation, Apoptotic"
				// as single record in my database
				if(!meshHeading.contains(",")){

					// simple debug code (outputs the MESH DESCRIPTORS) 

					System.out.println(meshHeading);

					// the database INSERTs executed here
					try {
						// insert current value in the preparedStatement
						s.setString(1, meshHeading);
						// execute the statement

						s.executeUpdate();
					} catch (SQLException e1) {}
				}
				// prune the tree
				descrecord.detach();
			}
		}
		);

		// just reading the file will do all the work
		try {
			Document document = reader.read(file);
		} catch (DocumentException e) {}

		// closing statement and connection

		s.close();
		con.close();
	}

}

In order to run this script you need the Java compiler, the MeSH XML file, a MySQL installation and two java libraries: MySQL Connector/J and dom4j.

So I use this basic solution, note that I update drupal using cvs method so I hide also the CVS directories. Put this code in your .htaccess file after RewriteEngine on inside the IfModule mod_rewrite.c section:

RewriteRule    ^(.*)CHANGELOG\.txt$  http://www.yoursite.net [R,L]
RewriteRule    ^(.*)INSTALL\.mysql\.txt$  http://www.yoursite.net [R,L]
RewriteRule    ^(.*)INSTALL\.txt$  http://www.yoursite.net [R,L]
RewriteRule    ^(.*)MAINTAINERS\.txt$  http://www.yoursite.net [R,L]
RewriteRule    ^(.*)CVS$  http://www.yoursite.net [R,L]
RewriteRule    ^(.*)CVS/$  http://www.yoursite.net [R,L]
RewriteRule    ^(.*)INSTALL\.pgsql\.txt$  http://www.yoursite.net [R,L]
RewriteRule    ^(.*)LICENSE\.txt$  http://www.yoursite.net [R,L]
RewriteRule    ^(.*)UPGRADE\.txt$  http://www.yoursite.net [R,L]

Modify to fix your needs and save the .htaccess file.

F.A.Q.

1 - Why you use tons of rules for every file and not something like ^(.*)\.txt$ ?

Mhh, I really don’t remember, maybe I have some text file I want to be accessible in the site.

2 - Why not just removing that text files?

I think that CVS imports them on every update, so you have to remove the files many times.