Posts

Showing posts from February, 2012

FRM-92102 : A network error has occured

Image
FRM-92102 is Gerneric Error maybe occur for more than one reasons :

1-Network 
2-Proxy
3-http
4-Session Time 


But today i will discuss the problem On oracle Application server 10g .
Description for the problem like the following when you try to connect on your deploy application On OAS 10g it's gives the above error from 1-5 minutes.

I will give you more than one solution maybe it will be related to the above problem and you try them separately to see which one will be valid for you : 

1-Netowrk Parameters :
You will find it $ORACLE_HOME/forms/server/default.env
Just increase the value .


2-do the following change in opmn.xml (under $ORACLE_HOME/opmn/conf/):




3-SET Inbound_connection_timeout In sqlnet.ora to ZERO .
Sqlnet.Inbound_connection_timeout = 0

Note : if your can't find this parameter in the SQLNET.ORA you cant add it .


5- Change the following $ORACLE_HOME/opmn/conf/opmn.xml








Hope this will work 

Thank you  Osama mustafa 

ORA-12528 tns listener all appropriate instances are blocking new connections

SQL> set ORACLE_SID=ORCL SQL> startup nomount ORACLE instance started. Total System Global Area 263639040 bytes Fixed Size 1332552 bytes Variable Size 222300856 bytes Database Buffers 33554432 bytes Redo Buffers 6451200 bytes C:\>lsnrctl services LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production Service "ORCL" has 2 instance(s). Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:59 LOCAL SERVER Instance "ORCL", status BLOCKED, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVER Service "ORCL_XPT" has 1 instance(s). Instance "ORCL", status BLOCKED, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOC…

RAC TO SINGLE NODE STEPS

Take RMAN backup of the production RAC database

1-
RMAN> run{
allocate channel c1 type disk format '/tmp/%U';
backup database;
backup archivelog all;

backup controlfile ;
}



2-Create Pfile from RAC for single Node Using SQLPLUS :
 SQL>create pfile '' from spfile ;

3-Open pfile that you create it and modify the following parameters manually:
%dest, control_files
log_archive_dest_1
cluster_database_instances

4-Use the pfile created above to STARTUP NOMOUNT the database on the new host
$ sqlplus / as sysdba
SQL> startup nomount;


5-rman target /
A-restore controlfile from '/tmp/< backup piece name of controlfile auto backup>';
OR
  restore controlfile from '/media/moh_1509/MEPSLIVE_20110919_762231895_3885.ctl'




B-ALTER DATABASE MOUNT ;
C.catalog backuppiece  '.bkp' repeat it for all of backupset .
D.catalog backuppiece  '.arch' repeat it for all of ARCHIVELOG.

E.
run
{
set newname for datafile 1 to '';
set newname for datafile 2…