I want to export the database of a SAP HR 4.7/Oracle 9.2.0.3.0/HP-UX instance with the sapinst tools and am running into issues.
The view log has the following content:
PHASE 2007-08-23 22:37:49
SAP Web Application Server
PHASE 2007-08-23 22:37:49
Request common parameters of SAP System
PHASE 2007-08-23 22:37:56
Prepare database export
PHASE 2007-08-23 22:37:57
Database Export
PHASE 2007-08-23 22:37:58
Database Load
INFO 2007-08-23 22:38:04
Copying file /mnt/sapexport/sapinst/keydb.xml to: /mnt/sapexport/sapinst/keydb.4.xml.
INFO 2007-08-23 22:38:04
Creating file /mnt/sapexport/sapinst/keydb.4.xml.
WARNING 2007-08-23 22:38:12
Return value of function getspnam(accadm) is NULL.
ERROR 2007-08-23 22:38:50
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPAPPL0.log
ERROR 2007-08-23 22:38:50
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPAPPL1.log
ERROR 2007-08-23 22:38:50
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPAPPL2.log
ERROR 2007-08-23 22:39:31
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPCATSD.log
ERROR 2007-08-23 22:39:31
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPCLUST.log
ERROR 2007-08-23 22:40:50
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPDSYS2.log
ERROR 2007-08-23 22:40:50
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPDSYS3.log
ERROR 2007-08-23 22:41:30
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPP05T1.log
ERROR 2007-08-23 22:42:09
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPPA001.log
ERROR 2007-08-23 22:42:09
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPPA201.log
ERROR 2007-08-23 22:42:09
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPPCL2.log
ERROR 2007-08-23 22:42:09
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPPCL4.log
ERROR 2007-08-23 22:42:47
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPPPOIX.log
ERROR 2007-08-23 22:42:47
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPREPOS.log
ERROR 2007-08-23 22:42:47
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPREPOT.log
ERROR 2007-08-23 22:43:20
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPSDIC.log
ERROR 2007-08-23 22:44:08
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPSSEXC.log
ERROR 2007-08-23 22:44:08
MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPSSRC.log
ERROR 2007-08-23 22:45:51
FJS-00012 Error when executing script.
In the file /mnt/sapexport/sapinst/SAPSSRC.log:
/appl/acc/sap/ACC/exe/R3load: sccsid @(#) $Id: //bas/620/src/R3ld/R3load/R3ldmain.c#12 $ SAP
/appl/acc/sap/ACC/exe/R3load: version R6.20/V1.2
/appl/acc/sap/ACC/exe/R3load -ctf E /appl/acc/sap/DATA/SAPSSRC.STR /appl/acc/sap/DB/DDLORA.TPL / mnt/sapexport/sapinst/SAPSSRC.TSK ORA -l /mnt/sapexport/sapinst/SAPSSRC.log
/appl/acc/sap/ACC/exe/R3load: job completed
/appl/acc/sap/ACC/exe/R3load: END OF LOG: 20070509202920
/appl/acc/sap/ACC/exe/R3load: START OF LOG: 20070821153824
/appl/acc/sap/ACC/exe/R3load: sccsid @(#) $Id: //bas/620/src/R3ld/R3load/R3ldmain.c#12 $ SAP
/appl/acc/sap/ACC/exe/R3load: version R6.20/V1.2
/appl/acc/sap/ACC/exe/R3load -datacodepage 1100 -e /mnt/sapexport/sapinst/SAPSSRC.cmd -l /mnt/sa pexport/sapinst/SAPSSRC.log -stop_on_error
DbSl Trace: Got ORACLE_HOME=/oracle/ACC/920_64 from environment
DbSl Trace: Client NLS settings: AMERICAN_AMERICA.WE8DEC
DbSl Trace: Got TNS_ADMIN=/opt/oracle/92064/network/admin from environment
DbSl Trace: Logon as OPS$-user to get SAPR3's password
DbSl Trace: Connecting as /@ACC on connection 0 ...
DbSl Trace: Attaching to DB Server ACC (con_hdl=0,svchp=8000000100d2cb18,svrhp=8000000100d2c808)
DbSl Trace: Starting user session (con_hdl=0,svchp=8000000100d2cb18,srvhp=8000000100d2c808,usrhp =8000000100e20518)
DbSl Trace: Now I'm connected to ORACLE
DbSl Trace: Got SAPR3's password from OPS$-user
DbSl Trace: Disconnecting from connection 0 ...
DbSl Trace: Closing user session (con_hdl=0,svchp=8000000100d2cb18,usrhp=8000000100e20518)
DbSl Trace: Now I'm disconnected from ORACLE
DbSl Trace: Connecting as SAPR3/<pwd>@ACC on connection 0 ...
DbSl Trace: Starting user session (con_hdl=0,svchp=8000000100d2cb18,srvhp=8000000100d2c808,usrhp =8000000100e20518)
DbSl Trace: Now I'm connected to ORACLE
DbSl Trace: Database NLS settings: AMERICAN_AMERICA.WE8DEC
DbSl Trace: Database instance ACC is running on joule with ORACLE version 9.2.0.3.0 since 200707 24
(DB) INFO: connected to DB
(GSI) INFO: dbname = "ACC20070622080646 "
(GSI) INFO: vname = "ORACLE "
(GSI) INFO: hostname = "joule "
(GSI) INFO: sysname = "HP-UX"
(GSI) INFO: nodename = "joule"
(GSI) INFO: release = "B.11.00"
(GSI) INFO: version = "U"
(GSI) INFO: machine = "9000/800"
Tue Aug 21 15:38:25 2007
MtxInit: 0 0 0
(GSI) INFO: instno = "0420000536"
(EXP) TABLE: "ABTREE"
(EXP) TABLE: "AKB_CHKCONF"
(EXP) TABLE: "AKB_INDX"
(EXP) TABLE: "APTREE"
(EXP) TABLE: "APTREET"
(EXP) TABLE: "CAPTREE"
(EXP) TABLE: "CAPTREET"
(EXP) TABLE: "CCCEXIT"
(EXP) TABLE: "CCCINFO"
(EXP) TABLE: "CLMCUS"
(EXP) TABLE: "CONTCOMP"
(EXP) TABLE: "CONTCOMPT"
(EXP) TABLE: "CONTCOMPX"
(EXP) TABLE: "CONTCOMPXT"
(TSK) ERROR: object CROSS not in /mnt/sapexport/exp/DATA/SAPSSRC.STR
DbSl Trace: Disconnecting from connection 0 ...
DbSl Trace: Closing user session (con_hdl=0,svchp=8000000100d2cb18,usrhp=8000000100e20518)
DbSl Trace: Detaching from DB Server (con_hdl=0,svchp=8000000100d2cb18,srvhp=8000000100d2c808)
DbSl Trace: Now I'm disconnected from ORACLE
(DB) INFO: disconnected from DB
/appl/acc/sap/ACC/exe/R3load: job finished with 1 error(s)
/appl/acc/sap/ACC/exe/R3load: END OF LOG: 20070821153827
/appl/acc/sap/ACC/exe/R3load: START OF LOG: 20070823214820
/appl/acc/sap/ACC/exe/R3load: sccsid @(#) $Id: //bas/620/src/R3ld/R3load/R3ldmain.c#12 $ SAP
/appl/acc/sap/ACC/exe/R3load: version R6.20/V1.2
/appl/acc/sap/ACC/exe/R3load -datacodepage 1100 -e /mnt/sapexport/sapinst/SAPSSRC.cmd -l /mnt/sa pexport/sapinst/SAPSSRC.log -stop_on_error
DbSl Trace: Got ORACLE_HOME=/oracle/ACC/920_64 from environment
DbSl Trace: Client NLS settings: AMERICAN_AMERICA.WE8DEC
DbSl Trace: Got TNS_ADMIN=/opt/oracle/92064/network/admin from environment
DbSl Trace: Logon as OPS$-user to get SAPR3's password
DbSl Trace: Connecting as /@ACC on connection 0 ...
DbSl Trace: Attaching to DB Server ACC (con_hdl=0,svchp=8000000100d2cb18,svrhp=8000000100d2c808)
DbSl Trace: Starting user session (con_hdl=0,svchp=8000000100d2cb18,srvhp=8000000100d2c808,usrhp =8000000100dfb940)
DbSl Trace: Now I'm connected to ORACLE
DbSl Trace: Got SAPR3's password from OPS$-user
DbSl Trace: Disconnecting from connection 0 ...
DbSl Trace: Closing user session (con_hdl=0,svchp=8000000100d2cb18,usrhp=8000000100dfb940)
DbSl Trace: Now I'm disconnected from ORACLE
DbSl Trace: Connecting as SAPR3/<pwd>@ACC on connection 0 ...
DbSl Trace: Starting user session (con_hdl=0,svchp=8000000100d2cb18,srvhp=8000000100d2c808,usrhp =8000000100dfb940)
DbSl Trace: Now I'm connected to ORACLE
DbSl Trace: Database NLS settings: AMERICAN_AMERICA.WE8DEC
DbSl Trace: Database instance ACC is running on joule with ORACLE version 9.2.0.3.0 since 200707 24
(DB) INFO: connected to DB
(GSI) INFO: dbname = "ACC20070622080646 "
(GSI) INFO: vname = "ORACLE "
(GSI) INFO: hostname = "joule "
(GSI) INFO: sysname = "HP-UX"
(GSI) INFO: nodename = "joule"
(GSI) INFO: release = "B.11.00"
(GSI) INFO: version = "U"
(GSI) INFO: machine = "9000/800"
Thu Aug 23 21:48:23 2007
MtxInit: 0 0 0
(GSI) INFO: instno = "0420000536"
(TSK) ERROR: object CROSS not in /mnt/sapexport/exp/DATA/SAPSSRC.STR
DbSl Trace: Disconnecting from connection 0 ...
DbSl Trace: Closing user session (con_hdl=0,svchp=8000000100d2cb18,usrhp=8000000100dfb940)
DbSl Trace: Detaching from DB Server (con_hdl=0,svchp=8000000100d2cb18,srvhp=8000000100d2c808)
DbSl Trace: Now I'm disconnected from ORACLE
(DB) INFO: disconnected from DB
/appl/acc/sap/ACC/exe/R3load: job finished with 1 error(s)
/appl/acc/sap/ACC/exe/R3load: END OF LOG: 20070823214823
/appl/acc/sap/ACC/exe/R3load: START OF LOG: 20070823224323
/appl/acc/sap/ACC/exe/R3load: sccsid @(#) $Id: //bas/620/src/R3ld/R3load/R3ldmain.c#12 $ SAP
/appl/acc/sap/ACC/exe/R3load: version R6.20/V1.2
/appl/acc/sap/ACC/exe/R3load -datacodepage 1100 -e /mnt/sapexport/sapinst/SAPSSRC.cmd -l /mnt/sapexport/sapinst/SAPSSRC.log -stop_on_error
DbSl Trace: Got ORACLE_HOME=/oracle/ACC/920_64 from environment
DbSl Trace: Client NLS settings: AMERICAN_AMERICA.WE8DEC
DbSl Trace: Got TNS_ADMIN=/opt/oracle/92064/network/admin from environment
DbSl Trace: Logon as OPS$-user to get SAPR3's password
DbSl Trace: Connecting as /@ACC on connection 0 ...
DbSl Trace: Attaching to DB Server ACC (con_hdl=0,svchp=8000000100d2cb18,svrhp=8000000100d2c808)
DbSl Trace: Starting user session (con_hdl=0,svchp=8000000100d2cb18,srvhp=8000000100d2c808,usrhp =8000000100dfb940)
DbSl Trace: Now I'm connected to ORACLE
DbSl Trace: Got SAPR3's password from OPS$-user
DbSl Trace: Disconnecting from connection 0 ...
DbSl Trace: Closing user session (con_hdl=0,svchp=8000000100d2cb18,usrhp=8000000100dfb940)
DbSl Trace: Now I'm disconnected from ORACLE
DbSl Trace: Connecting as SAPR3/<pwd>@ACC on connection 0 ...
DbSl Trace: Starting user session (con_hdl=0,svchp=8000000100d2cb18,srvhp=8000000100d2c808,usrhp =8000000100dfb940)
DbSl Trace: Now I'm connected to ORACLE
DbSl Trace: Database NLS settings: AMERICAN_AMERICA.WE8DEC
DbSl Trace: Database instance ACC is running on joule with ORACLE version 9.2.0.3.0 since 200707 24
(DB) INFO: connected to DB
(GSI) INFO: dbname = "ACC20070622080646 "
(GSI) INFO: vname = "ORACLE "
(GSI) INFO: hostname = "joule "
(GSI) INFO: sysname = "HP-UX"
(GSI) INFO: nodename = "joule"
(GSI) INFO: release = "B.11.00"
(GSI) INFO: version = "U"
(GSI) INFO: machine = "9000/800"
Thu Aug 23 22:43:33 2007
MtxInit: 0 0 0
(GSI) INFO: instno = "0420000536"
(TSK) ERROR: object CROSS not in /mnt/sapexport/exp/DATA/SAPSSRC.STR
DbSl Trace: Disconnecting from connection 0 ...
DbSl Trace: Closing user session (con_hdl=0,svchp=8000000100d2cb18,usrhp=8000000100dfb940)
DbSl Trace: Detaching from DB Server (con_hdl=0,svchp=8000000100d2cb18,srvhp=8000000100d2c808)
DbSl Trace: Now I'm disconnected from ORACLE
(DB) INFO: disconnected from DB
/appl/acc/sap/ACC/exe/R3load: job finished with 1 error(s)
/appl/acc/sap/ACC/exe/R3load: END OF LOG: 20070823224334
Also several times this message:
joule:/mnt/sapexport/sapinst> ./sapinst
WARNING The control document control.xml could not be created. Maybe your control file is inaccessible.
ERROR The control document based on control.xml could not be created.
Is there a way to stop the started export and start all over with the export via sapinst ?
Thanks in advance for any help.
Regards,
Gidion