Difference between revisions of "OracleXE"
From SME Server
Jump to navigationJump to searchm |
m |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | Oracle 11.2 XE (free edition) | + | ==Oracle 11.2 XE (free edition)== |
Following this page: http://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm#XEINL121 | Following this page: http://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm#XEINL121 | ||
| Line 24: | Line 24: | ||
Again I left everything standard (8080 port and simple password) | Again I left everything standard (8080 port and simple password) | ||
| + | <pre> | ||
| + | ALTER USER ANONYMOUS ACCOUNT UNLOCK; | ||
| − | + | EXEC DBMS_XDB.SETHTTPPORT(8080); | |
| − | + | /etc/init.d/oracle-xe restart | |
| + | </pre> | ||
| + | Configure OracleXE to start/stop in the SMEserver way: | ||
| + | <pre> | ||
| + | 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 | ||
| + | </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}
