FAQ
Hi,

after a failed switchover in an environment combining a physical standby
setup on 11.1.0.7 with a fresh 11.2.0.2 Oracle Restart install, I want
to explore any dangers / problems / surprises inherent in this combination.

First, I'd have a general question - is there any way I can "persuade"
Grid Infrastructure, having added a running database using srvctl add
database, that this database really IS running and should be, too
(target = online)? From crsctl status resource -t I get

NAME TARGET STATE SERVER STATE_DETAILS
ora.dgtest1.db OFFLINE OFFLINE


, and I don't like waiting for the next database bounce to have it
monitored by Grid Infrastructure :-;
(Same thing for the other resources like listeners, - Restart does not
seem to notice they are running...)
-
My next problem is, I added a service using srvctl and wanted to start it

srvctl start service -s primonly -d dgtest1

, just as described in Uwe Hesse's blog article "Data Guard & Oracle
Restart in 11gR2"
(http://uhesse.wordpress.com/2010/09/06/data-guard-oracle-restart-in-11gr2/),
and it turns out I get this error on the command line

PRCD-1084 : Failed to start service primonly
PRCR-1079 : Failed to start resource ora.dgtest1.primonly.svc
CRS-5017: The resource action "ora.dgtest1.primonly.svc start"
encountered the following error:
ORA-02095: specified initialization parameter cannot be modified


CRS-2674: Start of 'ora.dgtest1.primonly.svc' on 'ix-vip-db' failed
CRS-5017: The resource action "ora.dgtest1.primonly.svc clean"
encountered the following error:
ORA-44304: service primonly does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SERVICE", line 442
ORA-06512: at "SYS.DBMS_SERVICE", line 390
ORA-06512: at line 1


and my instance is shutdown and stays so, too:

NAME TARGET STATE SERVER STATE_DETAILS
ora.dgtest1.db ONLINE OFFLINE Instance
Shutdown

Now I wonder which parameter was not modifiable here (service_names
should be modifiable, shouldn't it?), and I'm a bit shocked imagining
this had happened on a real, productive database and not in test - I'd
have killed the primary trying to start that service....

I'd very much appreciate your advice / experiences regarding the usage
of 11gR1 databases with Grid Infrastructure, and especially regarding
service creation / administration.

Many thanks in advance!
Sigrid

P.S. Regarding the "parameter not modifiable" error, I found the
following in $GRID_HOME/log/ix-vip-db/agent/ohasd/oraagent_oracle:


2011-09-21 17:03:58.847: [ USRTHRD][1114904896] makeConnectStr =
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/oracle/product/11.1.0/db_1/bin/oracle)(ARGV0=oracledgtest)(E
NVS='ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1,ORACLE_SID=dgtest')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=dgtest)))
2011-09-21 17:03:58.848: [ USRTHRD][1114904896]
InstConnection::connectInt: server not attached
2011-09-21 17:03:58.888: [ USRTHRD][1114904896] ORA-02095: specified
initialization parameter cannot be modified

2011-09-21 17:03:58.888: [ USRTHRD][1114904896]
InstConnection:connectInt (3) OCIException OCI error 2095
2011-09-21 17:03:58.889: [ USRTHRD][1114904896]
InstConnection:connect:excp OCIException OCI error 2095
2011-09-21 17:03:58.889: [ USRTHRD][1114904896] RLB.dgtest1
RlbEventPoller::poll Exception OCIException during initial connection:
ORA-02095: specified initialization parameter ca

