13 Replies Latest reply: Jun 7, 2012 11:10 AM by Kavi K RSS

    ORA-01034 Error While Configuring Oracle Database

    Kiran Jyothi Ruttala

      Hello,

       

      We have installed Patrol KM for Oracle. While configuring, we are giving the DBA credential and getting the error message as below. Please note Patrol user is a member of the DBA group and it has got all the privileges in the sqlplus and the oracle executables.

       

      We have configured the log monitoring instance from PCO but none of them are showing in the console. When we are checking the configurations from the Patrol Configuration Manager those instance values are visible. Even we are trying to delete the existing instances and add new instance from PCM, that is not working.

      Error.jpg

      Please help us on this.

       

      Thanks in advance,

       

      Best Regards,
      Kiran.

        • 1. ORA-01034 Error While Configuring Oracle Database
          Jonathan Coop

          The error is coming from Oracle itself, so I'd start by checking your connection details etc. Can you connect from the agent to the database using some other means (as a test to isolate the problem)?

           

           

          Jon

          • 2. ORA-01034 Error While Configuring Oracle Database
            Marko Lahtinen

            Please share, if possible, the configurations of this instance.

            • 3. ORA-01034 Error While Configuring Oracle Database
              Pritam Majumder

              Hi Jon,

              Thanks for you reply. Actually this is coming in our environment and Kiran had posted on behalf of me. let me summarize:

              When i login to the server and set the Oracle environment variable paths and then execute sqlplus I am successfully able to login to the database using dba credentials.

              Now in Patrol I have added the instance and then I am trying to configure them, but at that time I am getting the error.

              I am also posting the debug log, if it can help you to analyze better:

              ####################################################################

              initialize the instance with:
                collectOK: 0

              Listing Oracle Tools on Unix platform

              ORAUnixL.psl::OraUnixFindOracleTools home >>/oracle/XXXXXX/db_10.2.0/<<

              ORAUnixL.psl::OraUnixFindOracleTools instObj >>/ORACLE_INSTANCE/XXXXXX<<

              ORAUnixL.psl::_OraGetGroupId result >>dba
              <<

              ORAUnixL.psl::_OraUnixCheckPermissions command >>ls -l /oracle/soartl/db_10.2.0//bin/sqlplus<<

              ORAUnixL.psl::_OraUnixCheckPermissions result >>-rwsrwsrwx<<

              ORAUnixL.psl::_OraUnixCheckPermissions lsGid >> dba <<

              ORAUnixL.psl::_OraUnixCheckPermissions returning true.

              ORAUnixL.psl::_OraUnixCheckPermissions command >>ls -ald /oracle/soartl/db_10.2.0//bin<<

              ORAUnixL.psl::_OraUnixCheckPermissions result >>drwxrwxrwx<<

              ORAUnixL.psl::_OraUnixCheckPermissions lsGid >> dba <<

              ORAUnixL.psl::_OraUnixCheckPermissions returning true.

              ORAUnixL.psl::_OraUnixCheckPermissions command >>ls -ald /oracle/soartl/db_10.2.0//lib<<

              ORAUnixL.psl::_OraUnixCheckPermissions result >>drwxrwxrwx<<

              ORAUnixL.psl::_OraUnixCheckPermissions lsGid >> dba <<

              ORAUnixL.psl::_OraUnixCheckPermissions returning true.


                 remote connect: TWO_TASK
                 tns_name:
                 service:
                 sid name: ORACLE_SID### XXXXXX is a local instance.

              get privileged account for configuration.the bConfFlag is >>1<<
              ORACtAsClause - begin.
              needas = -0-
              oracle_sid = -XXXXXX-

              ct_status = -0-

              sResult = -ERROR:
              ORA-01034: ORACLE not available
              ORA-27101: shared memory realm does not exist
              Linux Error: 2: No such file or directory


              ERROR:
              ORA-01017: invalid username/password; logon denied


              ERROR:
              ORA-01017: invalid username/password; logon denied


              -
              ORACtAsClause - begin.
              needas = -2-
              oracle_sid = -XXXXXX-

              ct_status = -0-

              sResult = -SELECT COUNT(*) FROM V$SESSION
              *
              ERROR at line 1:
              ORA-01034: ORACLE not available


              commit
              *
              ERROR at line 1:
              ORA-01034: ORACLE not available


              -

              ct_status = -0-

              update default account in pconfig for system
              verify the given account with result:
              select '!'||name from v$database
              *
              ERROR at line 1:
              ORA-01034: ORACLE not available


              select '@', grantee, granted_role from dba_role_privs
              *
              ERROR at line 1:
              ORA-01034: ORACLE not available


              commit
              *
              ERROR at line 1:
              ORA-01034: ORACLE not available

              ####################################################################

               

              Thanks in advance

              Pritam

              • 4. ORA-01034 Error While Configuring Oracle Database
                Jonathan Coop

                Did you try setting all the variables, etc, that used for this other user for patrol?, can you do the same connect using sqlplus as the patrol user (one the box where agent is)?

                 

                 

                Still the errors look like an Oracle problem.

                 

                 

                Regards

                 

                 

                Jon

                • 5. ORA-01034 Error While Configuring Oracle Database
                  Pritam Majumder

                  when I log in to the server with the patrol user then I am able to connect to oracle after setting all the env variable (e.g. ORACLE_SID, ORACLE_HOME). but the same is not working when do it from the PCO - oracle km - configure instance option.

                   

                  Regards

                  Pritam

                  • 6. Re: ORA-01034 Error While Configuring Oracle Database
                    Jonathan Coop

                    Set these env settings so that they are in the startup scripts for Patrol

                    (either the userrc.sh which is called by the patrolrc.sh) or patrol's .login

                     

                    Stop the agent completely and then start in a new shell.

                     

                    Regards

                     

                     

                    Jon

                    • 7. Re: ORA-01034 Error While Configuring Oracle Database
                      Jonathan Coop

                      Test that you can do all your sqlplus etc. without calling any env variables (having set in startup scripts). Then start the patrol agent from scratch so that it reads all the env variables and try again.

                       

                       

                      Regards

                       

                       

                      Jon

                      • 8. ORA-01034 Error While Configuring Oracle Database
                        Pritam Majumder

                        Its still same.

                        I have put all the environment variables in the patrol's .bash_profile.

                        Then stopped the patrol agent and logged off from the server.

                        Open a new shell and started the Pagent. I also checked i can invoke the sqlplus and login to the database (without setting any env variable)

                        But when I am trying to configure the instance from PCO, its failing with the same errorr.

                         

                        I am now feeling frustrated.

                         

                        Regards

                        Pritam.

                        • 9. ORA-01034 Error While Configuring Oracle Database
                          Jonathan Coop

                          It's worth having a look at the support knowledge base (you will need a valid login). Here are two possible solutions that I found:

                           

                          Oracle requires that the "oracle" executable in $ORACLE_HOME/bin have the following permission:

                           

                             -rwsr-s--x   1 oracle dba   7330847 Oct 20 11:01 oracle*

                           

                          If it does not have the above permission, the Oracle user can run everything, but other users running SQL*Plus (sqlplus), etc. see errors like:

                           

                             ORA-01034, "ORACLE not available"

                           

                          To change the permission, issue the command: chmod ug+s

                          Next, shutdown and startup database.

                           

                          Another possibility

                           

                          Can only connect to SQLPLUS outside of Patrol using SYS or a DBA account with the service name.

                          Check to see if the customer able to connect to SQLPlus from the system output window by

                          setting ORACLE_HOME, ORACLE_SID, and have $ORACLE_HOME/bin to be part of the PATH.

                          Next, connect to SQLPlus as SYS/<password>  if fails to connect, tries to connect to SQLPlus  using

                          SYS/<password>@<service name>

                          If able to connect to the database using the service name, then apply the following work-around

                          to be able to configure without doing an instance add and specify the service name:

                                          Start a developer console

                                          Attributes => Application Classes

                                          Highlight ORACLE_INSTANCE => Attributes => Commands =>  Evironment

                           

                          Define an environment variable TWO_TASK and set its

                            value to %{SID.EN_US} or %{oracle_sid}

                          Attempt configuration again.

                          NOTE: for this to work, must have in the TNSNAMES.ORA file a service name that matches with the sid name.

                          • 10. ORA-01034 Error While Configuring Oracle Database
                            Pritam Majumder

                            Actually I have followed this 2 KB articles earlier.

                            The first one I have already dine (this one helped troubleshooting on some different servers also).

                            The second option I am not sure. We do not have any developper console, rather we use PCM only.

                             

                            any suggestion?

                             

                            Pritam

                            • 11. ORA-01034 Error While Configuring Oracle Database
                              Jonathan Coop

                              Yes it'sequally relevent no matter your console type, as thbis is setting an evironment variable at the agent, if you are really trying to configure with PCM instead of either Patrol Central or a Classic console, I'd switch to a console and use menu commands there, rather than relying on copying config variables.

                               

                              Regards

                               

                               

                              Jon

                              • 12. ORA-01034 Error While Configuring Oracle Database
                                Pritam Majumder

                                Finally I am able to solve this. The reason was very silly though. ORACLE_HOME for the instance had a "/" at the end (/oracle/xxxxx/ora10.2.0/) and after I deleted the "/" it accepted the configuration .

                                 

                                Thanks

                                Pritam

                                • 13. ORA-01034 Error While Configuring Oracle Database
                                  Kavi K

                                  Hi,

                                   

                                  I faced only the logon error.

                                  ORA-01017: invalid username/password; logon denied

                                   

                                  Changing the username from uppercase to lower case for patrol account in DB (During Instance Configure after keyin of SYS pwd) solved the issue. Not sure what is the reason for the same.