DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: SVR4 Error?

  1. #1
    Join Date
    Aug 2008
    Posts
    123

    SVR4 Error?

    RMAN-06403: could not obtain a fully authorized session
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    SVR4 Error: 2: No such file or directory

    when the backup trying to backup it gives this error in log?

    why?

    Thanks
    Pat

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Talking Oracle_home/oracle_sid

    a) You did not set the ORACLE_HOME/ORACLE_SID

    b) The database is not started
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Aug 2008
    Posts
    123
    oracle_home/oracle_sid is set in the script of backup and when i do ps -ef|grep datatabase it does return records so that means database is running? please let me know if there is other way to check it.

    OS: sun solaris:
    Oracle 10.1.0.3.0

  4. #4
    Join Date
    Dec 2007
    Posts
    82
    Restart DB if required. this may solve the problem...
    cheers/
    MR

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Talking

    This may provide a clue:

    SVR4 Error: 2: No such file or directory

    Show us your script.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  6. #6
    Join Date
    Aug 2008
    Posts
    123
    #!/bin/ksh
    ######################################################################
    # Standard RMAN Script to backup the controlfile to Disk.
    #
    # ?? ??? 03 ????? Script Created
    # ?? ??? 03 Sunny Script Modified
    # a. Prevent multiple instances of the same
    # script from running.
    # b. Use Parameters file for rman catalog,
    # password, log file names, etc.
    # ?? Mar 06 Sunny Script Modified
    # a. Common routines written to a separate script.
    ######################################################################
    umask 002
    typeset -i STATUS
    typeset -i RETCODE
    export STATUS=0
    export RETCODE=0
    BACKUP_TYPE=cntl
    ######################################################################
    # Source the file containing the common functions
    ######################################################################
    . /app/oracle/admin/scripts/rman/RMAN_common_functions.sh
    LOGNAME=$CNTLLOG
    ## Determine ORACLE HOME, LD_LIBRARY_PATH.
    get_oracle_home
    echo `date` "Begin $BACKUP_TYPE backup of $ORACLE_SID" >> $SUMMARYLOG
    echo `date` "Begin $BACKUP_TYPE backup of $ORACLE_SID" >> $SERVERLOG

    #######################################################################
    # Ensure that another instance of this backup is not already running
    #######################################################################
    cd /app/oracle/admin/scripts/rman
    # PROGRAM = RMAN script name minus "RMAN_" and the ".sh"
    PROGRAM=`echo $0|sed s/'RMAN_'/''/g|sed s/'.sh'/''/g|sed s/'\/app\/oracle\/admin\/scripts\/rman\/'/''/g|sed s/'.\/'/''/g`
    CUR_DATE=`date "+%b%d.%H:%M:%S"`
    OEM_LOG=$HOME/logs/oem_errors.log
    check_duplicate_process
    touch $LOCKFILE

    ######################################################################
    # Delete old backup files based on retention times specified
    # (as parameters)
    ######################################################################
    cleanup_backup_files

    ######################################################################
    # Start the rman backup.
    ######################################################################
    echo `date` "Start rman script for ($BACKUP_TYPE) backup of $ORACLE_SID" >> $SUMMARYLOG
    echo `date` "Start rman script for ($BACKUP_TYPE) backup of $ORACLE_SID" >> $SERVERLOG
    $ORACLE_HOME/bin/rman target / >> $LOGNAME < connect $CATCMD $RMAN_USER/$RMAN_PASSWORD@$RCAT_SID;
    run {execute script backup_cf_to_disk;}
    EOF
    echo `date` "End rman script for ($BACKUP_TYPE) backup of $ORACLE_SID" >> $SUMMARYLOG
    echo `date` "End rman script for ($BACKUP_TYPE) backup of $ORACLE_SID" >> $SERVERLOG

    ######################################################################
    # Check for errors.
    ######################################################################
    if [ `grep "RMAN-00569" $LOGNAME |wc -l` -ne 0 ]
    then
    (( STATUS = STATUS | 4 ))
    send_error_message
    fi
    ######################################################################
    # Identify files to be saved.
    # From the logfile, identify all the backup pieces created during
    # this backup. These files will be compressed (if required) and saved.
    ######################################################################

    if [ $SAVE_FILES_YN = "Y" ]
    then
    if [ $COMPRESS_YN = "Y" ]
    then
    cat $LOGNAME|grep "piece handle" |$AWK -F= '{print $2}'|$AWK '{print $1".gz"}'> /app/oracle/admin/scripts/rman/${PROGRAM}.${CUR_DATE}.${ORACLE_SID}.sa
    ve_list
    else
    cat $LOGNAME|grep "piece handle" |$AWK -F= '{print $2}'|$AWK '{print $1}'> /app/oracle/admin/scripts/rman/${PROGRAM}.${CUR_DATE}.${ORACLE_SID}.save_li
    st
    fi
    fi

    ######################################################################
    # Compress / gzip the backup files
    ######################################################################
    if [ $COMPRESS_YN = "Y" ]
    then
    gzip_files
    fi

    ######################################################################
    # Save backup files (tape).
    # Delete the lockfile. This allows additional backups of the same time
    # to run even before the current save completes.
    ######################################################################
    rm $LOCKFILE
    if [ $SAVE_FILES_YN = "Y" ]
    then
    save_files &
    fi

    ######################################################################
    # Cleanup and exit
    ######################################################################
    echo `date` "End $BACKUP_TYPE backup of ${ORACLE_SID}" >> $SUMMARYLOG
    echo `date` "End $BACKUP_TYPE backup of ${ORACLE_SID}" >> $SERVERLOG
    exit 0

  7. #7
    Join Date
    Aug 2008
    Posts
    123
    hot backup is fine but not think controlfile backup is having problem!! please guide!!

  8. #8
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Talking First time?

    Is this the first time you try and execute this script?

    --- DELETED ---

    Ooops, the typo I found is actually generated by the forum...
    Last edited by LKBrwn_DBA; 08-21-2008 at 03:07 PM.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  9. #9
    Join Date
    Aug 2008
    Posts
    123
    no it's been running since long and just started show error in email like follow:
    RMAN-06403: could not obtain a fully authorized session
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    SVR4 Error: 2: No such file or directory

  10. #10
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Talking OH at 100%?

    Long shot: check if your Oracle home mount point is 100% full.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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