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?
- 4 Answers
- 6331 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How can a button be used in a report to give a drill down facility?
What is a physical page ? & What is a logical page ?
What is the "LOV of Validation" Property of an item? What is the use of it?
what is sequence of execution of following triggers 1.when-validate-item 2.post-change 3.key-next-item 4.post-text-item
What is a Trigger ?
To execute row from being displayed that still use column in the row which property can be used?
What do you mean by a pop-up window ?
When the form is running in DEBUG mode, If you want to examine the values of global variables and other form variables, What package procedure command you would use in your trigger text ?
what is the exact navigation to create a radio button in form6i? can i create the radio button in report6i?
Can a sigle canvas be used by different blocks ?
How can a break order be created on a column in an existing group?
Can you truncate a table in a procedure in Oracle Forms?
Oracle General 
