cancel
Showing results for 
Search instead for 
Did you mean: 

SAP 4.7EE SR1 200Relase - CJS-00030 Assertion failed Argument listenerOraT

Former Member
0 Kudos

Hi All,

I am installing SAP 4.7EE 200 release on HP UX 11.23, JDK 1.4.2_12 on oracle 10g.

I have sucessfully installed DB using RUNINSTALLER, CI and while installing DB Instance installation i am getting error at Oracle net configuration step.

Log file shows

ERROR 2009-02-04 22:35:49 [iaxxinscbk.cpp:289]

abortInstallation

CJS-00030 Assertion failed: OraNetworkConfigurator.doServerNetworkConfiguration: Argument listenerOraTemplate must point to an existing file.

I tried to configure the listener manually using netmgr but also no luck.

Is there any work around on this.

Mahesh

Accepted Solutions (1)

Accepted Solutions (1)

former_member603052
Contributor
0 Kudos

Hi

I think if u better try to move file /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPRSEUI.TSK.bck file to another location (dump for safe side) and continue installing.

Regards,

Kalyan

Former Member
0 Kudos

Hi,

But there are no files created SAP.TSK.bck. In all the SAP.log's it saying the same error.

I am not getting any clue to proceed further.

Mahesh

markus_doehr2
Active Contributor
0 Kudos

.TSK.bck files should not be moved - but merged with the original content by executing

R3load -merge_only <package>.TSK

If you move them away there will be tables missing after the import.

Markus

Former Member
0 Kudos

Hi Markus,

But in my case SAP*.TSK.bck files have not genrated. Any suggestions please.

Mahesh

markus_doehr2
Active Contributor
0 Kudos

The logfile you posted tell that - was that an old one?

What is your actual problem?

Markus

Former Member
0 Kudos

Hi Marcus,

That is the actuall one which i ran the installation with option retry after creating the index, which i got the error in the log file.

After this i have checked the Some of the SAP Notes , there they suggested the same command suggested by you. But when i am checking for the SAP*.TSK.bck files, i couldnt able to find these files.

Mahesh

markus_doehr2
Active Contributor
0 Kudos

Check at the location posted by sapinst - don´t "search" them somewhere on the filesystem.

If they are not there we can´t help you. I suggest you open an OSS call and let the support have a look on the system what´s wrong.

Markus

markus_doehr2
Active Contributor
0 Kudos

BTW: if you rebooted your machine the logs (everything in /tmp) may have been cleaned. In that case you can´t continue but need to start from the beginning.

Markus

Former Member
0 Kudos

Hi Markus,

Presently i have downloaded all the executables and i am starting the installation from the scartch. I will be posting the messg if i stuck in between. I hope this time it will be sucessfull.

Mahesh

Former Member
0 Kudos

Hi Markus,

Presently i am in Database load phase. I am getting following messg in log files.

How to overcome this messg DbSl Trace: ORA-1403 when accessing table SAPUSER

tail -200 SAPDOKCL.log

/sapmnt/R4U/exe/R3load: START OF LOG: 20090207190317

/sapmnt/R4U/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/sapmnt/R4U/exe/R3load: version R6.40/V1.4

/sapmnt/R4U/exe/R3load -ctf I /mysapdump/EDVDS/exp5/DATA/SAPDOKCL.STR /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/DDLORA.TPL /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPDOKCL.TSK ORA -l /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPDOKCL.log

/sapmnt/R4U/exe/R3load: job completed

/sapmnt/R4U/exe/R3load: END OF LOG: 20090207190317

/sapmnt/R4U/exe/R3load: START OF LOG: 20090207190337

/sapmnt/R4U/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/sapmnt/R4U/exe/R3load: version R6.40/V1.4

/sapmnt/R4U/exe/R3load -dbcodepage 1100 -i /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPDOKCL.cmd -l /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPDOKCL.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

DbSl Trace: my_free: failed to free memory, invalid address 60000000008e1258

(DB) INFO: DOKCLU created

Thank You,

Mahesh

former_member603052
Contributor
0 Kudos

Hi

Is ur installation got stopped at this phase????

Regards,

Kalyan

markus_doehr2
Active Contributor
0 Kudos

this is no problem - the job is "completed" so the table is there.

Markus

Former Member
0 Kudos

Hi Markus,

Yes there is no error message but

DbSl Trace: ORA-1403 when accessing table SAPUSER ..

But i would like why it ORA 1403 is getting. please let me know the reason.

Thanks

Mahesh

markus_doehr2
Active Contributor
0 Kudos

This error message can be ignored.

Check Note 969519 - 6.20/6.40 Patch Collection Installation : Oracle/UNIX

