Topic: Oracle 10g XE on SME 8 b4

[fpausp]

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 ?

[fpausp]

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

[Franco]

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.

[fpausp]

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

[Franco]

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,

[fpausp]

Hi,

That sounds good

Best
fpausp

[Stefano]

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

[fpausp]

Hi,

Ok, thanks for advise.

regards
fpausp

[Franco]

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

Thanks,

[fpausp]

Hi Franco,

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

Best
fpausp