ORA-02085 I created a database link without any problem. But when I tried to test the link, I got ORA-02085. SQL> select sysdate from dual@source_link;… Read More »How to Resolve ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE
In an unfamiliar environment, if there's only oracle or grid account is available for DBA to use, how can he to know everything about the database… Read More »How to Know Everything about an Unfamiliar Database
You can have this one: SQL> ALTER DATABASE OPEN READ ONLY; And also this one: SQL> ALTER DATABASE OPEN RESETLOGS; But there's NO combined statement like… Read More »Can I Open Database to READ ONLY with RESETLOGS?
PMON failed to acquire latch Here was the case, the database was hanging caused by some heavy loading processes. Users complained about the high waiting… Read More »How to Resolve "PMON failed to acquire latch, see PMON dump"