Osama – Page 34 – Technology Geek

CRS-4640 Error on Starting 11gR2 clusterware

Posted on May 24, 2012December 23, 2018 by Osama Mustafa in Database

ERROR :

[root@RAC01 cssd]# /oragrid/product/11.2/bin/crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
CRS-4534: Cannot communicate with Event Manager

When Trying To start Oracle Cluster with following Command :

[root@RAC01 cssd]# /oragrid/product/11.2/bin/crsctl start crs
CRS-4640: Oracle High Availability Services is already active
CRS-4000: Command Start failed, or completed with errors.

When Trying To Stop Oracle Cluster With Following Command :

crsctl stop crs command failed

[root@RAC01 cssd]# /oragrid/product/11.2/bin/crsctl stop crs
CRS-2796: The command may not proceed when Cluster Ready Services is not running
CRS-4687: Shutdown command has completed with errors.
CRS-4000: Command Stop failed, or completed with errors.

Solution is Simple :

Just Run

[root@RAC01 cssd]# /oragrid/product/11.2/bin/crsctl start cluster

[root@RAC01 ~]# /oragrid/product/11.2/bin/crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

Thank you
Osama mustafa

Repair Database Corrpution Using 11g New Tools

Posted on May 23, 2012December 23, 2018 by Osama Mustafa in Database

As Database Administrator you Face Some Issue About The Database Corruption But In 11g You have Some New Tool Called “data recovery advisor” .

With DRA you check the block corruptions and loss of data files and control files. The GUI feature also available from Enterprise manager.

Lets Start Using This Tool :

RMAN> BACKUP VALIDATE

Starting backup at 01-FEB-12

21 FAILED 0 169474 2048000 1046708826
File Name: /dbs1/orcl/system01.dbf
Block Type Blocks Failing Blocks Processed

To Use This Tool Follow The Below Step :

RMAN> LIST FAILURE

List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
———- ——– ——— ————- ——-
1041 HIGH OPEN 01-FEB-12 Datafile 21: ‘/dbs1/orcl/system.dbf ‘ contains one or more corrupt blocks

RMAN> ADVISE FAILURE;

List of Database Failures
=========================
Failure ID Priority Status Time Detected Summary
———- ——– ——— ————- ——-
1041 HIGH OPEN01-FEB-12 Datafile 21:”/dbs1/orcl/system.dbf ‘ contains one or more corrupt blocks

analyzing automatic repair options; this may take some time
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=319 device type=DISK
analyzing automatic repair options complete

RMAN> Repair failure preview;

RMAN> REPAIR FAILURE;

RMAN> REPAIR FAILURE NO PROMPT;

Thank you
Osama Mustafa

Change to Archive Log Mode In Oracle Rac

Posted on May 21, 2012December 23, 2018 by Osama Mustafa in Database

1. Disable clustering putting cluster_database parameter FALSE.

$export ORACLE_SID=ORCL1
$sqlplus “/ as sysdba”

Check the status of archive mode of the database:

SQL>archive log list

Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     407
Current log sequence           408

SQL> alter system set cluster_database=false scope=spfile sid=’ORCL1′;

2. Shutdown all instances using srvctl utilty

$ srvctl stop database -d cobra

3. Mount tha database using one of the instance:

$ sqlplus “/ as sysdba”

SQL> startup mount

4. Enable archivelog using following command:

SQL> alter database archivelog;

5. Re-enable clustering putting instance parameter cluster_database to TRUE from the current instance:

SQL> alter system set cluster_database=true scope=spfile sid=’ORCL1′;

6. Shutdown the local instance:

SQL> shutdown immediate

7. Startup all instances using srvctl utility:

#srvctl start database -d orcl

8. If any service is not up then get up those using srvctl utility:

#srvctl start service -dorcl

9. And now check archivelog mode is enabled or not using following:

$sqlplus “/ as sysdba”

SQL> archive log list

Database log mode            Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     407
Current log sequence           408

Thank you
Osama mustafa

Steps To Clone Oracle EBS R12

Posted on May 20, 2012December 23, 2018 by Osama Mustafa in Application, Articles

There’s Two major Parts In This Topics :
1- Pre Clone Steps .
2 – Post Clone Steps.

LETS START :

1- Pre Clone Steps :

On Application Tier :

1-    Execute Apps environment file
2-    cd $ADMIN_SCRIPTS_HOME
3-    ./adautocfg.sh
4-    Perl adpreclone.pl appsTier

Database Tier :

1-    Execute Database environment ( under ORACLE_HOME)
2-    cd $ORACLE_HOME/appsutil/scripts/(CONTEXT_NAME)
3-    ./adautocfg.sh
4-    perl adpreclone.pl dbTier

shutdown application and database Copy your virtual nodes on new servers .

Post clone Steps:

Database Server

1- cd $ORACLE_HOME/appsutil/clone/bin
2- perl adcfgclone.pl dbTier

Application Server:

1- cd $COMMON_TOP/clone/bin
2- perl adcfgclone.pl appsTier

Notes:
$COMMON_TOP: APPLICATION_BASE/apps/apps_st/comn
CONTEXT_NAME: SERVICE_NAME_HOSTNAME

Thank you
Osama mustafa

ORA-00020: maximum number of processes (%s) exceeded

Posted on May 18, 2012December 23, 2018 by Osama Mustafa in Database

SQL> show parameter processes

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
processes                            integer     150

SQL> select count(*) from v$process;

  COUNT(*)
----------
       149

