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.

ORA-24418: Cannot open further sessions.

1 Answers  

---

TNS-01014: set|show log_{ } [<value>]: set|show log parameters of current listener

1 Answers  

---

PCC-00031: Invalid value given for option "string"

1 Answers  

---

ORA-02433: cannot disable primary key - primary key not defined for table

1 Answers  

---

ORA-12153: TNS:not connected

1 Answers  

---

---

ORA-14099: all rows in table do not qualify for specified partition

1 Answers  

---

SQL*Loader-00937: parallel load requested and string has enabled triggers or constraints

1 Answers  

---

SQL*Loader-00931: OCI error while binding variable for column string in table string

1 Answers  

---

DRG-10821: contains cursor is not open

1 Answers  

---

ORA-22893: constraint can be specified only for REF columns

1 Answers  

---

ORA-36380: (AGGRECURSE) AGGREGATE was called recursively, which is not allowed.

1 Answers  

---

ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index

1 Answers  

---