Oracle express doesn't start

Uncle Istvan · 2016-11-06 13:22:02

Hallo everyone, I'm trying to exercise on oracle express for a school project, but, as I try to connect from sql to oracle with the Username SYSTEM, I get this message:

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0.
No problem, I try to connect with 
$ sqlplus system as sysdba
I managed to connet, but as I give any comand, I get the same output
ERROR at line 1:                                                                                                                     
ORA-01034: ORACLE not available                                                                                                      
Process ID: 0
Session ID: 0 Serial number: 0

Could someone please help me?

Last edited by Uncle Istvan (2016-11-14 12:56:49)

eda2z · 2016-11-07 16:23:47

It's been several years since I had to deal with Oracle, but if you google the 2 error messages you should find many solutions. They usually have to do with either not starting the database or incorrect setting of the environment variables ORACLE_SID and/or ORACLE_HOME.

Uncle Istvan · 2016-11-08 20:37:06

I searched in several forums, but I haven't found a solution yet. My Oracle_HOME and SID are well setted, I think the problem is in the listener, that I can't startup

Uncle Istvan · 2016-11-08 20:38:04

$lsnrctl start

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 08-NOV-2016 21:37:35

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Starting /usr/lib/oracle/product/11.2.0/xe/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.2.0 - Production
NL-00280: error creating log stream /usr/lib/oracle/product/11.2.0/xe/network/log/listener.log
 NL-00278: cannot open log file
  SNL-00016: snlfohd: error opening file
   Linux Error: 13: Permission denied

Listener failed to start. See the error message(s) above...

Last edited by Uncle Istvan (2016-11-14 12:56:12)

Uncle Istvan · 2016-11-10 09:06:52

Ok, I resolve the listener problem, but I still have the error in the sqlplus comand:

ALTER USER HR IDENTIFIED BY hr ACCOUNT UNLOCK;          
ALTER USER HR IDENTIFIED BY hr ACCOUNT UNLOCK
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

Last edited by Uncle Istvan (2016-11-14 12:55:48)

eda2z · 2016-11-10 20:02:11

I have never used the Express edition, only the full database, but there are 2 files which need to be correct: tnsnames.ora and listener.ora. They contain data on your hostname, port, SID and service name. Try googling "oracle express listener.ora" and "oracle express tnsnames.ora". Also there are log files associated with Oracle which may contain more info.

Uncle Istvan · 2016-11-14 11:10:11

Here is my tnsnames.ora

# tnsnames.ora Network Configuration File:

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Litsch)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

Last edited by Uncle Istvan (2016-11-14 12:55:24)

Uncle Istvan · 2016-11-14 11:11:13

That's my listener.ora

# listener.ora Network Configuration File:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/lib/oracle/product/11.2.0/xe)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
      (ADDRESS = (PROTOCOL = TCP)(HOST = Litsch)(PORT = 1521))
    )
  )

DEFAULT_SERVICE_LISTENER = (XE)

Last edited by Uncle Istvan (2016-11-14 12:54:58)

Uncle Istvan · 2016-11-14 11:22:35

And that's my orcle_env.sh

export ORACLE_HOME=/usr/lib/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export PATH=$PATH:$ORACLE_HOME/bin

Last edited by Uncle Istvan (2016-11-14 12:52:42)

WorMzy · 2016-11-14 11:43:03

Please don't bump your topic like that; if you are the last person to post, use the edit button to add more information. Also, please use code tags.

eda2z · 2016-11-14 15:45:03

As long as your hostname is really Litsch then the only thing I see that is different from what I have done in the past is the EXTPROC_CONNECTION_DATA section in tnsnames.ora. We never used that and it was removed.

You may want to checkout the Oracle wiki here and see if anything there helps. I have never installed Oracle on Arch - only Red Hat, Fedora and Ubuntu.

Uncle Istvan · 2016-11-15 20:41:02

Is maybe a configuration problem? When I was trying to start the listener, I had to create and give the permission 777 to the directory /usr/lib/oracle/product/11.2.0/xe/network/log before the configuration. Have I to create any other directory that are not created in the oracle installation?

Arch Linux

#1 2016-11-06 13:22:02

Oracle express doesn't start

#2 2016-11-07 16:23:47

Re: Oracle express doesn't start

#3 2016-11-08 20:37:06

Re: Oracle express doesn't start

#4 2016-11-08 20:38:04

Re: Oracle express doesn't start

#5 2016-11-10 09:06:52

Re: Oracle express doesn't start

#6 2016-11-10 20:02:11

Re: Oracle express doesn't start

#7 2016-11-14 11:10:11

Re: Oracle express doesn't start

#8 2016-11-14 11:11:13

Re: Oracle express doesn't start

#9 2016-11-14 11:22:35

Re: Oracle express doesn't start

#10 2016-11-14 11:43:03

Re: Oracle express doesn't start

#11 2016-11-14 15:45:03

Re: Oracle express doesn't start

#12 2016-11-15 20:41:02

Re: Oracle express doesn't start

Board footer