RSS

Data Objects in a data file in Oracle

How to know, find out data objects “Segments” in a given data file??

SELECT <distinct> a.segment_name,
 a.SEGMENT_TYPE,
 a.TABLESPACE_NAME,
 a.file_id,
 b.file_name Datafile_name
 FROM dba_extents a, dba_data_files b
 WHERE a.file_id = b.file_id
 AND b.file_id = <data file id>;

 

For the opposite purpose where you want to know in with data file a data object stored, you can use the following query:

SELECT a.segment_name, a.file_id, b.file_name Datafile_name
 FROM dba_extents a, dba_data_files b
 WHERE a.file_id = b.file_id AND a.segment_name = '<object_name>';
 
 

Tags: , , ,

XML Publisher Report Errors Due To: JAVA.IO.UNSUPPORTEDENCODINGEXCEPTION: &ENCODING

XML Publisher Report Errors Due To: JAVA.IO.UNSUPPORTEDENCODINGEXCEPTION: &ENCODING

APPLIES TO:
BI Publisher (formerly XML Publisher) – Version 10.1.3.2.0 to 11.1.1.5.0 [Release 10.1 to 11.1]
Oracle Application Object Library – Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
SYMPTOMS:
Using XML Publisher to generate a custom report.
You created an RDF report, configured it as a concurrent program,
changed output to XML and created a .rtf template in XML Publisher in order to have output in .pdf
When run, no output is generated.
The OPP log contains errors Caused by: java.io.UnsupportedEncodingException: &Encoding

CAUSE:
Incorrect encoding value in the report’s prolog

SOLUTION:
To resolve the issue:

1.Open the custom report in the Report Builder

2.Go to the property pallette of the Report

3.Remove the xml prologue value

4.Save the changes

5.Retest the issue.

 

Reference:

Doc ID 1051228.1

 

Tags: ,

compile jsp in EBS R12

compile jsp in EBS R12

Compile a jsp page:
cd $OA_HTML
$FND_TOP/patch/115/bin/ojspCompile.pl –compile -s ‘xxxx.jsp’ -log err.log –flush

Compile all jsp pages:
$FND_TOP/patch/115/bin/ojspCompile.pl –compile  –flush -p 4

Enable Automatic Compilation of JSP pages in R12
edit the $CONTEXT_FILE
Change value for the entry s_jsp_main_mode from justrun to recompile

run AutoConfig, restart the web tier services.

 

Tags:

Unable to determine SMTP server to use: set FND_SMTP_HOST

Problem:
Unable to determine SMTP server to use: set FND_SMTP_HOST

Symptoms:
– report ends with Warning
-the report log file shows ==> 1) PUBLISH ————-+ Emailing output to xx@xxx.xxx
– with consulting OPP log file shows ==> [UNEXPECTED] [51410:RT648550] oracle.apps.fnd.cp.opp.PostProcessorException: Unable to determine SMTP server to use: set FND_SMTP_HOST

Solution:
Change the profile option :
FND: SMTP Host –-> Give your smtp server name or IP
FND: SMTP Port –-> give your smtp server port (By default – 25).

 
1 Comment

Posted by on September 3, 2014 in Action_Plan, apps_dba, E-Business Suite

 

Tags: , , , ,

XML Report Publisher Fails With java.lang.OutOfMemoryError

Problem:
XML publisher completing in Warning when data size is big. One or more post processing actions failed java.lang.OutOfMemoryError

Symptoms:
– report ends with Warning
– with consulting OPP log file shows ==> Caused by: java.lang.OutOfMemoryError: Java heap space

Solution:
1. First test how much memory you can create in OS using the following command
$java -mx2700m -version

2. Determine what the heap size per OPP process is currently:
select DEVELOPER_PARAMETERS from FND_CP_SERVICES
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = ‘FNDCPOPP’);

3. Increase the Heap Space per Process to 1024 or to maximum result of OS command:
update FND_CP_SERVICES
set DEVELOPER_PARAMETERS =’J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m’
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = ‘FNDCPOPP’);
commit;

