Oracle Database Discussions

Hi Guys,

I am using Snap Manager for Oracle and I am trying to create a database clone using flexclone.

Now I get these errors:

--[ERROR] SMO-13032: Cannot perform operation: Clone Create. Root cause: ORACLE-00001: Error executing SQL: []. The command returned: SP2-1503: Unable to initialize Oracle call interface

I tried to access the sqlplus manually on the target server and I found these:

SunOS:oracle:DB /u01>sqlplus "/as sysdba"

SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

Then I did these:

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

Then:

SunOS:oracle:DB /u01>sqlplus "/as sysdba";

SQL*Plus: Release 11.2.0.3.0 Production on Tue Dec 4 14:00:32 2012

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to an idle instance.

SQL>


But still the SMO flexclone fails with the same error.

Where do one change the environment variable for the SMO?

Thanks in advance...