Installing 8.1.7 iwith patch

[feng11]

Hi,

I'm installing a new 8.1.7 db with patch. Is there any sequence to which one come first? According to patch set notes, they assume db is up and running. In my case, i'm install a new db. Can i,

1) install just the 8.1.7 binaries,
2) patch it to 8.1.7
3) create the db using dbassist w/o having to run the instruction steps in the patch set notes?

Anyone hot the error when running the catalog.sql after patching :

create role recovery_catalog_owner
*
ERROR at line 1:
ORA-01921: role name 'RECOVERY_CATALOG_OWNER' conflicts with another user or
role name

[stecal]

Install the base version of the RDBMS.
Create the seed database. Once the seed or starter database is up and running, and you know the software installed/linked okay, you can delete the seed database to regain disk space.

THEN, install the patch. Normally, usually, generally, the patch is not mission essential to the overall functioning of the database. For the most part, you can live without ever installing a patch.

[feng11]

I follow the instructions in the 8.1.7.4 patch set notes. At number 9, I dont get the correct output. is this ok?

SQL> connect / as sysdba
Connected.
SQL> select * from obj$ where type#=29 and owner# !=0;

no rows selected

SQL> update obj$ set status=5 where type#=29 and owner# !=0;

0 rows updated.

SQL> commit;

Commit complete.

SQL> select * from obj$ where type#=29 and owner# !=0;

no rows selected

SQL> desc dbms_java
ERROR:
ORA-04043: object dbms_java does not exist

[stecal]

I have negative knowledge of the specifics of what this patch does. If you are missing something like dbms_java, that would tell me you need to install the dbms_java package before you install the patch.

For future reference, if 0 rows are updated, what is there to commit (assuming no other transactions need to be committed)?

[davey23uk]

if you are installing patch set 4 then most of the stuff you dont need to do. Only if you have got all the weird and wonderful bits installed.

[pando]

if you dont use java just ignore that error but if in future you plan to use java then you better install it and patch it