This discussion is archived
8 Replies Latest reply: Aug 12, 2012 11:54 AM by 906711 RSS

Hyperion Installaion 11.1.1.3(error during configuration)

906711 Newbie
Currently Being Moderated
Hi All

I am Installing hyperion 11.1.1.3 on windows server2003 R2.I installed all the components individually Hyperion fondation first,essbase planning , FR then workspace and I created one schema after installing oracle 11g but when I try to configure the fondation first it asked me for database connection
Database-oracle
server-My computer server name(BoyazServaer)
port-1521
service name SID-orcl
username-system
password- my own password

After entering when I click next I am getting below error
"Error establishing socket to host and port:BoyazServer:1521:Reason connection refused connect.

I would really appreciate if anyone help me out.Please help me out I am in the middle of installation.

Thanks in advance
  • 1. Re: Hyperion Installaion 11.1.1.3(error during configuration)
    Nicholas King Journeyer
    Currently Being Moderated
    Is your listener up? Can you telnet to 1521? Can you connect to your database via a typical database tool like sqldeveloper?

    Thanks
    Nick
  • 2. Re: Hyperion Installaion 11.1.1.3(error during configuration)
    906711 Newbie
    Currently Being Moderated
    Is your listener up? Can you telnet to 1521? Can you connect to your database via a typical database tool like sqldeveloper?

    Can you please tell me how to check whether my listener is up or not?

    When I do telnet to 1521 in command prompt I getting the below message
    "could not open the connection to host on port 23 connect failed

    When I connect to sql
    Enter username-system
    passwod-my own password
    when I enter I got the below message
    "oracle database 11g Enterprise edition release 11.2.0.1.0 -64 bit production with partitioning ,OLAP Data mining Real application Testing options"


    Thanks
    Boya
  • 3. Re: Hyperion Installaion 11.1.1.3(error during configuration)
    JohnGoodwin Oracle ACE
    Currently Being Moderated
    You can check the listener status from command line.

    lsnrctl status

    This should inform whether the listener is running

    If you log in through SQLPLUS you can usually can the status.

    If you receive
    ORA-12541: TNS:no listener - Then the listener is not up and running.
    ORA-12514: TNS:listener does not currently know of service requested in connect - This can mean the listener is up and running but the database instance is not up.

    If you don't get any error messages when logging in through SQLPLUS issue the following

    select status from v$instance;

    If the database is up and running it shoud return OPEN.

    If the database it OPEN then your issue lies elsewhere.

    Cheers

    John
    http://john-goodwin.blogspot.com/
  • 4. Re: Hyperion Installaion 11.1.1.3(error during configuration)
    906711 Newbie
    Currently Being Moderated
    You can check the listener status from command line.
    lsnrctl status------------??

    This is what I got when I entered lsnrc status

    D:\app\Administrator\product\11.2.0\dbhome_1>cd..

    D:\app\Administrator\product\11.2.0>;cd dbhome_2

    D:\app\Administrator\product\11.2.0\dbhome_2>telnet 1521
    Connecting To 1521...Could not open connection to the host, on port 23: Connect
    failed.
    D:\app\Administrator\product\11.2.0>;cd dbhome_3
    D:\app\Administrator\product\11.2.0>;cd dbhome_4

    D:\app\Administrator\product\11.2.0\dbhome_4>telnet 1521;
    Connecting To 1521;...Could not open connection to the host, on port 23: Connect
    failed
    D:\app\Administrator\product\11.2.0>;cd dbhome_1

    D:\app\Administrator\product\11.2.0\dbhome_1>lsnrctl status

    LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 06-AUG-2012 10:58
    :57

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
    ction
    Start Date 05-AUG-2012 17:41:01
    Uptime 0 days 17 hr. 18 min. 0 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Listener Parameter File C:\app\Administrator\product\11.2.0\dbhome_1\network\a
    dmin\listener.ora
    Listener Log File c:\app\administrator\diag\tnslsnr\BoyazServer\listener
    \alert\log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522ipc)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1522)))
    Services Summary...
    Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "orcl" has 1 instance(s).
    Instance "orcl", status READY, has 1 handler(s) for this service...
    Service "orclXDB" has 1 instance(s).
    Instance "orcl", status READY, has 1 handler(s) for this service...
    The command completed successfully
    ------------------------------------------------------------------------------------------------------
    If you receive
    ORA-12541: TNS:no listener - Then the listener is not up and running.
    *ORA-12514: TNS:listener does not currently know of service requested in connect - This can mean the listener is up and running but the database instance is not up.??
    In the above I did not see see any TNS.Can you please tell what other commands to use to get the mentioned stmts
    ------------------------------------------------------------------------------------
    **If you don't get any error messages when logging in through SQLPLUS issue the following*
    select status from v$instance;
    If the database is up and running it shoud return OPEN.
    If the database it OPEN then your issue lies elsewhere. ???
    The status is open............

    Please help me out what to do more to get this issue resoved.I would really appreciate everyone who is helping me out.

    Thanks in advance
  • 5. Re: Hyperion Installaion 11.1.1.3(error during configuration)
    Nicholas King Journeyer
    Currently Being Moderated
    So is your listener at port 1522 instead of 1521?


    to use telnet do telnet machine_name port like
    telnet localhost 1522

    Please try to use sqldeveloper or another tool to ensure proper database connectivity before configuring Hyperion.

    Thanks
    Nick
  • 6. Re: Hyperion Installaion 11.1.1.3(error during configuration)
    906711 Newbie
    Currently Being Moderated
    D:\app\Administrator\product\11.2.0\dbhome_1>telnet BoyazServer 1522;
    Connecting To BoyazServer...Could not open connection to the host, on port 1522;
    : Connect failed
    still I am not able to resolve please help me.......
  • 7. Re: Hyperion Installaion 11.1.1.3(error during configuration)
    JohnGoodwin Oracle ACE
    Currently Being Moderated
    Have you installed/configured Oracle multiple times as you have have four db_homes
    The tnsnames.ora should say which port, host, sid the database is running on but as you have four db_homes then it is possible you have four tnsnames
    Your listener is also running on loopback address which makes me wonder if you have network problems.

    If this is a personal install and running on one machine you could try to configure using the loopback address 127.0.0.1 and port 1522 as a test, not that I would usually recommend it.

    Cheers

    John
    http://john-goodwin.blogspot.com/
  • 8. Re: Hyperion Installaion 11.1.1.3(error during configuration)
    906711 Newbie
    Currently Being Moderated
    Yeah I have installed oracle 11g multiple times so now what I did I have created new admin user and given all the admin rights.So my question is .......its ok to install the whole hyperion again or what are the suggetions
    recommended.

Legend

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