Ive just installed Oracle 8 client software (including Net8).
Now when I try to login I get a ‘Your login is not valid’ error message. Monitoring the repository database shows a connection being made to the database (Still a 7.3 database), proving the SQLNET link is still valid.
Additionally the SET-UP program will not run at all anymore.
Ive tried the various reinstall bits (NT service packs, B.O. etc) but nothing will clear the problem.
Any ideas?
Mike.
| British Energy plc
| Trading as Nuclear Electric Ltd
| Registered Office Barnett Way
| Barnwood Gloucester GL4 3RS
| Registered in England and Wales
| Registered No 3076445
| This email message and any attachments are confidential | and are intended for the use of the addressee only. If you | are not the addressee you should not copy or use them for | any purpose, nor disclose their contents to anyone else. | If you receive this email by mistake please notify us | immediately by telephoning +44 (0)1452 653377.
Now when I try to login I get a ‘Your login is not valid’ error message. Monitoring the repository database shows a connection being made to the database (Still a 7.3 database), proving the SQLNET link is still valid.
Any ideas?
Mike,
I have experienced the same with Oracle8 and a repository created with Net2.3. The Net8 machine gave the same error message, while Net2.3 machines logged in just fine.
May have something to to do with NLS_LANGUAGE, but I need to look a bit deeper into that.
I know this is not a solution to your problem, but just to let you know.
Oracle has removed some of the OCI calls that Business Objects uses with version 2.3.4. By installing Net 8, it upgraded your existing SQL*Net 2.3.3.x drivers to the new 2.3.4 version.
Two ways to fix this. Switch over completely to Net 8 and use only Net 8 connectivity (supported since release 4.1.1), or delete and reinstall your SQL*Net 2.3.3.x middleware.
Regards,
Cameron Meldahl
Business Objects
Technical Support
| British Energy plc
| Trading as Nuclear Electric Ltd
| Registered Office Barnett Way
| Barnwood Gloucester GL4 3RS
| Registered in England and Wales
| Registered No 3076445
| This email message and any attachments are confidential | and are intended for the use of the addressee only. If you | are not the addressee you should not copy or use them for | any purpose, nor disclose their contents to anyone else. | If you receive this email by mistake please notify us | immediately by telephoning +44 (0)1452 653377.
Your issue is due to the fact that Oracle Net 8 and Sql*Net 2.x should not be installed in the same directory. By default, they are installed in the same location, yet the drivers conflict with each other. You may notice that you can access your tables fine with your middleware, yet not with a querying tool (such as Business Objects) that expects to be able to communicate to certain drivers through certain OCI calls.
Just use the ORacle installer to Deinstall the Net8 or Sql*net files and reinstall them into a different directory. Once this is done, all should be fine.