Oracle XE is an excellent starter database, but under normal loads the out of the box parameters need to be increased. Database Sessions Increase the number of sessions that the database can handle at one time. This will allow for more users to access the database. sqlplus /nolog SQL> show parameters sessions SQL> alter system […]
Author Archives: markcallen
Starting Oracle Enterprise Manager
For the oracle database Enterprise Manager (EM) runs on port 1158. But it needs to be started by itself. Linux Login as oracle and run: $ORACLE_HOME/bin/emctl start dbconsole On some systems a xserver session needs to be running for the graphs to be created correctly. The best solution for this is to run vncserver on […]
Oracle XE Backup
After installing Oracle XE you should setup backups. Backups for XE For Oracle XE there is ready a backup script that uses Oracle’s RMAN. Setup Archive Log Mode After installing the database change it to archivelog mode: [oracle@localhost ~]$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 – Production on Sun May 25 01:28:00 2008 Copyright (c) […]
Checking for a User in OID
Test to see if a user is already in OID The following java code checks to see if there is a user in OID, returning true if they are there. import oracle.ldap.util.*; import oracle.ldap.util.jndi.*; import java.io.*; import java.util.*; import javax.naming.*; import javax.naming.directory.*; public class Application1 { InitialDirContext ctx; public Application1() throws NamingException { […]
Creating a new linux file system
Creating a ext3 file system on a new USB disk. Partition Table # /sbin/fdisk /dev/sdc The number of cylinders for this disk is set to 60801. There is nothing wrong with that, but this is larger than 1024, and could in certain setups cause problems with: 1) software that runs at boot time (e.g., old […]
Copying directories between file systems
Copying files from one directory to another using find and cpio. cd /old_file_system/ find . -print -depth | cpio -pamVd /new_file_system/
Getting https pages with Perl
Perl’s LWP package is a great way to get web pages and display the content of the resulting http header. Out of the box it does not support https, the following describes how to configure perl to access https pages. Configure CPAN The first thing to do is to setup perl to manage modules using […]
Using Java Web Start with Opera
Out of the box the Opera web browser is not setup to run jnlp files, therefore java webstart will not run properly. To fix this a new mime-type needs to be added to the browser. Follow instructions at: http://www.opera.com/support/search/supsearch.dml?index=470
Adding LDAP Authentication to a Site
Add the following entry to the VirtualHost <Directory “/var/www/html”> order allow,deny allow from all AuthName “Staff only” AuthType Basic AuthLDAPURL ldap://localhost/dc=example,dc=com require valid-user </Directory>
Security failure. Data decryption error. When using IE on a Mac
On Mac OS X when opening a new IE window from a site running under https there is no content in the window and the following error message is displayed: This can be correct by changing the SSLSessionCache in the Apache httpd.conf file. The error shows up when SSLSessionCache is set to none. If it […]