This discussion is archived
7 Replies Latest reply: Apr 18, 2012 1:18 AM by hqt200475 RSS

mysterious services

hqt200475 Newbie
Currently Being Moderated
Hi experts

My RAC-System aut 2-Nodes hat die Version 11.2.0.3 (on Linux RH 5.4/X86-64) and a standalone database dg

The output of lisnrctl status shows:
[oracle@dwh admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 17-APR-2012 19:39:47

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                17-APR-2012 17:06:59
Uptime                    0 days 2 hr. 32 min. 49 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0.3/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/dwh/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.16)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "DBUA0632275" has 1 instance(s).
  Instance "DBUA0632275", status BLOCKED, has 1 handler(s) for this service...
Service "DBUA3034148" has 1 instance(s).
  Instance "DBUA3034148", status BLOCKED, has 1 handler(s) for this service...
Service "dg1" has 1 instance(s).
  Instance "dg", status READY, has 1 handler(s) for this service...
Service "dg1_DGMGRL" has 1 instance(s).
  Instance "dg1", status UNKNOWN, has 1 handler(s) for this service...
Service "dgXDB" has 1 instance(s).
  Instance "dg", status READY, has 1 handler(s) for this service...
Service "rac" has 1 instance(s).
  Instance "rac1", status READY, has 1 handler(s) for this service...
Service "racXDB" has 1 instance(s).
  Instance "rac1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@dwh admin]$ 
I didn't define the services/instances "DBUA0632275" and "DBUA3034148" .

My Questions

1/ where do they come from?
2/ Why they have status "BLOCKED"?

Thank any help!

hqt200475

