Re: How to find out which version is installed - standard or enterprise?

If you do a custom installation with Oracle9i there's no way to tell from the banner. Even if you select no EE features the banner will still say EE.

On Tue, 5 Aug 2003 14:14:48 +0200, "Andreas Driesen" <andreas.driesen_at_tesla.de> wrote:

>Hello
>
>on Windows 2000 server with Oracle 9.2 following appears:
>
>Oracle9i Release 9.2.0.1.0 - Production
>PL/SQL Release 9.2.0.1.0 - Production
>CORE 9.2.0.1.0 Production
>TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
>NLSRTL Version 9.2.0.1.0 - Production
>
>Is it Enterprise or Standard now? ;-)
>
>Greetings,
>Andreas
>
>
>"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> schrieb im Newsbeitrag
>news:E2F6A70FE45242488C865C3BC1245DA703FE0C80_at_lnewton.leeds.lfs.co.uk...
>> SQL> select Banner from v$version
>>
>> BANNER
>> ----------------------------------------------------------------
>> Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
>> PL/SQL Release 9.2.0.1.0 - Production
>> CORE 9.2.0.1.0 Production
>>
>> TNS for HPUX: Version 9.2.0.1.0 - Production
>> NLSRTL Version 9.2.0.1.0 - Production
>> 5 rows selected
>>
>> The first one gives the game away :o)
>>
>> Cheers,
>> Norman.
>>
>> PS. This is on HPUX on a 64 bit HP server.
>>
>
Received on Tue Aug 05 2003 - 20:58:47 CDT