Subscribe

Cannot create Profile

[ Edited ]

Hi

I've got the following error when creating the profile. I don't know what it means ,Please help !

SnapManager for Oracle 3.1P1

OS : Hp-ux 11.23

Oracle  9.2.0

-[ INFO] SMO-13046: Operation GUID 8a2aa0b231524fb90131524fc5d90009 starting on Profile EnterENTTST

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

--[ INFO] SMO-13506: SQLPlus verification for database SID "ENTTST" passed.  Environment: [ORACLE_HOME=/ent/oracle/product/9.2.0]

--[ INFO] SMO-07431: Saving starting state of the database: ENTTST(OPEN).

--[ INFO] SMO-07431: Saving starting state of the database: ENTTST(OPEN).

--[ INFO] SD-00016: Discovering storage resources for /ENTTST_data.

--[ INFO] SD-00017: Finished storage discovery for /ENTTST_data.

--[ INFO] SD-00016: Discovering storage resources for /controlredo.

--[ INFO] SD-00017: Finished storage discovery for /controlredo.

--[ INFO] SD-00016: Discovering storage resources for /archive.

--[ INFO] SD-00017: Finished storage discovery for /archive.

--[ INFO] SD-00040: Beginning to discover filesystem(s) upon host volume group vgnetapp_archive.

--[ INFO] SD-00041: Finished discovering filesystem(s) upon host volume group vgnetapp_archive.

--[ INFO] SD-00040: Beginning to discover filesystem(s) upon host volume group vgnetapp_orafile.

--[ INFO] SD-00041: Finished discovering filesystem(s) upon host volume group vgnetapp_orafile.

--[ INFO] SD-00040: Beginning to discover filesystem(s) upon host volume group vgnetapp_ent.

--[ INFO] SD-00041: Finished discovering filesystem(s) upon host volume group vgnetapp_ent.

--[ERROR] FLOW-11019: Failure in BuildRestoreSteps: java.lang.NullPointerException

--[ERROR] FLOW-11008: Operation failed: java.lang.NullPointerException

--[ERROR] SMO-05075: Profile create failed: SMO-13527: Error performing fast restore check: FLOW-11019: Failure in BuildRestoreSteps: java.lang.NullPointerException.

Best regard

Tien

Cannot create Profile

64bits or 32bits?

Cannot create Profile

Hi

WEB GUI is  installed on windows server 2003 32bits

SMO server is installed on HpUX 11.23 64 bits

Regards/Tien

Cannot create Profile

OK,

About smo logs, What it say?

Cannot create Profile

:-)

I have the same error.

AIX

SMSAP 3.1P1

Oracle 10GR2

Cannot create Profile

If Somebody have An idea:

Some Smsap logs :

