Prosperity Quote

But as for you, be strong and do not give up, for your work will be rewarded. – 2 Chronicles 15:7

Quote of the Day

more Quotes

Who's Online

2 visitors online now
0 guests, 2 bots, 0 members

Thread 1 cannot allocate new log, sequence 36286 Checkpoint not complete while doing import

Problem:- Oracle10g Import is slow and see the warnings in the Oracle Alert Log

Thread 1 advanced to log sequence 36285 (LGWR switch) Current log# 2 seq# 36285 mem# 0: F:ORACLEORADATAMZSTWCD1MZSTWCD1_REDO02A.LOG Current log# 2 seq# 36285 mem# 1: G:ORACLEORADATAMZSTWCD1MZSTWCD1_REDO02B.LOG Thread 1 cannot allocate new log, sequence 36286 Checkpoint not complete

Cause:-

The “checkpoint not [...]

streams_pool_size defaulting to 179516211 in oracle alert log

streams_pool_size defaulting to 179516211 in oracle alert log

 

Problem

———-

The streams_pool_size dynamically changed from 0 to 179516211

and the following were recorded in the oracle alert log indicating issues related to data pump.

streams_pool_size defaulting to 179516211

kupprdp: master process DM00 started with pid=61, OS id=39190678

to execute – SYS.KUPM$MCP.MAIN(‘SYS_EXPORT_FULL_01′, [...]

ORA-29283: invalid file operation ORA-06512: at “SYS.UTL_FILE”, line 488

Problem

————–

When doing export form datapump

ORA-29283: invalid file operation ORA-06512: at “SYS.UTL_FILE”, line 488

Solution

————–

create the unix directory and the data pump directory in oracle

DROP DIRECTORY DATA_PUMP_DIR;

 

CREATE OR REPLACE DIRECTORY

DATA_PUMP_DIR AS

‘/u01/oracle/admin/msoa1_js/dpdump/’;

 

 

GRANT READ, WRITE ON DIRECTORY SYS.DATA_PUMP_DIR TO dp WITH GRANT OPTION;

 

GRANT [...]

EXP-00056: ORACLE error 1017 encountered ORA-01017: invalid username/password; logon denied

Problem

————–

The OS Authentication fails due to the missing user OPS$ORACLE

Cpsoa1:/u01/oracle> exp /

Export: Release 10.2.0.4.0 – Production on Tue Jan 11 13:52:43 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

EXP-00056: ORACLE error 1017 encountered

ORA-01017: invalid username/password; logon denied

Username:

Password:

Solution

————

create user and grant permission for OS [...]

ORA-06512: at “SYS.OLAPIHISTORYRETENTION”, line 1

problem

—————–

SQL> startup pfile=initTEST.ora ORACLE instance started.

Total System Global Area 314572800 bytes Fixed Size 2083760 bytes Variable Size 100664400 bytes Database Buffers 205520896 bytes Redo Buffers 6303744 bytes Database mounted. ORA-03113: end-of-file on communication channel

The alert log has

replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started [...]

ORA-12705: Cannot access NLS data files or invalid environment specified

PROBLEM

————–

The following error occurred when trying to connect to sql*plus to run a script.

ORA-12705: Cannot access NLS data files or invalid environment specified

SQL*Plus: Release 10.2.0.4.0 – Production on Fri Jan 7 10:09:37 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR: ORA-12705: Cannot access NLS data files or invalid environment [...]