on 09-15-2014 1:04 PM
Hello Team,
We created the clone of system A on By cloning using Hyper V export/import option.
Later we changed the all mount points pointing to B.We have now database Oracle 11.2.0.4 OS Linux RHEL 6.0 after cloning. And SAp is ECC 6.0 EHP 7 ,SAP_BASIS 740.Now we are running SWPM 1.0 Sp06 patch3 to rename the SID from A to B.
We encountered the below error
"An error occurred while processing option System Rename > Standard
System > SAP System Rename( Last error reported by the step: The JVMreports an exception during execution of class com.sap.sdt.ins.component.ora_clone_db_post_dia.DiSchemaUsersAndListener_validator) and function executeStepClass.\n DIAGNOSIS: The reported error
messagefrom JVM is: com.sap.sdt.sltoolbox.kdb.KdbException: no server version found in /oracle/B/11204 at
We can start our database and we also installed oracle 11.2.0.4 on B server on path /oracle/B /11204 again
still SWPM is giving same error.Please suggest.
Hi SPR,
Any responce from SAP?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Prasad,
Sorry for delay..
SAP replied as below
After an internal analysis we noticed that the tool was expecting to
find the ORACLE_HOME set to /oracle/B/112_64.
You mentioned that you have installed Oracle 11g in the new cloned
server.
Please check if the ORACLE_HOME is set to this location, which is a
symbolic link to /oracle/B/11204.
Also does this location exist?
If not, please create a symbolic link and let me know how it goes.
SAP is asking to create folder 112_64 at path /oracle/SID and then creating the symbolic link to actual ORACLE_HOME (/oracle/B/11204)
We can not try this as we already started manual method to start DB with SID B as we do while system refresh and later Run the SWPM for SAP SID rename only.
Now our test system is up and running with new SID B but we are not sure if it will raise any issue in future.
waiting to know from you whether the solution works for you or not.
Thank you!
We have raised call to SAP. Now SAP is also investigating on the same. Will let you know the updates once we get.
Thank you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi SPR,
I am also getting exactly same error and have created message with SAP.
please see the below reply from SAP.
==========================================
Please note that we noticed the SWPM is
expecting the ORACLE_HOME is set to /oracle/<Target SID>/102_64, which should
be a symbolic link to "/oracle/<Source SID>/11203". Does this link exist? If
not please do the following:
1. Create the symbolic link /oracle/<Target SID>/102_64 => /oracle/<Source SID>/11203;
2. Set ORACLE_HOME=/oracle/<Target SID>/102_64;
3. Run SWPM again.
======================================
FYI: I have not tried with SAP solution, as my system in not available now. I will give a try after couple of days. I kindly request you to let me know if it works fine.
Thanks and Regards,
Prasad
Hi Spr,
Did you maintain the oracle home environment variable.
With Regards
Ashutosh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Please attach last 500 lines from sapinst_dev.log
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
sapinst_dev.log
log last 500 lines:
INFO
2014-09-15 07:53:14.833 [syuxccuren.cpp:543]
CSyCurrentProcessEnvironmentImpl::setWorkingDirectory(const CSyPath& /tmp/sapinst_instdir/NW73/SBC/STANDARD)
lib=syslib module=syslib
Working directory changed to /tmp/sapinst_instdir/NW73/SBC/STANDARD.
TRACE 2014-09-15 07:53:14.833 [syuxccuren.cpp:111]
CSyCurrentProcessEnvironmentImpl::setUmask(ulong)
lib=syslib module=syslib
umask set to 23
TRACE 2014-09-15 07:53:14.836 [kdxxctaco.cpp:93]
CKdbTableContainerImpl::syncToContainerFile
CKdbTableContainerImpl::syncToContainerFile start ...
TRACE 2014-09-15 07:53:14.837 [kdxxctaco.cpp:122]
CKdbTableContainerImpl::syncToContainerFile
after creating out stream for /tmp/sapinst_instdir/NW73/SBC/STANDARD/inifile.xml
TRACE 2014-09-15 07:53:14.837 [kdxxctaco.cpp:156]
CKdbTableContainerImpl::syncToContainerFile
CKdbTableContainerImpl::syncToContainerFile stop ...
INFO 2014-09-15 07:53:14.840 [sixxcstepexecute.cpp:766]
Execute step getDefaultsForSAPInstanceDistributed of component |offlineadjustment_dialogs|ind|ind|ind|ind|0|0.
TRACE
Instantiating new NWUsageTypeBasic
TRACE
NWUsageTypeBasic() done
TRACE
Call block: offlineadjustment_dialogs_ind_ind_ind_ind
function: offlineadjustment_dialogs_ind_ind_ind_ind_DialogPhase_getDefaultsForSAPInstanceDistributed_Preprocess
is validator: false
TRACE 2014-09-15 07:53:14.905 [sixxcstepexecute.cpp:835]
Execution of preprocess block of |offlineadjustment_dialogs|ind|ind|ind|ind|0|0|getDefaultsForSAPInstanceDistributed returns FALSE.
TRACE
The step getDefaultsForSAPInstanceDistributed with key |offlineadjustment_dialogs|ind|ind|ind|ind|0|0 has been executed successfully.
TRACE 2014-09-15 07:53:14.909 [syuxccuren.cpp:289]
CSyCurrentProcessEnvironmentImpl::setEffectiveGroup(PSyGroupInt)
lib=syslib module=syslib
effective group already set. Nothing to do.
TRACE 2014-09-15 07:53:14.909 [syuxcuser.cpp:635]
PSyGroupImpl CSyUserImpl::getPrimaryGroup()const
lib=syslib module=syslib
account user="root" uid="0" exists with parameter gid="0"
TRACE 2014-09-15 07:53:14.909 [syuxccuren.cpp:249]
CSyCurrentProcessEnvironmentImpl::setEffectiveUser(PSyUserInt, const iastring&)
lib=syslib module=syslib
effective user already set. Nothing to do.
INFO 2014-09-15 07:53:14.909 [syuxccuren.cpp:543]
CSyCurrentProcessEnvironmentImpl::setWorkingDirectory(const CSyPath& /tmp/sapinst_instdir/NW73/SBC/STANDARD)
lib=syslib module=syslib
Working directory changed to /tmp/sapinst_instdir/NW73/SBC/STANDARD.
TRACE 2014-09-15 07:53:14.909 [syuxccuren.cpp:111]
CSyCurrentProcessEnvironmentImpl::setUmask(ulong)
lib=syslib module=syslib
umask set to 23
TRACE 2014-09-15 07:53:14.912 [kdxxctaco.cpp:93]
CKdbTableContainerImpl::syncToContainerFile
CKdbTableContainerImpl::syncToContainerFile start ...
TRACE 2014-09-15 07:53:14.913 [kdxxctaco.cpp:122]
CKdbTableContainerImpl::syncToContainerFile
after creating out stream for /tmp/sapinst_instdir/NW73/SBC/STANDARD/inifile.xml
TRACE 2014-09-15 07:53:14.913 [kdxxctaco.cpp:156]
CKdbTableContainerImpl::syncToContainerFile
CKdbTableContainerImpl::syncToContainerFile stop ...
INFO 2014-09-15 07:53:14.916 [sixxcstepexecute.cpp:766]
Execute step askTREXInstances of component |offlineadjustment_dialogs|ind|ind|ind|ind|0|0.
TRACE
Instantiating new NWUsageTypeBasic
TRACE
NWUsageTypeBasic() done
TRACE
Call block: offlineadjustment_dialogs_ind_ind_ind_ind
function: offlineadjustment_dialogs_ind_ind_ind_ind_DialogPhase_askTREXInstances_Preprocess
is validator: false
TRACE 2014-09-15 07:53:14.979 [sixxcstepexecute.cpp:835]
Execution of preprocess block of |offlineadjustment_dialogs|ind|ind|ind|ind|0|0|askTREXInstances returns FALSE.
TRACE
The step askTREXInstances with key |offlineadjustment_dialogs|ind|ind|ind|ind|0|0 has been executed successfully.
TRACE 2014-09-15 07:53:14.982 [syuxccuren.cpp:289]
CSyCurrentProcessEnvironmentImpl::setEffectiveGroup(PSyGroupInt)
lib=syslib module=syslib
effective group already set. Nothing to do.
TRACE 2014-09-15 07:53:14.982 [syuxcuser.cpp:635]
PSyGroupImpl CSyUserImpl::getPrimaryGroup()const
lib=syslib module=syslib
account user="root" uid="0" exists with parameter gid="0"
TRACE 2014-09-15 07:53:14.982 [syuxccuren.cpp:249]
CSyCurrentProcessEnvironmentImpl::setEffectiveUser(PSyUserInt, const iastring&)
lib=syslib module=syslib
effective user already set. Nothing to do.
INFO 2014-09-15 07:53:14.982 [syuxccuren.cpp:543]
CSyCurrentProcessEnvironmentImpl::setWorkingDirectory(const CSyPath& /tmp/sapinst_instdir/NW73/SBC/STANDARD)
lib=syslib module=syslib
Working directory changed to /tmp/sapinst_instdir/NW73/SBC/STANDARD.
TRACE 2014-09-15 07:53:14.982 [syuxccuren.cpp:111]
CSyCurrentProcessEnvironmentImpl::setUmask(ulong)
lib=syslib module=syslib
umask set to 23
TRACE 2014-09-15 07:53:14.986 [kdxxctaco.cpp:93]
CKdbTableContainerImpl::syncToContainerFile
CKdbTableContainerImpl::syncToContainerFile start ...
TRACE 2014-09-15 07:53:14.986 [kdxxctaco.cpp:122]
CKdbTableContainerImpl::syncToContainerFile
after creating out stream for /tmp/sapinst_instdir/NW73/SBC/STANDARD/inifile.xml
TRACE 2014-09-15 07:53:14.987 [kdxxctaco.cpp:156]
CKdbTableContainerImpl::syncToContainerFile
CKdbTableContainerImpl::syncToContainerFile stop ...
INFO 2014-09-15 07:53:14.991 [sixxcstepexecute.cpp:766]
Execute step askInstances of component |offlineadjustment_dialogs|ind|ind|ind|ind|0|0.
TRACE
Instantiating new NWUsageTypeBasic
TRACE
NWUsageTypeBasic() done
TRACE
Call block: offlineadjustment_dialogs_ind_ind_ind_ind
function: offlineadjustment_dialogs_ind_ind_ind_ind_DialogPhase_askInstances_Preprocess
is validator: false
TRACE 2014-09-15 07:53:15.50 [sixxcstepexecute.cpp:821]
Execution of preprocess block of |offlineadjustment_dialogs|ind|ind|ind|ind|0|0|askInstances returns TRUE.
TRACE
Instantiating new NWUsageTypeBasic
TRACE
NWUsageTypeBasic() done
TRACE
Call block: offlineadjustment_dialogs_ind_ind_ind_ind
function: offlineadjustment_dialogs_ind_ind_ind_ind_DialogPhase_askInstances
is validator: false
TRACE
tInstancesNumberLocalTable4UI.remove(WHERE 1=1)
TRACE 2014-09-15 07:53:15.68 [TableCpp.cpp:283]
Table(tInstancesNumberLocalTable4UI).insertRow({
hostSource:HostnameofA
hostTarget:HostnameofB
instanceDirSource:
instanceNumberSource:00
instanceNumberTarget:00
instanceProfileSource:/sapmnt/B/profile/A_DVEBMGS00_HostnameofA
instanceSource:DVEBMGS00
}, WHERE 1=1)
inserting
TRACE 2014-09-15 07:53:15.79 [iaxxgenimp.cpp:283]
CGuiEngineImp::showDialogCalledByJs()
showing dlg dStorageCopyInstance
TRACE 2014-09-15 07:53:15.80 [iaxxgenimp.cpp:293]
CGuiEngineImp::showDialogCalledByJs()
<dialog sid="dStorageCopyInstance">
<title>SAP Instances</title>
<table enabled="true" fixedrows="true" sid="instancesTable">
<caption>Source System</caption>
<column enabled="false" type="field" numeric="false" upper="false" name="instanceSource">
<caption>Instance</caption>
</column>
<column enabled="true" type="file" numeric="false" upper="false" name="instanceProfileSource">
<caption>Instance Profile</caption>
<helpitem id="SystemRename.InstanceProfile"/>
<value type="string"/>
</column>
<column enabled="true" type="field" numeric="true" upper="false" minvalue="0" maxvalue="98" name="instanceNumberSource">
<caption>Instance Number</caption>
<helpitem id="common.InstanceNumberABAP"/>
<value type="numeric"/>
</column>
<column enabled="true" type="field" numeric="false" upper="false" minlength="1" name="hostSource">
<caption>Host</caption>
<helpitem id="SystemRename.HostSource"/>
</column>
<row rowId="0">
<value>DVEBMGS00</value>
<value>/sapmnt/B/profile/A_DVEBMGS00_HostnameofA</value>
<value>00</value>
<value>HostnameofA</value>
</row>
</table>
<table enabled="true" fixedrows="true" sid="instancesTableTarget">
<caption>Target System</caption>
<column enabled="false" type="field" numeric="false" upper="false" name="instanceSource">
<caption>Instance</caption>
</column>
<column enabled="true" type="field" numeric="true" upper="false" minvalue="0" maxvalue="98" name="instanceNumberTarget">
<caption>Target System Instance Number</caption>
<helpitem id="common.InstanceNumberABAP"/>
<value type="numeric"/>
</column>
<column enabled="true" type="field" numeric="false" upper="false" minlength="1" name="hostTarget">
<caption>Target System Host</caption>
<helpitem id="SystemRename.HostTarget"/>
</column>
<row rowId="0">
<value>DVEBMGS00</value>
<value>00</value>
<value>HostnameofB</value>
</row>
</table>
<dialog/>
TRACE 2014-09-15 07:53:15.80 [iaxxgenimp.cpp:1031]
CGuiEngineImp::acceptAnswerForBlockingRequest
Waiting for an answer from GUI
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.