question about applying patch 8.1.7.3

[a128]

Hi,

I am trying to apply patch 8.1.7.3 to our current 8.1.7 server. However, in the readme file, it asks to make sure ORACLE_SID is set correctly. I have two databases on the same server, how do I know which ORACLE_SID to set to?

Or may be some steps such as running sql scripts need to be done for EACH database while steps for running installer are only done once?

Thanks,

[gandolf989]

I am guessing you are talking about running sql against your sids to upgrade the data dictionary. When you first start svrmgrl do the following: set instance sid1, connect internal, run whatever scripts need to be run then do the same for your other sid. Depending on your network os you can either do a SET ORACLE_SID=SID1 and then start svrmgrl or do an export ORACLE_SID=sid1 for the ksh in unix. When I have applied patches it has been to new databases and I have applied the patch before creating the database. I find that it works better. Also I only apply patches that run in the universal installer. Just my opinion.

To find out wat sid you are running against
select name, value from v$parameter where name = 'instance_name';