Why 0 "Zero" in FNDCPASS?Lets Use 60 or 50.

I heard many times from people 0 Y is the mandatory in FNDCPASS/FNDLOAD and WFLOAD and i thought of writing this post to clear doubts  " ".

Default Priority for Concurrent Manager is 50.
Lowest Priority for Concurrent Manager is 99.
Highest Priority for Concurrent Manager is 0.

Lets do it practically
================
[applvision@apps ~]$ sqlplus apps/apps

SQL*Plus: Release 10.1.0.5.0 - Production on Fri Nov 8 02:25:17 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit
[applvision@apps ~]$ sqlplus system/manager

SQL*Plus: Release 10.1.0.5.0 - Production on Fri Nov 8 02:25:35 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit
[applvision@apps ~]$ FNDCPASS apps/apps 60 Y system/manager SYSTEM APPLSYS welcome123
Log filename : L407423.log


Report filename : O407423.out
[applvision@apps ~]$ cat L407423.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

 module:
+---------------------------------------------------------------------------+

Current system time is 08-NOV-2013 02:27:13

+---------------------------------------------------------------------------+

Working...


+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 08-NOV-2013 02:27:15

+---------------------------------------------------------------------------+
[applvision@apps ~]$ sqlplus apps/welcome123

SQL*Plus: Release 10.1.0.5.0 - Production on Fri Nov 8 02:27:32 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user
USER is "APPS"
SQL>

Note * :-

 From above practically hence it has been proved that "0" is the priority which can be change.

But it always best practice to use  "Oracle defaults"

You are hotbackup is running and suddenly database crashed/Someone killed pmon process then what will happen to database?

Terminal 1
=======
SQL> startup
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1318172 bytes
Variable Size             436208356 bytes
Database Buffers          620756992 bytes
Redo Buffers               13049856 bytes
Database mounted.
Database opened.

SQL> alter database begin backup;

Database altered.

SQL>  select count(*),status from v$backup group by status;

  COUNT(*) STATUS
---------- ------------------
        44 ACTIVE

CREATE TABLE Persons
(
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
  8  );

Table created.

SQL> !date
Fri Nov  8 02:13:33 IST 2013

SQL>
SQL> exit
ERROR:
ORA-03135: connection lost contact
Process ID: 0
Session ID: 400 Serial number: 7

Terminal 2
=======
[dbvision@apps ~]$ ps -fu $LOGNAME|grep -i pmon
dbvision  5448     1  0 01:55 ?        00:00:00 ora_pmon_vision
dbvision  5968  5931  0 02:11 pts/3    00:00:00 grep -i pmon
[dbvision@apps ~]$ kill -9 5448
[dbvision@apps ~]$ ps -fu $LOGNAME|grep -i pmon
dbvision  6025  5931  0 02:13 pts/3    00:00:00 grep -i pmon
[dbvision@apps ~]$ date
Fri Nov  8 02:14:02 IST 2013
[dbvision@apps ~]$


Starting the database after crashed
========================
SQL> startup
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1318172 bytes
Variable Size             436208356 bytes
Database Buffers          620756992 bytes
Redo Buffers               13049856 bytes
Database mounted.
ORA-10873: file 1 needs to be either taken out of backup mode or media
recovered
ORA-01110: data file 1: '/db/vision/db/apps_st/data/system01.dbf'


SQL>  select count(*),status from v$backup group by status;

  COUNT(*) STATUS
---------- ------------------
        44 ACTIVE

SQL> select open_mode from v$database;

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

SQL> alter database end backup;

Database altered.

SQL> alter database open;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> 1date
SP2-0042: unknown command "1date" - rest of line ignored.
SQL> !date
Fri Nov  8 02:16:38 IST 2013

SQL>

How to apply a patch to a Shared APPL_TOP or Apps Tier File System environment?

