RSS

Category Archives: administration

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: ,

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: , ,

R12 after clone Error -FRM-92101 – on OEL5.7

after cloning R12 instance on OEL 5.7 64bit to TEST instance and when I started services normally, an error apprears when access the forms, getting the following error

FRM-92101: There was a failure in the Forms Server during startup. This could happen due to invalid configuration. Please look into the web-server log file for details

 
Java Exception
oracle.forms.net.ConnectionException:Forms sessionfailed during startup:no response from runtime process
at oracle.forms.net.ConnectionException.createConnectionException(Unknown Source)
at oracle.forms.net.HTTPNStream.getResponse(Unknown source)
at oracle.forms.net.HTTPNStream.doFlush(Unknown Source)
at oracle.forms.net.HTTPNStream.flush(Unknown Source)
at java.io.DataOutputStream.flush(Unknown source)
…………………………………………………………..

I have looked into the forms server log file which is given below

$LOG_HOME/ora/10.1.3/opmn/forms_default_group_1/formsstd.out

and found the following error

FormsServlet init():
configFileName: /u01/DEV/inst/apps/DEV_mkhots06/ora/10.1.2/forms/server/appsweb.cfg
testMode: false
Oracle Containers for J2EE 10g (10.1.3.4.0) initialized
ListenerServlet init()
Forms session <1> aborted: runtime process failed during startup with errors <ORACLE_HOME>/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

Forms session <2> aborted: runtime process failed during startup with errors <ORACLE_HOME>/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

Forms session <3> aborted: runtime process failed during startup with errors <ORACLE_HOME>/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

Cause:

The Actual cause of this error for my test instance is that openmotif package not installed along with pre-requisites for R12 in TEST instance server.

rpm -Uhv binutils-2.17.50.0.6-6.0.1.el5.x86_64.rpm
rpm -Uhv xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm
rpm -Uhv openmotif21-2.1.30-11.EL5.i386.rpm

then after that i hav relinked the frmweb executable of forms server after shutting the apps services by giving the following commands

$cd $ADMIN_SCRIPTS_HOME

$adstpall.sh apps/

Then

$cd $ORACLE_HOME/forms/lib

$make -f ins_forms.mk install

Then restarted the services using adstrtal.sh apps/

Now there is no issue of form errors and was able to access the forms from my TEST instance.

 

Tags: , ,

R12 disable all users script

regulatory after clone, you asked to close “disable/ end date/ deactivate” application “end” users

use the following script

declare cursor x is
select user_name from apps.fnd_user where LOWER(user_name) Not IN ('list some users you don't want to close');
begin
for all_user in x loop
apps.fnd_user_pkg.DisableUser(all_user.user_name);
commit;
end loop;
End;
 

Tags: ,