Difference between revisions of "OracleXE"
From SME Server
Jump to navigationJump to search (better start/stop commands + formatting) |
m |
||
| (One intermediate revision by the same user not shown) | |||
| Line 37: | Line 37: | ||
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc1.d/K01oracle-xe | ln -s /etc/rc.d/init.d/e-smith-service /etc/rc1.d/K01oracle-xe | ||
</pre> | </pre> | ||
| + | Now you can control Oracle-XE using this command: | ||
| + | service oracle-xe {start|stop|restart|force-reload|configure|status|enable|disable} | ||
| + | |||
| + | |||
| + | [[Category:Howto]] | ||
Latest revision as of 11:21, 1 February 2015
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}
