Skip to Content
0
G G
Jul 02, 2007 at 01:03 AM

Listener error

25 Views

Hi!

I have a problem when I want to startup the SAP System. Is installed on a Windows 2003 Enterprise with Oracle 9.2

I think that is a problem with the listener.

Here's the DEV_W0, SQLNET.ORA, TNSNAMES.ORA and LISTENER.ORA

Thx a lot for all you help.

Regards!

DEV_W0:

-


trc file: "dev_w0", trc level: 1, release: "640"

-


*

  • ACTIVE TRACE LEVEL 1

  • ACTIVE TRACE COMPONENTS all, M

*

B

B Sun Jul 01 21:30:57 2007

B create_con (con_name=R/3)

B Loading DB library 'D:\usr\sap\GD0\SYS\exe\run\dboraslib.dll' ...

B Library 'D:\usr\sap\GD0\SYS\exe\run\dboraslib.dll' loaded

B Version of 'D:\usr\sap\GD0\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.39)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 43

M intno 20020600

M make: multithreaded, Unicode

M pid 3024

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 3024) [dpxxdisp.c 1160]

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: JAVA is not active

M DpShMCreate: sizeof(wp_adm) 10528 (1316)

M DpShMCreate: sizeof(tm_adm) 2780232 (13832)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpShMCreate: sizeof(comm_adm) 290000 (580)

M DpShMCreate: sizeof(vmc_adm) 0 (372)

M DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

M DpShMCreate: SHM_DP_ADM_KEY (addr: 04550040, size: 3192688)

M DpShMCreate: allocated sys_adm at 04550040

M DpShMCreate: allocated wp_adm at 04551B58

M DpShMCreate: allocated tm_adm_list at 04554478

M DpShMCreate: allocated tm_adm at 045544A0

M DpShMCreate: allocated wp_ca_adm at 047FB0E8

M DpShMCreate: allocated appc_ca_adm at 04800EA8

M DpShMCreate: allocated comm_adm_list at 04802DE8

M DpShMCreate: allocated comm_adm at 04802E00

M DpShMCreate: allocated vmc_adm_list at 04849AD0

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 04849AF8

M DpShMCreate: allocated wall_adm at 04849B00

X

X Sun Jul 01 21:30:58 2007

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M calling db_connect ...

C Got ORACLE_HOME=D:\oracle\GD0 from environment

C Client NLS settings: AMERICAN_AMERICA.UTF8

C Logon as OPS$-user to get SAPGD0's password

C Connecting as /@GD0 on connection 0 ...

C Attaching to DB Server GD0 (con_hdl=0,svchp=042913D4,svrhp=0432A584)

C

C Sun Jul 01 21:31:03 2007

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12154

[dboci.c 3514]

C *** ERROR => CONNECT failed with sql error '12154'

[dbsloci.c 9750]

C Try to connect with default password

C Connecting as SAPGD0/<pwd>@GD0 on connection 0 ...

C Detaching from DB Server (con_hdl=0,svchp=042913D4,srvhp=0432A584)

C Attaching to DB Server GD0 (con_hdl=0,svchp=042913D4,svrhp=0432A584)

C

C Sun Jul 01 21:31:07 2007

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12154

[dboci.c 3514]

C *** ERROR => CONNECT failed with sql error '12154'

[dbsloci.c 9750]

B ***LOG BV3=> severe db error 12154 ; work process is stopped [dbsh#2 @ 1195] [dbsh 1195 ]

B ***LOG BY2=> sql error 12154 performing CON [dblink#1 @ 419] [dblink 0419 ]

B ***LOG BY0=> ORA-12154: TNS:could not resolve service name [dblink#1 @ 419] [dblink 0419 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 000256) [thxxhead.c 1269]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 9413]

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source = 255

M last_tid = 0

M last_mode = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M

M *****************************************************************************

M *

M * LOCATION SAP-Server cuervo_GD0_00 on host cuervo (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Sun Jul 01 21:31:07 2007

M * RELEASE 640

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 9589

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 730]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 252]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 3024) [dpnttool.c 357]

SQLNET.ORA:

  1. SQLNET.ORA Network Configuration File: D:\oracle\GD0\network\admin\sqlnet.ora

  2. Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

TNSNAMES.ORA:

  1. TNSNAMES.ORA Network Configuration File: D:\oracle\GD0\network\admin\tnsnames.ora

  2. Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

LISTENER.ORA:

  1. LISTENER.ORA Network Configuration File: D:\oracle\GD0\network\admin\listener.ora

  2. Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = cuervo)(PORT = 1521))

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = D:\oracle\GD0)

(PROGRAM = extproc)

)

)