Leave a Comment:
7 comments
Hi Atul,
I have a question which is not related to this topic. How can you find out if the listener is running or not in 806 home for 11i?
Reply@ Paul,
To find listener status in 11i
1. Login as application tier O.S. user
2. Set environment variable
3. Identify listener name $TNS_ADMIN/listener.ora (usually APPS_$SID so for SID vis11i listener name APPS_vis11i)
4. lsnrctl status $LISTENER_NAME like
lsnrctl status APPS_vis11i
—
LSNRCTL for Linux: Version 8.0.6.3.0 – Production on 21-SEP-2009 22:10:59
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=focusthreaderp)(Port=1637))
STATUS of the LISTENER
————————
Alias APPS_vis11i
Version TNSLSNR for Linux: Version 8.0.6.3.0 – Production
Start Date 21-SEP-2009 19:50:25
Uptime 0 days 2 hr. 20 min. 33 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /oracle/apps/11i/vis11i/vis11iora/8.0.6/network/admin/apps_vis11i.log
Services Summary…
FNDFS has 1 service handler(s)
FNDSM has 1 service handler(s)
The command completed successfully
—–
Above output indicates that apps listener is up and running from 2 hours 20 minutes
ReplyAtul,
I am trying to configure AD4J for R12.
But to install JVM Agent in the Oracle Application Server of R12, how can we do that?
The link you provided suggested to login in as ias_admin. But in 10.1.3.4 ( the application server version I am using ) of R12, we don’t have ias_admin. Correct?
Do we overwrite the opmn.xml to accomadate this jamagent? Then every Autoconfig run would overwrite it unless we overwrite the templates
Any ideas would be appreciated.
Reply@ Rajan,
As R12 is using 10gR3 so you can use application server control shipped with 10gR3 in R12 to deploy jamagent.war file into OC4J of R12
By default enterprise manager console /ascontrol is disabled in R12 so first enable it then login as oc4jadmin user
1. Change $INST_TOP/ora/10.1.3/Apache/Apache/conf/trusted.conf file and change
[Location ~ “/ascontrol”]
Order deny,allow
Deny from all
Allow from localhost
[/Location]
to
[Location ~ “/ascontrol”]
Order deny,allow
Allow from all
[/Location]
2. Restart Apache
adapcctl.sh stop
adapcctl.sh start
3. Access it via
oc4jadmin/password_4_oc4jadmin
If you are not sure about password then you can reset it .
Check these steps here http://onlineappsdba.com/index.php/2008/06/03/changereset-oc4jadmin-password/
steps mentioned in this post are for standalone 10gR3 , configuration files are same but under INST_TOP in R12 . Let me know if you need post on how to reset oc4jadmin password in r12
ReplyAtul,
Very good article. Good information. Thanks for your efforts & time. keep it up.
Hi Paul,
Please help me, how to purge the AD4J? what are the tables?
Rregards,
Reply@ Vinicius,
Check table JAM_THREAD_SAMPLES
select jam_pool_samples.POOL_NAME,
min(to_char(sample_date, ‘yy-mm-dd hh24:mi:ss’)),
max(to_char(sample_date, ‘yy-mm-dd hh24:mi:ss’))
from JAM_THREAD_SAMPLES,jam_pool_samples
where JAM_THREAD_SAMPLES.SAMPLE_NO = jam_pool_samples.SAMPLE_NO
and JAM_THREAD_SAMPLES.POOL_NAME = jam_pool_samples.POOL_NAME
group by jam_pool_samples.POOL_NAME
/
select segment_name, segment_type, sum(bytes)/1048576 mb
from user_extents where segment_name like ‘JAM%’
group by segment_name, segment_type
/
select table_name, num_rows, blocks, last_analyzed
from user_tables where table_name like ‘JAM%’