OracleXE
From SME Server
Jump to navigationJump to searchOracle 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}