Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: fpausp on June 26, 2009, 06:30:59 PM

Title: Oracle 10g XE on SME 8 b4
Post by: fpausp on June 26, 2009, 06:30:59 PM

Hi All,

I tried a quick and dirty install of oracle 10g xe on sme 8 beta 4, can anyone help me ?

I wrote my own litte draft-howto:

Code: [Select]


# Download the rpm from
http://www.oracle.com/technology/software/products/database/xe/htdocs/102xelinsoft.html

# install oracle 10g xe with
yum install oracle-xe-univ-10.2.0.1-1.0.i386.rpm

# configure oracle 10g xe with
/etc/init.d/oracle-xe configure

# create an ibay called oracle-xe

# Link the getting started html files to the ibay
cd /home/e-smith/files/ibays/oracle-xe/html
ln -s /usr/lib/oracle/xe/app/oracle/doc/* .
chown -R www:www *

# customize ibay settings to enable FollowSymLinks:
db accounts setprop oracle-xe FollowSymLinks enabled
signal-event ibay-modify

# start service on bootup
ln -fs /etc/rc.d/init.d/oracle-xe /etc/rc7.d/S99oracle-xe
reboot

# optional
# open the firewall for remote access
config set oracle-xe service access public status enabled TCPPort 1521
signal-event remoteaccess-update
signal-event reboot

# visit http://serverip/oracle-xe/getting_started.htm for a starting point



but i dont know how to get the http://127.0.0.1:8080/apex working

any suggestions ?

Title: Re: Oracle 10g XE on SME 8 b4
Post by: fpausp on June 26, 2009, 06:54:10 PM

Hi,

Make a ssh connection to the sme 8 server:

Code: [Select]

ssh -L 8888:localhost:8080 root@internal-serverip

That should redirect the port 8080 to 8888 on your localhost (client)

Open a Browser with the following Link:

Code: [Select]

http://localhost:8888/apex


Please help me testing

regards
fpausp

Title: Re: Oracle 10g XE on SME 8 b4
Post by: Franco on July 20, 2009, 09:13:48 PM

Hi,
So far, so good!
Have you found another way to make the connection to the admin interface without having to proxy it?
It's awkward that oracle requires this graphical interface on the server itself to manage it.

Title: Re: Oracle 10g XE on SME 8 b4
Post by: fpausp on July 21, 2009, 03:25:25 PM

Hi,

No, at the moment i am searching a way to backup the db ...
I bought a book to learn more about that.

Have you skills in that direction ?

Best
fpausp

Title: Re: Oracle 10g XE on SME 8 b4
Post by: Franco on July 21, 2009, 03:38:57 PM

Fausp,
There's a client application that can do pretty much everything the graphical web interface does. It's provided by Oracle. I'll search it and report back.

Thanks,

Title: Re: Oracle 10g XE on SME 8 b4
Post by: fpausp on July 21, 2009, 06:29:45 PM

Hi,

That sounds good :-)

Best
fpausp

Title: Re: Oracle 10g XE on SME 8 b4
Post by: Stefano on July 21, 2009, 07:33:28 PM

Quote from: fpausp on June 26, 2009, 06:30:59 PM

I wrote my own litte draft-howto:

Code: [Select]


# start service on bootup
ln -fs /etc/rc.d/init.d/oracle-xe /etc/rc7.d/S99oracle-xe

# optional
# open the firewall for remote access
config set oracle-xe service access public status enabled TCPPort 1521


I suggest you to do

Code: [Select]


ln -fs /etc/rc.d/init.d/e-smith-service /etc/rc7.d/S99oracle-xe

config set oracle-xe service  status enabled

in this way you can enable/disable oracle via db commands

my 2c

Stefano

Title: Re: Oracle 10g XE on SME 8 b4
Post by: fpausp on July 21, 2009, 08:11:52 PM

Hi,

Ok, thanks for advise.

regards
fpausp

Title: Re: Oracle 10g XE on SME 8 b4
Post by: Franco on July 22, 2009, 04:03:17 PM

OK, the application is OracleSQLDeveloper: http://www.oracle.com/technology/products/database/sql_developer/index.html
I hope it helps.

Thanks,

Title: Re: Oracle 10g XE on SME 8 b4
Post by: fpausp on July 26, 2009, 07:51:13 PM

Hi Franco,

Thanks for the Info, it is working very well over the vpn (pptp).

Best
fpausp