Month: January 2020

ODG broker error: ORA-1005: null password given; logon denied

I have an Oracle DataGuard envrionment that it has been upgraded from 12.1.0.2 to 18C recently. After the upgrade, the ODG broker gave the following error: ORA-1005: null password given; logon denied DGMGRL> show configuration; Configuration - DG_APROD Protection Mode: MaxPerformance Members: DB1 - Primary database Error: ORA-1005: null password given; logon denied DB2- Physical … Continue reading ODG broker error: ORA-1005: null password given; logon denied →

Advertisement

ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations

Have your ever tried to rename an Oracle table or index and got this error: ORA-14047? According to Oracle's docs, the following is the syntax of changing a table or index name: ALTER TABLE [schema.]table_name RENAME TO <new_table_name>; ALTER INDEX [schema.]index_name RENAME TO <new_index_name>; Note the new table/index name should NOT have the schema name … Continue reading ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations →