ansible-oracle
ansible-oracle copied to clipboard
Unable to put both new or existing DB into archivelog mode
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"}
I need more info than this. Can you show me your group_vars?
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