Re: database on windows
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 23 May 2013 18:37:23 +0100
Message-ID: <CABe10sY9jpmYivR0c28iKDsQKjkrWyvfRpxOUFjdOGC3YiicdA_at_mail.gmail.com>
Without having access to what? Select db_name/instance_name/db_unique_name from the relevant views all work if you have the relevant db permissions. The Database sid is found at the end of the windows service name and in the registry both of which are remotely queryable via PowerShell if you have the relevant o/s permissions.
On May 23, 2013 6:27 PM, "Zelli, Brian" <Brian.Zelli_at_roswellpark.org> wrote:
> I have two servers that look like they are running the same database.
> It is a vendor machine, vendor setup and I don't have access but when I
> look at the listener, it has the same sid and ip address and they are both
> running. They aren't clustered or anything so how can this be? Is there a
> way without having access to tell what the db name is on windows?
> ciao,
> Brian
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
Date: Thu, 23 May 2013 18:37:23 +0100
Message-ID: <CABe10sY9jpmYivR0c28iKDsQKjkrWyvfRpxOUFjdOGC3YiicdA_at_mail.gmail.com>
Without having access to what? Select db_name/instance_name/db_unique_name from the relevant views all work if you have the relevant db permissions. The Database sid is found at the end of the windows service name and in the registry both of which are remotely queryable via PowerShell if you have the relevant o/s permissions.
On May 23, 2013 6:27 PM, "Zelli, Brian" <Brian.Zelli_at_roswellpark.org> wrote:
> I have two servers that look like they are running the same database.
> It is a vendor machine, vendor setup and I don't have access but when I
> look at the listener, it has the same sid and ip address and they are both
> running. They aren't clustered or anything so how can this be? Is there a
> way without having access to tell what the db name is on windows?
> ciao,
> Brian
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 23 2013 - 19:37:23 CEST