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.