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

ORA-32611: incorrect use of MODEL CV operator

1 Answers  


TNS-04067: Number of connections: number.

1 Answers  


NNL-00936: Requests refused, DATA-EXISTS violation: number

1 Answers  


NZE-28813: invalid record type

1 Answers  


ORA-39041: Metadata filter has no selectivity.

1 Answers  






ORA-31455: nothing to ALTER

1 Answers  


ORA-09822: Translation of audit file name failed.

1 Answers  


RMAN-06479: WARNING: control file copy 'string' cannot be found on disk

1 Answers  


ORA-07220: slspool: wait error.

1 Answers  


KUP-11007: conversion error loading table string.string

1 Answers  


SQL*Loader-00121: Invalid skip_unusable_indexes option

1 Answers  


ORA-01921: role name 'string' conflicts with another user or role name

1 Answers  


Categories