DB13c Error:ORA-12541: TNS:no listener for windows systems

[Former Member]

Hello Gurus,

We are facing an issue in DB13C jobs.

Background:

DB13c is setup in Solution Manager.

Only for windows systems DB13 jobs are failing.

Job log is given below:

-

---

Job started

Step 001 started (program RSDBAJOB, variant &0000000002249, user ID P96ADM)

Execute logical command BRCONNECT On host 10.91.26.117

Parameters:-u / -jid CHECK20120116070805 -sid T72 -j P96 -c -f check

BR0801I BRCONNECT 7.10 (20)

BR0280I BRCONNECT time stamp: 2012-01-16 07.08.09

BR0301W SQL error -12541 at location BrDbConnect-15, SQL statement:

'CONNECT / AT JOURNAL_DB USING P96'

ORA-12541: TNS:no listener

BR0310W Connect to database instance P96 failed

BR0477I Oracle pfile /oracle/T72/102_64/dbs/initT72001.ora created from spfile /oracle/T72/102_64/dbs/spfileT72001.ora

BR0805I Start of BRCONNECT processing: cehrfhfs.chk 2012-01-16 07.08.08

BR0484I BRCONNECT log file: /oracle/T72/sapcheck/cehrfhfs.chk

BR0280I BRCONNECT time stamp: 2012-01-16 07.08.09

BR0301E SQL error -12541 at location db_connect-7, SQL statement:

'CONNECT / AT JOURNAL_DB USING P96'

ORA-12541: TNS:no listener

BR0310E Connect to database instance P96 failed

BR0280I BRCONNECT time stamp: 2012-01-16 07.08.09

BR0301W SQL error -3114 at location brc_dblog_open-3, SQL statement:

'/* AT JOURNAL_DB */ INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES ('20120116070808', 'chk', 'T72

ORA-03114: not connected to ORACLE

BR0324W Insertion of database log header failed

BR0806I End of BRCONNECT processing: cehrfhfs.chk2012-01-16 07.08.09

BR0280I BRCONNECT time stamp: 2012-01-16 07.08.09

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

Internal session terminated with a runtime error (see ST22)

Job cancelled

-

---

P96 is our solman(version:SAP EHP 1 for SAP Solution Manager 7.0)

T72 is 4.6c System .

Sap in windows

Database in Linux

Oracle -10.2.0.4

rest all DB13 jobs are running fine.

Only for windows system we are facing issue now.

-

---

Runtime Error which comes along with it is:

OBJECTS_OBJREF_NOT_ASSIGNED

Access via 'NULL' object reference not possible.

The current ABAP program "RSDBAJOB" had to be terminated because it has

come across a statement that unfortunately cannot be executed.

-

---

lsnrctl status for t72 instance is giving result for another instance(A72 which is teh Acceptance system for T72)

-

---

orat72 51> lsnrctl status

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 16-JAN-2012 07:27:53

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER

-

---

Alias LISTENER_A72_ES1UL0017

Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production

Start Date 27-DEC-2011 14:53:43

Uptime 19 days 16 hr. 34 min. 9 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /oracle/A72/102_64/network/admin/listener.ora

Listener Log File /oracle/A72/102_64/network/log/listener_a72_es1ul0017.log

-

---

Kindly provide your valuable suggestions.

Regards,

Samaya

[Former Member]

Hi Support,

Please check the SYSTEM or the user declared in SOLMAN_Setup credentials in Oracle and Check the credentials declared in SOLMAN_SETUP->Enter system Parameters -> DB Parameters along with the DB host, port number and click on setup DBA Cockpit Connection. Refresh. It would connect if your DB host T72 and port number were correct.

Please check and let me if you are still facing issue.

Thanks & Regards,

Ahamed.

[Former Member]

Hello Gurus,

We are still getting the error.

BR0301W SQL error -12541 at location BrDbConnect-15, SQL statement:

'CONNECT / AT JOURNAL_DB USING P96'

ORA-12541: TNS:no listener

Kindly suggest.

[Former Member]

Hello,

T72 SAP Instance :In Windows

T72 DB instance: In Linux box

P96(Solman) SAP and DB instances are in AIX boxes.

Solman DB13c configuration:

72 systems(Windows) : without ABAP SERVER option selected

for other systems(UNIX) : with ABAP SERVER option selected and RFC details provided

Thank you.

[Former Member]

Hello Nicholas,

Thank you for your suggestion.

But i do not think it is really required to change P96 tnsnames.ora.

Because, T72 database is in a Linnux box where several other DB are also there.

(Our landscape,NOn-PRD DB instances are together in 1 linux box)

DB13 jobs of other instances are working fine.

Only difference is T72 sap instace is a windows server where as other instances are in AIX.

In DB13c, windows system is configured as without ABAP server .

UNIX systems as With ABAP server.

All were working with this configuration till few days ago.

Thank you.

[nicholas_chang]

Hi,

Just to clarify, do you mean your T72 CI is in Linux whilst DB in windows? and your DB13c on SOLMAN to T72 DB worked before and stop and failed recently?

[Former Member]

Hello,

tnsping from solution manager is working fine.

Also, the P96 details are added to tnsnames.ora. already.

Still the issue persists.

Kindly suggest.

Regards,

Samaya

[nicholas_chang]

Hi,

Apologize for the confusion, u should insert T72 into P96 tnsname.ora in both location.

for eg:

T72.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = T72HostName)

(PORT = T72ListnerPort)

)

)

(CONNECT_DATA =

(SID = T72)

(GLOBAL_NAME = T72.WORLD)

)

)

It should works.

Cheers,

Nicholas Chang

[Former Member]

Hi,

Are you able to connect to the remote with the command below?

>> ORA-12541: TNS:no listener

tnsping <Address>

Execute the command at the SOLMAN

Best regards,

Orkun Gedik

Edited by: Orkun Gedik on Jan 16, 2012 8:48 AM

[nicholas_chang]

on top of that, please ensure you've inserted your P96 info into the tnsnames.ora of your calling system in both location:

/usr/sap/SID/sys/profile/oracle & /oracle/.../.../netowrk/admin.

Chees,

Nicholas Chang