How to troubleshoot oacore/OC4J process in Oracle Application Release r12 ?

1)First check oacore startup log file .
$LOG_HOME/appl/admin/log/adoacorectl.txt

2)Next check opmn log
$LOG_HOME/ora/10.1.3/opmn/opmn.log

ps -ef | grep 'opmn -d' | grep -v 'grep'
One Response to “Communication error with the OPMN server local port”

If all services are up and running and you still get “Page not found” in Apps R12, then

3)$LOG_HOME/ora/10.1.3/opmn/oacore_default_group_1/oacorestd.err

4)$LOG_HOME/ora/10.1.3/j2ee/oacore_default_group_1/application.log

To confirm that issue is because of Java Object Cache (JOC), check log file
$LOG_HOME/appl/rgf/javacache.log

Troubleshoot Oracle HTTP Server in Oracle ebs R12?

The configuration file for apache in R12 is located in the below location.
$ORA_CONFIG_HOME/10.1.3/Apache/Apache/conf/httpd.conf

For successful start of Apache exit code must be 0 ,
If this value is non zero like 150,152 or 204 then identify root cause of non zero exit
code by examing below files.


1)First check Apache startup log file .
$LOG_HOME/appl/admin/log/adapcctl.txt

2) $LOG_HOME/ora/10.1.3/opmn/HTTP_Server~1.log

3) Check for apache access logs and error logs.
$LOG_HOME/ora/10.1.3/Apache

ls -tlrh error_log.*|tail
ls -tlrh access_log.*|tail

How to troubleshoot oaforms/OC4J process in Oracle Application Release r12 ?

1)First check oacore startup log file .
$LOG_HOME/appl/admin/log/adoaformsctl.txt

2)Next check opmn log
$LOG_HOME/ora/10.1.3/opmn/opmn.log

3)$LOG_HOME/ora/10.1.3/opmn/oafm_default_group_1/formsstd.err

4)$LOG_HOME/ora/10.1.3/j2ee/oaforms_default_group_1/application.log

How to troubleshoot oafm/OC4J process in Oracle Application Release r12 ?

1)First check oacore startup log file .
$LOG_HOME/appl/admin/log/adoafmctl.txt

2)Next check opmn log
$LOG_HOME/ora/10.1.3/opmn/opmn.log

3)$LOG_HOME/ora/10.1.3/opmn/oafm_default_group_1/oafmstd.err

4)$LOG_HOME/ora/10.1.3/j2ee/oafm_default_group_1/application.log

How to execute WMSCheckLPN.sql?

please run the LPN diagnostic script - 
WMSCheckLPN.sql, for the problem/corrupted License Plate Number( LPN ) and upload the output.
Refer to Note 298052.1 for instructions and Licence Plate Number is H031923018.

SQL> select user,name from v$database;

USER NAME
------------------------------ ---------
APPS EBSTEST1

SQL> @WMSCheckLPN.sql
Please enter Licence Plate Number : H031923018

Date run: 09-OCT-13 17:19
Database: EBSTEST1
Applications: 11.5.10.2

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Solaris: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production


WMS Related Product Installation Status
WMS I=Installed
11i.WMS.G

PO I=Installed
11i.PO.I

ONT I=Installed
11i.ONT.J

INV I=Installed
11i.INV.J

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Analysing LPN related tables and columns Phase - 1 ....
Depending on the amount of underlying data to be analysed,
the script can run from a couple of seconds to several minutes.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Analysing WSH_DELIVERY_DETAILS_2SEP12
FROM WSH_DELIVERY_DETAILS_2SEP12
*
ERROR at line 200:
ORA-00942: table or view does not exist



Analysing WSH_DEL_DETAILS_INTERFACE

no rows selected

End of $Header: WMSCheckLPN.sql 1.1 21-Mar-2003 support
not spooling currently

=======================================================================
Please find output in file WMSCheckLPN.txt
=======================================================================

SQL>

Upload this output "WMSCheckLPN.txt" to ticketing tool.

ORA-12545: Connect failed because target host or object does not exist.

Autoconfig failed with below error in RAC ENVIRONMENT
=========================================
ORA-12545: Connect failed because target host or object does not exist.

