Home » RDBMS Server » Server Administration » Unable to mount the database
Unable to mount the database [message #140836] Wed, 05 October 2005 17:41 Go to next message
nitin_228
Messages: 29
Registered: May 2005
Location: RICHMOND, VA
Junior Member

Can someone tell me why am i getting this error ORA-02236

SVRMGR> @crdbrwstg.sql
ORACLE instance started.
Total System Global Area 534495392 bytes
Fixed Size 73888 bytes
Variable Size 360079360 bytes
Database Buffers 163840000 bytes
Redo Buffers 10502144 bytes
CHARACTER SET WE8ISO8859P1
*
ORA-02236: invalid file name
ALTER DATABASE OPEN RESETLOGS
*
ORA-01507: database not mounted
ORA-01507: database not mounted
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 534495392 bytes
Fixed Size 73888 bytes
Variable Size 360079360 bytes
Database Buffers 163840000 bytes
Redo Buffers 10502144 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
update global_name set global_name='RWSTG.WORLD'
*
ORA-01109: database not open
commit
*
ORA-01109: database not open
alter user sys identified by manager
*
ORA-01109: database not open
alter user system identified by manager
*
ORA-01109: database not open
alter database datafile '/develop10/rwstg/rwstgdata/ghrprod_sunhr_rw_data.dbf' resize 700M
*
ORA-01507: database not mounted
alter database datafile '/develop10/rwstg/rwstgdata/ghrprod_sunhr_rw_index.dbf' resize 700M
*
ORA-01507: database not mounted
commit
*
ORA-01109: database not open


Thanks,
Nitin

Report message to a moderator

Re: Unable to mount the database [message #140877 is a reply to message #140836] Thu, 06 October 2005 00:20 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
nitin_228 wrote on Thu, 06 October 2005 04:11



Total System Global Area 534495392 bytes
Fixed Size 73888 bytes
Variable Size 360079360 bytes
Database Buffers 163840000 bytes
Redo Buffers 10502144 bytes

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




Look its self explanatory , I think Oracle is unable to find control file at the location specified in the pfile , so better to read the alert log and make control file available at the specified location.


regards,
tarun

Report message to a moderator

Previous Topic: installation error 9i
Next Topic: inactive connection
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 10:45:07 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.