Skip to Content

Ora - 1034 during System Rename

Dear,

I am getting below issue during Backup/Restore Database phase of system rename

CONNECT / AS SYSDBA

SHUTDOWN IMMEDIATE

startup mount pfile=?/database/initPFP.ora.mount

@checkScript.sql

@rename.sql PFP PFP

EXIT

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.4.0 - Production on Sat Sep 27 01:00:49 2014

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to an idle instance.

Connected to an idle instance.

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

LRM-00101: unknown parameter name 'diagnostic_dest'

ORA-01078: failure in processing system parameters

Connected to an idle instance.

BEGIN

*

ERROR at line 1:

ORA-01034: ORACLE not available

Connected to an idle instance.

old  14:     sourceSid := upper('&&1');

new  14:     sourceSid := upper('PFP');

old  15:     targetSid := upper('&&2');

new  15:     targetSid := upper('PFP');

BEGIN

*

ERROR at line 1:

ORA-01034: ORACLE not available

Disconnected

SAPINST: End of output of SQL executing program G:\oracle\PFP\102/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2014-09-27, 01:00:54 SAPINST ORACLE stop logging

Regards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Sep 26, 2014 at 04:50 PM

    Check if you are able to start the database using command "startup mount pfile=?/database/initPFP.ora.mount" . Here provide full path of file initPFP.ora.mount

    Paste the output if you get any error

    Add comment
    10|10000 characters needed characters exceeded

    • hi Rejesh,

      ECC 6 installed with oracle 10204 on window server 2008 and system was running fine now I m renaming the hostname from SAPVPFP to SAPTPFP with below SWPM. this error is occurred during Backup/Restore Database phase of system rename.

      SOFTWARE PROVISIONING MGR 1.0 -> Windows on x64 64bit

      SWPM10SP06_4-20009707.SAR

      ORACLE_HOME, SAPDATA_HOME are set while remaining are not there.


      LRM-00101: unknown parameter name 'diagnostic_dest'" which is oracle 11g parameter but from the sqlplus error it looks you are on oracle 10

      I checked the info of above SWPM and I did not find that SWPM  support to which database. I also checked , there is compatible = 11.2.0 is in initPFP.ora.mount while i m using oracle 10204.


      hi Gaurav,

      I already shared the ora_sql_results.log.



      Regards,


  • avatar image
    Former Member
    Sep 29, 2014 at 04:58 AM

    Hi Abdul,

    Could you please share the ora_sql_results.log from /tmp directory and alert_<SID>.log file for analysis.

    Regards,

    Gaurav

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 29, 2014 at 05:04 AM

    Hi Abdul,

    Have you checked SAP Note 653247 - Composite note: ORA-01078

    Regards,

    Gaurav

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 29, 2014 at 05:09 AM

    Hi Abdul,

    If possible try to startup database in mount state and retry the phase again and re share the alert_<SID>.log and ora_sql_results.log files.

    Regards,

    Gaurav Rana

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member M. Abdul Jamil

      Could you please check the screenshots if you taken during parameter definition to SAPINST.

      During parameter definition to the Databse, default selection is oracle11 and you need to select oracle10 from drop down as your current database is oracle 10.

      If this is not the case, please open an OSS to get help from SAP.

  • avatar image
    Former Member
    Oct 02, 2014 at 01:41 AM

    Hi Abdul,

    Could you share sapinst_<sid>.log from tmp directory.Also please follow SCN link

    Regards,

    Gaurav

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 02, 2014 at 08:48 PM

    Hello,

    Can you check if service Window was created ? and be started ?

    you can make a duplicate database by RMAN manualy . outside sapinst.

    Regards

    Sandro Lobo

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member M. Abdul Jamil

      Hi Abdul Jamil ,

      Please be kind enough to explain the steps which you have done to resolve this issue.

      Great Thanks in advance for your help.

      Regards

      Kushal