| Error message when loading oracle via web browser [message #318960] |
Thu, 08 May 2008 09:27  |
MrNotebook
Messages: 13
Registered: May 2008
Location: Silver Spring, MD
|
Junior Member |
|
|
I sure hope someone can help me to run this new oracle I got.
I have Oracle 10.2G running in Centos (Linux) platform. I am told to insert http://127.0.0.1:8080/apex in my firefix browser (to get the main database console), however I recieve the error message...
Firefox can't establish a connection to the server at 127.0.0.1:8080
I looked around and can't seem to nail down the solution, and then I stumbled upon this forum.
Help me out please.
[Updated on: Thu, 08 May 2008 09:27] Report message to a moderator |
|
|
|
|
|
| Re: Error message when loading oracle via web browser [message #318969 is a reply to message #318964] |
Thu, 08 May 2008 09:53  |
MrNotebook
Messages: 13
Registered: May 2008
Location: Silver Spring, MD
|
Junior Member |
|
|
| ebrian wrote on Thu, 08 May 2008 10:40 | Are you accessing locally or remotely?
Are the services started:
/etc/init.d/oracle-xe start
|
I'm accessing it locally from within the linux desktop. I recieved the following messages...
[root@localhost httpd]# /etc/init.d/oracle-xe status
-bash: /etc/init.d/oracle-xe: No such file or directory
[root@localhost httpd]# /etc/init.d/oracle-xe start
-bash: /etc/init.d/oracle-xe: No such file or directory
[root@localhost httpd]# find / -name oracle-xe
[root@localhost httpd]#
It appears that I don't even have an oracle-xe file based on the find results.
|
|
|
|
|
|
| Re: Error message when loading oracle via web browser [message #318976 is a reply to message #318974] |
Thu, 08 May 2008 10:12 |
MrNotebook
Messages: 13
Registered: May 2008
Location: Silver Spring, MD
|
Junior Member |
|
|
| anacedent wrote on Thu, 08 May 2008 11:08 | using CUT & PASTE post the results back here from
netstat -nl
|
[root@localhost httpd]# netstat -nl
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN
tcp 0 0 :::22 :::* LISTEN
udp 0 0 0.0.0.0:1024 0.0.0.0:*
udp 0 0 0.0.0.0:68 0.0.0.0:*
udp 0 0 0.0.0.0:5353 0.0.0.0:*
udp 0 0 0.0.0.0:111 0.0.0.0:*
udp 0 0 :::1025 :::*
udp 0 0 :::5353 :::*
Active UNIX domain sockets (only servers)
Proto RefCnt Flags Type State I-Node Path
unix 2 [ ACC ] STREAM LISTENING 7946 @/tmp/fam-root-
unix 2 [ ACC ] STREAM LISTENING 5972 @/var/run/hald/dbus-0AH1opdlnJ
unix 2 [ ACC ] STREAM LISTENING 5138 /var/run/audit_events
unix 2 [ ACC ] STREAM LISTENING 5467 /var/run/dbus/system_bus_socket
unix 2 [ ACC ] STREAM LISTENING 5779 /dev/gpmctl
unix 2 [ ACC ] STREAM LISTENING 5855 /tmp/.font-unix/fs7100
unix 2 [ ACC ] STREAM LISTENING 5973 @/var/run/hald/dbus-7dmQDbu181
unix 2 [ ACC ] STREAM LISTENING 7322 /tmp/.gdm_socket
unix 2 [ ACC ] STREAM LISTENING 7526 /tmp/.X11-unix/X0
unix 2 [ ACC ] STREAM LISTENING 7882 /tmp/ssh-PkcYPv2459/agent.2459
unix 2 [ ACC ] STREAM LISTENING 7895 /tmp/.ICE-unix/2514
unix 2 [ ACC ] STREAM LISTENING 5554 /var/run/pcscd.comm
unix 2 [ ACC ] STREAM LISTENING 8159 /tmp/orbit-root/linc-9ea-0-3a27f9f4ba391
unix 2 [ ACC ] STREAM LISTENING 9943 /tmp/orbit-root/linc-c03-0-507a99549777a
unix 2 [ ACC ] STREAM LISTENING 8613 /tmp/orbit-root/linc-a05-0-5ebaa39f71b76
unix 2 [ ACC ] STREAM LISTENING 5889 /var/run/avahi-daemon/socket
[root@localhost httpd]#
|
|
|
|
|
|
| Re: Error message when loading oracle via web browser [message #318982 is a reply to message #318978] |
Thu, 08 May 2008 10:36 |
MrNotebook
Messages: 13
Registered: May 2008
Location: Silver Spring, MD
|
Junior Member |
|
|
| anacedent wrote on Thu, 08 May 2008 11:22 |
the absence of 8080 in the output above, means nothing is listening on port #8080 on this system
|
Ok...I started apache...
[root@localhost init.d]# /usr/sbin/httpd
[root@localhost init.d]# ps auxw | grep httpd
root 3844 0.5 1.2 20816 6224 ? Ss 15:13 0:00 /usr/sbin/httpd
apache 3845 0.0 0.6 20816 3156 ? S 15:13 0:00 /usr/sbin/httpd
apache 3846 0.0 0.6 20816 3156 ? S 15:13 0:00 /usr/sbin/httpd
apache 3847 0.0 0.6 20816 3156 ? S 15:13 0:00 /usr/sbin/httpd
apache 3848 0.0 0.6 20816 3156 ? S 15:13 0:00 /usr/sbin/httpd
apache 3849 0.0 0.6 20816 3156 ? S 15:13 0:00 /usr/sbin/httpd
apache 3850 0.0 0.6 20816 3156 ? S 15:13 0:00 /usr/sbin/httpd
apache 3851 0.0 0.6 20816 3156 ? S 15:13 0:00 /usr/sbin/httpd
apache 3852 0.0 0.6 20816 3156 ? S 15:13 0:00 /usr/sbin/httpd
root 3860 0.0 0.1 4008 748 pts/1 R+ 15:13 0:00 grep httpd
...however, I do not see netstat reporting port "8080"...
[root@localhost init.d]# netstat -nl
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN
tcp 0 0 :::80 :::* LISTEN
tcp 0 0 :::22 :::* LISTEN
tcp 0 0 :::443 :::* LISTEN
udp 0 0 0.0.0.0:1024 0.0.0.0:*
udp 0 0 0.0.0.0:68 0.0.0.0:*
udp 0 0 0.0.0.0:5353 0.0.0.0:*
udp 0 0 0.0.0.0:111 0.0.0.0:*
udp 0 0 :::1025 :::*
udp 0 0 :::5353 :::*
Active UNIX domain sockets (only servers)
Proto RefCnt Flags Type State I-Node Path
unix 2 [ ACC ] STREAM LISTENING 7946 @/tmp/fam-root-
unix 2 [ ACC ] STREAM LISTENING 5972 @/var/run/hald/dbus-0AH1opdlnJ
unix 2 [ ACC ] STREAM LISTENING 5138 /var/run/audit_events
unix 2 [ ACC ] STREAM LISTENING 5467 /var/run/dbus/system_bus_socket
unix 2 [ ACC ] STREAM LISTENING 5779 /dev/gpmctl
unix 2 [ ACC ] STREAM LISTENING 5855 /tmp/.font-unix/fs7100
unix 2 [ ACC ] STREAM LISTENING 5973 @/var/run/hald/dbus-7dmQDbu181
unix 2 [ ACC ] STREAM LISTENING 7322 /tmp/.gdm_socket
unix 2 [ ACC ] STREAM LISTENING 7526 /tmp/.X11-unix/X0
unix 2 [ ACC ] STREAM LISTENING 7882 /tmp/ssh-PkcYPv2459/agent.2459
unix 2 [ ACC ] STREAM LISTENING 7895 /tmp/.ICE-unix/2514
unix 2 [ ACC ] STREAM LISTENING 5554 /var/run/pcscd.comm
unix 2 [ ACC ] STREAM LISTENING 8159 /tmp/orbit-root/linc-9ea-0-3a27f9f4ba391
unix 2 [ ACC ] STREAM LISTENING 9943 /tmp/orbit-root/linc-c03-0-507a99549777a
unix 2 [ ACC ] STREAM LISTENING 8613 /tmp/orbit-root/linc-a05-0-5ebaa39f71b76
unix 2 [ ACC ] STREAM LISTENING 5889 /var/run/avahi-daemon/socket
[root@localhost init.d]#
Is there something I did wrong with regards to starting apache? I even tried http://127.0.0.1:80/apex and got...
Not Found
The requested URL /apex was not found on this server.
|
|
|
|
|
|
| Re: Error message when loading oracle via web browser [message #318985 is a reply to message #318984] |
Thu, 08 May 2008 10:52 |
MrNotebook
Messages: 13
Registered: May 2008
Location: Silver Spring, MD
|
Junior Member |
|
|
No. I downloaded a CentOS vmware with oracle already installed. All I had to do is boot up within my existing vmware console.
This is my filesystem...
[root@localhost init.d]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 5.3G 3.9G 1.2G 77% /
/dev/sdb1 3.0G 1.4G 1.5G 49% /u02
tmpfs 252M 0 252M 0% /dev/shm
I suppose oracle is taking up u02, right?
When I "su - oracle" I get...
[root@localhost conf]# su - oracle
Choose your Oracle Home
1) Server 10.2 EE: /u01/app/oracle/product/10.2/db_1
To start/stop database, listener, new EM console
2) Client 10.2: /u01/app/oracle/product/10.2/client
To run Java EM and other tools
...to which I select #1...
1
Your current environment:
ORACLE_BASE = /u01/app/oracle
ORACLE_HOME = /u01/app/oracle/product/10.2/db_1
ORACLE_SID = DB1
You can change your environment running:
. /home/oracle/.bash_profile
[oracle@localhost ~]$
...then, I do....
[oracle@localhost ~]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 08-MAY-2008 15:35:10
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Starting /u01/app/oracle/product/10.2/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.3.0 - Production
System parameter file is /u01/app/oracle/product/10.2/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.3.0 - Production
Start Date 08-MAY-2008 15:35:12
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@localhost ~]$
...and lastly, I...
[oracle@localhost ~]$ dbstart
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/product/10.2/db_1/bin/dbstart ORACLE_HOME
[oracle@localhost ~]$
...I'm just not sure what is going on here...it looks like it's doing something, however when I do the browser thing I gets nuthin'.
|
|
|
|
|
|
|
|
|
|
| Re: Error message when loading oracle via web browser [message #318991 is a reply to message #318985] |
Thu, 08 May 2008 11:19 |
 |
ebrian
Messages: 2794
Registered: April 2006
|
Senior Member |
|
|
| MrNotebook wrote on Thu, 08 May 2008 11:52 |
1) Server 10.2 EE: /u01/app/oracle/product/10.2/db_1
|
Now that I see the output menu again, this definitely doesn't appear to be XE, so that URL won't do you any good.
As a quick run down, once you select option 1 you could try to issue the following:
If you don't see any oracle processes running, then issue the following:
$ sqlplus / as sysdba
SQL> startup
SQL> exit
$ emctl start dbconsole
At this point, the emctl will output a URL that you can access OEM.
[Updated on: Thu, 08 May 2008 11:21] Report message to a moderator |
|
|
|
| Re: Error message when loading oracle via web browser [message #318993 is a reply to message #318991] |
Thu, 08 May 2008 11:35 |
MrNotebook
Messages: 13
Registered: May 2008
Location: Silver Spring, MD
|
Junior Member |
|
|
| ebrian wrote on Thu, 08 May 2008 12:19 | | MrNotebook wrote on Thu, 08 May 2008 11:52 |
1) Server 10.2 EE: /u01/app/oracle/product/10.2/db_1
|
Now that I see the output menu again, this definitely doesn't appear to be XE, so that URL won't do you any good.
As a quick run down, once you select option 1 you could try to issue the following:
If you don't see any oracle processes running, then issue the following:
$ sqlplus / as sysdba
SQL> startup
SQL> exit
$ emctl start dbconsole
At this point, the emctl will output a URL that you can access OEM.
|
YEA...it so worked!! Here is the output...
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Thu May 8 16:07:53 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 314572800 bytes
Fixed Size 1261540 bytes
Variable Size 113246236 bytes
Database Buffers 197132288 bytes
Redo Buffers 2932736 bytes
Database mounted.
Database opened.
[oracle@localhost ~]$ emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0
Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
http://localhost:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control .........................................................................
.................... failed.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2/db_1/localhost_DB1/sysman/log
...although the last line shows a failure, I am still able to access the DB via the web console which so far seems to be running just fine!
What is the Oracle Enterprise Manager 10g Database Control anyways? Am I to be concerned about that?
|
|
|
|
|
|
| Re: Error message when loading oracle via web browser [message #318996 is a reply to message #318994] |
Thu, 08 May 2008 11:50 |
MrNotebook
Messages: 13
Registered: May 2008
Location: Silver Spring, MD
|
Junior Member |
|
|
| ebrian wrote on Thu, 08 May 2008 12:39 | Database console is what allows you to administer and manage your Oracle components on that node. I have no idea how that image was created or configured, but it looks like you may need to review the log /u01/app/oracle/product/10.2/db_1/localhost_DB1/sysman/log for errors.
Now the fun starts. Time to start reading Oracle Docs.
|
Thank you SO much man!! You're right, the fun starts now.
|
|
|
|
| Re: Error message when loading oracle via web browser [message #319032 is a reply to message #318994] |
Thu, 08 May 2008 15:01 |
MrNotebook
Messages: 13
Registered: May 2008
Location: Silver Spring, MD
|
Junior Member |
|
|
| ebrian wrote on Thu, 08 May 2008 12:39 | Database console is what allows you to administer and manage your Oracle components on that node. I have no idea how that image was created or configured, but it looks like you may need to review the log /u01/app/oracle/product/10.2/db_1/localhost_DB1/sysman/log for errors.
Now the fun starts. Time to start reading Oracle Docs.
|
I have just a few more questions. What are the shutdown steps? When I init 0 my linux machine I tried doing the same steps and in the browser all the database arrows are red, pointing down. When I click the "startup" button and try to log in, it fails to let me in. What's going on, everything was working well before?
|
|
|
|
|
|
| Re: Error message when loading oracle via web browser [message #319062 is a reply to message #319037] |
Thu, 08 May 2008 19:32 |
MrNotebook
Messages: 13
Registered: May 2008
Location: Silver Spring, MD
|
Junior Member |
|
|
| ebrian wrote on Thu, 08 May 2008 16:20 | Check Automating Shutdown and Startup and you'll also need to include emctl start dbconsole in addition to what is addressed in the link.
| MrNotebook wrote on Thu, 08 May 2008 16:01 |
When I click the "startup" button and try to log in, it fails to let me in. What's going on, everything was working well before?
|
What error are you getting?
Can you connect to the database via SQL*Plus? What is the output of emctl status dbconsole.
|
This is what I'm getting now when I try to run the database...
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Fri May 9 00:09:08 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 314572800 bytes
Fixed Size 1261540 bytes
Variable Size 113246236 bytes
Database Buffers 197132288 bytes
Redo Buffers 2932736 bytes
Database mounted.
Database opened.
SQL> exit
[oracle@localhost ~]$ emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0
Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
http://localhost:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is not running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2/db_1/localhost_DB1/sysman/log
...and the browser is not loading the console. I've also config'd the automatic startup procedures according to the link. I'm hoping I'm not breaking it the more I mess with it.
[Updated on: Thu, 08 May 2008 19:34] Report message to a moderator |
|
|
|
|
|
| Re: Error message when loading oracle via web browser [message #319067 is a reply to message #319066] |
Thu, 08 May 2008 21:17 |
MrNotebook
Messages: 13
Registered: May 2008
Location: Silver Spring, MD
|
Junior Member |
|
|
| ebrian wrote on Thu, 08 May 2008 21:54 | You need to start the console with:
The important thing to remember about utilizing the emctl command is to ensure that the ORACLE_HOME, ORACLE_SID & PATH environment variables are set appropriately.
|
ok the web interface started again...however, this is what it looks like (view the attached screenshot).
|
|
|
|
|
|
|
|
|
|
|
|
| Host Credentials [message #412635 is a reply to message #319285] |
Fri, 10 July 2009 04:16 |
SameerChoudhari
Messages: 9
Registered: July 2009
Location: Bangalore
|
Junior Member |
|
|
I am getting
Validation Error
Please correct the following error:
osUserPassword - This field must be specified
osUserName - This field must be specified
when I enter HOST Credentials. Could you please solve my problem.
My Laptop Details :
Windows Vista Home Premium -32 Bit
Oracle 10g For Vista
[Updated on: Fri, 10 July 2009 04:18] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
