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.
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.
Change ias_admin password in 10g Application Server
If you have forgotten and want to change the ias_admin password,
then try this:
http://forums.oracle.com/forums/thread.jspa?threadID=181272
then try this:
http://forums.oracle.com/forums/thread.jspa?threadID=181272
FRM-92102 Network error on forms client in AS10g
Recently, I got a complaint from my AS10g users, that they are facing frequent disconnection with the server. May be due to network distruption.
The error stack was:
FRM-92102: A network error has occurred.The Forms Client has attempted to reestablish its connection to the Server 5 time(s) without success.Please check the network connection and try again later.Details...Java Exception:oracle.forms.net.ConnectionException:500at 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)at oracle.forms.net.StreamMessageWriter.run(Unknown Source)
I got an usefull hint on forums.oracle.com for the same problem.
It suggested to change the ping timeout to a higher value.
I had to do the following changes to opmn.xml under $ORACLE_HOME/opmn/conf
Find the process-type tag with id="OC4J_BI_FORMS" module-id="OC4J". Under this process-type tag, go to the category tag with the id="urlping-parameters". Replace the line
data id="/reports/rwservlet/pingserver?start=auto" value="200"
with
data id="/forms90/l90servlet" value="200"
Then, under the line
add:
ping timeout="300" interval="20
After doing the changes, restart the opmn.
I got this hint in
http://forums.oracle.com/forums/thread.jspa?threadID=323306&start=15&tstart=0
But, they have provided this solution for forms 9i. We have to change a few parameters according to AS10g environment.
Post your suggestions/feedback.
Determine ports used by opmn process
To determine the port values used by opmn processes, use this command:
prompt> opmnctl status -l
This also list the uid of the processes, which used to enables you to stop or restart an individual Oracle Application Server process.
Example:
prompt> opmnctl stopproc uniqueid= uid-of-particular-process
For more info:
http://download.oracle.com/docs/cd/B14099_19/core.1012/b13996/intro.htm#i1026303
prompt> opmnctl status -l
This also list the uid of the processes, which used to enables you to stop or restart an individual Oracle Application Server process.
Example:
prompt> opmnctl stopproc uniqueid=
For more info:
http://download.oracle.com/docs/cd/B14099_19/core.1012/b13996/intro.htm#i1026303
Report Server issue in 10gAS
We were running 10gAS on test server initially and it needs to be migrated from test server to apps server. It (test) was configured with report server "rep_hostname".
Apps server already been installed with AS (same version), but it was running with different report server (rep_apps_oraclehome1).
We overwrote all the fmx,fmb and rdf in apps, with the same from test. But the report server was not running. No report is popping up.
Tried to start "sh rwserer.sh server=rep_hostname" , but that made no sense. Error "frm-41213- unable to connect to report server rep_hostname"
Then tried, this url.
http://vidyabala.blogspot.com/2006/10/configuring-oracle-10g-reports-in.html
added rep_hostname to opmn service. This new service was started up fine. But the report was not popping up. Error frm-41214- unable to run report.
I went to check the report job status on "http://sever-name:7778/reports/rwservlet?servername=rep_hostname". All jobs were in status unable to run.
Clicked on one un-run report and it shown " Terminated with error:
REP-271468672: Unable to create a temporary file." .
That's the hint!!!!
The temp folder location mentioned in $ORACLE_HOME/reports/conf/rep_hostname.conf file's "tempDir" value, was not actually exists.
Then I created a temp folder on that location with proper permissions.
That's the fix. The reports are now running fine.
Apps server already been installed with AS (same version), but it was running with different report server (rep_apps_oraclehome1).
We overwrote all the fmx,fmb and rdf in apps, with the same from test. But the report server was not running. No report is popping up.
Tried to start "sh rwserer.sh server=rep_hostname" , but that made no sense. Error "frm-41213- unable to connect to report server rep_hostname"
Then tried, this url.
http://vidyabala.blogspot.com/2006/10/configuring-oracle-10g-reports-in.html
added rep_hostname to opmn service. This new service was started up fine. But the report was not popping up. Error frm-41214- unable to run report.
I went to check the report job status on "http://sever-name:7778/reports/rwservlet?servername=rep_hostname". All jobs were in status unable to run.
Clicked on one un-run report and it shown " Terminated with error:
REP-271468672: Unable to create a temporary file." .
That's the hint!!!!
The temp folder location mentioned in $ORACLE_HOME/reports/conf/rep_hostname.conf file's "tempDir" value, was not actually exists.
Then I created a temp folder on that location with proper permissions.
That's the fix. The reports are now running fine.
/etc/fstab entry for nfs mount for expdp directory
The following entry with arguments must be there in /etc/fstab for perfect expdp to a remote nfs location.
test:/d01/oracle/Infra/10.1.2/expdp_dump /home/oracle/expdp_share nfs rsize=32768,wsize=32768,hard,noac 0 0
test:/d01/oracle/Infra/10.1.2/expdp_dump /home/oracle/expdp_share nfs rsize=32768,wsize=32768,hard,noac 0 0
start / stop scripts for Oracle Application Server 10g
User comments are welcome
++++++++++++++++++++++++++++++++++++++++++++++
There are two oracle homes in an AS 10g(basic setup).
Infrastructure (short: INFRA) and Middle Tier (short: MidTier)
Start Infrastructure Metadata services first
Set the following env variables on infra user profile:
export ORACLE_SID=$ORACLE_HOME/bin/emctl startifdown iasconsole
export ORACLE_HOME=
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/opmn/bin
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=$PATH:$ORACLE_HOME/dcm/bin
Start script for Infra Services
# Starting Listener
$ORACLE_HOME/bin/lsnrctl start
# Starting up database
sqlplus / as sysdba
startup
### Starting Oracle EM for Db Control (optional)
$ORACLE_HOME/bin/emctl start dbconsole
## Starting Oracle EM for IAS Control (optional)
$opmnctl start
# You may start all the services on a single command
# opmnctl startall (or)
# You can start required services one by one
$opmnctl startproc ias-component=OID
$opmnctl startproc ias-component=HTTP_Server
$opmnctl startproc process-type=OC4J_SECURITY
Stop script for Infra Services
### Stop OPMN services first ####
# you may use "opmnctl stopall" to stop all the services
# in a single command.
$opmnctl stopproc process-type=OC4J_SECURITY
$opmnctl stopproc ias-component=HTTP_Server
$opmnctl stopproc ias-component=OID
$opmnctl shutdown
#Stopping dbconsole & iasconsole services
$ORACLE_HOME/bin/emctl stop iasconsole
$ORACLE_HOME/bin/emctl stop dbconsole
#Stopping db
sqlplus / as sysdba
shutdown immediate
#Stopping Listener
$ORACLE_HOME/bin/lsnrctl stopStart Middle Tier services Next
Set env variables on middle tier user profile
export ORACLE_SID=Start script for Middle Tier Services
export ORACLE_HOME=
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export FORMS_PATH=$ORACLE_HOME/forms
export ORA_PATH=$ORACLE_HOME/bin:$ORACLE_HOME/opmn/bin
export ORA_PATH=$ORA_PATH:$ORACLE_HOME/dcm/bin
export ORA_PATH=$ORA_PATH:$ORACLE_HOME/perl/bin
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PERL5LIB=$ORACLE_HOME/perl/lib/5.6.1
export PATH=$ORA_PATH:$PATH
$emctl startifdown iasconsole
# You may start all the services on a single command
# opmnctl startall (or)
# You can start required services one by one
$opmnctl start
$opmnctl startproc ias-component=HTTP_Server
$opmnctl startproc process-type=OC4J_Portal
$opmnctl startproc process-type=home
$opmnctl startproc process-type=OC4J_BI_Forms
$opmnctl startproc process-type=OC4J_Wireless
$opmnctl startproc ias-component=WebCache
$opmnctl startproc ias-component=Discoverer
Stop script for Middle Tier Services
# You may stop all the services on a single command
# opmnctl stopall (or)
# You can stop required services one by one
## Stop Discoverer
$opmnctl stopproc ias-component=Discoverer
$opmnctl stopproc ias-component=WebCache
$opmnctl stopproc process-type=OC4J_BI_Forms
$opmnctl stopproc process-type=OC4J_Wireless
$opmnctl stopproc process-type=home
$opmnctl stopproc process-type=OC4J_Portal
$opmnctl stopproc ias-component=HTTP_Server
$emctl stop iasconsole
$opmnctl shutdown
User comments are welcome
Usefull Linux Commands
Here are bunch of usefull linux commands.
i) Remove files by last updated date.
This will remove the files older than the "ctime" arg, in the current directory.
(note this is an interview question)
( Will be updated soon with more ...)
i) Remove files by last updated date.
This will remove the files older than the "ctime" arg, in the current directory.
(note this is an interview question)
find-ctime +17 -daystart -exec rm "{}" \;
Command to Delete files created on a particular day:
---------------------------------------------------------------
# touch -t 1104160000 /tmp/begin # touch -t 1104172359 /tmp/end # cd <- folder where your files are -> # find . -xdev -type f -newer /tmp/begin -a ! -newer /tmp/end | xargs rm
Find number of open files in system ------------------------------ lsof | perl -lane '$x{"$F[0]:$F[1]"}++;END { print "$x{$_}\t$_" for sort {$x{$a}<=>$x{$b}} keys %x}'
( Will be updated soon with more ...)
OS Version issue: while installing AS10g in Enterprise linux.
AS10g can't be installed on Oracle provided Enterprise Linux (October Update 4).
Though the Enterprise linux is very much similar to RedHat Linux, the AS10g will not allow you to install it on Oracle provided Enterprise linux.
How to by-pass ?
Make a copy of /etc/issue and /etc/redhat-release files.
Open oraparm.ini file inside as10g-cd1/install directory.
copy any one of the linux versions listed under "[Certified Versions]" tag.
Update the entries inside /etc/issue and /etc/redhat-release with the linux versions you copied from oraparam.ini file.
Example:
Original Entry in /etc/issue file:
Enterprise Linux Enterprise Linux AS release 4 (October Update 4)
Updated Entry:
redhat-Red Hat Enterprise Linux AS release 4
Now continue the installation.
This can be done for any issue that shows version problem.
Though the Enterprise linux is very much similar to RedHat Linux, the AS10g will not allow you to install it on Oracle provided Enterprise linux.
How to by-pass ?
Make a copy of /etc/issue and /etc/redhat-release files.
Open oraparm.ini file inside as10g-cd1/install directory.
copy any one of the linux versions listed under "[Certified Versions]" tag.
Update the entries inside /etc/issue and /etc/redhat-release with the linux versions you copied from oraparam.ini file.
Example:
Original Entry in /etc/issue file:
Enterprise Linux Enterprise Linux AS release 4 (October Update 4)
Updated Entry:
redhat-Red Hat Enterprise Linux AS release 4
Now continue the installation.
This can be done for any issue that shows version problem.
TNS-12555 while installing Apps using rapidwiz
This problem popped up when I was installing Oracle EBS 11i on an linux server.
Error Msg:
LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 06-OCT-2008 13:10:08
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /d01/oracle/proddb/9.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.6.0 - Production
System parameter file is /d01/oracle/proddb/9.2.0/network/admin/PROD_linuxerp/listener.ora
Log messages written to /d01/oracle/proddb/9.2.0/network/admin/prod.log
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPROD))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted
Symptom:
While installing EBS using rapidwiz ora-12555 popped up at the end of 20% saying "failed to run external process".
Cause:
file permission under "/var/tmp/.oracle" is not proper.
Solution:
Metalink Note: 472386.1
Change file permission to oracle.dba under /var/tmp/.oracle and retry.
Error Msg:
LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 06-OCT-2008 13:10:08
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /d01/oracle/proddb/9.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.6.0 - Production
System parameter file is /d01/oracle/proddb/9.2.0/network/admin/PROD_linuxerp/listener.ora
Log messages written to /d01/oracle/proddb/9.2.0/network/admin/prod.log
Error listening on: (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPROD))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted
Symptom:
While installing EBS using rapidwiz ora-12555 popped up at the end of 20% saying "failed to run external process".
Cause:
file permission under "/var/tmp/.oracle" is not proper.
Solution:
Metalink Note: 472386.1
Change file permission to oracle.dba under /var/tmp/.oracle and retry.
INSTE8 error while post-cloning appsTier
This Problen happen, when I was post-cloning an apps 11i instance.
AutoConfig is exiting with status 1
StackTrace:
java.lang.Exception: RC-50013: Fatal: Failed to instantiate driver /d01/oracle/uatnora/iA
S/appsutil/driver/instconf.drv
All are welcome to post their comments.
Error Log:
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
[INSTANTIATE PHASE]
AutoConfig could not successfully instantiate the following files:
Directory: /d01/oracle/uatnora/iAS/Apache/modplsql/cfg
\ INSTE8
AutoConfig could not successfully instantiate the following files:
Directory: /d01/oracle/uatnora/iAS/Apache/modplsql/cfg
\ INSTE8
AutoConfig is exiting with status 1
RC-50013: Fatal: Failed to instantiate driver /d01/oracle/uatnora/iAS/appsutil/driver/ins
tconf.drv
Raised by oracle.apps.ad.clone.ApplyAppsTechStack
tconf.drv
Raised by oracle.apps.ad.clone.ApplyAppsTechStack
StackTrace:
java.lang.Exception: RC-50013: Fatal: Failed to instantiate driver /d01/oracle/uatnora/iA
S/appsutil/driver/instconf.drv
The Cause:
While post-cloning appsTier this problem raised.
While post-cloning appsTier this problem raised.
There was a junk file in the name "\" which causes the problem. It has some reference in instconf.drv file. This reference causes the issue.
Referred: Note: 307954.1
Action : mv "\" file out of apps folders.
vi instconf.drv file
removed all the entries having reference to "\" file.
saved the instconf.drv file.
Ran adcfgclone again. Problem solved
All are welcome to post their comments.
Subscribe to:
Posts (Atom)