ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

  1. #11
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    does it work?

  2. #12
    Join Date
    Feb 2005
    Posts
    11
    oh sorry! I am sitting here waiting for a reply and I forgot to mention that it did not work.

    Thanks for all the replies so far Davey23UK.
    Last edited by RockyAssad; 02-02-2005 at 04:47 PM.

  3. #13
    Join Date
    Feb 2005
    Posts
    11
    Iam currently running a grep on the entire file system for the old db name. I'm wondering if I missed something. This wont be done for a few hours. Until then any other suggestions?

  4. #14
    Join Date
    Feb 2005
    Posts
    11
    well I got the grep results back, but it did not find anything. So back to square one with this.

  5. #15
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    what does tnsping ROCKY.ADMISSIONS.MVK.EDU from a command line return

  6. #16
    Join Date
    Feb 2005
    Posts
    11
    C:\Documents and Settings\Rocky>tnsping rocky.admissions.mvc.edu

    TNS Ping Utility for 32-bit Windows: Version 9.0.1.1.1 - Production on 02-FEB-20
    05 19:03:04

    Copyright (c) 1997 Oracle Corporation. All rights reserved.

    Used parameter files:
    C:\oracle\ora90\network\admin\sqlnet.ora
    C:\oracle\ora90\network\admin\tnsnames.ora

    TNS-03505: Failed to resolve name

  7. #17
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    out of ideas really,

    last thing I would try is jsust have rocky in the tnsnames file

    ROCKY =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 152.10.23.196)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = rocky.rocky)
    )
    )

    then try tnsping rocky and tnsping ROCKY.ADMISSIONS.MVC.EDU

    failing that, open a tar :-)

  8. #18
    Join Date
    Feb 2005
    Posts
    11
    I ended up creating a db on another linux box at the university and porting over the data. Took only a few hours and we were back up and running.

    I tried to create anther db on the same machine at first and I got all sorts of errors, so I said forget it. Things are looking good again.

    Davey tahnks again for all your help.

Posting Permissions

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



Click Here to Expand Forum to Full Width