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?

Answers were Sorted based on User's Feedback



While connecting to Oracle Db i am getting the following error message- ORA-12154: TNS:could not r..

Answer / 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

While connecting to Oracle Db i am getting the following error message- ORA-12154: TNS:could not r..

Answer / kashif keeriyo

you have to give link of
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)
)
)
to the tnsnames file inside the admin folder then connect it
will work surely.

Is This Answer Correct ?    5 Yes 1 No

While connecting to Oracle Db i am getting the following error message- ORA-12154: TNS:could not r..

Answer / harshada

Firstly Sys DBA/Manager sould create the user and allow him
to create the session permission with some password. then
mount the database it will allow you to connect the
database.

Is This Answer Correct ?    1 Yes 2 No

While connecting to Oracle Db i am getting the following error message- ORA-12154: TNS:could not r..

Answer / anil chauhan

only the restart the client machine

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Oracle Forms Reports Interview Questions

What are the different defaust triggers created when Master Deletes Property is set to Non-isolated?

1 Answers  


can u call procedure or function is sq l query in reports

1 Answers  


What are the types of canvas-views?

1 Answers  


What is a Text_io Package?

4 Answers  


Can you attach an lov to a field at design time?

1 Answers  


What is the use of transactional triggers?

1 Answers  


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

0 Answers  


What are the default extensions of the files careated by forms modules?

1 Answers  


running a report from Form or other Report , The Parameter Form Page will be Display first . I don?t want to display the screen . What I have to do ?

1 Answers   Convergys,


What are the different modals of windows?

1 Answers  


What are the default extension of the files created by library module?

1 Answers  


how do u compile a form i.e .fmb file in Unix or in dos

0 Answers   HCL,


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)