To get Application Login URL

SELECT profile_option_value
  FROM fnd_profile_option_values
 WHERE profile_option_id=
   (SELECT profile_option_id                            
      FROM fnd_profile_options WHERE profile_option_name = 'APPS_FRAMEWORK_AGENT')                            
   AND level_value = 0;




SELECT home_url
  FROM icx_parameters;

dbconsole

dbconsole
===========

To start the dbconsole process from the command line:


Step 1: Navigate into your ORACLE_HOME/bin directory.

Step 2:Run the following statement:

./emctl start dbconsole

Additionally, you can stop the process and view its status.

Step 3: To stop the dbconsole process:

./emctl stop dbconsole

Step 4: To view the status of the dbconsole process:

./emctl status dbconsole

To CPU Information

OS Version:
===========


uname -a(Print all infomation)

uname -r(Print the kernal name)

cat /proc/version

cat /etc/issue

cat /etc/redhat-release

tail /etc/redhat-release



CPU Info
===========
cat /proc/cpuinfo | grep processor | wc -l

grep --count processor /proc/cpuinfo

getconf _NPROCESSORS_ONLN

ls /sys/devices/system/cpu/

Vendor and model of the processor
================================

cat /proc/cpuinfo | grep vendor | uniq

cat /proc/cpuinfo | grep 'model name' | uniq

cat /proc/cpuinfo | grep -i mhz | uniq

Find RAM size(Total, available, used) in Linux
================================================

free

top

cat /proc/meminfo

vmstat -s




when i see the out put of cat /proc/cpuinfo

48bit for vm
38bit for physical


dmesg |grep VMware



cat /proc/cpuinfo | grep processor | wc -l

free
1048576

cat /etc/redhat-release

uname -a


dmesg |grep VMware

Controlfile backup trace

ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '/tmp/control_26Mar.bkp';

Agile Applications Basics

There are a few services that are required for Agile to run.

Services

1.       Database Server:

·         OracleServiceagile9

·         OracleOraDb11g_home1TNSListener

2.       Application Server

·         Oracle AutoVue Server (can start automatically)  

·         AgilePLM93        

·         Apache Tomcat Tomcat5  

LOG FILES Locations

BEA console logs	<AGILE_HOME>\agileDomain
General logs, including Agile log	<AGILE_HOME>\agileDomain\log
BEA server log	<AGILE_HOME>\agileDomain\servers\xxxx-agile-AgileServer
Tomcat logs	<AGILE_HOME>\apache-tomcat-6.0.18\logs

Agile application bounce order

To stop Services

Step 1:  Stop AgilePLM93

Step2 :  Stop Apache Tomcat Tomcat5

Step 3:  Stop  Oracle AutoVue Server

To Start Services

Step 1:  Start Apache Tomcat Tomcat5

Step 2:  Start AgilePLM93

Step 3: Start Oracle AutoVue Server

Changing User Password from Backend

·         Login to the Applications node as appl user

·         cd $FND_TOP/bin

·         Run FNDCPASS to change the User password with below command

FNDCPASS apps/<appspswd> 0 Y system/<systempaswd> USER <USERNAME_inCaps> <NewPassword>

Example:

FNDCPASS apps/xxxxx 0 Y system/xxxx USER ABCDEF xxxx

How to Verify User and New password

·         =>Use the below query as apps user to verify if the password is changed

select fnd_web_sec.validate_login('<USERNAME>','<NEWPASWD>') from dual;

·         The output of this query if “Y” then password is changed, if “N” then there was a problem in password change

·         

Example:

SQL> select fnd_web_sec.validate_login('ABCDEF','xxxxxx') from dual;

FND_WEB_SEC.VALIDATE_LOGIN('ABCDEF','xxxxxx')

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

Y