Showing posts with label Oracle XE. Show all posts
Showing posts with label Oracle XE. Show all posts

Wednesday, 3 December 2008

oracle XE sessions and processes

I found that my locally installed Oracle XE runs out of available connections far too soon for a php app I'm running. This results in some weird gui behaviour: some frames just don't load. Fortunately I found a way to sort of makes it a little better:

sqlplus system@XE
show parameters sessions;
alter system set sessions=250
scope=spfile;
show parameters processes;
alter system set processes=200
scope=spfile;
sudo /etc/init.d/oracle-xe restart

http://www.markcallen.com/oracle/oracle-xe-tuning

Monday, 10 November 2008

nls_lang.sh: 114: [[: not found (Oracle XE problem on ubuntu)

I installed Oracle Express edition on Kubuntu again, and I got a familiar error again after running:
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found

the solution is to change (as root or sudo) the first line in the "nls_lang.sh" from
#! /bin/sh
to
#! /bin/bash

http://forums.oracle.com/forums/thread.jspa?messageID=2325040