Weblogic: Create new and start up Managed Server

Create a new managed Server
1. Go to console.
2. Click Environment => Servers => New
3. Give a new name and use different port from other servers.
4. Save

Add library into new managed Server:
1. Go to console
2. Click on Deployment => adf.oracle.domain(1.0,11.1.1.0.0) => Target
3. Choose new managed server
4. Save
5. Repeat the 1-4 actions on library:

• adf.oracle.domain.webapp(1.0,11.1.1.1.0)
• jsf(1.2,1.2.9.0)
• jstl(1.2,1.2.0.1)
• ohw-rcf(5,5.0)
• ohw-uix(5,5.0)
• UIX(11,11.1.1.1.0)
• oracle.adf.dconfigbeans(1.0,11.1.1.0.0)
• oracle.adf.management(1.0,11.1.1.1.0)
• oracle.dconfig-infra
• oracle.jrf.system.filter
• oracle.jsp.next(11.1.1,11.1.1)
• oracle.sdp.client(11.1.1,11.1.1)
• oracle.soa.workflow.wc(11.1.1,11.1.1)
• oracle.webcenter.framework(11.1.1,11.1.1)
• oracle.webcenter.framework.view(11.1.1,11.1.1)
• oracle.webcenter.jive.dependency(11.1.1,11.1.1)
• oracle.webcenter.skin(11.1.1,11.1.1)
• oracle.wsm.seedpolicies(11.1.1,11.1.1) – only if you have installed Oracle Webservices Manager.
• oracle.portlet-producer.jpdk(11.1.1,11.1.1)
• oracle.portlet-producer.wsrp(11.1.1,11.1.1)
• DMS application
• wsm-pm

6. Go to console => Environment/Startup and Shutdown Classes:

7. Choose each item and add target to new managed server.

Start up new server on Windows:
1. Start up the domain
2. Go to %oracle_home%/user_projects/domains/[your domain]/bin
3. Create a shortcut on startManagedWebLogic.cmd on Desktop
4. Go to properties on the shortcut => Shortcut tab
5. Add [manage server name] & into target like C:/..../startmanagedWebLogic.cmd newManagedServer &
6. Double click on Shortcut.

Following is from 

http://www.orafmwschool.com/webcenter-custom-managed-server/

Oracle recommends creating a separate MDS schema to store custom Webcenter application metadata. Using existing MDS schemas may corrupt seeded repositories.

1. Run rcu from RCU_HOME/bin folder. Skip the first screen.
2. Specify Database connection parameters in the next step.
3. From “Select Components” screen, specify “ORAFMWSCHOOL” for “Create a new Prefix”. Select Oracle AS Repository Components –> AS Common Schemas –> Metadata Services. Click Next.
4. Enter schema password and confirm the same.
5. Click Next and then Finish.

This creates ORAFMWSCHOOL_MDS schema in the database.

Login to Enterprise Manager console using http://localhost:7001/em

Click on “Metadata Repositories” link from left sidebar.

Click on “mds-soa” to bring up SOA MDS repository detail screen. From “Metadata Repository” menu under mds-soa, select Administration –> Register/Deregister.

From Database Repositories section, click on “Register…”. Enter database details and click on Query.

Select ORAFMWSCHOOL_MDS from the list of displayed Metadata Repositories. Enter a Repository Name and Schema password we created in Step 2.

This completes registration of repository with Oracle Weblogic server domain.

ava.security.AccessControlException: access denied (java.lang.RuntimePermission createClassLoader)

System got error when you deploy EJB or War file:
ava.security.AccessControlException: access denied (java.lang.RuntimePermission createClassLoader)

Go to Admin Console => Configuration => Security
Do not check Security Manager

restart app server.

Reference to http://java.dzone.com/articles/hudson-security-manager

Db2 Backup

You have to turn on Administration Server.

C:.../> DB2ADMN SETID [username] (Enter)
C:.../> DB2ADMIN START

Then go to edit window and do the backup.
OR
CONNECT TO [schema Name];
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
BACKUP DATABASE [schema Name]TO "C:\db2data" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;
CONNECT TO [schema Name];
UNQUIESCE DATABASE;
CONNECT RESET;

JDeveloper: Save view into database

Save view into db

Oracle: Startup sequence

1. Get in SQLPlus:
C:/>sqlplus /nolog

2. Log in as sysdba
SQL> conn username/password as sysdba

3. Startup databas
SQL> startup mount;

4. Start up listener:
Go back to command line: C:/lsnrctl start

5. start instance
Log in as sysdba SQL> alter database open;

6. startup console
Go back to command line: emctl start dbconsole

Address already in use: JVM_Bind:8080

Under %JBoss folder%\server\default\deploy\jboss-web.deployer
Find a file: server.xml
Find port: 8080
Replace another unused one.

Display Map

Map hm = HashMap();
...

Set set = hm.entrySet();


Iterator i = set.iterator();

while(i.hasNext()){
Map.Entry me = (Map.Entry)i.next();
System.out.println(me.getKey() + " : " + me.getValue() );
}

Truncate Log file in SQL Server 2008: Shrink database

BACKUP log with truncate_only

DBCC SHRINKfile(2, 1, truncateonly)

BEA-000000: Rowkey does not have any primary key attributes

The Error: Rowkey does not have any primary key attributes.
Because the query for the displaying list doesn't have "Primary key".

Oracle: Check ISNUMBER

select decode(translate('A123456','1234567890','Y'),'Y','Y','N') from dual

select decode(translate('123456','1234567890','Y'),'Y','Y','N') from dual