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
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 |
What is a combo box?
What is a user exit program in oracle reports?
what are difference between post database commit and post-form commit?
How to solve the error ?Frequency below its group? while running the report. Why it is happened and How to solve that?
Can you change the color of the push button in design time?
While specifying master/detail relationship between two blocks specifying the join condition is a must ? True or False.
what is sequence of execution of following triggers 1.when-validate-item 2.post-change 3.key-next-item 4.post-text-item
did u received a single file or multiple files
List the system variables related in Block and Field?
What does TKPROF stand for?
What are the built-ins used for processing rows?
What are the two types views available in the object navigator?