ORACLE Failed to Connect http://127.0.0.1:8080/apex

26 Juni 2009 oleh mfirmanshah

oracle login

After a few days ago I finished installing the Oracle 10g xe on Ubuntu 9:04 the problem appears, I get stuck. It is visible in the browser like this below.

oracle failed

The following process flow is passed.

First, let’s install Oracle package with the command:

sudo dpkg -i oracle-xe-universal_10.2.0.1-1.0_i386.deb

[sudo] password for mfirmanshah:

Selecting previously deselected package oracle-xe-universal.
(Reading database … 125554 files and directories currently installed.)
Unpacking oracle-xe-universal (from oracle-xe-universal_10.2.0.1-1.0_i386.deb) …
Setting up oracle-xe-universal (10.2.0.1-1.0) …
update-rc.d: warning: /etc/init.d/oracle-xe missing LSB information
update-rc.d: see <http://wiki.debian.org/LSBInitScripts>
Executing Post-install steps…

You must run ‘/etc/init.d/oracle-xe configure’ as the root user to configure the database.

Processing triggers for man-db …

Follow the Oracle Configuration with the command:

sudo /etc/init.d/oracle-xe configure

Oracle Database 10g Express Edition Configuration
————————————————-
This will configure on-boot properties of Oracle Database 10g Express Edition. The following questions will determine whether the database should be starting upon system boot, the ports it will use, and the passwords that will be used for database accounts. Press <Enter> to accept the defaults. Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts. Note that the same password will be used for SYS and SYSTEM. Oracle recommends the use of different passwords for each database account. This can be done after initial configuration:
Confirm the password:

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:

After typing [Y] show progress :

Starting Oracle Net Listener…Done
Configuring Database…Done
Starting Oracle Database 10g Express Edition Instance…Done
Installation Completed Successfully.
To access the Database Home Page go to “http://127.0.0.1:8080/apex”

Continue to review the status of its engine, is already running or not :

sudo /etc/init.d/oracle-xe status

LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 20-JUN-2009 23:49:59

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                20-JUN-2009 23:47:06
Uptime                    0 days 0 hr. 2 min. 52 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=mfirmanshahlaptop.riska)(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

Command to view the details of the listener.ora :

sudo nano /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora

# listener.ora Network Configuration File:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST=localhost)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

But it appears in the Browser:

Failed to Connect http://127.0.0.1:8080/apex

oracle failed

SOLUTIONS is:

corrected hostname = localhost host to the first listed host = mfirmanshahlaptop.riska

Completion, let us try to Reload the Oracle :

sudo /etc/init.d/oracle-xe reload

Shutting down Oracle Database 10g Express Edition Instance.
Stopping Oracle Net Listener.

Starting Oracle Net Listener.
Starting Oracle Database 10g Express Edition Instance.

Now we are commanded to know the host name that we registered with the computer:

sudo nano /etc/hosts

127.0.0.1 localhost mfirmanshahlaptop.riska mfirmanshahlaptop
192.168.1.37 mfirmanshahlaptop.riska = mfirmanshahlaptop

# The following lines are desirable for IPv6 capable hosts
::1 localhost ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts

Setelah tempo hari saya selesai menginstall Oracle 10g XE di Ubuntu 9.04 muncul problem yang membuat saya buntu.

faizah@mfirmanshahlaptop:/media/LAN/riska1/Data RISKA/MASTER/RDBMS/Oracle/xe linux_deb$ sudo dpkg -i oracle-xe-universal_10.2.0.1-1.0_i386.deb

[sudo] password for faizah:
Selecting previously deselected package oracle-xe-universal.
(Reading database … 125554 files and directories currently installed.)
Unpacking oracle-xe-universal (from oracle-xe-universal_10.2.0.1-1.0_i386.deb) …
Setting up oracle-xe-universal (10.2.0.1-1.0) …
update-rc.d: warning: /etc/init.d/oracle-xe missing LSB information
update-rc.d: see <http://wiki.debian.org/LSBInitScripts>
Executing Post-install steps…

You must run ‘/etc/init.d/oracle-xe configure’ as the root user to configure the database.

Processing triggers for man-db …

faizah@mfirmanshahlaptop:/media/LAN/riska1/Data RISKA/MASTER/RDBMS/Oracle/xe linux_deb$ sudo /etc/init.d/oracle-xe configure

Oracle Database 10g Express Edition Configuration
————————————————-
This will configure on-boot properties of Oracle Database 10g Express
Edition. The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts. Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:
Confirm the password:

Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:

faizah@mfirmanshahlaptop:/media/LAN/riska1/Data RISKA/MASTER/RDBMS/Oracle/xe linux_deb$ sudo /etc/init.d/oracle-xe status

LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 20-JUN-2009 23:49:59

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                20-JUN-2009 23:47:06
Uptime                    0 days 0 hr. 2 min. 52 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=mfirmanshahlaptop.riska)(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

faizah@mfirmanshahlaptop:/media/LAN/riska1/Data RISKA/MASTER/RDBMS/Oracle/xe linux_deb$ sudo nano /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora

# listener.ora Network Configuration File:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST=localhost)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

# note : host sudah dikoreksi ke host=localhost

faizah@mfirmanshahlaptop:/media/LAN/riska1/Data RISKA/MASTER/RDBMS/Oracle/xe linux_deb$ sudo /etc/init.d/oracle-xe reload

Shutting down Oracle Database 10g Express Edition Instance.
Stopping Oracle Net Listener.

Starting Oracle Net Listener.
Starting Oracle Database 10g Express Edition Instance.

note : tail -f adalah perintah beberapa baris terakhir secara update

faizah@mfirmanshahlaptop:/media/LAN/riska1/Data RISKA/MASTER/RDBMS/Oracle/xe linux_deb$ cd

faizah@mfirmanshahlaptop:~$ tail -f /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0

Started with pid=7353
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
20-JUN-2009 23:55:46 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=mfirmanshahlaptop)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Listener completed notification to CRS on stop
20-JUN-2009 23:58:22 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=mfirmanshahlaptop)(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * stop * 0

TNSLSNR for Linux: Version 10.2.0.1.0 – Production on 20-JUN-2009 23:58:22

System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0

Started with pid=8311
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
20-JUN-2009 23:58:25 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=mfirmanshahlaptop)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
20-JUN-2009 23:59:01 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=mfirmanshahlaptop)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
20-JUN-2009 23:59:05 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=mfirmanshahlaptop)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Listener completed notification to CRS on stop
21-JUN-2009 00:21:46 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=mfirmanshahlaptop)(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * stop * 0

TNSLSNR for Linux: Version 10.2.0.1.0 – Production on 21-JUN-2009 00:21:47

Started with pid=11433
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
21-JUN-2009 00:21:50 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=mfirmanshahlaptop)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0