2011-08-02 10:07:20,148 [default0 f8bbdcbc229dab4144e75a8cb17f684c] [DEBUG]: FileSystemRestoreScopeCalculation - recursing to directory /oracle/TR1/sapdata4/undo_8
2011-08-02 10:07:20,148 [default0 f8bbdcbc229dab4144e75a8cb17f684c] [DEBUG]: FileSystemRestoreScopeCalculation - recursing to directory /oracle/TR1/sapdata4/user1i_1
2011-08-02 10:07:21,463 [default0 f8bbdcbc229dab4144e75a8cb17f684c] [DEBUG]: Storage component: /oracle/TR1/sapdata2/cust1d_2/cust1d.data2
2011-08-02 10:07:21,463 [default0 f8bbdcbc229dab4144e75a8cb17f684c] [DEBUG]: First Diskward component is : /oracle/TR1/sapdata2, Total diskward components : 1, Scope is: FULL
2011-08-02 10:07:21,463 [default0 f8bbdcbc229dab4144e75a8cb17f684c] [DEBUG]: To find if restore to an alternal location is specified in restore spec
2011-08-02 10:07:21,473 [default0 f8bbdcbc229dab4144e75a8cb17f684c] [ERROR]: FLOW-11019: Failure in BuildRestoreSteps: java.lang.NullPointerException
java.lang.NullPointerException
at com.netapp.snapfile.restore.RestoreStepGraphFactory.createRestoreStepGraph(RestoreStepGraphFactory.java:104)
at com.netapp.snapfile.restore.BuildRestoreStepsTask.execute(BuildRestoreStepsTask.java:52)
at com.netapp.common.flow.TaskInstanceTemplate.execute(TaskInstanceTemplate.java:336)
at com.netapp.common.flow.Operation.executeCurrentStack(Operation.java:140)
at com.netapp.common.flow.Operation.execute(Operation.java:55)
at com.netapp.common.flow.Threadpool$OperationThread.run(Threadpool.java:257)
2011-08-02 10:07:21,480 [default0 f8bbdcbc229dab4144e75a8cb17f684c] [ERROR]: FLOW-11008: Operation failed: java.lang.NullPointerException
java.lang.NullPointerException
at com.netapp.snapfile.restore.RestoreStepGraphFactory.createRestoreStepGraph(RestoreStepGraphFactory.java:104)
at com.netapp.snapfile.restore.BuildRestoreStepsTask.execute(BuildRestoreStepsTask.java:52)
at com.netapp.common.flow.TaskInstanceTemplate.execute(TaskInstanceTemplate.java:336)
at com.netapp.common.flow.Operation.executeCurrentStack(Operation.java:140)
at com.netapp.common.flow.Operation.execute(Operation.java:55)
at com.netapp.common.flow.Threadpool$OperationThread.run(Threadpool.java:257)
2011-08-02 10:07:21,491 [RMI TCP Connection(2)-10.2.4.109] [ERROR]: SMSAP-05075: Profile create failed: SMSAP-13527: Error performing fast restore check: FLOW-11019: Failure in BuildRestoreSteps: java.lang.NullPointerException.
2011-08-02 10:07:27,234 [RMI TCP Connection(2)-10.2.4.109] [ERROR]: SMSAP-13032: Cannot perform operation: Profile Create. Root cause: SMSAP-13527: Error performing fast restore check: FLOW-11019: Failure in BuildRestoreSteps: java.lang.NullPointerException.
com.netapp.dlm.services.vhi.HostSessionException: SMSAP-13527: Error performing fast restore check: FLOW-11019: Failure in BuildRestoreSteps: java.lang.NullPointerException.
at com.netapp.dlm.process.operation.FastRestoreCheckAlgorithm$2.constructException(FastRestoreCheckAlgorithm.java:89)
at com.netapp.dlm.process.operation.FastRestoreCheckAlgorithm$2.constructException(FastRestoreCheckAlgorithm.java:88)
at com.netapp.dlm.services.vhi.SnapFileInvocation.invoke(SnapFileInvocation.java:73)
at com.netapp.dlm.process.operation.FastRestoreCheckAlgorithm.runCheck(FastRestoreCheckAlgorithm.java:93)
at com.netapp.dlm.process.operation.ProfileCreateOperation.processDatabase(ProfileCreateOperation.java:171)
at com.netapp.dlm.process.operation.ProfileCreateOperation.doExecute(ProfileCreateOperation.java:127)
at com.netapp.dlm.process.common.OpCycleOperation.execute(OpCycleOperation.java:146)
at com.netapp.dlm.server.RemoteOperationImpl.execute(RemoteOperationImpl.java:62)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:309)
at sun.rmi.transport.Transport$1.run(Transport.java:168)
at java.security.AccessController.doPrivileged(AccessController.java:274)
at sun.rmi.transport.Transport.serviceCall(Transport.java:164)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:506)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.handleRequest(TCPTransport.java:838)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:912)
at java.lang.Thread.run(Thread.java:811)
2011-08-02 10:07:27,237 [RMI TCP Connection(2)-10.2.4.109] [INFO ]: SMSAP-07433: Returning the database to its initial state: TR1(OPEN).
2011-08-02 10:07:27,238 [RMI TCP Connection(2)-10.2.4.109] [DEBUG]: ORACLE-10000: Executing SQL query: select status from v$instance
2011-08-02 10:07:27,239 [RMI TCP Connection(2)-10.2.4.109] [DEBUG]: ORACLE-10007: Finished executing SQL in 0:00:00.001: select status from v$instance
2011-08-02 10:07:27,239 [RMI TCP Connection(2)-10.2.4.109] [DEBUG]: ORACLE-20007: Database instance TR1 is in state OPEN.
2011-08-02 10:07:27,240 [RMI TCP Connection(2)-10.2.4.109] [INFO ]: SMSAP-13039: Successfully aborted operation: Profile Create
2011-08-02 10:07:27,404 [RMI TCP Connection(2)-10.2.4.109] [ERROR]: SMSAP-13048: Profile Create Operation Status: FAILED
2011-08-02 10:07:27,409 [Thread-9] [DEBUG]: Heartbeat thread interrupted
2011-08-02 10:07:27,411 [Thread-9] [DEBUG]: Heartbeat thread finished
2011-08-02 10:07:27,411 [RMI TCP Connection(2)-10.2.4.109] [INFO ]: SMSAP-13049: Elapsed Time: 0:04:13.437
2011-08-02 10:07:27,428 [RMI TCP Connection(2)-10.2.4.109] [DEBUG]: Operation ENDED
2011-08-02 10:07:28,489 [RMI Unreferenced-1] [DEBUG]: RemoteObjectFactory unreferenced
2011-08-02 10:07:28,489 [RMI Unreferenced-2] [DEBUG]: Cleaning up operation factory JVM.

Cannot create Profile

Hi pdeshaye.

Efter some tests ,now I knew what my problem is . The reason  why SMO(for my problem,only) cannnot create a profile is that data files and Oracle_Home are on the same volumes/disk. After seperating them into different volumes/disks it does work perfectly.

Vol1/disk1 controlfiles ,redolog files

Vol2/disk2 archivelog files

Vol3/disk3 datafiles

Vol4/disk4 ORACLE_HOME

Regards/Tien