Problems galore with oracle 10g-xe on mandriva-2009

Problems galore with oracle 10g-xe on mandriva-2009 Rate Topic:

#1 rushadrenaline

Newbie (User Level: 0/10)

Group: Members
Posts: 3
Joined: 25-April 09

Post icon Posted 25 April 2009 - 07:21 AM

Hi all ive installed oracle 10g xe-univ.rpm on mandriva 2009.
Followed the default method and installed it om port 8080 ,then 8081 but it still aint working.
The problems that im facing are :
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

Quote

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 24-APR-2009 21:37:31

Copyright © 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)(ARGU
MENTS=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 © 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)(ARGU
MENTS=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)(ARGUME
NTS=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 © 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)(ARGU
MENTS=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)(ARGUME
NTS=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 © 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)(ARGU
MENTS=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.

#2 sahab

User Level: 1/10

Group: Members
Posts: 17
Joined: 20-March 09
Gender:Male
Interests:Unix,Linux,Friendship

Post icon Posted 25 April 2009 - 08:21 AM

rushadrenaline, on Apr 25 2009, 12:51 PM, said:

Quote

Hi

Try to connect the using telnet

sudo telnet localhost 8080

Also find if the port is opent

#namp localhost

#3 rushadrenaline

Newbie (User Level: 0/10)

Group: Members
Posts: 3
Joined: 25-April 09

Posted 25 April 2009 - 01:59 PM

Nmap localhost gave the following :: --
$.] nmap localhost

Starting Nmap 4.76 ( http://nmap.org ) at 2009-04-25 19:24 IST
Interesting ports on localhost (127.0.0.1):
Not shown: 996 closed ports
PORT STATE SERVICE
80/tcp open http
631/tcp open ipp
1521/tcp open oracle
6000/tcp open X11

Nmap done: 1 IP address (1 host up) scanned in 0.15 seconds

Telnet localhost did not give any output.
$. ] sudo telnet localhost 1521
Trying 127.0.0.1...
Connected to localhost (127.0.0.1).
Escape character is '^]'.
?
help