Home » RDBMS Server » Server Administration » ora 00205 (oracle 10g ,linux)
ora 00205 [message #438844] Tue, 12 January 2010 09:44 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi,please find my problem after creating database server in linux.


Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-00205: error in identifying controlfile, check alert log for more info


sql>shutdown immediate

ORA-01057 database not mounted


exception avilable in alert_orcl.log file

Starting background process QMNC
QMNC started with pid=13, OS id=2712
Thu Aug 10 16:44:00 2006
replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process MMON
Starting background process MMNL
MMON started with pid=15, OS id=3444
MMNL started with pid=16, OS id=3456

Completed: alter database open

db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.





please help me in fixing issue.

[Updated on: Tue, 12 January 2010 09:44]

Report message to a moderator

Re: ora 00205 [message #438845 is a reply to message #438844] Tue, 12 January 2010 09:49 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
>please find my problem after creating database server in linux.
There is no proof above is true.

You have errors & we have no idea exactly what you did ( or did not do).

>ORA-00205: error in identifying controlfile, check alert log for more info

Above needs to be resolved.

Not enough details to know the reason why.

post tail end of alert_SID.log file.

Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version
Re: ora 00205 [message #438900 is a reply to message #438845] Tue, 12 January 2010 22:37 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member



With the Partitioning, OLAP and Data Mining options
[[oracle@] ~]$ tail /opt/oracle/admin/orcl/bdump/alert_orcl.log;
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Tue Jan 12 05:40:07 2010
Completed: ALTER DATABASE OPEN
Tue Jan 12 10:00:16 2010
Thread 1 advanced to log sequence 3
Current log# 2 seq# 3 mem# 0: /opt/oracle/oradata/orcl/redo02.log
Tue Jan 12 19:34:51 2010
Thread 1 advanced to log sequence 4
Current log# 3 seq# 4 mem# 0: /opt/oracle/oradata/orcl/redo03.log



Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production


[Updated on: Tue, 12 January 2010 22:42]

Report message to a moderator

Re: ora 00205 [message #438902 is a reply to message #438900] Tue, 12 January 2010 23:17 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
nothing in your last post indicates any problem exists.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

It is very difficult to fix problems we can not see or when only clue is a standard error message without knowing exactly what you to produce the error
Re: ora 00205 [message #438903 is a reply to message #438902] Tue, 12 January 2010 23:25 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
Hi Blackswan,

startup is not happening and database is able to connect as sysdba.

but database is not mounting.
if give startup error as followed.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-00205: error in identifying controlfile, check alert log for more info

If try to give shutdown

sql>shutdown immediate

ORA-01057 database not mounted


not able to give startup command.

in alert_log file message is what in my previous message.
version also i explaine.wat else you want me for further information.please help me out in this?

[Updated on: Tue, 12 January 2010 23:25]

Report message to a moderator

Re: ora 00205 [message #438907 is a reply to message #438902] Wed, 13 January 2010 00:02 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
>startup is not happening and database is able to connect as sysdba.

STARTUP? I have not seen any evidence of STARTUP


>ORA-00205: error in identifying controlfile, check alert log for more info

You have posted no details to solve this mystery.

Re: ora 00205 [message #439660 is a reply to message #438844] Tue, 19 January 2010 00:31 Go to previous messageGo to next message
Bangla
Messages: 49
Registered: August 2008
Member
Hi, I got a complete solution from Arju's blog. Here is the link
http://arjudba.blogspot.com/2010/01/ora-00205-error-in-identifying-control.html
which might help you to solve this issue.
Re: ora 00205 [message #439677 is a reply to message #439660] Tue, 19 January 2010 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 63812
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Isn't it so strange that you share the same IP with Arju and it is your first post just after I told Arju to post the solution here instead of just posting a link to his blog in ALL his messages?
Seems to me you are Arju (or his avatar) still trying to spam for your blog.

Regards
Michel

[Updated on: Tue, 19 January 2010 01:10]

Report message to a moderator

Re: ora 00205 [message #439684 is a reply to message #439677] Tue, 19 January 2010 01:16 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
./fa/5263/0/

sriram Smile
Re: ora 00205 [message #439691 is a reply to message #439677] Tue, 19 January 2010 01:52 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Busted! ./fa/1604/0/
Re: ora 00205 [message #439707 is a reply to message #438844] Tue, 19 January 2010 03:18 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Dear Michael, Sorry someone notified me about this post.
Quote:
Seems to me you are Arju (or his avatar) still trying to spam for your blog.

You might not aware that in Bangladesh there is no static IP. Everyone is assigned dynamic IP. Don't know how you are thinking that Bangla and me are same.
Sorry to bother you.
Re: ora 00205 [message #439718 is a reply to message #439707] Tue, 19 January 2010 03:56 Go to previous message
Michel Cadot
Messages: 63812
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Don't know how you are thinking that Bangla and me are same.

Didn't my post explain it?
I add that Bangla posted regularly till 8 months ago, and made this post just after I warned you and you didn't post anything till this post. Maybe just a coincidence.

Regards
Michel
Previous Topic: DB Time Zone change (merged)
Next Topic: sys packages are invalid
Goto Forum:
  


Current Time: Fri Sep 30 07:13:34 CDT 2016

Total time taken to generate the page: 0.11636 seconds