Friday, July 18, 2014

How to unlock specific User in Oracle Database


Make sure you have installed Oracle Database already installed on your machine. For individual development purpose, Oracle has Express Edition light weight database s/w, that you can download and install on your machine.

- Connect to SQL Command Line prompt
    Start -> All Programs ->  Oracle Database <Version> Edition -> Expand -> SQL Command Line

-  Execute below command
                     SQL> connect / as sysdba

- You should notice as below

- Execute Below commands
          ALTER USER HR IDENTIFIED BY HR;
          ALTER USER HR ACCOUNT UNLOCK;


Tuesday, July 15, 2014

Unable to obtain credential store using jps-config



If you notice below error in your Jdeveloper, follow below solution to resolve.

Unable to obtain credential store using jps-config



Solution : Take backup of 'cwallet.sso' and delete this file from /Application/src/META-INF/

Configuring OHS Server Configuration files


What is httpd.conf file ?

This is a server configuration file which typically contains directives that affect how the server runs, such as user and group IDs it should use, and location of other files. Because the server configuration file is the main file that the server starts with, Oracle HTTP Server does not include any directive that says where to locate it. The location is passed on command line when the server starts.

Location :
Example :
/<box_name>/admin/ohs_instances_fm042/config/OHS/ohs1

Follow below link for more information

http://docs.oracle.com/cd/B12037_01/server.101/b12255/conffile.htm

mod_wl_ohs.conf : This file contains all the EM/CS related entries

http://docs.oracle.com/cd/E29542_01/webcenter.1111/e27738/wcadm_documents.htm#WCADM10693

Wednesday, July 2, 2014

Error: An unreported error occurred in Appc. No errors were reported, but the tool returned a failure result code: 1.



If you encounter below error while running your ADF app locally, add below code in web.xml just before </web-app> and it should resolve this compilation error.


Error: An unreported error occurred in Appc. No errors were reported, but the tool returned a failure result code: 1.

 <jsp-config>
        <jsp-property-group>
            <url-pattern>*.jsff</url-pattern>
            <is-xml>true</is-xml>
        </jsp-property-group>
    </jsp-config>