4. Increase the values for these profiles for at least 2 hours each (7200):
Concurrent:OPP Process Timeout
Concurrent:OPP Response Timeout

5. Restart the concurrent managers
 

Tags: , , , , , , ,

Gaps Resolving in DataGuard Physical Standby Using RMAN Incremental Backup

1) defer log transfer from Primary Database
SQL>alter system set log_archive_dest_state_2=’DEFER’ scope=MEMORY;

2) record last sequence from Primary and Standby
SQL> archive log list;
or use sql:
SQL> SELECT ARCH.THREAD# “Thread”, ARCH.SEQUENCE# “Last Sequence Received”, APPL.SEQUENCE# “Last Sequence Applied”, (ARCH.SEQUENCE# – APPL.SEQUENCE#) “Difference” FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#))ARCH, (SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1;

3) record last SCN
SQL> select to_char(current_scn) from v$database;
e.g.:
Primary==> 5973814619607
Standby==> 5973624753925

you can also know when the gap happens by:
SQL>select scn_to_timestamp(5973624753925) from dual;

4) stop log apply on Standby
SQL>alter database recover managed standby database cancel;

5)Perform Rman Incremental backup from Primary database to backup the gap starting from Standby SCN
RMAN>run {
allocate channel c1 type disk format ‘/tmp/gapresolve/%U.rmb’;
backup incremental from scn 5973624753925 database;
}

6) Take a buckup from the current Primary Control file
SQL>alter database create standby controlfile as ‘/tmp/gapresolve_standby.ctl’;
7) transfer the backup spices and control file to Standby machine
$scp file user@machine:/directory
$scp /tmp/gapresolve/*.rmb oracle@sdbypc:/tmp/gapresolve/

8)start Standby db
SQL>startup nomount

9) allocate Standby database control file
SQL>show parameter control_files
==> /oracle_home/dbs/stdbycontrol.dbf

10)replace it with Primary backed up control file
$cp /tmp/gapresolve_standby.ctl /oracle_home/dbs/stdbycontrol.dbf
10) mount Standy database in standby state
SQL>alter database mount standby database;

11)start rman on standby
$rman target=/

12)catalog backup spices
RMAN>catalog start with ‘/tmp/gapresolve’;

13) recover the database
RMAN>recover database;

14) in some new created datafile need to be restored first, so a error massage came:
RMAN-03002: failure of recover command at 08/23/2014 12:41:19
RMAN-06094: datafile 61 must be restored
so just restore that file by:
RMAN>restore datafile 61;

15) rman recovery ends with and error that requesting current log file, we can ignore this error

16) on Standby database, check the current SCN
SQL> select to_char(current_scn) from v$database;

17) on Standby database, resume log apply
SQL> alter database recover managed standby database disconnect from session;

18) on Primary, resume log transfer
alter system set log_archive_dest_state_2=’ENABLE’ scope=MEMORY;

19)frequently check the scn
SQL> select to_char(current_scn) from v$database;

 
 

Tags: , , , , ,

R12 Concurrent Manager Error: “System Hold, Fix Manager before resetting counters”

some of the concurrent managers are not coming up and  showing the following error:

The actual value of the manager is 0.

ERROR
“System Hold, Fix Manager before resetting counters”.  

Solution:

1. Stop all middle tier services including the concurrent managers.
Please make sure that no FNDLIBR, FNDSM, or any process is running by ps -ef | grep  FNDLIBR

2. Stop the database.

3. Start the database.

4. Go to cd $FND_TOP/bin
$ adrelink.sh force=y link_debug=y fnd FNDLIBR
$ adrelink.sh force=y link_debug=y fnd FNDFS
$ adrelink.sh force=y link_debug=y fnd FNDCRM
$ adrelink.sh force=y link_debug=y “fnd FNDSM

5. Run the CMCLEAN.SQL script from the referenced note below (don’t forget to commit).

 
Leave a comment

Posted by on June 23, 2014 in administration, apps_dba

 

Tags: , ,