Thursday, March 18, 2010

Ora-12154 when connecting to Oracle forms

When I started oracle Forms to create a new data blocks, I was unable to connect to the database. I got error:
Ora 12154: TNS name could not resolve the connect identifier specified

I have installed Oracle Developer suite 10g after Oracle 10g server. Platform is Windows Xp.

Solution: copy tnsnames.ora file from oracle home location to oracle developer home location.
that is,
from
d:\ora_10g\ora92\network\admin\tnsname.ora to
d:\oracle_tool\network\admin\tnsname.ora

Shutdown and restart the oc4J instance again. Try to connect again. everything work fine.

No comments:

Post a Comment

Please write your comments here.