How To Apply Patches On Shared Application Tier File System Environment (Doc ID 745580.1). There are 2 sets of of TIER values in the context file. One set is controlling services on the node and one set is controlling the AD utilities.  In a shared application tier environment the following context values should all be set to yes....  [applvision@apps log]$ egrep -i 's_isAdAdmin|s_isAdWeb|s_isAdForms|s_isAdConc|s_isAdFormsDev|s_isAdConcDev|s_isAdWebDev' $CONTEXT_FILE <TIER_ADADMIN oa_var="s_isAdAdmin">YES</TIER_ADADMIN> <TIER_ADWEB oa_var="s_isAdWeb">YES</TIER_ADWEB> <TIER_ADFORMS oa_var="s_isAdForms">YES</TIER_ADFORMS> <TIER_ADNODE oa_var="s_isAdConc">YES</TIER_ADNODE> <TIER_ADFORMSDEV oa_var="s_isAdFormsDev">YES</TIER_ADFORMSDEV> <TIER_ADNODEDEV oa_var="s_isAdConcDev">YES</TIER_ADNODEDEV> <TIER_ADWEBDEV oa_var="s_isAdWebDev">YES</TIER_ADWEBDEV> [applvision@apps log]$

With all the above variables set to YES, adpatch will apply all files to this Apps Tier.

The following variables in each nodes respective context file represent the services that are actually running on the a node:- e.g

<TIER_DB oa_var="s_isDB">NO</TIER_DB>
<TIER_ADMIN oa_var="s_isAdmin">NO</TIER_ADMIN>
<TIER_WEB oa_var="s_isWeb">YES</TIER_WEB>
<TIER_FORMS oa_var="s_isForms">YES</TIER_FORMS>
<TIER_NODE oa_var="s_isConc">NO</TIER_NODE>
<TIER_FORMSDEV oa_var="s_isFormsDev">YES</TIER_FORMSDEV>
<TIER_NODEDEV oa_var="s_isConcDev">NO</TIER_NODEDEV>
<TIER_WEBDEV oa_var="s_isWebDev">YES</TIER_WEBDEV>

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

If we lost adconfig.pl file?Can we able to run autoconfig.

[applvision@apps admin]$ cd $AD_TOP/bin
[applvision@apps bin]$ ls -tlrh adconfig.pl
-rwxr-xr-x 1 applvision applmgr 36K Nov  6  2008 adconfig.pl
[applvision@apps bin]$ mv adconfig.pl adconfig.pl_27sep2013
[applvision@apps bin]$ sh /apps/vision/inst/apps/vision_apps/admin/scripts/adautocfg.sh
Enter the APPS user password:
Can't open perl script "/apps/vision/apps/apps_st/appl/ad/12.0.0/bin/adconfig.pl": No such file or directory
[applvision@apps bin]$

When we run autoconfig using "adautocfg.sh" it calls adconfig.sh file and which in turn calls adconfig.pl script.
adconfig.pl is main script which start the autoconfig engine.If we lost adconfig.pl it not possible to run autoconfig.

Once we lost adconfig.pl file its not possible to re generate it.We have to copy it from other server.

if we lost adrelink.sh and adlicmgr.sh script.Is it possible to regenrate it?

if we lost adrelink.sh and adlicmgr.sh script.Is it possible to regenrate it?

If anything miss we will go for autoconfig choice.Let's do the same here to get adrelink.sh and adlicmgr.sh file.

======================
Let's create a senario
======================
[applvision@apps ~]$ cd $AD_TOP/bin
[applvision@apps bin]$ ls -ltrh adrelink.sh
-rwxr-xr-x 1 applvision applmgr 1.7K Dec 31  2006 adrelink.sh
[applvision@apps bin]$ mv adrelink.sh adrelink.sh_27sep2013
[applvision@apps bin]$ ls -ltrh adrelink.sh
ls: adrelink.sh: No such file or directory
[applvision@apps bin]$ 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/09280717/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 bin]$ ls -ltrh $AD_TOP/bin/adrelink.sh
ls: /apps/vision/apps/apps_st/appl/ad/12.0.0/bin/adrelink.sh: No such file or directory
[applvision@apps bin]$

Answer *:-
Both are the shell scripts,Its not possible to regenerate it.
we need to copy both the files from other server.

Rebuild/Re create context file in oracle apps R12.

If we lost $CONTEXT_FILE .How to rebulid  in oracle apps R12.


=============
Let's create senario
==============
/apps/vision/inst/apps/vision_apps/appl/admin
[applvision@apps admin]$ ls -tlrh
total 120K
-rw-r--r-- 1 applvision applmgr  11K Sep 28 07:43 adovars_vision_apps.env
-rw------- 1 applvision applmgr 7.0K Sep 28 07:44 ojspCompile.properties
-rw------- 1 applvision applmgr 3.3K Sep 28 07:44 ojspCompile.conf
-rw------- 1 applvision applmgr 1010 Sep 28 07:44 oamextensions.xml
-rwxr-xr-x 1 applvision applmgr  86K Sep 28 07:46 vision_apps.xml
[applvision@apps admin]$ mv vision_apps.xml vision_apps.xml_27sep2013
[applvision@apps admin]$ perl $COMMON_TOP/clone/bin/adclonectx.pl retrieve

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adclonectx Version 120.23.12010000.1

