Since I’ve spent a day sweating through this mess, I’d share my way of getting ODI to work with XE as a repository.
ODI repository creation is sucessfull, but after that Topology Manager and all other ODI modules won’t work, throwing
ORA-12705: invalid or unknown NLS parameter value specified while connecting to XE.
There are 3 java connections to repository in ODI:
-Duser.language=en -Duser.region=US) for tomcat solved this one.
-Duser.language=en&-Duser.region=USto odiparams, I’ve created a new wrapper configuration file (stored in ODI_HOME\tools\wrapper\conf) by copying snpsagent.conf to and adding this options to line
so it read
wrapper.java.additional.1=-Djava.security.policy=server.policy -Duser.language=en -Duser.region=US
reinstalling agent with the new wrapper conf file (you explicitly run
agentservice -i -s agent\_name 20910 new\_wrapper) worked.
See related Metalink Note: 471749.1