Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: newbie - another ORA-12154 :(

    Hello to everyone,

    I've the old ORA-12154 Problem. I've read through all the articles regarding that problem and tried the recommended solutions, but none worked.

    I'm running Oracle 9.2.0.1.0 on a win2003-Server.

    srv-name: srvlei05
    sid stwl

    Here are my sqlnet.ora, tnsnames.ora and listener.ora

    # SQLNET.ORA Network Configuration File: D:\oracle\oraswl\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    NAMES.PREFERRED_SERVERS =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvlei05)(PORT = 1521))
    )

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    #NAME.DEFAULT_ZONE = world
    #
    #NAMES.DEFAULT_DOMAIN = world


    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

    ***********************************************

    # TNSNAMES.ORA Network Configuration File: D:\oracle\oraswl\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    STWL_SRVLEI05 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvlei05)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = stwl)
    (SERVER = DEDICATED)
    )
    )

    INST1_HTTP =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvlei05)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = MODOSE)
    (PRESENTATION = http://HRService)
    )
    )

    ####################################
    # Date..........: Mon Mar 10 10:33:18 CET 2003
    ####################################

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    ************************************************

    # LISTENER.ORA Network Configuration File: D:\oracle\oraswl\NETWORK\ADMIN\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = srvlei05)(PORT = 1521))
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = stwl)
    (ORACLE_HOME = D:\oracle\oraswl\network\admin)
    (SID_NAME = stwl)
    )
    )



    I really would appreciate any help.

    Thank you in advance!

    Marc

  2. #2
    Join Date
    Jan 2004
    Location
    Scottsdale, AZ
    Posts
    106
    Is your oracle installation home actually in you network administration directory>? (ORACLE_HOME = D:\oracle\oraswl\network\admin) In my opinion, change listener.ora for your oracle home and restart the listener.
    "Take Control!
    Make The Choice!
    Accept The Consequences!
    Deal With The Results! "

  3. #3
    Join Date
    Mar 2004
    Posts
    3
    Thank you for your reply. The given Path is correct (D:\oracle\oraswl\network\admin) this is the ora-home and this is where the *.ora-files are stored.

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    In your SQLNET.ORA change the following line ...

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    to

    SQLNET.AUTHENTICATION_SERVICES= (NONE)

    HTH
    Gregg

  5. #5
    Join Date
    Mar 2004
    Posts
    3
    Thank you for that hint, but i'm afraid the problem persists.

  6. #6
    Join Date
    Jan 2004
    Location
    Scottsdale, AZ
    Posts
    106
    - check your path and make sure that tnsnames.ora can be found
    - check for the use of tns_admin variable, and that it is correctly set if it is used
    - verfiy that there are no weird characters at the end of the lines in the tnsnames.ora file. this can occur if the file was edited in unix or some other type of editor and transfered over to its location, check too, for extra lines at the end of the file, delete them.
    - if nothing else, recreate the tnsnames.ora file using the oracle provided configuration tools
    "Take Control!
    Make The Choice!
    Accept The Consequences!
    Deal With The Results! "

  7. #7
    Join Date
    Jul 2003
    Posts
    2,296
    for SQLNET.ORA:

    - comment out the authentication.services line
    - add a line: NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
    - what is your default doman?? you need this set. so uncomment it.

    for TNSNAMES.ORA:
    - set first line "STWL_SRVLEI05 =" to stwl.(your default domain) = (if you use WORLD then it would be "stwl.world =")

    for hosts I like to use IP and not nost-name, but that is my preference.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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