Home » Developer & Programmer » Application Express & MOD_PLSQL » can't connect to apex homepage
can't connect to apex homepage [message #589908] Thu, 11 July 2013 18:02 Go to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
hi there,

I tried posting this on Oracles official forum, but my post was ignored, which is frustrating. I'm hoping someone here is able to help.

I'm new to Oracle and find the learning curve steep. I'm more of a MySQL kind of guy. Anyway, I downloaded Oracle Database Express Edition

but I'm unable to connect to the home page via browser using http://localhost:8080/apex.

I need some help getting set up.

When I perform the following commands:



SQL> conn / as sysdba
SQL> select status from v$instance;



I get:



STATUS

______

OPEN



The results of running command lsnrctl status are:



LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 10-JUL-2013 12:37
:57

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
Start Date 10-JUL-2013 09:02:34
Uptime 0 days 3 hr. 35 min. 23 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora
Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\Alan-PC\listener\a
lert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Alan-PC)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Alan-PC)(PORT=8080))(Presentation=HT
TP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully



The results of running command netstat -a -o:



C:\Users\Alan>netstat -a -o

Active Connections

Proto Local Address Foreign Address State PID
TCP 0.0.0.0:135 Alan-PC:0 LISTENING 776
TCP 0.0.0.0:445 Alan-PC:0 LISTENING 4
TCP 0.0.0.0:554 Alan-PC:0 LISTENING 2660
TCP 0.0.0.0:1025 Alan-PC:0 LISTENING 436
TCP 0.0.0.0:1026 Alan-PC:0 LISTENING 832
TCP 0.0.0.0:1027 Alan-PC:0 LISTENING 992
TCP 0.0.0.0:1028 Alan-PC:0 LISTENING 504
TCP 0.0.0.0:1032 Alan-PC:0 LISTENING 1672
TCP 0.0.0.0:1033 Alan-PC:0 LISTENING 488
TCP 0.0.0.0:1521 Alan-PC:0 LISTENING 1732
TCP 0.0.0.0:2869 Alan-PC:0 LISTENING 4
TCP 0.0.0.0:3306 Alan-PC:0 LISTENING 3424
TCP 0.0.0.0:8080 Alan-PC:0 LISTENING 1732
TCP 0.0.0.0:10243 Alan-PC:0 LISTENING 4
TCP 127.0.0.1:1029 Alan-PC:0 LISTENING 1732
TCP 127.0.0.1:1032 Alan-PC:1243 ESTABLISHED 1672
TCP 127.0.0.1:1243 Alan-PC:1032 ESTABLISHED 2396
TCP 127.0.0.1:5939 Alan-PC:0 LISTENING 1836
TCP 192.168.2.13:139 Alan-PC:0 LISTENING 4
TCP 192.168.2.13:1900 a23-59-224-63:https CLOSE_WAIT 5736
TCP [::]:135 Alan-PC:0 LISTENING 776
TCP [::]:445 Alan-PC:0 LISTENING 4
TCP [::]:554 Alan-PC:0 LISTENING 2660
TCP [::]:1025 Alan-PC:0 LISTENING 436
TCP [::]:1026 Alan-PC:0 LISTENING 832
TCP [::]:1027 Alan-PC:0 LISTENING 992
TCP [::]:1028 Alan-PC:0 LISTENING 504
TCP [::]:1032 Alan-PC:0 LISTENING 1672
TCP [::]:1033 Alan-PC:0 LISTENING 488
TCP [::]:1521 Alan-PC:0 LISTENING 1732
TCP [::]:2869 Alan-PC:0 LISTENING 4
TCP [::]:3306 Alan-PC:0 LISTENING 3424
TCP [::]:8080 Alan-PC:0 LISTENING 1732
TCP [::]:10243 Alan-PC:0 LISTENING 4
TCP [fe80::8d6f:e8b2:9e8a:e855%10]:1031 Alan-PC:1521 ESTABLISHED
1672
TCP [fe80::8d6f:e8b2:9e8a:e855%10]:1090 Alan-PC:1091 ESTABLISHED
1672
TCP [fe80::8d6f:e8b2:9e8a:e855%10]:1091 Alan-PC:1090 ESTABLISHED
1732
TCP [fe80::8d6f:e8b2:9e8a:e855%10]:1092 Alan-PC:1093 ESTABLISHED
1672
TCP [fe80::8d6f:e8b2:9e8a:e855%10]:1093 Alan-PC:1092 ESTABLISHED
1732
TCP [fe80::8d6f:e8b2:9e8a:e855%10]:1521 Alan-PC:1031 ESTABLISHED
1732
TCP [fe80::8d6f:e8b2:9e8a:e855%10]:1919 Alan-PC:8080 FIN_WAIT_2
5928
TCP [fe80::8d6f:e8b2:9e8a:e855%10]:8080 Alan-PC:1919 CLOSE_WAIT
1732



I see a reference to port 8080 but I don't know if it is really listening on localhost = 127.0.0.1.

When I go into Windows Services it does say OracleServiceXE started and

OracleXETNSListener started.



I don't know where to go from here.



Please advise.



Alan
Re: can't connect to apex homepage [message #589916 is a reply to message #589908] Fri, 12 July 2013 00:17 Go to previous messageGo to next message
Littlefoot
Messages: 18848
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
I'm unable to connect to the home page via browser using http://localhost:8080/apex

What happens when you do so? What is the result?
Re: can't connect to apex homepage [message #589951 is a reply to message #589916] Fri, 12 July 2013 07:14 Go to previous messageGo to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
Well, nothing happens really. I open my browser, try to go the URL, and the tab just says, "Waiting for localhost...". Then I sit and wait forever for something to load.

Alan
Re: can't connect to apex homepage [message #589952 is a reply to message #589951] Fri, 12 July 2013 07:21 Go to previous messageGo to next message
Littlefoot
Messages: 18848
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What happens if you substitute "localhost" with its IP address, i.e. http://127.0.0.1:8080/apex? Or http://Alan-PC:8080/apex?

Do you have something else on the same port (such as Apache Tomcat)? If so, you'd need to change one of these (I know how to do both so I could assist, I hope).

No idea whether it has anything to do with it, but - could a firewall cause such problems? Try to (temporarily) turn it off and try again.
Re: can't connect to apex homepage [message #589954 is a reply to message #589952] Fri, 12 July 2013 08:01 Go to previous messageGo to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
The same thing happens. Actually, I do have Tomcat and I knew there would be a conflict on port 8080. So I went into the server.xml file for Tomcat and changed the port to just 80. I'm able to turn Tomcat on and off and currently am not even running it. So, as far as I know, there shouldn't be any interference with Oracle. But I have been wrong in the past. I am running Windows 7 and even thought of the firewall. I went into Windows Control Panel and tried to access the firewall to shut it down but it won't let me. Maybe you know of another way to shut it down, by editing a script somewhere? Maybe since I'm running the Home Premium edition of Windows it doesn't permit access? I don't know. I have Vipre Antivirus as well and temporarily shut it down to test. That had no affect either.

Alan

[Updated on: Fri, 12 July 2013 08:55]

Report message to a moderator

Re: can't connect to apex homepage [message #589962 is a reply to message #589954] Fri, 12 July 2013 10:57 Go to previous messageGo to next message
John Watson
Messages: 4102
Registered: January 2010
Location: Global Village
Senior Member
That Windows firewall could be the issue.

But apart from that, the database listener thinks that it is listening on whatever address the name Alan-PC resolves to. Can you try
http://Alan-PC:8080/apex

and also a simple test with telnet to see if anything is listening at all:
telnet Alan-PC 8080
Re: can't connect to apex homepage [message #589963 is a reply to message #589962] Fri, 12 July 2013 11:12 Go to previous messageGo to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
I tried the telnet command. This is what I got:

C:\Users\Alan>telnet Alan-PC 8080
'telnet' is not recognized as an internal or external command,
operable program or batch file.

Alan
Re: can't connect to apex homepage [message #589964 is a reply to message #589963] Fri, 12 July 2013 11:14 Go to previous messageGo to next message
John Watson
Messages: 4102
Registered: January 2010
Location: Global Village
Senior Member
http://www.orafaq.com/forum/mv/msg/188560/589931/148813/#msg_589931
Re: can't connect to apex homepage [message #589967 is a reply to message #589964] Fri, 12 July 2013 12:04 Go to previous messageGo to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
Is this supposed to funny. I'm not laughing. This is not the least bit constructive.
Re: can't connect to apex homepage [message #589968 is a reply to message #589967] Fri, 12 July 2013 12:19 Go to previous messageGo to next message
John Watson
Messages: 4102
Registered: January 2010
Location: Global Village
Senior Member
No joke.
Enabling the telnet client in Windows is a very straightforward procedure with which I would have thought most people are familiar. Why it is not done by default is a question for Microsoft. As is advice on how to enable it.
This is an Oracle forum, after all Smile
Re: can't connect to apex homepage [message #590002 is a reply to message #589968] Sat, 13 July 2013 05:19 Go to previous messageGo to next message
Littlefoot
Messages: 18848
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Your operating system is Windows 7 Home Premium. As far as I know, Oracle was never certified on any Home Windows edition so this *might* be a problem (although I don't believe so, but I could be wrong). I have never had any problems on MS Windows XP / 7 Professional.

As of firewall settings: Quote:
I tried to access the firewall to shut it down but it won't let me
What exactly did you not succeed to do? Access Windows Firewall at all, or is "Turn Windows Firewall on or off" inaccessible, or you can't choose the "off" radio button, or something different? Are you logged on as an administrator?
Re: can't connect to apex homepage [message #590012 is a reply to message #590002] Sat, 13 July 2013 11:44 Go to previous messageGo to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
I went into Control Panel/System and Security/Firewall. There is a link there to turn the firewall on or off. However, when I click on it, it doesn't really do anything. It sends me to Customize Settings interface which is red in color, that has no links on it whatsoever. There's a button labelled "Use recommended settings". When I click it, it brings up an error message "windows firewall can't change some of your settings". There's an OK and Cancel button, neither one of those does anything. Today, I'm going to attempt to load up Telnet. Never had to do that before, because I've never had to use it before. I'll let you know how that goes over.

Alan
Re: can't connect to apex homepage [message #590015 is a reply to message #590012] Sat, 13 July 2013 11:56 Go to previous messageGo to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
OK. I managed to install Telnet. When I run the command: C:\Users\Alan>telnet Alan-PC 8080 I do get a telnet session with a blinking cursor. I understand that it expects me type in a command, but I don't know any. I don't know anything about Telnet. The fact that I even got a session happening though should be encouraging, don't you think?

Where do I go from here?

Alan
Re: can't connect to apex homepage [message #590022 is a reply to message #590015] Sat, 13 July 2013 12:20 Go to previous messageGo to next message
Littlefoot
Messages: 18848
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Telnet commands (I don't know what John meant by suggesting that, sorry).

As you can connect to SQL*Plus, run the following (i.e. check APEX_PUBLIC_USER's status; if it is locked, unlock it and try the homepage again) while connected as SYS:
SQL> show user
USER is "SYS"
SQL>
SQL> select username, account_status
  2  from dba_users
  3  where username like '%APEX%';

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
APEX_040000                    LOCKED
APEX_PUBLIC_USER               LOCKED

SQL> alter user apex_public_user account unlock;

User altered.

Re: can't connect to apex homepage [message #590023 is a reply to message #590015] Sat, 13 July 2013 12:26 Go to previous messageGo to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
Something interesting today. I wasn't even able to connect using SQL Developer. I had set up an connection earier on port 1032, but today that port isn't even available. I ran the command netstat again and got a totally different set of ports. I've tried them all and I'm not able to connect via SQL Developer. Very frustrating...

C:\Users\Alan>netstat -a -o

Active Connections

Proto Local Address Foreign Address State PID
TCP 0.0.0.0:135 Alan-PC:0 LISTENING 800
TCP 0.0.0.0:445 Alan-PC:0 LISTENING 4
TCP 0.0.0.0:554 Alan-PC:0 LISTENING 3180
TCP 0.0.0.0:1025 Alan-PC:0 LISTENING 440
TCP 0.0.0.0:1026 Alan-PC:0 LISTENING 864
TCP 0.0.0.0:1027 Alan-PC:0 LISTENING 1008
TCP 0.0.0.0:1028 Alan-PC:0 LISTENING 508
TCP 0.0.0.0:1038 Alan-PC:0 LISTENING 1656
TCP 0.0.0.0:1039 Alan-PC:0 LISTENING 492
TCP 0.0.0.0:1521 Alan-PC:0 LISTENING 1704
TCP 0.0.0.0:2869 Alan-PC:0 LISTENING 4
TCP 0.0.0.0:8080 Alan-PC:0 LISTENING 1704
TCP 0.0.0.0:10243 Alan-PC:0 LISTENING 4
TCP 0.0.0.0:16190 Alan-PC:0 LISTENING 1576
TCP 127.0.0.1:1029 Alan-PC:0 LISTENING 1704
TCP 127.0.0.1:5939 Alan-PC:0 LISTENING 1796
TCP 127.0.0.1:36905 Alan-PC:0 LISTENING 1576
TCP 192.168.2.13:139 Alan-PC:0 LISTENING 4
TCP 192.168.2.13:1210 a23-59-224-63:https ESTABLISHED 3760
TCP 192.168.2.13:1220 a23-45-118-140:https ESTABLISHED 1264
TCP 192.168.2.13:1221 a23-45-118-140:https CLOSE_WAIT 1264
TCP [::]:135 Alan-PC:0 LISTENING 800
TCP [::]:445 Alan-PC:0 LISTENING 4
TCP [::]:554 Alan-PC:0 LISTENING 3180
TCP [::]:1025 Alan-PC:0 LISTENING 440
TCP [::]:1026 Alan-PC:0 LISTENING 864
TCP [::]:1027 Alan-PC:0 LISTENING 1008
TCP [::]:1028 Alan-PC:0 LISTENING 508
TCP [::]:1038 Alan-PC:0 LISTENING 1656
TCP [::]:1039 Alan-PC:0 LISTENING 492
TCP [::]:1521 Alan-PC:0 LISTENING 1704
TCP [::]:2869 Alan-PC:0 LISTENING 4
TCP [::]:8080 Alan-PC:0 LISTENING 1704
TCP [::]:10243 Alan-PC:0 LISTENING 4
TCP [::]:16190 Alan-PC:0 LISTENING 1576
TCP [fe80::8d6f:e8b2:9e8a:e855%10]:1037 Alan-PC:1521 ESTABLISHED
1656
TCP [fe80::8d6f:e8b2:9e8a:e855%10]:1171 Alan-PC:1172 ESTABLISHED
1656
TCP [fe80::8d6f:e8b2:9e8a:e855%10]:1172 Alan-PC:1171 ESTABLISHED
1704
TCP [fe80::8d6f:e8b2:9e8a:e855%10]:1521 Alan-PC:1037 ESTABLISHED
Re: can't connect to apex homepage [message #590025 is a reply to message #590023] Sat, 13 July 2013 12:31 Go to previous messageGo to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
Hi Littlefoot,

I ran the command you suggested inside SQL *Plus and this is what I got:

SQL*Plus: Release 11.2.0.2.0 Production on Sat Jul 13 14:28:04 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

SQL> show user
USER is ""

SQL> select username, account_status
2 from dba_users
3 where username like '%APEX%';
SP2-0640: Not connected

This is getting to be so frustrating, I'm thinking to reinstall Oracle on a different machine on the network and simply try to connect to it over the network.

[Updated on: Sat, 13 July 2013 12:37]

Report message to a moderator

Re: can't connect to apex homepage [message #590027 is a reply to message #590015] Sat, 13 July 2013 12:34 Go to previous messageGo to next message
John Watson
Messages: 4102
Registered: January 2010
Location: Global Village
Senior Member
Getting the telnet blinking cursor is good news: it means that there is something listening on that port (which you already knew from netstat) and furthermore that Windows is letting you connect to it, and therefore there is NO problem with your firewall.
Re: can't connect to apex homepage [message #590028 is a reply to message #590025] Sat, 13 July 2013 12:35 Go to previous messageGo to next message
Littlefoot
Messages: 18848
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Not connected? How come? This is what you should have done (starting from operating system's command prompt) (using your own password, of course):
C:\>sqlplus sys/pwd@xe as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sub Srp 13 19:33:52 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

SQL> select username, account_status
  2  from dba_users
  3  where username like '%APEX%';

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
APEX_040000                    LOCKED
APEX_PUBLIC_USER               OPEN

SQL>
Re: can't connect to apex homepage [message #590031 is a reply to message #590025] Sat, 13 July 2013 12:52 Go to previous messageGo to next message
Littlefoot
Messages: 18848
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
ashiers wrote on Sat, 13 July 2013 19:31

This is getting to be so frustrating, I'm thinking to reinstall Oracle on a different machine on the network and simply try to connect to it over the network.

I agree, that's frustrating. I installed different versions of XE database, all of them worked just fine, no problem, ever. XE installs in a few <Next> clicks and that's it, I don't know what might have gone wrong (unless it is really Windows Home edition).
Re: can't connect to apex homepage [message #590034 is a reply to message #590028] Sat, 13 July 2013 12:55 Go to previous messageGo to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
Guys,

I think this has gone on long enough. I tried bringing up SQL *Plus from the normal command prompt but I don't recall an appropriate password. All I'm getting is a blinking cursor, no SQL> prompt. I think I'll just uninstall Oracle altogether on this machine and try loading it up on a different machine on the network on Monday. I appreciate your assistance up to this point and if I have issues loading Oracle on the other machine, I'll let you know.

Alan
Re: can't connect to apex homepage [message #590040 is a reply to message #590034] Sat, 13 July 2013 13:07 Go to previous messageGo to next message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
Hey, I just found something that works. Check this out:

SQL*Plus: Release 11.2.0.2.0 Production on Sat Jul 13 14:57:50 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

SQL> conn / as sysdba
Connected.
SQL> select username, account_status
2 from dba_users
3 where username like '%APEX%
4 ';

no rows selected

SQL> select username, account_status
2 from dba_users
3 where username like '%APEX%';

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
APEX_040000 LOCKED
APEX_PUBLIC_USER LOCKED

SQL> alter user apex_public_user account unlock;

User altered.

SQL> select username, account_status
2 from dba_users
3 where username like '%APEX%';

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
APEX_040000 LOCKED
APEX_PUBLIC_USER OPEN

SQL>

What do you think? I went to my browser to try to connect to apex, but I'm still unable to connect.

Alan
Re: can't connect to apex homepage [message #590041 is a reply to message #590034] Sat, 13 July 2013 13:07 Go to previous messageGo to next message
John Watson
Messages: 4102
Registered: January 2010
Location: Global Village
Senior Member
I can't say I blame you for this decision. A word of warning, if you are new to this: de-installing Oracle products can be a bit of a mission. Probably best to use the installer to do it (you'll find a link to the Universal Installer on your Start menu) and then tidy up by removing the Oracle registry key in hkey_local_machine/software and the Oracle services in hkey_local_machine/system/current_control_set, and any references to Oracle in your system environment variables, and finally delete any Oracle related directories.

Good luck on your next install.

(ps - referring to "a blinking cursor" is quite funny to an Englishman. Is "blinking" ever used as an expletive in Nova Scotia?)
Re: can't connect to apex homepage [message #590043 is a reply to message #590040] Sat, 13 July 2013 13:10 Go to previous message
ashiers
Messages: 21
Registered: July 2013
Location: Bedford, Nova Scotia
Junior Member
No, it is not used as an expletive.
Previous Topic: How to hide Items values in browser URL.
Next Topic: I'm Back - brain picking time once again
Goto Forum:
  


Current Time: Fri Apr 25 02:04:45 CDT 2014

Total time taken to generate the page: 0.10053 seconds