Versions Compared

Old Version 4

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

Follow the instructions below to set up the Oracle database.

Info

For Oracle RAC, refer to Setting up with Oracle RAC

...

Table of Contents
maxLevel3
minLevel3
styleborder:1
locationtop
typeflat
separatorpipe

...

Code Block
$ sudo /etc/init.d/oracle-xe restart

Image RemovedImage Added

2. Connect to Oracle using SQL*Plus as sysdba.

Code Block
$ ./${ORACLE_HOME}/config/scripts/sqlplus.sh sysadm/password as sysdba

Image RemovedImage Added

2.1. Connect to instance with username and password.

...

Code Block
Create user USER_NAME identified by PASSWORD account unlock;
grant connect to USER_NAME;
grant create session, dba to USER_NAME;
commit;

For example,

Image RemovedImage Added

4. Exit from the SQL*Plus session by typing the "quit" command.

Code Block
SQL> quit

Image RemovedImage Added

Setup Configuration File

1. Edit the default database configuration defined in the  master-datasources.xml  file located at  $CARBON_HOME/repository/conf/datasources  directory as follows. Both the database configurations in  registry.xml  and  user-mgt.xml  refer this data source.

Image RemovedImage Added

Info

Replace these settings with your own custom values:

...

Info

When using the ojdbc6.jar with WSO2 servers there is a possibility of throwing an timezone region not found error. To overcome this issue it is necessary to set the java property as export JAVA_OPTS="-Duser.timezone='+05:30'". The value of this property should be the GMT difference of the country.  

if it is necessary to set this property permanently, then it should be defined inside the wso2server.sh as a new JAVA_OPT property.

Create Database Tables

Database tables can be created either manually by running scripts or automatically by using start-up parameters.

...