EM Configuration issue.

bash-4.1$ emctl
EM Configuration issue. /opt/usr01/app/usr01/product/11.2.0/dbhome_1/<hostname>_orcl not found.

For above error saying missing _orcl directory, search for _orcl folder in your /opt/usr01/app/usr01/product/11.2.0/dbhome_1 and set the actual required hostname to ORACLE_HOSTNAME (typically It would be localhost)

bash-4.1$ export ORACLE_HOSTNAME=localhost
bash-4.1$ emctl (now works fine)
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
   Oracle Enterprise Manager 10g Database Control commands:
        emctl start | stop dbconsole
        emctl status | secure | setpasswd dbconsole
        emctl config dbconsole -heap_size <size_value> -max_perm_size <size_value>
       emctl status agent
       emctl status agent -secure [-omsurl <http://<oms-hostname>:<oms-unsecure-port>/em/*>]
       emctl getversion
       emctl reload | upload | clearstate | getversion agent
       emctl reload agent dynamicproperties [<Target_name>:<Target_Type>]....
       emctl config agent <options>
       emctl config agent updateTZ
       emctl config agent getTZ
       emctl resetTZ agent
       emctl config agent credentials [<Target_name>[:<Target_Type>]]
       emctl gensudoprops
       emctl clearsudoprops
 Blackout Usage :
       emctl start blackout <Blackoutname> [-nodeLevel] [<Target_name>[:<Target_Type>]].... [-d <Duration>]
       emctl stop blackout <Blackoutname>
       emctl status blackout [<Target_name>[:<Target_Type>]]....

Generate a Self Signed Certificate using Java Keytool

Run the following command to Generate a Self Signed Certificate using Java Keytool

keytool -genkey -keyalg RSA -alias selfsigned -keystore keystore.jks -storepass password -validity 360 -keysize 2048





Java EE 6 Web Services Developer Certified Expert

Exam Number: 1Z0-897 Associated Certifications: Oracle Certified Expert, Java EE 6 Web Services Developer Exam Product Version: Java EE

Duration: 90 minutes Number of Questions: 55 Passing Score: 65% View passing score policy Validated Against: format: Multiple Choice

Exam Topics:-

  Assume the following:

• Missing package and import statements: If sample code do not include package or import statements, and the question does not explicitly refer to these missing statements, then assume that all sample code is in the same package, and import statements exist to support them.
• No file or directory path names for classes: If a question does not state the file names or directory locations of classes, then assume one of the following, whichever will enable the code to compile and run:
  • All classes are in one file
  • Each class is contained in a separate file, and all files are in one directory
• Unintended line breaks: Sample code might have unintended line breaks. If you see a line of code that looks like it has wrapped, and this creates a situation where the wrapping is significant (for example, a quoted String literal has wrapped), assume that the wrapping is an extension of the same line, and the line does not contain a hard carriage return that would cause a compilation failure.
• Code fragments: A code fragment is a small section of source code that is presented without its context. Assume that all necessary supporting code exists is present and that the supporting environment fully supports the correct compilation and execution of the code shown and its omitted environment.
• Descriptive comments: Take descriptive comments, such as "setter and getters go here," at face value. Assume that correct code exists, compiles, and runs successfully to create the described effect.

TOPICS

• Create an SOAP web service in a servlet container
• Create a RESTful web service in a servlet container
• Create a SOAP based web service implemented by an EJB component
• Create a RESTful web service implemented by an EJB component
• Configure JavaEE security for a SOAP web service
• Create a web service client for a SOAP based web service
• Create a web service client for a RESTful web service
• Create a SOAP based web service using Java SE platform
• Create handlers for SOAP web services
• Create low-level SOAP web services
• Use MTOM and MIME in a SOAP web service
• Use WS-Addressing with a SOAP web service
• Configure Message Level security for a SOAP web service
• Apply best practices to design and implement web services

java.lang.UnsupportedOperationException over ant jwsc task

java.lang.UnsupportedOperationException is very much unexplained exception while build ear using 'jwsc' ant task.

The main reason is, compilation problem due to missing jars/classes for jws file provided "${WSDL_FILENAME}Service_${WSDL_FILENAME}PortImpl.java". So, make sure that all jars/classes are set to its classpath as mentioned below.

1:       <target name="build" depends="gen-serv,gen-client">

2:              <delete dir="build"/>

3:              <jwsc srcdir="${SERVER_SRC_DIR}" destdir="build/${WSDL_FILENAME}" >

4:              <jws file="${WSDL_FILENAME}Service_${WSDL_FILENAME}PortImpl.java" compiledWsdl="lib/${WSDL_FILENAME}_wsdl.jar" type="JAXWS">

5:                     <WLHttpTransport contextPath="${WSDL_FILENAME}Service" serviceUri="${WSDL_FILENAME}Port" portName="${WSDL_FILENAME}Port"/>

6:                     <zipfileset dir="." prefix="WEB-INF">

7:                            <include name="lib/${WSDL_FILENAME}_Client.jar" />

8:                     </zipfileset>

9:              </jws>

10:          <classpath>

11:                  <pathelement path="${classpath}"/>

12:                  <fileset dir="${weblogic.jar.classpath}" >

13:                         <include name="**/*.jar"/>

14:                  </fileset>

15:          </classpath>

16:          </jwsc>

17:   </target>

Oracle DB performance

There are few observations on Oracle DB Performance:-

1. Server Class Installation always faster than Desktop Class
2. DB perform better in 'AL32UTF8' character set as compare to 'WE8MSWIN1252' (Use this query SELECT * FROM NLS_DATABASE_PARAMETERS and check value against NLS_CHARACTERSET to find out DB character set)

Setting up 'yum' in Oracle Linux 6

https://blogs.oracle.com/wim/entry/setting_up_oracle_linux_6

# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ol6.repo

Alter Tablespace with new data file

    ALTER TABLESPACE DEV_MDS
    ADD DATAFILE '/home/oracle/db11203/oradata/orcl/DEV_MDS3.dbf'
    SIZE 200M
    AUTOEXTEND ON
    NEXT 200M
    MAXSIZE UNLIMITED;


select  a.tablespace_name,
round(a.bytes_alloc / 1024 / 1024) megs_alloc,
round(nvl(b.bytes_free, 0) / 1024 / 1024) megs_free,
       round((a.bytes_alloc - nvl(b.bytes_free, 0)) / 1024 / 1024) megs_used,
      round((nvl(b.bytes_free, 0) / a.bytes_alloc) * 100) Pct_Free,
       100 - round((nvl(b.bytes_free, 0) / a.bytes_alloc) * 100) Pct_used,
       round(maxbytes/1048576) Max,
      c.status, c.contents
from  ( select  f.tablespace_name,
               sum(f.bytes) bytes_alloc,
               sum(decode(f.autoextensible, 'YES',f.maxbytes,'NO', f.bytes)) maxbytes
        from dba_data_files f
        group by tablespace_name) a,
      ( select  f.tablespace_name,
               sum(f.bytes)  bytes_free
        from dba_free_space f
        group by tablespace_name) b,
      dba_tablespaces c
where a.tablespace_name = b.tablespace_name(+)
and a.tablespace_name = c.tablespace_name
union all
select h.tablespace_name,
       round(sum(h.bytes_free + h.bytes_used) / 1048576) megs_alloc,
       round(sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) / 1048576) megs_free,
       round(sum(nvl(p.bytes_used, 0))/ 1048576) megs_used,
       round((sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) / sum(h.bytes_used + h.bytes_free)) * 100) Pct_Free,
       100 - round((sum((h.bytes_free + h.bytes_used) - nvl(p.bytes_used, 0)) / sum(h.bytes_used + h.bytes_free)) * 100) pct_used,
       round(sum(decode(f.autoextensible, 'YES', f.maxbytes, 'NO', f.bytes) / 1048576)) max,
      c.status, c.contents
from   sys.v_$TEMP_SPACE_HEADER h,
       sys.v_$Temp_extent_pool p,
       dba_temp_files f,
     dba_tablespaces c
where  p.file_id(+) = h.file_id
and    p.tablespace_name(+) = h.tablespace_name
and    f.file_id = h.file_id
and    f.tablespace_name = h.tablespace_name
and f.tablespace_name = c.tablespace_name
group by h.tablespace_name, c.status, c.contents
ORDER BY 1