ECC6 server not starting - pls help

[Former Member]

Hi gurus,

I have recently installed ECC6 in my pc but now its now the server is staring i got the folowing log from the trans folder cany anyone tell me how to fix this error...

date&time : 08.08.2020 - 10:02:09

4 ETW000 function : CONNECT

4 ETW000 buffersync : YES

4 ETW000 clients : default

4 ETW000 l.s.m. : VECTOR

4 ETW000 commit : 100000

4 ETW000 table cache : dynamic

4 ETW000

4 ETW000 [dev trc ,00000] Disconnecting from ALL connections: 384 0.000384

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 29 0.000413

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=02192650,usrhp=021DF608)

4 ETW000 314 0.000727

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=02192650,srvhp=021A3EC4)

4 ETW000 511 0.001238

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 580 0.001818

4 ETW000 [dev trc ,00000] Disconnected from connection 0 36 0.001854

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=1, com_tx=1)

4 ETW000 31 0.001885

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 30 0.001915

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 08.08.2015 - 10:02:09

1 ETP186 R3TRANS CONNECT

1 ETP110 end date and time : "20150808100209"

1 ETP111 exit code : "0"

I am also getting some error like this also

Status

Down

Host

ecc6

Port

1521

Name

LISTENER

Oracle Home

D:\oracle\product\10.2.0\ECC

Location

D:\oracle\product\10.2.0\ECC\network\admin

Details TNS-12541: TNS:no listener

-

---

Regards,

Ravi

[Former Member · Accepted solution]

Hi,

1. Check your oracle dababase is running or not?

2. check with commnad r3trans -d.

3. start the listener.

4. paste the exact log file here ie dev_wp##, dev_ms, sapstartlog..

Regards,

Srini Nookala

[Former Member · Accepted solution]

Hi Srini,

Thanks for ur reply here is the error details

opened by SAP_CMACCP (version=700.2005.12.02)

NiInit3: NI already initialized; param 'maxHandles' ignored (1;202)

CPIC (version=700.2005.12.02)

Mon Aug 10 19:04:01 2015

***LOG Q0I=> NiPConnect2: connect (10061: WSAECONNREFUSED: Connection refused) [nixxi.cpp 2764]

• ERROR => NiPConnect2: SiPeekPendConn failed for hdl 0 / sock 1540

(SI_ECONN_REFUSE; I4; ST; 10.17.119.172:3304) [nixxi.cpp 2764]

• ERROR => GwIConnect: GwConnect to ecc6 / 3304 failed (rc=NIECONN_REFUSED) [gwxx.c 294]

***LOG S0T=> GwIConnect, GwConnect (-0010) [gwxx.c 295]

***LOG S0R=> GwIConnect, GwConnect () [gwxx.c 297]

***LOG S0S=> GwIConnect, GwConnect (3304) [gwxx.c 299]

***LOG S90=> SAP_CMNOREGTP, GwIConnect ( 236) [r3cpic.c 9333]

*****************************************************************************

*

• LOCATION CPIC (TCP/IP) on local host

• ERROR partner 'ecc6:3304' not reached

*

• TIME Mon Aug 10 19:04:01 2015

• RELEASE 700

• COMPONENT NI (network interface)

• VERSION 38

• RC -10

• MODULE nixxi.cpp

• LINE 2764

• DETAIL NiPConnect2

• SYSTEM CALL connect

• ERRNO 10061

• ERRNO TEXT WSAECONNREFUSED: Connection refused

• COUNTER 1

actually in Oracle its not able to locate my listener i have checked in the service my oracle lister application is getting stopped automatically i started it manually also but its getting stopped i don't know y... it was working properly before now i donut know what happened . i have tried running "r3trans -d." in command prompt but its saying an unrecognized command.

Ravi

[Former Member · Accepted solution]

Hi

Check these:

1. The ports that are used in listener.ora are not used by some other process. It may be the possibility that it would be used by some other process. Check that port in linstener.ora and tnsnames.ora are same.

2. For the r3trans, check that you have included the path of run directory in enivronmental variable.

[Former Member · Accepted solution]

Hi Deepak,

Thanks for ur reply could please elaborate ur 2nd point please how to include it... . Recently i have added an NIC into my PC is it due to this things went wrong..??

Ravi

[former_member46205]

Hi,

you can reconfigure the oracle listner. it will work

[Former Member]

Hi,

Set the Environment varaibles.

Right click on mycomputer icon on desktop> clcik on Properties> clcik on Advanced tab--> click on Environment variables (see the bottom of page) > select NEW> Give like this

1. Variable = dbms_type

Value = ora

2. Variable = PATH

Value = <oracle_home>\bin

3. VAraible = dbs_ora_tnsname

Value =<sid>

4. Variable = dbs_ora_schema

Value=SAPR3 or SAP<sid> (depending on which user the R/3 tables belong to)

5. Varaible = NLS_LANG=AMERICAN_AMERICA.<characterset> (see Note 381674)

6. Variable = ORACLE_HOME

Value =<oracle_home>

7. Varaible = SAPDATA_HOME

Value =<drive>:\oracle\<sid>

Regards,

Srini Nookala

[Former Member]

Check SAP Notes 576919 and 563574 and related notes. I hope this will help.

Kind regards.

[Former Member]

hello Ravi

what is the port you have configured in listener.ora?

Is it 1527?

it seems your problem due to network port or network issue?

have you made any changes to your network setting or listener.ora ?

See the service listener ?Is it configured properly?

See the event logs if you get some error in your server.

It is windows environment ? try to stop everything and re-start windows?

hope it helps.

Amit

[Former Member]

Hi,

1. start the listener from control panel services

2. also start the TNSnames services.

3. Then start the database frol sqlplus command

sqlplus>startup

database should be start.

4. now start the sap.

Regards,

Srini Nookala

[Former Member]

Hi Srini,

I have tried starting the listener from the services but its getting stopped automatically i don't know y.

Ravi

[Former Member]

Hi Srini,

The connection failed with error

DBLI_RC_LOAD_LIB_FAILED<0012> could you please tell me know what to do?

Regards,

Ravi

Edited by: ravi r on Aug 12, 2008 6:47 PM

[Former Member]

Hi,

For the r3trans, check that you have included the path of run directory in enivronmental variable.

Goto Command prompt

type C:\ or D:\ usr\sap\SID\SYS\exe\run and enter

then type r3trans -d.

It should get into 000 finished successfully, if not datbase connection problems.

Regards,

Srini Nookala

[Former Member]

Hi Srini,

Thanks for the reply as i mentioned earlier its an db connection problem only the "listener problem" could you please let me know how to fix this one?

Ravi

[vincentlim826]

Your R3trans connect should looks fine.

Try locate error in following files:

- sapstart.log

- sapstartsrv.log

- stderr* file

- dev_ms

- dev_disp

- dev_w*

cheers.

[Former Member]

Why would you get the log from trans? If the system won't start, post the dev_ms and dev_disp from the work directory. Maybe a dev_w# trace file as well.