Metalink says: 
=========

Troubleshooting ORA-12545 / TNS-12545 Connect failed because target host or object does not exist (Doc ID 553328.1)

Cause : Issue with tns.

Solution: 
Wrong hostname in ifile

The system has not been taken off maintenance mode completely.Please contact your system adminstration.

The system has not been taken off maintenance mode completely.Please contact your system adminstration.

To get rid off this error:

1) login to applmgr user

2) run adadmin

3) use option 5 to disable maintenance mode.

Beginning database cleanup for previous session ...

Completed database cleanup for previous session.

            AD Administration Main Menu

   --------------------------------------------------

   1.    Generate Applications Files menu

   2.    Maintain Applications Files menu

   3.    Compile/Reload Applications Database Entities menu

   4.    Maintain Applications Database Entities menu

   5.    Change Maintenance Mode

   6.    Exit AD Administration

Enter your choice [6] : 5

             Change Maintenance Mode

   ----------------------------------------

Maintenance Mode is currently: [Enabled].

Maintenance mode should normally be enabled when patching

Oracle Applications and disabled when users are logged on

to the system.  See the Oracle Applications Maintenance

Utilities manual for more information about maintenance mode.

Please select an option:

   1.    Enable Maintenance Mode

   2.    Disable Maintenance Mode

   3.    Return to Main Menu

Enter your choice [3] : 2

