Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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,

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question