Running:
/apps/vision/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /apps/vision/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/apps/vision/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/apps/vision/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.RetrieveContext

Log file located at /apps/vision/inst/apps/vision_apps/appl/admin/RetrieveContext_09280757.log

Database Host [apps]:

Database Host Domain [innovation.com]:

Database Port [1521]:1526

Database SID:vision

APPS Schema Name [APPS]:apps

APPS Schema Password:apps

The following context files are available:

[1] vision_apps (APPL_TOP Context)
[2] vision_apps (Database Context)

Select the context to retrieve [1]:1

Destination file path [/apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml]:

Retrieved context file to /apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml

Log file location: /apps/vision/inst/apps/vision_apps/appl/admin/RetrieveContext_09280757.log
[applvision@apps admin]$ ls -tlrh /apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml
-rwxr-xr-x 1 applvision applmgr 86K Sep 28 08:00 /apps/vision/inst/apps/vision_apps/appl/admin/vision_apps.xml
[applvision@apps admin]$ date
Sat Sep 28 08:00:23 IST 2013
[applvision@apps admin]$

++++++++++++++++++++++
To re-build database tier context file follow below syntax.

[dbvision@apps bin]$ perl /db/vision/db/tech_st/11.1.0/appsutil/bin/adbldxml.pl appsuser=apps appspass=apps template=/db/vision/db/tech_st/11.1.0/appsutil/template/adxdbctx.tmp out=/db/vision/db/tech_st/11.1.0/appsutil

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

If we lost dbc file.How can we re generate it?

If we lost dbc file.How can we re generate it?

================
Let's create a scenario
================
[applvision@apps secure]$ ls -tlrh /apps/vision/inst/apps/vision_apps/appl/fnd/12.0.0/secure/vision.dbc
-rw------- 1 applvision applmgr 784 Sep 28 07:19 /apps/vision/inst/apps/vision_apps/appl/fnd/12.0.0/secure/vision.dbc
[applvision@apps secure]$ mv /apps/vision/inst/apps/vision_apps/appl/fnd/12.0.0/secure/vision.dbc /apps/vision/inst/apps/vision_apps/appl/fnd/12.0.0/secure/vision.dbc_27sep2013
[applvision@apps secure]$
[applvision@apps secure]$  ls -tlrh /apps/vision/inst/apps/vision_apps/appl/fnd/12.0.0/secure/vision.dbc
ls: /apps/vision/inst/apps/vision_apps/appl/fnd/12.0.0/secure/vision.dbc: No such file or directory
[applvision@apps secure]$

Now run autoconfig (or) run adgendbc.sh file to re generate dbc file.

[applvision@apps secure]$  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/09280743/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 secure]$ ls -tlrh /apps/vision/inst/apps/vision_apps/appl/fnd/12.0.0/secure/vision.dbc
-rw------- 1 applvision applmgr 784 Sep 28 07:44 /apps/vision/inst/apps/vision_apps/appl/fnd/12.0.0/secure/vision.dbc
[applvision@apps secure]$ date
Sat Sep 28 07:46:57 IST 2013
[applvision@apps secure]$

Re -cap

======

Move dbc file to create a senario.

Run autoconfig (or)run adgendbc.sh.

Check whether dbc file is created or not.

You have shutdown the Concurrent manager,Your juniour dba deleted the FNDLIBR executable. What happens when you start the concurrent manager?will CM come up (or) error out.

You have shutdown the Concurrent manager,Your junior dba deleted the FNDLIBR executable.
What happens when you start the concurrent manager?Will CM come up (or) error out.

----------------------------------------------
Move executable to create scenario
-----------------------------------------------

[applvision@apps bin]$ ls -ltrh FNDLIBR
-rwxr-xr-x 1 applvision applmgr 1.6M Mar 30  2009 FNDLIBR
[applvision@apps bin]$ mv FNDLIBR FNDLIBR_19sep2013
[applvision@apps bin]$ pwd


Lets try to start Concurrent manager.
[applvision@apps scripts]$ adcmctl.sh start apps/apps

You are running adcmctl.sh version 120.17.12010000.3

