OraFAQ Forum: Server Administration » ORA-01565: error in identifying file

Home » RDBMS Server » Server Administration » ORA-01565: error in identifying file (ORACLE 11.1 red hat4.1.2)

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

ORA-01565: error in identifying file [message #475414]

Tue, 14 September 2010 23:19

nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR

Member

Hi

I need to increase the size of shared pool for that i need to change the size of parameter sga_target and sga_max_size these are static parameter so that I need to change in spfile first then start instance then these parameter will get change. But when I create pfile from spfile it gives error:

ERROR at line 1:
ORA-01565: error in identifying file '?/dbs/spfile@.ora'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

Please tell me the solution of this.

Regards//
Neha

Report message to a moderator

Re: ORA-01565: error in identifying file [message #475415 is a reply to message #475414]

Tue, 14 September 2010 23:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I need to increase the size of shared pool
please post proof that NEED actually exists.

post results from SQL below
SELECT * FROM V$SGA_TARGET_ADVICE;

>But when I create pfile from spfile it gives error:

ERROR at line 1:
ORA-01565: error in identifying file '?/dbs/spfile@.ora'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

>Please tell me the solution of this.
I don't know what you have.
I don't know what you do.
I don't know what you see.
It is really, Really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds

Report message to a moderator

Re: ORA-01565: error in identifying file [message #475425 is a reply to message #475414]

Wed, 15 September 2010 00:53

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Are you sure you use a spfile? Are you sure you named an existing spfile?
Maybe it would help if you posted the statement you tried to execute, don't you think?

Regards
Michel

Report message to a moderator

Re: ORA-01565: error in identifying file [message #475426 is a reply to message #475425]

Wed, 15 September 2010 01:11

nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR

Member

Hi

I was executing a procedure and I got this msg:
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","SELECT /*+rule*/ SYS_XMLGEN(...","sql area","qeeOpn*[]: qkexrXformOpnArray")
ORA-06512: at "SYS.DBMS_METADATA", line 1968
ORA-06512: at "SYS.DBMS_METADATA", line 2011
ORA-06512: at "SYS.DBMS_METADATA", line 2343
ORA-06512: at "SYS.DBMS_METADATA", line 3247
ORA-06512: at "SYS.DBMS_METADATA", line 4863
ORA-06512: at line 1
ORA-06512: at "SYS.CREATE_COMPANY_NEWEST_TEST", line 120;

then I tried this one:
alter system set shared_pool_size=100M;
then it shows:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04033: Insufficient memory to grow pool

so I follow this link http://www.orafaq.com/wiki/SGA_target
it says:-For that we must first increase our SGA_MAX_SIZE parameter value. But we must restart out instance because its STATIC parameter.
because of this statement i was trying to create pfile from spfile but i cant.

please describe me how could i increase this parameter.
I am a beginner and need help of some senior DBA.

Report message to a moderator

Re: ORA-01565: error in identifying file [message #475427 is a reply to message #475426]

Wed, 15 September 2010 01:20

nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR

Member

Please see these details may be will help you for give me reply:

sga_target = 0
shared_pool_size = 128M
large_pool_size = 0
sga_max_size = 208M

Report message to a moderator

Re: ORA-01565: error in identifying file [message #475432 is a reply to message #475426]

Wed, 15 September 2010 01:55

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

i was trying to create pfile from spfile but i cant.

Michel Cadot wrote on Wed, 15 September 2010 07:53

Are you sure you use a spfile? Are you sure you named an existing spfile?
Maybe it would help if you posted the statement you tried to execute, don't you think?

Regards
Michel

Report message to a moderator

Re: ORA-01565: error in identifying file [message #475435 is a reply to message #475432]

Wed, 15 September 2010 02:16

nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR

Member

Hi

Oh yes I checked from v$spparameter
spfile = false;
and value = null;
It means instance is running through pfile only.
Now what I have to do for increasing the parameter of sga_max_size.

Report message to a moderator

Re: ORA-01565: error in identifying file [message #475436 is a reply to message #475435]

Wed, 15 September 2010 02:25

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Change the value in your pfile and restart.

Regards
Michel

Report message to a moderator

Re: ORA-01565: error in identifying file [message #475471 is a reply to message #475436]

Wed, 15 September 2010 04:40

nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR

Member

Hi

Actually this is our duplicate database of production db.
So I open init.ora it is having only 2 parameters
*.Compatible = 11.1.0.0.0
*.DB_Name='TESTDB'

so how could i change there sga_max_size when it is not available here?
please tell me the way to resolve this problem.

Report message to a moderator

Re: ORA-01565: error in identifying file [message #475473 is a reply to message #475471]

Wed, 15 September 2010 04:43

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Add it.

Regards
Michel

Report message to a moderator

Previous Topic:	ORA-28031 Maximum of 148 roles enabled roles exeeded
Next Topic:	Oracle Filrewall.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 21 07:07:52 CDT 2025