i had installed BO on my machine with Oracle 8.1 and it was working properly…now Oracle 9i has been installed on the system and none of the BO products r working anymore…when i try to log in to any of the products it shows up the following errors:
Server Error(USR0057)
if i click on details it shows me
E1000||1010||
and then it shows me
Could not reach repository database.(USR0045)
I tried to login to supervisor with username:GENERAL password:SUPERVISOR and tried to do a safe recovery
and try to test the database it shows me
Setup failed!(ADW0002)
if i log in to SQL plus with the same username/password it lets me login…
checked out the tnsnames.ora and also used Home selector in Oracle to point to the right home…still very confused as to where the problem is???
any pointers…
Did you move from sqlnet to a net80 environment? the test for this is copying your TNSNames.ora / sqlnet.ora files from your current home to the other - eg
if you use oracle\network\admin copy to net80\admin
or vice versa.
Try that, then verify you can do a safe recovery. if no, what about the registry - is your oracle_home correct there?
i de-installed Oracle 8i,9i and BO…cleaned up the registry.Then installed 8i once again and then BO.Created a new user(and gave all rights) in supervisor by loggin into a machine that’s workin fine…copied the BOMain key from that machine into the loc folder of my machine…still it showed me the same error …so i used the safe recovery option(Username:GENERAL,Password:SUPERVISOR) and it replaced the BOMain key…Now i am able to log in to supervisor…but cannot log in to either Designer/Business Objects(even though the user has rights)…gives me the error messages USR0057 and USR0045 if i try to log in to either Designer or Business objects…
other details:
there is only one version of tnsnames.ora in my PC, i am able to access the database in SQL Plus,able to successfully ping the server,single oracle home present…
so where is it going wrong???would really appreciate if someone can tell me where the problem might be???Really running out of ideas…
That last part about using the general supervisor account makes me think that you are not hitting Oracle from any module, not just Designer. In the recovery process, could you test the connection to Oracle? What were the details.
When you reinstalled, did you get the oracle middleware? Any chance that got skipped?
Having 1 tnsnames file is ok, but where is it? What folder did it use, net80? If so, I am betting you need to make a duplicate in the network/admin folder - I found that SQL*Plus and BO use different ‘paths’ to oracle, not sure why.
while performing the recovery it connected properly to Oracle…did not give any errors…
while installation of BO it checked the middleware as well…the contents of chkmidw.log file are as follows:
Starting to check if the middleware components are correctly installed (Oracle 7, ORACLE).
ORACLE_HOME… ok.
Path…
The value does not include the required elements (d:\Oracle\Ora81\bin;C:\Program Files\Oracle\jre\1.1.7\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;d:\Program Files\Metastorm e-Work\Engine;d:\Oracle\Ora81\orb\bin).
The middleware is not correctly installed (Oracle 7, ORACLE).
Starting to check if the middleware components are correctly installed (Oracle 8, ORACLE).
LAST_HOME… ok.
ORACLE_HOME… ok.
Path… ok.
ociw32.dll… ok.
The middleware checking has not detected any errors (Oracle 8, ORACLE).
Starting to check if the middleware components are correctly installed (SQL Server ODBC, MICROSOFT).
Driver… ok.
C:\WINDOWS\System32\SQLSRV32.dll… ok.
The middleware checking has not detected any errors (SQL Server ODBC, MICROSOFT).
strange since there is no Oracle 7 installed in my system…don’t know why it gives the message saying that middleware is not proper for Oracle 7
also checked the services running…one of them is OracleOraHome91TNSListener…i don’t know why it’s still ther when i hav uninstalled 9i completely…is this where the problem is…now my PC has only Oracle Client 8i…
btw tnsnames.ora file is in D:\Oracle\Ora81\network\ADMIN which i believe is proper…
uninstalled Oracle,BO and again installed it…inserted the path in Registry for Oracle…don’t know why it was not there…this time during the middleware check…evrythin was proper and now it’s workin…
somehow i believe that the middleware check is one of the most important indications of how BO is goin to repond…never has it given me a problem when the middleware check is proper…and i always end up in some kind of problem when middleware check gives some errors…
I just installed BO, had exactly the same problem as yours. When I tried to connect, got USR0057 error with details being E1000||1010||. But I can connect using SQLPLUS. So how do you exactly solve the problem, you were talking about checking the registry, I’m not quite sure I understand how. Could you please give me some advice/instructions here?
just keep a backup of the registry before you do this…
Go to Start > Run and type “regedit.” The Registry Editor window appears.
Go to HKEY_LOCAL_MACHINE > Software > Oracle.
There is a string value called ORACLE_HOME and its path on the left-hand side. It is usually the path to the Oracle install: c:\orant (Windows NT) or c:\orawin95 (Windows 95).Also check out for the paths if you have multiple oracle homes in the registry.
I had the path value missing.So check for that.If the value is missing then u should insert the path for oracle install there.
btw is ur middleware check giving you proper results…
We are upgarding to BO 6.1b and I Installed BO 6.1b client in one of my clients machine by uninstalling the Bo 5.1 and restored the bomain.key file from the server,
when i try to login to BO it is giving Server Error USR0057 Error. when i click on Details it is giving USR0045 “Cannot reach Repository Database”.
and TNS could not resove the serveice name.
I updated the tnsnames.ora file and bomain.key files
Can anybody have a solution for this,.
Oracle 9.2 server client oracle 8
Bo 6.1b production.
2 quick things to check - can you tnsping the server by adding the .world extension? eg
tnsping server.world
instead of
tnsping server ?
If so, add .world to sqlnet.ora - I always do the 2 files as a pair when I install…
If that doesn’t change anything, are you sure you’re updating the right folder with this tnsnames file? Any other Oracle instances on that box, even if they are obsolete?
If you are comfortable with regedit, you could search for ORACLE_HOME and see where it thinks that should go…
bdouglas,
I tried tnsping it is not working.I checked all entries everythis looks fine.
changes made to the right tnsnames.ora file.
Only concern is production server is 9.2 and Client m/c is using oracle 8.0
can u guide me what could be the proble.
Thanks Brent,
Its working now there was some problem with in the Tnsname.ora file.
Oracle 8.it is behaving differently when u save one time its not saving after doing it for several times it saved and its working.
Have had the USR0045 error before and always have been able to resolve it, however this time Ive got it I cant. I’ve gone through everything even the BO common connection error list. Just wondered if anyone could think of something I havent yet.
Basically, my set up is that I dont have a tnsnames but I just use the sqlnet.ora file to point me to the tnsname on a group drive. I can connect via SQL plus, however I cannot connect via BO or TOAD, it gives me the error. The funny thing is if someone else logs on to my PC they can login to BO and TOAD, but if I try and login on there PC I get the same error.
This is a work PC so I have a user profile, because others can login ok on my machine and I cant, I makes me think its profile related, but I dont understand how. Do registry settings follow a user profile at all ?
Things I have tried are,
deinstall, reintall BO and Oracle.
Cleaned out registry.
Confirmed ORACLE_HOME is correctly set
Checked the PATH to ensure Oracle is in there and is correct.
TNSPING’d the dbs and that ok, when I do this I can see its redirecting the request to the tnsnames on the shared drive.
Fixed it in end, problem was not obvious but I thought I would share it.
Basically I had a copy of the sqlnet file on my network drive, this meant that even though I had set the ORACLE_HOME correctly, it looked at the network drive for sqlnet file, because by chance I had one there it tried to use that rather than the one under Oracle. As soon as I removed the file it worked. Spotted problem in end by looking at the sqlnet.trc file under the following dir C:\Oracle\Ora920\Network\Trace
(BOB member since 2002-08-29)
(BOB member since 2002-10-04)