Pages

▼
Showing posts with label Oracle DB Administration. Show all posts
Showing posts with label Oracle DB Administration. Show all posts
Sunday, 6 July 2014

Thread 1 cannot allocate new log, sequence Checkpoint not complete

›
Problem: Following message getting from alert log Archived Log entry 19900 added for thread 1 sequence 19187 ID 0x9b87c8af dest 1: Thr...
2 comments:
Sunday, 29 June 2014

Resize Online Redo Log size in Oracle 11g R2

›
Re size Online Redolog size in Oracle 11gR2 Step 1. Check the status of redolog files Step2. Create 3 three new redolog file with size...
2 comments:
Sunday, 1 June 2014

Solution for ORA-01157 ORA-01110 error

›
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file ORA-01110: data file 201: '/u01/app/oracle/oradata/STLBAS/temp01.db...
2 comments:
Wednesday, 7 May 2014

Find alert log error from Database table

›
Find alert log error from  Database table SELECT ORIGINATING_TIMESTAMP, MODULE_ID, PROCESS_ID, MESSAGE_TEXT,HOST_ID FROM X$DBGALERTEXT ...
2 comments:
Monday, 14 April 2014

ORA-01102: cannot mount database in EXCLUSIVE mode

›
Error: ORA-01102: cannot mount database in EXCLUSIVE mode SQL> startup ORACLE instance started. Total System Global Area 4993982464...
2 comments:
Tuesday, 8 April 2014

Step by step to configure Oracle Heterogeneous Connectivity with 10g and DB2

›
Step by step to configure Oracle Heterogeneous Connectivity with 10g and DB2 1. Create a ODBC named DB2_ODBC [Note: The DSN must be ...
2 comments: