cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle TNS 12535 error after moving repository DB from Win NT to Win 2K

Former Member
0 Kudos

Business Objects 5.1

We have recently moved an Oracle database from Windows NT to Windows 2000. One particular user keeps on getting ORA-12535: TNS: operation timed out.

What could be causing this?

The user can run SQL*Plus and connect to the database without any problems.

The user gets this error when running BO itself. When running our Application or any other Oracle tool or utility (TOAD, SQL*Plus), etc, then all works fine.

From my own PC I can use the 'problem' users BO login to connect to the repository.

So the nature of the problem suggests a network or configuration issue of some kind. We have limited BO expertise at this site.

Please can someone advise?

regards,

MK

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Mo,

If the previous solution provided doesnu2019t works then check the following things:

1. Check the ORACLE_HOME value in the Registry and ensure that your PC has only one "ociw32.dll" file.

2. Confirm that the PATH environment variable definition's first Oracle /bin folder path points to the middleware

installation you intend Supervisor to use.

3. Add the repository database server's IP address to the local HOSTS file.

4. Confirm the repository database's entry in the Oracle TNSNames.ora file.

Regards,

Sarbhjeet Kaur

Former Member
0 Kudos

Hi Mo,

Information about all users, groups and profiles of BO Users is stored in the Security domain of

BO repository.

If the issue occurs only for a particular user, then that user information might be corrupted in

any one of the Repository tables.

Could you please remove and add the group to the user profile.

It inserts the correct information into the repository.

Then your user might be able to run the application successfully after removing and adding

the group.

Regards,

Sarbhjeet Kaur