Thread: ORA-12154: TNS could not resolve service name

Dear friends,

I am first time using form 6i i am using oracle 8.1.7 in my pc, when i installed i gave the global database name as amar now i have downloaded 'form 6i rel-2' and installed it in that pc in o.s windows xp professional, such as form developer, then report developer, and then net 8 configuration every thing goes perfect in installation. but when i am using form builder for data entry form at the data block wizard, for table or view it will ask for user name, password, and database name. I have tried it with scott, sys and system of user name but is not working it is telling me that "ora-12154: TNS could not resolve service name" what will be problem i didnot understand..i have also installed it properly. my global database name is amar (i have to manually start it and the TNS listner) only one user that is scott

thanks and regards....samar

check your tnsnames.ora file and ensure that tns entry you are trying to use is mentioned properly.

Originally Posted by samarendra_78

Dear friends,

I am first time using form 6i i am using oracle 8.1.7 in my pc, when i installed i gave the global database name as amar now i have downloaded 'form 6i rel-2' and installed it in that pc in o.s windows xp professional, such as form developer, then report developer, and then net 8 configuration every thing goes perfect in installation. but when i am using form builder for data entry form at the data block wizard, for table or view it will ask for user name, password, and database name. I have tried it with scott, sys and system of user name but is not working it is telling me that "ora-12154: TNS could not resolve service name" what will be problem i didnot understand..i have also installed it properly. my global database name is amar (i have to manually start it and the TNS listner) only one user that is scott

thanks and regards....samar

While installing d2k you have to select correct TCP/IP connection file (Network connection).