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.
Adding/removing report server in 10g Application Server
To delete the Report server you have to follow some steps:
1. Stop opmn processes.
2. Stop EM console
3. Take a backup of opmn.xml
4. Open opmn.xml. There must be an entry related to your reports server.
Carefully delete that whole tag.
5. Then do "opmnctl validate" to validate your opmn.xml.
6. Take a backup of targets.xml.
7. Open targets.xml.. There must be a entry for your reports server in that.
Delete that whole tag from there.
8. Start opmn processes.
9. Start EM Console.
To add new reports server:
1. Adding a new report server with the name my_report_server
$ rwserver.sh server=my_report_server batch=yes
2. Register with OEM and OPMN
$ addNewServerTarget my_report_server
3. Open configuration file created in the name of new report server
$ vi $ORACLE_HOME/reports/conf/my_report_server.conf
4. Change SourceDir and tempDir values to the actual one.
5. Start newly added report server process.
1. Stop opmn processes.
2. Stop EM console
3. Take a backup of opmn.xml
4. Open opmn.xml. There must be an entry related to your reports server.
Carefully delete that whole tag.
5. Then do "opmnctl validate" to validate your opmn.xml.
6. Take a backup of targets.xml.
7. Open targets.xml.. There must be a entry for your reports server in that.
Delete that whole tag from there.
8. Start opmn processes.
9. Start EM Console.
To add new reports server:
1. Adding a new report server with the name my_report_server
$ rwserver.sh server=my_report_server batch=yes
2. Register with OEM and OPMN
$ addNewServerTarget my_report_server
3. Open configuration file created in the name of new report server
$ vi $ORACLE_HOME/reports/conf/my_report_server.conf
4. Change SourceDir and tempDir values to the actual one.
5. Start newly added report server process.
adapcctl.sh: exiting with status 204
On a new VIS R12.1 installation, the OHS (oracle http server) failed to start and give status 204.
Upon querying the status of opmn managed processes with adopmnctl.sh, the following status is shown:
Processes in Instance:
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm | 9713 | Alive
OC4JGroup:default_group | OC4J:forms | 9648 | Alive
OC4JGroup:default_group | OC4J:oacore | 9570 | Alive
HTTP_Server | HTTP_Server | N/A | Down
On driilling through the http server logfile on $INST_TOP/logs/ora/10.1.3/opmn/HTTP_Server~1.log
found some error like this:
10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open sh
ared object file: No such file or directory
I thought this could be due to some link files, not properly linked on /usr/lib or /lib folders.
I searched for link file libdb.so.2 on /usr/lib and /lib folders. But nothing found.
So, I went on creating a link file " libdb.so.2" on both the folders.
Now, I restarted the OHS.
This time it gave the same 204 status. Http log shows,
Cannot load $IAS_ORACLE_HOME/Apache/Apache/libexec/mod_ossl.so into server: $IAS_ORACLE_HOME/Apache/Apache/libexec/mod_ossl.so: undefined symbol: dbm_firstkey
Now, the situation got really worse. I googled a lot, but found nothing related.
Finally, I checked for the pre-requisite rpm one-by-one. I referred Metalink doc:607883 once again.
There I got the fix.
I missed to apply patch 607883. It was clearly mentioned on this doc, that this patch would fix an issue with the Oracle HTTP Server (missing libdb.so.2)
Applied the patch and this time OHS started fine.
Upon querying the status of opmn managed processes with adopmnctl.sh, the following status is shown:
Processes in Instance:
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm | 9713 | Alive
OC4JGroup:default_group | OC4J:forms | 9648 | Alive
OC4JGroup:default_group | OC4J:oacore | 9570 | Alive
HTTP_Server | HTTP_Server | N/A | Down
On driilling through the http server logfile on $INST_TOP/logs/ora/10.1.3/opmn/HTTP_Server~1.log
found some error like this:
10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open sh
ared object file: No such file or directory
I thought this could be due to some link files, not properly linked on /usr/lib or /lib folders.
I searched for link file libdb.so.2 on /usr/lib and /lib folders. But nothing found.
So, I went on creating a link file " libdb.so.2" on both the folders.
Now, I restarted the OHS.
This time it gave the same 204 status. Http log shows,
Cannot load $IAS_ORACLE_HOME/Apache/Apache/libexec/mod_ossl.so into server: $IAS_ORACLE_HOME/Apache/Apache/libexec/mod_ossl.so: undefined symbol: dbm_firstkey
Now, the situation got really worse. I googled a lot, but found nothing related.
Finally, I checked for the pre-requisite rpm one-by-one. I referred Metalink doc:607883 once again.
There I got the fix.
I missed to apply patch 607883. It was clearly mentioned on this doc, that this patch would fix an issue with the Oracle HTTP Server (missing libdb.so.2)
Applied the patch and this time OHS started fine.
Disabling Single Sign-On on Report Server
While accessing a 10g Application Server report, the user need to log-in through Single Sign-on process.
Though this is an additional security feature, someone may feel this annoying.
In this Post, I'll explain, how to avoid single sign-on process while accessing 10g AS reports.
Step 1: Disable Single Sign-on:
Uncomment the
Note: The
Step 2: Disable Reports Server Security:
Though, the single sign-on is disabled, we need to sign-on at "reports server security" process, in order to access the reports.
To disable this, the security element in the Reports Server configuration file, ($
Commenting out the above security element will disable the Reports server security process.
Step 3: Restart the report server opmn process.
That's all...
You won't get any annoying screen, asking for username and passwords.
But remember, you are reducing an additional security feature.
Though this is an additional security feature, someone may feel this annoying.
In this Post, I'll explain, how to avoid single sign-on process while accessing 10g AS reports.
Step 1: Disable Single Sign-on:
Uncomment the
SINGLESIGNON parameter in the Reports Servlet configuration file (rwservlet.properties) and set it to "NO". This file is located in $ORACLE_HOME/reports/conf directory.Note: The
SINGLESIGNON value is usually commented out after installation, but the default value is YES.Step 2: Disable Reports Server Security:
Though, the single sign-on is disabled, we need to sign-on at "reports server security" process, in order to access the reports.
To disable this, the security element in the Reports Server configuration file, ($
ORACLE_HOME/reports/conf/servername.conf) must be commented out.
The default value would be like this:"security id="rwSec" class="oracle.reports.server.RWSecurity>"
"!--property name="securityUserid" value="portal_id/portal_password@portal_schema"
confidential="yes" encrypted="no"-->"
"property name="oidEntity" value="%REPORTS_OID_ENTITY%" confidential="yes"
encrypted="no"/>"
"/security>"
Commenting out the above security element will disable the Reports server security process.
Step 3: Restart the report server opmn process.
That's all...
You won't get any annoying screen, asking for username and passwords.
But remember, you are reducing an additional security feature.
server down in the middle of hot-backup.
Today Morning, I had a very touch time with my DB.
I thought of taking hot-backup, because, number of users accessing the db will be less on morning.
I've started the hot backup.
It was going well, until the system tablespace's turn.
When the system tb is offline for hot backup, the server went down, without any hint.
Later I got to know there was a problem in UPS.
Within few minutes, the server started again. Now, my tough-time started.
Upon starting the db, I got "ORA-10873".
I've mounted the db, and checked v$backup, v$datafile views for datafile's status.
The system tablespace and it's datafiles were offline.
I issued "alter database datafile '' online" for all the system*.dbf files. The sql went fine.
But still, status for system datafiles were showing "active" in v$backup view.
Tension mounting as I got calls from client-side about the db.
any guess....?
Referred "http://www.oracleabc.com/oracledocs/11gErrors/ORA-10873.htm"
I re-issued "alter database datafile '' end backup".
Now v$backup shows 'Not Active'. Really sucks.
why my previous sql failed to bring back the dbf from offline ?
I thought of taking hot-backup, because, number of users accessing the db will be less on morning.
I've started the hot backup.
It was going well, until the system tablespace's turn.
When the system tb is offline for hot backup, the server went down, without any hint.
Later I got to know there was a problem in UPS.
Within few minutes, the server started again. Now, my tough-time started.
Upon starting the db, I got "ORA-10873".
I've mounted the db, and checked v$backup, v$datafile views for datafile's status.
The system tablespace and it's datafiles were offline.
I issued "alter database datafile '
But still, status for system datafiles were showing "active" in v$backup view.
Tension mounting as I got calls from client-side about the db.
any guess....?
Referred "http://www.oracleabc.com/oracledocs/11gErrors/ORA-10873.htm"
I re-issued "alter database datafile '
Now v$backup shows 'Not Active'. Really sucks.
why my previous sql failed to bring back the dbf from offline ?
Change orcladmin password using OIDADMIN
1.Login to the Oracle Directory Manager
2.Unix: cd $ORACLE_HOME/bin (Should be the INFRA_HOME/bin directory)
./oidadmin
3.Windows: Use the 10g client to connect to the ODM by giving the appropriate hostname and Port no
4.Once after loggin to the ODM
*.Click Entry Management
*.Click dc=com( or ***As per your configuration)
*.Click the next subtree dc=***(As per your configuration)
*,Click cn=Users
*.Click cn=orcladmin (under the cn=Users)
Select the properties for the orcladmin user and change the userpassword column in the properties to your new password .
5.Save your changes.
6.Cycle the OID and OC4JSECURITY in your infrastructure for the new changes to take effect.
This should work.
2.Unix: cd $ORACLE_HOME/bin (Should be the INFRA_HOME/bin directory)
./oidadmin
3.Windows: Use the 10g client to connect to the ODM by giving the appropriate hostname and Port no
4.Once after loggin to the ODM
*.Click Entry Management
*.Click dc=com( or ***As per your configuration)
*.Click the next subtree dc=***(As per your configuration)
*,Click cn=Users
*.Click cn=orcladmin (under the cn=Users)
Select the properties for the orcladmin user and change the userpassword column in the properties to your new password .
5.Save your changes.
6.Cycle the OID and OC4JSECURITY in your infrastructure for the new changes to take effect.
This should work.
Creating samba share quickly
This is for those who are frustrated with creating smb share on linux-2-windows.
open /etc/samba/smb.conf file on vi editor.
put the following entry at the end of file.
[your-folder-name-to-be-shared]
path =
public = yes
writeable = yes (no, for read-only access)
That's all.
restart smbd service.
Now you can access the folders.
open /etc/samba/smb.conf file on vi editor.
put the following entry at the end of file.
[your-folder-name-to-be-shared]
path =
public = yes
writeable = yes (no, for read-only access)
That's all.
restart smbd service.
Now you can access the folders.
Subscribe to:
Posts (Atom)