MUST_RENAME_THIS_DATAFILE on RAC Standby

Few days ago i got the activity to create the 2 NODE RAC DR on EXADATA for 2 NODE RAC Production. Here I am listing few issues that made this activity perfect case for Data Guard beginners Environment:Production Database Name: Financedb_unique_name : finance Standby Database Name : Finstandbydb_unique_name : finstandby Production OS Node: agoracledba1 agoracledba2Standby […]

Read More

ORA-12162: TNS:net service name is incorrectly specified

Let’s have look on some listener issues in the database. Cause: The connect descriptor corresponding to the net service name in TNSNAMES.ORA or in the directory server (Oracle Internet Directory) is incorrectly specified. Action: If using local naming make sure there are no syntax errors in the corresponding connect descriptor in the TNSNAMES.ORA file. If […]

Read More