Re: Upgrade to ORACLE ver 7.0.16.6 - V$VERSION problem

From: Marcus Collins <ccmr_at_cplan109.ion.chevron.com>
Date: 2 Sep 94 13:22:24 GMT
Message-ID: <1994Sep2.132224.10591_at_london.chevron.com>

In article <rgrosek.12.2E637509_at_silver.sdsmt.edu>, rgrosek_at_silver.sdsmt.edu (Grosek, Rick) says:
>
>I just upgraded our ORACLE Server software from version 7.0.12 up to version
>7.0.16.6. So far, the only problem I've found is with the V$VERSION table.
>It appears as though this table was not updated with the new version
>information. Is it safe to manually UPDATE this table, or is there a better
>way?
>

You did not say what platform/OS. The output from 7.0.16 on HP-UX is:

SQL> select * from v$version;

BANNER

---

ORACLE7 Server Release 7.0.16.4.0 - Production PL/SQL Release 2.0.18.1.0 - Production
CORE Version 2.3.2.1.0 - Production (LSF Alpha) TNS for HPUX: Version 2.0.15.0.0 - Production

Which looks OK. This does not state the options purchased eg procedural, distributed and parallel. But 7.0.13 did not do this either.

--
 Marcus Collins                        Internet: eccmr_at_aberdeen.chevron.com
 Database Analyst.                   MS-Mail: CCMR
 Chevron (UK) Ltd.                    Phone: +44 224 242690. CTN 677-2690.
 Ninian House, Crawpeel Road, Altens, Aberdeen AB1 4LG.

         _/        _/   _/_/_/_/    _/_/_/_/
        _/_/ _/_/   _/             _/
       _/ _/_/_/   _/            _/
      _/  _/ _/   _/            _/
     _/     _/   _/            _/
    _/     _/   _/_/_/_/  _/_/_/_/

Received on Fri Sep 02 1994 - 15:22:24 CEST