menu
  • Register

Ora-00205: error in identifying control file, check alert log for more info

0 votes
60 views

Problem :

I am newly installing the Oracle XE database on my Ubuntu by following below steps:

Downloaded the latest rpm file for the Oracle XE and ran below commands to install my database:

sudo apt-get install alien
alien oracle-xe-11.2.0-1.0.x86_64.rpm
dpkg -i oracle-xe_11.2.0-2_amd64.deb

After that  I made sure that I have the permissions to /u01/ and also it is under the dba group.

Now when I am trying to start my database then I am facing below error

“Ora-00205: error in identifying control file, check alert log for more info”

●7 ●5 ●2
3,870 points

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

A file initSID.ora, where SID is your instance name (XE in your case), is your initialization parameter file (pfile) which Oracle always uses when instance starts to load the runtime settings specified by the database administrator.

For some reason your installation process was not successful, and you end up with a default pfile named the init.ora.

On startup the Oracle instance reads initialization parameters from your following files in a order of appearance

1.    spfileSID.ora

2.    spfile.ora

3.    initSID.ora

where your first two being binary counterparts of pfiles so they are called server parameter files (spfiles). And they should reside on a server side in contrast to your pfiles which can be on any side.

You can copy the init.ora to initXE.ora and set appropriate parameters just to check if your instance starts.

●9 ●7 ●4
38,600 points

Related questions

0 votes
2 answers 398 views
398 views
Ora-06502: pl/sql: numeric or value error: character string buffer too small
Problem : I tried my Oracle code in different ways, like by taking out a while loop or a if loop, but when I put both loops together (if and while), I always face below error at the end. ERROR: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 13 06502. 00000 -  "PL/SQL: numeric or value error%s"
asked Jan 22, 2020 jwilliam 3.9k points
1 vote
1 answer 171 views
171 views
Ora-02449: unique/primary keys in table referenced by foreign keys.
Problem : I am learning Oracle and trying to create and drop tables. If I try to drop my table it is always showing me below error: DROP TABLE SUBURB; DROP TABLE CITY; DROP TABLE STATE; Error at line 1: ORA-02449: unique/primary keys in table referenced ... already used by an existing object. I am unable to understand the above errors. Can someone guide me in fixing above Oracle related errors?
asked May 12, 2020 Martin K 6.6k points
0 votes
1 answer 20 views
20 views
Ora-24247: network access denied by access control list (acl).
Problem: I have good knowledge of Oracle. Currently I am trying my hand on Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production and also I am trying to use the ftp package (UTL_TCP). Here is the procedure which I have written: declare     l_conn ... setup of a ACL as mentioned by them but still I am unable to figure it out why my network access is denied after the login.
asked Aug 15, 2020 Raphael Pacheco 4.9k points
1 vote
1 answer 95 views
95 views
Ora-02270: no matching unique or primary key for this column-list.
Problem: I am trying to learn Oracle. I have created two tables their names are Table Employee and Table USER, here is the structure. CREATE TABLE Employee ( ID NUMBER NOT NULL , USERID NUMBER, CONSTRAINT B_PK PRIMARY KEY ( ID ) ENABLE ); CREATE TABLE USER ( ... above error but because of my elementary knowledge on Oracle I am unable to fix it. Kindly guide me in fixing above Oracle error.
asked May 29, 2020 Martin K 6.6k points
1 vote
1 answer 47 views
47 views
Ora 00119 invalid specification for system parameter local_listener.
Problem : I am very new to Oracle. I can very clearly see from the SQLPLUS startup output that my database is not starting up because in my init.ora file local_listener is setup as the LISTENER and now it says that it is unable to resolve that name. ... figure out my mistake. I need Oracle experts help to fix my bellow error: Ora 00119 invalid specification for system parameter local_listener .
asked Apr 22, 2020 stewart 4k points
0 votes
1 answer 15 views
15 views
ora-01033: oracle initialization or shutdown in progress
asked Sep 13, 2020 Daniel Anderson 4k points
0 votes
1 answer 7 views
7 views
ora-01427: single-row subquery returns more than one row
asked Sep 13, 2020 Daniel Anderson 4k points
0 votes
2 answers 260 views
260 views
java.sql.sqlrecoverableexception no more data to read from socket
Problem : I am facing bellow error java.sql.sqlrecoverableexception no more data to read from socket
asked Nov 5, 2019 peterlaw 6.9k points
Dark theme