How to fix this error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How to fix this error

  1. #1
    Join Date
    Jun 2006
    Posts
    51

    How to fix this error

    ORA-12519: TNS:no appropriate service
    handler found

    Thanks in advance

  2. #2
    Join Date
    Jun 2006
    Posts
    51
    I solved the problem with adding a new listener.ora file for duplicate HOST B, and startup the listener...that's it... found in the tread for this problem

    Can anyone help me with steps how to my instance to listerner.ora or creating listerner.ora for new instance

    Thanks

  3. #3
    Join Date
    Jan 2006
    Location
    Bangalore,IND
    Posts
    47
    For Windows:

    use net manager>oracle net configuration>listener>db services

    set the global db name, directory and sid and that's it.

    For Unix:

    use netmgr

  4. #4
    Join Date
    Jun 2006
    Posts
    51
    Thanks for your reply

    Can mansa or anyone tell me steps how to add new sid to listerner.ora in aix unix box in order to fix this error.

  5. #5
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Hire an oracle DBA
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

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