Search Discussions

  • D'Hooge Freek at Sep 21, 2011 at 4:51 pm
    Sigrid,

    Only 11.2 databases can be managed with Oracle restart.
    How did you succeed in registering the database with oracle restart?


    Regards,


    Freek D'Hooge
    Uptime
    Oracle Database Administrator
    email: freek.dhooge@uptime.be
    tel +32(0)3 451 23 82
    http://www.uptime.be
    disclaimer: www.uptime.be/disclaimer

    -----Original Message-----
    From: oracle-l-bounce@freelists.org On Behalf Of Sigrid Keydana
    Sent: woensdag 21 september 2011 18:01
    To: oracle-l@freelists.org
    Subject: uncanny experiences combining Oracle Restart 11.2.0.2 and Data Guard 11.1.0.7

    Hi,

    after a failed switchover in an environment combining a physical standby
    setup on 11.1.0.7 with a fresh 11.2.0.2 Oracle Restart install, I want
    to explore any dangers / problems / surprises inherent in this combination.

    First, I'd have a general question - is there any way I can "persuade"
    Grid Infrastructure, having added a running database using srvctl add
    database, that this database really IS running and should be, too
    (target = online)? From crsctl status resource -t I get

    NAME TARGET STATE SERVER STATE_DETAILS
    ora.dgtest1.db OFFLINE OFFLINE


    , and I don't like waiting for the next database bounce to have it
    monitored by Grid Infrastructure :-;
    (Same thing for the other resources like listeners, - Restart does not
    seem to notice they are running...)
    -
    My next problem is, I added a service using srvctl and wanted to start it

    srvctl start service -s primonly -d dgtest1

    , just as described in Uwe Hesse's blog article "Data Guard & Oracle
    Restart in 11gR2"
    (http://uhesse.wordpress.com/2010/09/06/data-guard-oracle-restart-in-11gr2/),
    and it turns out I get this error on the command line

    PRCD-1084 : Failed to start service primonly
    PRCR-1079 : Failed to start resource ora.dgtest1.primonly.svc
    CRS-5017: The resource action "ora.dgtest1.primonly.svc start"
    encountered the following error:
    ORA-02095: specified initialization parameter cannot be modified


    CRS-2674: Start of 'ora.dgtest1.primonly.svc' on 'ix-vip-db' failed
    CRS-5017: The resource action "ora.dgtest1.primonly.svc clean"
    encountered the following error:
    ORA-44304: service primonly does not exist
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
    ORA-06512: at "SYS.DBMS_SERVICE", line 442
    ORA-06512: at "SYS.DBMS_SERVICE", line 390
    ORA-06512: at line 1


    and my instance is shutdown and stays so, too:

    NAME TARGET STATE SERVER STATE_DETAILS
    ora.dgtest1.db ONLINE OFFLINE Instance
    Shutdown

    Now I wonder which parameter was not modifiable here (service_names
    should be modifiable, shouldn't it?), and I'm a bit shocked imagining
    this had happened on a real, productive database and not in test - I'd
    have killed the primary trying to start that service....

    I'd very much appreciate your advice / experiences regarding the usage
    of 11gR1 databases with Grid Infrastructure, and especially regarding
    service creation / administration.

    Many thanks in advance!
    Sigrid

    P.S. Regarding the "parameter not modifiable" error, I found the
    following in $GRID_HOME/log/ix-vip-db/agent/ohasd/oraagent_oracle:


    2011-09-21 17:03:58.847: [ USRTHRD][1114904896] makeConnectStr =
    (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/oracle/product/11.1.0/db_1/bin/oracle)(ARGV0=oracledgtest)(E
    NVS='ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1,ORACLE_SID=dgtest')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=dgtest)))
    2011-09-21 17:03:58.848: [ USRTHRD][1114904896]
    InstConnection::connectInt: server not attached
    2011-09-21 17:03:58.888: [ USRTHRD][1114904896] ORA-02095: specified
    initialization parameter cannot be modified

    2011-09-21 17:03:58.888: [ USRTHRD][1114904896]
    InstConnection:connectInt (3) OCIException OCI error 2095
    2011-09-21 17:03:58.889: [ USRTHRD][1114904896]
    InstConnection:connect:excp OCIException OCI error 2095
    2011-09-21 17:03:58.889: [ USRTHRD][1114904896] RLB.dgtest1
    RlbEventPoller::poll Exception OCIException during initial connection:
    ORA-02095: specified initialization parameter ca



    --
    http://www.freelists.org/webpage/oracle-l


    --
    http://www.freelists.org/webpage/oracle-l
  • Sigrid Keydana at Sep 21, 2011 at 8:42 pm
    Hi Freek,

    I admit was using the srvctl from the Grid Home, which I thought was how
    you do it in the case of 11.1 (frankly I cannot recall right now why I
    was assuming this, just seeing that being done by others I guess...)
    So now from your reply, I start to think I got something very wrong
    here, kind of embarrassing :-;

    Still, my first question would apply, in the case of the listener -
    which IS running from the Grid Home - ... so given that I specify the
    port in the srvctl add command, shouldn't Grid Infrastructure notice the
    listener is already active on that port (it notices something's running
    for sure, because without -f I couldn't even add the listener...) and
    set its state and target to online?

    Many thanks,
    Sigrid


    On 09/21/2011 06:46 PM, D'Hooge Freek wrote:
    Sigrid,

    Only 11.2 databases can be managed with Oracle restart.
    How did you succeed in registering the database with oracle restart?


    Regards,


    Freek D'Hooge
    Uptime
    Oracle Database Administrator
    email: freek.dhooge@uptime.be
    tel +32(0)3 451 23 82
    http://www.uptime.be
    disclaimer: www.uptime.be/disclaimer

    -----Original Message-----
    From: oracle-l-bounce@freelists.org On Behalf Of Sigrid Keydana
    Sent: woensdag 21 september 2011 18:01
    To: oracle-l@freelists.org
    Subject: uncanny experiences combining Oracle Restart 11.2.0.2 and Data Guard 11.1.0.7

    Hi,

    after a failed switchover in an environment combining a physical standby
    setup on 11.1.0.7 with a fresh 11.2.0.2 Oracle Restart install, I want
    to explore any dangers / problems / surprises inherent in this combination.

    First, I'd have a general question - is there any way I can "persuade"
    Grid Infrastructure, having added a running database using srvctl add
    database, that this database really IS running and should be, too
    (target = online)? From crsctl status resource -t I get

    NAME TARGET STATE SERVER STATE_DETAILS
    ora.dgtest1.db OFFLINE OFFLINE


    , and I don't like waiting for the next database bounce to have it
    monitored by Grid Infrastructure :-;
    (Same thing for the other resources like listeners, - Restart does not
    seem to notice they are running...)
    -
    My next problem is, I added a service using srvctl and wanted to start it

    srvctl start service -s primonly -d dgtest1

    , just as described in Uwe Hesse's blog article "Data Guard& Oracle
    Restart in 11gR2"
    (http://uhesse.wordpress.com/2010/09/06/data-guard-oracle-restart-in-11gr2/),
    and it turns out I get this error on the command line

    PRCD-1084 : Failed to start service primonly
    PRCR-1079 : Failed to start resource ora.dgtest1.primonly.svc
    CRS-5017: The resource action "ora.dgtest1.primonly.svc start"
    encountered the following error:
    ORA-02095: specified initialization parameter cannot be modified


    CRS-2674: Start of 'ora.dgtest1.primonly.svc' on 'ix-vip-db' failed
    CRS-5017: The resource action "ora.dgtest1.primonly.svc clean"
    encountered the following error:
    ORA-44304: service primonly does not exist
    ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
    ORA-06512: at "SYS.DBMS_SERVICE", line 442
    ORA-06512: at "SYS.DBMS_SERVICE", line 390
    ORA-06512: at line 1


    and my instance is shutdown and stays so, too:

    NAME TARGET STATE SERVER STATE_DETAILS
    ora.dgtest1.db ONLINE OFFLINE Instance
    Shutdown

    Now I wonder which parameter was not modifiable here (service_names
    should be modifiable, shouldn't it?), and I'm a bit shocked imagining
    this had happened on a real, productive database and not in test - I'd
    have killed the primary trying to start that service....

    I'd very much appreciate your advice / experiences regarding the usage
    of 11gR1 databases with Grid Infrastructure, and especially regarding
    service creation / administration.

    Many thanks in advance!
    Sigrid

    P.S. Regarding the "parameter not modifiable" error, I found the
    following in $GRID_HOME/log/ix-vip-db/agent/ohasd/oraagent_oracle:


    2011-09-21 17:03:58.847: [ USRTHRD][1114904896] makeConnectStr =
    (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/oracle/product/11.1.0/db_1/bin/oracle)(ARGV0=oracledgtest)(E
    NVS='ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1,ORACLE_SID=dgtest')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=dgtest)))
    2011-09-21 17:03:58.848: [ USRTHRD][1114904896]
    InstConnection::connectInt: server not attached
    2011-09-21 17:03:58.888: [ USRTHRD][1114904896] ORA-02095: specified
    initialization parameter cannot be modified

    2011-09-21 17:03:58.888: [ USRTHRD][1114904896]
    InstConnection:connectInt (3) OCIException OCI error 2095
    2011-09-21 17:03:58.889: [ USRTHRD][1114904896]
    InstConnection:connect:excp OCIException OCI error 2095
    2011-09-21 17:03:58.889: [ USRTHRD][1114904896] RLB.dgtest1
    RlbEventPoller::poll Exception OCIException during initial connection:
    ORA-02095: specified initialization parameter ca



    --
    http://www.freelists.org/webpage/oracle-l

    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 21, '11 at 3:59p
activeSep 21, '11 at 8:42p
posts3
users2
websiteoracle.com

2 users in discussion

Sigrid Keydana: 2 posts D'Hooge Freek: 1 post

People

Translate

site design / logo © 2022 Grokbase