2 instances, 1 listener, services summary
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: 2 instances, 1 listener, services summary

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    2 instances, 1 listener, services summary

    1) Host A has the below

    Services Summary...
    instance_1 has 2 service handler(s)
    instance_2 has 2 service handler(s)
    instance_1 has 1 service handler(s)
    instance_1 has 2 service handler(s)
    instance_1 has 2 service handler(s)
    instance_2 has 2 service handler(s)
    instance_2 has 2 service handler(s)

    a) both instances has the same port number.
    b) in my listener configuration, i have only the instance_1 configuration.
    c) both instances share the same oracle user


    Questions
    i) I am puzzled by the list of services summary as shown above.What does it mean?
    ii) in my listener configuration, i have only the entry for instance 1. And i have checked that when i su to the oracle user , the instance is instance_1.

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    mind posting your listener.ora up? I'd like to see it.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    Oct 2002
    Posts
    391
    sure, below is it.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = instance_1)
    (ORACLE_HOME = /oracle/product/8.1.7)
    (SID_NAME = idea)
    )
    )

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    You have more than one oracle home on your computer, right?

    because the listener service summary from your first post and the listener.ora from your second one definitely are not from the same oracle home, that's for sure.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Oct 2002
    Posts
    391
    i have an oracle user who has 2 instances and they have the same oracle home from "env". Therefore, 2 instances are having the same listener, tnsnames configuration.

    Of course, the initsid.ora are different.

    Please advise.
    Last edited by yls177; 11-21-2004 at 09:42 PM.

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