Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6946 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 |
What is a Text_io Package?
What is the difference when Flex mode is mode on and when it is off?
What is a library?
What are the different default triggers created when Master Deletes Property is set to isolated?
What is a master detail relationship?
List the windows event triggers available in Forms 4.0?
What is the between Function and Procedure?
How do you display console on a window ?
how to create the triggers in the forms?
If two groups are not linked in the data model editor, What is the hierarchy between them?
What is an user exit used for?
Can you attach an lov to a field at run-time? if yes, give the build-in name.
Oracle General 
