oracle error 1034, 7429 - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: oracle error 1034, 7429

  1. #11
    Join Date
    Feb 2001
    Posts
    290
    Naren,
    try to unset the env. variable ORACLE_PATH on client machine and post the tsnnames.ora from the client m/c.

    and try setting the ORACLE_HOME and ORACLE_SID from the client and give a try...

    Madhu Reddy
    xdollor@yahoo.com

  2. #12
    Join Date
    Jun 2002
    Posts
    22

    Unhappy

    dear madhu,

    I have unset the oracle_path in the client and set the oracle_sid and oracle_home.

    but still it is giving the same error.

    regards,
    naren

  3. #13
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Error: ORA 7429
    Text: smsgsg: shmget() failed to get segment.
    -------------------------------------------------------------------------------
    Cause: a shared memory segment used for all part of the SGA could not be
    retrieved.
    Action: Use the system error number in the error message to determine why
    the segment could not be retrieved. If it does not exists, shutdown
    the database using the "abort" option, and then restart it.
    If the get failed because the permissions are incorrect, make sure
    that the ownership of the oracle executable is the same as that on
    the shared memory segment.

    *** Important: The notes below are for experienced users - See [NOTE:22080.1]


    Explanation:
    This is typically reported when a user tries to connect to a
    database but either the database is NOT running or the user has
    their environment set up incorrectly.

    Diagnosis:
    - Is the database actually running ?

    - Is the connection attempt local or to a remote database ?

    Local:
    - Check ORACLE_HOME and ORACLE_SID are correct:

    env | grep ORACLE

    The ORACLE_SID is case sensitive and MUST match the instance
    ORACLE_SID.

    - Check ORACLE_HOME and the ORACLE_SID thus:

    cd $ORACLE_HOME/dbs
    ls -l sgadef$ORACLE_SID.*

    If the 'cd' fails ORACLE_HOME is incorrect. If the 'ls' shows
    no files then either the database is not running OR
    ORACLE_SID is wrong.

    - Check the Operating System error number after the ORA 7429
    message.

    Error 2 Is typically wrong ORACLE_SID or ORACLE_HOME
    Error 13 Is typically incorrect permissions on the
    'oracle' executable. As the Oracle user ensure
    the permissions are correct thus:

    cd $ORACLE_HOME/bin
    chmod 4755 oracle

    If the database is started as 'root' and the
    permissions are wrong you need to:
    Shutdown the database as root
    Change the permissions as above
    Restart the database

    TCP/IP:
    - For SQL*Net V1 over TCP/IP ensure that the ORACLE_HOME in
    the oratab file (/etc/oratab or /var/opt/oracle/oratab)
    is EXACTLY correct for the instance.

    - For SQL*Net V2 over TCP/IP ensure that the ORACLE_HOME in
    the listener.ora file is EXACTLY correct for the instance.
    This file should be in one of:
    /etc/listener.ora
    $TNS_ADMIN/listener.ora
    /var/opt/oracle/listener.ora
    or $ORACLE_HOME/network/admin/listener.ora

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width