Wednesday, March 6, 2013

Oracle XE on Debian

This is short introduction how to install and use Oracle XE database on Debian. Oracle web page offer only two version of XE database for download (for Windows x32 and Linux x64), but on "Oracle Open Source Software" is available i386 version of Debian package: https://oss.oracle.com/debian/dists/unstable/non-free/binary-i386/

Installation:


After download package, we can start install package:
  • $ sudo dpkg -i oracle-xe-universal_10.2.0.1-1.1_i386.deb
Next we execute "after installation" configuration. We can keep parameters that are as default in configuration process, except "user password" and maybe number of port for web manager (8080 replace by for example 8180):
  • $ sudo /etc/init.d/oracle-xe configure

Default username is: 
  • system

Oracle web manager:

Oracle web manager is running on "localhost" address:


Oracle SQL Developer:

Quote: "Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database." This tool is available on Oracle home page, but if you want to download, you must register (horror). Another solution is to find this package on "One-click hosting" (for example: sqldeveloper-3.2.20.09.87-no-jre.zip).

After download and unpack, we must change file mode:
  • chmod 755 /sqldeveloper/sqldeveloper.sh 

And then we can run tool. For first start we must setting path to JVM (in my case: JAVA_HOME=/usr/lib/jvm/java-6-sun):
  • $ /sqldeveloper/sqldeveloper.sh


SQLplus:

Oracle command-line interface "sqlplus" is good hiding. The file path is following in my installation:
  • /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/scripts/runsqlplus.sh


SQL commands:

And finally, several examples of SQL commands (sqlplus):

login:
  • SQL> connect  system/oracle
view all users:
  • SQL> select * from all_users;
view all tables:
  • SQL> select * from dict;
execute an SQL script from file:
  • SQL > @/oracle/scripts/script.sql


No comments:

Post a Comment