Oracle10g
Oracle 10g Articles
This page contains articles related to Oracle Database 10g
Latest articles
- Copying Oracle Scheduler jobs with Arguments - Oracle provides dbms_scheduler.copy_job function to copy oracle scheduler jobs which works great. But problem is that it cannot copy jobs which have arguments. Need to copy jobs can arise due to following scenarios 1)Runaway jobs – When Scheduler job is running without any SID. This means OS session is not present and this will not [...]
- 10gR2 Silent Install with 11gr2 CRS fails - I was trying to perform a 10.2 silent install with 11gR2 CRS. While doing pre-checks installer failed with following error Check complete: Failed <<<< Problem: The 'active' version of Oracle Clusterware is not 10g Release 2 (10.2). Recommendation: You must upgrade all nodes of the cluster to Oracle Clusterware 10g Release 2. If you have [...]
- 10.2 CRS startup issue - Today I faced a strange issue with CRS post host reboot. CRS was not coming up and we could see following message in $ORA_CRS_HOME/log/<hostname>/client/clsc*.log cat clsc26.log Oracle Database 10g CRS Release 10.2.0.4.0 Production Copyright 1996, 2008 Oracle. All rights reserved. 2011-07-01 21:00:14.345: [ COMMCRS][2541577376]clsc_connect: (0x6945e0) no listener at (ADDRESS=(PROTOCOL=IPC)(KEY=CRSD_UI_SOCKET)) 2011-07-01 21:00:14.345: [ COMMCRS][2541577376]clsc_connect: (0x695020) no [...]
- Performance Management Guide on AIX - While trying to find the amount of physical memory used by oracle process on AIX, I got reference of a document from Metalink: Performance Management Guide It tell us about which process is using how much memory and how to interpret the output of commands like: vmstat, svmon, ps on AIX. Also, to get more [...]
- Effect Of Multiple SHMMAX Settings - Last week I saw a warning message at database startup time saying: WARNING: EINVAL creating segment of size 0x000000000f0020xx fix shm parameters in /etc/system or equivalent It is an Oracle 10204 database running on Solaris. Searching MOS for exact meaning for this warning, it states that a new shared memory segment is getting created to [...]
General database Administration
- Copying Oracle Scheduler jobs with Arguments
- Effect Of Multiple SHMMAX Settings
- Using Oracle Wallet to Execute Shell script/cron without hard coded Oracle database password
- CleanUp Temporary Segments Occupying Permanent Tablespace
- Generating Datapump Export Dump with Dumpfile name Containing Current Date and Time
- Cloning database..Just do some Post checks !!
- Connections to DataBase Hang Including “/ as sysdba”
- Scheduling Job through Cron??
- Recreating Database Link
- Creating Oracle Extended RAC on Oracle VM
- Full Database Export Failing With ORA-00980
- Checking Database Feature Usage Stats
- 10.2.0.4 Window’s Patchset overwrites Sqlnet.ora
- Simplified Approach to Resolve ORA-4031
- High Database Sessions
- ORA-01426 After Upgrade to 10g
- ORA- 4031 – A Case Study
- Solving ORA-1031 while connecting as “/ as sysdba” :
- AWE -What is It and How to use it?
- Recovering from ORA-1578 ORA-8103 (Logical Corruption)
Corruption
- Physical Corruption: ORA-1578 part 3
- Recovering from ORA-1578 ORA-8103 (Logical Corruption)
- Physical Corruption: ORA-1578 PART-2
- Physical Corruption: ORA-1578 -Part 1
One Comment for “Oracle10g”
Leave a Comment
#!/bin/ksh
#Script to Perform incremental backup every day at 11 am
################################################################
#Change History
#================
#DATE AUTHOR CHANGE
#——— ———————– ——————-
#08-mar-2012 Prashanth Kumar H New Script Created
#
################################################################
export ORACLE_HOME=/home/oracle10g/oracle/product/10.2.0/db_1
export ORACLE_SID=soft
export PATH=$PATH:$ORACLE_HOME/bin
rman target sys/soft
run {
ALLOCATE CHANNEL RMAN_BACK_CH01 TYPE DISK;
CROSSCHECK BACKUP;
BACKUP incremenatal level 1 AS COMPRESSED BACKUPSET FORMAT ‘/home/oracle10g/SOFT/backupsset/databasefiles_%d_%u_%s_%T’;
sql ‘ALTER SYSTEM ARCHIVE LOG CURRENT’;
BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT ‘/home/oracle10g/SOFT/archivelog/archivelogs_%d_%u_%s_%T’ DELETE INPUT;
BACKUP AS COMPRESSED BACKUPSET CURRENT CONTROLFILE FORMAT ‘/home/oracle10g_SOFT/controlfile_%d_%u_%s_%T’;
CROSSCHECK BACKUP;
DELETE NOPROMPT OBSOLETE;
DELETE NOPROMPT EXPIRED BACKUP;
RELEASE CHANNEL RMAN_BACK_CH01;
}
EXIT;
#Script Used To backup the incremental database using rman
###############################################################
* 11 * * * /home/oracle10g/rman_inc_bk.sh
but the i am getting the below error…
From oracle10g@localhost.localdomain Tue Mar 13 11:42:06 2012
Return-Path:
Received: from localhost.localdomain (localhost.localdomain [127.0.0.1])
by localhost.localdomain (8.13.1/8.13.1) with ESMTP id q2D6C6uq008864
for ; Tue, 13 Mar 2012 11:42:06 +0530
Received: (from oracle10g@localhost)
by localhost.localdomain (8.13.1/8.13.1/Submit) id q2D6C1xn008857;
Tue, 13 Mar 2012 11:42:01 +0530
Date: Tue, 13 Mar 2012 11:42:01 +0530
Message-Id:
From: root@localhost.localdomain (Cron Daemon)
To: oracle10g@localhost.localdomain
Subject: Cron /home/oracle10g/rman_inc_bk.sh
X-Cron-Env:
X-Cron-Env:
X-Cron-Env:
X-Cron-Env:
X-Cron-Env:
Recovery Manager: Release 10.2.0.1.0 – Production on Tue Mar 13 11:42:01 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: SOFT (DBID=3725122068)
RMAN>
Recovery Manager complete.
/home/oracle10g/rman_inc_bk.sh[22]: run: not found
/home/oracle10g/rman_inc_bk.sh[23]: ALLOCATE: not found
/home/oracle10g/rman_inc_bk.sh[24]: CROSSCHECK: not found
/home/oracle10g/rman_inc_bk.sh[25]: BACKUP: not found
/home/oracle10g/rman_inc_bk.sh[26]: sql: not found
/home/oracle10g/rman_inc_bk.sh[27]: BACKUP: not found
/home/oracle10g/rman_inc_bk.sh[28]: BACKUP: not found
/home/oracle10g/rman_inc_bk.sh[29]: CROSSCHECK: not found
/home/oracle10g/rman_inc_bk.sh[30]: DELETE: not found
/home/oracle10g/rman_inc_bk.sh[31]: DELETE: not found
/home/oracle10g/rman_inc_bk.sh[32]: RELEASE: not found
/home/oracle10g/rman_inc_bk.sh[33]: syntax error: `}’ unexpected