Cisco Anyconnect 2.5.6005 + Windows 8

after installed cisco anyconnect 2.5.6005, when connect,
“Checking for product updates…”.
failed

modified following key value by regedit
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\vpnva]
“DisplayName”=”Cisco AnyConnect VPN Virtual Miniport Adapter for Windows x64”

the displayname is sth just before “Cisco AnyConnect VPN Virtual Miniport Adapter for Windows x64”, delete them , and only remain “=”Cisco AnyConnect VPN Virtual Miniport Adapter for Windows x64”

retry, everything is ok
🙂

Failed Component with handler ID “55” does not exist

I have some EBS R12 load testing scripts , run ok in dev enviroment. 
and We decided to move it to the testing env, with much powerful hardware. 

After all R12 moving is done, all ebs form scripts show followng error. 
<strong>Failed Component with handler ID "55" does not exist.</strong>
on following line of code
nca.genericClient(101, "COMPONENT_ID_55").sendGenericClientMessage("", "12");
this code is generated by openscript after you clicked an url that point to a form and before the form shows.

I tried to record a new scripts on new env, the code run's ok in new env , and got the same error in the old env.

It must be some config not fixed for the new env.
I compared the 2 codes line by line, finally found that I don't make the DB service name as a parameter of the openscript scripts. 
the old DB service name is VIS and the new one is VISXL.

just replace all 'VIS' in old scripts to 'VISXL' and It worked again.
of course the better method is to make the service a parameter , and It will be easier to work with new env.

adoacorectl.sh, adformsctl.sh, adoafmctl.sh exiting with status 150

 

after adstart all, show following report

[Service Control Execution Report]
The report format is:
  <Service Group>            <Service>                                  <Script>         <Status>

  Root Service                                                                           Enabled
  Root Service               Oracle Process Manager for VIS_slcc02db02  adopmnctl.sh     Started
  Web Entry Point Services                                                               Enabled
  Web Entry Point Services   Oracle HTTP Server VIS_slcc02db02          adapcctl.sh      Started
  Web Entry Point Services   OracleTNSListenerAPPS_VIS_slcc02db02       adalnctl.sh      Started
  Web Application Services                                                               Enabled
  Web Application Services   OACORE OC4J Instance VIS_slcc02db02        adoacorectl.sh   Failed
  Web Application Services   FORMS OC4J Instance VIS_slcc02db02         adformsctl.sh    Failed
  Web Application Services   OAFM OC4J Instance VIS_slcc02db02          adoafmctl.sh     Failed
  Batch Processing Services                                                              Enabled
  Batch Processing Services  OracleConcMgrVIS_slcc02db02                adcmctl.sh       Started
  Batch Processing Services  Oracle Fulfillment Server VIS_slcc02db02   jtffmctl.sh      Started
  Other Services                                                                         Enabled

adformsctl.sh: exiting with status 150

check detail logs:
09/27/12-22:44:20 :: adformsctl.sh version 120.16.12010000.3
09/27/12-22:44:20 :: adformsctl.sh: starting OPMN if it is not running

opmnctl: opmn is already running.

09/27/12-22:44:21 :: adformsctl.sh: Starting OPMN managed FORMS OC4J instance

opmnctl: starting opmn managed processes...
================================================================================
opmn id=slcc02db02.us.oracle.com:6200
    no processes or applications matched this request

09/27/12-22:44:21 :: adformsctl.sh: exiting with status 150


================================================================================

stop all R12 procs

