rose55
asked on
PL1-->Cobol-->Oracle
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!!
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!!
Hi there
Can u tell me the work around?
Thanx
K.M.P
Can u tell me the work around?
Thanx
K.M.P
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.
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.
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open the oracle/network/admin/liste
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.