pgodfrin wrote:
> On Jan 5, 12:15 pm, DA Morgan <damor...@[EMAIL PROTECTED]
> wrote:
>> pgodfrin wrote:
>>> On Jan 4, 10:45 pm, DA Morgan <damor...@[EMAIL PROTECTED]
> wrote:
>>>> pgodfrin wrote:
>>>>> This is a Fedora 8 installation with Grid 10.1.0.4 (yeah, I know - I
>>>>> need to patch it...).
>>>>> regards,
>>>>> pg
>>>> We agree. Go to metalink. Download it. Apply it.
>>>> --
>>>> Daniel A. Morgan
>>>> Oracle Ace Director & Instructor
>>>> University of Wa****ngton
>>>> damor...@[EMAIL PROTECTED]
(replace x with u to respond)
>>>> Puget Sound Oracle Users Groupwww.psoug.org
>>> oops - Grid is 10.1.2.0.2 ...maybe I dont need to patch it...
>>> Maybe I can rephrase the question - how does Grid identify that a
>>> database should be using a particular listener?
>> It doesn't. These days databases dynamically register with listeners in
>> most cases. It may be looking at where the dynamic registration took
place.
>> --
>> Daniel A. Morgan
>> Oracle Ace Director & Instructor
>> University of Wa****ngton
>> damor...@[EMAIL PROTECTED]
(replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org
>
> HI Dan,
> Well - the database is indeed dynamically registering with the
> listener:
>
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for Linux: Version 10.2.0.1.0 -
> Production
> Start Date 04-JAN-2008 18:00:31
> Uptime 0 days 20 hr. 2 min. 59 sec
> Trace Level off
> Security ON: Local OS Authentication
> SNMP OFF
> Listener Parameter File /home/oracle/tnsadmin/listener.ora
> Listener Log File /oracle/product/10.2.0.1/network/log/
> listener.log
> Listening Endpoints Summary...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=edgwprd1)(****T=1521)))
> Services Summary...
> Service "edgwrp01" has 1 instance(s).
> Instance "edgwrp01", status READY, has 1 handler(s) for this
> service...
> Service "pgdb" has 1 instance(s).
> Instance "pgdb", status READY, has 1 handler(s) for this service...
>
> nothing fancy here - using the default listener, no SID_LIST in the
> listener... But Grid insists that database "pgdb" should be using a
> different listener (the one that was running when I installed grid and
> the agent).
>
> This is from the target:datbase page:
> General
> [Black Out]
> Status Up
> Up Since Jan 4, 2008 6:00:35 PM CST
> Instance Name pgdb
> Version 10.2.0.1.0
> Host edgwprd1
> Listener EDGWPRD1_10201_edgwprd1
> View All Properties
>
> So...any thoughts?
> pg
The Grid Control has a real problem with its metadata. Try shutting it
down and restarting it. You may need to drop that target and recreate it
but try the easy solution first.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Wa****ngton
damorgan@[EMAIL PROTECTED]
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
|
