Results 1 to 4 of 4

Thread: ora 12154

  1. #1
    Join Date
    Jun 2004
    Posts
    7

    Unanswered: ora 12154

    I am trying to access my database, but it wont accept

    scott
    tiger
    and when i leave the host string i get ora 12203 - unable to connect to destination.

    otherwise the error is

    ora 12154 - TNS Couldnt resolve host name

    this is happening on 8i

    now when i have installed 9i completely new from scratch i get the same problem.. what is the issue..

  2. #2
    Join Date
    Jun 2004
    Location
    Germany, Frankfurt
    Posts
    5
    Hello,
    please ensure your tnsnames.ora.
    it should contain SID, Host ans Port
    Kurt

  3. #3
    Join Date
    Jun 2004
    Posts
    7

    what should i do?

    what should i do about the tnsname.ora file.. with the data. could you kindly guide me please.

    thanks

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Run Oracle's NET8 ASSISTANT ... It will guide you thru setting up the tnsnames.ora file ... It will ask you questions about the service name and machine the database is running on...

    1st ... Ensure you have tcpip connectivity ... ping database server.
    2nd .. Once you have setup the tnsnames.ora file ... tnsping servicename
    3rd... run sqlplus and log onto the database...
    4th .. Setup any 3rd party packages you have ...

    HTH
    Gregg

Posting Permissions

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