|
-
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
-
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
-
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
-
Restart DB if required. this may solve the problem...
cheers/
MR
-
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
-
#!/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
-
hot backup is fine but not think controlfile backup is having problem!! please guide!!
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|