and search for ORA-1403

Markus

Former Member
0 Kudos

Hi Markus,

1. During the Import phase how the sapinst will take cares of the .TSK.

2. I have checked in the sapinst dir first it is creating *.TSK and *.log files after this creating the *.cmd files.

3. In the next step it is trying to get the information from the *.cmd file and creating *.TSK.bck files and creating the objects in the DB level.

Is this how the running installation I would like to know behind the screens so that i can also help others.

Thanks,

Mahesh

markus_doehr2
Active Contributor
0 Kudos

> 1. During the Import phase how the sapinst will take cares of the .TSK.

sapinst does nothing with the .TSK files. sapinst starts migration monitor (migmon.jar) which is a java program. That program takes care of everything.

> 2. I have checked in the sapinst dir first it is creating *.TSK and *.log files after this creating the *.cmd files.

The .TSK files are created from your source packages. TSK means "TASK", there the system knows which tables and indexes to created. Together with the DDL* file in the installation it "mixes" the statements for the specific database.

> 3. In the next step it is trying to get the information from the *.cmd file and creating *.TSK.bck files and creating the objects in the DB level.

After the phase above the .cmd files are created. Then R3load processes are started. You can see the full call to R3load in the logfiles.

To avoid running two R3load processes on the same .TSK file the .TSK files is copied to a .TSK.bck file. From this the migmon.jar knows which package is already running.

Finally the .TSK files are evaluated and checked if they have only "ok" entries. "xeq" is "to be done" and "err" is error.

Markus

Former Member
0 Kudos

Hi Markus,

Thanks for the very valuable information.

Thanks,

Mahesh

Former Member
0 Kudos

Hi Markus,

Very much thankful for your guidance.. I am able to successfully installed 4.7 EE Release 200.

Thank You Sir,

Mahesh

Answers (2)

Answers (2)

markus_doehr2
Active Contributor
0 Kudos

I think you installed the database software too early.

You wrote that you installed but sapinst is searching for the DVDs.

Usually you start with sapinst, give all the parameters and sapinst will start with the installation, created/maintain users and the stops and requests you to install the database. If you installed the database before (as you have apparently done) that is not working.

Since you´re in the early stage of the installation I suggest you start from scratch.

Read the installation guides, the only OS where Oracle is instealled before you start sapinst is Windows.

Markus

Former Member
0 Kudos

Thanks Marcus ... I will start the installation from the scartch as per the suggestion. Is that ok if i keep the users as it is? means not deleting the users just unistalling the DB.

Regards,

Mahesh

markus_doehr2
Active Contributor
0 Kudos

Yes, you can keep the users.

Make sure you also delete /etc/oratab and other Oracle related files.

Markus

Former Member
0 Kudos

Hi Markus,

Now installation is running smoothly. Thanks for your valuable responses.

Mahesh

markus_doehr2
Active Contributor
0 Kudos

Good to hear it works now!

Markus

Former Member
0 Kudos

Hi Marqus,

I have stuck in the ABAP Import phase. I am getting the error in the utmost all the all the log files. I am not getting any clue on this. It saying the files are corrupted. Please check the log file ..

DbSl Trace: my_free: failed to free memory, invalid address 60000000008e9be8 for this i have followed the SAP Note 837410. I have upgrade kernel to 221 patch level.

But for this error

DbSl Trace: ORA-1403 when accessing table SAPUSER..

I have checked this link

http://www.uber-goober.com/forums/showthread.php?t=108838

I have checked the SAP Note 455195 & 709389 but no luck.

But it seems to be i have to again reload the Export DVDs..

Please suggest how to proceed.

/sapmnt/R4U/exe/R3load: START OF LOG: 20090206143252

/sapmnt/R4U/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/sapmnt/R4U/exe/R3load: version R6.40/V1.4

/sapmnt/R4U/exe/R3load -ctf I /mysapdump/ExportDVDS/51030431_4_export/DATA/SAPRSEUI.STR /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/DDLORA.TPL /tmp/s

apinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPRSEUI.TSK ORA -l /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPRSEUI.log

/sapmnt/R4U/exe/R3load: job completed

/sapmnt/R4U/exe/R3load: END OF LOG: 20090206143252

/sapmnt/R4U/exe/R3load: START OF LOG: 20090206143302

/sapmnt/R4U/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/sapmnt/R4U/exe/R3load: version R6.40/V1.4

/sapmnt/R4U/exe/R3load -ctf I /mysapdump/ExportDVDS/51030431_4_export/DATA/SAPRSEUI.STR /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/DDLORA.TPL /tmp/s

apinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPRSEUI.TSK ORA -l /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPRSEUI.log

/sapmnt/R4U/exe/R3load: job completed

