Martins Blog

Trying to explain complex things in simple terms

Little things worth knowing: ORACLE_SID, instance_name and the database names in Clusterware

Posted by Martin Bach on November 4, 2014

If you ever wanted to know how Clusterware works with registered database resources, read on! It takes a little while to get your head around the concepts of the ORACLE_SID, the instance_name and the database name as well. And how Clusterware deals with all of them. Although this post has been written on 12.1.0.2.0 on Linux, it should be applicable to 11.2 Clusterware as well. Oh and by Clusterware I mean Grid Infrastructure of course ;)

Why would you want to care?

Most deployments I have seen use the simple formula: ORACLE_SID = instance_name = db_name, especially in single instance deployments. RAC One Node and RAC databases are slightly different as their instances are usually named db_name where is the n-th instance in the cluster. What however, if you want to have separate SID, instance name and database names? I keep things simple for now and don’t throw in a different db_unique_name…

Assume for the first part of the article that you have created a database manually, e.g. not using dbca. In this case you define the database properties using the ORACLE_SID, the init.ora file (for db_name and instance_name) as well as the create database statement. Here is an example for my database, DB:

[oracle@oraclelinux ~]$ grep DB /etc/oratab
DB1:/u01/app/oracle/product/12.1.0.2/dbhome_1:N

And for the most basic init.ora:

[oracle@oraclelinux ~]$ cat /u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/initDB1.ora

db_name = DB
instance_name = DB1

db_create_file_dest = '+data'
compatible = 11.2.0.0.0
undo_management=AUTO
db_block_size = 8192
db_files = 300
processes = 500
sga_target=2G
filesystemio_options=setall
recyclebin = off
audit_file_dest=/u01/app/oracle/admin/DB/adump
control_files='+DATA/DB/CONTROLFILE/current.257.862665191'
diagnostic_dest=/u01/app/oracle

So let’s start with the SID

Question 1: can you easily change the ORACLE_SID? Answer is: yes you can. From the point of view of starting the database, the SID is used to look up configuration. Let’s change the ORACLE_SID to DBN (keeping the correct ORACLE_HOME) instead of DB1. Without changing any of the configuration files you will get this:

[oracle@oraclelinux ~]$ export ORACLE_SID=DBN
[oracle@oraclelinux ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 4 07:34:42 2014

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/initDBN.ora'
SQL>

What if we change these?

[oracle@oraclelinux dbs]$ mv initDB1.ora initDBN.ora
[oracle@oraclelinux dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 4 07:36:17 2014

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size		    2926472 bytes
Variable Size		 1677723768 bytes
Database Buffers	  452984832 bytes
Redo Buffers		   13848576 bytes
Database mounted.
Database opened.
SQL>

Checking the background processes you can see that they are named …DBN:

[oracle@oraclelinux dbs]$ ps -ef | grep smon
oracle    1519     1  0 07:02 ?        00:00:00 asm_smon_+ASM
oracle    5073     1  0 07:36 ?        00:00:00 ora_smon_DBN
oracle    5425  1586  0 07:37 pts/0    00:00:00 grep smon
[oracle@oraclelinux dbs]$

Now in this case we have an instance_name of DB1, and an ORACLE_SID of DBN instead of DB1. The database name is still set to DB.

Registering a resource in Clusterware

Question 2: How can you register such a construct in Clusterware? This is an Oracle Restart configuration so I can’t show you how it works in RAC, but I can show you the registration and management for the single instance deployment. Keeping the above settings, you can use the srvctl add database command to add the database to Clusterware. Here is an example. If you used DBCA to create the database, it would use the same technique. Note that I have updated /etc/oratab, replacing DB1 with DBN to reflect the new ORACLE_SID.

[oracle@oraclelinux ~]$ srvctl add database -h

Adds a database configuration to be managed by Oracle Restart.

Usage: srvctl add database -db <db_unique_name> -oraclehome <oracle_home> [-domain <domain_name>] [-spfile <spfile>] [-pwfile <password_file_path>] [-role {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY | FAR_SYNC}] [-startoption <start_options>] [-stopoption <stop_options>] [-dbname <db_name>] [-instance <inst_name>] [-policy {AUTOMATIC | MANUAL | NORESTART}] [-diskgroup "<diskgroup_list>"]
    -db <db_unique_name>           Unique name for the database
    -oraclehome <path>             Oracle home path
    -domain <domain>               Domain for database. Must be set if database has DB_DOMAIN set.
    -spfile <spfile>               Server parameter file path
    -pwfile <password_file_path>   Password file path
    -role <role>                   Role of the database (PRIMARY, PHYSICAL_STANDBY, LOGICAL_STANDBY, SNAPSHOT_STANDBY, FAR_SYNC)
    -startoption <start_options>   Startup options for the database. Examples of startup options are OPEN, MOUNT, or "READ ONLY".
    -stopoption <stop_options>     Stop options for the database. Examples of shutdown options are NORMAL, TRANSACTIONAL, IMMEDIATE, or ABORT.
    -dbname <db_name>              Database name (DB_NAME), if different from the unique name given by the -db option
    -instance <inst_name>          Instance name
    -policy <dbpolicy>             Management policy for the database (AUTOMATIC, MANUAL, or NORESTART)
    -diskgroup "<diskgroup_list>"  Comma separated list of disk group names
    -verbose                       Verbose output
    -help                          Print usage

[oracle@oraclelinux ~]$ srvctl add database -db DB -oraclehome /u01/app/oracle/product/12.1.0.2/dbhome_1 \
> -pwfile /u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/initDBN.ora -role PRIMARY \
> -instance DBN -policy MANUAL -diskgroup "DATA,RECO"

Now the database is registered and I can query it’s configuration:

[oracle@oraclelinux ~]$ srvctl config database -d DB
Database unique name: DB
Database name:
Oracle home: /u01/app/oracle/product/12.1.0.2/dbhome_1
Oracle user: oracle
Spfile:
Password file: /u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/initDBN.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: MANUAL
Disk Groups: DATA,RECO
Services:
OSDBA group:
OSOPER group:
Database instance: DBN

How does Clusterware connect to my database?

Question 3: How does Clusterware connect to the database to perform administrative tasks such as shutting it down and starting it up?

The answer to that question is found in the oraagent log file. Its location changed in 12c. In 11.2 you found all relevant logs in $GRID_HOME/log/$(hostname -s). In 12c they moved to the diagnostic_dest. In my case the oracle account “owns” Clusterware and the RDBMS stack so that’ll be in $ORACLE_BASE/diag. The complete path to the agent log in my environment is /u01/app/oracle/diag/crs/oraclelinux/crs/trace, and the file to check is ohasd_oraagent_oracle.trc. In RAC the file locations are different-in Oracle Restart there isn’t a CRSD process.

Since this file gets a little verbose even with the low log levels, it’s a good idea to note down when you were performing your test. In the output to follow I skipped all the bits that aren’t relevant for this discussion, otherwise you probably wouldn’t see the wood for the trees.

2014-11-04 07:49:11.128239 :    AGFW:3548362496: {0:0:1726} Agent received the message: RESOURCE_START[ora.db.db 1 1] ID 4098:4393

2014-11-04 07:49:11.128266 :    AGFW:3548362496: {0:0:1726} ora.db.db 1 1 state changed from: UNKNOWN to: STARTING

2014-11-04 07:49:11.130019 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] clsnUtils::cmdIdIsStart CmdId:257
2014-11-04 07:49:11.130051 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] DbAgent:getOracleSid 13 oracle_sid = DBN
2014-11-04 07:49:11.130059 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] DbAgent:getOracleSid  oracle_sid = DBN
2014-11-04 07:49:11.130121 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] Utils::getOracleHomeAttrib oracle_home:/u01/app/oracle/product/12.1.0.2/dbhome_1
2014-11-04 07:49:11.130213 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] ConnectionPool::ConnectionPool 2 m_oracleHome:/u01/app/oracle/product/12.1.0.2/dbhome_1, m_oracleSid:DBN, m_usrOraEnv:  m_instanceType:1 m_instanceVersion:12.1.0.2.0
2014-11-04 07:49:11.130254 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] DbAgent::setOracleSidAttrib updating GEN_USR_ORA_INST_NAME to DBN
2014-11-04 07:49:11.130267 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] clsnUtils::setResAttrib nonPerX current value GEN_USR_ORA_INST_NAME value 

2014-11-04 07:49:11.132339 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] ConfigFile::parse mmap name:prod nameWithCase:prod value:/u01/app/oracle/product/12.1.0.2/dbhome_1:N comment:line added by Agent StartCompleted

2014-11-04 07:49:11.135691 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] ConfigFile::parse mmap name:dbn nameWithCase:DBN value:/u01/app/oracle/product/12.1.0.2/dbhome_1:N comment:line added by Agent

2014-11-04 07:49:11.166499 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] start dependency = hard(ora.DATA.dg,ora.RECO.dg) weak(type:ora.listener.type,uniform:ora.ons)

2014-11-04 07:49:11.269849 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] DbAgent:getConnection oracleHome:/u01/app/oracle/product/12.1.0.2/dbhome_1 oracleSid:DBN usrOraEnv: resVersion:12.1.0.2.0
2014-11-04 07:49:11.269958 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] InstConnection:InstConnection: init:c80b40b0 oracleHome:/u01/app/oracle/product/12.1.0.2/dbhome_1 oracleSid:DBN instanceType:1 instanceVersion:12.1.0.2.0
2014-11-04 07:49:11.270631 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] clsnInstConnection::makeConnectStr UsrOraEnv ,ORACLE_BASE= m_oracleHome /u01/app/oracle/product/12.1.0.2/dbhome_1 Crshome /u01/app/oracle/product/12.1.0.2/grid
2014-11-04 07:49:11.271977 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] makeConnectStr = (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/oracle)(ARGV0=oracleDBN)(ENVS='ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1,ORACLE_SID=DBN,LD_LIBRARY_PATH=,ORACLE_BASE=')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(CONNECT_DATA=(SID=DBN))))
2014-11-04 07:49:11.275192 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] Container:start oracle home /u01/app/oracle/product/12.1.0.2/dbhome_1
2014-11-04 07:49:11.275657 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] InstConnection::connectInt: server not attached
2014-11-04 07:49:12.315345 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] InstConnection:connectInt connected

