cancel
Showing results for 
Search instead for 
Did you mean: 

I am getting the following error at Import ABAP phase ...

Former Member
0 Kudos

Dear All,

I am getting the following error at Import ABAP phase when performing the system copy function (Import) via ./sapinst ( OS - LINUX and DATABASE-ORACLE 10g)...

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

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

/usr/sap/RXT/SYS/exe/run/R3load: START OF LOG: 20090102154030

/usr/sap/RXT/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP

/usr/sap/RXT/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Apr 1 2006 00:08:29

/usr/sap/RXT/SYS/exe/run/R3load -testconnect

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12541

DbSl Trace: CONNECT failed with sql error '12541'

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12541

DbSl Trace: CONNECT failed with sql error '12541'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12541

DbSl Trace: CONNECT failed with sql error '12541'

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12541

DbSl Trace: CONNECT failed with sql error '12541'

(DB) ERROR: DbSlErrorMsg rc = 99

/usr/sap/RXT/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/RXT/SYS/exe/run/R3load: END OF LOG: 20090102154030

Thanx,

Amit

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

very helpful site for immediate respose.

Former Member
0 Kudos

Hi,

I am getting the same error message while installing solution manager in Windows server 2003.

Is there any solution for this?

Regards,

Badri

0 Kudos

hello

here it goes

################

  1. Filename......: listener.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

################

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = GPS.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = GPS)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = prdserver)

(PORT = 1527)

)

  1. (ADDRESS =

  2. (PROTOCOL = IPC)

  3. (KEY = EPD.WORLD)

  4. )

  5. (ADDRESS =

  6. (PROTOCOL = IPC)

  7. (KEY = EPD)

  8. )

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = GPS)

(ORACLE_HOME = D:\oracle\GPS\102)

)

  1. (SID_DESC =

  2. (SID_NAME = GPS)

  3. (ORACLE_HOME = D:\oracle\GPS\102)

  4. )

  5. (SID_DESC =

  6. (SID_NAME = EPD)

  7. (ORACLE_HOME = E:\oracle\product\10.2.0\db_1)

  8. )

)

JPReyes
Active Contributor
0 Kudos

That means that the Oracle listener is not running.

just logon as ora<sid> and use command lsnrctl start

Regards

Juan

Former Member
0 Kudos

Dear Juan,

I already start the lsnrctl with ORS<SID>,

BUT GETTING THE SAME ERROR MESSAGE.

Kindly help for the same.

regards,

Amit

JPReyes
Active Contributor
0 Kudos

Run R3trans -d and post the errors on trans.log

Regards

Juan

Former Member
0 Kudos

Hi Juan,

I am getting following error message :

isrxi:rxtadm 1> R3trans -d

This is R3trans version 6.13 (release 700 - 20.02.06 - 16:15:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'RXT'"

R3trans finished (0012).

Regards,

Amit

JPReyes
Active Contributor
0 Kudos

Yes... but check the trans.log file created when you executed that command and post it here.

Regards

Juan

Former Member
0 Kudos

Dear Juan,

Trans.log is ;

isrxi:rxtadm 7> cat trans.log

4 ETW000 R3trans version 6.13 (release 700 - 20.02.06 - 16:15:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 02.01.2009 - 16:45:09

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Fri Jan 2 16:45:09 2009 62 0.000062

4 ETW000 [dev trc ,00000] db_con_init called 13 0.000075

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 21 0.000096

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/RXT/SYS/exe/run/dboraslib.so' ...

4 ETW000 26 0.000122

4 ETW000 [dev trc ,00000] load shared library (/usr/sap/RXT/SYS/exe/run/dboraslib.so), hdl 0

4 ETW000 9099 0.009221

4 ETW000 [dev trc ,00000] Library '/usr/sap/RXT/SYS/exe/run/dboraslib.so' loaded

4 ETW000 16 0.009237

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/RXT/SYS/exe/run/dboraslib.so

4 ETW000 30 0.009267

4 ETW000 [dev trc ,00000] Version of '/usr/sap/RXT/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.46)

4 ETW000 42 0.009309

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/RXT/SYS/exe/run/dboraslib.so

4 ETW000 21 0.009330

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/RXT/SYS/exe/run/dboraslib.so

4 ETW000 25 0.009355

4 ETW000 [dev trc ,00000] New connection 0 created 16 0.009371

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 21 0.009392

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 17 0.009409

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 15 0.009424

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 16 0.009440

4 ETW000 [dev trc ,00000] -->oci_initialize (con_hdl=0) 195 0.009635

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.UTF8 1567 0.011202

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPSR3's password 14 0.011216

4 ETW000 [dev trc ,00000] Connecting as /@RXT on connection 0 (nls_hdl 0) ... (dbsl 700 240106)

4 ETW000 15 0.011231

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 17 0.011248

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x9342150 0x9349ba0 0x935a298

4 ETW000 16 0.011264

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 15 0.011279

4 ETW000 [dev trc ,00000] Allocating server context handle 11 0.011290

4 ETW000 [dev trc ,00000] Attaching to DB Server RXT (con_hdl=0,svchp=0x935a1c8,svrhp=0x935c4a8)

4 ETW000 63 0.011353

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541

4 ETW000 1787 0.013140

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'

4 ETW000 16 0.013156

4 ETW000 [dev trc ,00000] Try to connect with default password 46 0.013202

4 ETW000 [dev trc ,00000] Connecting as SAPSR3/<pwd>@RXT on connection 0 (nls_hdl 0) ... (dbsl 700 240106)

4 ETW000 15 0.013217

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

4 ETW000 16 0.013233

4 ETW000 [dev trc ,00000] 0 UTF8 1 0x9342150 0x9349ba0 0x935a298

4 ETW000 15 0.013248

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=0x935c4a8)

4 ETW000 14 0.013262

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x935a1c8,srvhp=0x935c4a8)