Starting concurrent manager for vision ...
Starting vision_0920@vision Internal Concurrent Manager
Default printer is noprint

adcmctl.sh: exiting with status 0


adcmctl.sh: check the logfile /apps/vision/inst/apps/vision_apps/logs/appl/admin/log/adcmctl.txt for more information ...

No processes are running
[applvision@apps scripts]$ ps -fu applvision
UID        PID  PPID  C STIME TTY          TIME CMD
501       5536  5527  0 06:23 ?        00:00:00 sshd: applvision@pts/2
501       5537  5536  0 06:23 pts/2    00:00:00 -bash
501       5807     1  0 06:25 pts/2    00:00:00 sendmail: ./r8K0tLqD005807 [127.0.0.1]: client MAIL
501       5813  5537  0 06:25 pts/2    00:00:00 ps -fu applvision

======================================
Concurrent manager log file contain below message
======================================

Starting vision_0920@vision Internal Concurrent Manager -- shell process ID 5794

          logfile=/apps/vision/inst/apps/vision_apps/logs/appl/conc/log/vision_0920.mgr
          PRINTER=noprint
           mailto=applvision
          restart=N
             diag=N
            sleep=30
             pmon=4
           quesiz=1
          Reviver is ENABLED

sh: line 34: FNDLIBR: command not found
The vision_0920@vision internal concurrent manager has terminated with status 127 - giving up.



Answer *:- It will not Concurrent manager,When you start concurrent manager,it will look for FNDLIBR executable which is located at cd $FND_TOP/bin.
FNDLIBD which inturn calls two executables FNDFS and FNDSM.

FNDFS is used to view the log and out files of concurrent managers.FNDFS is also called as report view agent.
FNDSM is start the concurrent manager.

You have removed the patch log directoy and what happens when you fire adpatch? Will patch get succeed or error out?

You have removed the patch log directoy and what happens when you fire adpatch?
Will patch get succeed or error out?

/apps/vision/apps/apps_st/appl/admin/vision
[applvision@apps vision]$ ls -tlrh
total 56K
drwx------ 2 applvision applmgr 4.0K Sep 20 06:35 21sep2013_log
-rw------- 1 applvision applmgr  25K Sep 22 01:25 adalldefaults.txt
drwx------ 2 applvision applmgr 4.0K Sep 22 02:24 log
drwx------ 3 applvision applmgr  16K Sep 22 02:24 out
drwxr-xr-x 2 applvision applmgr 4.0K Sep 22 02:26 restart
[applvision@apps vision]$ rm -rf log
[applvision@apps vision]$ ls -ld log
ls: log: No such file or directory
[applvision@apps vision]$ pwd
/apps/vision/apps/apps_st/appl/admin/vision
[applvision@apps vision]$
[applvision@apps vision]$ date
Thu Sep 26 06:51:05 IST 2013
[applvision@apps vision]$


My application services are down
=================================
[applvision@apps patches]$ ps -fu applvision
UID        PID  PPID  C STIME TTY          TIME CMD
501       5434  5398  0 05:59 ?        00:00:00 sshd: applvision@pts/3
501       5435  5434  0 05:59 pts/3    00:00:00 -bash
501       5964  5957  0 06:08 ?        00:00:00 sshd: applvision@pts/4
501       5965  5964  0 06:08 pts/4    00:00:00 -bash
501       6520  5435  0 06:32 pts/3    00:00:00 ps -fu applvision
[applvision@apps patches]$


Enabling maintainance 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: [Disabled].


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] : 1

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

