14 Replies Latest reply: Sep 4, 2013 2:12 AM by Sh!va RSS

    Can Not start  Oracle Database after Server is restarted !!!!

    Next Level

      am building a oracle Hyperion Essbase and planning sandbox on my laptop using VMware 9.0

      and 11gr2 as ny database.

       

      Once I complete the install and config, I am installing the essbase EAS client, once that is completed I have too restart the server

       

      once the Server is back up, the database is giving me the following Error:

       

      Database Instance: Hyperion

       

      Enterprise Manager is not able to connect to the database instance. The state of the components are listed below. Page Refreshed  Aug 31, 2013 2:19:45 AM EDT 

       

      Database Instance

      Host  localhost

      Port  1521

      SID  Hyperion

      Oracle Home  C:\app\Administrator\product\11.2.0\dbhome_1

      Listener

      Status  Down

      Host  localhost

      Port  1521

      Name  LISTENER

      Oracle Home  C:\app\Administrator\product\11.2.0\dbhome_1

      Location  C:\app\Administrator\product\11.2.0\dbhome_1\network\admin

      Details  TNS-12541: TNS:no listener

      Agent Connection to Instance

      Status  Failed

      Details  ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach

       

      Change Status Details

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

       

       

      SQL> Connected to an idle instance.

      SQL> SQL> ORA-00119: invalid specification for system parameter LOCAL_LISTENER

      ORA-00132: syntax error or unresolved network name 'LISTENER_HYPERION'

      Disconnected

       

      Database Instance: Hyperion

      Error Message

      The operation for starting up the database has failed. Click 'View Details' to see the error. You may have to perform a recovery.

      View Details

      Perform Recovery

      Enterprise Manager is not able to connect to the database instance. The state of the components are listed below. Page Refreshed  Aug 31, 2013 6:56:37 AM EDT

       

      Please advise

        • 1. Re: Can Not start  Oracle Database after Server is restarted !!!!
          Sh!va

          Can you check environment Variable

          %ORACLE_HOME%=C:\app\Administrator\product\11.2.0\dbhome_1

           

          Also check TNSlistener. ora file. if all the entires are correct.

           

          Cheers!

           

          Sh!va

          • 2. Re: Can Not start  Oracle Database after Server is restarted !!!!
            Next Level

            %ORACLE_HOME%=C:\app\Administrator\product\11.2.0\dbhome_1 this look OK


            but I did a search for TNSlistener. ora file and it was not there ???


            did I miss a steo when setting up the Database


            Please advise

            • 3. Re: Can Not start  Oracle Database after Server is restarted !!!!
              UserAL1178M

              Set enviormental variables. EM need a listener in order to funcion. So start the listener by lsnrctl start command. Tns is not needed if you connect as local user like sqlplus / as sysdba

              • 4. Re: Can Not start  Oracle Database after Server is restarted !!!!
                Next Level

                please dont take this the wrong way but

                 

                I dont know what you mean by Set enviormental variables

                 

                also

                 

                This lsnrctl start command what is the detail process to complete this activity

                 

                I am really new to this database admin stuff

                 

                Thanks In advance

                • 5. Re: Can Not start  Oracle Database after Server is restarted !!!!
                  UserAL1178M

                  Why you close the issue? Did you solve it?

                  • 6. Re: Can Not start  Oracle Database after Server is restarted !!!!
                    rukbat

                    UserAL1178M wrote:

                     

                    Why you close the issue? Did you solve it?

                    ... because they multi-cross-posted the same question into the Korean mirror of these same OTN forums:

                    https://forums.oracle.com/thread/2575557

                    • 7. Re: Can Not start  Oracle Database after Server is restarted !!!!
                      Next Level

                      i did not close the issue - i most have hit the wrong button

                       

                      update

                       

                      I went into the Databse control of my Instance

                      and manual started the LISTENER


                      are this was the Result

                      Status  Up

                      Host  localhost

                      Port  1521

                      Name  LISTENER

                      Oracle Home  C:\app\Administrator\product\11.2.0\dbhome_1

                      Location  C:\app\Administrator\product\11.2.0\dbhome_1\network\admin

                       

                      But I still geting this Error

                       

                      Agent Connection to Instance

                      Status  Failed

                      Details  ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach)

                       

                      Please advise

                       

                      also

                       

                      # listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

                      # Generated by Oracle configuration tools.

                       

                       

                      LISTENER =

                        (DESCRIPTION_LIST =

                          (DESCRIPTION =

                            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

                            (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

                          )

                        )

                       

                       

                      ADR_BASE_LISTENER = C:\app\Administrator

                      • 8. Re: Can Not start  Oracle Database after Server is restarted !!!!
                        Sh!va

                        My Bad ..Check TNSnames.ora i think SID is not correct their..

                         

                        It will be under  C:\app\Administrator\product\11.2.0\dbhome_1\network\admin i think

                         

                        Cheers!

                         

                        Sh!va


                        • 9. Re: Can Not start  Oracle Database after Server is restarted !!!!
                          Next Level

                          # listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora

                          # Generated by Oracle configuration tools.

                           

                           

                          LISTENER =

                            (DESCRIPTION_LIST =

                              (DESCRIPTION =

                                (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

                                (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

                              )

                            )

                           

                           

                          ADR_BASE_LISTENER = C:\app\Administrator

                          • 10. Re: Can Not start  Oracle Database after Server is restarted !!!!
                            UserAL1178M

                            How are you trying to connect to the instance. Can you post your conection string? Is the instance up and running?

                             

                            The problem may stand that service is not register with listener. Connect to your instance as sysdba and register it by alter system register command.

                            • 11. Re: Can Not start  Oracle Database after Server is restarted !!!!
                              Next Level

                              How are you trying to connect to the instance.

                              Oracle Hyperion Essbase need it for it Shared Server Schema

                               

                              Can you post your conection string?

                              I dont know how to this Request

                               

                              Is the instance up and running?

                              After the server is Restarted this is the Error

                              Enterprise Manager is not able to connect to the database instance.

                               

                              The problem may stand that service is not register with listener.

                              How can i Validated That based on the Error I am getting 

                               

                              Connect to your instance as sysdba and register it by alter system register command.

                              I Dont know how to this command

                               

                              Please advise

                              • 12. Re: Can Not start  Oracle Database after Server is restarted !!!!
                                UserAL1178M

                                Open cmd

                                Execute sqlplus / as sysdba

                                What is the result?

                                • 13. Re: Can Not start  Oracle Database after Server is restarted !!!!
                                  Next Level

                                  Open a new command line;

                                  Type 'tnsping orcl'

                                   

                                   

                                   

                                   

                                  C:\Users\Administrator>tnsping orcl

                                   

                                   

                                  TNS Ping Utility for 32-bit Windows: Version 11.2.0.3.0 - Production on 03-SEP-2

                                  013 10:54:46

                                   

                                   

                                  Copyright (c) 1997, 2011, Oracle.  All rights reserved.

                                   

                                   

                                  Used parameter files:

                                  C:\Oracle\Middleware\dbclient32\network\admin\sqlnet.ora

                                   

                                   

                                   

                                   

                                  Used TNSNAMES adapter to resolve the alias

                                  Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhos

                                  t)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))

                                  OK (20 msec)

                                   

                                   

                                   

                                   

                                  Type 'lsnrctl status

                                  Microsoft Windows [Version 6.1.7601]

                                  Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

                                   

                                   

                                  C:\Users\Administrator>tnsping orcl

                                   

                                   

                                  TNS Ping Utility for 32-bit Windows: Version 11.2.0.3.0 - Production on 03-SEP-2

                                  013 10:59:06

                                   

                                   

                                  Copyright (c) 1997, 2011, Oracle.  All rights reserved.

                                   

                                   

                                  Used parameter files:

                                  C:\Oracle\Middleware\dbclient32\network\admin\sqlnet.ora

                                   

                                   

                                   

                                   

                                  Used TNSNAMES adapter to resolve the alias

                                  Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhos

                                  t)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))

                                  OK (0 msec)

                                   

                                   

                                  C:\Users\Administrator>lsnrctl

                                   

                                   

                                  LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 03-SEP-2013 11:03

                                  :38

                                   

                                   

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

                                   

                                   

                                  Welcome to LSNRCTL, type "help" for information.

                                   

                                   

                                  LSNRCTL> status

                                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

                                  STATUS of the LISTENER

                                  ------------------------

                                  Alias                     LISTENER

                                  Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ

                                  ction

                                  Start Date                03-SEP-2013 06:39:11

                                  Uptime                    0 days 4 hr. 24 min. 48 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\WIN-5SRHHS52LM1\list

                                  ener\alert\log.xml

                                  Listening Endpoints Summary...

                                    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))

                                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

                                  The listener supports no services

                                  The command completed successfully

                                  LSNRCTL>

                                   

                                   

                                   

                                   

                                   

                                   

                                  SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 4 01:16:19 2013

                                   

                                   

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

                                   

                                   

                                  Enter user-name: sys as sysdba

                                  Enter password:

                                  Connected to an idle instance.

                                   

                                   

                                  SQL> startup

                                  ORA-00119: invalid specification for system parameter LOCAL_LISTENER

                                  ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'

                                  SQL>

                                   

                                  Please advise

                                  • 14. Re: Can Not start  Oracle Database after Server is restarted !!!!
                                    Sh!va

                                    Can you copy the content of sqlnet.ora and add in tnslistener.ora and listener.ora.... ( Note:- Take backup of files before modifications)

                                     

                                    Looks like listener is pointing to other path ...Also can you check environment variables..i guess we will get some clue there.

                                     

                                    Cheers!

                                     

                                    Sh!va