02 – Oracle SOA Suite tutorial environment

In this tutorial I will show you how to:

  • Configure SQL Developer on Oracle SOA VM
  • Create tutorial user BC_SOA_TUTORIAL
  • Add DataSource to WebLogic server

Configure SQL Developer on Oracle SOA VM

When I was writing this tutorial there is a bug in Oracle SOA VM. The link to SQLDeveloper is invalid. Let’s fix them now:

Ensure that menu link is still wrong. It’s possible that Oracle fix it.

Menu_002

Go to console (default root password: welcome1):

Ensure that path “/u01/app/oracle/product/12.1.0/dbhome_2/sqldeveloper/sqldeveloper/bin/sqldeveloper” is valid. If not, you can find sqldeveloper by:

Start SQLDevloper

Menu_002

Create tutorial user BC_SOA_TUTORIAL

Run SQLDeveloper and create connection to sys account.

Menu_003

  • Conenction name: SOATutorial_SYS
  • Username: sys
  • Password: welcome1
  • Role: SYSDBA
  • Hostname: localhost
  • Port: 1521
  • Service name: soadb.oracle.com

 

Zaznaczenie_004

Test and save and connect to the created connection.

Menu_005

Now we create new database user allowed to connect and manage schema resources.

Execute the script.

Zaznaczenie_006

OK, it’s time to create connection to the  BC_SOA_TUTORIAL user.

  • Conenction name: SOATutorial_BC_SOA_TUTORIAL
  • Username: BC_SOA_TUTORIAL
  • Password: BC_SOA_TUTORIAL
  • Role: default
  • Hostname: localhost
  • Port: 1521
  • Service name: soadb.oracle.com

Zaznaczenie_007

Test and save the connection.

Add DataSource to WebLogic server

In your web browser go to WebLogic Server Administration Console and login as weblogic/welcome1.

Zaznaczenie_008

Go to Services-> Data Sources and create new Generic Data Source.

Menu_009

Set Data Source name to “SoaTutorialDataSource” and JNDI to “jdbc/SoaTutorialDataSource”.

Zaznaczenie_010

On the next page leave ThinXA Database Driver, then go Next and Next.

Zaznaczenie_011

Fill database access credentials.

 

  • Database name: soadb.oracle.com
  • Host Name: localhost
  • Port: 1521
  • Conenction name: SOATutorial_BC_SOA_TUTORIAL
  • Username: BC_SOA_TUTORIAL
  • Password: BC_SOA_TUTORIAL

Zaznaczenie_012

On the next step change URL from “jdbc:oracle:thin:@localhost:1521:soadb.oracle.com” to “jdbc:oracle:thin:@localhost:1521/soadb.oracle.com”, because we use service name instead of SID. Then click “Test Configuration” and Next.

Zaznaczenie_013

On the last page select AdminServer as target and Finish.

Zaznaczenie_014

 

 

 

 

 

Facebooktwittergoogle_plusredditlinkedinmail

Leave a Reply