Results 1 to 7 of 7

Thread: error ORA-12154

  1. #1
    Join Date
    Dec 2002
    Posts
    17

    Unanswered: error ORA-12154

    error
    ora-12154: TNS: could not resolve service name.

    how do you troubleshoot this error?

    thanks,

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    Verify tnsnames.ora

    Check your TNS_ADMIN system variable if it is set tnsnames.ora shoudl be in this directory else it is in $ORACLE_HOME/network/admin directory.

    Is the tnsnames.ora file there ?
    Has it an entry you used to connect?

    Good luck!

    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  3. #3
    Join Date
    Dec 2002
    Posts
    17
    yes the TNS file exist in the directory.
    do i have to do any changes to that file?
    for example, instead of database in the file to put
    the real name of the database?
    just a thought because i get the same error.

    thanks

  4. #4
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    post

    PLease post your tnsnames.ora file ( or a substrat containing your tns entry)

    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  5. #5
    Join Date
    Dec 2002
    Posts
    17
    # This file contains the syntax information for
    # the entries to be put in any tnsnames.ora file
    # The entries in this file are need based.
    # There are no defaults for entries in this file
    # that Sqlnet/Net3 use that need to be overridden
    #
    # Typically you could have two tnsnames.ora files
    # in the system, one that is set for the entire system
    # and is called the system tnsnames.ora file, and a
    # second file that is used by each user locally so that
    # he can override the definitions dictated by the system
    # tnsnames.ora file.

    # The entries in tnsnames.ora are an alternative to using
    # the names server with the onames adapter.
    # They are a collection of aliases for the addresses that
    # the listener(s) is(are) listening for a database or
    # several databases.

    # The following is the general syntax for any entry in
    # a tnsnames.ora file. There could be several such entries
    # tailored to the user's needs.

    <alias>= [ (DESCRIPTION_LIST = # Optional depending on whether u have
    # one or more descriptions
    # If there is just one description, unnecessary ]
    (DESCRIPTION=
    [ (SDU=2048) ] # Optional, defaults to 2048
    # Can take values between 512 and 32K
    [ (ADDRESS_LIST= # Optional depending on whether u have
    # one or more addresses
    # If there is just one address, unnecessary ]
    (ADDRESS=
    [ (COMMUNITY=<community_name>) ]
    (PROTOCOL=tcp)
    (HOST=<hostname>)
    (PORT=<portnumber (1521 is a standard port used)>)
    )
    [ (ADDRESS=
    (PROTOCOL=ipc)
    (KEY=<ipckey (PNPKEY is a standard key used)>)
    )
    ]
    [ (ADDRESS=
    [ (COMMUNITY=<community_name>) ]
    (PROTOCOL=decnet)
    (NODE=<nodename>)
    (OBJECT=<objectname>)
    )
    ]
    ... # More addresses
    [ ) ] # Optional depending on whether ADDRESS_LIST is used or not
    [ (CONNECT_DATA=
    (SID=<oracle_sid>)
    [ (GLOBAL_NAME=<global_database_name>) ]
    )
    ]
    [ (SOURCE_ROUTE=yes) ]
    )
    (DESCRIPTION=
    [ (SDU=2048) ] # Optional, defaults to 2048
    # Can take values between 512 and 32K
    [ (ADDRESS_LIST= ] # Optional depending on whether u have more
    # than one address or not
    # If there is just one address, unnecessary
    (ADDRESS
    [ (COMMUNITY=<community_name>) ]
    (PROTOCOL=tcp)
    (HOST=<hostname>)
    (PORT=<portnumber (1521 is a standard port used)>)
    )
    [ (ADDRESS=
    (PROTOCOL=ipc)
    (KEY=<ipckey (PNPKEY is a standard key used)>)
    )
    ]
    ... # More addresses
    [ ) ] # Optional depending on whether ADDRESS_LIST
    # is being used
    [ (CONNECT_DATA=
    (SID=<oracle_sid>)
    [ (GLOBAL_NAME=<global_database_name>) ]
    )
    ]
    [ (SOURCE_ROUTE=yes) ]
    )
    [ (CONNECT_DATA=
    (SID=<oracle_sid>)
    [ (GLOBAL_NAME=<global_database_name>) ]
    )
    ]
    ... # More descriptions
    [ ) ] # Optional depending on whether DESCRIPTION_LIST is used or not

  6. #6
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    which entry

    Which entry do you use!????

    This seems a file that has no valid entries (only syntax examples)

    Remi
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

  7. #7
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    1

    Re: which entry

    Hey I just read somewhere else about the ora-12541 problem.
    I tried all the remedies in this forum, but not chance. What I had tried was:

    Uninstall my Zoneslab Zonealarm software. This firewall software block all Persistence IP, including from oracle server. When I try to change from an oracle to another oracle server, than the ora-12541 problem occur (with zonelabs).

    First installation and setup of oracle client was fine (although zonelabs was deactivated) but then after changes of tnsnames.ora file, i was not able to login to oracle.

    Uninstall zonelabs, -> works!

    chiao

Posting Permissions

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