SQL> alter system set processes=300 scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

SQL> show parameter processes

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
processes                            integer     300

Thank you
Osama mustafa

ORA-16038 ORA-19504

Posted on May 17, 2012December 23, 2018 by Osama Mustafa in Database

Archiver Hung in Oracle database

Summary

1. check how much space is used by archiver

2. check the last good backup of the database

3. delete archive log files older than last good backup

4. crosscheck archive log

1. check how much space is used by archiver

Sql> select count(*),sum(blocks*block_size) from v$archived_log where backup_count=0 and deleted=’NO’;
Sql> select * from v$flash_recovery_area_usage;

2. check the last good backup of the database

set pages 999 lines 120

   col STATUS format a9

   col hrs format 999.99

   col start_time format a15

   col end_time format a15

   col dev format a5

   col inbytes format a10

   col outbytes format a10

   select

       INPUT_TYPE, STATUS,

       to_char(START_TIME,’mm/dd/yy hh24:mi’) start_time,

       to_char(END_TIME,’mm/dd/yy hh24:mi’)   end_time,

       elapsed_seconds/3600                   hrs,

       output_device_type dev,

       input_bytes_display inbytes,

       output_bytes_display outbytes

    from V$RMAN_BACKUP_JOB_DETAILS

   order by session_key;

3. delete archive log files older than last good backup

rman target / nocatalog
allocate channel for maintenance device type disk;
crosscheck archivelog all;
delete noprompt archivelog until time ‘sysdate – 1’;
delete noprompt expired archivelog all;
delete noprompt obsolete device type disk;

4. crosscheck archive log

crosscheck archivelog all;
release channel;
exit;

Thank you

Osama mustafa

ORA-19566: exceeded limit of 0 corrupt blocks for file

Posted on May 17, 2012December 23, 2018 by Osama Mustafa in Database

I already Talk about this Error but this Topics Share Another Solution For it :

RMAN> backup database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/22/2011 11:45:40
ORA-19566: exceeded limit of 0 corrupt blocks for file /oracle/oradata/orcl/system01.dbf

SQL> select * from V$DATABASE_BLOCK_CORRUPTION;

     FILE#     BLOCK#   BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
  5  2684        1    0 CHECKSUM

RMAN> blockrecover datafile 5 block 2684;

Thank you
Osama mustafa

ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 960

Posted on May 16, 2012December 23, 2018 by Osama Mustafa in Database

This Error Appear when you try to create MATERIALIZED VIEW On remote View

First you have to know it

Bug 5583712 ORA-942 on create materialized view on remote view

*Product (Component)*	Oracle Server (Rdbms)
*Range of versions believed* to be affected**	Versions < 11
*Versions confirmed* as being affected**	10.2.0.3
Platforms affected	Generic (all / most platforms affected

You can check Metalink Doc : 5583712.8

But I would Share this solution All you Have to do is follow the below steps :

CREATE MATERIALIZED VIEW RHC
BUILD IMMEDIATE
USING INDEX
REFRESH COMPLETE ON DEMAND START WITH SYSDATE+1 NEXT SYSDATE + 8/24
AS SELECT * FROM vw_RHC@remotedb;

ORA-00942: TABLE OR VIEW does NOT exist
ORA-06512: AT “SYS.DBMS_SNAPSHOT_UTL”, line 960
ORA-06512: AT line 1

The Solution is :

CREATE MATERIALIZED VIEW RHC
BUILD IMMEDIATE
USING INDEX
REFRESH COMPLETE ON DEMAND START WITH SYSDATE+1 NEXT SYSDATE + 8/24
AS AS SELECT * FROM (SELECT * FROM vw_employees@remotedb);

Materialized VIEW created.

Thank you
Osama mustafa

OAS process type = OC4J:Home unable to start

Posted on May 14, 2012December 23, 2018 by Osama Mustafa in Database

After Trying All The Solutions , Metalink note nothing Works But Never Give up I provide Solution For The
below Error :

Error
–> Process (pid=8337)
time out while waiting for a managed process to start
Log:
/oraas/ias10g/MID/opmn/logs/OC4J~home~default_island~1

Note : Try This Solution After Have been Increase timeout On Opmn.xml

Solution :

1- Create New OC4J instance By

createinstance -instanceName OC4J_instanceName

Enter Password That you want .

2- Check /etc/hosts On you server, Its must Contain

127.0.0.1 localhost.localdomain localhost

3-group must be change from default_group to your new Group (that you Create it in Step 1 ) .

cd $ORACLE_HOME/opmn/conf/
vi opmn.xml

Search For Default_group (its Default Group in Installation) and Change it to New One
For Example :

You New OC4J_instance_name : test
Default group Should be : test_group
Search For Default_group and Change it with test_group.

4-aftre the above steps :

opmnctl stopall
opmnctl startall

Thank you
Osama Mustafa

ORA-01034: ORACLE not available When Create DBCONSOLE

Posted on May 14, 2012December 23, 2018 by Osama Mustafa in Database

ORA-01034: ORACLE not available When Create DBCONSOLE / DBCONTROL

If you are using the following Command :

$ emca -deconfig dbcontrol db -repos drop

$ emca -config dbcontrol db -repos create

Try Use

emca -config dbcontrol db -repos recreate -ORACLE_HOSTNAME “Hostname”
-SID “SID” -PORT “PortNumber” -ORACLE_HOME $ORACLE_HOME -DBDNMP_PWD “Password”

It Should be Work

Thank you
Osama mustafa