Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Christy H.Aug 30 2018 — edited Sep 4 2018

Hello,

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

SQL> connect / as sysdba

Connected 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 available

Process ID: 0

Session ID: 0 Serial number: 0

SQL> startup

ORA-01078: failure in processing system parameters

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

SQL> startup open

ORA-01078: failure in processing system parameters

LRM-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/

ll

total 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.

root@linux ~# updatedb

root@linux ~# locate alert_XE.log

root@linux ~#

also not able to find log file

lsnrctl start

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 30-AUG-2018 23:28:55

Copyright (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 - Production

System parameter file is /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora

Log messages written to /u01/app/oracle/product/11.2.0/xe/log/diag/tnslsnr/linux/listener/alert/log.xml

Error 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 permitted

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

please advise

Thanks in anticipation

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 2 2018
Added on Aug 30 2018
4 comments
7,509 views