on 07-02-2007 2:03 AM
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:
SQLNET.ORA Network Configuration File: D:\oracle\GD0\network\admin\sqlnet.ora
Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
TNSNAMES.ORA:
TNSNAMES.ORA Network Configuration File: D:\oracle\GD0\network\admin\tnsnames.ora
Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
LISTENER.ORA:
LISTENER.ORA Network Configuration File: D:\oracle\GD0\network\admin\listener.ora
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)
)
)
^^ i do not see any system specific content in the listener.ora file...how did you implement the network part for oracle? tnsnames.ora is empty" as well.....you have to apply data to these files - otherwise the listener cannot be started properly...
tnsnames.ora (example)
==================
<b>GDO</b>.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST =<b><your.hostname></b>)
(PORT = 1527)
)
)
(CONNECT_DATA =
(SID = <b>GDO</b>)
(GLOBAL_NAME = <b>GDO</b>.WORLD)
)
)
listener.ora (example)
==================
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY= <b>GD0</b>.WORLD)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= <b>GD0</b>)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = <b><your.hostname></b>)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 32768)
(SID_NAME = <b>GD0</b>)
(ORACLE_HOME = D:\oracle\GD0)
)
GreetZ, AH
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
the step by step check for ORA-12154 is described in note
<a href="https://service.sap.com/sap/support/notes/443867">443867</a>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.