Homogeneous system copy ABAP with Oracle

[Former Member]

Hi!

I'm doing a homog. sys. copy with a CRM 7.0, unicode, on Oracle 10.2 and Windows 2008 64-bit.

I'm doing this copy to the same server as the system was one previously, because the system was not installed correctly.

I have uninstalled the instance the old system and have now started the system copy - target system - central instance and have choosen to restore with database backup.

I've run into some problems with the step Create Instance_oradim.

I get the following error in the SAPinstGui

An error occurred while processing option SAP CRM 7.0 Support Release 1 > Software Life-Cycle Options > System Copy > Oracle > Target System Installation > Central System > Based on AS ABAP > Central System( Last error reported by the step :TypeError: rowPar has no properties (in script NW_ABAP_OneHost|ind|ind|ind|ind, line 61644: ???)). You can now: 
u2022	Choose Retry to repeat the current step.
u2022	Choose View Log to get more information about the error.
u2022	Stop the option and continue with it later.
Log files are written to C:\Program Files/sapinst_instdir/CRM70/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/.

I've retried, but it didn't work

When I look in the sapinst file in C:\Program Files/sapinst_instdir/CRM70/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP I found this error.

|NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraOBR|ind|ind|ind|ind|5|0|createInstance_oradim was executed with status ERROR ( Last error reported by the step :TypeError: rowPar has no properties (in script NW_ABAP_OneHost|ind|ind|ind|ind, line 61644: ???)).

I also found something that might be an authorization error

FSL-01027  Account user="ORA_DCT_DBA" does not exist.
INFO[E] 2010-08-26 08:59:07.631
FSL-01027  Account user="ORA_DCT_OPER" does not exist
INFO[E] 2010-08-26 08:59:07.741
FSL-01027  Account user="ORA_DBA" does not exist.

rollo

[Former Member]

Hi Rollo,

I hope u have specified datafiles manually as in source system during the advanced DB config in the input phase. If not you have to stop and restart the installation and chose the advance DB config option and then specify the datafiles manually as that of the source system.

The datafile details of the source system can be obtained from the backup log.

Regards,

Varadharajan M

[Former Member]

Thanks for your reply!

I've chosen to restore the database from an offline backup, should I stil have to do this manually?

All folders and files are created as they should

rollo

[Former Member]

Rollo,

You mean all the datafiles have been restored to the same location as it was in the source system. Can you cross check that once again with the source system directoy structure/backup log? You need to ensure that the files are restored in the same path (<drive>:\oracle\<SID>\sapdata<n>).

Regards,

Varadharajan M

[Former Member]

Hi!

I thought that SAPinst stops for me to restore the database and that I shouldn't restore the database before that!?

I also got this from Markus Doehr yesterday in this thread

- running sapinst and select "backup/restore" as system copy option

- sapinst halts and ask you to restore the database

- sapinst continiues and adapts the environment

This is a similar error as mine

Regards

rollo

[Former Member]

Hi!

What do you mean by "All folders and files are created as they should" ?

Have u crossed the restore phase ?

As Mrkus said, the installation will halt inbetween for restoration. These steps are there in the installation guide.

Ensure that u r following the system copy guide. The steps are mentioned much clearly in the "Oracle database" section of the guide.

-Varadhu..

[Former Member]

I'm in the Backup/Restore phase, but the system has not yet halted for the restore.

rollo

[Former Member]

Got an anser from SAP last night

This is a know error and this is the workaround

1.- Stop sapinst

2.- login as <sid>adm user

start a command prompt and execute the following command:

oradim -new -SID <SID> -STARTMODE manual -SRVCSTART system

<SID> must be replaced by the database SID of the system you are

installing

3. modify the 'keydb.xml' in your installation dirctory:

search for createInstance_oradim and few lines later replace

"ERROR" with "OK".

The lines would be like

<fld name="STEPKEY">

<strval>

