SAPinst export of Oracle database

[Former Member]

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

[Former Member · Accepted solution]

The sapinst was started with root and sapadm.

The export on command line with sapadm.

Gidion

[markus_doehr2 · Accepted solution]

I think that's the problem.

"sapadm" has apparently not the correct environment set.

Can you try as user "accadm"?

--

Markus

[Former Member · Accepted solution]

Think i was not clear enough.

Manually executing the export command with userID sapadm works.

It is possible to set another userID via an variable.

Do you know which variable this is ?

Gidion

[markus_doehr2 · Accepted solution]

The system takes the value from the instance name, so if you use ACC as instance name, the user to be used is "accadm".

I don't know, why the system chooses sapadm instead.

--

Markus

[Former Member]

The userID sapadm is in directory /home/home1/sapadm/accadm

The userID accadm is in directory /home/home1/sapadm/

It's SAP HR system, so assume the reason to build this has to do with security.

When manually executing the export command with sapadm on command line and correct exe directory then this works.

Think i got problems with connecting to the database, because of log of R3ldctlExport.log.

Gidion

[markus_doehr2]

Which user did you give when sapinst asked you? accadm? or sapadm?

I have to admit, I never had such kind of problems you're dealing with and it's pretty difficult to assist...

--

Markus

[Former Member]

The file R3ldctl.log is empty.

Here's the log of R3ldctlExport.log:

DbSl Trace: OCI-call 'OCIEnvCreate' failed: rc = -1

DbSl Trace: OCI-call 'OCIErrorGet' failed: rc = -2

ERROR: DbSlConnect rc= 99

DbSl Trace: OCI-call 'OCIHandleAlloc' failed: rc = -2

DbSl Trace: CONNECT failed with sql error '-2'

DbSl Trace: OCI-call 'OCIErrorGet' failed: rc = -2

DbSl Trace: OCI-call 'OCIHandleAlloc' failed: rc = -2

DbSl Trace: CONNECT failed with sql error '-2'

DbSl Trace: OCI-call 'OCIErrorGet' failed: rc = -2

Gidion

[markus_doehr2]

The user who's executing the export is usually <sid>adm, I don't know what the user "sapadm" is for.

Can you execute that command as use accadm on command line manually?

--

Markus

[Former Member]

Default value at “Location of Instance Files” is /sapmnt where the additional information provides “The instance will be installed under /usr/sap/<SAPSID>/.... Common directories will be linked to <SAP System Mount Directory>/<SAPSID>/....”.

Based on this info I used the value "/usr/sap/ACC", but now adjusted and restarted the sapinst with new value /usr/sap for instance directory.

Now i receive the before error message again:

MOS-01012 PROBLEM: '/usr/sap/ACC/exe/R3ldctl -l ./R3ldctlExport.log -p /mnt/sapexport/exp/DATA/ ' returned with '2' which is not a defined as a success code.

In the thread it is advised to start the export on commandline with <SID>adm.

This looks to be starting well with userID sapadm, but normally the SAPinst has to be started with root.

In my SAP system there's a userID sapadm and accadm, so when SAPinst starts with root then it switched during the export to different users.

My <SID> is ACC so that i got the feeling the SAPinst is using the userID accadm and not sapadm.

Is it possible to set another userID via an variable ?

Gidion

[markus_doehr2]

sapinst does the necessary switch to the user.

What do you see in R3ldctlExport.log and R3ldctl.log?

--

Markus

[Former Member]

When start the SAPINST with <sid>adm and adjust the permissions and ownership on SAPINST_DIR and below directories i get the message:

MUT-02044 The following paths expected but not found in the library path environment variable (SHLIB_PATH) /usr/sap/ACC/ACC/exe/.

As you could see in the environment variables, there's no value for /usr/sap/ACC/ACC/exe/ set.

Already tried with symbolic links and adjusting the environment variable SHLIB_PATH, but shouldn't SAPINST look for /usr/sap/ACC/exe/run ?

Where does the SAPINST is getting the variable to check for /usr/sap/ACC/ACC/exe/ ?

Gidion

[markus_doehr2]

I think it´s because you gave "/usr/sap/ACC" when sapinst asked for the instance directory (instead of /usr/sap).

--

Markus

