While connecting to Oracle Db i am getting the following
error message- ORA-12154: TNS:could not resolve the connect
identifier specified
what are the steps to solve this problem?
Answer Posted / bhupendra singh koranga
Please check your tnsnames.ora file on client machine..
the parameter should be like this..
database =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =ip addrss or name
of the host)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = service name or database name)
)
)
fix it up...
and then just connect it again..
it will work..
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
what is tripstop report?
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
i am writing a query select EmpNo from Emp how can i call in after parameter form
What is responsibility and how u attach How to create user and how u attach with responsibility.
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
hiding item in report how like that properly,thats manually but at runtime i want to do
Is it possible to execute a dynamic sql from forms?
What is the difference between flex mode and confined mode?
if some data is not transfered where it will get stored
did u p prepared complex report
How can we generate report output in excel format?
What is a user exit program in oracle reports?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame