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.
/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)