Posts

Showing posts from April, 2012

Automatic Storage Management/ASM Part 2

Image
Templates:Templates are named groups of attributes that can be applied to the files within a disk groupExamples :-- Create a new template. ALTER DISKGROUP disk_group_1 ADD TEMPLATE my_template ATTRIBUTES (MIRROR FINE); -- Modify template. ALTER DISKGROUP disk_group_1 ALTER TEMPLATE my_template ATTRIBUTES (COARSE); -- Drop template. ALTER DISKGROUP disk_group_1 DROP TEMPLATE my_template;

Available attributes include:
UNPROTECTED - No mirroring or striping regardless of the redundancy setting.MIRROR - Two-way mirroring for normal redundancy and three-way mirroring for high redundancy. This attribute cannot be set for external redundancy.COARSE - Specifies lower granuality for striping. This attribute cannot be set for external redundancy.FINE - Specifies higher granularity for striping. This attribute cannot be set for external redundancy.DirectoriesA directory heirarchy can be defined using the ALTER DISKGROUP statement to support ASM file aliasing Examples :
-- Create a directory. A…

rman-06054 media recovery requesting

RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 02/13/2011 14:51:58 RMAN-06054: media recovery requesting unknown log: thread 1 seq 2 lowscn 547146This Error Happened Sometimes When you try to restore rman backup from Real ApplicationCluster To single Node Solution RMAN > recover database noredo; Thank youOsama mustafaHope This is useful .

RMAN-10003 ORA-12154

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/15/2011 12:54:22
RMAN-12001: could not open channel ORA_DISK_1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database
ORA-12154: TNS:could not resolve the connect identifier specified


Solution :

RMAN> run {
2> allocate channel ch00 type disk;
3> restore database;
4>}


Thank You
osama Mustafa

500 Internal Server Error / Oracle Application Server

Image
There's more than One Reason For this i will provide you with two solutions (Meta-link Note):

Solution One : 

1. Backup and edit the forms configuration file (Default= formsweb.cfg)
2. Modify the HTMLdelimiter to have only one character as a value 

HTMLdelimiter=% 3. Save and exit the file.

Solution Two :

Edit oracle_apache.conf and comment out the include related to the forms.conf  as the following :
# Oracle Forms Developer
#include "/oas/product/oas2/forms/server/forms.conf"

Thank You
osama mustafa


RAID PRINCIPLE

Image
RAID : Redundant Array of Inexpensive (Independent) Disks

RAID TYPE :
RAID 0RAID 1RAID 5RAID 10 (also known as RAID 1+0) RAID LEVEL 0   Following are the key points to remember for RAID level 0. Minimum 2 disks.Excellent performance ( as blocks are striped ).No redundancy ( no mirror, no parity ).Don’t use this for any critical system.
RAID LEVEL 1
Following are the key points to remember for RAID level 1. Minimum 2 disks.Good performance ( no striping. no parity ).Excellent redundancy ( as blocks are mirrored ). RAID LEVEL 5  Following are the key points to remember for RAID level 5. Minimum 3 disks.Good performance ( as blocks are striped ).Good redundancy ( distributed parity ).Best cost effective option providing both performance and redundancy. Use this for DB that is heavily read oriented. Write operations will be slow.
RAID LEVEL 10











 Following are the key points to remember for RAID level 10. Minimum 4 disks.This is also called as “stripe of mirrors”Excellent redundancy ( as …

IMP-00003 With ORA-03113/ORA-03114

Error : 

“IMP-00003: ORACLE error 3113 encountered, ORA-03113: end-of-file on communication channel”
 OR
“IMP-00003: ORACLE error 3114 encountered, ORA-03114: not connected to ORACLE”


Cause : 

 database corruption or deletion of any critical files from the Oracle database which further makes the data stored in the database inaccessible , this error can appear on any platform .

Solution : 

Login as “sys” in SQLPLUS and run the below Sqls.$OH/rdbms/admin/prvtread.plb.$OH/rdbms/admin/dbmsread.sql. Retry Your Import .


Thank you
Osama Mustafa.

Automatic Storage Management (ASM) / Part 1

using SQL*Plus connect to the idle instance.

export ORACLE_SID=+ASM
sqlplus / as sysdba

Startup and Shutdown of ASM Instances ASM instance are started and stopped in a similar way to normal database instances. The options for the STARTUP command are:
FORCE - Performs a SHUTDOWN ABORT before restarting the ASM instance.MOUNT - Starts the ASM instance and mounts the disk groups specified by the ASM_DISKGROUPS parameter.NOMOUNT - Starts the ASM instance without mounting any disk groups.OPEN - This is not a valid option for an ASM instance. The options for the SHUTDOWN command are:
NORMAL - The ASM instance waits for all connected ASM instances and SQL sessions to exit then shuts down.IMMEDIATE - The ASM instance waits for any SQL transactions to complete then shuts down. It doesn't wait for sessions to exit.TRANSACTIONAL - Same as IMMEDIATE.ABORT - The ASM instance shuts down instantly.ASM Disk Groups  level of redundancy:NORMAL REDUNDANCY - Two-way mirroring, requiring two failure groups…

Changing Archive Log Destination

Today I am Gonna Show you How to change Archive log Destination in Two Ways :

1.Temporarily Changing the Destination Using SQL*Plus

sqlplus / as sysdba

sql> archive log list; Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/product/10.2.0/db_1/dbs/arch
Oldest online log sequence 9285
Next log sequence to archive 9287
Current log sequence 9287To change the location

sql>ARCHIVE LOG START '/u01/arch';
To Verify your changes:

sql> archive log list;
Database log mode Archive Mode Automatic archival Enabled Archive destination /oracle/arch Oldest online log sequence 9285 Next log sequence to archive 9287 Current log sequence 9287
2-Permanently Changing the Destination Using SQL*Plus

sqlplus / as sysdba

ALTER SYSTEM SET log_archive_dest ='/oradata/arch' scope=both;To Verify your changes:

sql> archive log list;

Database…

ORA-16018 ORA-16019

Cause : 
These two errors come whenever LOG_ARCHIVE_DEST is set as archival location and you want to set DB_RECOVERY_FILE_DEST


Solution : 

1- You need to see Archive log destination First .
SQL > archive log list ; 
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 215
Next log sequence to archive 217
Current log sequence 217
2-You Can Check Archive Location  By Check Database Parameter

SQL> show parameter DB_RECOVERY_FILE_DEST
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /oradata
 db_recovery_file_dest_size big integer 10G
 3-Set New Archive Log Location

SQL> alter system set log_archive_dest='/u01'; alter system set log_archive_dest='/u01'
*
ERROR at line 1:
ORA-02097: parameter cannot b…

Remove Node From Oracle Rac 10g ( Part-2)

Image
Remove Node From The Database :  ( From The Node You want to Delete) 

**Before You Start Deleting Node From Database You need To update inventory by :
./runInstaller –updateNodeList ORACLE_HOME=<Database home> "CLUSTER_NODES=<node to be removed>" –local