ansible-oracle icon indicating copy to clipboard operation
ansible-oracle copied to clipboard

Unable to put both new or existing DB into archivelog mode

Open g10chy opened this issue 5 years ago • 2 comments

TASK [oradb-manage-db : manage-db | create/manage database] ************************************************************************************************************
fatal: [servername]: FAILED! => {"changed": false, "msg": "Something went wrong while executing sql - ORA-01126: database must be mounted in this instance and not open in any instance sql: alter database archivelog"}

g10chy avatar Mar 28 '19 14:03 g10chy

I need more info than this. Can you show me your group_vars?

oravirt avatar Mar 28 '19 18:03 oravirt

Sure, database.yml from group__vars is:

oracle_databases:                                               # Dictionary describing the databases to be installed
      - home: 18300-base                                            # 'Last' directory in ORACLE_HOME path (e.g /u01/app/oracle/12.2.0.1/db1)
        oracle_version_db: 18.3.0.0
        oracle_db_name: orclcdb                                 # Database name
        oracle_db_type: SI                                   # Type of database (RAC,RACONENODE,SI)
        is_container: True                                # (true/false) Is the database a container database
        storage_type: FS                                     # Database storage to be used. ASM or FS.
        oracle_db_mem_totalmb: 1024                            # Amount of RAM to be used for SGA
        oracle_database_type: MULTIPURPOSE                   # MULTIPURPOSE|DATA_WAREHOUSING|OLTP
        redolog_size: 75M
        redolog_groups: 3
        datafile_dest: /u01/oradata
        recoveryfile_dest: /u01/fra
        archivelog: true
        flashback: true
        force_logging: true
        listener_name: LISTENER
        listener_port: 1621
        state: present

g10chy avatar Mar 28 '19 19:03 g10chy