-
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.
-
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
-
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)
)
)
-
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?
-
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 10: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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|