sqlplus -s &un_apps/***** @/apps/vision/apps/apps_st/appl/ad/12.0.0/patch/115/sql/adsetmmd.sql DISABLE

Successfully disabled Maintenance Mode.

Review the messages above, then press [Return] to continue.

Backing up restart files, if any......Done.

             Change Maintenance Mode

   ----------------------------------------

Maintenance Mode is currently: [Disabled].

4) Restart application services 

(adstpall.sh and adstrtal.sh scripts) - $ADMIN_SCRIPTS_HOME

If we lost adapcctl.sh, adalnctl.sh, and adcmctl.sh scripts.Is it possible to re- generate it?

If we lost adapcctl.sh, adalnctl.sh, and adcmctl.sh scripts.Is it possible to re- generate it?
yes we can re-generate it,By running autoconfig.

Let's create a scenario
=================
[applvision@apps scripts]$ pwd
/apps/vision/inst/apps/vision_apps/admin/scripts
[applvision@apps scripts]$ ps -fu applvision
UID        PID  PPID  C STIME TTY          TIME CMD
501       6040  6033  0 07:52 ?        00:00:00 sshd: applvision@pts/2
501       6041  6040  0 07:52 pts/2    00:00:00 -bash
501       6395  6041  0 08:05 pts/2    00:00:00 ps -fu applvision
[applvision@apps scripts]$ mv adapcctl.sh adapcctl.sh_7oct2013
[applvision@apps scripts]$ mv adalnctl.sh adalnctl.sh_7oct2013
[applvision@apps scripts]$ mv adcmctl.sh adcmctl.sh_7oct2013
[applvision@apps scripts]$ ls -ltrh adapcctl.sh adalnctl.sh adcmctl.sh
ls: adapcctl.sh: No such file or directory
ls: adalnctl.sh: No such file or directory
ls: adcmctl.sh: No such file or directory
[applvision@apps scripts]$
[applvision@apps scripts]$ date
Tue Oct  8 08:08:29 IST 2013
[applvision@apps scripts]$

Solution *:-Now run autoconfig to re generate all missing/lost scripts.

[applvision@apps scripts]$ sh /apps/vision/inst/apps/vision_apps/admin/scripts/adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /apps/vision/inst/apps/vision_apps/admin/log/10080810/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /apps/vision/inst/apps/vision_apps
        Classpath                   : /apps/vision/apps/apps_st/comn/java/lib/appsborg2.zip:/apps/vision/apps/apps_st/comn/java/classes

        Using Context file          : /apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IGS_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
[applvision@apps scripts]$ ls -ltrh adapcctl.sh adalnctl.sh adcmctl.sh
-rwx------ 1 applvision applmgr 7.2K Oct  8 08:11 adalnctl.sh
-rwx------ 1 applvision applmgr  17K Oct  8 08:11 adcmctl.sh
-rwx------ 1 applvision applmgr 8.1K Oct  8 08:12 adapcctl.sh
[applvision@apps scripts]$ date
Tue Oct  8 08:15:50 IST 2013
[applvision@apps scripts]$

Note *:- My autoconfig completed successfully and new scripts are re-generated.

Quote of the day!!

Optimism is the faith that leads to achievement. Nothing can be done without hope and confidence.

ORA-00600: internal error code, arguments: [kcratr1_lastbwr]

Metlink id *:-ORA-00600:[Kcratr1_lastbwr] During Database Startup after a Crash (Doc ID 393984.1)

SQL> startup
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1318172 bytes
Variable Size             432014052 bytes
Database Buffers          624951296 bytes
Redo Buffers               13049856 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],
[], [], [], [], [], [], []

SQL> select open_mode from v$database;

OPEN_MODE
----------
MOUNTED

SQL>



SYMPTOMS
==========
After a disk failure that caused the database to crash, the instance fails to start up with ORA-00600: arguments: [kcratr1_lastbwr].


Error in alert log file is
=============
Tue Oct 08 07:26:53 2013
ALTER DATABASE   MOUNT
Setting recovery target incarnation to 2
Successful mount of redo thread 1, with mount id 3631468477
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Tue Oct 08 07:26:57 2013
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
 parallel recovery started with 3 processes
Started redo scan
Errors in file /db/vision/db/tech_st/11.1.0/admin/vision_apps/diag/rdbms/vision/vision/trace/vision_ora_5385.trc  (incident=147332):
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /db/vision/db/tech_st/11.1.0/admin/vision_apps/diag/rdbms/vision/vision/incident/incdir_147332/vision_ora_5385_i147332.trc
Aborting crash recovery due to error 600
Errors in file /db/vision/db/tech_st/11.1.0/admin/vision_apps/diag/rdbms/vision/vision/trace/vision_ora_5385.trc:
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN...
Trace dumping is performing id=[cdmp_20131008072701]
Tue Oct 08 07:27:55 2013
Sweep Incident[147332]: completed


Solution: Meta link says.
=====================
Mount the database and issue a recover statement.


SQL> recover database;
Media recovery complete.
SQL> select open_mode,name from v$database;

OPEN_MODE  NAME
---------- ---------
MOUNTED     VISION

SQL>

SQL> alter database open;

Database altered.

SQL> select status from v$instance;

STATUS
------------
OPEN
SQL> select open_mode,name from v$database;

OPEN_MODE  NAME
---------- ---------
READ WRITE VISION


SQL>

Quote of the day !!!

Our greatest weakness lies in giving up. The most certain way to succeed is always to try just one more time.

Listener interview question

what is listener in oracle database?
Listener is a process that will listen for incoming connection.

what is the name of the defalut listener?
listener.

what is the ulility to start the database listener?
lsnrctl .

what is the default port number for the database listener?
1521

Can multiple listener L1,L2 and  L3 listen to single database(ebstest)?
yes,multiple listener can listen to single database.

Is it possible have password for a listener?(or)can we create password for a listener to protect it.
Yes,we can.

Single listener can listen to multiple database like ebstest,ebsdev and ebsqa?
yes,it is possible.

is it possible for a listener to listen multiple protocals like TCP and TCP WITH SSL?
YES.

How to stop the database listener?
lsnrctl stop <name of the listener>

How to start the listener?
lsnrctl start <name of the listener>.

How to stop and start listener at one shot?
lsnrctl stop <name of the listener>;lsnrctl start <name of the listener>

What happens,when database listener is down?
if listener is down,Users are not able to connect to database.


What is the location for tnsnames.ora and listener.ora file?

cd $ORACLE_HOME/network/admin/$CONTEXT_NAME (OR) cd $TNS_ADMIN

What TNS stands for in TNS_ADMIN varaible?
TNS is stands for transparent network substrate.


Thanks for visiting my blog !!!!!!!!!!!!!!!123456789

Cause: FDPRRC failed due to ORA-01654: unable to extend index APPLSYS.FND_CONCURRENT_REQUESTS_N4 by 16 in tablespace APPS_TS_TX_IDX

Users are complaining that they request's are not completing and getting below error.

Error in Concurrent manager logfile *:--
------------------------------------------------
Cause: FDPRRC failed due to ORA-01654: unable to extend index APPLSYS.FND_CONCURRENT_REQUESTS_N4 by 16 in tablespace APPS_TS_TX_IDX

Cause:tablespace APPS_TS_TX_IDX is 100%.Please resize or add a datafile to to tablespace
according the situation.

TABLESPACE_ AVAIL USED FREE Used % FREE_PC Required MB
----------- ---------- ---------- ---------- ------- ------- -----------
APPS_TS_TX_ 343452 343452 0 100.00 0.00 60609.1765

IDX

Solution*:-
SQL> alter database datafile '+EBSTEST1_DATA/DATABASE/datafile/apps_ts_tx_idx.732.824471231' resize 7200m;

Database altered.


SQL>

Thanks for visiting my blog.!!!!!!!!!!!!!!!!!

ORA-27301: OS failure message: Not owner ORA-27302: failure occurred at: skgpwinit6 ORA-27303: additional information:

I have scrapped the target database and used "rsync" command to transfer the binaries from source system
to target system.I have configured the 11.2.0 and when i am trying to connect to database getting below
error.

oradev@ctssd11 $ sqlplus apps/apps#oops

SQL*Plus: Release 11.2.0.3.0 Production on Tue Sep 24 01:31:43 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

ERROR:
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Not owner
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 30310 (dbaoltp1), current gid
= 54132 (dbadev)


Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

Cause:Owner (or) group name is poiting to production (dbaoltp1).

Solution *:-

drwxr-xr-x 98 oradev dbaoltp1 3.0K Sep 24 01:04 11.2.0

chown -R oradev:dbadev 11.2.0

ORA-09925: Unable to create audit trail file SVR4 Error: 28: No space left on device Additional information: 9925

When i am trying to stop the database using crsctl command getting below error.

crsctl stop res ora.ebstest1.db
CRS-2673: Attempting to stop 'ora.ebstest1.db' on 'ctsst12'
ORA-09925: Unable to create audit trail file
SVR4 Error: 28: No space left on device
Additional information: 9925
ORA-09925: Unable to create audit trail file
SVR4 Error: 28: No space left on device
Additional information: 9925
CRS-2675: Stop of 'ora.ebstest1.db' on 'ctsst12' failed

CRS-4000: Command Stop failed, or completed with errors.

Issue is no space is left on the mount point (or) utilize 100%,Please clear the unwanted files from trace dirctory and try it again.
ctsst12 > df -h |grep -i st1
ebstest1_oracle 31G 31G 0K 100% /ebstest1/oracle
/dev/asm/erpapp-308 202G 185G 17G 92% /ebstest1/apps/erpapp
ctsst12 > 

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

When trying to create xml file,got below error in oracle applications 11i for rdbms $ORACLE_HOME.

[oratest1@ctsst11 bin]$ perl adbldxml.pl tier=db appsuser=apps appspasswd=apps#opps

Starting context file generation for db tier..
Using JVM from /ebstest1/oracle/11.2.0/jdk/bin/java to execute java programs..

The log file for this adbldxml session is located at:
/ebstest1/oracle/11.2.0/appsutil/log/adbldxml_10021445.log

Could not Connect to the Database : Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Connecting to the ebstest12 database instance...

Connection paramaters values:
Database server hostname ==> ctsst11-vip.user.com
Database listener port ==> 1592
Database SID ==> ebstest12
Database schema name ==> apps

Could not Connect to the Database : Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor


AC-40000: Error: Exception - java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
occured while connecting to the database - ebstest12

Could not Connect to the Database with the above parameters, Please answer the Questions below

Enter Hostname of Database server[ctsst11-vip.user.com]:


Solution *:-
1)Check listener status ==> you will find the sentence in the last line "listener support no service" it's mean that your listener is not register with the database.
2)login to sysdba ==>sqlplus "/as sysdba"
3)alter system register;
4)stop and start listener.
5)Re test the issue