SqlPlus connection error ORA-12545 - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 24 of 24

Thread: SqlPlus connection error ORA-12545

  1. #21
    Join Date
    Apr 2001
    Posts
    35
    Tried both, same result.
    Share on Google+

  2. #22
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Are you have any firewalls with open 1521 port and close another?
    Share on Google+

  3. #23
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Looks to me the problem is in the hostname identification...

    First of all can you do

    ping host_name
    or
    telnet host_name


    Then try


    tnsping host_name
    tnsping service_name

    Please also provide the results. "The one word answers doesn't help us". Give us the result output as it is....

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!

    Share on Google+

  4. #24
    Join Date
    Apr 2001
    Posts
    35
    It was actually a simple fix from Oracle support. In init.ora file, set the hostname with IP address instead of machine name for the local_listener and mts_dispatcher resolved the problem.

    Thanks for all the effort. This is one of those occasions Oracle support had a quick and effective response. Closing this thread.
    Share on Google+

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