Answer / bhuvneshwar singh

ORA-38706 "Cannot turn on flashback database logging"
ORA-38709 "Recovery area is not enabled"

Solution :

1. do the proper shutdown of database (shut normal,immediate).
2. start up database in mount phase ( startup mount).
3. set this parameter one by one
a.ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=2G
SCOPE=BOTH;

B.ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=/HOME/FRA
SCOPE=BOTH;

4. ALTER DATABASE OPEN;

5. NOW USE THIS COMMAND AND CHECK IT OUT WHETHER FLASHBACK
AREA IS ENABLED ?

SELECT NAME, FLASHBACK_ON FROM V$DATABASE;


I am sure this information will help you a lot

Regards
Bhvuneshwar singh

Answer / guest

Cause: An ALTER DATABASE FLASHBACK ON command failed because
the Recovery Area was not enabled.

Action: Set DB_RECOVERY_FILE_DEST to a location and retry.

Please add more information about this Error

Answer / ajit tripathi

Everything will be same as above only path for fra will be inverted comas.

PLS-00623: FLOAT precision constraint must be between 1 and 126

1 Answers  

---

ORA-02227: invalid cluster name

1 Answers  

---

PCC-02409: Expecting an expression of some REF type

1 Answers  

---

QSM-01067: materialized view, string, cannot support the query measure, string

1 Answers  

---

NNO-00853: failed to get LDAP attribute/value: error = number

1 Answers  

---

ORA-37112: OLAP API requires Oracle 9.2 or later

1 Answers  

---

ORA-23371: column string unknown in table string

1 Answers  

---

ORA-23345: table "string"."string" not registered to collect statistics

1 Answers  

---

ORA-31192: Resource string has not been checked out

1 Answers  

---

NID-00372: Change database ID and database name string to string? (Y/[N]) =>

1 Answers  

---

ORA-24903: invalid namespace attribute passed into OCI call

1 Answers  

---

ORA-09846: soacon: ARCH unable to open named pipe.

1 Answers  

---