ORA-00845: MEMORY_TARGET not supported on this system

Got this error...?


This type of error depends on your server memory allocated to your database.You need to change your memory_target.

Alter system set memory_target= 2000M scope=both;



cheers!!!

The OracleDBConsolev8it3 service terminated with service-specific error 1 (0x1).

Got this error?

The OracleDBConsolev8it3 service terminated with service-specific error 1 (0x1).



emca -config dbcontrol db

SEVERE: Failed to unlock all EM-related accounts


Could not complete the configuration. Refer to the log file for more details

It`s a common error. you need to drop dbconsole first.after that you can recreate the same


1)DROP DBCONSOLE first

emca -deconfig dbcontrol db -repos drop

then

2)CREATE NEW REPOSITORY

emca -repos create

emca -config dbcontrol db


It will take sometime to create new repository.Also you can see the path of EM at end of the execution.

Restart EM Console


emctl stop dbconsole db

emctl start dbconsole db



Cheers!!!

Unable to open Log File-EXPDP & IMPDP error

ORA-39002
ORA-39070
ORA-29283
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283

Check out expdp with default directory.If this ok.Then check out drive security.There is no SYSTEM user in SECURITY Tab.Add system user to SECURITY.Then try.

Cheers!!!

ORA-01000 maximum open cursors exceeded

Cause: A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user.

Action: Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle.

ALTER SYSTEM SET open_cursors = 400 SCOPE=BOTH;

Try to find out application to see why cursors are staying open.

LIBRARY CACHE HIT RATIO AND EXECUTION MISSES

The following SQL statement help you to calculate the library cache hit ratio:

SELECT
SUM(PINS) "EXECUTIONS",
SUM(RELOADS) "CACHE MISSES WHILE EXECUTING"
FROM
V$LIBRARYCACHE;

If the ratio of misses to executions is more than 1%, then try to reduce the library cache misses by increasing the shared pool size.

SHARED POOL TUNING-CACHE HIT RATIO.

We can simply find out cache hit ratio.Put this below query in to your sql window.

SELECT 'Buffer Cache' NAME,
ROUND ( (congets.VALUE + dbgets.VALUE - physreads.VALUE)
* 100
/ (congets.VALUE + dbgets.VALUE),
2
) VALUE
FROM v$sysstat congets, v$sysstat dbgets, v$sysstat physreads
WHERE congets.NAME = 'consistent gets'
AND dbgets.NAME = 'db block gets'
AND physreads.NAME = 'physical reads'
UNION ALL
SELECT 'Execute/NoParse',
DECODE (SIGN (ROUND ( (ec.VALUE - pc.VALUE)
* 100
/ DECODE (ec.VALUE, 0, 1, ec.VALUE),
2
)
),
-1, 0,
ROUND ( (ec.VALUE - pc.VALUE)
* 100
/ DECODE (ec.VALUE, 0, 1, ec.VALUE),
2
)
)
FROM v$sysstat ec, v$sysstat pc
WHERE ec.NAME = 'execute count'
AND pc.NAME IN ('parse count', 'parse count (total)')
UNION ALL
SELECT 'Memory Sort',
ROUND ( ms.VALUE
/ DECODE ((ds.VALUE + ms.VALUE), 0, 1, (ds.VALUE + ms.VALUE))
* 100,
2
)
FROM v$sysstat ds, v$sysstat ms
WHERE ms.NAME = 'sorts (memory)' AND ds.NAME = 'sorts (disk)'
UNION ALL
SELECT 'SQL Area get hitrate', ROUND (gethitratio * 100, 2)
FROM v$librarycache
WHERE namespace = 'SQL AREA'
UNION ALL
SELECT 'Avg Latch Hit (No Miss)',
ROUND ((SUM (gets) - SUM (misses)) * 100 / SUM (gets), 2)
FROM v$latch
UNION ALL
SELECT 'Avg Latch Hit (No Sleep)',
ROUND ((SUM (gets) - SUM (sleeps)) * 100 / SUM (gets), 2)
FROM v$latch;

ORA-00020: maximum number of processes (150) exceeded.

Maximum number of default process is 150.when that abouve error is happened..we can increase our max number of process by

alter system set processes=160 scope=spfile;