Edited by: hqt200475 on Apr 17, 2012 10:51 AM
  • 1. Re: un
    sb92075 Guru
    Currently Being Moderated
    hqt200475 wrote:
    Hi

    My 2-Nodes RAC-System on Linux RH 5.7/X86 hat die Version 11.2.0.1
    I'm impressed ( NOT! ).
  • 2. Re: un
    Brian Bontrager Expert
    Currently Being Moderated
    <comments that do not apply to the updated issue removed>

    Edited by: Brian Bontrager on Apr 17, 2012 3:15 PM
  • 3. Re: un
    hqt200475 Newbie
    Currently Being Moderated
    It was a type error :-)
  • 4. Re: mysterious services
    sb92075 Guru
    Currently Being Moderated
    hqt200475 wrote:
    Hi experts
    I didn't define the services/instances "DBUA0632275" and "DBUA3034148" .

    My Questions

    1/ where do they come from?
    when was the last time somebody tried running "dbca" on this system?
    2/ Why they have status "BLOCKED"?
    the attempted DB is NOT online

    I bet that after next system reboot they will not appear.
  • 5. Re: mysterious services
    hqt200475 Newbie
    Currently Being Moderated
    Hi sb92075,

    I started dbca 1 hour before!

    Can you tell me a bit more how dbca and these services are in connection ?

    Thanks

    hqt200475
  • 6. Re: mysterious services
    Levi-Pereira Guru
    Currently Being Moderated
    Hi,
    This is not a mystery, but this is something undocumented.

    There is a time ago I had the same curiosity when I saw an unknown PMON process on my host.
    I noted that during the initialization of DBCA or DBUA the Oracle always creates an temporary instance named DBUA<number of instance> in a short period, for internal reasons he also registers a service on the listener temporarily.

    This dummy instance is started to determine what options are available to DBCA use it. This instance is created and removed in seconds, it is necessary to execute two select "select parameter from v$option where value='TRUE'" and "select version from v$timezone_file"


    Start dbca and check pmon process.

    You will see something like this:
    $ ps -ef |grep pmon
    oracle    2485     1  4 23:14 ?        00:00:00 ora_pmon_DBUA0
    For more detailed information see the trace log that is generated while the DBCA is running.
    $ORALCE_BASE/cfgtoollogs/dbca/trace.log_<NAME_OF_ORACLE_HOME>
    See this example:
    cat trace.log_OraDb11g_home1
    .
    .
    .
    [main] [ 2012-04-17 23:13:58.079 BRT ] [OracleHome.initOptions:1226]  Initializing Database Options with  for dummy sid=DBUA0 using initfile=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initDBUA0.ora using pwdfile=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwDBUA0
    .
    .
    .
    [main] [ 2012-04-17 23:14:07.671 BRT ] [OracleHome.initOptions:1240]  executing: startup nomount pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initDBUA0.ora'
    [main] [ 2012-04-17 23:14:19.175 BRT ] [OracleHome.initOptions:1250]  executing: select parameter from v$option where value='TRUE'
    [main] [ 2012-04-17 23:14:19.198 BRT ] [OracleHome.initOptions:1256]  Database Option Partitioning is ON
    [main] [ 2012-04-17 23:14:19.198 BRT ] [OracleHome.initOptions:1256]  Database Option Objects is ON
    [main] [ 2012-04-17 23:14:19.198 BRT ] [OracleHome.initOptions:1256]  Database Option Real Application Clusters is ON
    [main] [ 2012-04-17 23:14:19.199 BRT ] [OracleHome.initOptions:1256]  Database Option Advanced replication is ON
    [main] [ 2012-04-17 23:14:19.199 BRT ] [OracleHome.initOptions:1256]  Database Option Bit-mapped indexes is ON
    [main] [ 2012-04-17 23:14:19.199 BRT ] [OracleHome.initOptions:1256]  Database Option Connection multiplexing is ON
    [main] [ 2012-04-17 23:14:19.200 BRT ] [OracleHome.initOptions:1256]  Database Option Connection pooling is ON
    [main] [ 2012-04-17 23:14:19.200 BRT ] [OracleHome.initOptions:1256]  Database Option Database queuing is ON
    [main] [ 2012-04-17 23:14:19.200 BRT ] [OracleHome.initOptions:1256]  Database Option Incremental backup and recovery is ON
    [main] [ 2012-04-17 23:14:19.200 BRT ] [OracleHome.initOptions:1256]  Database Option Instead-of triggers is ON
    [main] [ 2012-04-17 23:14:19.201 BRT ] [OracleHome.initOptions:1256]  Database Option Parallel backup and recovery is ON
    [main] [ 2012-04-17 23:14:19.201 BRT ] [OracleHome.initOptions:1256]  Database Option Parallel execution is ON
    [main] [ 2012-04-17 23:14:19.201 BRT ] [OracleHome.initOptions:1256]  Database Option Parallel load is ON
    [main] [ 2012-04-17 23:14:19.201 BRT ] [OracleHome.initOptions:1256]  Database Option Point-in-time tablespace recovery is ON
    [main] [ 2012-04-17 23:14:19.202 BRT ] [OracleHome.initOptions:1256]  Database Option Fine-grained access control is ON
    [main] [ 2012-04-17 23:14:19.202 BRT ] [OracleHome.initOptions:1256]  Database Option Proxy authentication/authorization is ON
    [main] [ 2012-04-17 23:14:19.202 BRT ] [OracleHome.initOptions:1256]  Database Option Change Data Capture is ON
    [main] [ 2012-04-17 23:14:19.203 BRT ] [OracleHome.initOptions:1256]  Database Option Plan Stability is ON
    [main] [ 2012-04-17 23:14:19.203 BRT ] [OracleHome.initOptions:1256]  Database Option Online Index Build is ON
    [main] [ 2012-04-17 23:14:19.203 BRT ] [OracleHome.initOptions:1256]  Database Option Coalesce Index is ON
    [main] [ 2012-04-17 23:14:19.204 BRT ] [OracleHome.initOptions:1256]  Database Option Managed Standby is ON
    [main] [ 2012-04-17 23:14:19.204 BRT ] [OracleHome.initOptions:1256]  Database Option Materialized view rewrite is ON
    [main] [ 2012-04-17 23:14:19.204 BRT ] [OracleHome.initOptions:1256]  Database Option Database resource manager is ON
    [main] [ 2012-04-17 23:14:19.204 BRT ] [OracleHome.initOptions:1256]  Database Option Spatial is ON
    [main] [ 2012-04-17 23:14:19.205 BRT ] [OracleHome.initOptions:1256]  Database Option Export transportable tablespaces is ON
    [main] [ 2012-04-17 23:14:19.205 BRT ] [OracleHome.initOptions:1256]  Database Option Transparent Application Failover is ON
    [main] [ 2012-04-17 23:14:19.206 BRT ] [OracleHome.initOptions:1256]  Database Option Fast-Start Fault Recovery is ON
    [main] [ 2012-04-17 23:14:19.206 BRT ] [OracleHome.initOptions:1256]  Database Option Sample Scan is ON
    [main] [ 2012-04-17 23:14:19.206 BRT ] [OracleHome.initOptions:1256]  Database Option Duplexed backups is ON
    [main] [ 2012-04-17 23:14:19.207 BRT ] [OracleHome.initOptions:1256]  Database Option Java is ON
    [main] [ 2012-04-17 23:14:19.207 BRT ] [OracleHome.initOptions:1256]  Database Option OLAP Window Functions is ON
    [main] [ 2012-04-17 23:14:19.207 BRT ] [OracleHome.initOptions:1256]  Database Option Block Media Recovery is ON
    [main] [ 2012-04-17 23:14:19.208 BRT ] [OracleHome.initOptions:1256]  Database Option Fine-grained Auditing is ON
    [main] [ 2012-04-17 23:14:19.208 BRT ] [OracleHome.initOptions:1256]  Database Option Application Role is ON
    [main] [ 2012-04-17 23:14:19.208 BRT ] [OracleHome.initOptions:1256]  Database Option Enterprise User Security is ON
    [main] [ 2012-04-17 23:14:19.209 BRT ] [OracleHome.initOptions:1256]  Database Option Oracle Data Guard is ON
    [main] [ 2012-04-17 23:14:19.209 BRT ] [OracleHome.initOptions:1256]  Database Option Oracle Label Security is ON
    [main] [ 2012-04-17 23:14:19.209 BRT ] [OracleHome.initOptions:1256]  Database Option OLAP is ON
    [main] [ 2012-04-17 23:14:19.210 BRT ] [OracleHome.initOptions:1256]  Database Option Basic Compression is ON
    [main] [ 2012-04-17 23:14:19.210 BRT ] [OracleHome.initOptions:1256]  Database Option Join index is ON
    [main] [ 2012-04-17 23:14:19.210 BRT ] [OracleHome.initOptions:1256]  Database Option Trial Recovery is ON
    [main] [ 2012-04-17 23:14:19.211 BRT ] [OracleHome.initOptions:1256]  Database Option Data Mining is ON
    [main] [ 2012-04-17 23:14:19.211 BRT ] [OracleHome.initOptions:1256]  Database Option Online Redefinition is ON
    [main] [ 2012-04-17 23:14:19.212 BRT ] [OracleHome.initOptions:1256]  Database Option Streams Capture is ON
    [main] [ 2012-04-17 23:14:19.212 BRT ] [OracleHome.initOptions:1256]  Database Option File Mapping is ON
    [main] [ 2012-04-17 23:14:19.213 BRT ] [OracleHome.initOptions:1256]  Database Option Block Change Tracking is ON
    [main] [ 2012-04-17 23:14:19.213 BRT ] [OracleHome.initOptions:1256]  Database Option Flashback Table is ON
    [main] [ 2012-04-17 23:14:19.213 BRT ] [OracleHome.initOptions:1256]  Database Option Flashback Database is ON
    [main] [ 2012-04-17 23:14:19.214 BRT ] [OracleHome.initOptions:1256]  Database Option Transparent Data Encryption is ON
    [main] [ 2012-04-17 23:14:19.214 BRT ] [OracleHome.initOptions:1256]  Database Option Backup Encryption is ON
    [main] [ 2012-04-17 23:14:19.214 BRT ] [OracleHome.initOptions:1256]  Database Option Unused Block Compression is ON
    [main] [ 2012-04-17 23:14:19.215 BRT ] [OracleHome.initOptions:1256]  Database Option Oracle Database Vault is ON
    [main] [ 2012-04-17 23:14:19.215 BRT ] [OracleHome.initOptions:1256]  Database Option Result Cache is ON
    [main] [ 2012-04-17 23:14:19.215 BRT ] [OracleHome.initOptions:1256]  Database Option SQL Plan Management is ON
    [main] [ 2012-04-17 23:14:19.216 BRT ] [OracleHome.initOptions:1256]  Database Option SecureFiles Encryption is ON
    [main] [ 2012-04-17 23:14:19.216 BRT ] [OracleHome.initOptions:1256]  Database Option Real Application Testing is ON
    [main] [ 2012-04-17 23:14:19.216 BRT ] [OracleHome.initOptions:1256]  Database Option Flashback Data Archive is ON
    [main] [ 2012-04-17 23:14:19.217 BRT ] [OracleHome.initOptions:1256]  Database Option DICOM is ON
    [main] [ 2012-04-17 23:14:19.217 BRT ] [OracleHome.initOptions:1256]  Database Option Active Data Guard is ON
    [main] [ 2012-04-17 23:14:19.218 BRT ] [OracleHome.initOptions:1256]  Database Option Server Flash Cache is ON
    [main] [ 2012-04-17 23:14:19.218 BRT ] [OracleHome.initOptions:1256]  Database Option Advanced Compression is ON
    [main] [ 2012-04-17 23:14:19.218 BRT ] [OracleHome.initOptions:1256]  Database Option XStream is ON
    [main] [ 2012-04-17 23:14:19.219 BRT ] [OracleHome.initOptions:1256]  Database Option Deferred Segment Creation is ON
    [main] [ 2012-04-17 23:14:19.219 BRT ] [OracleHome.initOptions:1260]  executing: select version from v$timezone_file
    [main] [ 2012-04-17 23:14:19.227 BRT ] [OracleHome.initOptions:1266]  Timezone file version is 14
    [main] [ 2012-04-17 23:14:20.663 BRT ] [SQLEngine.done:2167]  Done called
    [main] [ 2012-04-17 23:14:20.665 BRT ] [OsUtilsBase.deleteFile:1838]  OsUtilsBase.deleteFile: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initDBUA0.ora
    [main] [ 2012-04-17 23:14:20.666 BRT ] [OsUtilsBase.deleteFile:1838]  OsUtilsBase.deleteFile: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwDBUA0
    [main] [ 2012-04-17 23:14:20.666 BRT ] [OracleHome.initOptions:1301]  Database Options queried: 63
    [main] [ 2012-04-17 23:14:35.920 BRT ] [Host.checkOPS:2556]  Inside checkOPS
    Regards,
    Levi Pereira
  • 7. Re: mysterious services
    hqt200475 Newbie
    Currently Being Moderated
    Hi Levi,

    It´s great! Thanks for your competent and kind answers.

    regards

    hqt200475

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points