[Former Member]

Fully agree, environment also confuses me

Confirm for ORACLE_HOME and ORA_NLS33 parameter.

Here's the environment variables for oracle:

oraacc:

joule:oraacc 22> env | grep ORA

dbms_type=ORA

ORACLE_PSRV=ACC

ORACLE_SID=ACC

ORACLE_BASE=/opt/oracle

ORACLE_HOME=/opt/oracle/92064

ORA_NLS33=/opt/oracle/92064/ocommon/nls/admin/data

sapadm:

joule:sapadm> env | grep ORA

ORACLE_PSRV=ACC

ORACLE_BASE=/oracle

ORACLE_SID=ACC

ORA_NLS33=/opt/oracle/92064/ocommon/nls/admin/data

ORACLE_HOME=/opt/oracle/92064

dbms_type=ORA

accadm:

joule:accadm 21> env | grep ORA

dbms_type=ORA

ORACLE_PSRV=ACC

ORACLE_SID=ACC

ORACLE_HOME=/opt/oracle/92064

ORACLE_BASE=/oracle

ORA_NLS33=/opt/oracle/92064/ocommon/nls/admin/data

[Former Member]

Markus, you're correct.

I checked the system: status and machine type field to be able to see 32 or 64 bit (with Linux ia64 clearly to see if 64 bit).

The file /usr/sap/<SID>/SYS/exe/run/R3load gives:

joule:oraacc 25> ./R3load -v

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

This is ./R3load version R6.20/V1.2

Rgds,

Gidion

[markus_doehr2]

Oh yeah - you are still using a 6.20 kernel which is now unsupported for more than 2 years (see Note 803429 - Desupport 6.20 kernel)

To get the copy process smooth I really suggest:

- upgrade to the latest download compatible kernel (6.40)

- upgrade R3load, R3ldctl and R3szchk additionally to the lastest versions

After that you could try to export the database using R3load, if that does not work, I suggest upgrading your system to an actual Oracle patchset.

You can try, of course, to use your current version but keep in mind that the tools, especially R3load, are VERY old and you may or may not be able to export the database successfully. The new R3load contains many, many fixes that you might need to export.

--

Markus

[Former Member]

Hello Markus,

The kernel is upgraded to 6.40 and could start the export of the database.

saproot@joule:/usr/sap/ACC/ACC/exe# ./R3load -v

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

This is ./R3load version R6.40/V1.4

Compiled Mar 17 2007 01:09:10

Now i get the error message:

ERROR 2007-09-07 10:11:24

MOS-01012 PROBLEM: '/usr/sap/ACC/ACC/exe/R3ldctl -l ./R3ldctlExport.log -p /mnt/sapexport/exp/DATA/ ' returned with '2' which is not a defined as a success code.

The file R3ldctl.log is empty.

Only related message i could find is Note 516246 - INST: System Copy for SAP Systems based on SAP Web AS 6.20.

SOLUTION:

1. Exit SAPINST.

2. Set the environment variable HOME to the home directory of the SAP system administrator <sapsid>adm (for example, with command

setenv HOME /home/<sid>adm

if the home directory of the SAP system administrator is '/home' and '<sapsid>' is the SAP system ID (in lower-case letters)).

3. Start SAPinst again.

This is for an SAP DB / MaxDB and i got Oracle and also i start sapinst with root.

Rgds,

Gidion

[Former Member]

Thinking that the problem is related to environment variables, here's the result of command “env | grep ACC” for following users:

root:

SHLIB_PATH=/opt/oracle/92064/lib:/usr/sap/ACC/ACC/exe/

sapadm:

SHLIB_PATH=/opt/oracle/92064/lib:/usr/sap/ACC/SYS/exe/run

ORACLE_PSRV=ACC

PATH=/opt/oracle/92064/bin:/usr/sap/ACC/SYS/exe/run:/usr/bin:/usr/local/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/fc/bin:/opt/fcms/bin:/opt/upgrade/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/hparray/bin:/opt/prm/bin:/opt/perf/bin:/opt/OV/bin/OpC:/opt/ignite/bin:/opt/hpnp/bin:/opt/samba/bin:/opt/sudo/bin:/opt/sudo/sbin:/opt/ssh/bin:/opt/networker/bin:/usr/sbin/stm/uut/bin/progs:/opt/cfg2html:/usr/sbin/diag/contrib:/opt/hpnpl//bin:/opt/findutils/bin:/opt/a2ps/bin:/opt/OV/bin:/opt/graphics/common/bin:/opt/resmon/bin:/opt/perl/bin

