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

What is an oracle report?

812


What is the difference between BPA AND Contract What are documents and test cases u followed

2144


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

1657


what are the new features introduced in oracle form services in 11g release 2?

795


Why oracle forms required?

778


What do we mean by record group in oracle forms?

822


what the 'lov of validation' property of an item? Mention what is the difference between lov and list item?

787


What do you understand by lov and how can it be used?

756


what is difference between group above and group left report

3575


What is the difference between bind and lexical parameter?

773


from where do u receive the information to develop report

1729


i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1761


Is it possible to have multiple layouts in a report?

801


how do u place it in required folder

1680


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

1799