Oracle 9i and Oracle Forms 6i in 2 different Oracle-Homes
629539Mar 20 2008 — edited Mar 20 2008My OS: Windows XP
First I installed "Oracle9i Database 9.2.0.1.0" with Oracle-Home-Path "OraHome92".
Then I wanted to install "Oracle Forms Developer/Services 6i Release 2", because I need to use the Form Builder. I wasn't able to install this in the same Oracle-Home, so I installed it with a new one called "oradev". Now my Oracle Installation-Folder looks like this:
-oracle
---admin
---ora92 (comment: HOME 0)
---oradata
---oradev (comment: HOME 1)
Working with the database directly works fine, with Enterprise Manager I created a user, database and my first tables. No problems there.
But now I do have a problem: When I try to connect to my database with Form Builder, I get the following error message:
ORA-12154: TNS:Der Dienstname konnte nicht aufgelöst werden.
In english it should be this:
ORA-12154: TNS: could not resolve service name.
I guess the problem might be the two different oracle-homes?!??
Does anybody have an idea how I can connect to my database with Form Builder?