topic SMO Creating Profile In Win2008 in Data Protection

SMO Creating Profile In Win2008

asitienei — Fri, 18 Dec 2015 09:16:57 GMT

Hi ,

I am getting below error when creating a profile in snap manager for oracle

--[ERROR] SMO-05075: Profile create failed: ORACLE-00602: Cannot find ORACLE_HOME for SID " " in the Windows Registry

Log Details

INFO] SMO-13051: Process PID=9304

[ INFO] SMO-13036: Starting operation Profile Create on host

[ INFO] SMO-13046: Operation GUID 8a80838d3a30014a013a30014fe90009 starting on Profile netapp_jobs

[ INFO] SMO-13505: SnapDrive environment verification passed.

[ERROR] SMO-05075: Profile create failed: ORACLE-00602: Cannot find ORACLE_HOME for SID " " in the Windows Registry.

[ERROR] SMO-13032: Cannot perform operation: Profile Create. Root cause: ORACLE-00602: Cannot find ORACLE_HOME for SID " " in the Windows Registry.

[ INFO] SMO-13039: Successfully aborted operation: Profile Create

[ERROR] SMO-13048: Profile Create Operation Status: FAILED

[ INFO] SMO-13049: Elapsed Time: 0:00:08.268

Your help will be highly appreciated

Re: SMO Creating Profile In Win2008

chinchillaking — Mon, 22 Oct 2012 15:59:56 GMT

Hi Aspel,

I have problem with "ORACLE-00602: Cannot find ORACLE_HOME for SID " " in the Windows Registry" with SMO 3.0.3 and 3.1 but I am not sure same as your, environment as below.

Windows 2008R2 EE SP1

Oracle 11gR2 X64

I found below link describe Oracle 64bit registry in "HKLM\SOFTWARE\Wow6432Node\ORACLE\ORACLE_HOME", but 32bit application cannot recognise. I cannot found SMO x64 access Oracle registry information and I try export registry HKLM\SOFTWARE\Wow6432Node\ORACLE\ORACLE_HOME and edit location to HKLM\SOFTWARE\ORACLE\ORACLE_HOME, after import new edition and the problem disappear.

http://blog.whitehorses.nl/2010/02/03/32-bit-applications-on-64-bit-windows-welcome-wow6432node-registry-key/

Best regards,

Chung

Re: SMO Creating Profile In Win2008

RoyG — Mon, 19 Oct 2015 17:05:17 GMT

I ran into this issue as well after upgrading Oracle 11.2.0.1 to 11.2.0.4. No resolutions found on the net helped.

error [ERROR] SMO-05075: Profile create failed: ORACLE-00602: Cannot find ORACLE_HOME for SID "DELTEKCP" in the Windows Registry.

Setting ORACLE_HOME wouldn't resolve it. I had a cloned box that didn't have the upgrade yet.

I exported the registry from that box for the key [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb11g_home1] and imported that into my upgraded box and this RESOLVED this issue. I'm not sure which key resolved it. I'm attaching a screenshot of the keys in this export for reference.

Re: SMO Creating Profile In Win2008

Sahana — Tue, 20 Oct 2015 09:55:58 GMT

SnapManager does not support the following features, platforms, and Oracle technologies:

• Policy-based data protection available with the integration of the NetApp Management Console data protection capability

• Role-based access control (RBAC) available with the integration of Operations Manager

• Fast restore or volume-based SnapRestore (VBSR) 11

• Clone split operation

• Oracle Real Application Clusters (RAC) using any protocol

• Oracle Automatic Storage Management (ASM) using any protocol

• Oracle Direct NFS (dNFS)

• Itanium-64 platforms

Refer https://library.netapp.com/ecm/ecm_get_file/ECMP1119917 (Needs login) page 11.

Re: SMO Creating Profile In Win2008

Sahana — Tue, 20 Oct 2015 09:59:37 GMT

Since this is Oracle RAC, you should provide the aaa1 during the profile creation (the SID of the database has a number at the end corresponding to each RAC node).

Re: SMO Creating Profile In Win2008

RoyG — Wed, 21 Oct 2015 02:33:13 GMT

Sahana, this is not RAC. This is single Windows instance.