Oracle SOA:Stop and start command

Middleware/user_projects/domains/soa_domain/bin/stopWebLogic.sh &
Middleware/user_projects/domains/soa_domain/bin/stopManagedWebLogic.sh soa_server1 &
Middleware/user_projects/domains/soa_domain/bin/stopManagedWebLogic.sh bam_server1 &


Middleware/user_projects/domains/soa_domain/bin/startWebLogic.sh &
Middleware/user_projects/domains/soa_domain/bin/startManagedWebLogic.sh soa_server1 &
Middleware/user_projects/domains/soa_domain/bin/startManagedWebLogic.sh bam_server1 &

Oracle SOA: Install with error RCU-6107 DB Init Param Prerequisite failure for processes current value

If you have this error:

RCU-6107 DB Init Param Prerequisite failure for processes current value

1. Connect to the database and open SQL*plus
run: SQL> alter system set processes=300 scope=spfile;

2. find a file name: init.ora under "spfile" folder, Change parameter open_cursors=500
and find the config/scripts/initXEtemp.ora , Change parameter open_cursors=500

Weblogic: heap size

Change file setting on C:\Oracle\Middleware\jdeveloper\jdev\bin\jdev.conf
Or just find the file in JDeveloper folder.

DB2: View lock on table and kill session

get snapshot for locks on

LIST APPLICATION

FORCE APPLICATION (13347)

13347 is Application ID.

Connect EJB from other client to Weblogic

Please include following JAR file:
Creating a wlfullclient.jar for JDK 1.6 client applications
Use the following steps to create a wlfullclient.jar file for a JDK 1.6 client application:

Change directories to the server/lib directory.
cd WL_HOME/server/lib
Use the following command to create wlfullclient.jar in the server/lib directory:
java -jar wljarbuilder.jar
You can now copy and bundle the wlfullclient.jar with client applications.
Add the wlfullclient.jar to the client application’s classpath.

Creating a wlfullclient5.jar for JDK 1.5 client applications
Change directories to the server/lib directory.
cd WL_HOME/server/lib
Use the following command to create wlfullclient.jar in the server/lib directory:
java -jar wljarbuilder.jar -profile wlfullclient5
You can now copy and bundle the wlfullclient5.jar with client applications.
Add the wlfullclient5.jar to the client application’s classpath..
(REMEMBER: USE JDK1.5 to generate the jar file)

Refer from http://download.oracle.com/docs/cd/E12840_01/wls/docs103/client/jarbuilder.html#wp1077742

Default URL and username for JDeveloper Integrated Weblogic Server

Here it is:
URL: http://localhost:7101/console
username: weblogic
password: weblogic1

Oracle 11g: Error on Start up

If you get Error like:
Failed to auto-start Oracle Net Listener using xxxxx
or
ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener

SOLUTION:
Update file "dbstart", change link ORACLE_HOME_LISTENER=$1 to ORACLE_HOME_LISTENER=$ORACLE_HOME

DB2: Select table Primary key and Foreign Key

Primary key

SELECT NAME
FROM
SYSIBM.SYSCOLUMNS
WHERE TBNAME = 'table name'
AND TBCREATOR = 'creator'
AND KEYSEQ > 0
ORDER BY KEYSEQ ASC

Foreign Key

SELECT B.REFTBNAME AS PARENTTABLE,COLNAME
FROM
SYSIBM.SYSFOREIGN KEYS A,
SYSIBM.SYSRELS B
WHERE A.RELNAME = B.RELNAME
AND B.TBNAME = 'table name'
AND B.REFTBCREATOR = 'creator'
AND B.REFTBCREATOR = A.CREATOR

SQL: not match from table 1

SELECT TestTable1.ID, TestTable1.Name, TestTable1.Title
FROM TestTable1 LEFT JOIN TestTable ON TestTable1.[Name] = TestTable.[Name]
WHERE (((TestTable.Name) Is Null));

SharePoint: The trial period for this product has expired.

Method 1:
Go to: http://support.microsoft.com/kb/971620/en-us
(When you install the 2007 Microsoft Office servers Service Pack 2, the product expiration date is activated incorrectly) and follow the document.

Method 2:
Added application pool Account ("dcomcnfg.exe") to the Distributed users
(Add the Application Pool account to the built-in Active Directory group "Distributed COM Users".)
1. Go to Application Pool and see what's the account which can access this Application pool.
2. Go to Active Directory and find the group named "Distributed COM Users". Add the application pool account to that group.