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^^

Install Form Builder Oracle 10g

In Order to install oracle10g for form Builder have 3 kind of installer:
1. install oracle database (oracle database 10g)
source nya :
http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html

2. install jre-1_5_0_06-windows-i586-p-iftw ,jre-6u6-windows-i586-p, dan jinit
3. install developer suite form
source nya :
http://www.oracle.com/technology/software/products/ids/index.html

After download developer suite. find "setup.exe" and double-klik.

2. klik "next" and then you are suggested to locate directory to install.

3. after finished, klik "next"

4. choose "complete(1.11Gb)" and klik next

5. just skip and klik next.

6. klik install and finish.

Senin, 23 Maret 2009

Install Database Oracle10g for Form Builder

In Order to install oracle10g for form Builder have 3 kind of installer:
1. install oracle database (oracle database 10g)
source nya :
http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html

2. install jre-1_5_0_06-windows-i586-p-iftw ,jre-6u6-windows-i586-p, dan jinit
3. install developer suite form
source nya :
http://www.oracle.com/technology/software/products/ids/index.html

first install jre-1_5_0_06-windows-i586-p-iftw ,jre-6u6-windows-i586-p, dan jinit.
now i share how to install database oracle10g for form buider.
1. to install form builder, find set up.exe then double-klik to run set up.
2.after that it appears command prompt.

then appears dialog box:

3. "Oracle Home Location" to locate your database, installation type : entreprise edition (1.3Gb)
4. Rename "Global Database Name" is database's name. usually default is "orcl"
5. set "database password" and "confirm database"
6. klik next



6. klik next

7. see the detail that will be installed, then klik "install"

8. after finish,next step to configuration Assistant to configure and start component


9. after "configuration Assistant" finished,appears dialog box.

10. we are recommended to set "password management". in oracle,only database account like SYS,SYSTEM are unlocked, and to login to database, we cannot use account like SYS,SYSTEM so, we must unlock the others and set password.
first, klik "password management"

to unlock username, we can unlock as we needed. in this example, i unlock username "hr" and "oe" then insert password in "New Password" and "Confirm Password".
11. then klik "ok". after klik "ok" again. appears box that contain URL for 3 substance:
  1. Enterprise Manager Database Control URL
  2. The iSQL*Plus URL
  3. The iSQL*Plus DBA URL
we must save content of URL to connect database.

if you want to uninstall your database. you can klik "installed product". "Installed product" to know what database that you already installed.

then klik remove to uninstall.
12. after finished, you can try to connect with web browser. open your web browser and type URL for "The iSQL*Plus URL".

username and password that you unlock before, "connect identifier" is your database name.

Enjoy.^^