We help IT Professionals succeed at work.

oracle client issue (again)

pma111
pma111 asked
on
My credentials – not an oracle tech nor a DBA

My issue – I have just got a new PC, on my old PC (windows XP) I used to have a tool to query our oracle database. This tool is similar to TOAD from bentic software:

http://www.benthicsoftware.com/products.html

I have installed the the quiery software fine. The full oracle client fine. I have also copied over tnsnames.ora file to the required directory.

Now, in the drop down box in the query tool it lists all available databases. However, when I supply the correct login credentials, I am met with a:

ORA 12154 error – could not resolve the connect identifier specified?

I am not sure if the database has IP restrictions which devices could connect – but if not – any idea where I am gong wrong.

Please keep your answers basic.
Comment
Watch Question

Database Analysist Senior
Commented:
check that your client is able to communicate to server i.e

in command prompt try tnsping connect_string_name

i.e

c:>tnsping DBname

Author

Commented:
Will it need hostname or just the SID, i.e. production? or \\oracleserver\production

Thanks

Author

Commented:
Output as follows:

H:\>tnsping

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 02-NOV-2
011 12:08:15

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

TNS-03502: Insufficient arguments.  Usage:  tnsping <address> [<count>]

H:\>tnsping prod2

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 02-NOV-2
011 12:08:41

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:
C:\oracle\product\10.2.0\client_2\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=removed)(PO
RT=1525)) (CONNECT_DATA= (SID=PRODUCTION)))
OK (120 msec)

H:\>
Praveen Kumar ChandrashekatrDatabase Analysist Senior

Commented:
you are selecting same "prod2" in your third party tool right?

can you send the screen shot of your third party tool.

you can also try in command prompt.

H:\>sqlplus

userid :your login_id@prod2
password: *****

let us know that u r able to connect.

Author

Commented:
Yeah prod2

I tried the sql plus way and get the exact same error.
SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
Copy your sqlnet.ora file from the old machine as well.

It might be a domain issue.
Praveen Kumar ChandrashekatrDatabase Analysist Senior

Commented:
check in your tool that it is reffering to which tnsname.ora file for connection.

also check this doc

http://www.benthicsoftware.com/support.html

Author

Commented:
Can you go into more detail on domain issue?

I will copy over sqlnet.ora as well
SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:

Author

Commented:
Not sure if this could be an issue - but I appear to home 2 oracle homes!

One I think is just the instant client and another is the full client.

in start > programs it lists both

oracle - oraclinet10g_home1
oracle - oraclient10g_home2

Could this be the problem?

Author

Commented:
All the sqlnet.ora file says (it is on both machines) is:

--

# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\client_2\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
>>but I appear to home 2 oracle homes!

Yes.

Do you need both homes?  If not, remove one.

If you need both, the easiest fix here is:

Merge the tnsnames.ora files from both into a single one then copy that one into both homes.

Author

Commented:
By remove one is at as simple as deleting it from the file system?
SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
The instant client, yes.

The full client, no.  Run the installer.  It will allow you to remove the products.

Author

Commented:
SOmething I just spotted. The NTFS on my admin folder in which tnsnames.ora resides.

I only have list folder contents and read permissions.

Could this be an issue.

On a collegues they have full access on this folder to everyone group.

I dont have local admin rights on this PC.
SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
Read access should be fine.

>>I dont have local admin rights on this PC.

Then how did you install the full client?

Author

Commented:
I didnt.

Our IT support did.

I am just data analyst
SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
I would suggest merging the entries in the two tnsnames.ora files and keep both installs since they are already done.

Author

Commented:
In the client 1 "home" (the instant client) there is no tnsnames.ora file to merge with the other. There is only a tnsnames.ora file in C:\oracle\product\10.2.0\client_2\NETWORK\ADMIN

I am tempted to aks them to remove both off the system and reinstall the full client again and copy over the tnsnames.ora from another PC.

Its driving me mad now.
SILVER EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
in client1, manually create a network\admin folder and copy the tnsnames.ora and sqlnet.ora in there.
Praveen Kumar ChandrashekatrDatabase Analysist Senior

Commented:
>>remove both off the system and reinstall the full client again and copy over the tnsnames.ora from another PC<<

i think this will be best as it avoid confusion.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.