Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-12222 : TNS:No such protocol adapter -error

Gowthaman Ganesan-OracleApr 1 2012 — edited Apr 5 2012
Hi

when i try to connect database from forms builder i get the below error.

ORA-12222 : TNS : No such protocol adapter. I refered many forums and help sites... i checked everyting in my system. like Regedit and environment variable.

still i am getting the same error. kindly help to resolve this issue.

Please find the below details of my desktop, form builder and Oracle database.


Desktop OS
-----------
Operating system : WINDOWS XP (professional) version 2002 service pack 3

Oracle Database
---------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

Oracle database installed in Linux server
linux server details

Linux VM177 2.6.18-194.0.0.0.3.el5xen #1 SMP Mon Mar 29 18:27:00 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

any rpm are required in Linux server resolve this issue.

my linux server i couldn't find any rpms OPENM*

$ rpm -qa openm*
$


Oracle forms builder
---------------------

Forms [32 Bit] Version 6.0.8.24.1 (Production)
Oracle Toolkit Version 6.0.8.24.0 (Production)
PL/SQL Version 8.0.6.3.0 (Production)
Oracle Procedure Builder V6.0.8.21.0 Build #1459 - Production
PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)
Oracle Query Builder 6.0.7.1.0 - Production
Oracle Virtual Graphics System Version 6.0.5.38.0 (Production)
Oracle Tools GUI Utilities Version 6.0.8.20.1 (Production)
Oracle Multimedia Version 6.0.8.20.0 (Production)
Oracle Tools Integration Version 6.0.8.18.0 (Production)
Oracle Tools Common Area Version 6.0.8.18.0
Oracle CORE Version 4.0.6.0.0 - Production

Thanks in advance. your early reply will be very much appriciated.

Gowtham
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2012
Added on Apr 1 2012
24 comments
16,726 views