LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices


Reply
  Search this Thread
Old 09-23-2006, 10:01 AM   #1
kenjiru
LQ Newbie
 
Registered: Sep 2006
Location: Romania
Distribution: Gentoo
Posts: 14

Rep: Reputation: 0
oracle xe on gentoo - no web interface


After a long and annoying process of trial and error I've managed to install Oracle XE on Gentoo Linux. Now the problem is I can't access the web interface.

Code:
kenjiru radu # ps -ef | grep tnslsnr
oracle    9416     1  0 15:02 ?        00:00:00 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER -inherit

kenjiru radu # ps -ef | grep XE
oracle    9421     1  0 15:02 ?        00:00:00 xe_pmon_XE
oracle    9423     1  0 15:02 ?        00:00:00 xe_psp0_XE
oracle    9425     1  0 15:02 ?        00:00:00 xe_mman_XE
oracle    9427     1  0 15:02 ?        00:00:00 xe_dbw0_XE
oracle    9429     1  0 15:02 ?        00:00:00 xe_lgwr_XE
oracle    9431     1  0 15:02 ?        00:00:00 xe_ckpt_XE
oracle    9433     1  0 15:02 ?        00:00:02 xe_smon_XE
oracle    9435     1  0 15:02 ?        00:00:00 xe_reco_XE
oracle    9437     1  0 15:02 ?        00:00:00 xe_mmon_XE
oracle    9439     1  0 15:02 ?        00:00:00 xe_mmnl_XE
oracle    9443     1  0 15:03 ?        00:00:00 xe_qmnc_XE
oracle    9495     1  0 15:03 ?        00:00:00 xe_q000_XE

kenjiru radu # cat /etc/default/oracle-xe|grep HTTP_PORT
HTTP_PORT=8088

kenjiru radu # netstat -anl | grep 8088
So oracle isn't listening on port 8088.

This is the first time I've installed Oracle on Linux so it is possible I've done something wrong, but I can't figure out where the problem is.

During installation process I've created a new database like this:

1. modified ORACLE_SID=XE
2. cp $ORACLE_HOME/dbs/init.ora $ORACLE_HOME/dbs/initXE.ora
3. sqlplus '/ as sysdba'
4. SQL> create database XE;

So I can start oracle like this:

Code:
kenjiru ~ # /etc/init.d/oracle start
 * Starting Oracle Net Listener ...

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-SEP-2006 15:02:49

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
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
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost,)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                23-SEP-2006 15:02:49
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File         /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost,)(PORT=1521)))
Services Summary...
Service "XE" has 1 instance(s).
  Instance "XE", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully                                                                                                                     [ ok ]
 * Starting Oracle Database 10g Express Edition Instance ...
ORACLE instance started.

Total System Global Area   96468992 bytes
Fixed Size                  1257356 bytes
Variable Size              88080500 bytes
Database Buffers            4194304 bytes
Redo Buffers                2936832 bytes
Database mounted.
Database opened.
1. How can I check if the database is really ok?
2. And why the web interface doesn't work?
 
Old 09-23-2006, 02:55 PM   #2
MensaWater
LQ Guru
 
Registered: May 2005
Location: Atlanta Georgia USA
Distribution: Redhat (RHEL), CentOS, Fedora, CoreOS, Debian, FreeBSD, HP-UX, Solaris, SCO
Posts: 7,454
Blog Entries: 15

Rep: Reputation: 1449Reputation: 1449Reputation: 1449Reputation: 1449Reputation: 1449Reputation: 1449Reputation: 1449Reputation: 1449Reputation: 1449Reputation: 1449
Haven't worked with XE and am not a DBA but have looked at Oracle on multiple UNIX/Linux systems.

So I did want to mention you can check which port the listener is actually using.

ps -ef |grep listener
Will give you the PID.

lsof -p <PID>
Will show you the open file handles of the process including the network ports.

It may simply be it is not listening on the port you think it is.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle Web Frontend Similar to phpMyAdmin? firefly2442 General 0 11-11-2005 07:33 PM
Installed Oracle 10g in Gentoo/Whitebox Robert0380 LinuxQuestions.org Member Success Stories 3 03-31-2005 04:00 PM
Firewall Web Interface SolidSnake Linux - Security 2 10-04-2004 08:37 AM
how to install the oracle 9i on GUI interface??? alexlam50 Linux - Software 4 11-16-2003 05:20 PM
Oracle web based administration puzz_1 Linux - Software 0 06-10-2003 07:09 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Networking

All times are GMT -5. The time now is 11:09 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration