Installing Oracle 11g SOASuite – Part 1: Oracle Database 11g XE

Tags

11G, Composer, Console, DataBase, Deploy, Domain, EM, JDeveloper, Linux, MEMORY TARGET, MEMORY_TARGET not supported on this system, ORA-00845, Oracle, SOA, Soa-Suite, SUDO, Ubuntu, XE, XE

To test scenarios is essential to establish a local environment in order to deepen our learning and knowledge, thinking about it in this post I will show step by step how is the Oracle Soa Suite 11g installation.

The SOA Suite requires a database for persistence. The Express Edition 11g was chosen for development environment in question.

The installation will be done on Ubuntu Linux 64bit version: 4.14, the minimum hardware and software for Oracle 11g SOASuite installation can be found here: http://docs.oracle.com/html/E18558_01/fusion_requirements.htm

For installation I need to divide it into parts as follows:

Download Oracle Database Express Edition 11g Release 2

Download the required file using the link:

http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html

Here, click Accept License Agreement

Select the Download Oracle Database Express Edition 11g Release 2 for Linux x64

You see the Login screen below if you do not have an account please create it will be necessary for the other downloads.

Made Login will see the message below: then choose the Save File option and click OK to save our file:

Performed the download, we will prepare our environment for installation:

See that the file is with the RPM.ZIP extension and so you must convert it to DEB for installation in our environment and also for setting up our file and other SOASuite packages you must install the file libaio1

On the Ubuntu Command Prompt, run the following commands:

This command updates its libs Ubuntu:

sudo apt-get update

This command installs the necessary libs for installation:

sudo apt-get install alien libaio1 unixodbc vim

Now let’s unpack our oracle-xe-11.2.0-1.0.x86_64.rpm.zip file that held the download

Enter the folder where was downloaded and unzip the file:

sudo unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip

Note that within the Download folder it automatically created pasta Disk1:

Enter the folder and run the command to turn the .rpm files to .deb:

sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm

Note: This command may take 2-10 minutes depending on your hardware configuration

See the Disk1 folder where the file was created oracle-xe_11.2.0-2_amd64.deb

Now execute the following commands:

Note: These commands avoid the following error: MEMORY TARGET error ( ORA-00845: MEMORY_TARGET not supported on this system ):

sudo rm -rf /dev/shm
sudo mkdir /dev/shm
sudo mount -t tmpfs shmfs -o size=2048m /dev/shm

Since these changes are only temporary for the current session will be lost after a system reboot. In order to make them permanent, you can create a startup script allowing you to add the above steps for a file, make them executable and automatically start them with the system.

Now execute the following commands:

sudo touch /etc/rc2.d/S10oracle-mount
sudo gedit /etc/rc2.d/S10oracle-mount

Was created S10oracle-mount file, then copy the text below and paste into this file:

#! /bin/sh
### BEGIN INIT INFO
# Provides:          Creates Oracle mount point
# Required-Start:    
# Required-Stop:     
# Default-Start:     2 3 4 5
# Default-Stop:      0 1 6
# Short-Description: Used for Oracle installation
# Description:       Used for Oracle installation
### END INIT INFO

# Aktionen
case "$1" in
    start)
        mkdir /var/lock/subsys 2>/dev/null
        touch /var/lock/subsys/listener
        rm /dev/shm 2>/dev/null
        mkdir /dev/shm 2>/dev/null
        mount -t tmpfs shmfs -o size=2048m /dev/shm
        ;;
    stop)
        ;;
    restart)
        ;;
esac
exit 0

Save and close the file and run the command to give the necessary permissions:

sudo chmod 755 /etc/rc2.d/S10oracle-mount

Now let’s create some users for Oracle running the following commands:

sudo su -
groupadd oinstall
groupadd dba
useradd -m -g oinstall -G dba oracle
passwd oracle

enter the password 123 or whatever you want, then repeat the password

groupadd nobody
usermod -g nobody nobody

Now run the following command:

sudo gedit /etc/rc2.d/S01shm_load

Was created S01shm_load file, then copy the text below and paste into this file:

#!/bin/sh
case “$1” in
start) mkdir /var/lock/subsys 2>/dev/null
touch /var/lock/subsys/listener
rm /dev/shm 2>/dev/null
mkdir /dev/shm 2>/dev/null
mount -t tmpfs shmfs -o size=2048m /dev/shm ;;
*) echo error
exit 1 ;;
esac

Save and close the file and run the command to give the necessary permissions:

sudo chmod 755 /etc/rc2.d/S01shm_load

Now run the following command:

sudo gedit /etc/sysctl.conf

Will open the sysctl.conf file

At the end of the add file as follows:

