LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   cannot connect to oracle admin page after install (https://www.linuxquestions.org/questions/linux-newbie-8/cannot-connect-to-oracle-admin-page-after-install-771763/)

criathar 11-26-2009 02:43 PM

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

Tinkster 11-26-2009 02:53 PM

Hi, welcome to LQ!

Is SELinux enabled?


Cheers,
Tink

criathar 11-26-2009 03:00 PM

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?

criathar 11-26-2009 03:06 PM

newb
 
I am so new to linux it hurts but am trying to learn. Actually I am liking it so far.

paulsm4 11-26-2009 03:20 PM

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

criathar 11-27-2009 02:33 AM

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

paulsm4 11-27-2009 10:25 PM

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).

mlichtenstein2 10-23-2010 10:19 PM

Bringing up the Oracle listeners on Linux Ubuntu
 
Quote:

Originally Posted by criathar (Post 3770570)
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


All times are GMT -5. The time now is 05:59 AM.