Remember once the DG build process ora-00210,ora-00202,ora-27086 Library error

Ora-00210:cannot Open the specified control file

Ora-00202:control file: '/u01/app/oracle/oradata/orcl/control01.ctl '

Ora-27086:unable to lock File-already inch use

Ideas:

1 , look at "LK" and "sgadef.dbf " These two documents are not present, and if they exist, they are deleted;

2 , see if there is a background process exists;

3 , look at Oracle shared memory segments and signal sets (semaphores) is not still there;

Actual operation:

[Email protected] ~]$ Cd$oracle_home/dbs

[[email protected] dbs]$ ls

Hc_sid.dat Initdw.ora Init.ora lksid orapwsid Spfilesid.ora

[Email protected] dbs]$ RM lksid

[[email protected] dbs]$ ls

Hc_sid.dat Initdw.ora Init.ora Orapwsid Spfilesid.ora

[[email protected] dbs]$ Ps-ef|grepora_|grep SID

Oracle 4981 1 0 09:00? 00:00:00 Ora_pmon_sid

Oracle 4983 1 0 09:00? 00:00:00 Ora_psp0_sid

Oracle 4985 1 0 09:00? 00:00:00 Ora_mman_sid

Oracle 4987 1 0 09:00? 00:00:00 Ora_dbw0_sid

Oracle 4989 1 0 09:00? 00:00:00 Ora_lgwr_sid

Oracle 4991 1 0 09:00? 00:00:01 Ora_ckpt_sid

Oracle 4993 1 0 09:00? 00:00:01 Ora_smon_sid

Oracle 4995 1 0 09:00? 00:00:00 Ora_reco_sid

Oracle 4997 1 0 09:00? 00:00:00 Ora_cjq0_sid

Oracle 4999 1 0 09:00? 00:00:07 Ora_mmon_sid

Oracle 5001 1 0 09:00? 00:00:00 Ora_mmnl_sid

Oracle 5003 1 0 09:00? 00:00:00 Ora_d000_sid

Oracle 5005 1 0 09:00? 00:00:00 Ora_s000_sid

Oracle 5023 1 0 09:00? 00:00:00 Ora_qmnc_sid

Oracle 5133 1 0 09:00? 00:00:00 Ora_q000_sid

Oracle 5139 1 0 09:00? 00:00:00 Ora_q001_sid

Oracle 31755 1 1 13:21? 00:00:00 Ora_j000_sid

[Email protected] dbs]$ Ps-ef|grepora_|grep sid|grep Pmon

Oracle 4981 1 0 09:00? 00:00:00 Ora_pmon_sid

[Email protected] dbs]$ kill-9 4981

[Email protected] dbs]$ Ps-ef|grepora_|grep sid|grep Pmon

[Email protected] dbs]$ ipcs-m

------Shared Memory Segments--------

Key shmid owner perms bytes nattch Status

Re Startup database, problem solving.

Remember once the DG build process ora-00210,ora-00202,ora-27086 Library error