Install Oracle10g xe on ubuntu 9.04

Today, we will introduce you to the actual steps for installing Oracle10g xe on ubuntu 9.04. Most people will feel dizzy when installing Oracle10g xe on ubuntu 9.04 ", in fact, if you have some knowledge about the actual operation steps, you will feel very simple.

In the past, we often used Oracle's lightweight server Oracle xe in the development environment. It is suitable for Oracle10g environments in windows.

Installing Oracle on linux is a pain point. This is because many preparations need to be made for the installation. In addition, Oracle installation is based on the redhat version. Ubuntu server is a good version of linux server, but has little enterprise support, such as Oracle and other software providers.

The company needs to transplant the previous Oracle Database stuff. Install express editionXE on ubuntu server for emergency purposes ). This version is very easy to install on ubuntu. However, garbled characters were found during the import of utf8-encoded Oracle Database backups. The reason is:

Reference

Western European

The database created using a single-byte Latin1 (WE8MSWIN1252) character set, which is suitable for storing Western European language data

Universal

The database is created using a multibyte (AL32UTF8) character set, which is suitable for global data in any language.

Previously, only versions of the western character set are supported. Refer to the relevant documentation to list the installation and configuration steps below. First, you must set the source of Oracle xe:

Java code

 
 

  
  
sudo vim /etc/apt/sources.list   
  
  
sudo vim /etc/apt/sources.list  
 
 

Add:

Java code

 
 

  
  
deb http://oss.Oracle.com/debian unstable main non-free   
  
  
deb http://oss.Oracle.com/debian unstable main non-free  
 
 

To install Oracle10g xe in ubuntu 9.04, run the above steps. Then add the public key of the source server to the keystore of the local apt system:

Ava code

 
 

  
  
wget http://oss.Oracle.com/el4/RPM-GPG-KEY-Oracle
 -O- | sudo apt-key add -   
  
  
wget http://oss.Oracle.com/el4/RPM-GPG-KEY-Oracle
-O- | sudo apt-key add -  
 
 

Then, update the apt Library:

Java code

 
 

  
  
apt-get update   
  
  
apt-get update  
 
 

First, you need to configure apt-get. For details, see install Oracle XE under ubuntu server.

The above content is an introduction to the steps for installing Oracle10g xe on ubuntu 9.04. I hope you will find some gains.