Monday, October 20, 2008

Error LRM-00123 Create SPFILE from PFILE

Hi Friends,

Yesterday night I have a plan to create a Physical Standby Database server with Data Guard feature. But I got hanged with LRM-00123 Error at the time of creating SPFILE from PFILE 

And later on I tired a lot to do googling but there is no proper solution provided by anyone.
SQL> create spfile from pfile='c:\primarypfile.ora';
create spfile from pfile='c:\primarypfile.ora' 
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00123: invalid character 146 found in the input file
Here when I have used Notepad or Wordpad Text editor I was not able to find any difference. But later on when I have installed TEXTPAD text editor. I found the difference that I have used "`" instead of using '.

I hope this will help you all in future.

Enjoy!!!!!




4 comments:

  1. Hi Bhavik,
    Thank you very much for your post. It really worked.

    Thanks
    Fahad
    Oracle DBA

    ReplyDelete
  2. Hi ingress,
    Thank you very much for your post. It really worked.

    Thanks
    Fahad
    Oracle DBA

    ReplyDelete
  3. You are welcome Fahad.

    Regards,
    Bhavik

    ReplyDelete
  4. You are welcome Fahad.

    Regards,
    ingress

    ReplyDelete