4 ETW000 13 0.013275

4 ETW000 [dev trc ,00000] Deallocating server context handle 0x935c4a8 20 0.013295

4 ETW000 [dev trc ,00000] Allocating server context handle 20 0.013315

4 ETW000 [dev trc ,00000] Attaching to DB Server RXT (con_hdl=0,svchp=0x935a1c8,svrhp=0x935c4a8)

4 ETW000 25 0.013340

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12541

4 ETW000 430 0.013770

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12541'

4 ETW000 16 0.013786

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12541 performing CON [dblink#3 @ 431]

4 ETW000 85 0.013871

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12541: TNS:no listener [dblink#3 @ 431]

4 ETW000 15 0.013886

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'RXT'"

isrxi:rxtadm 8>

Regards,

Amit

JPReyes
Active Contributor
0 Kudos

ORA-12541: TNS:no listener

than means that your listener is not running or the config is incorrect check TNSNAMES.ORA and LISTENER.ORA.

Regards

Juan

Former Member
0 Kudos

Juan,

Thanx for your kind response.

Now I m go for fresh installation , if got any error then get back to you..

Thanx,

Amit

JPReyes
Active Contributor
0 Kudos

You should try to fix this installation... you'll learn this way.

Anyhow.. if you are going for a clean install then close the thread.

Regards

Juan

Former Member
0 Kudos

Dear Juan,

When I go for fresh installation,I got the following error message in import ABAP Phase:

cd /tmp/sapinst_instdir/ERP/LM/COPY/ORA/SYSTEM/CENTRAL/AS-ABAP/

isrxi:orarxt 18> cat R3load.exe.log

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

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

/usr/sap/RXT/SYS/exe/run/R3load: START OF LOG: 20090102231229

/usr/sap/RXT/SYS/exe/run/R3load: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#6 $ SAP

/usr/sap/RXT/SYS/exe/run/R3load: version R7.00/V1.4 [UNICODE]

Compiled Apr 1 2006 00:08:29

/usr/sap/RXT/SYS/exe/run/R3load -testconnect

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12541

DbSl Trace: CONNECT failed with sql error '12541'

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12541

DbSl Trace: CONNECT failed with sql error '12541'

(DB) ERROR: db_connect rc = 256

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12541

DbSl Trace: CONNECT failed with sql error '12541'

DbSl Trace: OCI-call 'OCIServerAttach' failed: rc = 12541

DbSl Trace: CONNECT failed with sql error '12541'

(DB) ERROR: DbSlErrorMsg rc = 99

/usr/sap/RXT/SYS/exe/run/R3load: job finished with 1 error(s)

/usr/sap/RXT/SYS/exe/run/R3load: END OF LOG: 20090102231229

What to do regarding this error ??

Regards,

Amit

Former Member
0 Kudos

Hi All,

(Again go for fresh installation)

I am getting the following error at Configure Oracle server Network when performing

the system copy function (Import) via ./sapinst ( OS - LINUX and

DATABASE-ORACLE 10g)...

INFO 2009-01-05 09:53:03

Working directory changed to /tmp/sapinst_exe.26674.1231129347.

INFO 2009-01-05 09:53:03

Working directory changed to /tmp/sapinst_instdir/ERP/LM/COPY/ORA/SYSTEM/CENTRAL /AS-ABAP.

INFO 2009-01-05 09:53:03

Working directory changed to /tmp/sapinst_exe.26674.1231129347.

INFO 2009-01-05 09:53:03

Working directory changed to /tmp/sapinst_instdir/ERP/LM/COPY/ORA/SYSTEM/CENTRAL /AS-ABAP.

ERROR 2009-01-05 09:53:03

CJS-00030 Assertion failed: lsnrctl: Parameter dbHome has to be a valid ORACLE_ HOME.

ERROR 2009-01-05 09:53:03

MUT-03025 Caught ESAPinstException in Modulecall: ESAPinstException: error text undefined.

ERROR 2009-01-05 09:53:03

FCO-00011 The step StartListener 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|9| 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_OraDBStd|ind|ind|ind|ind|3|0|NW_OraClient|ind|ind|ind|in d|3|0|NW_OraNetworkSrv|ind|ind|ind|ind|1|0|StartListener was executed with statu s ERROR .

What to do regarding this error.

Regards,

Amit

Former Member
0 Kudos

Hi All,

Problem resolved..

I have changed the permossion for listner.ora file and then retry again.It works and I cleaar the oracle server configuration phase.

Regards,

Amit

Former Member
0 Kudos

Sir,

I am getting the same error inspite of listener is running and ORACLE_HOME is set please assist here.