VBOX_E_FILE_ERROR (0x80BB0004) Component: Appliance Interface

Problem:

Could not open the current file in the archive (VERR_TAR_CHKSUM_MISMATCH). Result Code: VBOX_E_FILE_ERROR (0x80BB0004) Component: Appliance Interface: IAppliance {3059cf9e-25c7-4f0b-9fa5-3c42e441670b}

Scenario:

When trying to import oracle prebuilt VM into Oracle virtual box.  We encouter this exception.

Solution:

1. Check md5 checksum on the downloaded files.
2. Uncheck disk drive, usb while import.
3. Make sure Oracle virtual box version.  Make sure you import appliance into the Virtual Box mentioned on the website.

Oracle SOA Testing utilities: Wiki

Oracle SOA Testing utilities: Wiki: Home — Project Kenai



Oracle SOA Testing utilities: Wiki: ByPassExternalReferences — Project Kenai



Oracle SOA Testing utilities: Wiki: CheckoutAndRun — Project Kenai



Oracle SOA Testing utilities: Wiki: CornerCases — Project Kenai



Oracle SOA Testing utilities: Wiki: UseItFromOpenScript — Project Kenai

Can not build schema ..located at

Exception:

Exception: Can not build schema 'http://xmlns.oracle.com/ias/pcbpel/NotificationService' located at 'file:/C:/JDeveloper/mywork/SamplePOC/Project1/NotificationService.xsd'

NotificationService WSDL in MDS:

<definitions name="NotificationService_WSDL" targetNamespace="http://xmlns.oracle.com/ias/pcbpel/NotificationService" xmlns="http://schemas.xmlsoap.org/wsdl/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tns="http://xmlns.oracle.com/ias/pcbpel/NotificationService" xmlns:ns1="http://IWSDLDocument1.xsd" xmlns:java="http://schemas.xmlsoap.org/wsdl/java/" xmlns:format="http://schemas.xmlsoap.org/wsdl/formatbinding/" xmlns:plnk="http://schemas.xmlsoap.org/ws/2003/05/partner-link/">
<types>
<schema targetNamespace="http://xmlns.oracle.com/ias/pcbpel/NotificationService1" xmlns="http://www.w3.org/2001/XMLSchema" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/">
<import namespace="http://xmlns.oracle.com/ias/pcbpel/NotificationService" schemaLocation="NotificationService.xsd"/>
</schema>
<schema targetNamespace="http://xmlns.oracle.com/ias/pcbpel/NotificationService" xmlns="http://www.w3.org/2001/XMLSchema" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/">
<element name="faultMessage" type="xsd:string"/>
</schema>
</types>
<message name="IMNotificationRequest">
<part name="IMPayload" type="tns:IMPayloadType"/>
</message>


Changed NotificationService WSDL in MDS:

<definitions name="NotificationService_WSDL" targetNamespace="http://xmlns.oracle.com/ias/pcbpel/NotificationService" xmlns="http://schemas.xmlsoap.org/wsdl/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tns="http://xmlns.oracle.com/ias/pcbpel/NotificationService" xmlns:tns1="http://xmlns.oracle.com/ias/pcbpel/NotificationService/xsd" xmlns:ns1="http://IWSDLDocument1.xsd" xmlns:java="http://schemas.xmlsoap.org/wsdl/java/" xmlns:format="http://schemas.xmlsoap.org/wsdl/formatbinding/" xmlns:plnk="http://schemas.xmlsoap.org/ws/2003/05/partner-link/">
<types>
<xsd:schema>
<xsd:import namespace="http://xmlns.oracle.com/ias/pcbpel/NotificationServicexsd" schemaLocation="../../xsd/v1/NotificationService.xsd"/>
</xsd:schema>
<xsd:schema elementFormDefault="qualified">
<xsd:element name="faultMessage" type="xsd:string"/>
</xsd:schema>
</types>
<message name="IMNotificationRequest">
<part name="IMPayload" type="tns1:IMPayloadType"/>
</message>

Cause:

SOA is very strict in namespaces.  

•   Open the wsdl in JDEV to find cause of the issues.
•   Check the import schema elements for discrepencies.
•   Check if Schema being imported has same targetNamespace as the WSDL's      targetNameSpace.  Then import the same targetNamespace.

java.lang.UnsupportedOperationException: Remote JDBC disabled.

Problem:

<RuntimeException thrown by rmi server: weblogic.jdbc.common.internal.RmiDataSource.getConnection()
 java.lang.UnsupportedOperationException: Remote JDBC disabled.
java.lang.UnsupportedOperationException: Remote JDBC disabled
        at weblogic.jdbc.common.internal.JDBCServerHelperImpl.<clinit>(JDBCServerHelperImpl.java:36)
        at weblogic.jdbc.common.internal.JDBCService.initialize(JDBCService.java:91)
        at weblogic.jdbc.common.internal.JDBCService.start(JDBCService.java:137)
        at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
        Truncated. see log file for complete stacktrace

Solution:

1) Go to the Weblogic Domain Directory and edit the setDomainEnv.sh file
2) Modify WLS_JDBC_REMOTE_ENABLED value false to true.
WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=true"
3) Restart the WebLogic Servers

Reference:

http://idmoim.blogspot.com/2011/07/javalangunsupportedoperationexception.html

Find the process running on a particular port in UNIX

Lists all the ports and their process ids.

> netstat -tulpn

You can see the PID , only if the process is owned by the user that you have logged in.

To find the process id of a particular port.

> netstat -tulpn | grep 8089

udp        0      0 ::ffff:10.32.200.000:8089   :::*                                    11268/java

to find the process of this particular process id:

> ps -ef | grep 11268

Resources for Creating Certificates

https://blogs.oracle.com/blogbypuneeth/entry/steps_to_create_a_csr

https://kb.informatica.com/h2l/HowTo%20Library/1/0312_SSL_Two-Way_Configuration.pdf

Basic DB Admin tasks using local SQL PLUS

Connecting to SQL PLUS:

oracle> source /fmwapps/oracle/product/12.1.0/dbhome_1/bin/oraenv
Oracle_sid = ? [Enter SID of the instance you are trying  to connect] orcl

oracle> sqlplus

To Start the instance

SQL*Plus: Release 12.1.0.1.0 Production on Sun Jun 29 12:06:50 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Enter user-name: SYS as SYSDBA
Enter Password:  <Enter your DB password>

SQL> startup

To Shutdown the instance:

SQL> shutdown

To Find hostname of the Instance

SQL> select host_name from v$instance;

To find the port of the instance :

$ORACLE_HOME/11.2.0.3/network/admin

listerner.ora  file has port and SID.

tnsnames.ora  file has the cluster configuration for the database.

To fine the status of the listener:

lsnrctl status LISTENER