Selasa, 24 Maret 2009

Connect Database Oracle 10g to developer Suite Form

To connect developer suite Form and database, we must adjust listener.
listener is bridge between form and database.
first step, we must set net configuration assistant both DevSuiteHome and database Oracle10g. in net configuration assistant we make listener with same port to connect.

First, we set net configuration assistant for Listener in Developer Suite Form
1. after installation finished, open "all Program->Oracle-DevSuiteHome->configuration and migration tools->net configuration assistant"

2.klik "next"

3. choose "Add" to make a new one and klik "next"

4. Rename "Listener Name" and klik "next"

5. set "TCP" as default and klik "next"

6. default port is "1521" but if you don't like you can choose "use another port number".
7. after that finish.

Then, we set net configuration assistant for Local Net Service in Developer Suite Form
1. open "all Program->Oracle-DevSuiteHome->configuration and migration tools->net configuration assistant"

2. then klik "next"

3. choose "Add" to make a new one and klik "next"

4. Rename "Service Name"
NB: "Servie Name" is database name that installed before.
after that klik "next"

5. use "TCP" klik next

6. fill "Host Name", "host name" is computer's name and port must same with port in listener that made before, klik "next"
7. after next, there have 2 option
  • no,do not test
  • yes,perform test
better to choose "yes,perform test" and klik next.
8. if failed, klik change login to update username and password.

after this test succeeded, klik next and finish.

Now configuration Assistant for Developer Suite Form finished then configuration Assistant for Database.
open "all Program->Oracle-Oracle-OraDB10g-home->configuration and migration tools->net configuration assistant"
Step is same, but port must same with port in Developer Suite Form that created before.

Open and Run Form has 2 step :
- Open "all Program->Oracle Developer Suite-DevSuiteHome->Form Developer->Start OC4J Instance"
- Open "all Program->Oracle Developer Suite-DevSuiteHome->Form Developer->Form Builder"

After finished, login and enjoy^^

Tidak ada komentar:

Posting Komentar