This discussion is archived
4 Replies Latest reply: Oct 2, 2012 12:30 PM by WIP RSS

Apex Listsner issue

WIP Newbie
Currently Being Moderated
hi All,

I am trying to install Apex and have the following on my laptop

1) Oracle DB 11gR2 on win 7-->this is working fine
2) Oracle middleware fusion 11g (WebLogic Server Version: 10.3.6.0)--->this is working fine ,I am able to login to console.

As I am using the Oracle Apex Listener installation ,

I have installed the apex and done as per the below link

http://docs.oracle.com/cd/E21611_01/doc.11/e21058/install.htm

but Stuck at the chapter 2)Configuring Oracle Application Express Listener

THE ISSUE is

Access Oracle Application Express Listener Administration
To access Oracle Application Express Listener Administration initially, enter the following URL in your Web browser:
http://<host>:<port>/apex/listenerConfigure

when I try to login as Admin in the above ,I get invalid username password ? ora 1017.

What is the password for this ?

Please suggest dear experts.

Regards
S
  • 1. Re: Apex Listsner issue
    Udo Guru
    Currently Being Moderated
    Hi "S",

    which APEX Listener version using which Java version for your WLS do you try to get working?

    Usually, you'll need the credentials you've entered in the step [url http://docs.oracle.com/cd/E21611_01/doc.11/e21058/install.htm#CHDCGGDG]Create Users and Roles to access APEX Listener's administration, but though the documentation uses this synonymously, the initial configuration is actually a little different and doesn't call for authentication.

    On the other hand, you say you get an ORA-01017, so I assume you are actually able to access the initial configuration and you are trying to enter the database credentials there. This fails, because you use the wrong database user.
    Hopefully, you've followed the APEX installation guide for APEX Listener as well. If so, one of your steps has been [url http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21673/otn_install.htm#BABDEEIHConfigure APEX_PUBLIC_USER Account[/url]. This would be the recommended database user to make your APEX Listener connect to your APEX instance. "Admin" is usually the user to access the APEX internal administration, which is different from APEX Listener's administration (and is also available if you access APEX through a different web server).

    -Udo
  • 2. Re: Apex Listsner issue
    WIP Newbie
    Currently Being Moderated
    Thanks Udo

    As us suggest i used the above user (APEX_PUBLIC_USER) now .
    I am able to connect to database with above user via toad/sqlplus/sql developer

    Now the error is different as below .

    Request could not be processed due to error:
    IO Error: The Network Adapter could not establish the connection

    Also I have already created the above users and roles as suggested in the link

    My JDK is jdk1.7.0_07

    Regards
    S

    Edited by: WIP on Oct 1, 2012 10:34 PM
  • 3. Re: Apex Listsner issue
    685473 Newbie
    Currently Being Moderated
    Hi "S",

    For the APEX listener 1.1 you need to create in Weblogic an administrator user for the configuration of the APEX listener.
    For example "adminlistener" with the role "Admin".
    Look for more details in the documentation of the listener.

    When you start http://<host>:<port>/apex/listenerConfigure (new configuration) or http://<host>:<port>/apex/listenerAdmin (existing configuration) you need to login with this administrator user. Thus "adminlistener".

    When the configuration page of the listener appears you need to define the connection to the database for APEX.
    This is done with the APEX_PUBLIC_USER account.
    Furthermore you need to define the hostname, port, sid or servicename of the database.
    After saving you can start APEX in the browser.

    In APEX for the Internal workspace you have to login as "Admin" with the password you defined during the installation of APEX.
    By the way I would try to avoid naming the administrators of your own APEX workspaces like "admin". Rather call them "admin_+workspace+"

    Regards,

    Mathieu
  • 4. Re: Apex Listsner issue
    WIP Newbie
    Currently Being Moderated
    Thanks You Dear

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points