Pau Lo
asked on
oracle client issue (again)
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.
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.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
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\c
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HO
RT=1525)) (CONNECT_DATA= (SID=PRODUCTION)))
OK (120 msec)
H:\>
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\c
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HO
RT=1525)) (CONNECT_DATA= (SID=PRODUCTION)))
OK (120 msec)
H:\>
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.
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.
ASKER
Yeah prod2
I tried the sql plus way and get the exact same error.
I tried the sql plus way and get the exact same error.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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
also check this doc
http://www.benthicsoftware.com/support.html
ASKER
Can you go into more detail on domain issue?
I will copy over sqlnet.ora as well
I will copy over sqlnet.ora as well
The docs explain it better than I can:
http://download.oracle.com/docs/cd/E11882_01/network.112/e10835/sqlnet.htm#CIHJDJHD
http://download.oracle.com/docs/cd/E11882_01/network.112/e10835/sqlnet.htm#CIHJDJHD
ASKER
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?
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?
ASKER
All the sqlnet.ora file says (it is on both machines) is:
--
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\c
# 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_SERV
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
--
# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\c
# 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_SERV
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
>>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.
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.
ASKER
By remove one is at as simple as deleting it from the file system?
The instant client, yes.
The full client, no. Run the installer. It will allow you to remove the products.
The full client, no. Run the installer. It will allow you to remove the products.
ASKER
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.
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.
Read access should be fine.
>>I dont have local admin rights on this PC.
Then how did you install the full client?
>>I dont have local admin rights on this PC.
Then how did you install the full client?
ASKER
I didnt.
Our IT support did.
I am just data analyst
Our IT support did.
I am just data analyst
I would suggest merging the entries in the two tnsnames.ora files and keep both installs since they are already done.
ASKER
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\c
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.
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.
in client1, manually create a network\admin folder and copy the tnsnames.ora and sqlnet.ora in there.
>>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.
i think this will be best as it avoid confusion.
ASKER
Thanks