Successfully enabled 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: [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



i have unloaded the patch in this directory.
/apps/vision/apps/apps_st/patches/11808198

[applvision@apps 11808198]$ adpatch

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                         Oracle Applications AutoPatch

                                 Version 12.0.0

NOTE: You may not use this utility for custom development
      unless you have written permission from Oracle Corporation.


Attention: AutoPatch no longer checks for unapplied pre-requisite patches.
You must use OAM Patch Wizard for this feature. Alternatively, you can
review the README for pre-requisite information.


Your default directory is '/apps/vision/apps/apps_st/appl'.
Is this the correct APPL_TOP [Yes] ?

AutoPatch records your AutoPatch session in a text file
you specify.  Enter your AutoPatch log file name or press [Return]
to accept the default file name shown in brackets.

Filename [adpatch.log] : test.log  ==> it has created the log direcotory,so adpatch will  not fail.

You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?

Please enter the batchsize [1000] :


Please enter the name of the Oracle Applications System that this
APPL_TOP belongs to.

The Applications System name must be unique across all Oracle
Applications Systems at your site, must be from 1 to 30 characters
long, may only contain alphanumeric and underscore characters,
and must start with a letter.

Sample Applications System names are: "prod", "test", "demo" and
"Development_2".

Applications System Name [vision] : vision *


NOTE: If you do not currently have certain types of files installed
in this APPL_TOP, you may not be able to perform certain tasks.

Example 1: If you don't have files used for installing or upgrading
the database installed in this area, you cannot install or upgrade
the database from this APPL_TOP.

Example 2: If you don't have forms files installed in this area, you cannot
generate them or run them from this APPL_TOP.

Example 3: If you don't have concurrent program files installed in this area,
you cannot relink concurrent programs or generate reports from this APPL_TOP.


Do you currently have files used for installing or upgrading the database
installed in this APPL_TOP [YES] ? YES *


Do you currently have Java and HTML files for HTML-based functionality
installed in this APPL_TOP [YES] ? YES *


Do you currently have Oracle Applications forms files installed
in this APPL_TOP [YES] ? YES *


Do you currently have concurrent program files installed
in this APPL_TOP [YES] ? YES *


Please enter the name Oracle Applications will use to identify this APPL_TOP.

The APPL_TOP name you select must be unique within an Oracle Applications
System, must be from 1 to 30 characters long, may only contain
alphanumeric and underscore characters, and must start with a letter.

Sample APPL_TOP Names are: "prod_all", "demo3_forms2", and "forms1".

APPL_TOP Name [apps] : apps *

NOTE:
Adpatch will complete without ant errors,becuase it is able to create log directory.
/apps/vision/apps/apps_st/appl/admin/vision
[applvision@apps vision]$ ls -ltrh
total 56K
drwx------ 2 applvision applmgr 4.0K Sep 20 06:35 21sep2013_log
-rw------- 1 applvision applmgr  25K Sep 22 01:25 adalldefaults.txt
drwx------ 3 applvision applmgr  16K Sep 22 02:24 out
drwxr-xr-x 2 applvision applmgr 4.0K Sep 26 06:52 log
drwxr-xr-x 2 applvision applmgr 4.0K Sep 26 06:52 restart

see the timestamp
[applvision@apps vision]$ date
Thu Sep 26 06:53:53 IST 2013
[applvision@apps vision]$ cd log
[applvision@apps log]$ ls -tlh
total 32K
-rw-r--r-- 1 applvision applmgr 7.2K Sep 26 06:52 test.log
-rw-r--r-- 1 applvision applmgr  366 Sep 26 06:52 test.lgi
-rw-r--r-- 1 applvision applmgr  18K Sep 26 06:49 adadmin.log
[applvision@apps log]$

You have removed the patch log directoy.How do you re create it?

You have removed the patch log directoy which contains adworker's log and patch log files.How do you re create it?

Let's create a scenario
==============
/apps/vision/apps/apps_st/appl/admin/vision
[applvision@apps vision]$mv log 21sep2013_log
[applvision@apps vision]$ ls -tlhr
total 52K
-rw------- 1 applvision applmgr  25K Sep 16 03:31 adalldefaults.txt
drwx------ 2 applvision applmgr 4.0K Sep 20 06:35 21sep2013_log
drwx------ 3 applvision applmgr  16K Sep 20 06:40 out
drwxr-xr-x 2 applvision applmgr 4.0K Sep 20 06:41 restart

[applvision@apps 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/09220124/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]$ pwd
/apps/vision/inst/apps/vision_apps/admin/scripts
[applvision@apps scripts]$

source the env file
==================

[applvision@apps appl]$ ls -tlrh APPS*.env
-rw-r--r-- 1 applvision applmgr 1.1K Sep 22 01:25 APPSvision_apps.env
[applvision@apps appl]$ . ./APPSvision_apps.env


/apps/vision/apps/apps_st/appl/admin/vision
[applvision@apps vision]$ ls
21sep2013_log  adalldefaults.txt  log  out  restart
[applvision@apps vision]$ ls -lrh
total 56K
drwxr-xr-x 2 applvision applmgr 4.0K Sep 20 06:41 restart
drwx------ 3 applvision applmgr  16K Sep 20 06:40 out
drwx------ 2 applvision applmgr 4.0K Sep 22 01:25 log
-rw------- 1 applvision applmgr  25K Sep 22 01:25 adalldefaults.txt
drwx------ 2 applvision applmgr 4.0K Sep 20 06:35 21sep2013_log
[applvision@apps vision]$ cd log
[applvision@apps log]$ pwd
/apps/vision/apps/apps_st/appl/admin/vision/log
[applvision@apps log]$ ls -lrh
total 0
[applvision@apps log]$


Note *;- But log file will contians nothing ,its a empty directory.

you have shutdown database .Someone came and deleted controlfile.

you have shutdown database .Someone came and deleted controlfile. When you start the database you got the error saying controlfile missing. Now what you will do?

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
[dbvision@apps data]$ rm /db/vision/db/apps_st/data/cntrl01.dbf
[dbvision@apps data]$

SQL> startup
ORACLE instance started.
Total System Global Area 1071333376 bytes
Fixed Size                  1318172 bytes
Variable Size             440402660 bytes
Database Buffers          616562688 bytes
Redo Buffers               13049856 bytes
ORA-00205: error in identifying control file, check alert log for more info.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[dbvision@apps data]$ pwd
/db/vision/db/apps_st/data


Go to alert logfile and find which controlfile is missing.
=========================================================
[dbvision@apps data]$ adrci

ADRCI: Release 11.1.0.7.0 - Production on Sun Sep 22 01:13:42 2013

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

ADR base = "/db/vision/db/tech_st/11.1.0/admin/vision_apps"
adrci> show home
ADR Homes:
diag/rdbms/vision/vision
adrci> exit
[dbvision@apps data]$ cd "/db/vision/db/tech_st/11.1.0/admin/vision_apps"
[dbvision@apps vision_apps]$ cd diag/rdbms/vision/vision
[dbvision@apps vision]$ cd trace
[dbvision@apps trace]$ pwd
/db/vision/db/tech_st/11.1.0/admin/vision_apps/diag/rdbms/vision/vision/trace
[dbvision@apps trace]$ ls -tlrh alert*.log
-rw-r--r-- 1 dbvision dba 623K Sep 22 01:13 alert_vision.log
[dbvision@apps trace]$


alert logfile
============

ALTER DATABASE   MOUNT
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/db/vision/db/apps_st/data/cntrl01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-205 signalled during: ALTER DATABASE   MOUNT...
Sun Sep 22 01:13:28 2013
Checker run found 1 new persistent data failures


if you have backup of the controlfile just copy it.Incase if you lost all you have may have multiplex of the controlfile in some other disk
just restore it.

[dbvision@apps data]$ cp -r cntrl02.dbf cntrl01.dbf
[dbvision@apps data]$


SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1318172 bytes
Variable Size             440402660 bytes
Database Buffers          616562688 bytes
Redo Buffers               13049856 bytes
Database mounted.
SQL> alter database open;

Database altered.

SQL>

Interview question on adutilities and others

Where all ADUTILITIES EXE'S LOCATED?

$AD_TOP/bin
For each utility three files are presented.
[applvision@apps bin]$ ls -ltrh adadmin adadminnew adadmin_wrapper
-rwxr-xr-x 1 applvision applmgr 9.2K Dec 31  2006 adadmin_wrapper
-rwxr-xr-x 1 applvision applmgr 9.2K Mar 27  2009 adadmin
-rwxr-xr-x 1 applvision applmgr 3.5M Mar 30  2009 adadminnew
[applvision@apps bin]$

First two files are wrapper files and both are same in size.

==>adadmin will internall call adadminnew
==>adadminnew is key executable which calls adadmin.


What happen if we lost adadminnew?

adadmin will not work.

Scenario:

[applvision@apps bin]$ mv adadminnew adadminnew_14sep2013
[applvision@apps bin]$ adadmin
sh: /apps/vision/apps/apps_st/appl/ad/12.0.0/bin/adadminnew: No such file or directory
[applvision@apps bin]$


What we had to do if we lost adadminnew?

If we lost adadminnew we can recreate it by using adrelink.sh.

[applvision@apps bin]$ mv adadminnew adadminnew_14sep2013
[applvision@apps bin]$ adadmin
sh: /apps/vision/apps/apps_st/appl/ad/12.0.0/bin/adadminnew: No such file or directory
[applvision@apps bin]$

Now fire the below command to recreate it.

$AD_TOP/bin/adrelink.sh force=y "ad admin adadmin"

NOTE: force=y indicates to check for all libraries.



if we lost adrelink.sh and adlicmgr.sh script.Is it possible to regenrate it?

Both are the shell scripts.Its not possible to regenerate it.
we need to copy it from other server.



How can we generate env file?

BY using adadmin
Choose Maintain Applications file menu.
Create application environment file
Above is applicable in 11i and in R12 i don't see this option.
(or)
Run autoconfig.



if we lost dbc,can we recreate it?
Yes ,we can re create dbc file.
To generate dbc file run autoconfig(OR) Execute adgendbc.sh script.



Form where fmx is generated?

All the executable for forms are generated from fmb files.
cd $AU_TOP/forms/US.


Using adadmin is it possible to relink ad product?
No,we cannot do it using adrelink.sh



what is the configuration file of adutilities?
adconfig.txt which is located at $APPL_TOP/admin.


How oracle will know some adadmin session is running or not?

It will know from restart file.

cd $APPL_TOP/admin/$SID/restart
<name>.rf9

If rf9 is there,it assumes that some adutilities are running.
if any adadmin session failed then we restart adadmin session then it will read the information from restart file.


can we use adadmin in non-interactive mode?
Yes,we can use it using addefaultsfile.

Which adutlilty will not create table in the database?
adident utility will not create table in the dataabase.



Why we need to generate JAR files?

For certain patches,post patch activity.
During upgradation of oracle apps.

We can generate jar files in two ways.
Normal generation
=================
it will generate missing or out of date jar files.

Force generation
================
Force generation will generate all jar files.



What we had to do if we lost forms binary file?
Copy the binary file from another server.


What is the default form when we launch oracle application form?

FNDSCSCG.fmx
It is located in $FND_TOP/forms/US



What is the executable file when we are regenerating the forms?
in Oracle apps 11i f6ogen and in r12 frmcmp_batch.


What is the executable file when we are regenerating message files?
FNDMDGEN.FMX which is located at $FND_TOP/bin


What is the executable when we are regenerating reports?
rwcon60 in oracle application 11i.


How can we generate dbc file?
By running auto config.
By executing adgendbc.sh file which is located at $COMMON_TOP/admin/install/$CONTEXT_NAME
and in R12 $INST_TOP/install/admin.adgendbc.sh

(MWA)Telnet is not working on the below port 10230

User will raise ticket with dbateam saying mobile server(telnet)  is not running on ebsvision database(or)
you will get communication mail from user (or)business.

How do you check whether mobile services is up and running in R12?

[applvision@apps install]$ ps -fu applvision|grep -i Doracle
501       7146  5748  0 00:22 pts/3    00:00:00 grep -i doracle

Check whether the mobile port is listening for any sevices.
[applvision@apps install]$ netstat -ann|grep -i 10230

After checking above two steps we can say that telnet is down.

[applvision@apps scripts]$ cd $ADMIN_SCRIPTS_HOME
[applvision@apps scripts]$ pwd
/apps/vision/inst/apps/vision_apps/admin/scripts

Now start mobile service on the same port
============================
[applvision@apps scripts]$ nohup mwactl.sh start 10230 &
[1] 7161
[applvision@apps scripts]$ nohup: appending output to `nohup.out'

[1]+  Done                    nohup mwactl.sh start 10230
[applvision@apps scripts]$ pwd
/apps/vision/inst/apps/vision_apps/admin/scripts


Now verify it
============
[applvision@apps scripts]$ ps -fu applvision|grep -i Doracle
501       7163     1  1 00:22 pts/3    00:00:03 /apps/vision/apps/tech_st/10.1.3/appsutil/jdk/bin/java -DCLIENT_PROCESSID=7163 -Doracle.apps.mwa=/apps/vision/apps/apps_st/appl/mwa/12.0.0 -Doracle.apps.jrad.mmd=/apps/vision/apps/apps_st/comn/webapps/oacore/html/jrad -Doracle.apps.inst=/apps/vision/inst/apps/vision_apps -mx512m -ms128m oracle.apps.mwa.presentation.telnet.Listener 10230
501       7313  5748  0 00:26 pts/3    00:00:00 grep -i doracle
[applvision@apps scripts]$ netstat -ann|grep -i 10230
tcp        0      0 0.0.0.0:10230               0.0.0.0:*                   LISTEN
[applvision@apps scripts]$


Now the mobile services are up and running.Tell user to check now.