faizah@mfirmanshahlaptop:/media/LAN/riska1/Data RISKA/MASTER/RDBMS/Oracle/xe linux_deb$ sudo /etc/init.d/oracle-xe reload

Shutting down Oracle Database 10g Express Edition Instance.
Stopping Oracle Net Listener.

Starting Oracle Net Listener.
Starting Oracle Database 10g Express Edition Instance.

faizah@mfirmanshahlaptop:/media/LAN/riska1/Data RISKA/MASTER/RDBMS/Oracle/xe linux_deb$ tail -f /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log

Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace/listener.trc
Trace level is currently 0

faizah@mfirmanshahlaptop:~$ sudo nano /etc/hosts

127.0.0.1         localhost
127.0.0.1       mfirmanshahlaptop.riska mfirmanshahlaptop
192.168.1.37       mfirmanshahlaptop.riska = mfirmanshahlaptop

========lalu hasil dibaris 1 & 2 digabungkan untuk menghemat========

127.0.0.1 localhost mfirmanshahlaptop.riska mfirmanshahlaptop
192.168.1.37 mfirmanshahlaptop.riska = mfirmanshahlaptop

Ditulis dalam IT | Bertanda apex, blog, blogger, failed, linux, oracle, tips trik, ubuntu | & Komentar

2 Tanggapan

di/pada 23 September 2009 pada 20:27 azzasy

Hi..
If you have a problem in accessing localhost, you have to go to sqlplus to execute dbms_xdb.setHttpport(8080);
try with this:

~$ sqlplus / as sysdba

By enterim your account and password system
execute the following commands:

~$ dbms_xdb.setHttpport(8080);

~$ commit;

~$ quit;

You then reload the oracle

~$ sudo /etc/init.d/oracle-xe force-reload

Hope, it works!
di/pada 23 September 2009 pada 20:30 azzasy

Hi Guys..

But for me after doing such commands, Failed to connect will not appear anymore. But, The page appears a blank page.
Do one of you know how to fix it?

thanks