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

did u received a single file or multiple files

1608


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

625


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

1455


hi,dis is Shasi.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.and iwant one project with explanation please help me...

1663


How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

1642






In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

810


I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object

2273


What do you understand by lov?

565


What is an SQL FORMS ?

2310


a text item is there what r the different types of triggers associated with it

1508


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

1619


what are bind variables?

589


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

539


if u want to delete all these detail block etc what will happen in form

1471


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

1565