|
Home > Archive > WebSphere Portal Server > April 2007 > Cloudscape --> Oracle failure in transfer.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cloudscape --> Oracle failure in transfer.
|
|
|
| Hello,
The current environment:
Red Hat EL 3uc8
WAS ND 6.0.2.9
WPS 6.0.0.0
We are attempting to run the DB transfer in the following manner:
/WPSconfig.sh database-transfer -Drelease.DbPassword=password -Dcustomization.DbPassword=password
-Dcommunity.DbPassword=password -Djcr.DbPassword=password -Dwmm.DbPassword=password -Dfeedback.DbPa
ssword=password -Dlikeminds.DbPassword=password
We are getting the following error:
Thu Apr 19 14:26:24 EDT 2007
Target started: action-set-jcrls-params-oracle
action-set-jcrls-params-oracle:
[gethost] Getting hostname from /ckfr/WebSphere/AppServer/profiles/***/config/cells/Cell01/nodes/***/serverindex.xml.
[gethost] <endPoint xmi:id="EndPoint_1174499181863" host="***" port="***"/>
[gethost] discovered hostname: ***
[parsedburl] Warning: Can't parse oracle URL: jdbc:oracle:thin:@(description=(address_
list=(address=(protocol=tcp)(host=***)(P
ort=****)))(connect_data=(server=dedicat
ed)(service_name=wpscfgcb)))
[parsedburl] String index out of range: -19
Target finished: action-set-jcrls-params-oracle
Target finished: database-transfer-jcr-setup-oracle
Target finished: action-database-transfer-jcr-setup
Target finished: action-init-jcr-db-transfer
Target finished: database-transfer-domain-jcr
Target finished: database-transfer-domains
Target finished: database-transfer
| |
|
| amcoelho@checkfree.com a écrit :
> Hello,
> The current environment:
> Red Hat EL 3uc8
> WAS ND 6.0.2.9
> WPS 6.0.0.0
>
> We are attempting to run the DB transfer in the following manner:
> /WPSconfig.sh database-transfer -Drelease.DbPassword=password -Dcustomization.DbPassword=password
> -Dcommunity.DbPassword=password -Djcr.DbPassword=password -Dwmm.DbPassword=password -Dfeedback.DbPa
> ssword=password -Dlikeminds.DbPassword=password
>
> We are getting the following error:
> Thu Apr 19 14:26:24 EDT 2007
> Target started: action-set-jcrls-params-oracle
>
> action-set-jcrls-params-oracle:
> [gethost] Getting hostname from /ckfr/WebSphere/AppServer/profiles/***/config/cells/Cell01/nodes/***/serverindex.xml.
> [gethost] <endPoint xmi:id="EndPoint_1174499181863" host="***" port="***"/>
> [gethost] discovered hostname: ***
> [parsedburl] Warning: Can't parse oracle URL: jdbc:oracle:thin:@(description=(address_
list=(address=(protocol=tcp)(host=***)(P
ort=****)))(connect_data=(server=dedicat
ed)(service_name=wpscfgcb)))
> [parsedburl] String index out of range: -19
> Target finished: action-set-jcrls-params-oracle
> Target finished: database-transfer-jcr-setup-oracle
> Target finished: action-database-transfer-jcr-setup
> Target finished: action-init-jcr-db-transfer
> Target finished: database-transfer-domain-jcr
> Target finished: database-transfer-domains
> Target finished: database-transfer
>
Hi,
Try changing your URL in wpconfig.properties by
jdbc:oracle:thin@host:port:wpscfgcb
Regards,
| |
|
|
> Hi,
> Try changing your URL in wpconfig.properties by
> jdbc:oracle:thin@host:port:wpscfgcb
> Regards,
>
Hi,
Thanks for the response,
I the jdbc string used, is what our Oracle DBA team advises us to do. (I did attempt to change the url, to the format you are specifying above, but, it actuatlly is failing on the validation parts)
What's intresting is that we are able to pass all the validation tests: (All the tests below are successfull with our URL)
/WPSconfig.sh validate-database-connection-wps -Drelease.DbPassword=password -Dcustomization.DbPassword=password -Dcommunity.DbPassword=password -Djcr.DbPassword=password
/WPSconfig.sh validate-database-connection-jcr -Djcr.DbPassword=password
/WPSconfig.sh validate-database-connection-feedback -Dfeedback.DbPassword=password
/WPSconfig.sh validate-database-connection-likeminds -Dlikeminds.DbPassword=password
/WPSconfig.sh validate-database-connection-wmm -Dwmm.DbPassword=password
/WPSconfig.sh validate-database-driver
But when we attempt to run the transfer part:
/WPSconfig.sh database-transfer -Drelease.DbPassword=password -Dcustomization.DbPassword=password -Dcommunity.DbPassword=password -Djcr.DbPassword=password -Dwmm.DbPassword=password -Dfeedback.DbPassword=password -Dlikeminds.DbPassword=password
It appears to transfer the release, customization, and the community, but, once it attempt the jcr part, we get that cryptic error above.
It looks like 5.1 of portal may have also had this issue:
http://www-1.ibm.com/support/docvie...uid=swg21229390
But, I checked with our DBA, and he has the
java_pool_size set to 200MB vs 12MB in that document above. (Should be more than enough)
I do have a call open with support, and, if we can resolve it, I hope to post the results here.
Thanks,
|
|
|
|
|