/sapmnt/R4U/exe/R3load: END OF LOG: 20090206143302

/sapmnt/R4U/exe/R3load: START OF LOG: 20090206170853

/sapmnt/R4U/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/sapmnt/R4U/exe/R3load: version R6.40/V1.4

/sapmnt/R4U/exe/R3load -dbcodepage 1100 -i /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPRSEUI.cmd -l /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/N

UC/DB/SAPRSEUI.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

(DB) INFO: RSEUINC created

/sapmnt/R4U/exe/R3load: START OF LOG: 20090206170924

/sapmnt/R4U/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/sapmnt/R4U/exe/R3load: version R6.40/V1.4

/sapmnt/R4U/exe/R3load -dbcodepage 1100 -i /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPRSEUI.cmd -l /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/N

UC/DB/SAPRSEUI.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

(TSK) ERROR: file /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPRSEUI.TSK.bck already seems to exist

a previous run may not have been finished cleanly

file /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPRSEUI.TSK possibly corrupted

/sapmnt/R4U/exe/R3load: job finished with 1 error(s)

/sapmnt/R4U/exe/R3load: END OF LOG: 20090206170924

(IMP) INFO: import of RSEUINC completed (1207692 rows)

(DB) INFO: RSEUINC~0 created

(DB) INFO: RSEUINC~1 created

DbSl Trace: my_free: failed to free memory, invalid address 60000000008e9be8

DbSl Trace: my_free: failed to free memory, invalid address 6000000000da08e8

(DB) INFO: disconnected from DB

/sapmnt/R4U/exe/R3load: job completed

/sapmnt/R4U/exe/R3load: END OF LOG: 20090206171106

/sapmnt/R4U/exe/R3load: START OF LOG: 20090206175801

/sapmnt/R4U/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/sapmnt/R4U/exe/R3load: version R6.40/V1.4

/sapmnt/R4U/exe/R3load -dbcodepage 1100 -i /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPRSEUI.cmd -l /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/N

UC/DB/SAPRSEUI.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

/sapmnt/R4U/exe/R3load: START OF LOG: 20090206175801

/sapmnt/R4U/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/sapmnt/R4U/exe/R3load: version R6.40/V1.4

/sapmnt/R4U/exe/R3load -dbcodepage 1100 -i /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPRSEUI.cmd -l /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/N

UC/DB/SAPRSEUI.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

DbSl Trace: my_free: failed to free memory, invalid address 60000000008e9be8

(DB) INFO: disconnected from DB

/sapmnt/R4U/exe/R3load: job completed

/sapmnt/R4U/exe/R3load: END OF LOG: 20090206175801

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

DbSl Trace: my_free: failed to free memory, invalid address 60000000008e9be8

(DB) INFO: disconnected from DB

/sapmnt/R4U/exe/R3load: job completed

/sapmnt/R4U/exe/R3load: END OF LOG: 20090206175801

/sapmnt/R4U/exe/R3load: START OF LOG: 20090206191435

/sapmnt/R4U/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/sapmnt/R4U/exe/R3load: version R6.40/V1.4

/sapmnt/R4U/exe/R3load -dbcodepage 1100 -i /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPRSEUI.cmd -l /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/N

UC/DB/SAPRSEUI.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

/sapmnt/R4U/exe/R3load: START OF LOG: 20090206191435

/sapmnt/R4U/exe/R3load: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#4 $ SAP

/sapmnt/R4U/exe/R3load: version R6.40/V1.4

/sapmnt/R4U/exe/R3load -dbcodepage 1100 -i /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPRSEUI.cmd -l /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/N

UC/DB/SAPRSEUI.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

(TSK) ERROR: Unable to rename /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPRSEUI.TSK to /tmp/sapinst_instdir/R3E47X2/SYSTEM/ABAP/ORA/NUC/DB/SAPRSEU

I.TSK.bck

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

/sapmnt/R4U/exe/R3load: job finished with 1 error(s)

/sapmnt/R4U/exe/R3load: END OF LOG: 20090206191436

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

DbSl Trace: my_free: failed to free memory, invalid address 60000000008e9be8

(DB) INFO: disconnected from DB

/sapmnt/R4U/exe/R3load: job completed

/sapmnt/R4U/exe/R3load: END OF LOG: 20090206191436

markus_doehr2
Active Contributor
0 Kudos

Check the file

sapinst_dev:log

which file is it trying to open?

Markus

Former Member
0 Kudos

Hi Markus,

When i have configured the listener manually it is replacing the listener.ora file and after that what creating the listener.ora its getting the error.

sapinst.log

PHASE 2009-02-04 21:45:46

Create versions of default profile, instance profile and start profile

