Hi all,When i try to login to Oracle Workflow Manager with the following linkhttp://localhost:7778/s...
By user502230
Hi All,Im a Jr. Database Analyst Im trying to make some documentation of ourSCM Plan for my manageme...
By mitch_gillespie_rmc
Hi All,Im a Jr. Database Analyst Im trying to make some documentation of ourSCM Plan for my manageme...
By mitch_gillespie_rmc
I'm looking for references and advice on the best way to managetable schema and stored procedur...
By mark_harrison
Hello allI have just installed instantclient 10.2 in a new workstation, OS is Win2K Professional. In...
By clapidus
Hi,I have a table, mytable (id number, refid varchar2(64), clob text)where refid (a project identifi...
By morten
Please somebody let me know the step by step procedure to create the connection of Developer 2000 Fo...
By user563663
Hi, oracle gurus.I run a query in two databases (the data and the structure are absolutly indentical...
By developer, 2 Comments
Hi, I have the following script...declare l_mail_conn utl_smtp.connection;begin l_mail_conn := utl_s...
By sam_cit_yahoo_c_, 4 Comments
Hi,I want to execute the followingCREATE OR REPLACE DIRECTORY mydir AS 'C:\temp'declare ou...
By michal, 1 Comments
Dear All, I have created a batch file which will Export the Logical Oracle dump everyday of the week...
By capt_jack, 2 Comments
Hi !!!I got it problem, since i executed the follow:analyze table HEADER compute statisticsanalyze t...
By gbelini, 2 Comments
Hi All,Greetings,OS-sunsolarisoracle 8.0.6when i try connecting sqlplus with user name and password....
By aadil, 1 Comments
I have install 10gExpress. I opened up the SQL Command Line window, which I think should be same as ...
By user587971, 2 Comments
Hi all,I have a performance problem with a query which took around 30shere is the query :SELECT Coun...
By user577903, 3 Comments
it looks like the patch #5508302 should solve this - I should better search metalink before I post new topic next time :)
filip_aps_cz | Sat, 23 Feb 2008 18:35:00 GMT |
Interesting....
We had this same problem and Oracle said that it was due to the version of the JDBC driver failing to deal with trailing null collumns on an upload and got us to upgrade the server JDBC driver. Fixed the problem ok, and not seen this patch before
garyw | Sat, 23 Feb 2008 18:36:00 GMT |
hmmm... sounds curious.. I just applied the patch so I hope it won't break anything. what version of JDBC driver did you upgrade to?
filip_aps_cz | Sat, 23 Feb 2008 18:37:00 GMT |
If you are using iAS, you should be at 10.1.0.4.2 but the one that is recommended is 10.1.0.5
rekounas | Sat, 23 Feb 2008 18:39:00 GMT |
I'm running mobile server in standalone mode (oc4j), so no iAS.. On our 10.2.0.2 production server I can see "JDBC Version 9.0.1.5.0" on mobile server home page, so I should probably upgrade the driver. How can I do it?
filip_aps_cz | Sat, 23 Feb 2008 18:39:00 GMT |
Hi,
Interesting..
We had this same problem and Oracle said that it was due to the version of the JDBC driver failing to deal with trailing null collumns on an upload and got us to upgrade the server JDBC driver. Fixed the problem ok, and not seen this patch before
This i found in one of your reply...
How can i Upgrade JDBC Driver ???
paninie | Sat, 23 Feb 2008 18:40:00 GMT |
I am assuming iAS, but it should be similar if you are using OC4J. You are probably also experiencing bug "5508302" and require the one-off patch of the same number 5508302.
Create a new directory to put the new JDBC libraries:
$ mkdir $ORACLE_HOME/jdbc/jdbc92
2. Put new JDBC libraries and jar files in the new directory you created
3. Edit the $iAS_ORACLE_HOME/opmn/conf/opmn.xml file to include/modify the -Djava.ext.dirs java option to the OC4J instance that you want it to use the new JDBC Drivers:
-Djava.ext.dirs=<path_to_the_AS_OH>/jdbc/jdbc92
This step can also be achieved using the -Xbootclasspath/a: java option:
UNIX Syntax:
-Xbootclasspath/a:<path_to_the_AS_oracle_home>/jdbc/jdbc92/classes12dms.jar:
<path_to_the_AS_oracle_home>/jdbc/jdbc92/dms.jar
Windows Syntax:
-Xbootclasspath^/a:O:\path\to\AS\oracle\home\jdbc\jdbc92classes12dms.jar;
O:\path\to\AS\oracle\home\jdbc\jdbc92\dms.jar
4. Propagate changes to your DCM repository:
$ dcmctl updateconfig -ct opmn
5. Stop/Start your OC4J instance:
$ opmnctl stopproc process-type=<oc4j_instance_name>
$ opmnctl startproc process-type=<oc4j_instance_name>
rekounas | Sat, 23 Feb 2008 18:41:00 GMT |