cancel
Showing results for 
Search instead for 
Did you mean: 

SWPM 1.0 error while System Rename :no server version found in /oracle/SID/11204 at

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member82170
Participant
0 Kudos

Hi SPR,

Any responce from SAP?

Former Member
0 Kudos

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!

former_member82170
Participant
0 Kudos

Hi SPR,

Thank you, My issue has been resolved by changing the Oracle home to /oracle/<SID>/112_64 in listener.ora file.

Thanks and Regard,

Prasad

Former Member
0 Kudos

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!

former_member82170
Participant
0 Kudos

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

Former Member
0 Kudos

Check oracle home name maintained in /etc/oratab file for your SID.

SWPM will check and require same name which is mainatined in there.

One more thing to point here, if your oracle version home is 11204 you have to create softlink to 11204 not to 11203

former_member185239
Active Contributor
0 Kudos

Hi Spr,

Did you maintain the oracle home environment variable.

With Regards

Ashutosh

former_member188883
Active Contributor
0 Kudos

Hi ,

Please attach last 500 lines from sapinst_dev.log

Regards,

Deepak Kori

Former Member
0 Kudos

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