BLOG

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

Posted on 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
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 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 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

ORA-19566 exceeded limit of %s corrupt blocks for file %s

Posted on by Osama Mustafa in Database 
Cause: The user specified limit of allowable corrupt blocks was exceeded 
 while reading the specified datafile for a datafile copy or backup. 
Action: None. The copy or backup operation fails. The session trace file 
 contains detailed information about which blocks were corrupt.
 
 
But The Below is Work around : 
 
  
 1)Run DBVerify utility. Have a look at Verify Physical Data Structure



For example,
 
 
 $ dbv file=/oradata2/data1/dbase1/system01.dbf 
 
 Also run this operation for against the all datafiles you suspect which has corrupt block.



2)While taking backup within RUN block specify SET MAXCORRUPT in order 
to say how many corruption it can handle. I ran dbverify utility and I 
saw 1 block corrupt each in SYSTEM(1) and SYSAUX(3) datafile.



3)Now backup database with SET MAXCORRUPT option.


 


Syntax : 

 


SET MAXCORRUPT FOR DATAFILE File_id For DatabaseFiles to ;
 

SET MAXCORRUPT FOR DATAFILE  to ;
 

RMAN> RUN{

2> SET MAXCORRUPT FOR DATAFILE 1,3 to 1;

3> BACKUP DATABASE;

4> }



For datafile 1 and 3 maximum 1 block corruption can be tolerated.


 





 


Thank you 


Osama Mustafa 


  

	

	

	




	
	

		
Check RMAN Backup Status
				

					Posted on  by Osama Mustafa in Scripts				


				

	

		
The Below Scripts To Check Backup Status Via Sqlplus , Maybe you will find Same Or Another Scripts In the Same way :  


Sqlplus / as sysdba 


This script will report on all backups – full, incremental and archivelog backups –




col STATUS format a9
col hrs format 999.99
select
SESSION_KEY, 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
from V$RMAN_BACKUP_JOB_DETAILS
order by session_key;




 


This script will report all on full and incremental backups, not archivelog backups –




col STATUS format a9
col hrs format 999.99
select
SESSION_KEY, 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
from V$RMAN_BACKUP_JOB_DETAILS
where input_type='DB INCR'
order by session_key;




I would Love to Thank gavin soorma – OCM For His Amazing Effort . Share it For Knowledge .


Thank you
Osama Mustafa



	

	

	




	
	

		
Working with RMAN Stored Scripts
				

					Posted on  by Osama Mustafa in Scripts				


				

	

		


Creating Stored Scripts: CREATE SCRIPT


 


Make sure RMAN is connected to the right target database and the recovery catalog. Then run the CREATE SCRIPT command, as shown in this example: 


 




 


CREATE SCRIPT full_backup 
{     
  BACKUP DATABASE PLUS ARCHIVELOG;
  DELETE OBSOLETE;
} 


 


 




 you can also provide a COMMENT with descriptive information:




CREATE GLOBAL SCRIPT global_full_backup 
COMMENT 'use only with ARCHIVELOG mode databases'
{     
  BACKUP DATABASE PLUS ARCHIVELOG;
  DELETE OBSOLETE;
}






Running Stored Scripts: EXECUTE SCRIPT


 




RUN { EXECUTE SCRIPT full_backup; }






Displaying a Stored Script: PRINT SCRIPT




PRINT SCRIPT full_backup;


PRINT SCRIPT full_backup TO FILE 'my_backup.txt'; 






Listing Stored Scripts: LIST SCRIPT NAMES




LIST SCRIPT NAMES;








LIST ALL SCRIPT NAMES;






Updating Stored Scripts: REPLACE SCRIPT




REPLACE SCRIPT full_backup 
{
  BACKUP DATABASE PLUS ARCHIVELOG;
}




Deleting Stored Scripts: DELETE SCRIPT


  




DELETE SCRIPT 'full_backup';


DELETE GLOBAL SCRIPT 'global_full_backup'; 




 


 


 


 Thank you 


Osama mustafa


 




 




 



	

	

	




	
	

		
DBCONSOLE For Real Application Cluster
				

					Posted on  by Osama Mustafa in Database				


				

	

		


Drop DBCONSOLE FOR RAC (Uninstall) : 




we will user the following command :


emca -deconfig dbcontrol db -repos drop -cluster


Make sure you have the below information :




    

  • Database unique name
    • 

  • Listener port number
    • 

  • Password for SYS user
    • 

  • Password for SYSMAN user
    • 