###########
# Oracle XE Recommended Values
kernel.sem = 250 32000 100 128
kernel.shmmax = 536870912
##########

Save and close the file and run the command:

sudo gedit /sbin/chkconfig

Was created chkconfig file, then copy the text below and paste into this file:

#!/bin/bash
file=/etc/init.d/oracle-xe
if [[ ! `tail -n1 $file | grep INIT` ]]; then
echo >> $file
echo ‘### BEGIN INIT INFO’ >> $file
echo ‘# Provides: OracleXE’ >> $file
echo ‘# Required-Start: $remote_fs $syslog’ >> $file
echo ‘# Required-Stop: $remote_fs $syslog’ >> $file
echo ‘# Default-Start: 2 3 4 5’ >> $file
echo ‘# Default-Stop: 0 1 6’ >> $file
echo ‘# Short-Description: Oracle 11g Express Edition’ >> $file
echo ‘### END INIT INFO’ >> $file
fi
update-rc.d oracle-xe defaults 80 01

Save and close the file and run the command to give the necessary permissions:

sudo chmod 755 /sbin/chkconfig

Now run the following command to set the kernel parameters:

sudo gedit /etc/sysctl.d/60-oracle.conf

Will open the 60-oracle.conf file

Within the add file as follows:

# Oracle 11g XE kernel parameters
fs.file-max=6815744
net.ipv4.ip_local_port_range=9000 65000
kernel.sem=250 32000 100 128
kernel.shmmax=536870912

Save and close the file

Make sure the file was saved successfully running the following command:

sudo cat /etc/sysctl.d/60-oracle.conf

Should show the screen below:

Run the following command to load the kernel parameters:

sudo service procps start

Now run the following commands:

sudo ln -s /usr/bin/awk /bin/awk
sudo mkdir /var/lock/subsys
sudo touch /var/lock/subsys/listener

Ready … We’re ready to install Oracle 11g XE … “Ufffaaaaa“:-)

Now inside the folder where you were ../Downloads/Disk1 run the following command to run the file:

sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb

Everything OK so far, there’s only configure Oracle XE, for this run the following command:

sudo /etc/init.d/oracle-xe configure

In the question below just hit ENTER: to accept the defaults

Specify the HTTP port that will be used for Oracle Application Express [8080]:

Back to the question below press ENTER to accept the default value

Specify a port that will be used for the database listener [1521]:

In the question below will be your password sys User, then place 123

/etc/init.d/oracle-xe: line 405: /bin/awk: No such file or directory
Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:

This question only place the Y value (for Oracle XE be started along with your ubuntu when it is started)

Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:

So far so OK as below:

However, even if it appears “the errors below” there will be no problems for these errors on lines 775, 776, 777, 778, 779, 780, 781 and 782 are just because there ‘single quotation marks‘ the end of the file /etc/init.d/oracle-xe as follows:

‘### BEGIN INIT INFO’
‘# Provides: OracleXE’
‘# Required-Start: ’
‘# Required-Stop: ’
‘# Default-Start: 2 3 4 5′
‘# Default-Stop: 0 1 6′
‘# Short-Description: Oracle 11g Express Edition’
‘### END INIT INFO’

Every time you stop or start Oracle will see the message above, but if you want to stop display these errors, just take the ‘single quotes’ so that they are as follows:

Edit with the following command:

sudo gedit /etc/init.d/oracle-xe

Scroll to the end of file and check how the image above.

Note: If the errors are different from the above, check the problem and not proceed with the other SOASuite facilities.

Now run the following command:

sudo gedit ~/.bashrc

Opened the .bashrc file, then copy the text below and paste into the end of this file:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH

Save and close the file

Run the following command to return to your HOME:

Now run this command to load your settings:

. ./.profile

Now enter the SqlPlus

Enter: sqlplus on your terminal

Enter user-name: sys as sysdba

Enter Password: (in my case put 123)

Imagem Blog Uans Carvalho

Run the commands to increase the numbers of processes and Oracle sessions:

alter system set sessions = 600 scope=spfile; alter system set processes = 750 scope=spfile;

Then:

Shutdown;

And then:

Startup;

To test in your browser type:

http://localhost:8080/apex

If you see the Browser screen below your installation was successful:

If you want to access, enter this information:

Workspace: INTERNAL
Username: ADMIN
Password: (enter the password you entered when installing)

Note: The first time you access will be prompted to change the password but can put the same if you want.

After that, follow the screen with login successfully performed:

Hugs and to the Next

/:-D

UansCarvalho

~ Blog for Oracle SOA Developers

Installing Oracle 11g SOASuite – Part 1: Oracle Database 11g XE

Related Posts

Related

Leave a Reply