IMP-00038: Could not convert to environment character set's handle

Check character set of Database which export dump file has been already taken.

You check the character set with below query.

select * from v$nls_parameters where parameter in ('NLS_CHARACTERSET','NLS_LANGUAGE');

Also check the character set of DB which needs to be imported.

Check whether the characterset conversion is possible or not.

Sometimes a corrupted dumpfile cause this error.Suppose if you are trying to import using IMP from a EXPDP(Data pump Export)dumpfile Cause this error .

Cheers.

EXEC DBMS_WM.REMOVEWORKSPACE('WORKSPACE_NAME');

ora-04030 out of process memory while trying to allocate 'N' bytes.


Delete all the save points from workspace.We can see the save points from WMSYS.WM$WORKSPACE_SAVEPOINTS_TABLE.Use below query to remove save points from worskspace .


DBMS_WM.DeleteSavepoint(
workspace IN VARCHAR2,
savepoint_name IN VARCHAR2,
compress_view_wo_overwrite IN BOOLEAN DEFAULT FALSE,
auto_commit IN BOOLEAN DEFAULT TRUE,
commit_in_batches IN BOOLEAN DEFAULT FALSE,
batch_size IN VARCHAR2 DEFAULT 'PRIMARY_KEY_RANGE');


After the successful removal of save points,You can remove workspace simply by

EXEC DBMS_WM.REMOVEWORKSPACE('WORKSPACE_NAME');


Cheers!!!

Forcefull Disable Version on Versioned Table.

You can forcefully Disable Version tables that have already modified in non Live Workspace in Oracle.But all the changes made by the non Live workspace will be neglected.

SQL> EXEC DBMS_WM.DISABLEVERSIONING('TABLE_NAME',TRUE);

ORA-16179: incremental changes

ORA-16179: incremental changes to "log_archive_dest_2" not allowed with SPFILE


You can simply avoid this error by cross checking your command once again.

Use your command like this

SQL>ALTER SYSTEM SET log_archive_dest_2 = 'LOCATION=/OPT/ARC' SCOPE=SPFILE;



Cheers!!!

ORA-04031: unable to allocate N bytes of shared memory

This error can we fixed by increasing shared pool memory.

Or you can flush your shared pool memory ,If the size is already High

SQL>alter system flush shared_pool;

You can increase shared pool size(shared_pool_size) using parameter file(INIT.ORA)

Or you can dynamically increase your size by

SQL>ALTER SYSTEM SET SHARED_POOL_SIZE=1200M SCOPE=BOTH;

Last SQL statement on each SCHEMA

We can calculate late executed statement using below query.

select j.sql_text,y.username
from v$session y, v$sqlarea j
where j.hash_value = y.prev_hash_value



Cheers.

ORA-12518: TNS:listener could not hand off client connection

ORA-12518: TNS:listener could not hand off client connection

In a shared server environment .


Shutdown the dispatcher and add new dispatchers.
SQL> show parameter dispatchers
SQL> select name from v$dispatcher;
SQL> alter system shutdown immediate 'D001';
Add new dispatcher
SQL> alter system set DISPATCHERS = '(protocol=tcp)(dispatchers=4)';


In dedicated Server.


PGA is fully allocated for all processes.Check PGA memory allocation.
SQL> SELECT * FROM V$PROCESS ORDER BY PGA_ALLOC_MEM DESC

Kill unnecessary Sessions for freed PGA memory



Cheers...!!!