OracleXE

From SME Server
Jump to navigationJump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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}