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 |
Is it possible to split the printpreviewer into more than one region?
WHAT IS THE ORACLE FORM TRIGGER WHICH CAN BE FIT IN ALL THREE LEVELS i.e., IN FORM LEVEL, BLOCK LEVEL AND ITEM LEVEL ?
How we can migrate the 6i report to 10g reports. What steps need to reuired?
What is the difference between keystartup and pre-form ?
What is a Text_io Package?
What is a visual attribute?
Where is the external query executed at the client or the server?
what r the various types of reports
What is the use of Printer Definition file (PRT) in Reports ?
Name the different triggers associated with oracle forms having a master-detail relationship.
how to pass 2 variables from one form to other form
With which function of summary item is the compute at options required?