Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    3

    Unhappy Unanswered: Oracle developer 6.0 conflicts with Oracle 9i

    hi all!
    i've a problem with Oracle.
    first, i installed Oracle 9i enterprise edition, and create a database call TESTDB. it's ok with all!
    after that i install Oracle Developer 6.0 with complete option.
    but i can't connect to my database. It has an error ORA-12514.
    How can anyone solve this???
    Thx very much!

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Check the TNSNAMES.ORA file (should be in your <oracle_home>\network\admin directory) and see whether SERVICE_NAME is correct. You can expect to have something like this:
    Code:
    testdb =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = testdb)
        )
      )

  3. #3
    Join Date
    Sep 2003
    Posts
    3
    Quote Originally Posted by Littlefoot
    Check the TNSNAMES.ORA file (should be in your <oracle_home>\network\admin directory) and see whether SERVICE_NAME is correct. You can expect to have something like this:
    Code:
    testdb =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = testdb)
        )
      )
    Thanks for reply!
    here my tnsnames.ora

    Code:
    TESTDB =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = TESTDB)
        )
      )
    but i can't using oracle form builder, sqlplus.... connect to my database?
    It still has an error 12514.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    And what's in the TNSNAMES.ORA residing in your Oracle Developer 6 \NET80\ADMIN directory? Also, check both (in your DB and Developer NET* directories) SQLNET.ORA files.

  5. #5
    Join Date
    Sep 2003
    Posts
    3
    i met the solution!
    Thank you! littlefoot

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •