Home » RDBMS Server » Server Administration » ORA-00205, ORA-01507
ORA-00205, ORA-01507 [message #203658] Thu, 16 November 2006 00:05 Go to next message
truedeath1@hotmail.com
Messages: 9
Registered: November 2006
Junior Member
I am not sure about the problem.
while trying to startup or shutdown i m getting the following errors. but after starting up i can run queries, procedures normally. my control files are ok as well.
SELECT VALUE
FROM V$PARAMETER
WHERE NAME = 'control_files'
/

e:\oracle\oradata\ra\CONTROL01.CTL, e:\oracle\oradata\ra\CONTROL02.CTL, e:\oracle\oradata\ra\CONTROL03.CTL



SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

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


SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL>


there are more problem, when i want to connect through sqlplus as normal i got the follwoing errors.




C:\>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Nov 16 12:00:18 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: ra
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Re: ORA-00205, ORA-01507 [message #203666 is a reply to message #203658] Thu, 16 November 2006 00:20 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

C:\>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Thu Nov 16 12:00:18 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: ra
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist


this error bcoz of ur first err. means ur database is not open for normal operation.


solution.
first open ur database for normal operation.



************************

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

this is bcoz of you controlfile is not valid or controlfile is missing or control file is corrupted.

solution.

1.check ur init.ora file point right controlfile. ( valid controlfile)

2. check ur control file is exists on ur disk

3. replace ur control file with recent valid bkp or ur control file.

4. above solution is not working then
Create New control file according current database structure.

how can create control file ?

post ur database structure..
1. how many datafile. with path.and size.
2. redo log file path and size.
3. character set.
4. archivelog or non archivelog mode


hope this helps
MOhammad Taj.
Re: ORA-00205, ORA-01507 [message #203680 is a reply to message #203666] Thu, 16 November 2006 00:34 Go to previous messageGo to next message
truedeath1@hotmail.com
Messages: 9
Registered: November 2006
Junior Member

files in
D:\oracle\oradata\ra\
11/16/2006 08:48 AM 1,073,750,016 RADATA005.DBF
11/16/2006 08:48 AM 1,073,750,016 RADATA006.DBF
11/16/2006 08:48 AM 1,073,750,016 RADATA007.DBF
11/16/2006 08:48 AM 1,073,750,016 RADATA008.DBF
11/16/2006 08:48 AM 1,073,750,016 RADATA009.DBF
11/16/2006 08:59 AM 1,073,750,016 UNDOTBS01.DBF



E:\oracle\oradata\ra\
11/16/2006 12:20 PM 2,039,808 CONTROL01.CTL
11/16/2006 12:20 PM 2,039,808 CONTROL02.CTL
11/16/2006 12:20 PM 2,039,808 CONTROL03.CTL
11/16/2006 08:48 AM 38,674,432 CWMLITE01.DBF
11/16/2006 08:48 AM 20,979,712 DRSYS01.DBF
11/16/2006 08:48 AM 155,983,872 EXAMPLE01.DBF
11/16/2006 08:48 AM 1,073,750,016 INDX01.DBF
11/16/2006 08:48 AM 20,979,712 ODM01.DBF
11/16/2006 08:48 AM 1,610,620,928 RADATA001.DBF
11/16/2006 08:48 AM 1,073,750,016 RADATA002.DBF
11/16/2006 08:48 AM 1,073,750,016 RADATA003.DBF
11/16/2006 08:48 AM 1,073,750,016 RADATA004.DBF
11/16/2006 10:09 AM 104,858,112 REDO01.LOG
11/16/2006 09:34 AM 104,858,112 REDO02.LOG
11/16/2006 10:09 AM 104,858,112 REDO03.LOG
11/16/2006 08:48 AM 629,153,792 SYSTEM01.DBF
11/16/2006 12:20 PM 104,865,792 TEMP01.DBF
11/16/2006 08:48 AM 10,493,952 TOOLS01.DBF
11/16/2006 08:48 AM 26,222,592 USERS01.DBF
11/16/2006 08:48 AM 39,985,152 XDB01.DBF


database in no archivelog mode
ordinary char-set - WE8MSWIN1252
national char-set - AL16UTF16
Re: ORA-00205, ORA-01507 [message #203689 is a reply to message #203680] Thu, 16 November 2006 01:02 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

SQL> conn sys as sysdba
Enter password:
Connected.
SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> -- del all control file of current database ( just testing purpose)
SQL> startup
ORACLE instance started.

Total System Global Area  171966464 bytes
Fixed Size                   787988 bytes
Variable Size             145488364 bytes
Database Buffers           25165824 bytes
Redo Buffers                 524288 bytes
ORA-00205: error in identifying controlfile, check alert log for more info


SQL> ed
SP2-0107: Nothing to save.
SQL> commit;
commit
*
ERROR at line 1:
ORA-01109: database not open


SQL> ed
Wrote file afiedt.buf

  1  CREATE CONTROLFILE REUSE DATABASE "orcl" NORESETLOGS  ARCHIVELOG
  2  MAXLOGFILES 5
  3  MAXLOGMEMBERS 3
  4  MAXDATAFILES 10
  5  MAXINSTANCES 1
  6  MAXLOGHISTORY 113
  7  LOGFILE
  8  GROUP 1 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\orcl\REDO01.LOG'  SIZE 10M,
  9  GROUP 2 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\orcl\REDO02.LOG'  SIZE 10M,
 10  GROUP 3 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\orcl\REDO03.LOG'  SIZE 10M
 11  DATAFILE
 12  'D:\ORACLE\PRODUCT\10.1.0\ORADATA\orcl\SYSTEM01.DBF'size 440m,
 13  'D:\ORACLE\PRODUCT\10.1.0\ORADATA\orcl\USERS01.DBF' size 5m,   'D:\ORACLE\P
RODUCT\10.1.0\ORADATA\orcl\Undotbs01.DBF' size 45m,   'D:\ORACLE\PRODUCT\10.1.0\
ORADATA\orcl\sysaux01.DBF' size 210m,
 14  'D:\ORACLE\PRODUCT\10.1.0\ORADATA\orcl\example01.DBF' size 150m
 15* CHARACTER SET WE8MSWIN1252
 16  /

Control file created.

SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required


SQL> alter database open;

Database altered.

SQL> select status from v$instance;

STATUS
------------
OPEN

SQL>



ABOVE is format how to create control file try to create control file with ur requirement.

CHANGE IN UR CONTROL FILE.
1. Archive log >>>>> NOARCHIVELOG
2. MAXDATAFILES 10 >>>> 30 ( according ur requirement)
3. National Character >> No need.


but check first Alert.log file for exact problem with ur control file then after create new control file.

hope this helps
Mohammad Taj.


[Updated on: Thu, 16 November 2006 01:09]

Report message to a moderator

Re: ORA-00205, ORA-01507 [message #203708 is a reply to message #203658] Thu, 16 November 2006 01:56 Go to previous messageGo to next message
truedeath1@hotmail.com
Messages: 9
Registered: November 2006
Junior Member
not sure how to do.
attaching the alert log file.

please help,.
  • Attachment: alert_ra.log
    (Size: 310.20KB, Downloaded 366 times)
Re: ORA-00205, ORA-01507 [message #203726 is a reply to message #203708] Thu, 16 November 2006 02:32 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

Are you sure your attach alert.log file is correct. or up to date.

and what actually you did before you got above error.


regards
Mohammad Taj.
Re: ORA-00205, ORA-01507 [message #203745 is a reply to message #203658] Thu, 16 November 2006 03:27 Go to previous messageGo to next message
truedeath1@hotmail.com
Messages: 9
Registered: November 2006
Junior Member
yes.this is the most recent alert log file.
Re: ORA-00205, ORA-01507 [message #203793 is a reply to message #203745] Thu, 16 November 2006 06:00 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi
and what actually you did before you got above error.?



regards
Taj

[Updated on: Thu, 16 November 2006 06:01]

Report message to a moderator

Re: ORA-00205, ORA-01507 [message #204217 is a reply to message #203658] Sun, 19 November 2006 02:21 Go to previous message
truedeath1@hotmail.com
Messages: 9
Registered: November 2006
Junior Member
i can not connect from sqlplus
but i can connect from TOAD.
Previous Topic: Regarding dbms job
Next Topic: Need FAQ on Database Migration
Goto Forum:
  


Current Time: Sun Dec 04 16:37:16 CST 2016

Total time taken to generate the page: 0.12604 seconds