Oracle Database Discussions

Hi,

I'm new to Oracle and I'm trying to install OracleXE on a Xen virtual machine and I've installation problems which I can't solve (it'seems Oracle doesn't start at all), because I receive this error in sqlplus:

Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

Are there konwn issues with this kind of environment (uname -r: 2.6.12.6-xen3_12.1_rhel4.1)? It seems it can connect to shared mem but everything is ok with shmem and other oracle configs. The only erorr I receive (scary!) is "USER: terminating instance due to error 27103" in bdump log

My info:

# env | grep ORA
ORACLE_SID=XE
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

# /etc/init.d/oracle-xe start
Starting Oracle Net Listener.
Starting Oracle Database 10g Express Edition Instance.

...but:


# ps -ef | grep ora
oracle 3424 1 0 06:51 ? 00:00:00 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER -inherit


# cat /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/rdbms/log/xe_ora_2196.trc
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
System name: Linux
Node name: dwarf04
Release: 2.6.12.6-xen3_12.1_rhel4.1
Version: #1 SMP Tue Jan 31 14:04:08 PST 2006
Machine: i686
Instance name: XE
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
Unix process pid: 2196, image: oracle@dwarf04

opiino: Attach failed! error=-1 ifvp=(nil)

Memory:
MemTotal: 356536 kB
SwapTotal: 1048568 kB

# ipcs -l

------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 1048576
max total shared memory (kbytes) = 8388608
min seg size (bytes) = 1

------ Semaphore Limits --------
max number of arrays = 128
max semaphores per array = 250
max semaphores system wide = 32000
max ops per semop call = 100
semaphore max value = 32767

------ Messages: Limits --------
max queues system wide = 16
max size of message (bytes) = 8192
default max size of queue (bytes) = 16384

# cat /usr/lib/oracle/xe/app/oracle/admin/XE/bdump/alert_XE.log

(latest log only)

Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =10
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
sessions = 49
sga_target = 146800640
control_files = /usr/lib/oracle/xe/oradata/XE/control.dbf
compatible = 10.2.0.1.0
db_recovery_file_dest = /usr/lib/oracle/xe/app/oracle/flash_recovery_area
db_recovery_file_dest_size= 10737418240
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
shared_servers = 4
job_queue_processes = 4
background_dump_dest = /usr/lib/oracle/xe/app/oracle/admin/XE/bdump
user_dump_dest = /usr/lib/oracle/xe/app/oracle/admin/XE/udump
core_dump_dest = /usr/lib/oracle/xe/app/oracle/admin/XE/cdump
audit_file_dest = /usr/lib/oracle/xe/app/oracle/admin/XE/adump
db_name = XE
open_cursors = 300
os_authent_prefix =
pga_aggregate_target = 25952256
USER: terminating instance due to error 27103
Instance terminated by USER, pid = 3603


The same installation steps on a "real" Linux box resulted in a successfull installation