Big news! The community will be moving to a new platform April 21. Read more.
Big news! The community will be moving to a new platform April 21. Read more.
Absent Member.
Absent Member.
1555 views

Configure DBSPI for Oracle Data Guard fails

Hi,

The dbspicfg.sh for the standby database fails (actually the connection check) with:

DBSPI10-23: Unable to connect to database 'ITIMACC' [ORA-00604: error occurred at recursive SQL level 1
ORA-01219: database not open: queries allowed on fixed tables/views only].

The 'dbspicao -d -f -v' gives the same result of course (dbspicao for Sun Solaris 11.42.002).

Have tried a number of ways to specifiy the connection but the 'as sysdba' always seems to be ignored/lost.

SYNTAX_VERSION 4
ORACLE
HOME "/opt/oracle/10.2.0"
DATABASE "ITIMACC" CONNECT "sys/password as sysdba"

Any idea someone what can be wrong?

/Peter
0 Likes
7 Replies
Absent Member.
Absent Member.

ALso mention the listener...
0 Likes
Absent Member.
Absent Member.

The listener is OK. As can be seen from the ORA-message above, dbspicao has connected to the database and been able the obtain the database status.
0 Likes
Absent Member.
Absent Member.

No one still came across this problem and manages to solve it?
/Peter
0 Likes

I think the SPI is trying to log in to the standby - which doesn't allow log ins.
0 Likes
Micro Focus Expert
Micro Focus Expert

Hi Peter,

I think your issue is related to listener defination in your system, you have to consult your DBA for this.

For the time being you can add listener name in the text box for listner in Database Configuration utility

The other work around is to user sys/passowrd@ITEMCC as sysdba in your username string

So the final look should be

SYNTAX_VERSION 4
ORACLE
HOME "/opt/oracle/10.2.0"
DATABASE "ITIMACC" CONNECT "sys/password as sysdba"
LISTENER "ITIMACC"

Or

SYNTAX_VERSION 4
ORACLE
HOME "/opt/oracle/10.2.0"
DATABASE "ITIMACC" CONNECT "sys/password@ITIMACC as sysdba"

Regards,
Mahmoud Ibrahim
http://www.mahmoudthoughts.com
Regards,
Mahmoud Ibrahim
https://www.itmthoughts.com
New version of Mahmoudthoughts witten by other IT experts, if you want to share tips and tricks you are invited to join and write your own articles.
  • Say thanks by clicking the "Thump Up!" which is on the left.

  • Make it easier for other people to find solutions, by marking my answer with "Accept as Solution" if it solves your issue.
  • 0 Likes
    Absent Member.
    Absent Member.

    Hi all,
    here is the test case.

    # id
    uid=0(root) gid=3(sys) groups=0(root),1(other),105(dba)
    #
    #
    # sqlplus /nolog

    SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 24 18:43:51 2011

    Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

    SQL> conn hp_dbspi/hp_dbspi as sysdba
    Connected.
    SQL> select database_role from v$database;

    DATABASE_ROLE
    ----------------
    PHYSICAL STANDBY

    SQL> quit
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    #
    #
    # dbspicfg -e
    SYNTAX_VERSION 4

    ORACLE

    HOME "/progs/ora/product/10.2/db_1"
    DATABASE "DB4" CONNECT "HP_DBSPI/hp_dbspi as sysdba"

    #
    # dbspicao10 -d -f -v -i DB4
    Checking instance: 'DB4' @ '/progs/ora/product/10.2/db_1':
    2011-02-24T18:30:26 ERROR dbspicao(10) DB4 [cola:ora_util.pc:243]: DBSPI10-23: Unable to connect to database 'DB4' [ORA-01033: ORACLE initialization or shutdown in progress]. See Instruction text or User's Guide for details.
    Connect: FAILED

    #
    # sqlplus /nolog

    SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 24 18:57:01 2011

    Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

    SQL> conn hp_dbspi/hp_dbspi
    ERROR:
    ORA-01033: ORACLE initialization or shutdown in progress

    SQL> quit

    #
    # ovc -version
    HP Software Control 06.00.075
    #
    # uname -a
    HP-UX xxxxx B.11.11 U 9000/800 771471037

    The question is: why HP DBSPI does fail to connect? Why does it completely ignore 'as sysdba' clause in the connection string?

    For instance Oracle EM Agent is capable to connect to standby database with 'sysdba' role and therefore monitor it w/o any problems.

    Regards,
    Yakov.
    0 Likes
    Absent Member.
    Absent Member.

    Hi,

    Does anyone know if this has been resolved? I have many clients with physical standby database and currently they are not able to monitor these physical standby databases due to this issue. Any help would be greatly appreciated.

     

    syonis.

    0 Likes
    The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.