Difference between revisions of "OracleXE"

From SME Server
Jump to navigationJump to search
m
 
Line 39: Line 39:
 
Now you can control Oracle-XE using this command:
 
Now you can control Oracle-XE using this command:
 
  service oracle-xe {start|stop|restart|force-reload|configure|status|enable|disable}
 
  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}