Home » RDBMS Server » Server Administration » error in identifying file 'C:\oracle\product\10.2.0\db_1/dbs/spfilegrasim.ora' (Oracle,10g,windows xp)
error in identifying file 'C:\oracle\product\10.2.0\db_1/dbs/spfilegrasim.ora' [message #397328] Fri, 10 April 2009 01:48 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

I have shutdown database and while start the database i am getting the ORA-01565: error in identifying file 'C:\oracle\product\10.2.0\db_1/dbs/spfilegrasim.ora' file.
after i have start the database with pfile option it works fine.

commands:

startup pfile=C:\Oracle\product\10.2.0\admin\grasim\pfile\init.ora

my scripts are present here

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount

ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file 'C:\oracle\product\10.2.0\db_1/dbs/spfilegrasim.ora'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 1091)
SQL> startup pfile=C:\Oracle\product\10.2.0\admin\grasim\pfile\init.ora
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 167775108 bytes
Database Buffers 436207616 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.
SQL>

please give me comments why it occurs.
Re: error in identifying file 'C:\oracle\product\10.2.0\db_1/dbs/spfilegrasim.ora' [message #397331 is a reply to message #397328] Fri, 10 April 2009 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Follow the guidelines.

create spfile from pfile;

Regards
Michel

[Updated on: Fri, 10 April 2009 01:56]

Report message to a moderator

Re: error in identifying file 'C:\oracle\product\10.2.0\db_1/dbs/spfilegrasim.ora' [message #397338 is a reply to message #397328] Fri, 10 April 2009 02:37 Go to previous messageGo to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
i did this commands after that i am getting below error

ORA-01565: error in identifying file 'C:\oracle\product\10.2.0\db_1/dbs/spfilegrasim.ora'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 1091)


please give an instuctions.
Re: error in identifying file 'C:\oracle\product\10.2.0\db_1/dbs/spfilegrasim.ora' [message #397339 is a reply to message #397338] Fri, 10 April 2009 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
create spfile from pfile;

Regards
Michel
Re: error in identifying file 'C:\oracle\product\10.2.0\db_1/dbs/spfilegrasim.ora' [message #397525 is a reply to message #397328] Sat, 11 April 2009 19:50 Go to previous message
Vivek.k.thakur
Messages: 30
Registered: December 2007
Location: DELHI, INDIA
Member

Hi you are giving wrong path 'C:\oracle\product\10.2.0\db_1/dbs/spfilegrasim.ora'

use 'C:\oracle\product\10.2.0\db_1\dbs\spfilegrasim.ora'

And I also think there should be DATABASE instead of DBS because it is a windows machine.

If you are right then use following command

create spfile='C:\oracle\product\10.2.0\db_1\dbs\spfilegrasim.ora' FROM pfile='C:\Oracle\product\10.2.0\admin\grasim\pfile\init.ora';

OR

create spfile='C:\oracle\product\10.2.0\db_1\database\spfilegrasim.ora' FROM pfile='C:\Oracle\product\10.2.0\admin\grasim\pfile\init.ora';

[Updated on: Sat, 11 April 2009 19:57]

Report message to a moderator

Previous Topic: How do I generate a SQL script file for creation of existing DB Objects (merged 4)
Next Topic: dictionary managed free blocks management
Goto Forum:
  


Current Time: Thu Dec 08 22:17:22 CST 2016

Total time taken to generate the page: 0.04997 seconds