Difference between revisions of "OracleXE"

From SME Server
Jump to navigationJump to search
m
(better start/stop commands + formatting)
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;
  
ALTER USER ANONYMOUS ACCOUNT UNLOCK;
+
EXEC DBMS_XDB.SETHTTPPORT(8080);
  
EXEC DBMS_XDB.SETHTTPPORT(8080);
+
/etc/init.d/oracle-xe restart
 
+
</pre>
/etc/init.d/oracle-xe restart
+
Configure OracleXE to start/stop in the SMEserver way:
 
+
<pre>
  ln -s /etc/rc.d/init.d/oracle-xe /etc/rc7.d/S99Oracle
+
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/oracle-xe /etc/rc1.d/K98Oracle
+
ln -s /etc/rc.d/init.d/e-smith-service /etc/rc1.d/K01oracle-xe
 +
</pre>

Revision as of 11:13, 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