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

EXIT_FORM is a restricted package procedure ?

1 Answers  


What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?

1 Answers  


Where is the external query executed at the client or the server?

2 Answers   Wipro,


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

0 Answers  


in reports 1og.if we enter a query in list of values then parameter form displays a dropdown.in that if any ething is selected then that will display in the report.supp if i am not selected any value then it should display all the values.how it is possible?can any one help me........

1 Answers  






Can we use bulk collect in oracle forms if yes then how?

1 Answers  


What is coordination Event?

1 Answers  


Explain types of Block in forms4.0?

1 Answers  


What do you understand by oracle forms?

0 Answers  


What is the difference between an ON-VALIDATE-FIELD trigger and a trigger ?

2 Answers  


What is WHEN-Database-record trigger?

1 Answers  


how to hide the scroll bar in forms 6i

2 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • 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)