Solved

PL1-->Cobol-->Oracle

Posted on 2001-07-12
5
585 Views
Last Modified: 2012-05-04
I am currently updating a PL1 screen to call a Cobol program that calls Oracle. I can get the Cobol/Oracle program to work(I've written many of them). When I run a BTS to test the screen, the cobol program comes down with an Oracle error-12154:TNS:could not resolve service name. Help!! Any suggestions as to where to start?
7/27/01
I got the BTS run to work..the PL1 sreen gets populated correctly. BUT..if I do a regular run of the PL1 screen, it is as if the PL1 program doesn't see the info being passed back from Oracle. The Oracle version is 8i. Help!!
0
Comment
Question by:rose55
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 6

Expert Comment

by:jpk041897
ID: 6279157
This answer is generaly caused by a typo in the client app or a misconfigured server.

Open the oracle/network/admin/listener.ora file and look for the service name that you are using to establich your connection.

If it does not appear in the listener.ora file then you should create a TNS listener with the appropiate name.

If it does appear, check out your connect string and insure you a re using the correct name, for example:

connect scott/tiger@wrongname

implies that you have either not set up a listener called wrongname or that wrongname is indeed the wrong name.

One final cause, if the client app and the DB server are on the same box, you might have either not set up a listener at all or the listener may be down.

The way you can test this is to log into SQL*Plus on the server box.

If you can't log in using connect scott/tiger then you listener is down.
0
 

Expert Comment

by:pandi_k
ID: 6296416
Hi there

Can u tell me the work around?

Thanx
K.M.P
0
 
LVL 6

Expert Comment

by:jpk041897
ID: 6325150
What version of Oracle (software and hardware platform are you using).

Generaly, to start the listener when its down you run a program from the command line (dos/windows/Unix):

lsnrctl start

This program usualy resides in the oracle/bin directory.

But the listener won't start at all if it has not been defined. Tell me your OS and Oracle version so that I can tell you how to set up and start the listener for your specific architecture.

0
 
LVL 54

Expert Comment

by:nico5038
ID: 7258998

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts removed
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 

Accepted Solution

by:
Jgould earned 0 total points
ID: 7289108
Question has been closed as per recommendation

JGould-EE Moderator
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question