oracle driver

Hi All,

I am trying to setup a odbc connection for oracle server my tnsnames.ora which is in C:\app\oracle\product\11.2.0\client_1\Network\Admin
and here is the connection settings
ORA11 =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(Host = 10.1.100.113)(Port = 1521))
   )
 (CONNECT_DATA =
   (SERVICE_NAME = ADVA)
 )
)

when i am trying to setup i am under odbc
i am tring to enter
datasource name: history
tns service name10.1.100.113
username: $username
and click on test connection
service name: AVDA
username: $username
password:$password

i am getting an error saying
ORA-12154: TNS:could not resolve the connect identifier specified.

can someone help me please.
romeiovasuAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johnsoneSenior Oracle DBACommented:
For TNS service name, you should use ORA11.  That is the name of the entry in your tnsnames.ora file.
0
romeiovasuAuthor Commented:
it doesnt work if i use ORA11

but if i type 10.1.100.113/ADVA then it works.
0
slightwv (䄆 Netminder) Commented:
>>my tnsnames.ora which is in C:\app\oracle\product\11.2.0\client_1\Network\Admin

Are you using the ODBC drivers installed under C:\app\oracle\product\11.2.0\client_1?
In other words: Do you only have the one Oracle product installed on the machine?
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

DavidSenior Oracle Database AdministratorCommented:
The lines following the first must be indented at least one space.
0
romeiovasuAuthor Commented:
i didnt understand.
0
slightwv (䄆 Netminder) Commented:
Didn't understand which post?
0
romeiovasuAuthor Commented:
by yours only.

>>my tnsnames.ora which is in C:\app\oracle\product\11.2.0\client_1\Network\Admin

Are you using the ODBC drivers installed under C:\app\oracle\product\11.2.0\client_1?
In other words: Do you only have the one Oracle product installed on the machine?
0
slightwv (䄆 Netminder) Commented:
I was asking if you had more than one set of Oracle drivers installed on the computer.

Did you download and install a separate ODBC driver in a different folder?
0
romeiovasuAuthor Commented:
no this is the only one we have.
0
slightwv (䄆 Netminder) Commented:
>>and click on test connection  service name: AVDA

Service name on test should be ORA11 as well.

That is the 'alias' specified in the tnsnames.ora file.  When using the tnsnames.ora file, you need to only reference the 'alias'.

>>but if i type 10.1.100.113/ADVA then it works.

This likely uses EZConnect and bypasses the tnsnames.ora file.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
romeiovasuAuthor Commented:
how can i force to use ORA11 only.
0
slightwv (䄆 Netminder) Commented:
>>how can i force to use ORA11 only.

I don't think you can force connections to only use tnsnames and ignore EZConnect.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.