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


Please Help Members By Posting Answers For Below Questions

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

2576


HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1101


What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?

4076


What is an implicit anchor and how is it a different form explicit anchor in a report builder?

633


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

1602






Explain how one can iterate through items and records in a specified block?

550


if some data is not transfered where it will get stored

1468


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

1296


what is the difference between call_form, new_form and open_form?

729


what is a package n what r the packages availbla in report

1624


I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users

847


What is responsibility and how u attach How to create user and how u attach with responsibility.

1629


What do you understand by oracle forms and why are they required?

564


What is the difference between bind and lexical parameter?

549


how report can be generated if we have the database designed in oracle 10g?

1466