Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm having a problem in creating spfile from pfile.I think I don't have permission to write on Oracle Home. I'm using Windows 8

SQL> startup nomount pfile='initlittle2.ora.txt';
ORACLE instance started.

Total System Global Area  644468736 bytes
Fixed Size                  1376520 bytes
Variable Size             192941816 bytes
Database Buffers          444596224 bytes
Redo Buffers                5554176 bytes
SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'A:\ORACLEBASE\PRODUCT\11.2.0\OLTP2\DATABASE\INITLITTLE2.ORA' 

Any workaround for my problem?

share|improve this question

1 Answer 1

It appears that you created your pfile with a double extension .ora.txt (Windows Notepad sometimes does this).

You can try to:

  • rename the pfile removing the .txt extension, or

  • specify the full path to your parameter file in the CREATE statement, e.g. CREATE SPFILE FROM PFILE = 'c:\yourpath\initlittle2.ora.txt';

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.