dbs_ora_tnsname=ACC

ORACLE_SID=ACC

DB_SID=ACC

DIR_LIBRARY=/usr/sap/ACC/SYS/exe/run

SAPDATA_HOME=/oracle/acc/ACC

SAPSYSTEMNAME=ACC

accadm:

joule:accadm 21> env | grep ACC

PATH=/opt/oracle/92064/bin:.:/home/home1/sapadm/accadm:/usr/sap/ACC/SYS/exe/run:/usr/bin:/usr/local/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/fc/bin:/opt/fcms/bin:/opt/upgrade/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/hparray/bin:/opt/prm/bin:/opt/perf/bin:/opt/OV/bin/OpC:/opt/ignite/bin:/opt/hpnp/bin:/opt/samba/bin:/opt/sudo/bin:/opt/sudo/sbin:/opt/ssh/bin:/opt/networker/bin:/usr/sbin/stm/uut/bin/progs:/opt/cfg2html:/usr/sbin/diag/contrib:/opt/hpnpl//bin:/opt/findutils/bin:/opt/a2ps/bin:/opt/OV/bin:/opt/graphics/common/bin:/opt/resmon/bin:/opt/perl/bin

SAPSYSTEMNAME=ACC

DIR_LIBRARY=/usr/sap/ACC/SYS/exe/run

SHLIB_PATH=/opt/oracle/92064/lib:/usr/sap/ACC/SYS/exe/run

dbs_ora_tnsname=ACC

ORACLE_PSRV=ACC

ORACLE_SID=ACC

DB_SID=ACC

SAPDATA_HOME=/oracle/acc/ACC

oraacc

PATH=/opt/oracle/92064/bin:/opt/oracle/92064/bin:/opt/oracle/92064/bin:/opt/oracle/92064/bin:/opt/oracle/92064/bin:.:/home/home1/oraacc:/appl/acc/sap/ACC/exe:/usr/bin:/usr/local/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/fc/bin:/opt/fcms/bin:/opt/upgrade/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/hparray/bin:/opt/prm/bin:/opt/perf/bin:/opt/OV/bin/OpC:/opt/ignite/bin:/opt/hpnp/bin:/opt/samba/bin:/opt/sudo/bin:/opt/sudo/sbin:/opt/ssh/bin:/opt/networker/bin:/usr/sbin/stm/uut/bin/progs:/opt/cfg2html:/usr/sbin/diag/contrib:/opt/hpnpl//bin:/opt/findutils/bin:/opt/a2ps/bin:/opt/OV/bin:/opt/graphics/common/bin:/opt/resmon/bin:/opt/perl/bin

SAPSYSTEMNAME=ACC

DIR_LIBRARY=/appl/acc/sap/ACC/exe

SHLIB_PATH=/appl/acc/sap/ACC/exe

ORACLE_PSRV=ACC

ORACLE_SID=ACC

SAPDATA_HOME=/oracle/acc/ACC

[markus_doehr2]

Admittely, your environment looks really confusing for me

ORACLE_HOME points to /opt/oracle/92064?

Do you have any ORA_NLS33 parameters set (for <SID>adm)?

--

Markus

[Former Member]

When executing "file $ORACLE_HOME/bin/oracle" i get the message:

/opt/oracle/92064/bin/oracle: ELF-64 executable object file - PA-RISC 2.0 (LP64)

When executing "file /usr/sap/<SID/exe/R3load" i get the message "cannot open".

Under the directory /usr/sap/<SID> I got the directories D05, DVEBMGS04 and SYS, but no exe ?

Which issue will be solved by upgrading from Oracle 9.2.0.3.0 to 9.2.0.8 ?

Rgds,

Gidion

[markus_doehr2]

As you see, your Oracle is a 64bit file so your assumption to use 32bit software is wrong.

What gives

file /usr/sap/<SID>/SYS/exe/run/R3load

Should have the same as the Oracle executable.