Create DBCONSOLE FOR RAC ( Install) :  


In this case you have more than one choice you can use what you want depend on your requirements :


1-


emca -config dbcontrol db -repos create -cluster


2-


 emca -reconfig dbcontrol –cluster –EM_NODE node1 -EM_NODE_LIST node2,node3,node4




emca -reconfig dbcontrol –cluster –EM_NODE node5 -EM_NODE_LIST node6,node7,node8


 The below Information for installing DBCONSOLE :




    

  • The Database unique name
    • 

  • The Listener port number
    • 

  • The Cluster name
    • 

  • The Password for SYS user
    • 

  • The Password for DBSNMP user
    • 

  • The Password for SYSMAN user
    • 

  • The Email address for notifications (optional)
    • 

  • The Outgoing Mail (SMTP) server for notifications (optional)
    • 

  • The ASM ORACLE_HOME e.g. /u01/app/asm/product/10.2.0
    • 

  • The ASM port e.g. 1521
    • 

  • The ASM user role e.g. SYSDBA
    • 

  • The ASM username e.g. SYS
    • 

  • The ASM user password
    • 





Note : Sometimes you need to put the password between “” .  
Thank you
Osama mustafa

	

	

	




	
	

		
FRM-92100 : your connection to the server was interrupted
				

					Posted on  by Osama Mustafa in Application				


				

	

		


Cause


NLS_LANG has been set to an invalid value in the environment of the user starting Oracle Forms Services. 


 Solution


Set NLS_LANG to a valid value like AMERICAN_AMERICA.AR8MSWIN1256 in the default.env file or any custom environment file which is being used. 


You can go to regedit and also set the NLS_LANG value to the one mentioned above and check if this resolves the issue. 


 If the Above Solution Doesn’t Work For you Try The Below One : 


1) FRM-92100 occurs when invoking a new forms session from existing form  session, or another URL is invoked from the parent browser window of  the forms applet? 


To work-around use the applet parameter separateFrame=”True”. This parameter is set in the static html file or formsweb.cfg 


2) If using Oracle Jinitiator, try clearing the Jinitiator JAR or jcache: 


For versions 1.3.x.x.x : Control Panel – Jinitiator Control Panel – Cache Tab Page – Clear JAR Cache button 


3) If using MS Internet Explorer check that permissions / security options are set correctly 


Launch Microsoft Internet Explorer. 
Select the Tools -> Internet Options from the top level menu. 
Click the SECURITY Tab: 
Choose Local Intranet Zone from the list. 
Click Custom Level. 
Select Java Permissions –  Custom from the list. 
Click Java Custom Settings. 
Select the Edit Permissions tab. 
Choose Enable for Run Unsigned Content. 
Choose Enable for Run Signed Content. 
Select the ADVANCED tab. 
Scroll down to Java VM. 
Check the Java console enabled option. 
Select the CONNECTIONS tab. 
Click the LAN Settings button. 
If IE is using a proxy server : Check the Bypass proxy server for local  addresses check box. Click the Advanced button, and enter the local  domain in the Exceptions box. Use the form *.domain.com, where  domain.com maps to your local domain. 
Click OK to exit the dialog. 
Click OK to save the changes and exit IE. 
Restart the computer.


Thank you
This Work aroud Is Working For Me , Hope it will be useful For you


Osama Mustafa  



	

	

	




	
	

		
All About Oracle WorkFlow Mailer
				

					Posted on  by Osama Mustafa in Application				


				

	

		
In this Topic We will discuss the Workflow mailer In Oracle Apps ad how to check it Let Start :


Workflow: version


  $FND_TOP/sql/wfver.sql


 check workflow status. 


set linesize 120
set pagesize 50
column COMPONENT_NAME format a45
column STARTUP_MODE format a15
column COMPONENT_STATUS format a15




select fsc.COMPONENT_NAME,fsc.STARTUP_MODE,fsc.COMPONENT_STATUS,fcq.last_update_date
from APPS.FND_CONCURRENT_QUEUES_VL fcq, fnd_svc_components fsc
where fsc.concurrent_queue_id = fcq.concurrent_queue_id(+)
order by COMPONENT_STATUS , STARTUP_MODE , COMPONENT_NAME;


check if workflow is used by only one instance








col value format a20


select p.parameter_id,


p.parameter_name,


v.parameter_value value


