catproc version is different than database version

[Former Member]

Can I run catproc & catalog when the database is up and running? Or do I have to stop the database?

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

SQL> select version from V$INSTANCE;

VERSION

-

---

9.2.0.7.0

SQL> select comp_id, version, status from dba_registry;

COMP_ID VERSION STATUS

-

---

-

---

-

---

CATALOG 9.2.0.6.0 VALID

CATPROC 9.2.0.6.0 VALID

SQL> show parameter compatible

NAME TYPE VALUE

-

---

-

---

-

---

compatible string 9.2.0.7.0

[Former Member · Accepted solution]

I would suggest that you install the Oracle Database patchset 9.2.0.7 without running the post installations tasks documented in the patchset readme.html.

YOU HAVE TO EXECUTE additional scripts after the installation of a patchset or minipatch. Details see readme.html of the update.

peter

[markus_doehr2]

It MUST be run when the database is running since it creates views, triggers, packages etc. This works only with a mounted and open database.

--

Markus