Problems with oracle startup.

Installation and support for Oracle DB on CentOS.
Post Reply
Marcus
Posts: 1
Joined: 2006/07/31 02:19:53

Problems with oracle startup.

Post by Marcus » 2006/07/31 02:49:44

I've installed oracle from oracle-xe-univ-10.2.0.1-1.0.i386.rpm, and things 'seem' to start up okay... but then I try and connect to different apps and I hit some problems.

[quote]
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 31 12:37:14 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> select * from system;
SP2-0640: Not connected
SQL> connect;
Enter user-name: system
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
[/quote]

[quote]
(I've configured to use 9090, not 8080)
[root@glass ~]# wget localhost:9090/apex
--12:43:07-- http://localhost:9090/apex
=> `apex'
Resolving localhost... 127.0.0.1
Connecting to localhost|127.0.0.1|:9090... failed: Connection refused.
[/quote]

I've noticed the following in the file /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/log/glass/client/css.log, but I'm not sure if it's related

[quote]
[ OCRUTL][3070388448]u_set_comp_error: Parameter was NULL
[ OCRUTL][3070388448]u_set_ocr_error: Parameter was NULL
2006-07-31 12:12:45.698: [ OCROSD][3070388448]utgdv:2:ocr loc file cannot be opened
2006-07-31 12:12:45.698: [ OCROSD][3070388448]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
[ OCRUTL][3070388448]u_set_gbl_comp_error: Parameter was NULL
2006-07-31 12:12:45.698: [ OCRRAW][3070388448]proprinit: Could not open raw device
2006-07-31 12:12:45.698: [ default][3070388448]a_init:7!: Backend init unsuccessful : [33]
[ OCRUTL][3070388448]u_set_ocr_error: Parameter was NULL
2006-07-31 12:12:45.698: [ CSSCLNT][3070388448]clsssinit: error(33 ) in OCR initialization

[ OCRUTL][3070388448]u_set_ocr_error: Parameter was NULL
2006-07-31 12:34:54.045: [ OCROSD][3070388448]utgdv:2:ocr loc file cannot be opened
2006-07-31 12:34:54.045: [ OCROSD][3070388448]utopen:1: Couldnt find ocr,[ocrmirror] location in config file
[ OCRUTL][3070388448]u_set_gbl_comp_error: Parameter was NULL
2006-07-31 12:34:54.045: [ OCRRAW][3070388448]proprinit: Could not open raw device
2006-07-31 12:34:54.045: [ default][3070388448]a_init:7!: Backend init unsuccessful : [33]
[ OCRUTL][3070388448]u_set_ocr_error: Parameter was NULL
2006-07-31 12:34:54.045: [ CSSCLNT][3070388448]clsssinit: error(33 ) in OCR initialization

LEM stack 1: error [clsdfopen1] [

LEM stack 2: error [clsdfgenfullname] [sclsdgcwd]
[/quote]

I'm also seeing the following repeated in my /var/log/messages file

[quote]
Jul 31 12:34:54 glass su(pam_unix)[3965]: session opened for user oracle by root(uid=0)
Jul 31 12:34:54 glass su[3965]: Warning! Could not relabel /dev/pts/1 with user_u:object_r:initrc_devpts_t, not relabeling.Operation not permitted
Jul 31 12:34:55 glass su(pam_unix)[3965]: session closed for user oracle

[/quote]

Other than that, I'm not sure where to look; netstat shows the following
[quote]
tcp 0 0 127.0.0.1:1521 0.0.0.0:* LISTEN 3964/tnslsnr

unix 2 [ ACC ] STREAM LISTENING 12756 3964/tnslsnr /var/tmp/.oracle/sEXTPROC_FOR_XE
unix 2 [ ACC ] STREAM LISTENING 12758 3964/tnslsnr /var/tmp/.oracle/s#3964.1
unix 2 [ ACC ] STREAM LISTENING 12763 3964/tnslsnr /var/tmp/.oracle/s#3964.2
[/quote]

but nothing for 9090, and I'm not sure what other logs to check. Ideas?

Gopal
Posts: 5
Joined: 2006/07/22 13:57:25
Contact:

Problems with oracle startup.

Post by Gopal » 2006/08/05 04:59:33

ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

$export ORACLE_SID=ORCL1
[oracle@racdb1 ~]$ id
uid=175(oracle) gid=115(dba) groups=115(dba)
[oracle@racdb1 ~]$

$sqlplus / as sysdba
SQL>startup;

Post Reply

Return to “CentOS 4 - Oracle Installation and Support”