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?
Answer Posted / 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 |
Post New Answer View All Answers
How to create Drill down report?
Name the different triggers supported by oracle reports and their firing order.
from where do u receive the information to develop report
Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com.
How can we expand Parameter Form Canvas on Reports 6i?
What do you understand by oracle forms?
What do you understand by oracle forms and why are they required?
What do you understand by lov and how can it be used?
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
What is an oracle report?
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
Can we invoke one form from another in a multi-forms application?
what is oracle forms?
how report can be generated if we have the database designed in oracle 10g?