LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 11-26-2009, 01:43 PM   #1
criathar
LQ Newbie
 
Registered: Nov 2009
Posts: 5

Rep: Reputation: 0
cannot connect to oracle admin page after install


Been trying to connect to oracle-xe 10g on fedora12 linux for a week. I'm a real newb and just starting to learn linux and oracle. When I try to connect to home admin page the error I get is:
Unable to connect
Firefox can't establish a connection to the server at 127.0.0.1:8080


Tried this:
# telnet localhost 8080
Trying ::1...
telnet: connect to address ::1: Connection refused
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused


below I pasted some output to help diagnose problem. I noticed that this is an issue to a lot of people. But I have'nt seen a clear answer on how to fix the problem. I used the following commands from forums not my memory.


After I start database
# using service oracle-xe start
and use
# service oracle-xe status
I get this

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 26-NOV-2009 11:26:39

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

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 26-NOV-2009 09:09:54
Uptime 0 days 2 hr. 16 min. 45 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 "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


# netstat -tlnp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1166/sshd
tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN 927/cupsd
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 1337/sendmail: acce
tcp 0 0 0.0.0.0:36520 0.0.0.0:* LISTEN 1118/rpc.statd
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN 892/rpcbind
tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN 2057/tnslsnr
tcp 0 0 :::22 :::* LISTEN 1166/sshd
tcp 0 0 ::1:631 :::* LISTEN 927/cupsd
tcp 0 0 :::443 :::* LISTEN 1231/httpd
tcp 0 0 :::111 :::* LISTEN 892/rpcbind
tcp 0 0 :::80 :::* LISTEN 1231/httpd


# ps ax
PID TTY STAT TIME COMMAND


1817 ? S 0:00 /usr/libexec/notification-area-applet --oaf-activate-iid=OAF
1823 ? S 0:00 /usr/libexec/gvfsd-burn --spawner :1.7 /org/gtk/gvfs/exec_sp
1835 ? Ss 0:00 /sbin/mount.ntfs /dev/sdb1 /media/Local Disk -o rw,nosuid,no
1857 ? S 0:00 /bin/sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/
1858 ? S 0:00 /bin/sh /usr/lib64/firefox-3.5.5/run-mozilla.sh /usr/lib64/f
1874 ? Sl 2:18 /usr/lib64/firefox-3.5.5/firefox http://127.0.0.1:8080/apex
1947 ? Sl 0:04 gnome-terminal
1948 ? S 0:00 gnome-pty-helper
1949 pts/0 Ss 0:00 bash
1994 pts/0 S 0:00 su
2000 pts/0 S 0:00 bash
2057 ? Ss 0:00 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnsl
11179 ? S< 0:00 [scsi_eh_2]
11180 ? S< 0:00 [usb-storage]
11185 ? S< 0:00 /sbin/udevd -d
11187 ? S< 0:00 /sbin/udevd -d
11197 ? S 0:00 hald-addon-storage: polling /dev/sdc (every 2 sec)
11207 ? S 0:00 /usr/libexec/gvfsd-metadata
11337 pts/0 R+ 0:00 ps ax
[root@impulse impulse]# service oracle-xe status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 26-NOV-2009 11:26:39

Last edited by criathar; 11-26-2009 at 01:52 PM. Reason: too long
 
Old 11-26-2009, 01:53 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
Hi, welcome to LQ!

Is SELinux enabled?


Cheers,
Tink
 
Old 11-26-2009, 02:00 PM   #3
criathar
LQ Newbie
 
Registered: Nov 2009
Posts: 5

Original Poster
Rep: Reputation: 0
enabled

I wouldn't know how to enable SELINUX. I can go to SELinux management tool but do not see what to enable. Since you mentioned it I went to the network port tab and looked at port 8080 and it said it was a http_cache_port_t the level is s0. Does that mean it is off? if so how do I get the level higher?
 
Old 11-26-2009, 02:06 PM   #4
criathar
LQ Newbie
 
Registered: Nov 2009
Posts: 5

Original Poster
Rep: Reputation: 0
newb

I am so new to linux it hurts but am trying to learn. Actually I am liking it so far.
 
Old 11-26-2009, 02:20 PM   #5
paulsm4
LQ Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
Hi -

You've definitely picked a challenging goal . But I have confidence in you!

ANYWAY: Here's what we know:
Quote:
1. You're trying to get Oracle working under Linux. You're getting a "connect" error. The problem could be in Oracle, in Linux or both.

2. Oracle has an administrative web interface. You're trying to access it with:
Quote:
firefox http://127.0.0.1:8080
3. IP address "127.0.0.1" is "localhost": the host you're actually logged in to. "8080" is the TCP/IP port you expect this administrative web interface to be listening on. Port "80", in contrast, is an ordinary HTTP web server. And port "1521" is the port *Oracle* talks on. You talk to the port 8080 web server, and the web server talks to Oracle. That's the goal, anyway.

4. Both the Firefox "Unable to connect" and telnet "Connection refused" errors are telling you pretty much the same story:

a) You don't have a program listening on port 8080 on your localhost.
... and/or ...
b) "Something" (a firewall, SELinux, etc) is preventing you from connecting to that program.
OK, so what are your options?
Quote:
1. If you have SELinux running, disable it.

2. If you have a firewall running, make sure port 8080 is open.

... and, the first thing to look for ...

