Home » RDBMS Server » Networking and Gateways » apex home page not response (oracle 11g ee)
apex home page not response [message #338209] Mon, 04 August 2008 03:44 Go to next message
futi
Messages: 22
Registered: November 2007
Junior Member

hi, i could not reach the remote host that includes apex.

when i typed it in browser :
http://10.200.1.22:8081/apex

i am getting "cannot find server" html page. Is there any listener problem, can i fix this via editing listener.ora and how? Or, the problem is another thing? I can connect this machine on telnet, and when i type :
"ftp localhost 2100",

i am getting this error:
fatih@oracle $ ftp localhost 2100
ftp: connect to address 127.0.0.1: Connection refused
Trying ::1...
ftp: connect: Network is unreachable
ftp>

I can reach that database via pl sql, sql plus but i can not reach the browser. What can i do? thanx

also i've alreday set the port as 8081 via typing dbms_xdb.sethttpport(8081);
but anything will happen when i enter this page.

is there any listener problem? That path can not response:

http://10.200.1.22:8081/apex/apex_login
Re: apex home page not response [message #338303 is a reply to message #338209] Mon, 04 August 2008 08:22 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Did you check this >>> ftp: connect: Network is unreachable<<<

Ping the remote server, it is ping successfully or not?

Re: apex home page not response [message #338349 is a reply to message #338303] Mon, 04 August 2008 12:34 Go to previous messageGo to next message
futi
Messages: 22
Registered: November 2007
Junior Member
yes i can ping remote databases using "ping" command in command line but i could not get any response when i trying the tnsping that host. I can connect that server via pl sql as i said earlier.

the server seems down. i cant solve this problem for weeks.
Re: apex home page not response [message #338423 is a reply to message #338349] Tue, 05 August 2008 00:26 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

show the output of tnsping command.
Re: apex home page not response [message #338615 is a reply to message #338349] Tue, 05 August 2008 08:01 Go to previous messageGo to next message
futi
Messages: 22
Registered: November 2007
Junior Member
C:\Documents and Settings\stasungur>tnsping 10.2xx.1xx.65

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-AUG-2
008 16:00:53

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

Used parameter files:
D:\oracle\product\10.2.0\db_2\network\admin\sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=10.2xx.1xx.65))(A
DDRESS=(PROTOCOL=TCP)(HOST=10.2xx.1xx.65)(PORT=1521)))
TNS-12541: TNS:no listener

C:\Documents and Settings\stasungur>
Re: apex home page not response [message #338627 is a reply to message #338615] Tue, 05 August 2008 08:57 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Did you check ?
TNS-12541: TNS:no listener


Listener is started?
if started then TNS_ADMIN variable is properly set.

Re: apex home page not response [message #338705 is a reply to message #338627] Tue, 05 August 2008 13:53 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello,

In feature please don't post tcp/ip information.

Thanks & Regards

Babu

[Updated on: Tue, 05 August 2008 13:59]

Report message to a moderator

Re: apex home page not response [message #338811 is a reply to message #338627] Wed, 06 August 2008 00:36 Go to previous messageGo to next message
futi
Messages: 22
Registered: November 2007
Junior Member
how can i check this info?
Re: apex home page not response [message #339341 is a reply to message #338811] Thu, 07 August 2008 05:35 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Go to the machine where Oracle SErver is installed.

open command prompt and type below command.

CMD> lsnrctl status

post the output here.
Re: apex home page not response [message #339438 is a reply to message #339341] Thu, 07 August 2008 09:04 Go to previous messageGo to next message
futi
Messages: 22
Registered: November 2007
Junior Member
fatih@oracle $ lsnrctl status

LSNRCTL for Solaris: Version 11.1.0.6.0 - Production on 07-AUG-2008 16:57:22

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fatih)(PORT=1529)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 11.1.0.6.0 - Production
Start Date 01-AUG-2008 11:24:54
Uptime 6 days 5 hr. 32 min. 27 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /dwh0/app/oracle/product/11.1.0.1/network/admin/listen
er.ora
Listener Log File /dwh0/app/oracle/product/diag/tnslsnr/fatih/listener/a
lert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fatih)(PORT=1529)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "owb11" has 1 instance(s).
Instance "owb11", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
fatih@oracle $
Re: apex home page not response [message #339509 is a reply to message #338209] Thu, 07 August 2008 12:21 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Forgive me for jumping in here, since I really don't do APEX.

I do not think Oracle listener is involved with establishing client connections into the APEX DB.

Since the client uses a browser to access the DB, I think some sort of webserver, like Apache, is needed.

What gets returned by the following command?
netstat -na | grep LISTEN

>http://10.200.1.22:8081/apex
If the above is going to succeed, something needs to be listening on port 8081.

Some sort of deamon/service needs to be started to accept new requests on port 8081, IMO.

ORACLE_HTTPSERVER_HOME/Apache/Apache/bin/apachectl start

HTH & YMMV!

[Updated on: Thu, 07 August 2008 12:53] by Moderator

Report message to a moderator

Re: apex home page not response [message #339632 is a reply to message #339509] Fri, 08 August 2008 00:42 Go to previous messageGo to next message
futi
Messages: 22
Registered: November 2007
Junior Member
ORACLE_HTTPSERVER_HOME/Apache/Apache/bin/apachectl start

this path is not found on remote machine i've controlled it. There is no apache folder anywhere in $ORACLE_HOME.

anacedent said that "
Some sort of deamon/service needs to be started to accept new requests on port 8081, IMO." probably this issue is true. i have to do something like it. What can i do?
Re: apex home page not response [message #339633 is a reply to message #338209] Fri, 08 August 2008 00:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>What can i do?
Use ACCESS it is less user hostile.
Re: apex home page not response [message #339709 is a reply to message #339633] Fri, 08 August 2008 03:14 Go to previous message
futi
Messages: 22
Registered: November 2007
Junior Member
> Use ACCESS it is less user hostile.

? I don't undestand?
Previous Topic: running 9i and 10g on same server
Next Topic: Interface between Oracle and SQL Server databases
Goto Forum:
  


Current Time: Thu Mar 28 05:31:25 CDT 2024