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

    case confusion - two dbcontrol config directories for one database


      Oracle SE-One 64-bit

      Oracle ASM 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;






      SQL> select instance_name from v$instance;







      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






      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.