OAS: show oc4j memory usage with opmnctl (10.1.3)

opmnctl status -fmt cmp%mem%hpz%pme%sme

Processes in Instance: test_instance
--------------+---------+----------+---------+--------
ias-component | memused | heapsize | privmem | shrdmem
--------------+---------+----------+---------+--------
ASG | N/A | N/A | N/A | N/A
OC4JGroup:coreman_group | 220960 | 0 | 205928 | 15032
OC4JGroup:esbdt_group | 396560 | 0 | 380888 | 15672
OC4JGroup:soa_group | 1555096 | 0 | 1510424 | 44672
OC4JGroup:default_group | 185420 | 0 | 170472 | 14948
HTTP_Server | 1035640 | 0 | 1024396 | 11244

rdbms: trace session with logon trigger

Just a simple logon trigger to trace an user session:

create or replace trigger set_session_trace after logon on database

begin
if user ='$USER' then
  execute immediate 'alter session set timed_statistics = true';
  execute immediate 'alter session set max_dump_file_size = unlimited';
  execute immediate 'alter session set tracefile_identifier = ''trace_session_$USER''';
  execute immediate 'alter session set events ''10046 trace name context forever, level 12'' ';
end if;
end;
/

$USER: username

Trace levels (10046):

0: Turn off
1: Basic sql trace ( equal to alter session set sql_trace=true )
4: Level 1 plus bind variables
8: Level 1 plus wait events
12: Level 1 plus bind variables and wait event information

OID: Failed to start OID

Oracle OID failed to start

Check $INFRA_HOME/ldap/log/oidmon.log:

2010/12/08:11:42:51 * [oidmon]: Unable to connect to database,

            will retry again after 20 sec

2010/12/08:11:43:11 * Connecting to database, connect string is infra

2010/12/08:11:43:11 * [gsdsiConnect] ORA-1017, ORA-01017: invalid username/password; logon denied

Problem: ODS password in infra instance wallet file differs from ODS password in INFRA database.

Solution: Recreate wallet file (password):

cd $INFRA_HOME/ldap/admin

oidpasswd connect=oaiinfra create_wallet=true

password: xxxx

infra = connect string infra database (mdr)

password = ODS password

SSO: Internal Server Error 500, Partner application configuration not found

In INFRA_HOME/sso/log/ssoServer.log

Mon Dec 06 12:31:12 CET 2010 [DEBUG] AJPRequestHandler-ApplicationServerThread-9 exception before getAuthLevel

oracle.security.sso.server.conf.ConfigurationException: Partner application configuration not found:7AD3DE1B

        at oracle.security.sso.server.conf.DatabaseConfigReader.getPartnerConfiguration(DatabaseConfigReader.java:134)

        at oracle.security.sso.server.auth.AuthDirector.getAuthLevel(AuthDirector.java:181)

        at oracle.security.sso.server.ui.SSOLoginServlet.doPost(SSOLoginServlet.java:345)

        at oracle.security.sso.server.ui.SSOLoginServlet.doGet(SSOLoginServlet.java:307)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

        at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:835)

        at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:341)

        at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:852)

        at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:231)

        at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:136)

        at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)

        at java.lang.Thread.run(Thread.java:534)

Reregister Partner Application:

$ORACLE_HOME/sso/bin/ssoreg.sh -oracle_home_path $ORACLE_HOME -site_name mijn_site -config_mod_osso TRUE -mod_osso_url

https://mysite.tst.nl -virtualhost -config_file $INFRA_HOME/Apache/Apache/conf/osso/osso_mysite.conf -remote_midtier -admin_info cn=orcladmin

Check INFRA Database :

select SITE_TOKEN,SITE_ID,SITE_NAME,START_DATE from orasso.wwsso_papp_configuration_inf_t ;

Restart INFRA Tier and MID Tier

opmnctl shutdown && opmnctl startall

neat-handed shell commands

# Search for files containing "text" strings through directories

find . -type f -exec grep -l "text string" {} \;

# Kill more then 1 processes (unix)

ps -ef | grep "process" | awk -F " " '{ print "kill -9 " $2 }'

or

for x in ` ps -ef | grep "process" | awk -F " " '{ print $2 }'`
do
    kill -9 $x
done

Welcome

Welcome on luiksie.blog.com