rm -rf $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/persistence/*
rm -rf $ORA_CONFIG_HOME/10.1.3/j2ee/oafm/persistence/*
rm -rf $ORA_CONFIG_HOME/10.1.3/j2ee/forms/persistence/*

start all service again

all is ok.

EBS R12, after rapid clone, FRM92101

no response from runtime process

check log
[apps@slcc02db02 ~]$ tail -f   $LOG_HOME/ora/10.1.3/opmn/forms_default_group_1/formsstd.out

12/09/27 21:29:07 Forms session <2> aborted: runtime process failed during startup with errors /scratch/apps/appmgr/VIS/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

12/09/27 21:45:29 Forms session <3> aborted: runtime process failed during startup with errors /scratch/apps/appmgr/VIS/apps/tech_st/10.1.2/bin/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directo

reinstall all needed rpms

12/09/27 21:45:47 Shutting down…
12/09/27 21:49:01 FormsServlet init():
configFileName:     /scratch/apps/appmgr/VIS/inst/apps/VIS_slcc02db02/ora/10.1.2/forms/server/appsweb.cfg
testMode:           false
12/09/27 21:49:01 Oracle Containers for J2EE 10g (10.1.3.5.0)  initialized
12/09/27 21:50:54 ListenerServlet init()

禁止cos_slug_translator将全英文标题url翻译为中文

cos_slug_translator是一个很好用的插件,会自动将带有中文的标题翻译为英文,作为永久链接,英文比中文更好。
cos_slug_translator采用了有道的翻译api,目前版本是1.1,这个api会将中文翻译为英文,同时,也会将英文翻译为中文。没有参数可以指定是 中->英 还是 英->中。这样就造成了如果标题是全英文的,那么最终的固定连接会自动被替换为翻译过来的中文,反倒不美。
进行如下修改,如果表里中不含有中文,就不进行翻译

修改 function CosSlugTrans($postID){
    $tableposts = $wpdb->posts ;
        $sql = "SELECT post_title,post_name FROM $tableposts WHERE ID=$postID";
        $res = $wpdb->get_results($sql);    
        $post_title = $res[0]->post_title;
        $tran_title = cos_tranlate($post_title);
        $slug = $tran_title;
        if(function_exists("sanitize_title") ) {
            if( sanitize_title( $res[0]->post_title ) != $res[0]->post_name  ){
                if( !substr_count($path, '%') ) 
....
修改为
    $tableposts = $wpdb->posts ;
        $sql = "SELECT post_title,post_name FROM $tableposts WHERE ID=$postID";
        $res = $wpdb->get_results($sql);    
        $post_title = $res[0]->post_title;

        if (preg_match("/[\x7f-\xff]/", $post_title)) {
            $tran_title = cos_tranlate($post_title);
            $slug = $tran_title;
        } else {
            $slug = $post_title;
        }

        if(function_exists("sanitize_title") ) {
            if( sanitize_title( $res[0]->post_title ) != $res[0]->post_name  ){
                if( !substr_count($path, '%') ) 
....

 

How to determine bind variable value and type from trace file

from
http://oradbatips.blogspot.jp/2007/11/tip-64-how-to-determine-bind-variable.html
For finding more information about bind variable, user should be able to locate BINDS keyword in trace file.
This part is something like this :

BINDS #2:
bind 0: dty=1 mxl=32(30) mal=00 scl=00 pre=00 oacflg=13 oacfl2=1 size=32 offset=0
bfp=030a79ec bln=32 avl=01 flg=05
value="A"

dty determines bind variable type and value shows bind variable value at the time of execution.
Different values can be assigned to dty which presents different data type.

Typical dty value is :

1 VARCHAR2 or NVARCHAR2
2 NUMBER
8 LONG
11 ROWID
12 DATE
23 RAW
24 LONG RAW
96 CHAR
112 CLOB or NCLOB
113 BLOB
114 BFILE

To demosnstrate, I ran some queries.

SQL> alter session set statistics_level=ALL;

Session altered.

SQL> alter session set max_dump_file_size=UNLIMITED;

Session altered.

SQL> alter session set events '10046 trace name context forever, level 12';

Session altered.

SQL> variable b number;
SQL> declare
2 cnt number;
3 begin
4 :b:=1;
5 select count(*) into cnt from dba_objects where object_id=:b;
6 end;
7 /

PL/SQL procedure successfully completed.

SQL> alter session set events '10046 trace name context off';

Session altered.

Checking trace file ……

PARSING IN CURSOR #2 len=52 dep=1 uid=0 oct=3 lid=0 tim=2797155817 hv=1220784193 ad='130a9d4c'
SELECT count(*) from dba_objects where object_id=:b1
END OF STMT
PARSE #2:c=15625,e=24270,p=0,cr=5,cu=0,mis=1,r=0,dep=1,og=0,tim=2797155809
BINDS #2:
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=13 oacfl2=1 size=24 offset=0
bfp=030a7b2c bln=22 avl=02 flg=05
value=1
EXEC #2:c=0,e=2062,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=2797159524
FETCH #2:c=0,e=37,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=2797159885

 

—— Query #2 : Varhchar2 Bind variable

SQL> alter session set events '10046 trace name context forever, level 12';

Session altered.

SQL> variable b varchar2(30);
SQL> declare
2 cnt number;
3 begin
4 :b:='A';
5 select count(*) into cnt from dba_objects where object_name=:b;
6 end;
7 /

PL/SQL procedure successfully completed.

SQL> alter session set events '10046 trace name context off';

Checking trace file .....

PARSING IN CURSOR #2 len=54 dep=1 uid=0 oct=3 lid=0 tim=3007778755 hv=2029951970 ad='12ff2c80'
SELECT count(*) from dba_objects where object_name=:b1
END OF STMT
PARSE #2:c=15625,e=12991,p=0,cr=2,cu=0,mis=1,r=0,dep=1,og=0,tim=3007778748
BINDS #2:
bind 0: dty=1 mxl=32(30) mal=00 scl=00 pre=00 oacflg=13 oacfl2=1 size=32 offset=0
bfp=030a79ec bln=32 avl=01 flg=05
value="A"
EXEC #2:c=0,e=2167,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3007782524
WAIT #2: nam='db file sequential read' ela= 9458 p1=1 p2=89 p3=1
WAIT #2: nam='db file sequential read' ela= 6606 p1=1 p2=26791 p3=1

 

 

code highlighter test 2

set pagesize 0
set linesize 125
set serveroutput on size 10000
col plan_table_output format a125
undefine hash_value
set verify off feedback off
var hash_value varchar2(20)
begin
:hash_value := '&hash_value';
end;
/
insert into plan_table
(statement_id,timestamp,operation,options,object_node,object_owner,object_name,
optimizer,search_columns,id,parent_id,position,cost,cardinality,bytes,other_tag,
partition_start,partition_stop,partition_id,other,distribution,
cpu_cost,io_cost,temp_space,access_predicates,filter_predicates,
plan_id,OBJECT_ALIAS,DEPTH,PROJECTION,TIME,QBLOCK_NAME
)
select distinct hash_value,sysdate,operation,options,object_node,object_owner,object_name,
optimizer,search_columns,id,parent_id,position,cost,cardinality,bytes,other_tag,
partition_start,partition_stop,partition_id,other,distribution,
cpu_cost,io_cost,temp_space,access_predicates,filter_predicates,
:hash_value,OBJECT_ALIAS,DEPTH,PROJECTION,TIME,QBLOCK_NAME
from v$sql_plan
where hash_value = :hash_value
/
col piece noprint
select distinct 'sql_id:'||sql_id, ' hash_value:'||hash_value, 'plan_hash_value:'||plan_hash_value from v$sql_plan where hash_value=:hash_value
/
select distinct piece,sql_text from v$sqltext where hash_value = :hash_value order by piece
/
@?/rdbms/admin/utlxplp.sql
set linesize 80
set verify on feedback on pagesize 1000

set pagesize 0
set linesize 125
set serveroutput on size 10000
col plan_table_output format a125
undefine hash_value
set verify off feedback off
var hash_value varchar2(20)
begin
:hash_value := '&hash_value';
end;
/
insert into plan_table
(statement_id,timestamp,operation,options,object_node,object_owner,object_name,
optimizer,search_columns,id,parent_id,position,cost,cardinality,bytes,other_tag,
partition_start,partition_stop,partition_id,other,distribution,
cpu_cost,io_cost,temp_space,access_predicates,filter_predicates,
plan_id,OBJECT_ALIAS,DEPTH,PROJECTION,TIME,QBLOCK_NAME
)
select distinct hash_value,sysdate,operation,options,object_node,object_owner,object_name,
optimizer,search_columns,id,parent_id,position,cost,cardinality,bytes,other_tag,
partition_start,partition_stop,partition_id,other,distribution,
cpu_cost,io_cost,temp_space,access_predicates,filter_predicates,
:hash_value,OBJECT_ALIAS,DEPTH,PROJECTION,TIME,QBLOCK_NAME
from v$sql_plan
where hash_value = :hash_value
/
col piece noprint
select distinct 'sql_id:'||sql_id, ' hash_value:'||hash_value, 'plan_hash_value:'||plan_hash_value from v$sql_plan where hash_value=:hash_value
/
select distinct piece,sql_text from v$sqltext where hash_value = :hash_value order by piece
/
@?/rdbms/admin/utlxplp.sql
set linesize 80
set verify on feedback on pagesize 1000

public class Hello {
public static void main(String[] args) {
System.out.println("Hello World!");
}
}

#!/usr/bin/perl
use Txu::Util;
use Data::Dumper;

#SetDebug;

unless (@ARGV >= 2){
print "Usage: ./diff_hd.pl file1 file2\n";exit;
}

open $rpt, '<', $ARGV[0]; my $r = &FileToArray($rpt,'\s*,\s*'); close $rpt; open $rpt, '<', $ARGV[1]; my $s = &FileToArray($rpt,'\s*,\s*'); close $rpt; my $c = &NewDiffCfg($r->[0], $s->[0], [0], 2);

my $d = &GetDiffArray(
$c
);