Top
PRIMECLUSTER Wizard for Oracle 4.5 Configuration and Administration Guide
FUJITSU Software

A.1.3 Warning state

An Oracle instance has been activated, but an Oracle instance resource has entered Warning.

[Case 1] (Standby Operation, Scalable Operation with Oracle RAC, Single-Node Cluster Operation)

An Oracle instance resource enters Warning when

If ORA-01017 is output to syslog, you can determine the cause of this problem.
Register the correct SYSTEM user password again. See “3.3 Oracle SYSTEM User Password Change ”.

[Case 2] (Standby Operation, Scalable Operation with Oracle RAC, Single-Node Cluster Operation)

An Oracle instance resource enters Warning when the Oracle SYSTEM user account is locked, so you are not allowed to connect to Oracle instance.

If ORA-28000 is output to syslog, you can determine the cause of this problem.

You can also check the SYSTEM user account by referring to the following SQL.

If the “account_status” column indicates “LOCKED(TIMED)” or “LOCKED”, you can determine the cause of this problem.

# su - <Oracle user>
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> select username, account_status from dba_users;

Access Oracle instance using sysdba privileges then release account locking of the SYSTEM user.

# su - <Oracle user>
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> alter user system account unlock;

If ORA-01017 is output to syslog as well as ORA-28000, an incorrect password might have been registered. In this case, correct the SYSTEM user password. See “3.3 Oracle SYSTEM User Password Change ”. Then, release account locking using the procedure above.

[Case 3] (Standby Operation, Scalable Operation with Oracle RAC, Single-Node Cluster Operation)

An Oracle instance resource enters Warning when instance monitoring is discontinued.
Check the monitoring status by executing the “clorainfo -m” command. See “4.6 clorainfo - Display Resource Configuration and Monitoring Status”.
If instance monitoring has been discontinued, check if the Oracle instance has been activated with the OPEN status then restart monitoring. See “4.2 hvoraenable - Restart Monitoring Resources”.

[Case 4] (Standby Operation, Scalable Operation with Oracle RAC, Single-Node Cluster Operation)

In Oracle instance monitoring, an Oracle instance resource enters Warning if there is no reply from SQL (e.g. insert, update, etc.) within a specified time, but you can access the Oracle instance, and the instance indicates OPEN. “ERROR: 0226: Watch Timeout occurred” message will also be output to syslog.
Take corrective action on Oracle database.
In Oracle instance monitoring of PRIMECLUSTER Wizard for Oracle, if there is no reply from the Oracle instance within a specified time, monitoring timeout will be considered. At the first monitoring timeout, the resource will only enter Warning, however, if it occurs twice in a row, a resource failure will be determined.

[Case 5] (Standby Operation, Scalable Operation with Oracle RAC, Single-Node Cluster Operation)

In Oracle instance monitoring, an Oracle instance resource enters Warning if you cannot access the Oracle instance because of a max session error or max process error.
If ORA-00018 or ORA-00020 is output to syslog, you can determine the cause of this problem.
For the maximum number of sessions that are set in the Oracle SESSIONS parameter, or the maximum number of processes that are set in the PROCESSES parameter, estimate enough values considering monitoring sessions for PRIMECLUSTER Wizard for Oracle.

For details see the Oracle Database manual.

[Case 6] (Standby Operation, Scalable Operation with Oracle RAC, Single-Node Cluster Operation)

An Oracle instance resource enters Warning when the SYSTEM user's password has expired, so Oracle instance connection is not allowed.
If ORA-28001 is output to syslog, you can determine the cause of this problem.
You can also check it by referring to the following SQL statement. If the ORA-28001 error message appears, you can determine the cause of this problem.

# su - <Oracle user>
$ sqlplus /nolog
SQL> connect system/password
ERROR:
ORA-28001: the password has expired

Changing password for system
New password:

In this case, change the SYSTEM user's password. After that, register the password with “clorapass” command. Refer to “3.3 Oracle SYSTEM User Password Change ”.

[Case 7] (Scalable Operation with Oracle RAC)

The monitoring of Oracle RAC instance resource becomes failure when setting of WFTime is the followings, the resource state enter Warning until it is recovered by Oracle Clusterware.

It is possible to check setting of WFTime by the “clorainfo -c” command. (For detail of “WFTime”, refer to step 10 of “2.3.5 userApplication with Oracle RAC Instances and Listeners”).
Check the Oracle database alert log, so you might be able to detect the cause of the failure.