on 11-07-2010 6:00 PM
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
################
Filename......: listener.ora
Created.......: created by SAP AG, R/3 Rel. >= 4.0A
Name..........:
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
tnsnames.ora Network Configuration File: /oracle/sid/102_64/network/admin/tnsnames.ora
Generated by Oracle configuration tools.
################
Filename......: tnsnames.ora
Created.......: created by SAP AG, R/3 Rel. >= 4.0A
Name..........:
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
tnx
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hostname:oraSID 5> more tnsnames.ora
tnsnames.ora Network Configuration File: /oracle/SID/102_64/network/admin/tnsnames.ora
Generated by Oracle configuration tools.
################
Filename......: tnsnames.ora
Created.......: created by SAP AG, R/3 Rel. >= 4.0A
Name..........:
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It seems wrong Listener config , review once.
what is the ouput of
TNSPING SID
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.