Installing Oracle XE 11g on Ubuntu 11.10

Ubuntu is not supported OS for Oracle XE 11g but still we can make it work by following below post. The main issue is due to memory management used by previous version vs ubuntu 11.10.

https://forums.oracle.com/forums/thread.jspa?threadID=2301639

More information about creating users & workspace - http://docs.oracle.com/cd/E17781_01/admin.112/e18585/toc.htm#autoId3

How to assign normal privilages for any database user

You can revoke sysdba privileges from HR schema.

REVOKE sysdba from HR.

Normal HR schema will have privileges as below

GRANT CREATE SESSION TO hr;
GRANT ALTER SESSION TO hr;
GRANT CREATE DATABASE LINK TO hr;
GRANT CREATE SEQUENCE TO hr;
GRANT CREATE SYNONYM TO hr;
GRANT CREATE VIEW TO hr;
GRANT RESOURCE TO hr;
GRANT execute ON sys.dbms_stats TO hr;

You can find demo scripts at
$ORACLE_HOME/demo/schema folder

Oracle XE 11g Beta has been released

It sounds like an April 1st joke, the long awaited Oracle XE 11g Beta Version, but it is not. On OTN you can download either a Windows Installer or a Linux Installer.

In short the limitations of XE 11g:

* only one CPU is used
* only one installation of XE per Computer
* up to 11 gigabyte of user-data is allowed ! (XE10 had only 4GB)
* only 1 GB RAM is used (at most)
* no HTTPS with the built in EPG

Link to the : installation guide

Link to : more information

Link to the : download location

The only thing you have to enter during the installation was a password for the SYS and SYSTEM DB Users, the rest went with the defaults. Just a couple minutes later XE 11g was up and running :-)

The first thing i did was allowing remote access to the new and shiny graphical admin interface. Simply enter this command “EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);” when connected to SQLPLUS as SYS or SYSTEM.

With the URL http://<hostname>:8080/apex/f?p=4950 you can start the graphical admin interface of your XE 11g database.

Try it yourself, It looks really great!

Exception in thread "main" java.lang.UnsatisfiedLinkError: Can't load library - libmawt.so

When installing any fusion middleware products, if the java run time has mismatch with underlying architecture, then you will get the below error:

Exception in thread "main" java.lang.UnsatisfiedLinkError: Can't load library

libmawt.so

 

Sample Scenario:-

When I tried installing rcu, I got the above error. The reason is that,

it was always using the jdk which comes with rcu bundle by default. Since

my machine has 64 bit architecture and the default jdk is made for 32 bit,

I got the above error.

Solution:-

Install 64 bit amd version and update the JAVA_HOME. If rcu still uses old jdk

path, replace the jdk folder of rcu with latest one.

Installing Oracle Express Edition on Ubuntu 11.04

I almost spent the half day of installing Oracle XE database in Ubuntu 11.04 and after going through many blogs, I found better way to install it.

Remember that there is no direct installation file available for ubuntu i.e., debian packages. You get only rpm version of oracle-xe installation file from oracle.com and you need to tweak to install as debian.

First, query for existing oracle packages and uninstall old versions of database.

dpkg-query -l | grep oracle

Now you can uninstall as follows

dpkg -r <package_name>

Now follow the below article to install as deb file.

http://forums.oracle.com/forums/thread.jspa?messageID=9611617

ORA-01157: cannot identify/lock data file

Unfortunately I deleted dbf file from file system and I got stuck with the below error when trying to create table space.

SQL> create tablespace content_system datafile 'd:/UCM/tablespace/stellent_temp.dbf' size 500M;

create tablespace content_system datafile 'd:/UCM/tablespace/stellent_temp.dbf' size 500M

*

ERROR at line 1:

ORA-01109: database not open

Now the solution is,

SQL> alter database datafile 'd:/UCM/tablespace/stellent_temp.dbf' OFFLINE DROP;

Database altered.

SQL> alter database open;

Database altered.