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.
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.
database was slow, due to undo retention
Yesteday, I had a call from client, saying db was very slow.
Thu Feb 25 14:50:31 2010
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.1.0.7.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
Time: 25-FEB-2010 14:50:31
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=202.157.69.223)(PORT=62300))
ORA-01555 caused by SQL statement
Are you observing any errors for undo tablespace or are you just concerned with the growth of the undo tablespace. Please note that unless you get ora-1555 or ora -30036 you need not increase the undo tablespace.
Run this query when undo tablespace is full
SELECT DISTINCT STATUS, SUM(BYTES), COUNT(*)
FROM DBA_UNDO_EXTENTS GROUP BY STATUS;
ACTIVE - Undo Extent is Active, Used by a transaction.
EXPIRED - Undo Extent is expired (Exceeded the Undo Retention).
UNEXPIRED - Undo Extent will be required to honour UNDO_RETENTION.
in case you see lot of expired extents, then no need to increase undo tablespace as the extents will be reused.
Thu Feb 25 14:50:31 2010
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.1.0.7.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
Time: 25-FEB-2010 14:50:31
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=202.157.69.223)(PORT=62300))
ORA-01555 caused by SQL statement
Are you observing any errors for undo tablespace or are you just concerned with the growth of the undo tablespace. Please note that unless you get ora-1555 or ora -30036 you need not increase the undo tablespace.
Run this query when undo tablespace is full
SELECT DISTINCT STATUS, SUM(BYTES), COUNT(*)
FROM DBA_UNDO_EXTENTS GROUP BY STATUS;
ACTIVE - Undo Extent is Active, Used by a transaction.
EXPIRED - Undo Extent is expired (Exceeded the Undo Retention).
UNEXPIRED - Undo Extent will be required to honour UNDO_RETENTION.
in case you see lot of expired extents, then no need to increase undo tablespace as the extents will be reused.
Inactive no manager after cloning....
We got an INACTIVE NO MANAGER after cloning an 11i with ATG.RUP.5.
The concurrent manager log, appeared with the following error:
Could not initialize the Service Manager FNDSM_[SERVER_NAME]_[ENV_NAME]. Verify that [SERVER_NAME] has been registered for concurrent processing. Routine AFPEIM encountered an error while starting concurrent manager.
We got a solution, while browsing through the net.
The concurrent manager log, appeared with the following error:
Could not initialize the Service Manager FNDSM_[SERVER_NAME]_[ENV_NAME]. Verify that [SERVER_NAME] has been registered for concurrent processing. Routine AFPEIM encountered an error while starting concurrent manager.
We got a solution, while browsing through the net.
Reset orcladmin password
Changing/Resetting passwords for orcladmin,ias_admin super users.
Note: orcladmin and ias_admin users share the same password, initially.
1. If you remember ias_admin password and want to change it.
$oidpasswd connect= reset_su_password=true
OID DB user password:
new password:
confirm password:
password set
OID DB user password:
new password:
confirm password:
password set
2. If you know ias_admin password then one more method to reset:
$ORACLE_HOME/bin/resetiASpasswd.sh cn=orcladmin $ORACLE_HOME
3. If you really forgot both ias_admin and orcladmin passwords, then
refer Documet Id: 472752.1
4. Finally, if you forgot both ias_admin and orcladmin passwords, there's one more method to reset them.
Login sqlplus as dba.
Enter the following "execute orasso.WWSSO_OID_INTEGRATION.reset_passwd('orcladmin',null,'new password');"
That's all. You can reset ias_admin password after this.
Subscribe to:
Posts (Atom)