0 Replies Latest reply on Sep 12, 2013 8:01 PM by EdStevens

    case confusion - two dbcontrol config directories for one database

    EdStevens

      Oracle 11.2.0.2 SE-One 64-bit

      Oracle ASM 11.2.0.2 64-bit

      Oracle Linux 5.6 x86-64

      Stand alone server, no cluster, no RAC

       

      Configured a new dbcontrol for subject database.  Everything seems to be functioning correctly but it created two config directories

       

      oracle:mydb$ cd $ORACLE_HOME

       

      2013-09-12 14:21:50

      oracle:mydb$ ls -l myserver*

       

      myserver.mycompany.org_mydb:                        -------- note the dbname is lower case and directory is sparse

      total 4

      drwxr----- 3 oracle oinstall 4096 Sep 12 14:13 sysman

       

      myserver.mycompany.org_MYDB:                        -------- note the dbname is upper case and directory is fully populated

      total 12

      -rw-r----- 1 oracle oinstall    6 Sep 12 14:13 emctl.pid

      -rw-r--r-- 1 oracle oinstall   56 Sep 12 14:13 oraInst.loc

      drwxr----- 7 oracle oinstall 4096 Sep 12 14:13 sysman

       

       

      And in the j2ee directory we get this.  Note the dbname is in upper case

       

      oracle:mydb$ cd oc4j/j2ee

       

      2013-09-12 14:26:49

      oracle:mydb$ ll

      total 36

      -rw-r--r--  1 oracle oinstall 1012 Apr  5 08:56 deploy_db_wf.ini

      drwxr-xr-x 14 oracle oinstall 4096 Apr  5 08:53 home

      drwxr-xr-x  3 oracle oinstall 4096 Apr  5 08:51 oc4j_applications

      drwxr-x---  6 oracle oinstall 4096 Apr  5 08:51 OC4J_DBConsole

      drwxr-xr-x 10 oracle oinstall 4096 Sep 12 14:13 OC4J_DBConsole_myserver.mycompany.org_MYDB 

      drwxr-xr-x  5 oracle oinstall 4096 Apr  5 08:51 OC4J_Workflow_Component_Container

      drwxr-xr-x  5 oracle oinstall 4096 Apr  5 08:51 OC4J_Workflow_Management_Container

      drwxr-xr-x  2 oracle oinstall 4096 Apr  5 08:53 utilities

       

       

      What the database tells us about itself:

       

      SQL> select name from v$database;

       

      NAME

      ---------

      MYDB

       

      SQL> select instance_name from v$instance;

       

      INSTANCE_NAME

      ----------------

      mydb

       

       

      SQL> select name,

        2         value

        3  from v$parameter

        4  where name in ('db_name',

        5                 'db_unique_name',

        6                 'instance_name',

        7                 'service_names',

        8                 'global_names'

        9                 )

      10  order by name;

       

      NAME                 VALUE

      -------------------- --------------------

      db_name              MYDB

      db_unique_name       MYDB

      global_names         FALSE

      instance_name        mydb

      service_names        MYDB

       

       

      And the environment from which I ran emca:

       

       

       

      oracle:mydb$ env |grep ORA|sort

      ORACLE_BASE=/u01/app/oracle

      ORACLE_HOME=/u01/app/oracle/product/11.2.0.2/dbhome_1

      ORACLE_SID=mydb

       

       

      The mis-matched cases stem from my predecessor deciding he didn't like database names in lower case, so started changing in mid-stream.  I'm not sure exactly what he did or how he did it.  But that aside, the results of creating a new dbcontrol (getting two directories for the same database) still puzzling.  I started by dropping the original (emca -deconfig dbcontrol db -repos drop), which dropped the upper-case version of the directories, but left the lower-case version.  I then deleted that manually before running emca to configure a new dbcontrol, but still ended up with both versions.

       

      Ideas?