OraFAQ Forum: Server Administration » error in identifying file 'C:\oracle\product\10.2.0\db

Home » RDBMS Server » Server Administration » error in identifying file 'C:\oracle\product\10.2.0\db_1/dbs/spfilegrasim.ora' (Oracle,10g,windows xp)

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

error in identifying file 'C:\oracle\product\10.2.0\db_1/dbs/spfilegrasim.ora' [message #397328]

Fri, 10 April 2009 01:48

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.

Report message to a moderator

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

Michel Cadot
Messages: 68665
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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

create spfile from pfile;

Regards
Michel

Report message to a moderator

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 23:42:22 CDT 2024