QUESTION: Latest CPU thinks I have a db running



I'm on 8i on AIX.

My question isn't 8i specific (good thing); but I need to understand
the mechanism by which the CPU patch detects active databases in the
current home before patching that home.

Let's say I have 2 homes and 3 databases on my server.

My DBs are all running against HOME1. I am updating HOME2, and will
move the databases to HOME2 and redo their catalogs one by one. I set
my ORACLE_HOME to HOME2, and my ORACLE_SID to DB3 in preparation for
patching. ORACLE_SID should play little part in the 'binaries' part of
the CPU, so at this point I don't really care what the SID is.

When I run installcpu.sh, I get a warning:

"Seems that some databases in /home/oracle/product/8.1.7 are active
Found instance: DB1 open"

When I set my ORACLE_HOME to HOME2 (which I am trying to patch) and my
ORACLE_SID to DB1, and then open a sqlplus session, I get a 'connected
to idle instance' message - as I would expect, because this database is
not running against this HOME. So I see no evidence of this db running
against the home I am patching.

Conversely, if I set my ORACLE_HOME to HOME1, leave my SID as DB1, and
start a sqlplus session, I get in - as expected.

So why does the CPU installer think I have this DB1 database running
against HOME2?

I have tried to grep for the text of the warning message in various
files in the CPU install folder, in hopes of learning what it is
looking for - but found nothing.

Mildly confused...

Thanks!

BD

.



Relevant Pages

  • Re: Competition for OraPerf
    ... I would say that with the complexities of modern Oracle databases and the ... A consultant like me would cost you ... I've never seen a database server with CPU set more then 40% ... Because it's one thing to ensure you have sufficient hardware for your ...
    (comp.databases.oracle.server)
  • Re: Competition for OraPerf
    ... I would say that with the complexities of modern Oracle databases and the ... A consultant like me would cost you ... I've never seen a database server with CPU set more then 40% ... Buying few SSD devices for a few grands will probably do ...
    (comp.databases.oracle.server)
  • Re: Append Record to External Database
    ... > I have two databases (db1 and db2) with the same structure. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Security between databases
    ... SQL Server databases. ... I have two databases DB1 and DB2. ... DB1 has a table called DB1_Table1. ... The above model is repeated for DB2. ...
    (microsoft.public.sqlserver.security)
  • Re: Multiple Informix Instances with 9.4 UC4 version
    ... Just make sure the 2 CPU intensive databases ... if you can try staggering the ... busy periods of the databases. ... Then give the small database 1 CPU (the last 1 left, ...
    (comp.databases.informix)