berean1224
Member
Hello,
PL/SQL Developer is being evaluated for purchase. Assistance is needed because there is a problem completing the setup. The forum and instructions have been completely read for resolution to no avail.
Exception message: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in the connect description.
At one point had problems which I believe had to deal with tnsname.ora but the settings in this file were simplified and shortened. It now only includes configuration values for a single DB. And, Oracle's SQL Developer is able to use the same tnsname.ora file which PLSQL Developer points to but without a problem.
c:\windows\system32\drivers\etc\hosts has been setup to point to database server. But this didn't resovle problem. Hard coded the IP address into tnsnames.ora but that didn't fix problem.
Due to another post, tried to comment out NAMES.DEFAULT_DOMAIN in SQLNET.ORA to if that would reolve problem but it did not. Also tried to create a trace via trace_level_client to no avail.
Assistance is appreciated,
Thank you,
Berean1224
TNSNAME.ORA file shall be send via email.
Environment:
Backend Oracle 10g;
Client OS: Win XP Pro 2002 Sp2;
PL/SQL Developer
Version 7.1.4.1390
Windows XP Professional 5.1 Build 2600 (Service Pack 2)
Physical memory : 2,096,360 kB (1,348,192 available)
Paging file : 4,038,152 kB (3,407,372 available)
Virtual memory : 2,097,024 kB (2,009,568 available)
Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe
Preferences
Session mode: Multi
OCI Library: C:\oracle\ora92\bin\oci.dll
Use OCI7: False
Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\\default.ini
Plug-Ins
Aliases
PROD
Homes
OraHome92 (C:\oracle\ora92)
DLLs
C:\oracle\ora92\bin\oci.dll
TNS File
C:\oracle\ora92\Network\Admin\tnsnames.ora
Using
Home: C:\oracle\ora92\bin
DLL: C:\oracle\ora92\bin\oci.dll
OCI: version 9.2
The above value for
PL/SQL Developer is being evaluated for purchase. Assistance is needed because there is a problem completing the setup. The forum and instructions have been completely read for resolution to no avail.
Exception message: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in the connect description.
At one point had problems which I believe had to deal with tnsname.ora but the settings in this file were simplified and shortened. It now only includes configuration values for a single DB. And, Oracle's SQL Developer is able to use the same tnsname.ora file which PLSQL Developer points to but without a problem.
c:\windows\system32\drivers\etc\hosts has been setup to point to database server. But this didn't resovle problem. Hard coded the IP address into tnsnames.ora but that didn't fix problem.
Due to another post, tried to comment out NAMES.DEFAULT_DOMAIN in SQLNET.ORA to if that would reolve problem but it did not. Also tried to create a trace via trace_level_client to no avail.
Assistance is appreciated,
Thank you,
Berean1224
TNSNAME.ORA file shall be send via email.
Environment:
Backend Oracle 10g;
Client OS: Win XP Pro 2002 Sp2;
PL/SQL Developer
Version 7.1.4.1390
Windows XP Professional 5.1 Build 2600 (Service Pack 2)
Physical memory : 2,096,360 kB (1,348,192 available)
Paging file : 4,038,152 kB (3,407,372 available)
Virtual memory : 2,097,024 kB (2,009,568 available)
Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe
Preferences
Session mode: Multi
OCI Library: C:\oracle\ora92\bin\oci.dll
Use OCI7: False
Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\\default.ini
Plug-Ins
Aliases
PROD
Homes
OraHome92 (C:\oracle\ora92)
DLLs
C:\oracle\ora92\bin\oci.dll
TNS File
C:\oracle\ora92\Network\Admin\tnsnames.ora
Using
Home: C:\oracle\ora92\bin
DLL: C:\oracle\ora92\bin\oci.dll
OCI: version 9.2
The above value for
