| 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
|
|
|
|
|
|
|
|
| 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.
|
|
|
|
|
|
|
|
|
|
|
|
| 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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
