8 Replies Latest reply: Aug 12, 2012 1:54 PM by 906711 RSS

    Hyperion Installaion 11.1.1.3(error during configuration)

    906711
      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
          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
            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
              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
                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
                  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
                    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
                      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
                        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.