menu
  • Register

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

0 votes
95 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
1 answer 17 views
17 views
ora 02049 timeout distributed transaction waiting for lock
Problem: ora 02049 timeout distributed transaction waiting for lock
asked Feb 19 Dan phillip 4.1k points
0 votes
1 answer 2 views
2 views
Ora-12560: tns:protocol adapter error
Problem: I Google[d] for this error ORA-12560: TNS:protocol adaptor error but not able to find the actual reason and how to solve this error ? Can anyone tell me a perfect solution to solve login problem.
asked Apr 3 ummesalma 22k points
0 votes
2 answers 518 views
518 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
0 votes
1 answer 2 views
2 views
Ora-01652: unable to extend temp segment by 128 in tablespace temp
Problem: Oracle gives the following error: SQL Error: ORA-01652: unable to extend temp segment by 128 in tablespace SYSTEM Any help would be appreciated.
asked Apr 3 ummesalma 22k points
1 vote
1 answer 272 views
272 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 2 views
2 views
Ora-00922: missing or invalid option
Problem: This is the error I am getting: SQL Error: ORA-00922: missing or invalid option
asked Apr 3 ummesalma 22k points
0 votes
1 answer 2 views
2 views
Ora-00923: from keyword not found where expected
Problem: I have been getting the error ORA-00923: FROM keyword not found where expected and do not know why, please help
asked Apr 3 ummesalma 22k points
0 votes
1 answer 2 views
2 views
Ora-00937: not a single-group group function
Problem: I'm trying to get a percentage of the item that are available in a certain area. Using my query, I get an error ORA-00937: not a single-group group function How do I fix this in Oracle?
asked Apr 3 ummesalma 22k points
0 votes
1 answer 3 views
3 views
Ora-00942: table or view does not exist
Problem: I use SQL developer and I made a connection to my database with the system user But when I try to proceed following I get the SQL Error ORA-00942 table or view does not exist.
asked Apr 3 ummesalma 22k points
0 votes
1 answer 2 views
2 views
Ora-00972: identifier is too long
Problem: I have a query and it returns the error ORA-00972 identifier is too long, is there any tip to make it work without making the alias shorter? Thanks
asked Apr 3 ummesalma 22k points
Dark theme