DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-12545

  1. #1
    Join Date
    Apr 2002
    Posts
    1
    Greetings,

    I have a client computer trying to connect to an Oracle database through a dial-up modem. I can dial-up, and my username and password are accepted. When I try connecting to the database, sqlplus user/pw@NN01 I get error ora-12545: connect failed because target host or object does not exist.

    The Tnsnames.ora file is:

    NN01.NN.WBC.COM =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = nansvr4.weyer.com)(PORT = 1521))
    (CONNECT_DATA = (SID = NN01)(SERVER = DEDICATED))
    )

    The sqlnet.ora file is:

    NAME.DEFAULT_ZONE = world
    SQLNET.EXPIRE_TIME = 0
    SQLNET.ENCRYPTION_SERVER = requested
    SQLNET.ENCRYPTION_CLIENT = requested
    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES)

    Tnsping does not work. When I follow the exact same procedure, using the same tnsnames, sqlnet.ora files on the computer beside this one, it all works fine.

    Any help on this would be appreciated,

    Brad

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    I experienced this problem. Infact, some times the IP address might change. So use the IP address in your HOST isntead of system name.
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    This is in the listener.ora file in one of my databases. You may want to use the Startup wait and Connect timeout parameters in the listener.ora file on you db server. It could be that you connection is slow and it takes to long for the client to connect. You might also try sqlnet tracing. Also make sure try to hard ccode the ip and make sure that tcp/ip is selected for the dial up connection.

    LISTENER =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (HOST = 192.168.0.1)
    (PORT = 1521)
    )
    )
    STARTUP_WAIT_TIME_LISTENER = 0
    CONNECT_TIMEOUT_LISTENER = 0
    TRACE_LEVEL_LISTENER = OFF
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = BSG1)
    (ORACLE_HOME = \Oracle\ora81)
    (GLOBAL_DBNAME = MYSID)
    )
    )

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