--

Markus

[Former Member]

Here's the log file /mnt/sapexport/sapinst/SAPAPPL0.log:

Thu Aug 23 22:38:32 2007

MtxInit: 0 0 0

(GSI) INFO: instno = "0420000536"

(TSK) ERROR: file /mnt/sapexport/sapinst/SAPAPPL0.TSK.bck already seems to exist

a previous run may not have been finished cleanly

file /mnt/sapexport/sapinst/SAPAPPL0.TSK possibly corrupted

/appl/acc/sap/ACC/exe/R3load: job finished with 1 error(s)

/appl/acc/sap/ACC/exe/R3load: END OF LOG: 20070823223832

Removed the export directory (everything under /mnt/sapexport/exp) and ./sapinst restarted,but get the message:

(DB) INFO: connected to DB

(TFH) ERROR: Unable to open /mnt/sapexport/exp/DATA/SAPCLUST.TOC

(TFH) ERROR: OS error message: No such file or directory

/appl/acc/sap/ACC/exe/R3load: job finished with 1 error(s)

/appl/acc/sap/ACC/exe/R3load: END OF LOG: 20070828094216

Assume also to remove everything in directory /mnt/sapexport/sapinst, but then also the sapinst is removed.

Is it an option to remove only the TSK and LOG files ?

When I tried this i got the message:

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 20070724

(DB) INFO: connected to DB

(TFH) ERROR: Unable to open /mnt/sapexport/exp/DATA/SAPZCA_D.TOC

(TFH) ERROR: OS error message: Permission denied

/appl/acc/sap/ACC/exe/R3load: job finished with 1 error(s)

/appl/acc/sap/ACC/exe/R3load: END OF LOG: 20070828101101

root@joule:/mnt/sapexport/sapinst# whoami

root

How can i get the permission denied when i logon with root ?

Made a copy of the /sapinst directory and put in the old situation, so removed files are back and rerun ./sapinst which encountered an error:

MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPZCA_D.log

ERROR 2007-08-28 14:17:46

FJS-00012 Error when executing script.

In the log file /mnt/sapexport/sapinst/SAPZCA_D.log the following message appears:

(DB) INFO: connected to DB

(TFH) ERROR: Unable to open /mnt/sapexport/exp/DATA/SAPZCA_D.TOC

(TFH) ERROR: OS error message: Permission denied

/appl/acc/sap/ACC/exe/R3load: job finished with 1 error(s)

/appl/acc/sap/ACC/exe/R3load: END OF LOG: 20070828101101

Downloaded again the DVD 1019679 “CD SAP R3E 4.7x1.10 SR1 SAPINST ORACLE”, but in the HPUX is only a 64 bit version and 32 bit is only for LINUX.

I have HP-UX B.11.00 U 9000/800 for 32 bit, does this mean i got to use the linux version ?

When i start the SAPCAR in any of both directories i get the following message "sh: ./SAPCAR: Execute permission denied." with root ?

Rgds,

Gidion

[markus_doehr2]

Are you really sure you're running a 32bit Oracle on HP-UX 11.00?

Check as user ora<SID> with the command

[code]file $ORACLE_HOME/bin/oracle[/code]

and

[code]file /usr/sap/<SID/exe/R3load[/code]

You can't run a Linux binary on HP-UX.

I highly suggest upgrading your Oracle release...

--

Markus

[andreas_herzog]

<b>(TSK) ERROR: object CROSS not in /mnt/sapexport/exp/DATA/SAPSSRC.STR</b>

-> the taskfile for table class SAPSSTRC includes an object named CROSS which cannot be found in the database content

-> you should edit the TSK-file, for example by <b>adding an IGN</b> at the end of the corresponding line

and

-> re-start the export using sapinst

also have a look at file <b>R3szchkExport.log</b> if there are any other tables not found in the database...

GreetZ, AH

[markus_doehr2]

You are using a VERY old patchset for your database... (9.2.0.8 is actual)

Your logfile says:

MSC-01015 Process finished with error(s), check log file /mnt/sapexport/sapinst/SAPAPPL0.log

Did you check the content of that logfile?

If you want to start the export from scratch, delete the directory /mnt/sapexport/sapinst and restart sapinst.

--

Markus