2014-11-04 07:49:24.231865 :    AGFW:3548362496: {0:0:1726} ora.db.db 1 1 state changed from: STARTING to: ONLINE

This should be enough information to get us started. Now what’s happening here? First of all the Agent Framework (AGFW) receives the command to start the database. Oracle Clusterware manages resources, and the database is one of these. Each resource to be managed has to have a profile in Clusterware. The profile determines what Clusterware does with a resource. The profile for the DB resource is shown here for reference.

[oracle@oraclelinux ~]$ crsctl stat res ora.db.db -p
NAME=ora.db.db
TYPE=ora.database.type
ACL=owner:oracle:rwx,pgrp:asmdba:r-x,other::r--,group:oinstall:r-x,user:oracle:rwx
ACTIONS=startoption,group:"asmdba",user:"oracle",group:"oinstall"
ACTION_SCRIPT=
ACTION_START_OPTION=
ACTION_TIMEOUT=600
ACTIVE_PLACEMENT=0
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
AUTO_START=never
CARDINALITY=1
CHECK_INTERVAL=1
CHECK_TIMEOUT=30
CLEAN_TIMEOUT=60
CLUSTER_DATABASE=false
DATABASE_TYPE=SINGLE
DB_UNIQUE_NAME=DB
DEGREE=1
DELETE_TIMEOUT=60
DESCRIPTION=Oracle Database resource
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=60
FAILURE_THRESHOLD=1
GEN_AUDIT_FILE_DEST=/u01/app/oracle/admin/DB/adump
GEN_START_OPTIONS=
GEN_USR_ORA_INST_NAME=DBN
HOSTING_MEMBERS=
INSTANCE_FAILOVER=1
INTERMEDIATE_TIMEOUT=0
LOAD=1
LOGGING_LEVEL=1
MANAGEMENT_POLICY=MANUAL
MODIFY_TIMEOUT=60
NLS_LANG=
OFFLINE_CHECK_INTERVAL=0
ONLINE_RELOCATION_TIMEOUT=0
ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1
ORACLE_HOME_OLD=
OS_CRASH_THRESHOLD=0
OS_CRASH_UPTIME=0
PLACEMENT=balanced
PWFILE=/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/initDBN.ora
RANK=0
RELOCATE_ACTION=0
RELOCATE_BY_DEPENDENCY=1
RESTART_ATTEMPTS=1
ROLE=PRIMARY
SCRIPT_TIMEOUT=60
SERVER_CATEGORY=
SERVER_POOLS=
SERVER_POOLS_PQ=
SPFILE=
START_CONCURRENCY=0
START_DEPENDENCIES=hard(ora.DATA.dg,ora.RECO.dg) weak(type:ora.listener.type,uniform:ora.ons)
START_TIMEOUT=600
STOP_CONCURRENCY=0
STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.DATA.dg,shutdown:ora.RECO.dg)
STOP_TIMEOUT=600
TYPE_VERSION=3.3
UPTIME_THRESHOLD=1h
USER_WORKLOAD=yes
USE_STICKINESS=0
USR_ORA_DB_NAME=
USR_ORA_DOMAIN=
USR_ORA_ENV=
USR_ORA_FLAGS=
USR_ORA_INST_NAME=DBN
USR_ORA_OPEN_MODE=open
USR_ORA_OPI=false
USR_ORA_STOP_MODE=immediate

Back to the start sequence. After the start command has been received the configuration is looked up in /etc/oratab. Any start dependencies (disk groups DATA and RECO, the listener and the ONS daemon as shown in the profile) are validated and satisfied if needed. The most interesting information is found in makeConnectStr: using the ORACLE_SID and the associated information (ORACLE_HOME) the connection string is dynamically created:

2014-11-04 07:49:11.271977 :CLSDYNAM:3552564992: [ora.db.db]{0:0:1726} [start] makeConnectStr = (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/oracle/prod
uct/12.1.0.2/dbhome_1/bin/oracle)(ARGV0=oracleDBN)(ENVS='ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1,ORACLE_SID=DBN,LD_LIBRARY_PATH=,ORACLE_BASE=')(ARG
S='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(CONNECT_DATA=(SID=DBN))))

This will be used to connect to the database instance and start it up. Oracle isn’t able to magically correct any configuration errors. If you define the instance to be DB1 in the srvctl add database command Clusterware won’t be able to start the instance. Just like you aren’t able to start it with SQL*Plus either. The oraagent_oracle.log file on RAC and the ohasd_oraagent_oracle.trc are good starting point to check for issues. Another useful flag is SRVM_TRACE:

[oracle@oraclelinux ~]$ grep SRVM_TRACE $(which srvctl)
if [ "X${SRVM_TRACE}" != "X" ]
  if [ "${SRVM_TRACE}" != "false" ]  && [ "${SRVM_TRACE}" != "FALSE" ]

Applied, this shows some rather verbose output but can help you in cases the resource won’t start. I’ll close this article with a traced call to get the status of the DB database and leave the interpretation of the output as an exercise to the reader.

[oracle@oraclelinux ~]$ SRVM_TRACE=TRUE srvctl status database -db DB
[main] [ 2014-11-04 08:11:36.482 GMT ] [OPSCTLDriver.setInternalDebugLevel:325]  tracing is true at level 2 to file null
[main] [ 2014-11-04 08:11:36.488 GMT ] [OPSCTLDriver.main:162]  SRVCTL arguments : args[0]=status args[1]=database args[2]=-db args[3]=DB
[main] [ 2014-11-04 08:11:36.490 GMT ] [SRVMContext.init:114]  Performing SRVM Context init. Init Counter=1
[main] [ 2014-11-04 08:11:36.527 GMT ] [Library.load:194]  library.load
[main] [ 2014-11-04 08:11:36.529 GMT ] [sPlatform.isHybrid:66]  osName=Linux osArch=amd64 JVM=64 rc=false
[main] [ 2014-11-04 08:11:36.530 GMT ] [sPlatform.isHybrid:66]  osName=Linux osArch=amd64 JVM=64 rc=false
[main] [ 2014-11-04 08:11:36.531 GMT ] [Library.load:271]  Loading  library /u01/app/oracle/product/12.1.0.2/dbhome_1/lib/libsrvmhas12.so
[main] [ 2014-11-04 08:11:36.546 GMT ] [SRVMContext.init:131]  SRVM Context init-ed
[main] [ 2014-11-04 08:11:36.568 GMT ] [Version.isPre:610]  version to be checked 12.1.0.2.0 major version to check against 10
[main] [ 2014-11-04 08:11:36.574 GMT ] [Version.isPre:621]  isPre.java: Returning FALSE
[main] [ 2014-11-04 08:11:36.580 GMT ] [OCR.loadLibrary:328]
 Inside constructor of OCR
[main] [ 2014-11-04 08:11:36.584 GMT ] [OCR.loadLibrary:336]  Going to load the ocr library
[main] [ 2014-11-04 08:11:36.585 GMT ] [Library.load:194]  library.load
[main] [ 2014-11-04 08:11:36.585 GMT ] [sPlatform.isHybrid:66]  osName=Linux osArch=amd64 JVM=64 rc=false
[main] [ 2014-11-04 08:11:36.587 GMT ] [sPlatform.isHybrid:66]  osName=Linux osArch=amd64 JVM=64 rc=false
[main] [ 2014-11-04 08:11:36.588 GMT ] [Library.load:271]  Loading  library /u01/app/oracle/product/12.1.0.2/dbhome_1/lib/libsrvmocr12.so
[main] [ 2014-11-04 08:11:36.589 GMT ] [OCR.loadLibrary:338]  loaded ocr libraries
[main] [ 2014-11-04 08:11:36.590 GMT ] [SRVMContext.init:114]  Performing SRVM Context init. Init Counter=2
[main] [ 2014-11-04 08:11:36.590 GMT ] [OCR.isCluster:1000]  Calling OCRNative for isCluster()
[main] [ 2014-11-04 08:11:36.592 GMT ] [OCR.isCluster:1004]  OCR Result status = true
[main] [ 2014-11-04 08:11:36.593 GMT ] [OCR.isCluster:1016]  Bolean result = false
[main] [ 2014-11-04 08:11:36.594 GMT ] [CommandLineParser.<init>:488]  Is this a cluster? : false
[main] [ 2014-11-04 08:11:36.599 GMT ] [CommandLineParser.parse:678]  parsing cmdline args
[main] [ 2014-11-04 08:11:36.601 GMT ] [CommandLineParser.antlrParse:500]  parsing cmdline args using antlr
[main] [ 2014-11-04 08:11:36.603 GMT ] [CommandLineParser.antlrParse:558]  input args are status database -db %OPTVAL%DB
[main] [ 2014-11-04 08:11:36.641 GMT ] [SrvExprParser.optverb:826]  antlr: Match verb
[main] [ 2014-11-04 08:11:36.642 GMT ] [SrvExprParser.optnoun:873]  antlr: Match noun
[main] [ 2014-11-04 08:11:36.644 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for output
[main] [ 2014-11-04 08:11:36.644 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:36.645 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for compatible
[main] [ 2014-11-04 08:11:36.645 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:36.646 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for HELP
[main] [ 2014-11-04 08:11:36.647 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:36.648 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for help
[main] [ 2014-11-04 08:11:36.648 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:36.649 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for file
[main] [ 2014-11-04 08:11:36.649 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:36.650 GMT ] [SrvExprParser.optval:906]  antlr: Call initOptVals for status database
[main] [ 2014-11-04 08:11:36.650 GMT ] [SrvExprParser.optval:946]  antlr: Getting OPTION VALUE
[main] [ 2014-11-04 08:11:36.651 GMT ] [SrvExprParser.optval:948]  antlr: Set -db value: %OPTVAL%DB
[main] [ 2014-11-04 08:11:36.652 GMT ] [CmdOptVals.checkAndSet:734]  Calling checkAndSet for -db = -db
[main] [ 2014-11-04 08:11:36.653 GMT ] [CmdOptVals.checkAndSet:802]  Calling checkAndSet for OptEnum db = DB
[main] [ 2014-11-04 08:11:36.654 GMT ] [OptVal.check:180]  Value DB for option db will be set.
[main] [ 2014-11-04 08:11:36.655 GMT ] [OptVal.check:221]  db = DB
[main] [ 2014-11-04 08:11:36.655 GMT ] [SrvExprParser.cmdline:529]  antlr: Set verb and noun and options
[main] [ 2014-11-04 08:11:36.656 GMT ] [SrvExprParser.srvrule:219]  antlr: Return optvals
[main] [ 2014-11-04 08:11:36.656 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for file
[main] [ 2014-11-04 08:11:36.657 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:36.658 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for help
[main] [ 2014-11-04 08:11:36.658 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:36.659 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for db
[main] [ 2014-11-04 08:11:36.660 GMT ] [OptVal.isSet:150]  m_value is DB
[main] [ 2014-11-04 08:11:36.660 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for database
[main] [ 2014-11-04 08:11:36.661 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:36.661 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for db
[main] [ 2014-11-04 08:11:36.662 GMT ] [OptVal.isSet:150]  m_value is DB
[main] [ 2014-11-04 08:11:36.663 GMT ] [CommandLineParser.checkOptionalCombOptions:813]  Loop for combList(0)
[main] [ 2014-11-04 08:11:36.663 GMT ] [CommandLineParser.checkOptionalCombOptions:815]  Set isMatched to true
[main] [ 2014-11-04 08:11:36.664 GMT ] [CommandLineParser.checkOptionalCombOptions:829]  Check option -db
[main] [ 2014-11-04 08:11:36.665 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for db
[main] [ 2014-11-04 08:11:36.666 GMT ] [OptVal.isSet:150]  m_value is DB
[main] [ 2014-11-04 08:11:36.666 GMT ] [CommandLineParser.checkOptionalCombOptions:813]  Loop for combList(1)
[main] [ 2014-11-04 08:11:36.667 GMT ] [CommandLineParser.checkOptionalCombOptions:815]  Set isMatched to true
[main] [ 2014-11-04 08:11:36.667 GMT ] [CommandLineParser.checkOptionalCombOptions:829]  Check option -thisversion
[main] [ 2014-11-04 08:11:36.668 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for thisversion
[main] [ 2014-11-04 08:11:36.668 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:36.669 GMT ] [CommandLineParser.checkOptionalCombOptions:846]  Set isMatched to false
[main] [ 2014-11-04 08:11:36.671 GMT ] [CommandLineParser.checkOptionalCombOptions:813]  Loop for combList(2)
[main] [ 2014-11-04 08:11:36.672 GMT ] [CommandLineParser.checkOptionalCombOptions:815]  Set isMatched to true
[main] [ 2014-11-04 08:11:36.672 GMT ] [CommandLineParser.checkOptionalCombOptions:829]  Check option -thishome
[main] [ 2014-11-04 08:11:36.673 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for thishome
[main] [ 2014-11-04 08:11:36.674 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:36.675 GMT ] [CommandLineParser.checkOptionalCombOptions:846]  Set isMatched to false
[main] [ 2014-11-04 08:11:36.675 GMT ] [CmdOptVals.checkRefChoices:1066]  in checkRefChoices
[main] [ 2014-11-04 08:11:36.676 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for output
[main] [ 2014-11-04 08:11:36.677 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:36.678 GMT ] [OPSCTLDriver.main:215]  Attempting to register interrupt handler for OPSCTL driver
[main] [ 2014-11-04 08:11:36.681 GMT ] [InterruptHandler.registerInterruptHandler:60]  Registering shutdown hook.....
[main] [ 2014-11-04 08:11:36.682 GMT ] [InterruptHandler.registerInterruptHandler:62]  Registered shutdown hook.....
[main] [ 2014-11-04 08:11:36.683 GMT ] [SRVCTLHandler.registerInterruptHandler:86]  Registered interrupt handler for OPSCTL driver
[main] [ 2014-11-04 08:11:36.684 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for compatible
[main] [ 2014-11-04 08:11:36.684 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:36.685 GMT ] [OPSCTLDriver.execute:345]  checking for -H option: print verbose command syntax
[main] [ 2014-11-04 08:11:36.685 GMT ] [CmdOptVals.isOptionSet:917]  Check isOptionSet for HELP
[main] [ 2014-11-04 08:11:36.687 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for help
[main] [ 2014-11-04 08:11:36.687 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:36.688 GMT ] [CmdOptVals.isOptionSet:917]  Check isOptionSet for HELP_H
[main] [ 2014-11-04 08:11:36.688 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for HELP
[main] [ 2014-11-04 08:11:36.689 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:36.711 GMT ] [CRSCache.<clinit>:74]  CRSCache: useCache is false
[main] [ 2014-11-04 08:11:36.712 GMT ] [OPSCTLDriver.execute:411]  executing 2-word command verb=6 noun=101
[main] [ 2014-11-04 08:11:36.746 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for db
[main] [ 2014-11-04 08:11:36.748 GMT ] [OptVal.isSet:150]  m_value is DB
[main] [ 2014-11-04 08:11:36.763 GMT ] [DatabaseFactoryImpl.getInstance:320]  s_instance is null
[main] [ 2014-11-04 08:11:36.765 GMT ] [DatabaseFactoryImpl.getInstance:323]  before returning object
[main] [ 2014-11-04 08:11:36.765 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for db
[main] [ 2014-11-04 08:11:36.766 GMT ] [OptVal.isSet:150]  m_value is DB
[main] [ 2014-11-04 08:11:36.767 GMT ] [DatabaseFactoryImpl.getDatabase:995]  Before calling get database with name and version
[main] [ 2014-11-04 08:11:36.815 GMT ] [HASContext.<init>:125]  moduleInit = 67
[main] [ 2014-11-04 08:11:36.816 GMT ] [SRVMContext.init:114]  Performing SRVM Context init. Init Counter=3
[main] [ 2014-11-04 08:11:36.816 GMT ] [HASContext.<init>:136]  Initialised SRVMContext
[main] [ 2014-11-04 08:11:36.882 GMT ] [EntityOperations.isEntityRegisteredCRSD:353]  entity: ora.db.db, type: 1, registered: true
[main] [ 2014-11-04 08:11:36.896 GMT ] [CRSCache.getAttributesFromCache:220]  updated: ora.db.db [<DATABASE_TYPE:SINGLE>, <ORACLE_HOME:/u01/app/oracle/product/12.1.0.2/dbhome_1>, <VERSION:12.1.0.2.0>]
[main] [ 2014-11-04 08:11:36.898 GMT ] [DatabaseFactoryImpl.internalGetDatabase:1115]  dbVersion4 = 12.1.0.2
[main] [ 2014-11-04 08:11:36.901 GMT ] [DatabaseFactoryImpl.internalGetDatabase:1129]  db type SINGLE
[main] [ 2014-11-04 08:11:36.905 GMT ] [Version.isPre:610]  version to be checked 12.1.0.2.0 major version to check against 11
[main] [ 2014-11-04 08:11:36.906 GMT ] [Version.isPre:621]  isPre.java: Returning FALSE
[main] [ 2014-11-04 08:11:36.907 GMT ] [Version.isPre:642]  version to be checked 12.1.0.2.0 major version to check against 11 minor version to check against 2
[main] [ 2014-11-04 08:11:36.908 GMT ] [Version.isPre:651]  isPre: Returning FALSE for major version check
[main] [ 2014-11-04 08:11:36.908 GMT ] [DatabaseFactoryImpl.getSingleInstanceDatabase:1923]  Getting single instance database for DB
[main] [ 2014-11-04 08:11:36.920 GMT ] [DatabaseAction.<init>:80]  Created Database Action
[main] [ 2014-11-04 08:11:36.932 GMT ] [CRSCache.getAttributesFromCache:220]  updated: ora.db.db [<DB_UNIQUE_NAME:DB>]
[main] [ 2014-11-04 08:11:36.933 GMT ] [DatabaseImpl.crsResource:5254]  calling parent's crsResource
[main] [ 2014-11-04 08:11:36.980 GMT ] [EntityOperations.isEntityRegisteredCRSD:353]  entity: ora.db.db, type: 1, registered: true
[main] [ 2014-11-04 08:11:36.987 GMT ] [CRSCache.getAttributesFromCache:229]  CRS cache: ora.db.db [<DATABASE_TYPE:SINGLE>]
[main] [ 2014-11-04 08:11:36.990 GMT ] [Version.isPre:610]  version to be checked 12.1.0.2.0 major version to check against 11
[main] [ 2014-11-04 08:11:36.991 GMT ] [Version.isPre:621]  isPre.java: Returning FALSE
[main] [ 2014-11-04 08:11:36.991 GMT ] [Version.isPre:691]  version to be checked 12.1.0.2.0 major version to check against 11 minor version to check against 2 patchset version to check against 2
[main] [ 2014-11-04 08:11:36.992 GMT ] [Version.isPre:701]  isPre: Returning FALSE for major version check
[main] [ 2014-11-04 08:11:36.993 GMT ] [CRSCache.getAttributesFromCRS:155]  CRS: name: ora.db.db, type 1, node: null
[main] [ 2014-11-04 08:11:36.994 GMT ] [CRSCache.getAttributesFromCRS:156]  attrs: all
[main] [ 2014-11-04 08:11:37.031 GMT ] [CRSCache.getAttributesFromCRS:163]  CRS: [<STATE:ONLINE>, <TARGET:ONLINE>, <ACL:owner:oracle:rwx,pgrp:asmdba:r-x,other::r--,group:oinstall:r-x,user:oracle:rwx>, <ACTIONS:startoption,group:"asmdba",user:"oracle",group:"oinstall">, <ACTION_FAILURE_TEMPLATE:>, <ACTION_SCRIPT:>, <ACTION_START_OPTION:>, <ACTION_TIMEOUT:600>, <ACTIVE_PLACEMENT:0>, <AGENT_FILENAME:%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%>, <ALERT_TEMPLATE:>, <ALIAS_NAME:>, <AUTO_START:never>, <CARDINALITY:1>, <CARDINALITY_ID:0>, <CHECK_INTERVAL:1>, <CHECK_TIMEOUT:30>, <CLEAN_TIMEOUT:60>, <CLUSTER_DATABASE:false>, <CONFIG_VERSION:1>, <CREATION_SEED:37>, <DATABASE_TYPE:SINGLE>, <DB_UNIQUE_NAME:DB>, <DEFAULT_TEMPLATE:PROPERTY(RESOURCE_CLASS=database) PROPERTY(DB_UNIQUE_NAME= CONCAT(PARSE(%NAME%, ., 2), %USR_ORA_DOMAIN%, .)) ELEMENT(INSTANCE_NAME= %GEN_USR_ORA_INST_NAME%) ELEMENT(DATABASE_TYPE= %DATABASE_TYPE%)>, <DEGREE:1>, <DEGREE_ID:0>, <DELETE_TIMEOUT:60>, <DESCRIPTION:Oracle Database resource>, <ENABLED:1>, <FAILOVER_DELAY:0>, <FAILURE_INTERVAL:60>, <FAILURE_THRESHOLD:1>, <GEN_AUDIT_FILE_DEST:/u01/app/oracle/admin/DB/adump>, <GEN_START_OPTIONS:>, <GEN_USR_ORA_INST_NAME:DBN>, <HOSTING_MEMBERS:>, <ID:ora.db.db>, <INSTANCE_COUNT:1>, <INSTANCE_FAILOVER:1>, <INTERMEDIATE_TIMEOUT:0>, <LOAD:1>, <LOGGING_LEVEL:1>, <MANAGEMENT_POLICY:MANUAL>, <MODIFY_TIMEOUT:60>, <NAME:ora.db.db>, <NLS_LANG:>, <NOT_RESTARTING_TEMPLATE:>, <OFFLINE_CHECK_INTERVAL:0>, <ONLINE_RELOCATION_TIMEOUT:0>, <ORACLE_HOME:/u01/app/oracle/product/12.1.0.2/dbhome_1>, <ORACLE_HOME_OLD:>, <OS_CRASH_THRESHOLD:0>, <OS_CRASH_UPTIME:0>, <PLACEMENT:balanced>, <PROFILE_CHANGE_TEMPLATE:>, <PWFILE:/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/initDBN.ora>, <RANK:0>, <RELOCATE_ACTION:0>, <RELOCATE_BY_DEPENDENCY:1>, <RESTART_ATTEMPTS:1>, <ROLE:PRIMARY>, <SCRIPT_TIMEOUT:60>, <SERVER_CATEGORY:>, <SERVER_POOLS:>, <SERVER_POOLS_PQ:>, <SPFILE:>, <START_CONCURRENCY:0>, <START_DEPENDENCIES:hard(ora.DATA.dg,ora.RECO.dg) weak(type:ora.listener.type,uniform:ora.ons)>, <START_TIMEOUT:600>, <STATE_CHANGE_TEMPLATE:>, <STOP_CONCURRENCY:0>, <STOP_DEPENDENCIES:hard(intermediate:ora.asm,shutdown:ora.DATA.dg,shutdown:ora.RECO.dg)>, <STOP_TIMEOUT:600>, <TYPE:ora.database.type>, <TYPE_VERSION:3.3>, <UPTIME_THRESHOLD:1h>, <USER_WORKLOAD:yes>, <USE_STICKINESS:0>, <USR_ORA_DB_NAME:>, <USR_ORA_DOMAIN:>, <USR_ORA_ENV:>, <USR_ORA_FLAGS:>, <USR_ORA_INST_NAME:DBN>, <USR_ORA_OPEN_MODE:open>, <USR_ORA_OPI:false>, <USR_ORA_STOP_MODE:immediate>, <VERSION:12.1.0.2.0>]
[main] [ 2014-11-04 08:11:37.032 GMT ] [DatabaseImpl.getDBInstances:2356]  name=STATE, value=ONLINE
[main] [ 2014-11-04 08:11:37.033 GMT ] [DatabaseImpl.getDBInstances:2356]  name=TARGET, value=ONLINE
[main] [ 2014-11-04 08:11:37.034 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ACL, value=owner:oracle:rwx,pgrp:asmdba:r-x,other::r--,group:oinstall:r-x,user:oracle:rwx
[main] [ 2014-11-04 08:11:37.035 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ACTIONS, value=startoption,group:"asmdba",user:"oracle",group:"oinstall"
[main] [ 2014-11-04 08:11:37.035 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ACTION_FAILURE_TEMPLATE, value=
[main] [ 2014-11-04 08:11:37.036 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ACTION_SCRIPT, value=
[main] [ 2014-11-04 08:11:37.037 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ACTION_START_OPTION, value=
[main] [ 2014-11-04 08:11:37.038 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ACTION_TIMEOUT, value=600
[main] [ 2014-11-04 08:11:37.038 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ACTIVE_PLACEMENT, value=0
[main] [ 2014-11-04 08:11:37.039 GMT ] [DatabaseImpl.getDBInstances:2356]  name=AGENT_FILENAME, value=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
[main] [ 2014-11-04 08:11:37.039 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ALERT_TEMPLATE, value=
[main] [ 2014-11-04 08:11:37.041 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ALIAS_NAME, value=
[main] [ 2014-11-04 08:11:37.042 GMT ] [DatabaseImpl.getDBInstances:2356]  name=AUTO_START, value=never
[main] [ 2014-11-04 08:11:37.042 GMT ] [DatabaseImpl.getDBInstances:2356]  name=CARDINALITY, value=1
[main] [ 2014-11-04 08:11:37.043 GMT ] [DatabaseImpl.getDBInstances:2356]  name=CARDINALITY_ID, value=0
[main] [ 2014-11-04 08:11:37.045 GMT ] [DatabaseImpl.getDBInstances:2356]  name=CHECK_INTERVAL, value=1
[main] [ 2014-11-04 08:11:37.047 GMT ] [DatabaseImpl.getDBInstances:2356]  name=CHECK_TIMEOUT, value=30
[main] [ 2014-11-04 08:11:37.047 GMT ] [DatabaseImpl.getDBInstances:2356]  name=CLEAN_TIMEOUT, value=60
[main] [ 2014-11-04 08:11:37.048 GMT ] [DatabaseImpl.getDBInstances:2356]  name=CLUSTER_DATABASE, value=false
[main] [ 2014-11-04 08:11:37.049 GMT ] [DatabaseImpl.getDBInstances:2356]  name=CONFIG_VERSION, value=1
[main] [ 2014-11-04 08:11:37.050 GMT ] [DatabaseImpl.getDBInstances:2356]  name=CREATION_SEED, value=37
[main] [ 2014-11-04 08:11:37.051 GMT ] [DatabaseImpl.getDBInstances:2356]  name=DATABASE_TYPE, value=SINGLE
[main] [ 2014-11-04 08:11:37.053 GMT ] [DatabaseImpl.getDBInstances:2356]  name=DB_UNIQUE_NAME, value=DB
[main] [ 2014-11-04 08:11:37.053 GMT ] [DatabaseImpl.getDBInstances:2356]  name=DEFAULT_TEMPLATE, value=PROPERTY(RESOURCE_CLASS=database) PROPERTY(DB_UNIQUE_NAME= CONCAT(PARSE(%NAME%, ., 2), %USR_ORA_DOMAIN%, .)) ELEMENT(INSTANCE_NAME= %GEN_USR_ORA_INST_NAME%) ELEMENT(DATABASE_TYPE= %DATABASE_TYPE%)
[main] [ 2014-11-04 08:11:37.054 GMT ] [DatabaseImpl.getDBInstances:2356]  name=DEGREE, value=1
[main] [ 2014-11-04 08:11:37.058 GMT ] [DatabaseImpl.getDBInstances:2356]  name=DEGREE_ID, value=0
[main] [ 2014-11-04 08:11:37.059 GMT ] [DatabaseImpl.getDBInstances:2356]  name=DELETE_TIMEOUT, value=60
[main] [ 2014-11-04 08:11:37.060 GMT ] [DatabaseImpl.getDBInstances:2356]  name=DESCRIPTION, value=Oracle Database resource
[main] [ 2014-11-04 08:11:37.061 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ENABLED, value=1
[main] [ 2014-11-04 08:11:37.061 GMT ] [DatabaseImpl.getDBInstances:2356]  name=FAILOVER_DELAY, value=0
[main] [ 2014-11-04 08:11:37.062 GMT ] [DatabaseImpl.getDBInstances:2356]  name=FAILURE_INTERVAL, value=60
[main] [ 2014-11-04 08:11:37.063 GMT ] [DatabaseImpl.getDBInstances:2356]  name=FAILURE_THRESHOLD, value=1
[main] [ 2014-11-04 08:11:37.063 GMT ] [DatabaseImpl.getDBInstances:2356]  name=GEN_AUDIT_FILE_DEST, value=/u01/app/oracle/admin/DB/adump
[main] [ 2014-11-04 08:11:37.064 GMT ] [DatabaseImpl.getDBInstances:2356]  name=GEN_START_OPTIONS, value=
[main] [ 2014-11-04 08:11:37.064 GMT ] [DatabaseImpl.getDBInstances:2356]  name=GEN_USR_ORA_INST_NAME, value=DBN
[main] [ 2014-11-04 08:11:37.066 GMT ] [DatabaseImpl.getDBInstances:2356]  name=HOSTING_MEMBERS, value=
[main] [ 2014-11-04 08:11:37.066 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ID, value=ora.db.db
[main] [ 2014-11-04 08:11:37.067 GMT ] [DatabaseImpl.getDBInstances:2356]  name=INSTANCE_COUNT, value=1
[main] [ 2014-11-04 08:11:37.068 GMT ] [DatabaseImpl.getDBInstances:2356]  name=INSTANCE_FAILOVER, value=1
[main] [ 2014-11-04 08:11:37.068 GMT ] [DatabaseImpl.getDBInstances:2356]  name=INTERMEDIATE_TIMEOUT, value=0
[main] [ 2014-11-04 08:11:37.069 GMT ] [DatabaseImpl.getDBInstances:2356]  name=LOAD, value=1
[main] [ 2014-11-04 08:11:37.069 GMT ] [DatabaseImpl.getDBInstances:2356]  name=LOGGING_LEVEL, value=1
[main] [ 2014-11-04 08:11:37.071 GMT ] [DatabaseImpl.getDBInstances:2356]  name=MANAGEMENT_POLICY, value=MANUAL
[main] [ 2014-11-04 08:11:37.072 GMT ] [DatabaseImpl.getDBInstances:2356]  name=MODIFY_TIMEOUT, value=60
[main] [ 2014-11-04 08:11:37.072 GMT ] [DatabaseImpl.getDBInstances:2356]  name=NAME, value=ora.db.db
[main] [ 2014-11-04 08:11:37.073 GMT ] [DatabaseImpl.getDBInstances:2356]  name=NLS_LANG, value=
[main] [ 2014-11-04 08:11:37.074 GMT ] [DatabaseImpl.getDBInstances:2356]  name=NOT_RESTARTING_TEMPLATE, value=
[main] [ 2014-11-04 08:11:37.075 GMT ] [DatabaseImpl.getDBInstances:2356]  name=OFFLINE_CHECK_INTERVAL, value=0
[main] [ 2014-11-04 08:11:37.076 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ONLINE_RELOCATION_TIMEOUT, value=0
[main] [ 2014-11-04 08:11:37.082 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ORACLE_HOME, value=/u01/app/oracle/product/12.1.0.2/dbhome_1
[main] [ 2014-11-04 08:11:37.083 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ORACLE_HOME_OLD, value=
[main] [ 2014-11-04 08:11:37.084 GMT ] [DatabaseImpl.getDBInstances:2356]  name=OS_CRASH_THRESHOLD, value=0
[main] [ 2014-11-04 08:11:37.085 GMT ] [DatabaseImpl.getDBInstances:2356]  name=OS_CRASH_UPTIME, value=0
[main] [ 2014-11-04 08:11:37.086 GMT ] [DatabaseImpl.getDBInstances:2356]  name=PLACEMENT, value=balanced
[main] [ 2014-11-04 08:11:37.086 GMT ] [DatabaseImpl.getDBInstances:2356]  name=PROFILE_CHANGE_TEMPLATE, value=
[main] [ 2014-11-04 08:11:37.087 GMT ] [DatabaseImpl.getDBInstances:2356]  name=PWFILE, value=/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/initDBN.ora
[main] [ 2014-11-04 08:11:37.087 GMT ] [DatabaseImpl.getDBInstances:2356]  name=RANK, value=0
[main] [ 2014-11-04 08:11:37.088 GMT ] [DatabaseImpl.getDBInstances:2356]  name=RELOCATE_ACTION, value=0
[main] [ 2014-11-04 08:11:37.089 GMT ] [DatabaseImpl.getDBInstances:2356]  name=RELOCATE_BY_DEPENDENCY, value=1
[main] [ 2014-11-04 08:11:37.090 GMT ] [DatabaseImpl.getDBInstances:2356]  name=RESTART_ATTEMPTS, value=1
[main] [ 2014-11-04 08:11:37.090 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ROLE, value=PRIMARY
[main] [ 2014-11-04 08:11:37.091 GMT ] [DatabaseImpl.getDBInstances:2356]  name=SCRIPT_TIMEOUT, value=60
[main] [ 2014-11-04 08:11:37.095 GMT ] [DatabaseImpl.getDBInstances:2356]  name=SERVER_CATEGORY, value=
[main] [ 2014-11-04 08:11:37.097 GMT ] [DatabaseImpl.getDBInstances:2356]  name=SERVER_POOLS, value=
[main] [ 2014-11-04 08:11:37.098 GMT ] [DatabaseImpl.getDBInstances:2356]  name=SERVER_POOLS_PQ, value=
[main] [ 2014-11-04 08:11:37.098 GMT ] [DatabaseImpl.getDBInstances:2356]  name=SPFILE, value=
[main] [ 2014-11-04 08:11:37.099 GMT ] [DatabaseImpl.getDBInstances:2356]  name=START_CONCURRENCY, value=0
[main] [ 2014-11-04 08:11:37.099 GMT ] [DatabaseImpl.getDBInstances:2356]  name=START_DEPENDENCIES, value=hard(ora.DATA.dg,ora.RECO.dg) weak(type:ora.listener.type,uniform:ora.ons)
[main] [ 2014-11-04 08:11:37.100 GMT ] [DatabaseImpl.getDBInstances:2356]  name=START_TIMEOUT, value=600
[main] [ 2014-11-04 08:11:37.101 GMT ] [DatabaseImpl.getDBInstances:2356]  name=STATE_CHANGE_TEMPLATE, value=
[main] [ 2014-11-04 08:11:37.101 GMT ] [DatabaseImpl.getDBInstances:2356]  name=STOP_CONCURRENCY, value=0
[main] [ 2014-11-04 08:11:37.102 GMT ] [DatabaseImpl.getDBInstances:2356]  name=STOP_DEPENDENCIES, value=hard(intermediate:ora.asm,shutdown:ora.DATA.dg,shutdown:ora.RECO.dg)
[main] [ 2014-11-04 08:11:37.103 GMT ] [DatabaseImpl.getDBInstances:2356]  name=STOP_TIMEOUT, value=600
[main] [ 2014-11-04 08:11:37.104 GMT ] [DatabaseImpl.getDBInstances:2356]  name=TYPE, value=ora.database.type
[main] [ 2014-11-04 08:11:37.105 GMT ] [DatabaseImpl.getDBInstances:2356]  name=TYPE_VERSION, value=3.3
[main] [ 2014-11-04 08:11:37.106 GMT ] [DatabaseImpl.getDBInstances:2356]  name=UPTIME_THRESHOLD, value=1h
[main] [ 2014-11-04 08:11:37.107 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USER_WORKLOAD, value=yes
[main] [ 2014-11-04 08:11:37.108 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USE_STICKINESS, value=0
[main] [ 2014-11-04 08:11:37.109 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USR_ORA_DB_NAME, value=
[main] [ 2014-11-04 08:11:37.110 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USR_ORA_DOMAIN, value=
[main] [ 2014-11-04 08:11:37.110 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USR_ORA_ENV, value=
[main] [ 2014-11-04 08:11:37.111 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USR_ORA_FLAGS, value=
[main] [ 2014-11-04 08:11:37.112 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USR_ORA_INST_NAME, value=DBN
[main] [ 2014-11-04 08:11:37.112 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USR_ORA_OPEN_MODE, value=open
[main] [ 2014-11-04 08:11:37.114 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USR_ORA_OPI, value=false
[main] [ 2014-11-04 08:11:37.114 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USR_ORA_STOP_MODE, value=immediate
[main] [ 2014-11-04 08:11:37.115 GMT ] [DatabaseImpl.getDBInstances:2356]  name=VERSION, value=12.1.0.2.0
[main] [ 2014-11-04 08:11:37.126 GMT ] [CRSCache.getAttributesFromCache:229]  CRS cache: ora.db.db [<DATABASE_TYPE:SINGLE>]
[main] [ 2014-11-04 08:11:37.130 GMT ] [CRSCache.getAttributesFromCRS:155]  CRS: name: ora.db.db, type 1, node: null
[main] [ 2014-11-04 08:11:37.131 GMT ] [CRSCache.getAttributesFromCRS:156]  attrs: [HOSTING_MEMBERS]
[main] [ 2014-11-04 08:11:37.134 GMT ] [CRSCache.getAttributesFromCRS:163]  CRS: [<HOSTING_MEMBERS:>]
[main] [ 2014-11-04 08:11:37.136 GMT ] [CRSCache.getAttributesFromCRS:155]  CRS: name: ora.db.db, type 1, node: null
[main] [ 2014-11-04 08:11:37.136 GMT ] [CRSCache.getAttributesFromCRS:156]  attrs: [SERVER_POOLS]
[main] [ 2014-11-04 08:11:37.158 GMT ] [CRSCache.getAttributesFromCRS:163]  CRS: [<SERVER_POOLS:>]
[main] [ 2014-11-04 08:11:37.169 GMT ] [CRSCache.getAttributesFromCRS:155]  CRS: name: ora.db.db, type 1, node: null
[main] [ 2014-11-04 08:11:37.170 GMT ] [CRSCache.getAttributesFromCRS:156]  attrs: [SERVER_POOLS]
[main] [ 2014-11-04 08:11:37.175 GMT ] [CRSCache.getAttributesFromCRS:163]  CRS: [<SERVER_POOLS:>]
[main] [ 2014-11-04 08:11:37.176 GMT ] [DatabaseImpl.serverPoolsHelper:5977]  list of server pool names =
[main] [ 2014-11-04 08:11:37.178 GMT ] [DatabaseImpl.crsResource:5254]  calling parent's crsResource
[main] [ 2014-11-04 08:11:37.201 GMT ] [EntityOperations.isEntityRegisteredCRSD:353]  entity: ora.db.db, type: 1, registered: true
[main] [ 2014-11-04 08:11:37.218 GMT ] [CRSNative.searchEntities:658]  found 0 entities
[main] [ 2014-11-04 08:11:37.218 GMT ] [EntityOperations.fetchRunningNodeNames:1161]  Looking for nodes: resource ora.db.db
[main] [ 2014-11-04 08:11:37.242 GMT ] [CRSNative.searchEntities:658]  found 1 entities
[main] [ 2014-11-04 08:11:37.244 GMT ] [EntityOperations.fetchRunningNodeNames:1193]  	riid : ora.db.db 1 1 node: oraclelinux, state ONLINE, istate STABLE
[main] [ 2014-11-04 08:11:37.251 GMT ] [DatabaseImpl.getDBInstances:2411]  Adding running node oraclelinux
[main] [ 2014-11-04 08:11:37.252 GMT ] [DatabaseImpl.getDBInstances:2415]  asList=[oraclelinux]
[main] [ 2014-11-04 08:11:37.252 GMT ] [DatabaseImpl.crsResource:5254]  calling parent's crsResource
[main] [ 2014-11-04 08:11:37.263 GMT ] [EntityOperations.isEntityRegisteredCRSD:353]  entity: ora.db.db, type: 1, registered: true
[main] [ 2014-11-04 08:11:37.286 GMT ] [CRSNative.searchEntities:658]  found 1 entities
[main] [ 2014-11-04 08:11:37.289 GMT ] [DatabaseImpl.getDBInstances:2421]  size of resultData = 1
[main] [ 2014-11-04 08:11:37.290 GMT ] [DatabaseImpl.getDBInstances:2454]  riID=ora.db.db 1 1 result={LAST_SERVER=oraclelinux}
[main] [ 2014-11-04 08:11:37.292 GMT ] [DatabaseImpl.getDBInstances:2481]  not getting any value from GEN
[main] [ 2014-11-04 08:11:37.292 GMT ] [DatabaseImpl.getDBInstances:2485]  both gen and config, instance name = DBN
[main] [ 2014-11-04 08:11:37.293 GMT ] [CRSCache.getAttributesFromCache:229]  CRS cache: ora.db.db [<DATABASE_TYPE:SINGLE>]
[main] [ 2014-11-04 08:11:37.294 GMT ] [CRSCache.getAttributesFromCRS:155]  CRS: name: ora.db.db, type 1, node: null
[main] [ 2014-11-04 08:11:37.295 GMT ] [CRSCache.getAttributesFromCRS:156]  attrs: [HOSTING_MEMBERS]
[main] [ 2014-11-04 08:11:37.304 GMT ] [CRSCache.getAttributesFromCRS:163]  CRS: [<HOSTING_MEMBERS:>]
[main] [ 2014-11-04 08:11:37.304 GMT ] [CRSCache.getAttributesFromCRS:155]  CRS: name: ora.db.db, type 1, node: null
[main] [ 2014-11-04 08:11:37.305 GMT ] [CRSCache.getAttributesFromCRS:156]  attrs: [SERVER_POOLS]
[main] [ 2014-11-04 08:11:37.327 GMT ] [CRSCache.getAttributesFromCRS:163]  CRS: [<SERVER_POOLS:>]
[main] [ 2014-11-04 08:11:37.340 GMT ] [Util.<init>:103]  Util Instance created.
[main] [ 2014-11-04 08:11:37.342 GMT ] [DatabaseImpl.getDBInstances:2543]  instName=DBN nodeName=oraclelinux
[main] [ 2014-11-04 08:11:37.346 GMT ] [CRSCache.getAttributesFromCRS:155]  CRS: name: ora.db.db, type 1, node: null
[main] [ 2014-11-04 08:11:37.347 GMT ] [CRSCache.getAttributesFromCRS:156]  attrs: [SERVER_POOLS_PQ]
[main] [ 2014-11-04 08:11:37.351 GMT ] [CRSCache.getAttributesFromCRS:163]  CRS: [<SERVER_POOLS_PQ:>]
[main] [ 2014-11-04 08:11:37.352 GMT ] [StatusAction.internalExecuteDatabase:491]  number of instances = 1
[main] [ 2014-11-04 08:11:37.353 GMT ] [StatusAction.internalExecuteDatabase:494]  instance name = DBN
[main] [ 2014-11-04 08:11:37.354 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for thisversion
[main] [ 2014-11-04 08:11:37.354 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:37.355 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for thishome
[main] [ 2014-11-04 08:11:37.356 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:37.357 GMT ] [DatabaseImpl.crsResource:5254]  calling parent's crsResource
[main] [ 2014-11-04 08:11:37.371 GMT ] [EntityOperations.isEntityRegisteredCRSD:353]  entity: ora.db.db, type: 1, registered: true
[main] [ 2014-11-04 08:11:37.398 GMT ] [CRSNative.searchEntities:658]  found 1 entities
[main] [ 2014-11-04 08:11:37.399 GMT ] [CRSNative.fetchStatusByNodesName:594]  	node: oraclelinux, status ONLINE, istate STABLE
[main] [ 2014-11-04 08:11:37.401 GMT ] [StatusAction$StatusDescription.<init>:4977]  StatusOnNode: node oraclelinux, value: RUNNING_ON_NODE
[main] [ 2014-11-04 08:11:37.402 GMT ] [Version.isPre:610]  version to be checked 12.1.0.2.0 major version to check against 11
[main] [ 2014-11-04 08:11:37.402 GMT ] [Version.isPre:621]  isPre.java: Returning FALSE
[main] [ 2014-11-04 08:11:37.403 GMT ] [Version.isPre:691]  version to be checked 12.1.0.2.0 major version to check against 11 minor version to check against 2 patchset version to check against 2
[main] [ 2014-11-04 08:11:37.404 GMT ] [Version.isPre:701]  isPre: Returning FALSE for major version check
[main] [ 2014-11-04 08:11:37.405 GMT ] [CRSCache.getAttributesFromCRS:155]  CRS: name: ora.db.db, type 1, node: null
[main] [ 2014-11-04 08:11:37.405 GMT ] [CRSCache.getAttributesFromCRS:156]  attrs: all
[main] [ 2014-11-04 08:11:37.424 GMT ] [CRSCache.getAttributesFromCRS:163]  CRS: [<STATE:ONLINE>, <TARGET:ONLINE>, <ACL:owner:oracle:rwx,pgrp:asmdba:r-x,other::r--,group:oinstall:r-x,user:oracle:rwx>, <ACTIONS:startoption,group:"asmdba",user:"oracle",group:"oinstall">, <ACTION_FAILURE_TEMPLATE:>, <ACTION_SCRIPT:>, <ACTION_START_OPTION:>, <ACTION_TIMEOUT:600>, <ACTIVE_PLACEMENT:0>, <AGENT_FILENAME:%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%>, <ALERT_TEMPLATE:>, <ALIAS_NAME:>, <AUTO_START:never>, <CARDINALITY:1>, <CARDINALITY_ID:0>, <CHECK_INTERVAL:1>, <CHECK_TIMEOUT:30>, <CLEAN_TIMEOUT:60>, <CLUSTER_DATABASE:false>, <CONFIG_VERSION:1>, <CREATION_SEED:37>, <DATABASE_TYPE:SINGLE>, <DB_UNIQUE_NAME:DB>, <DEFAULT_TEMPLATE:PROPERTY(RESOURCE_CLASS=database) PROPERTY(DB_UNIQUE_NAME= CONCAT(PARSE(%NAME%, ., 2), %USR_ORA_DOMAIN%, .)) ELEMENT(INSTANCE_NAME= %GEN_USR_ORA_INST_NAME%) ELEMENT(DATABASE_TYPE= %DATABASE_TYPE%)>, <DEGREE:1>, <DEGREE_ID:0>, <DELETE_TIMEOUT:60>, <DESCRIPTION:Oracle Database resource>, <ENABLED:1>, <FAILOVER_DELAY:0>, <FAILURE_INTERVAL:60>, <FAILURE_THRESHOLD:1>, <GEN_AUDIT_FILE_DEST:/u01/app/oracle/admin/DB/adump>, <GEN_START_OPTIONS:>, <GEN_USR_ORA_INST_NAME:DBN>, <HOSTING_MEMBERS:>, <ID:ora.db.db>, <INSTANCE_COUNT:1>, <INSTANCE_FAILOVER:1>, <INTERMEDIATE_TIMEOUT:0>, <LOAD:1>, <LOGGING_LEVEL:1>, <MANAGEMENT_POLICY:MANUAL>, <MODIFY_TIMEOUT:60>, <NAME:ora.db.db>, <NLS_LANG:>, <NOT_RESTARTING_TEMPLATE:>, <OFFLINE_CHECK_INTERVAL:0>, <ONLINE_RELOCATION_TIMEOUT:0>, <ORACLE_HOME:/u01/app/oracle/product/12.1.0.2/dbhome_1>, <ORACLE_HOME_OLD:>, <OS_CRASH_THRESHOLD:0>, <OS_CRASH_UPTIME:0>, <PLACEMENT:balanced>, <PROFILE_CHANGE_TEMPLATE:>, <PWFILE:/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/initDBN.ora>, <RANK:0>, <RELOCATE_ACTION:0>, <RELOCATE_BY_DEPENDENCY:1>, <RESTART_ATTEMPTS:1>, <ROLE:PRIMARY>, <SCRIPT_TIMEOUT:60>, <SERVER_CATEGORY:>, <SERVER_POOLS:>, <SERVER_POOLS_PQ:>, <SPFILE:>, <START_CONCURRENCY:0>, <START_DEPENDENCIES:hard(ora.DATA.dg,ora.RECO.dg) weak(type:ora.listener.type,uniform:ora.ons)>, <START_TIMEOUT:600>, <STATE_CHANGE_TEMPLATE:>, <STOP_CONCURRENCY:0>, <STOP_DEPENDENCIES:hard(intermediate:ora.asm,shutdown:ora.DATA.dg,shutdown:ora.RECO.dg)>, <STOP_TIMEOUT:600>, <TYPE:ora.database.type>, <TYPE_VERSION:3.3>, <UPTIME_THRESHOLD:1h>, <USER_WORKLOAD:yes>, <USE_STICKINESS:0>, <USR_ORA_DB_NAME:>, <USR_ORA_DOMAIN:>, <USR_ORA_ENV:>, <USR_ORA_FLAGS:>, <USR_ORA_INST_NAME:DBN>, <USR_ORA_OPEN_MODE:open>, <USR_ORA_OPI:false>, <USR_ORA_STOP_MODE:immediate>, <VERSION:12.1.0.2.0>]
[main] [ 2014-11-04 08:11:37.425 GMT ] [DatabaseImpl.getDBInstances:2356]  name=STATE, value=ONLINE
[main] [ 2014-11-04 08:11:37.426 GMT ] [DatabaseImpl.getDBInstances:2356]  name=TARGET, value=ONLINE
[main] [ 2014-11-04 08:11:37.427 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ACL, value=owner:oracle:rwx,pgrp:asmdba:r-x,other::r--,group:oinstall:r-x,user:oracle:rwx
[main] [ 2014-11-04 08:11:37.427 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ACTIONS, value=startoption,group:"asmdba",user:"oracle",group:"oinstall"
[main] [ 2014-11-04 08:11:37.428 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ACTION_FAILURE_TEMPLATE, value=
[main] [ 2014-11-04 08:11:37.428 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ACTION_SCRIPT, value=
[main] [ 2014-11-04 08:11:37.429 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ACTION_START_OPTION, value=
[main] [ 2014-11-04 08:11:37.429 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ACTION_TIMEOUT, value=600
[main] [ 2014-11-04 08:11:37.430 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ACTIVE_PLACEMENT, value=0
[main] [ 2014-11-04 08:11:37.431 GMT ] [DatabaseImpl.getDBInstances:2356]  name=AGENT_FILENAME, value=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
[main] [ 2014-11-04 08:11:37.432 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ALERT_TEMPLATE, value=
[main] [ 2014-11-04 08:11:37.432 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ALIAS_NAME, value=
[main] [ 2014-11-04 08:11:37.433 GMT ] [DatabaseImpl.getDBInstances:2356]  name=AUTO_START, value=never
[main] [ 2014-11-04 08:11:37.434 GMT ] [DatabaseImpl.getDBInstances:2356]  name=CARDINALITY, value=1
[main] [ 2014-11-04 08:11:37.435 GMT ] [DatabaseImpl.getDBInstances:2356]  name=CARDINALITY_ID, value=0
[main] [ 2014-11-04 08:11:37.435 GMT ] [DatabaseImpl.getDBInstances:2356]  name=CHECK_INTERVAL, value=1
[main] [ 2014-11-04 08:11:37.436 GMT ] [DatabaseImpl.getDBInstances:2356]  name=CHECK_TIMEOUT, value=30
[main] [ 2014-11-04 08:11:37.436 GMT ] [DatabaseImpl.getDBInstances:2356]  name=CLEAN_TIMEOUT, value=60
[main] [ 2014-11-04 08:11:37.437 GMT ] [DatabaseImpl.getDBInstances:2356]  name=CLUSTER_DATABASE, value=false
[main] [ 2014-11-04 08:11:37.438 GMT ] [DatabaseImpl.getDBInstances:2356]  name=CONFIG_VERSION, value=1
[main] [ 2014-11-04 08:11:37.439 GMT ] [DatabaseImpl.getDBInstances:2356]  name=CREATION_SEED, value=37
[main] [ 2014-11-04 08:11:37.439 GMT ] [DatabaseImpl.getDBInstances:2356]  name=DATABASE_TYPE, value=SINGLE
[main] [ 2014-11-04 08:11:37.440 GMT ] [DatabaseImpl.getDBInstances:2356]  name=DB_UNIQUE_NAME, value=DB
[main] [ 2014-11-04 08:11:37.441 GMT ] [DatabaseImpl.getDBInstances:2356]  name=DEFAULT_TEMPLATE, value=PROPERTY(RESOURCE_CLASS=database) PROPERTY(DB_UNIQUE_NAME= CONCAT(PARSE(%NAME%, ., 2), %USR_ORA_DOMAIN%, .)) ELEMENT(INSTANCE_NAME= %GEN_USR_ORA_INST_NAME%) ELEMENT(DATABASE_TYPE= %DATABASE_TYPE%)
[main] [ 2014-11-04 08:11:37.442 GMT ] [DatabaseImpl.getDBInstances:2356]  name=DEGREE, value=1
[main] [ 2014-11-04 08:11:37.444 GMT ] [DatabaseImpl.getDBInstances:2356]  name=DEGREE_ID, value=0
[main] [ 2014-11-04 08:11:37.444 GMT ] [DatabaseImpl.getDBInstances:2356]  name=DELETE_TIMEOUT, value=60
[main] [ 2014-11-04 08:11:37.445 GMT ] [DatabaseImpl.getDBInstances:2356]  name=DESCRIPTION, value=Oracle Database resource
[main] [ 2014-11-04 08:11:37.446 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ENABLED, value=1
[main] [ 2014-11-04 08:11:37.447 GMT ] [DatabaseImpl.getDBInstances:2356]  name=FAILOVER_DELAY, value=0
[main] [ 2014-11-04 08:11:37.447 GMT ] [DatabaseImpl.getDBInstances:2356]  name=FAILURE_INTERVAL, value=60
[main] [ 2014-11-04 08:11:37.448 GMT ] [DatabaseImpl.getDBInstances:2356]  name=FAILURE_THRESHOLD, value=1
[main] [ 2014-11-04 08:11:37.449 GMT ] [DatabaseImpl.getDBInstances:2356]  name=GEN_AUDIT_FILE_DEST, value=/u01/app/oracle/admin/DB/adump
[main] [ 2014-11-04 08:11:37.450 GMT ] [DatabaseImpl.getDBInstances:2356]  name=GEN_START_OPTIONS, value=
[main] [ 2014-11-04 08:11:37.450 GMT ] [DatabaseImpl.getDBInstances:2356]  name=GEN_USR_ORA_INST_NAME, value=DBN
[main] [ 2014-11-04 08:11:37.451 GMT ] [DatabaseImpl.getDBInstances:2356]  name=HOSTING_MEMBERS, value=
[main] [ 2014-11-04 08:11:37.452 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ID, value=ora.db.db
[main] [ 2014-11-04 08:11:37.452 GMT ] [DatabaseImpl.getDBInstances:2356]  name=INSTANCE_COUNT, value=1
[main] [ 2014-11-04 08:11:37.453 GMT ] [DatabaseImpl.getDBInstances:2356]  name=INSTANCE_FAILOVER, value=1
[main] [ 2014-11-04 08:11:37.454 GMT ] [DatabaseImpl.getDBInstances:2356]  name=INTERMEDIATE_TIMEOUT, value=0
[main] [ 2014-11-04 08:11:37.455 GMT ] [DatabaseImpl.getDBInstances:2356]  name=LOAD, value=1
[main] [ 2014-11-04 08:11:37.455 GMT ] [DatabaseImpl.getDBInstances:2356]  name=LOGGING_LEVEL, value=1
[main] [ 2014-11-04 08:11:37.456 GMT ] [DatabaseImpl.getDBInstances:2356]  name=MANAGEMENT_POLICY, value=MANUAL
[main] [ 2014-11-04 08:11:37.456 GMT ] [DatabaseImpl.getDBInstances:2356]  name=MODIFY_TIMEOUT, value=60
[main] [ 2014-11-04 08:11:37.457 GMT ] [DatabaseImpl.getDBInstances:2356]  name=NAME, value=ora.db.db
[main] [ 2014-11-04 08:11:37.458 GMT ] [DatabaseImpl.getDBInstances:2356]  name=NLS_LANG, value=
[main] [ 2014-11-04 08:11:37.458 GMT ] [DatabaseImpl.getDBInstances:2356]  name=NOT_RESTARTING_TEMPLATE, value=
[main] [ 2014-11-04 08:11:37.459 GMT ] [DatabaseImpl.getDBInstances:2356]  name=OFFLINE_CHECK_INTERVAL, value=0
[main] [ 2014-11-04 08:11:37.459 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ONLINE_RELOCATION_TIMEOUT, value=0
[main] [ 2014-11-04 08:11:37.460 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ORACLE_HOME, value=/u01/app/oracle/product/12.1.0.2/dbhome_1
[main] [ 2014-11-04 08:11:37.461 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ORACLE_HOME_OLD, value=
[main] [ 2014-11-04 08:11:37.462 GMT ] [DatabaseImpl.getDBInstances:2356]  name=OS_CRASH_THRESHOLD, value=0
[main] [ 2014-11-04 08:11:37.462 GMT ] [DatabaseImpl.getDBInstances:2356]  name=OS_CRASH_UPTIME, value=0
[main] [ 2014-11-04 08:11:37.463 GMT ] [DatabaseImpl.getDBInstances:2356]  name=PLACEMENT, value=balanced
[main] [ 2014-11-04 08:11:37.463 GMT ] [DatabaseImpl.getDBInstances:2356]  name=PROFILE_CHANGE_TEMPLATE, value=
[main] [ 2014-11-04 08:11:37.464 GMT ] [DatabaseImpl.getDBInstances:2356]  name=PWFILE, value=/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/initDBN.ora
[main] [ 2014-11-04 08:11:37.465 GMT ] [DatabaseImpl.getDBInstances:2356]  name=RANK, value=0
[main] [ 2014-11-04 08:11:37.466 GMT ] [DatabaseImpl.getDBInstances:2356]  name=RELOCATE_ACTION, value=0
[main] [ 2014-11-04 08:11:37.466 GMT ] [DatabaseImpl.getDBInstances:2356]  name=RELOCATE_BY_DEPENDENCY, value=1
[main] [ 2014-11-04 08:11:37.467 GMT ] [DatabaseImpl.getDBInstances:2356]  name=RESTART_ATTEMPTS, value=1
[main] [ 2014-11-04 08:11:37.468 GMT ] [DatabaseImpl.getDBInstances:2356]  name=ROLE, value=PRIMARY
[main] [ 2014-11-04 08:11:37.469 GMT ] [DatabaseImpl.getDBInstances:2356]  name=SCRIPT_TIMEOUT, value=60
[main] [ 2014-11-04 08:11:37.469 GMT ] [DatabaseImpl.getDBInstances:2356]  name=SERVER_CATEGORY, value=
[main] [ 2014-11-04 08:11:37.470 GMT ] [DatabaseImpl.getDBInstances:2356]  name=SERVER_POOLS, value=
[main] [ 2014-11-04 08:11:37.471 GMT ] [DatabaseImpl.getDBInstances:2356]  name=SERVER_POOLS_PQ, value=
[main] [ 2014-11-04 08:11:37.472 GMT ] [DatabaseImpl.getDBInstances:2356]  name=SPFILE, value=
[main] [ 2014-11-04 08:11:37.473 GMT ] [DatabaseImpl.getDBInstances:2356]  name=START_CONCURRENCY, value=0
[main] [ 2014-11-04 08:11:37.474 GMT ] [DatabaseImpl.getDBInstances:2356]  name=START_DEPENDENCIES, value=hard(ora.DATA.dg,ora.RECO.dg) weak(type:ora.listener.type,uniform:ora.ons)
[main] [ 2014-11-04 08:11:37.475 GMT ] [DatabaseImpl.getDBInstances:2356]  name=START_TIMEOUT, value=600
[main] [ 2014-11-04 08:11:37.476 GMT ] [DatabaseImpl.getDBInstances:2356]  name=STATE_CHANGE_TEMPLATE, value=
[main] [ 2014-11-04 08:11:37.477 GMT ] [DatabaseImpl.getDBInstances:2356]  name=STOP_CONCURRENCY, value=0
[main] [ 2014-11-04 08:11:37.478 GMT ] [DatabaseImpl.getDBInstances:2356]  name=STOP_DEPENDENCIES, value=hard(intermediate:ora.asm,shutdown:ora.DATA.dg,shutdown:ora.RECO.dg)
[main] [ 2014-11-04 08:11:37.478 GMT ] [DatabaseImpl.getDBInstances:2356]  name=STOP_TIMEOUT, value=600
[main] [ 2014-11-04 08:11:37.480 GMT ] [DatabaseImpl.getDBInstances:2356]  name=TYPE, value=ora.database.type
[main] [ 2014-11-04 08:11:37.480 GMT ] [DatabaseImpl.getDBInstances:2356]  name=TYPE_VERSION, value=3.3
[main] [ 2014-11-04 08:11:37.481 GMT ] [DatabaseImpl.getDBInstances:2356]  name=UPTIME_THRESHOLD, value=1h
[main] [ 2014-11-04 08:11:37.481 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USER_WORKLOAD, value=yes
[main] [ 2014-11-04 08:11:37.483 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USE_STICKINESS, value=0
[main] [ 2014-11-04 08:11:37.483 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USR_ORA_DB_NAME, value=
[main] [ 2014-11-04 08:11:37.484 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USR_ORA_DOMAIN, value=
[main] [ 2014-11-04 08:11:37.485 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USR_ORA_ENV, value=
[main] [ 2014-11-04 08:11:37.486 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USR_ORA_FLAGS, value=
[main] [ 2014-11-04 08:11:37.487 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USR_ORA_INST_NAME, value=DBN
[main] [ 2014-11-04 08:11:37.487 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USR_ORA_OPEN_MODE, value=open
[main] [ 2014-11-04 08:11:37.488 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USR_ORA_OPI, value=false
[main] [ 2014-11-04 08:11:37.488 GMT ] [DatabaseImpl.getDBInstances:2356]  name=USR_ORA_STOP_MODE, value=immediate
[main] [ 2014-11-04 08:11:37.489 GMT ] [DatabaseImpl.getDBInstances:2356]  name=VERSION, value=12.1.0.2.0
[main] [ 2014-11-04 08:11:37.490 GMT ] [CRSCache.getAttributesFromCache:229]  CRS cache: ora.db.db [<DATABASE_TYPE:SINGLE>]
[main] [ 2014-11-04 08:11:37.494 GMT ] [CRSCache.getAttributesFromCRS:155]  CRS: name: ora.db.db, type 1, node: null
[main] [ 2014-11-04 08:11:37.495 GMT ] [CRSCache.getAttributesFromCRS:156]  attrs: [HOSTING_MEMBERS]
[main] [ 2014-11-04 08:11:37.498 GMT ] [CRSCache.getAttributesFromCRS:163]  CRS: [<HOSTING_MEMBERS:>]
[main] [ 2014-11-04 08:11:37.499 GMT ] [CRSCache.getAttributesFromCRS:155]  CRS: name: ora.db.db, type 1, node: null
[main] [ 2014-11-04 08:11:37.500 GMT ] [CRSCache.getAttributesFromCRS:156]  attrs: [SERVER_POOLS]
[main] [ 2014-11-04 08:11:37.524 GMT ] [CRSCache.getAttributesFromCRS:163]  CRS: [<SERVER_POOLS:>]
[main] [ 2014-11-04 08:11:37.527 GMT ] [DatabaseImpl.crsResource:5254]  calling parent's crsResource
[main] [ 2014-11-04 08:11:37.539 GMT ] [EntityOperations.isEntityRegisteredCRSD:353]  entity: ora.db.db, type: 1, registered: true
[main] [ 2014-11-04 08:11:37.562 GMT ] [CRSNative.searchEntities:658]  found 1 entities
[main] [ 2014-11-04 08:11:37.562 GMT ] [DatabaseImpl.getDBInstances:2421]  size of resultData = 1
[main] [ 2014-11-04 08:11:37.564 GMT ] [DatabaseImpl.getDBInstances:2454]  riID=ora.db.db 1 1 result={LAST_SERVER=oraclelinux}
[main] [ 2014-11-04 08:11:37.565 GMT ] [CRSCache.getAttributesFromCache:229]  CRS cache: ora.db.db [<DATABASE_TYPE:SINGLE>]
[main] [ 2014-11-04 08:11:37.566 GMT ] [CRSCache.getAttributesFromCRS:155]  CRS: name: ora.db.db, type 1, node: null
[main] [ 2014-11-04 08:11:37.572 GMT ] [CRSCache.getAttributesFromCRS:156]  attrs: [HOSTING_MEMBERS]
[main] [ 2014-11-04 08:11:37.582 GMT ] [CRSCache.getAttributesFromCRS:163]  CRS: [<HOSTING_MEMBERS:>]
[main] [ 2014-11-04 08:11:37.583 GMT ] [CRSCache.getAttributesFromCRS:155]  CRS: name: ora.db.db, type 1, node: null
[main] [ 2014-11-04 08:11:37.584 GMT ] [CRSCache.getAttributesFromCRS:156]  attrs: [SERVER_POOLS]
[main] [ 2014-11-04 08:11:37.604 GMT ] [CRSCache.getAttributesFromCRS:163]  CRS: [<SERVER_POOLS:>]
[main] [ 2014-11-04 08:11:37.606 GMT ] [Util.<init>:103]  Util Instance created.
[main] [ 2014-11-04 08:11:37.608 GMT ] [DatabaseImpl.getDBInstances:2543]  instName=DBN nodeName=oraclelinux
[main] [ 2014-11-04 08:11:37.611 GMT ] [CRSCache.getAttributesFromCRS:155]  CRS: name: ora.db.db, type 1, node: null
[main] [ 2014-11-04 08:11:37.614 GMT ] [CRSCache.getAttributesFromCRS:156]  attrs: [SERVER_POOLS_PQ]
[main] [ 2014-11-04 08:11:37.625 GMT ] [CRSCache.getAttributesFromCRS:163]  CRS: [<SERVER_POOLS_PQ:>]
[main] [ 2014-11-04 08:11:37.626 GMT ] [Util.<init>:103]  Util Instance created.
[main] [ 2014-11-04 08:11:37.627 GMT ] [CmdOptVals.isOptionSet:917]  Check isOptionSet for VERBOSE
[main] [ 2014-11-04 08:11:37.629 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for verbose
[main] [ 2014-11-04 08:11:37.629 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:37.631 GMT ] [CmdOptVals.isOptionSet:917]  Check isOptionSet for INNER
[main] [ 2014-11-04 08:11:37.632 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for inner
[main] [ 2014-11-04 08:11:37.634 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:37.637 GMT ] [CRSCache.getAttributesFromCache:229]  CRS cache: ora.db.db [<DATABASE_TYPE:SINGLE>]
[main] [ 2014-11-04 08:11:37.638 GMT ] [CmdOptVals.isOptionSet:917]  Check isOptionSet for FORCE
[main] [ 2014-11-04 08:11:37.639 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for force
[main] [ 2014-11-04 08:11:37.639 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:37.641 GMT ] [CRSNative.getResourceInstancesID:1070]  Looking for RIs using filter: ((NAME == ora.db.db) AND ((STATE == ONLINE) OR (STATE == INTERMEDIATE)))
[main] [ 2014-11-04 08:11:37.645 GMT ] [CRSNative.getResourceInstancesID:1078]  found 1 RIs
[main] [ 2014-11-04 08:11:37.646 GMT ] [CRSNative.getResourceInstancesID:1080]  	ora.db.db 1 1
[main] [ 2014-11-04 08:11:37.647 GMT ] [CmdOptVals.isOptionSet:917]  Check isOptionSet for VERBOSE
[main] [ 2014-11-04 08:11:37.648 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for verbose
[main] [ 2014-11-04 08:11:37.648 GMT ] [OptVal.isSet:150]  m_value is null
Database is running.
[main] [ 2014-11-04 08:11:37.682 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for thisversion
[main] [ 2014-11-04 08:11:37.683 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:37.683 GMT ] [CmdOptVals.isOptionSet:861]  Calling isOptionSet for thishome
[main] [ 2014-11-04 08:11:37.684 GMT ] [OptVal.isSet:150]  m_value is null
[main] [ 2014-11-04 08:11:37.684 GMT ] [InterruptHandler.unRegisterInterruptHandler:76]  UNRegistering shutdown hook.....
[main] [ 2014-11-04 08:11:37.685 GMT ] [InterruptHandler.unRegisterInterruptHandler:81]  UnRegistered shutdown hook.....
[main] [ 2014-11-04 08:11:37.686 GMT ] [OPSCTLDriver.main:233]  Unregistered OPSCTL driver's interrupt handler
[main] [ 2014-11-04 08:11:37.687 GMT ] [SRVMContext.term:151]  Performing SRVM Context Term. Term counter is 2
[oracle@oraclelinux ~]$

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: