Instance not starting

[former_member72943]

Hello All,

My SAP server is not starting,please find attached the R3trans -d , trans.log output

4 ETW000 r3trans version 6.14 (release 700 - 24.04.08 - 14:09:00).

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

4 ETW000

4 ETW000 date&time : 21.03.2009 - 00:18:51

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] Sat Mar 21 00:18:53 2009 0 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000

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

4 ETW000 [dev trc ,00000] Loading DB library 'dboraslib.dll' ... 0 0.000000

4 ETW000 [dev trc ,00000] load shared library (dboraslib.dll), hdl 0 16292 0.016292

4 ETW000 [dev trc ,00000] using "D:\usr\sap\GPS\SYS\exe\nuc\NTI386\dboraslib.dll"

4 ETW000 35 0.016327

4 ETW000 [dev trc ,00000] Library 'dboraslib.dll' loaded 14 0.016341

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dboraslib.dll

4 ETW000 22 0.016363

4 ETW000 [dev trc ,00000] Version of 'dboraslib.dll' is "700.08", patchlevel (0.158)

4 ETW000 166 0.016529

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dboraslib.dll

4 ETW000 22 0.016551

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dboraslib.dll

4 ETW000 31 0.016582

4 ETW000 [dev trc ,00000] New connection 0 created 25 0.016607

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 28 0.016635

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

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

4 ETW000 19 0.016677

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 22 0.016699

4 ETW000 [dev trc ,00000] CLIENT_ORACLE_HOME is not set as environment variable or

4 ETW000 DIR_CLIENT_ORAHOME is not set as profile parameter.

4 ETW000 assuming using instant client with unspecified location.

4 ETW000 242 0.016941

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 34299 0.051240

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

4 ETW000 [dev trc ,00000] Client NLS settings: AMERICAN_AMERICA.WE8DEC 4301 0.055575

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPR3's password 33 0.055608

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

4 ETW000 28 0.055636

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

4 ETW000 26 0.055662

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 026C5E80 026CB3B4 026CAC3C

4 ETW000 142 0.055804

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

4 ETW000 [dev trc ,00000] Allocating server context handle 22 0.055853

4 ETW000 [dev trc ,00000] Attaching to DB Server GPS (con_hdl=0,svchp=026CAB88,srvhp=026CEDFC)

4 ETW000 61 0.055914

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

4 ETW000 37725 0.093639

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

4 ETW000 25 0.093664

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12514 10761 0.104425

4 ETW000 [dev trc ,00000] Try to connect with default password 18 0.104443

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

4 ETW000 22 0.104465

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

4 ETW000 22 0.104487

4 ETW000 [dev trc ,00000] 0 WE8DEC 1 026C5E80 026CB3B4 026CAC3C

4 ETW000 21 0.104508

4 ETW000 [dev trc ,00000] server_detach(con_hdl=0,stale=0,svrhp=026CEDFC) 14 0.104522

4 ETW000 [dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=026CAB88,srvhp=026CEDFC)

4 ETW000 21 0.104543

4 ETW000 [dev trc ,00000] Deallocating server context handle 026CEDFC 20 0.104563

4 ETW000 [dev trc ,00000] Allocating server context handle 21 0.104584

4 ETW000 [dev trc ,00000] Attaching to DB Server GPS (con_hdl=0,svchp=026CAB88,srvhp=026CEDFC)

4 ETW000 33 0.104617

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

4 ETW000 19846 0.124463

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

4 ETW000 24 0.124487

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12514 14 0.124501

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

4 ETW000 18719 0.143220

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [dblink#5 @ 431]

4 ETW000 22 0.143242

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

[former_member204746]

By the way, you have not installed Oracle the proper way. you ran SETUP.exe instead of SAPSERVER.CMD

have you read the installation guide Before attempting to install your new instance?

[Former Member]

This is a Listener problem:

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor dblink#5 @ 431

looks like your DB is not correctly defined in the Listener definition file or it is not up.

[Former Member]

Hii

This seems to be the problem of listener.I guess listener is not up,check the status of listenere

login as ora<SID> user and do lsnrctl status

If it is down, start listener using lsnrctl start and then start database

Then try starting SAP.if it comes up gud

other wise post the contents of your tnssames.ora file

Rohit

[former_member72943]

Hello

tnsnames.ora file

1. tnsnames.ora Network Configuration File: D:\oracle\GPS\102\network\admin\tnsnames.ora

2. Generated by Oracle configuration tools.

INST1_HTTP =

(DESCRIPTION =

(ADDRESS_LIST =

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

)

(CONNECT_DATA =

(SERVER = SHARED)

(SERVICE_NAME = MODOSE)

(PRESENTATION = http://HRService)

)

)

GPS.WORLD =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = GPS.world)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

[fidel_vales]

Hi,

if the two people who answer you (and the error) are telling that the issue is the listener, I wonder why you post here your tnsnames.ora.

I would expect that you post at least one of the following

• the listener.ora

• the listener.log

• the output of lsnrctl status

but you post the tnsnames.ora, that provides no information at all related to the error (unless you provide the listener.ora)

I hope it is clear, please, post (at least) the listener.ora

[former_member72943]

hello

listener.log

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

TNSLSNR for 32-bit Windows: Version 10.2.0.2.0 - Production on 21-MAR-2009 03:57:07

Copyright (c) 1991, 2005, Oracle. All rights reserved.

System parameter file is D:\usr\sap\GPS\SYS\profile\oracle\listener.ora

Log messages written to D:\oracle\GPS\102\network\log\listener.log

Trace information written to D:\oracle\GPS\102\network\trace\listener.trc

Trace level is currently 0

Started with pid=2620

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\GPS.WORLDipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\GPSipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prdserver)(PORT=1527)))

Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

WARNING: Subscription for node down event still pending

21-MAR-2009 03:57:08 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=gpsadm))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869824)) * status * 0

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

listner.ora

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

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

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. )

)

[fidel_vales]

Hi,

Don't you see the problem after posting the tnsnames and the listener?

I'll assume that the IP address for prdserver is 167.147.0.200.

If it is not, then that would be a problem.

You are sending a request to the listener on the port 1521

Your listener is configured to "listen" on the port 1527

therefore

> ORA-12514: TNS:listener does not currently know of service requested in connect descriptor