cancel
Showing results for 
Search instead for 
Did you mean: 

SAP down - ERROR => CONNECT failed with sql error 12514

Former Member
0 Kudos

Hello All,

After restart SAP not getting up.

R3trans log >>>

4 ETW000 [developertra,00000] Try to connect with default password 13 0.033705

4 ETW000 [developertra,00000] Connecting as SAPR3/<pwd>@SID on connection 0 ... (dbsl 46D 220209)

4 ETW000 20 0.033725

4 ETW000 [developertra,00000] -->oci_logon(con_hdl=0, user='SAPR3', dbname='SID')

4 ETW000 20 0.033745

*4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'olog' failed: rc = 12514 931 0.034676*

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

4 ETW000 [dblink ,00627] ***LOG BY2=>sql error 12514 performing CON 142 0.034845

4 ETW000 [dblink ,00627] ***LOG BY0=> 15 0.034860

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

hostname:sidam 53>

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

listener.log

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

07-NOV-2010 19:05:23 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=SID.WORLD)(CID=(PROGRAM=R3trans)(HOST=hostname)(USER=SIDadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.119.161.17)(PORT=60626)) * establish * SID.WORLD * 12514

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

lsnrctl >>

Services Summary...

Service "sid" has 1 instance(s).

Instance "sid", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

LSNRCTL>

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

SQL> select status from v$instance;

STATUS

-


OPEN

but SAP is not getting up.

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

hostname:orasid 41> more listener.ora

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

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

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

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

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

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

LISTENER =

(ADDRESS_LIST =

(ADDRESS=

(PROTOCOL=IPC)

(KEY= sid.WORLD)

)

(ADDRESS=

(PROTOCOL=IPC)

(KEY= sid)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = hostname)

(PORT = 1535)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU = 32768)

(SID_NAME = sid)

(ORACLE_HOME = /oracle/sid/102_64)

)

)

hostname:orasid 42>

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

hostname:orasid 43> more tnsnames.ora

  1. tnsnames.ora Network Configuration File: /oracle/sid/102_64/network/admin/tnsnames.ora

  2. Generated by Oracle configuration tools.

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

  1. Filename......: tnsnames.ora

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

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

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

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

LISTENER_sid.WORLD =

(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = hostname)(PORT = 1535))

sid.WORLD =

(DESCRIPTION =

(ADDRESS = (COMMUNITY = SAP.WORLD)(PROTOCOL = TCP)(HOST = hostname)(PORT = 1535))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = sid.WORLD)

)

)

hostname:orasid 44>

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

listener.log

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

07-NOV-2010 19:05:23 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=SID.WORLD)(CID=(PROGRAM=R3trans)(HOST=hostname)(USER=SIDadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.119.161.17)(PORT=60626)) * establish * SID.WORLD * 12514

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

Edited by: mohsinbasis on Nov 7, 2010 7:06 PM

Edited by: mohsinbasis on Nov 7, 2010 7:08 PM

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

tnx

richard_howard
Active Participant

I just used this Thread to resolve the same/similar problem, so I'll add some additional info.

We patched to 11.2.0.3 and started getting some ORA-12514 errors.  When I ran "lsnrctl status" the SID.WORLD service was no longer displaying in a READY state.  Why?  The listener.ora and tnsnames.ora had not changed.

  • TNSPING was ok
  • R3trans -x was ok
  • 11.2.0.3 /oracle/client checked out fine
  • I could actually do a successful "startsap" and run ok

The issued turned out to be that LOCAL_LISTENER parameter in the initSID.ora was blank.  If your tnsnames.ora file has a "LISTENER_SID.WORLD" entry, this parameter needs to match it.  I updated the parameter with the following:

  ALTER SYSTEM SET LOCAL_LISTENER='LISTENER_SID';

Immediately after setting it, the "lsnrctl status" was now showing the SID.WORLD service.

I do not know if the 11.2.0.3 Patchset or the SBP had anything to do with blanking out this parameter but I have to assume that it did since the SID.WORLD service was fine before we begain.

Thanks to John Feely.  The note he referenced above led me down this path.

Former Member
0 Kudos

listener.log

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

07-NOV-2010 19:05:23 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=SID.WORLD)(CID=(PROGRAM=R3trans)(HOST=hostname)(USER=SIDadm))) * (ADDRESS=(PROTOCOL=tcp)(HOST=144.119.161.17)(PORT=60626)) * establish * SID.WORLD * 12514

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

lsnrctl >>

(HOST = hostname)

(PORT = 1535)

Hi,

even if the correct IP of "hostname" is 144.119.161.17, it is obvious from listener.log that the listener is trying to establish a connection at port 60626 and not at port 1535.

Please check your configuration again.

Are there more than one system running on the same server?

Regards,

Constantina

mohsin_m3
Participant
0 Kudos

hostname:oraSID 5> more tnsnames.ora

  1. tnsnames.ora Network Configuration File: /oracle/SID/102_64/network/admin/tnsnames.ora

  2. Generated by Oracle configuration tools.

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

  1. Filename......: tnsnames.ora

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

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

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

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

SID.WORLD=

(DESCRIPTION =

(SDU = 32768)

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SID.WORLD)

(PROTOCOL = TCP)

(HOST = hostname)

(PORT = 1535)

)

)

(CONNECT_DATA =

(SID = SID)

(GLOBAL_NAME = SID.WORLD)

)

)

hostname:oraSID 6>

Now issue is resolved

former_member220071
Active Participant
0 Kudos

Hi ,

Please check service_name parameter of your database.

Also check listener.log

Abhijit

Edited by: Abhijeet Siras on Nov 8, 2010 4:14 PM

Former Member
0 Kudos

Hi,

It seems wrong Listener config , review once.

what is the ouput of

TNSPING SID

Regards,

volker_borowski2
Active Contributor
0 Kudos

Hi,

all your "sid" in your config files are lowercase, while

R3trans tries to connect with uppercase "SID".

This could be a missmatch.

Check "sidadm" Environment for TNS_ADMIN. If set, i.e. to

/sapmnt/SID/profile/oracle

check sqlnet.ora and tnsnames.ora at that position.

Volker

former_member189546
Active Contributor
0 Kudos

Hello,

The 12514 error code means that it was possible to reach the listener

but that the listener had to reject the connection because he does not

know where to route the request

Please check note

563574 Composite SAP note ORA-12514

regards,

John Feely

Former Member
0 Kudos

Hi,

The listener seem to be trying to connect to port 60626, however this port is not configured in your listener.ora file. Please check any listener file available in <dir_profile>/oracle directory and correct the listener details in it. Restart the listener for any changes done.