<strval><![CDATA[ NW_Doublestack_OneHost ind ind ind ind 0 0 NW_Onehost_System ind ind ind ind 2 0 NW_CreateDBandLoad ind ind ind ind 10 0 NW_CreateDB ind ind ind ind 0 0 NW_OraDBCheck ind ind ind ind 0 0 NW_OraDBMain ind ind ind ind 0 0 NW_OraDBOBR ind ind ind ind 1 0 NW_OraOBR ind ind

ind ind 5 0 createInstance_oradim]]>

</strval>

</fld>

<fld name="STATUS">

<strval><![CDATA[ERROR]]> <<<<<<<

</strval>

</fld>

replace the entry 'CDATA[ERROR]' by 'CDATA[OK]'

4.- Restart the installation with exactly the same installation options

But, I got a new error and the installation stopped

An error occurred while processing option SAP CRM 7.0 Support Release 1 > Software Life-Cycle Options > System Copy > Oracle > Target System Installation > Central System > Based on AS ABAP > Central System( Last error reported by the step :Caught ESAPinstException in Modulecall: ORA-00000: normal, successful completion Disconnected .). You can now: 
u2022	Choose Retry to repeat the current step. 
u2022	Choose View Log to get more information about the error. 
u2022	Stop the option and continue with it later. 
Log files are written to C:\Program Files/sapinst_instdir/CRM70/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/.

[Former Member]

Hello Rollo,

the answer from SAP sounds very strange for me. Coming back to you initial error messages:

FSL-01027  Account user="ORA_DCT_DBA" does not exist.
INFO[E] 2010-08-26 08:59:07.631
FSL-01027  Account user="ORA_DCT_OPER" does not exist
INFO[E] 2010-08-26 08:59:07.741
FSL-01027  Account user="ORA_DBA" does not exist.

These are of course no users but local user groups. Did you check them on your server?

If they didn't exist simply create them and the installation should continue.

Regards,

Mark

[Former Member]

Thanks for your reply!

The groups are on the server and I have added the <SID>ADM, sapservice<SID> and domain\Administrator to theese groups.

rollo

[Former Member]

problem solved.

There was an issue with the servername, once that was changed, it all worked!

rollo

[Former Member]

The log

An extract of the log
TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Production
System parameter file is E:\oracle\DCT\102\network\admin\listener.ora
Log messages written to E:\oracle\DCT\102\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\DCT.WORLDipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\DCTipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=CRMTEST.europe.com)(PORT=1527)))
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=DCT.WORLD))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Production
Start Date                26-AUG-2010 08:58:49
Uptime                    0 days 0 hr. 0 min. 5 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   E:\oracle\DCT\102\network\admin\listener.ora
Listener Log File         E:\oracle\DCT\102\network\log\listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\DCT.WORLDipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\DCTipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=CRMTEST.europe.com)(PORT=1527)))
Services Summary...
Service "DCT" has 1 instance(s).
  Instance "DCT", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
