Skip to Content
0
Former Member
Aug 23, 2007 at 10:33 PM

SAPinst export of Oracle database

544 Views

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