Still unable to unstall oracle xe

I have downloaded oracle-xe-univ-10.2.0.1-1.0.i386.rpm from oracle’s website and installed it on my new opensuse 11.2 using yast (simple click in kde).
then i called (to configure it).


# /etc/init.d/oracle-xe configure

But could not start it. I get the following error


vpc-laptop:/home/vpc # /etc/init.d/oracle-xe restart
Shutting down Oracle Database 10g Express Edition Instance.
Stopping Oracle Net Listener.

Starting Oracle Net Listener.
Starting Oracle Database 10g Express Edition Instance.
Failed to start Oracle Net Listener using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr and Oracle Express Database using /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus.

I tried to do all manually


# rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm
Préparation...              ########################################### [100%]
   1:oracle-xe-univ         ########################################### [100%]
Executing Post-install steps...

insserv: warning: script 'oracle-xe' missing LSB tags and overrides
insserv: Default-Start undefined, assuming default start runlevel(s) for script `oracle-xe'
insserv: script vmware-mgmt: service VMware already provided!
insserv: script vmware: service VMware already provided!
insserv: script vmware-autostart: service VMware already provided!
insserv: Script jexec is broken: incomplete LSB comment.
insserv: missing `Required-Stop:'  entry: please add even if empty.
oracle-xe                 0:off  1:off  2:off  3:on   4:off  5:on   6:off
You must run '/etc/init.d/oracle-xe configure' as the root user to
configure the database.

and then re configure it



# /etc/init.d/oracle-xe configure

Oracle Database 10g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 10g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:9090

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of
different passwords for each database account.  This can be done after
initial configuration:
Confirm the password:

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:no

Invalid response: no
Starting Oracle Net Listener...Done
Configuring Database...grep: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/config/log/*.log: No such file or directory
Done
/bin/chmod: cannot access `/usr/lib/oracle/xe/oradata/XE': No such file or directory
/bin/chmod: cannot access `/usr/lib/oracle/xe/oradata/XE': No such file or directory
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.
To access the Database Home Page go to "http://127.0.0.1:9090/apex"

but configuration seems not to be successful. Oracle simply does not work.

This same version used to work perfectly on opensuse 11.1.
any idea?

  1. Did you run the configure script as root?
  2. Check if `/usr/lib/oracle/xe/oradata/XE’ does exist, if not, your installation went wrong, and configuring it makes no sense…

Took a look at your errors once more, and noticed that you may not have a fully qualified network address for your machine in your host file like
192.168.1.10 mymachine.mydomain.com mymachine

Put it on top, just after 127.0.0.1

Finally i figured it out.
Thank you rvanderhoorn but the problem is not with my config.
The problem is the rpm script installer not the configurer it self.
the evel message is “warning: script ‘oracle-xe’ missing LSB tags and overrides”
Indeed as of this new opensuse release, LSB implementation is stricter and thus does not run oracle’s post install script.
Particularly, the problem is with oracle password.
The simplest work around i found is
0- su % to login as root
1- install the RPM
2- su
3- passwd oracle % to change oracle password, choose any pwd you’d like
4- exit % return as root
5- /etc/init.d/oracle-xe configure % to configure xe db

it worked for me. It should work for other too.

Congratulations :slight_smile: this has been driving me spare :\