OraFAQ Forum: Server Administration » ORA-00205, ORA-01507

Home » RDBMS Server » Server Administration » ORA-00205, ORA-01507

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00205, ORA-01507 [message #203658]

Thu, 16 November 2006 00:05

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

Report message to a moderator

Re: ORA-00205, ORA-01507 [message #203666 is a reply to message #203658]

Thu, 16 November 2006 00:20

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.

Report message to a moderator

Re: ORA-00205, ORA-01507 [message #203680 is a reply to message #203666]

Thu, 16 November 2006 00:34

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

Report message to a moderator

Re: ORA-00205, ORA-01507 [message #203689 is a reply to message #203680]

Thu, 16 November 2006 01:02

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

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