| ora 00205 [message #438844] |
Tue, 12 January 2010 09:44  |
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 #438900 is a reply to message #438845] |
Tue, 12 January 2010 22:37  |
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 #438903 is a reply to message #438902] |
Tue, 12 January 2010 23:25 |
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 #439677 is a reply to message #439660] |
Tue, 19 January 2010 01:09 |
 |
Michel Cadot
Messages: 68665
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 #439718 is a reply to message #439707] |
Tue, 19 January 2010 03:56 |
|
Michel Cadot
Messages: 68665
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