from apps.fnd_svc_comp_param_vals_v v,


apps.fnd_svc_comp_params_b p,


apps.fnd_svc_components c


where c.component_type = ‘WF_MAILER’


and v.component_id = c.component_id


and v.parameter_id = p.parameter_id


and p.parameter_name in ( ‘INBOUND_SERVER’,’ACCOUNT’, ‘REPLYTO’)


order by p.parameter_name; 




check for bad e-mail address 




set linesize 170
col name  format a40 
col email_address format a80  
select name, email_address from apps.wf_local_roles where email_address like ‘% %’;


select name, email_address from apps.wf_local_roles where email_address like ‘%%’;


 “If this retuning Row The there’s bad Email”


How to know mail sent to a user with details: 




select name, display_name, notification_preference, email_address


 from wf_local_roles where name = ”;




To see failed, open notifications 


SELECT message_type, COUNT(1)
FROM apps.wf_notifications
WHERE 1 = 1 AND mail_status = ‘FAILED’ AND status = ‘OPEN’
GROUP BY message_type;


To check if email address, notification preference, display_name 




select DISPLAY_NAME, NOTIFICATION_PREFERENCE from wf_users where  EMAIL_ADDRESS = ‘HR@domainname.com‘ and STATUS = ‘ACTIVE’ and DISPLAY_NAME =  ‘xxxxx’;




select DISPLAY_NAME, NOTIFICATION_PREFERENCE, EMAIL_ADDRESS from   wf_users where NOTIFICATION_PREFERENCE=’MAILTEXT’ and STATUS = ‘ACTIVE’;




select distinct(count(*)) from wf_users where  NOTIFICATION_PREFERENCE=’MAILTEXT’ and STATUS = ‘ACTIVE’ and  EMAIL_ADDRESS = ‘HR@Domainname.com‘;




Thank you
Osama mustafa 

	

	

	




	
	

		
What Is $ADMIN_SCRIPT_HOME ???
				

					Posted on  by Osama Mustafa in Application				


				

	

		
As We All Know if you need to start/shutdown Oracle Apps you need go $ADMIN_SCRIPT_HOME In R12 Or $CONTEXT_HOME in R11
 
 This Article Explain What These Scripts Do : 


adstrtal.sh 


Master script to start all components/services of middle tier or application tier. This script will use Service Control API to start all services which are enabled after checking them in context file (SID_HOSTNAME.xml or CONTEXT_NAME.xml)




adstpall.sh


Master script to stop all components/services of middle tier or application tier 





adalnctl.sh 


Script to start / stop apps listener (FNDFS and FNDFS). This listener will file will be in 10.1.2 ORACLE_HOME (i.e. Forms & Reports Home)
listener.ora file will be in $INST_TOP/apps/$CONTEXT_NAME/ora/10.1.2/network/admin directory
(Mostly similar to one in 11i with only change in ORACLE_HOME i.e. from 8.0.6 to 10.1.2 )


 adapcctl.sh


Script to start/stop Web Server or Oracle HTTP Server. This script uses opmn (Oracle Process Manager and Notification Server) with syntax similar to opmnctl [startstop]proc ohslike opmnctl stopproc ohs .


adcmctl.sh 


Script to start / stop concurrent manager,


 adformsctl.sh


Script to start / stop Forms OC4J from 10.1.3 Oracle_Home. This script will also use opmnctl to start/stop Forms OC4J like
opmnctl stopproc type=oc4j instancename=forms




adformsrvctl.sh


This script is used only if you wish to start forms in socket mode. Default forms connect method in R12 is servlet.
If started this will start frmsrv executable from 10.1.2 Oracle_Home in Apps R12


adoacorectl.sh


This script will start/stop oacore OC4J in 10.1.3 Oracle_Home. This scripts will also use opmnctl (similar to adapcctl & adformsctl) to start oacore instance of OC4J like
opmnctl startproc type=oc4j instancename=oacore


 adoafmctl.sh


 This script will start/stop oafm OC4J in 10.1.3 Oracle_Home. This scripts will also use opmnctl (similar to above) to start oacore instance of OC4J like
opmnctl startproc type=oc4j instancename=oafm


adopmnctl.sh


This script will start/stop opmn service in 10.1.3 Oracle_Home. opmn will control all services in 10.1.3 Oracle_Home like web server or various oc4j instances. If any services are stopped abnormally opmn will/should start them automatically.


Thank You 
Osama Mustafa