INFO 2010-08-26 08:58:52.708
Execute step SetListenerModeAuto of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraClient|ind|ind|ind|ind|3|0|NW_OraNetworkSrv|ind|ind|ind|ind|1|0
INFO 2010-08-26 08:58:54.99
Execute step setLocalDefaultContextParameter of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraDbaTools|ind|ind|ind|ind|4|0
INFO 2010-08-26 08:58:54.318
Switched to user: dctadm.
INFO 2010-08-26 08:58:55.740
Execute step checkStepPreconditions of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraDbaTools|ind|ind|ind|ind|4|0
INFO 2010-08-26 08:58:57.443
Execute step prepareDirectories of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraDbaTools|ind|ind|ind|ind|4|0
INFO 2010-08-26 08:58:57.740
Switched to user: dctadm.
INFO 2010-08-26 08:58:59.146
Execute step installInitSidSap of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraDbaTools|ind|ind|ind|ind|4|0
INFO 2010-08-26 08:58:59.459
Switched to user: dctadm.
INFO 2010-08-26 08:58:59.521
Creating file E:\oracle\DCT\102\database\initDCT.sap.
INFO 2010-08-26 08:59:01.162
Execute step installInitSidDba of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraDbaTools|ind|ind|ind|ind|4|0
INFO 2010-08-26 08:59:01.318
Copied file 'C:/Program Files/sapinst_instdir/CRM70/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/INITSID.DBA' to 'E:/oracle/DCT/102/database/initDCT.dba'.
INFO 2010-08-26 08:59:03.178
Execute step extractDbaTools of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraDbaTools|ind|ind|ind|ind|4|0
INFO 2010-08-26 08:59:05.6
Execute step setPermissions of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraDbaTools|ind|ind|ind|ind|4|0
INFO 2010-08-26 08:59:07.241
Execute step SetPermissionsForWindowsDatabaseFolder of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraDbaTools|ind|ind|ind|ind|4|0
INFO[E] 2010-08-26 08:59:07.522
FSL-01027  Account user="ORA_DCT_DBA" does not exist.
INFO[E] 2010-08-26 08:59:07.631
FSL-01027  Account user="ORA_DCT_OPER" does not exist.
INFO[E] 2010-08-26 08:59:07.741
FSL-01027  Account user="ORA_DBA" does not exist.
INFO 2010-08-26 08:59:08.960
Execute step SetPermissionsForWindowsOnInitsidstar of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraDbaTools|ind|ind|ind|ind|4|0
INFO[E] 2010-08-26 08:59:09.241
FSL-01027  Account user="ORA_DCT_DBA" does not exist.
INFO[E] 2010-08-26 08:59:09.350
FSL-01027  Account user="ORA_DCT_OPER" does not exist.
INFO[E] 2010-08-26 08:59:09.460
FSL-01027  Account user="ORA_DBA" does not exist.
INFO[E] 2010-08-26 08:59:09.788
FSL-01027  Account user="Administrators" does not exist.
INFO[E] 2010-08-26 08:59:09.897
FSL-01027  Account user="Administrators" does not exist.
INFO 2010-08-26 08:59:11.382
Execute step runSapdbaroleSql of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraDbaTools|ind|ind|ind|ind|4|0
INFO 2010-08-26 08:59:12.835
Execute step runSapconnroleSql of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraDbaTools|ind|ind|ind|ind|4|0
INFO 2010-08-26 08:59:14.85
Execute step createInstance_oradim of component |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraOBR|ind|ind|ind|ind|5|0
ERROR 2010-08-26 08:59:16.882
FJS-00003  TypeError: rowPar has no properties (in script NW_ABAP_OneHost|ind|ind|ind|ind, line 61644: ???)
ERROR 2010-08-26 08:59:19.836
FCO-00011  The step createInstance_oradim with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraOBR|ind|ind|ind|ind|5|0|createInstance_oradim was executed with status ERROR ( Last error reported by the step :TypeError: rowPar has no properties (in script NW_ABAP_OneHost|ind|ind|ind|ind, line 61644: ???)).
INFO 2010-08-26 08:59:47.510
An error occured and the user decided to retry the current step: "|NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraOBR|ind|ind|ind|ind|5|0|createInstance_oradim".
ERROR 2010-08-26 08:59:50.463
FJS-00003  TypeError: rowPar has no properties (in script NW_ABAP_OneHost|ind|ind|ind|ind, line 61644: ???)
ERROR 2010-08-26 08:59:53.416
FCO-00011  The step createInstance_oradim with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBOBR|ind|ind|ind|ind|1|0|NW_OraOBR|ind|ind|ind|ind|5|0|createInstance_oradim was executed with status ERROR ( Last error reported by the step :TypeError: rowPar has no properties (in script NW_ABAP_OneHost|ind|ind|ind|ind, line 61644: ???)).
WARNING 2010-08-26 09:21:55.346
SAPinst terminated by SIGINT (Ctrl+C)
INFO 2010-08-26 09:21:55.346
Creating file C:\Program Files\sapinst_instdir\.lastInstallationLocation.
INFO 2010-08-26 09:21:56.221
Creating file C:\Program Files\sapinst_instdir\CRM70\LM\COPY\ORA\SYSTEM\CENTRAL\AS-ABAP\__instana_tmp.xml.