ORA-04930: open sequence number failed or initial state is valid



ORA-04930: open sequence number failed or initial state is valid..

Answer / guest

Cause: Either Shared Sequence Number OS component was not
installed properly, or an MC hardware failure may have
occurred or a previous instance was not shut down properly.

Action: Verify that there are no background or foreground
Oracle processes from a previous instance on this node using
the OS command ps -ef|grep <instance_name>. Verify that
there are no shared memory segments belonging to the user
which owns the Oracle installation by isuing the ipcs -b OS
command. If there are shared memory segments or processes
still on the system, use svrmgrl to shutdown the instance
with the abort option. If the instance is not up, verify
that the cluster software and/or the hardware is installed
and working. Log in as superuser and issue the cnxshow
command. Are all of the nodes in the cluster listed? Are
they members of the cluster? Is the communications between
nodes okay? If the answer to any of these questions is
false, contact Digital's customer support organization.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

O2I-00113: No HFILE specified

1 Answers  


ORA-02236: invalid file name

1 Answers  


ORA-16589: Data Guard Connection process detected a network transfer error

1 Answers  


ORA-12435: invalid audit success: string

1 Answers  


ORA-28300: No permission to read user entry in LDAP directory service.

1 Answers  






ORA-21301: not initialized in object mode

1 Answers  


RMAN-06280: Report of obsolete backups and copies

1 Answers  


ORA-09875: TASDEF_WRITE: write error when writing ?/dbs/tasdef@.dbf file.

1 Answers  


ORA-39954: DEFERRED is required for this system parameter

1 Answers  


ORA-37043: (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.

1 Answers  


ORA-31433: subscriber view does not exist

1 Answers  


PCC-00060: Both CURSOR and STATEMENT have AT clauses at line number of file string.

1 Answers  


Categories