1. Log-in to EBS with system administrator responsibility and click on Dashboard.
2. On the Lower-Right corner you may find a link to OAM version. Click on that.
3. Here comes the OAM version.
Find OAM verion (R12.1)
To find the version of OAM
1. Log-in to EBS with system administrator responsibility and click on Dashboard.
2. On the Lower-Right corner you may find a link to OAM version. Click on that.
3. Here comes the OAM version.
1. Log-in to EBS with system administrator responsibility and click on Dashboard.
2. On the Lower-Right corner you may find a link to OAM version. Click on that.
3. Here comes the OAM version.
FND_STATS don't consider temp tables
Yesterday, I had to run FND_STATS.gather_schema_stats for XX schema, manually. Because, it was not registered with Oracle Apps.
Upon querying the last_analyzed column of dba_tables, I found some of the tables from XX schema are not analyzed and they are temporary tables (temporary column=Y).
Finding:
FND_STATS don't analyze temp tables.
Upon querying the last_analyzed column of dba_tables, I found some of the tables from XX schema are not analyzed and they are temporary tables (temporary column=Y).
Finding:
FND_STATS don't analyze temp tables.
strange phenomenon of rman
While executing an RMAN script from catalog database, rman shows file system error and doesn't store backups to the file location specified in the script.
I used two separate machines for doing this rman exercise. One m/c is configured to run catalog database and the other one is my target database.
The file location specified in the backup script is in catalog db machine, and the script is executed from catalog db. But, rman always looks for the same location on the target db machine.
Anyone has any clue about this ?
I used two separate machines for doing this rman exercise. One m/c is configured to run catalog database and the other one is my target database.
The file location specified in the backup script is in catalog db machine, and the script is executed from catalog db. But, rman always looks for the same location on the target db machine.
Anyone has any clue about this ?
opmn component failed to start (AS 10.1.3.x)
Recently I had a problem on starting Middle Tier processes of Oracle AS 10.1.3.x.
$ opmnctl startproc ias-component=OC4J:oc4j_soa
opmnctl: starting opmn managed processes...
================================================================================
opmn id=prima.abits.com:6201
No processes or applications match the specified configuration.
opmn.log shows....
10/05/17 11:00:10 [pm-process] Starting Process: default_group~oc4j_soa~default_group~1 (376439197:0)
10/05/17 11:00:57 [libopmnoc4j] Host and Port information for port type jms not sent by the OC4J process
10/05/17 11:00:57 [libopmnoc4j] WARNING: OC4J did not send the protocol value for port id: jms
10/05/17 11:00:57 [libopmnoc4j] Port information in the ONS notification is incorrect for proc: 376439197. Some of the reason
s for the failure are:
1. ajp, rmi and jms ports could not be bound by the process.
2. If a port value for a certain port ID is handed by OPMN to the OC4J process and this value is not returned back in the ON
S notifications. For example, this can happen for certain bad JGroups related configurations.
10/05/17 11:00:57 [libopmnoc4j] Process Start Error: default_group~oc4j_soa~default_group~1 (376439197:7849)
10/05/17 11:00:58 [pm-process] Stopping Process: default_group~oc4j_soa~default_group~1 (376439197:7849)
10/05/17 11:00:58 [libopmnoc4j] Process Stop Error: default_group~oc4j_soa~default_group~1 (376439197:7849)
10/05/17 11:00:58 [libopmnoc4j] Failed to construct stop command for proc: 376439197
10/05/17 11:00:58 [libopmnoc4j] Forcefully Terminating Process: default_group~oc4j_soa~default_group~1 (376439197:7849)
Haven't got any clue with this log, I searched on OTN.
Mr. Sameer.h has posted a nice message on this problem at this URL: http://forums.oracle.com/forums/thread.jspa?threadID=619852
This solved my prob.
The solution is:
Stop opmnctl processes
delete jms.state file under $OH/j2ee\home\persistence\home_default_group_1/
start opmnctl processes again.
It worked like a charm.
$ opmnctl startproc ias-component=OC4J:oc4j_soa
opmnctl: starting opmn managed processes...
================================================================================
opmn id=prima.abits.com:6201
No processes or applications match the specified configuration.
opmn.log shows....
10/05/17 11:00:10 [pm-process] Starting Process: default_group~oc4j_soa~default_group~1 (376439197:0)
10/05/17 11:00:57 [libopmnoc4j] Host and Port information for port type jms not sent by the OC4J process
10/05/17 11:00:57 [libopmnoc4j] WARNING: OC4J did not send the protocol value for port id: jms
10/05/17 11:00:57 [libopmnoc4j] Port information in the ONS notification is incorrect for proc: 376439197. Some of the reason
s for the failure are:
1. ajp, rmi and jms ports could not be bound by the process.
2. If a port value for a certain port ID is handed by OPMN to the OC4J process and this value is not returned back in the ON
S notifications. For example, this can happen for certain bad JGroups related configurations.
10/05/17 11:00:57 [libopmnoc4j] Process Start Error: default_group~oc4j_soa~default_group~1 (376439197:7849)
10/05/17 11:00:58 [pm-process] Stopping Process: default_group~oc4j_soa~default_group~1 (376439197:7849)
10/05/17 11:00:58 [libopmnoc4j] Process Stop Error: default_group~oc4j_soa~default_group~1 (376439197:7849)
10/05/17 11:00:58 [libopmnoc4j] Failed to construct stop command for proc: 376439197
10/05/17 11:00:58 [libopmnoc4j] Forcefully Terminating Process: default_group~oc4j_soa~default_group~1 (376439197:7849)
Haven't got any clue with this log, I searched on OTN.
Mr. Sameer.h has posted a nice message on this problem at this URL: http://forums.oracle.com/forums/thread.jspa?threadID=619852
This solved my prob.
The solution is:
Stop opmnctl processes
delete jms.state file under $OH/j2ee\home\persistence\home_default_group_1/
start opmnctl processes again.
It worked like a charm.
Subscribe to:
Posts (Atom)