menu
  • Register

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

0 votes
40 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

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 294 views
294 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 jwilliam 3.9k points
1 vote
1 answer 90 views
90 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 Martin K 6.6k points
0 votes
1 answer 7 views
7 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 Raphael Pacheco 4.9k points
1 vote
1 answer 47 views
47 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 Martin K 6.6k points
Dark theme