INFO 2009-02-04 21:45:48

All file system node operations of table t_SAPComponent_Profiles_FORMS_SHARED processed successfully.

INFO 2009-02-04 21:45:50

Adapt operation t_SAPComponent_Profiles_SHARED processed successfully.

INFO 2009-02-04 21:45:52

All file system node operations of table t_SAPComponent_Profiles_PERMISSIONS_SHARED processed successfully.

ERROR 2009-02-04 21:45:57

CJS-00030 Assertion failed: OraNetworkConfigurator.doServerNetworkConfiguration: Argument listenerOraTemplate must point to an existing file.

ERROR 2009-02-04 22:20:47

CJS-00030 Assertion failed: OraNetworkConfigurator.doServerNetworkConfiguration: Argument listenerOraTemplate must point to an existing file.

ERROR 2009-02-04 22:24:41

CJS-00030 Assertion failed: OraNetworkConfigurator.doServerNetworkConfiguration: Argument listenerOraTemplate must point to an existing file.

INFO 2009-02-04 22:31:06

Copying file /oracle/R4U/102_64/network/admin/listener.ora to: /oracle/R4U/102_64/network/admin/listener.3.ora.

INFO 2009-02-04 22:31:06

Creating file /oracle/R4U/102_64/network/admin/listener.3.ora.

INFO 2009-02-04 22:31:06

Removing file /oracle/R4U/102_64/network/admin/listener.ora.

ERROR 2009-02-04 22:31:06

CJS-00030 Assertion failed: OraNetworkConfigurator.doServerNetworkConfiguration: Argument listenerOraTemplate must point to an existing file.

sapinst_dev.log

TRACE [iaxxcwalker.cpp:296]

CDomWalker::processStep()

Executing installation step SAPSYSTEM_DB|ind|ind|ind|ind|ind|0|SAPSYSTEM|ind|ind|ind|ind|ind|0|SAPComponent|ind|ind|ind|ind|ind|0|DatabaseClient|ind|ind|ora|ind|ind|0|DatabaseNetworkConfiguration|ind|ind|ora|ind|ind|0|doNetworkConfiguration

TRACE [iaxxejsexp.cpp:208]

EJS_Installer::writeTraceToLogBook()

OraBackRel.isBackRelClient dbClientVersion: 920

ERROR 2009-02-04 22:24:41 [iaxxinscbk.cpp:289]

abortInstallation

CJS-00030 Assertion failed: OraNetworkConfigurator.doServerNetworkConfiguration: Argument listenerOraTemplate must point to an existing file.

markus_doehr2
Active Contributor
0 Kudos

sapinst is no looking for listener.ora but for the TEMPLATE of that file.

Do you have the file

TNSNAME.ORA in directory <installation master>/SAPINST/UNIX/COMMON/INSTALL/ORA?

Markus

Former Member
0 Kudos

Hi Markus,

It was there but it is in small charcters so its not able to find the file. After changing to upper charcterstics it went through.

But i am stuck at phase Extract Databse Server Archives.

sapinst.log

INFO 2009-02-05 17:22:48

Authorizations set for /oracle/R4U/sapdata1/sysaux_1.

INFO 2009-02-05 17:22:48

Permission of file system node /oracle/R4U/sapdata1/sysaux_1 with type DIRECTORY to (orar4u,USER,=rwxo)(dba,GROUP,=rxg)(everyone,GROUP,=rx) changed successfully.

INFO 2009-02-05 17:22:48

All file system node operations of table tORA_SapdataNodes processed successfully.

INFO 2009-02-05 17:22:51

All file system node operations of table tORA_DatabaseServerNodes processed successfully.

INFO 2009-02-05 17:22:51

All file system node operations of table tORA_SapdataNodes processed successfully.

ERROR 2009-02-05 17:22:54

MDB-06020 File not found: [no oracle rdbms file found].

sapinst_dev.log

TRACE [iaxxejsexp.cpp:208]

EJS_Installer::writeTraceToLogBook()

extractRdbmsCDs start, dbSid: R4U

TRACE [iaxxejsexp.cpp:208]

EJS_Installer::writeTraceToLogBook()

extract archive: /mysapdump/Oracle_102_1/OR110264.SAR

ERROR 2009-02-05 17:32:00 [iaxxinscbk.cpp:289]

abortInstallation

MDB-06020 File not found: [no oracle rdbms file found].

TRACE [iaxxejsbas.hpp:270]

EJS_Base::dispatchFunctionCall()

JS Callback has thrown std::ESAPinstException: ESAPinstException: error text undefined

TRACE [iaxxcwalker.cpp:301]

CDomWalker::processStep()

Mahesh