Forum Stats

  • 3,767,860 Users
  • 2,252,726 Discussions
  • 7,874,367 Comments

Discussions

LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora'

Christy H.
Christy H. Member Posts: 409 Blue Ribbon

Hello,

My OS is Ubuntu 16.04 and oracle 11gR2 just newly installed.

SQL> connect / as sysdbaConnected to an idle instance.SQL> ALTER USER sys IDENTIFIED BY "password";ALTER USER sys IDENTIFIED BY "passwords"*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0SQL> startupORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora'SQL> startup openORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora'SQL> 

Ubuntu command line:

cd /u01/app/oracle/product/11.2.0/xe/dbs/lltotal 4.0K-rwx------ 1 root root 559 Aug 30 22:27 initXE_DEFAULT.ora*

`/u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora` file not exists.

[email protected] ~# [email protected] ~# locate [email protected] ~# 

also not able to find log file

lsnrctl startLSNRCTL for Linux: Version 11.2.0.2.0 - Production on 30-AUG-2018 23:28:55Copyright (c) 1991, 2011, Oracle.  All rights reserved.Starting /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.2.0 - ProductionSystem parameter file is /u01/app/oracle/product/11.2.0/xe/network/admin/listener.oraLog messages written to /u01/app/oracle/product/11.2.0/xe/log/diag/tnslsnr/linux/listener/alert/log.xmlError listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))TNS-12555: TNS:permission denied TNS-12560: TNS:protocol adapter error  TNS-00525: Insufficient privilege for operation   Linux Error: 1: Operation not permittedListener failed to start. See the error message(s) above...

please advise

Thanks in anticipation

clcarter

Answers

  • Markus Flechtner
    Markus Flechtner Member Posts: 501 Bronze Trophy
    edited Aug 30, 2018 5:58PM

    Did you run "sudo /etc/init.d/oracle-xe configure" to configure database and listener after you installed the software?

    (BTW, Ubuntu is not supported for XE, but there are instructions available on the net - did you use one of them, if yes, which?

    HTH

    Markus

    clcarter
  • Christy H.
    Christy H. Member Posts: 409 Blue Ribbon
    edited Aug 30, 2018 6:08PM
    Did you run "sudo /etc/init.d/oracle-xe configure" to configure database and listener after you installed the software?

    sudo /etc/init.d/oracle-xe configure

    Oracle Database 11g Express Edition is already configured

    (BTW, Ubuntu is not supported for XE, but there are instructions available on the net - did you use one of them, if yes, which?

    https://github.com/pwojnowski/oracle-xe-ubuntu.git

    clcarter
  • Markus Flechtner
    Markus Flechtner Member Posts: 501 Bronze Trophy
    edited Aug 31, 2018 4:32AM

    Please post the output of the " env |grep -i oracle" command.

    It should contains lines like:

    LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/xe/lib:

    ORACLE_SID=XE

    ORACLE_BASE=/u01/app/oracle

    PATH=/u01/app/oracle/product/11.2.0/xe/bin:/u01/app/oracle/product/11.2.0/xe/ctx/bin:/usr/bin:/usr/local/bin:/sbin:/usr/sbin

    ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe

    Regards

    Markus

    clcarter
  • clcarter
    clcarter Member Posts: 1,406
    edited Sep 4, 2018 10:27AM

    >> initXE_DEFAULT.ora != initXE.ora

    Try a startup with that _DEFAULT... file, if that works make an spfile.

      sudo su - oracle ... [+profile for OH, sid, ...]

      sqlplus /nolog ... conn /as sysdba;

      startup pfile='/u01/app/oracle/product/11.2.0/xe/dbs/initXE_DEFAULT.ora' ;

      ... -- startup OK?

      create spfile from pfile='/u01/app/oracle/product/11.2.0/xe/dbs/initXE_DEFAULT.ora' ;

      shutdown immediate ;

      startup ;

    And the lsnrctl start should be done via the oracle login, but its not needed until a remote client wants a connection. No listener, no remote sessions. First things first, the listener and instance have to be started before getting that far ...

This discussion has been closed.