OracleXE

From SME Server
Jump to navigation Jump to search

Oracle 11.2 XE (free edition)

Following this page: http://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm#XEINL121

Download Oracle XE for Linux (I´ve tested only on 64 bits env)

unzip downloaded file:

unzip oracle...

enter directory Disk1

cd Disk1

install rpm

rpm -Uv oracle...

I accepted all defaults (port 8080) and create a simple password just for startup.


run sqlplus

/u01/app/oracle/product/11.2.0/xe/bin/sqlplus

execute these commands

@apxconf /u01/app

Again I left everything standard (8080 port and simple password)

ALTER USER ANONYMOUS ACCOUNT UNLOCK;

EXEC DBMS_XDB.SETHTTPPORT(8080);

/etc/init.d/oracle-xe restart

Configure OracleXE to start/stop in the SMEserver way:

config set oracle-xe service status enabled TCPPort 8080
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc7.d/S99oracle-xe
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc1.d/K01oracle-xe

Now you can control Oracle-XE using this command:

service oracle-xe {start|stop|restart|force-reload|configure|status|enable|disable}