FRM-92050:Failed to connect to the Server

SOLUTİON:

You have to open port number 9010 on application server

ORA-19804: cannot reclaim string bytes disk space from string limit

Problem:

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/02/2013 03:01:58
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 139586437120 limit continuing other job steps, job failed will not be re-run
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_2 channel at 06/02/2013 03:01:58
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 52428800 bytes disk space from 139586437120 limit

Solution:

Increase your db_recovery_file_dest_size parameter.

SQL>alter system set db_recovery_file_dest_size=<size> scope=BOTH

'Both' means,parameter will change memory an spfile.This parameter dynamic parameter.So you can test backup now :)))

Happy Friday:))

RMAN-06214: Datafile Copy

Problem:

RMAN-06214: Datafile Copy   /u01/backup/online_backup/data_D-NECODB_I-439097153_TS-APPS_TS_SUMMARY_FNO-396_6fntn4p3


Solution:

RMAN> crosscheck copy;
RMAN> delete expired copy;

Sending An Attachment Via Unix

mutt -s "Test Mail" -a /home/applprod/doganay.zip doganayn@yahoo.com < /home/applprod/n.txt




Note:/home/applprod/n.txt is dummy txt.It can use for not opening the MUTT emulator

There Are No Active Responsibilities Available For This User

Problem:

While you are configuring DMZ Server on EBS you can some harmful changing
like 'Responsibility Trust Level’ profile
If  'Responsibility Trust Level’ status changed to 'external' from 'normal'
you may get this error below:

There are no active responsibilities available for this user


Solution:

1)

Run this procedure below with apps user:
--------------------------------------------------------------------
DECLARE
stat boolean;
BEGIN
stat := FND_PROFILE.SAVE('APPL_SERVER_TRUST_LEVEL', '2', 'SITE');
IF stat THEN
dbms_output.put_line( 'Stat = TRUE - profile updated' );
ELSE
dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
END IF;
commit;
END;
--------------------------------------------------------------------

2)Then shutdown application(adstpall.sh)

3)Then run autoconfig(autocfg.sh)

4)Finally startup your application(adstrtall.sh)

Login ebs and see your success:)


Pray and Tray:))

ORA-01565: error in identifying file

we get errors below while doing adcfgclone in test environment.

Problem:

ORA-01565: error in identifying file '/test1_db/sys/system11.dbf'
ORA-27048: skgfifi: file header information is invalid



Solution:

Resize dbfs which are full.


How to detect and fix a corruption in the datafile OS header/Block Zero - ORA-27047 (Doc ID 360032.1)
So please run the following command on the source database
dbfsize /test1_db/sys/system11.dbf

Done relinking module WSCMTM in product wsm

Problem:

While applying patch 12603409

Done relinking module WSCMTM in product wsm
Done with link of product 'wsm' on Fri Mar 29 19:34:26 EET 2013
adrelink is exiting with status 1


via adadmin relink WSM WSCMTI then 'An error occurred while relinking application programs.
Continue as if it were successful [No] :


Solution:

via adadmin relink WSM WSCMTI then 'An error occurred while relinking application programs.
Continue as if it were successful [No] :

adadmin-------->choose 2----->choose 1---->relink

Continue as if it were successful [No] :

Choose 'yes'