Home » RDBMS Server » Networking and Gateways » Problem Connecting Developer 6.0 to 10G Database (Oracle DB 9.2.0.1)
Problem Connecting Developer 6.0 to 10G Database [message #448119] Fri, 19 March 2010 10:45 Go to next message
playitsafe
Messages: 19
Registered: January 2009
Location: NJ
Junior Member
Can currently connect to a 9.2.0.1 database using Oracle Developer 6.0 with the following connect string:

C:\orant\BIN\ifrun60.EXE GMS ops$cannonc/cannonc@GMS3B.TEST.COM[/email]

I don't believe it is using the TNSNAMES.ora entry for this, because when I take it out of there it still connects.

I create a 10.1.0.5 database and copyied the tables,etc to there. But I'm having problem connecting, getting "ORA-12154:TNS Could not resolve service name". Tried the following:

C:\orant\BIN\ifrun60.EXE GMS ops$cannonc/cannonc@NJZTEST[/email]
C:\orant\BIN\ifrun60.EXE GMS ops$cannonc/cannonc@NJZTEST.TEST.COM[/email]

I did add the entry for the 10G database to TNSNAMES.ora:

NJZTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = njzainettest.test.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = njztest)
)
)

I new to this, but my guess is the other entry had the full path name..and this SERVICE_NAME does not. But then again I don't believe it looks at the TNSNAMES file. This NJZTEST is the 2nd instance on the NJZAINETTEST machine.

Any thoughts on what I'm missing here?

Thanks

[Updated on: Fri, 19 March 2010 10:46]

Report message to a moderator

Re: Problem Connecting Developer 6.0 to 10G Database [message #448122 is a reply to message #448119] Fri, 19 March 2010 11:15 Go to previous messageGo to next message
Michel Cadot
Messages: 59295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12154: TNS:could not resolve the connect identifier specified
 *Cause:  A connection to a database or other service was requested using
 a connect identifier, and the connect identifier specified could not
 be resolved into a connect descriptor using one of the naming methods
 configured. For example, if the type of connect identifier used was a
 net service name then the net service name could not be found in a
 naming method repository, or the repository could not be
 located or reached.
 *Action:
   - If you are using local naming (TNSNAMES.ORA file):
      - Make sure that "TNSNAMES" is listed as one of the values of the
        NAMES.DIRECTORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA)
      - Verify that a TNSNAMES.ORA file exists and is in the proper
        directory and is accessible.
      - Check that the net service name used as the connect identifier
        exists in the TNSNAMES.ORA file.
      - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA
        file.  Look for unmatched parentheses or stray characters. Errors
        in a TNSNAMES.ORA file may make it unusable.
   - If you are using directory naming:
      - Verify that "LDAP" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Verify that the LDAP directory server is up and that it is
        accessible.
      - Verify that the net service name or database name used as the
        connect identifier is configured in the directory.
      - Verify that the default context being used is correct by
        specifying a fully qualified net service name or a full LDAP DN
        as the connect identifier
   - If you are using easy connect naming:
      - Verify that "EZCONNECT" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Make sure the host, port and service name specified
        are correct.
      - Try enclosing the connect identifier in quote marks.

   See the Oracle Net Services Administrators Guide or the Oracle
   operating system specific guide for more information on naming.


Check your ORACLE_HOME and for any TNS_ADMIN environment variable.

Regards
Michel
Re: Problem Connecting Developer 6.0 to 10G Database [message #448124 is a reply to message #448122] Fri, 19 March 2010 11:36 Go to previous messageGo to next message
playitsafe
Messages: 19
Registered: January 2009
Location: NJ
Junior Member
Thanks Mike, I have been through the notes on the error but here is my problem.

I know i'm not using the TNSNames.ora, because I have removed the entry for the 9.2.0.1

That leaves the LDAP and EZCONNECT, none of which exist in the SQLNET.org (I did add them to no avail), so how is this working?

I'm guessing is it using some direct connection from the parameter string, I would have this problem with 9I or 10G database. Not sure what to format for the string, something like njzainettest.test.com:njztest?

I'm sure this is a simple connection problem I have been able to connect using SQLPlus Worksheet in 9I, with the following parameters, that must be using the TNSNames.org file is my guess?

ops$cannonc
cannonc
NJZTEST

Re: Problem Connecting Developer 6.0 to 10G Database [message #448129 is a reply to message #448124] Fri, 19 March 2010 12:16 Go to previous messageGo to next message
Michel Cadot
Messages: 59295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I know i'm not using the TNSNames.ora, because I have removed the entry for the 9.2.0.1

Maybe you are using another one that the one you're thinking of.
Did you search what I asked?

Quote:
I'm sure this is a simple connection problem I have been able to connect using SQLPlus Worksheet in 9I, with the following parameters, that must be using the TNSNames.org file is my guess?

This is correct and maybe inconsistent with your previous sentence.

Regards
Michel
Re: Problem Connecting Developer 6.0 to 10G Database [message #448131 is a reply to message #448129] Fri, 19 March 2010 12:29 Go to previous messageGo to next message
playitsafe
Messages: 19
Registered: January 2009
Location: NJ
Junior Member
Using TNSNAMES for SQL, not using TNSNAMES for the Developer 6.0 connection.

Where and how the Developer 6.0 is connecting is the question of the day.

Located in C:\oracle\ora92\network\admin, there is only 1 TNSNAMES file on the system.

Thanks

[Updated on: Fri, 19 March 2010 12:29]

Report message to a moderator

Re: Problem Connecting Developer 6.0 to 10G Database [message #448212 is a reply to message #448131] Sat, 20 March 2010 12:12 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
Assuming we are discussing a single system, it appear that at least 3 separate ORACLE_HOME folders should exist; 1 for Developer, 1 for V9 DB, & 1 for V10 DB.

By default each will have a tnsnames.ora file.
So it becomes a matter of the actual value of ORACLE_HOME when various utilities are invoked.

Of course this could be overrode by TNS_ADMIN value.

None of which know for sure at this time.
Sad
Re: Problem Connecting Developer 6.0 to 10G Database [message #448214 is a reply to message #448212] Sat, 20 March 2010 13:30 Go to previous message
Littlefoot
Messages: 19653
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I agree, this might be yet another TNS_ADMIN problem/solution. Here's an example, so - take a look; perhaps it'll help.
Previous Topic: Db links issues..
Next Topic: DB Link from SQL Server 2005 (Big5) to Oracle(UTF8)
Goto Forum:
  


Current Time: Thu Oct 02 07:07:42 CDT 2014

Total time taken to generate the page: 0.12983 seconds