Thursday, June 25, 2009
You need to create a view in the source DB to convert the lob to string using either view or materialized view.
or same as below, create a function / procedure to convert the lob to string.
you can use the following to workaround the issue.
create or replace function lobconverterproc
( col1 in varchar2) return varchar2
SELECT FYDSCR INTO var1 FROM tablename
select lobconverterproc('Test') from dual;
Monday, June 22, 2009
Other issue, is that it could be a bug as in the note “java.lang.NoClassDefFoundError: org/apache/log4j/Category After Upgrading from 10.1.3.1.0” ,Note ID : 460448.1
To resolved this follow the guide here
Sunday, June 21, 2009
2. For the Oracle® Containers for J2EE Configuration and Administration Guide, Using the admin_client.jar Utility please refered the link here.
3. Another important consideration in when migrating is that the default behaviour of the 10.1.3. 10.1.10 Invocation by Servlet Name without Mapping Is Disabled by Default
The 10.1.3.x Oracle Containers for J2EE Servlet Developer's Guide notes that by default, servlet invocation by class name is now disabled, but can be enabled through the property setting
-Dhttp.webdir.enable=true. (Servlet invocation by class name was enabled by default in versions 10.1.2.x and prior.)
What is similar, but undocumented, is that this also applies to invoking a servlet through its
value when there is no corresponding
entry. Invoking a servlet through its servlet name in this way was enabled by default in 10.1.2.x and prior, but requires the setting
-Dhttp.webdir.enable=true in 10.1.3.x versions.
For example, consider the following
web.xml entry, with no corresponding
In 10.1.2.x, you could access this servlet using
/servlet/TestIt without any property setting. In 10.1.3.x, you must set
-Dhttp.webdir.enable=true to access the servlet in this way with the given configuration.
Sunday, June 07, 2009
If you encounter these error "REP-56040: Server rep_
In MS Windows: %ORACLE_HOME%\bin\rwdiag.bat -findall
In Unix: $ORACLE_HOME/bin/rwdiag.sh -findAll
Broadcast mechanism used to locate servers------------------------------------------
Channel address = 220.127.116.11 Channel port = 14021
(1) Name =
(2) Name =
(3) Name =
(4) Name =
notice, that the report server services appear on the different hostname. In the rwservlet.trc,
Exception 51002 (): Bind to Reports Server
There's two way to resolve this , 1 way is to set different report_server name compare with other server or 2 , changing the naming method in the $ORACLE_HOME/reports/rwnetwork.conf
Uncoment the multicast and enabled the naming method. e.g.
multicast channel="18.104.22.168" port="14021" timeout="1000" retry="3"/
!--namingService name="Cos" host="%NAMING_HOST%" port="%NAMING_PORT%"/--
!-- multicast channel="22.214.171.124" port="14021" timeout="1000" retry="3"/--
namingService name="Cos" host="testserver" port="14021"
- Intermittent REP-51002 or REP-56040 and Same Repserver is Displayed Multiple Times in Rwdiag.sh Output, Note ID :563367.1
-REP-51002 And Rep-56040 if More than one OC4J_BI_FORMS Instance is Created, Note ID : 390412.1