The logon failed.

[yogeswari]

Hi,

When i try to connect in FM getting the below error:
QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: USHH_CM
UDA-SQL-0432 Unable to locate the gateway "cogudaor".

So i done googling and so i observed to do this:

Set the TNS_ADMIN in your windows environment variables, to the path to your tnsnames.ora file and then re-start the server.
Example: TNS_ADMIN:=oracle client
install/product/product_version/Client_1/NETWORK/ADMIN
Steps:
1. In Windows, right-click 'My Computer' icon and select 'properties'.
2. Click on the 'Advanced' tab.
3. Click on 'Environment Variables'.
4. Under the 'System Variables' pane, search for the TNS_ADMIN environment variable.
5. Click 'edit' and modify the TNS_ADMIN to include the correct path to the tnsnames.ora file and click 'OK'.

Here what is tnsnams.ora file and how do it get it??

Also is there problems with FM because i tried this with my collegue FM but it is working good in there but throwing error for me?  What should be done? Also attaching the properties section in my computer to add environemnt variable.  please look.

Please suggest on this as i am very new to this.

thanks,
yogeswari.

[navissar]

This sounds indeed a lot like an Oracle client issue.
To answer your question: tnsnames.ora is an Oracle configuration file which basically gives Oracle client a "dictionary" of connection strings, so instead of always ordering it "connect to the database named such-and-such in server this-and-that", you order it to connect to database blabla. Oracle then goes to the tnsnames.ora file and looks for blabla, where the connection string is written.

Here's what you need to check:
1. Is there an Oracle client installed on your machine? If not, ask IT or whoever is responsible for that to install an Oracle client 32-bit of a matching version to your database.
2. Is the Oracle client installed the same version as your database? Is it 32-bit? It has to be both.
3. If it's installed, where is it installed? Once you know where your Oracle installation is, you can easily find your tnsnames.ora file.

Good luck!

[yogeswari]

Thank you for your response.

But i cannot connect to sample package too.

Attaching the screenshot for your references.  Could anyone provide your suggestions for this, as i am breaking for this for many days.

thanks,
yogeswari.

[yogeswari]

sry missedout the attachment.

[navissar]

Samples are also restored to a DB, and based on "cogudaor" in the error message I'm guessing this is an Oracle database (COG - That's Cognos, UDA - That's Universal Data Access, OR - Well, that says to me we're talking about Oracle... :)). So the same answer applies: Check that you have a 32 bit installation of an Oracle client of a matching version installed on your machine and direct the env. path towards the tnsnames.ora file.

[yogeswari]

Hi,

thanks again for the response.
i tried to find the tnsnames file.
then what to do.
Also in mycompute-->properties-->advanced settings-->system variable--> there is no variable like TNS_ADMIN in my system.

Also i am using VD.

Please advise now as i would consider your help as great.

thanks,
yogeswari.

[navissar]

Hey there,
I can't see how we can help from afar on this. Have a DBA or an IT person look into whether you have an Oracle client installed, and how it is configured.

[yogeswari]

Hi Nimrod Avissar,

thank you much for your prompt responses.
it is working fine now.

thanks,
yogeswari.