3. If you know how to turn on the Oracle web admin interface (the software that's supposed to be listening on port 8080) ... then be sure to turn it on, and make sure it's running!
I'm guessing that this "Oracle web admin interface" we've been talking about is probably the "XML DB Embedded Apache Server" that comes with Oracle XE. You can find more info about it here:

http://download.oracle.com/docs/cd/B...p.htm#CHDBEJDA

http://download.oracle.com/docs/cd/B...p.htm#BHAGICFJ

You might need to configure "marvel.conf" (same links as above).

But by all means, please try these commands, and see what happens:
Quote:
http://download.oracle.com/docs/cd/B.../post_inst.htm

ORACLE_HTTPSERVER_HOME/Apache/Apache/bin/apachectl stop
ORACLE_HTTPSERVER_HOME/Apache/Apache/bin/apachectl start
<= Substitute your actual path for "ORACLE_HTTPSERVER_HOME"
Verify that you actually have an "Apache/bin" directory with an "apachectl" script in it
'Hope that helps .. PSM

Last edited by paulsm4; 11-26-2009 at 02:32 PM.
 
Old 11-27-2009, 01:33 AM   #6
criathar
LQ Newbie
 
Registered: Nov 2009
Posts: 5

Original Poster
Rep: Reputation: 0
reply

Thanks for info but I still couldn't get it working. I disabled SELinux and firewall. Tried to add port 8080 to ports. I will try again tomorrow
 
Old 11-27-2009, 09:25 PM   #7
paulsm4
LQ Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
And please "cd" into your Oracle directory and try "./apachectl start" (this should be a *different* Apache than the one that comes with your Fedora Linux).
 
Old 10-23-2010, 09:19 PM   #8
mlichtenstein2
LQ Newbie
 
Registered: Oct 2010
Location: Orlando, FL
Distribution: Ubuntu 10.1
Posts: 9

Rep: Reputation: 0
Bringing up the Oracle listeners on Linux Ubuntu

Quote:
Originally Posted by criathar View Post
Been trying to connect to oracle-xe 10g on fedora12 linux for a week. I'm a real newb and just starting to learn linux and oracle. When I try to connect to home admin page the error I get is:
Unable to connect
Firefox can't establish a connection to the server at 127.0.0.1:8080


Tried this:
# telnet localhost 8080
Trying ::1...
telnet: connect to address ::1: Connection refused
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused


below I pasted some output to help diagnose problem. I noticed that this is an issue to a lot of people. But I have'nt seen a clear answer on how to fix the problem. I used the following commands from forums not my memory.


After I start database
# using service oracle-xe start
and use
# service oracle-xe status
I get this

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 26-NOV-2009 11:26:39

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

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 26-NOV-2009 09:09:54
Uptime 0 days 2 hr. 16 min. 45 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 "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


# netstat -tlnp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1166/sshd
tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN 927/cupsd
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 1337/sendmail: acce
tcp 0 0 0.0.0.0:36520 0.0.0.0:* LISTEN 1118/rpc.statd
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN 892/rpcbind
tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN 2057/tnslsnr
tcp 0 0 :::22 :::* LISTEN 1166/sshd
tcp 0 0 ::1:631 :::* LISTEN 927/cupsd
tcp 0 0 :::443 :::* LISTEN 1231/httpd
tcp 0 0 :::111 :::* LISTEN 892/rpcbind
tcp 0 0 :::80 :::* LISTEN 1231/httpd


# ps ax
PID TTY STAT TIME COMMAND


1817 ? S 0:00 /usr/libexec/notification-area-applet --oaf-activate-iid=OAF
1823 ? S 0:00 /usr/libexec/gvfsd-burn --spawner :1.7 /org/gtk/gvfs/exec_sp
1835 ? Ss 0:00 /sbin/mount.ntfs /dev/sdb1 /media/Local Disk -o rw,nosuid,no
1857 ? S 0:00 /bin/sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/
1858 ? S 0:00 /bin/sh /usr/lib64/firefox-3.5.5/run-mozilla.sh /usr/lib64/f
1874 ? Sl 2:18 /usr/lib64/firefox-3.5.5/firefox http://127.0.0.1:8080/apex
1947 ? Sl 0:04 gnome-terminal
1948 ? S 0:00 gnome-pty-helper
1949 pts/0 Ss 0:00 bash
1994 pts/0 S 0:00 su
2000 pts/0 S 0:00 bash
2057 ? Ss 0:00 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnsl
11179 ? S< 0:00 [scsi_eh_2]
11180 ? S< 0:00 [usb-storage]
11185 ? S< 0:00 /sbin/udevd -d
11187 ? S< 0:00 /sbin/udevd -d
11197 ? S 0:00 hald-addon-storage: polling /dev/sdc (every 2 sec)
11207 ? S 0:00 /usr/libexec/gvfsd-metadata
11337 pts/0 R+ 0:00 ps ax
[root@impulse impulse]# service oracle-xe status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 26-NOV-2009 11:26:39
-------------------------------------------------------------------
Instead of using sudo to start the listener, first use su - oracle, then start the listener.
su - oracle
password: oracle

export ORACLE_BASE=/usr/lib/oracle/xe/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/server
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME_LISTNER=$ORACLE_HOME
export ORACLE_SID=XE

lsnrctl start LISTENER

lsnrctl status

I was then able to bring up the Oracle home page a few minutes later with:
http://127.0.0.1:8080/apex
 
  


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
squirralmail admin page mail2mphani Linux - Newbie 1 03-09-2009 02:29 AM
cups problem - viewing admin page in IE esdeedee Linux - Networking 0 08-08-2006 02:05 AM
cannot connect to oracle 10g xe database admin page sparrott Linux - Networking 4 03-20-2006 02:46 PM
Can't access the Dlink router admin page. liquidrave Linux - Networking 15 01-17-2006 11:45 AM
CUPS - cannot access admin page Vincent_Vega Linux - Software 0 03-18-2004 01:20 AM


All times are GMT -5. The time now is 12:29 AM.

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