Welcome to My Oracle World

To Check Language Patches

SELECT LANGUAGE_CODE,NLS_LANGUAGE,INSTALLED_FLAG FROM FND_LANGUAGES WHERE INSTALLED_FLAG IN('B','I');

JSP compilation

Step 1: cd $OA_HTML

Step 2: $JTF_TOP/admin/scripts/ojspCompile.pl --compile -s 'getRegRpzSerialNo.jsp'

for any .java file,

Step 3: javac linga.java

step 4: Apache bounce

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