Wednesday, October 28, 2020
    Home Oracle Troubleshooting Solution of ORA-39511 with CRS-5702

    Solution of ORA-39511 with CRS-5702

    Solution of ORA-39511: Start of CRS resource for instance failed with error :[CRS-5702: Resource 'ora.asm' is already running

    Solution of ORA-39511: Start of CRS resource for instance ‘242’ failed with error :[CRS-5702: Resource ‘ora.asm’ is already running on ‘abc005’

    How problem hit:

    While trying to startup a new instance manually in order to start duplicating one database I was getting below error:

    - Advertisement -

    SQL> startup nomount pfile=initabc1.ora
    ORA-39511: Start of CRS resource for instance ‘242’ failed with error:[CRS-5702: Resource ‘ora.asm’ is already running on ‘abc005’
    CRS-0223: Resource ‘ora.asm’ has placement error.
    clsr_start_resource:260 status:242
    clsrapi_start_asm:start_asmdbs status:242

    This is on a 19c database setup on a cluster environment with ASM.

    Before I issue this command I’ve manually dropped a database having same name abc, I didn’t use dbca for this job because I had a problem login to the server with VNC, so I took the easy approach and dropped it manually and deleted all its files under ASM groups.

    Solution and Workaround:

    It’s always recommended dropping the database using DBCA, specially on a cluster/Oracle Restart environment. This will maintain to clean up all database resources on the server and avoid having above error.

    - Advertisement -

    For my scenario, because my job was not complete, I had to remove the remaining database cluster resources manually using the following commands:

    1- Remove the database and its instances resources from OCR:
    srvctl remove instance -d abc -i abc1
    srvctl remove instance -d abc -i abc2
    srvctl remove database -d abc

    2- Remove all the database files inside ASM including datafiles, redo log files, controlfiles, password file, spfile from asmcmd console.

    3- Remove the database entry from /etc/oratab

    4- Make sure there are no resources belong to the dropped database:

    crsctl stat res -p

    When you want to make strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals , Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert. This expert DBA Team club blog always provides you latest technology news and database news to be keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. These all Oracle DBA tips are available in single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would be enjoy more advance topics from our partner resource.

    Consider reading to these articles:

    - Advertisement -
    - Advertisment -

    Most Popular

    Identifying important information in Big Data

    The way in which Big Data technologies have evolved in the real word enterprise goes on to show that even technologists and scientists who might have disparaged the word (Big Data) previously

    Five Reasons Why Database Outsourcing

    The blog post explains why database outsourcing and remote dba support becomes most popular during present time of Covid-19 Pandemic.

    Hardware of Database Server

    The blog post explains how to choose best hardware of your database server for getting high performance and security.

    oracle 19c new features – Automatic Indexing

    A major Oracle 19c autonomous database new Feature automatic indexing using DBMS_AUTO_INDEX some details and how to article.

    Recent Comments