Ora - 1034 during System Rename

[former_member182034]

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,

[Former Member]

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

[former_member182034]

ISSUE RESOLVED

[Former Member]

Hi Abdul,

Could you please share the resolution and close the thread.

[Former Member]

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

[former_member182657]

Hi Abdul,

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

Regards,

Gaurav

[former_member182657]

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

[Former Member]

Please share the ora_sql_results.log file.

Check the parameters according to the note suggested above and remove the parameter 'diagnostic_dest' from your initPFP.ora.mount file and try to start the system manually by providing the full path of initPFP.ora.mount .

Share the error logs for the same if again you get some.

[former_member182034]

hi Rajesh and Gaurav,

1. Please check attached ora_sql_result file.

2. startup with full path

SQL> startup mount pfile=G:\oracle\PFP\102\database\initPFP.ora.mount

LRM-00101: unknown parameter name 'diagnostic_dest'

ORA-01078: failure in processing system parameters

3. If I removed the diagnostic_dest parameter then result is.

SQL> startup mount pfile=G:\oracle\PFP\102\database\initPFP.ora.mount

ORA-00401: the value for parameter compatible is not supported by this release

4. If I change the value of compatible parameter from 11.2.0 to 10.2.0 then i get below error.

SQL> startup mount pfile=G:\oracle\PFP\102\database\initPFP.ora.mount

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translat

ed

ORA-01263: Name given for file destination directory is invalid

OSD-04018: Unable to access the specified directory or device.

O/S-Error: (OS 3) The system cannot find the path specified.

5. If i change the value ( from NTS) to NONE) of this parameter SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora

SQL> startup mount pfile=G:\oracle\PFP\102\database\initPFP.ora.mount

ORA-01031: insufficient privileges

I don't think that issue will be resolved after change the parameters.

Regards,

ora_sql_results.txt.zip

[Former Member]

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.

[former_member182657]

Hi Abdul,

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

Regards,

Gaurav

[former_member182657]

Hi Abdul,

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

Regards,

Gaurav

[Former Member]

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

[former_member182034]

hi Dear,

same error when i try to startup with full path.

Regards,

[Former Member]

Hi,

It looks some issue with your environment variables, check if the below parameters are set correctly for the user

ORACLE_HOME

SAPDBHOST

DBSID

SAPDATA_HOME

Check parameters as per the SAP notes 830576.

Could you confirm your oracle version, you are getting error "LRM-00101: unknown parameter name 'diagnostic_dest'" which is oracle 11g parameter but from the sqlplus error it looks you are on oracle 10 . (SAPINST: End of output of SQL executing program G:\oracle\PFP\102/bin/sqlplus)

Have you checked if you have used correct oracle version while selection in sapinst.

[former_member182034]

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,