TNS Listener issue - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: TNS Listener issue

  1. #11
    Join Date
    Feb 2010
    Posts
    36
    Hi All,

    Thanks for reply.

    1) I can have two listeners on same port that 1521 (Verified after testing).
    Both the listener are up and running.

    2) The issue was as below and it's strange:
    Windows 2008R2 has new interface like commandprompt and it is windows power shell. I was setting ORACLE_SID first and was logging into the database. But "ENVIRNMENT CANNOT BE SET IN THIS WINDOWS POWER SHELL". Then I did it from normal windows command prompt and it could set the env veriables to logg into the proper db.

    Thanks and regards,
    Mayura

  2. #12
    Join Date
    Feb 2011
    Location
    Norwich, UK
    Posts
    5
    Hi Mayura,

    Glad you're sorted now.

    1) Is what I thought.

    2) Interesting issue, haven't come across that as our DBs are on Sun/Solaris platform.

    Thanks for posting your findings, hopefully it'll be useful if someone has the same problem!

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