Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Last night I installed sp3 and cu1 on a 64 bit SQL 2005 failover cluster.

Everything went well. Reporting services is installed on the primary node.

It now cannot connect to Oracle. The initial errors seemed to be related to this: http://support.microsoft.com/default.aspx?scid=KB;en-us;870668

I granted network service access, but that didn't change anything. I then made it like development (which is working fine, unfortunately), which meant adding authenticated users to the bin and admin\network folders.

This gave us a new error.

ORA-12705: Cannot access NLS data files or invalid environment specified

Most posts on the web say this should happen in sqlplus as well. It does not.

We have Oracle 10g and 9 drivers installed on this server. The 9 drivers are 32 bit that SSIS is using. It seems that reporting services is using the 10 drivers.

When I added security settings to the oracle folders as directed in the link above, I did it on the 9 drivers first and we got errors in rs saying that it could not use 32 bit drivers. When I added the security settings on the 64 bit and removed 32 we started getting the NLS errors.

Thanks for any help! Posting this to both SO and SF- I'd love to hear some ideas before we call MS.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

I found several answers such as this:

http://www.dba-oracle.com/t_ora_12705_resolution.htm

Decided to rename the registry key and it worked.

I still have no idea why the permissions changed on the oracle directories.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.