Hi all ive installed oracle 10g xe-univ.rpm on mandriva 2009.
Followed the following default method
PHP Code:
/etc/init.d/oracle-xe configure
Oracle Database 10g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database XE. 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]:8081
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: (* make sure you remember this password *)
Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]: y
Starting Oracle Net Listener...Done
Configuring Database...Done
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.
To access the Database Home Page go to "http://127.0.0.1:8080/apex"
But Im facing the following problems now :: -
1. > Oracle isnt running
$ sudo /etc/rc.d/init.d/oracle-xe start
$ ps -aux | grep -i oracle
oracle 21089 0.0 0.2 22008 5900 ? Ss 22:38 0:00 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER -inherit
2. > My listener.log
PHP Code:
TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 24-APR-2009 21:37:31
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0
Started with pid=9524
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
24-APR-2009 21:37:31 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 24-APR-2009 22:00:29
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0
Started with pid=10122
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
24-APR-2009 22:03:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listener completed notification to CRS on stop
24-APR-2009 22:22:35 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost)(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * stop * 0
TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 24-APR-2009 22:22:35
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0
Started with pid=3474
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
24-APR-2009 22:22:35 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listener completed notification to CRS on stop
24-APR-2009 22:38:02 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost)(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * stop * 0
TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 24-APR-2009 22:38:02
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0
Started with pid=21089
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
24-APR-2009 22:38:02 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=localhost)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
24-APR-2009 22:46:03 * stop * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
24-APR-2009 22:46:03 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
24-APR-2009 22:46:06 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
24-APR-2009 22:46:11 * 12502
3. > Connection refuse error on firefox when i try
http://localhost:8081/apex
I have tired googling since last 2 days but no help. Even if somebody has solved it,but they havnt posted the complete solution.People should at least post the complete solutiun instead of just saying -- "thanks its solved". Such practice would save a lot of headace for everybody.
Oracle 10g xe on mandriva 2009
