tag:blogger.com,1999:blog-71085343050958611292024-03-13T11:12:44.602-07:00Oracle Error CodeOracle Error Solution, find the answer to your oracle error.Unknownnoreply@blogger.comBlogger117125tag:blogger.com,1999:blog-7108534305095861129.post-7717977902793590552010-09-12T01:17:00.000-07:002010-09-12T01:20:24.685-07:00Oracle Database Import Error 3113/3114<b>Error:</b><br />
IMP-00003: ORACLE error 3113 encountered<br />
ORA-03113: end-of-file on communication channel<br />
IMP-00003: ORACLE error 3114 encountered<br />
ORA-03114: not connected to ORACLE<br />
This application has requested the Runtime to terminate it in an unusual way.<br />
Please contact the application's support team for more information.<br />
<br />
<b>Cause:</b><br />
The problem occurs because imp utiliy encounters error out when trying to execute some commands.<br />
<br />
<b>Solution:</b><br />
1. Login as sys in the SQLPLUS and run the following sqls <br />
<br />
@$ORACLE_HOME/rdbms/admin/dbmsread.sql <br />
@$ORACLE_HOME/rdbms/admin/prvtread.plb <br />
<br />
2. Redo the import.Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-60379707362996985172009-02-20T03:07:00.000-08:002009-03-27T16:35:02.545-07:00ORA-07445<div >
<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%" class="nobr">
<tbody>
<tr><td align="center"><u>ORA-07445</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-07445</u></td><td valign="top">:</td>
<td>Exception encountered: core dump [string] [string] [string] [string]
[string] [string]</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>An OS exception occurred which should result in the creation of a core file. This is an internal error.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Contact your customer support representative.</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-07445" rel="tag">ora-07445</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>
</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-52234952720382909412009-02-20T02:19:00.000-08:002009-02-20T02:23:14.367-08:00ORA-01918<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-01918</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-01918</u></td><td valign="top">:</td>
<td> user 'string' does not exist</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td> User does not exist in the system.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td> Verify the user name is correct.</td></tr>
<tr><td align="center" colspan="3" class="oraerrdef"><br><u>More Information</u></td></tr>
<tr><td colspan="3">To view a listing of all oracle users, execute the following SQL statement:<br>
<br>
SELECT * FROM ALL_USERS;<br>
<br>
<br>
To view a listing of all oracle roles, execute the following SQL statement:<br>
<br>
SELECT * FROM DBA_ROLES;</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-01918" rel="tag">ora-01918</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-86482417127212099482009-02-18T20:35:00.000-08:002009-02-18T21:07:07.376-08:00ORA-12545<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-12545</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-12545</u></td><td valign="top">:</td>
<td>Connect failed be target host or object does not exist</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>The address specified is not valid, or the program being connected to does not exist.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Ensure the ADDRESS parameters have been entered correctly; the most
likely incorrect parameter is the node name. Ensure that the executable for the
server exists (perhaps "oracle" is missing.) If the protocol is TCP/IP, edit the
TNSNAMES.ORA file to change the host name to a numeric IP address and tryagain.</td></tr>
<tr><td align="center" colspan="3" class="oraerrdef"><br><u>More Information</u></td></tr>
<tr><td colspan="3">1. Check your tnsname using "tnsping" command on client side:<br>
tnsping "your oracle service"<br>
2. Check database listener (server side) if the specific service or SID is on<br>
lsnrctl status<br><br>http://ora-error-101.blogspot.com/2008/11/ora-12541.html</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-12545" rel="tag">ora-12545</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-25964760821943777332009-02-18T01:32:00.001-08:002009-02-18T01:32:47.609-08:00ORA-25153<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-25153</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-25153</u></td><td valign="top">:</td>
<td>Temporary Tablespace is Empty</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>An attempt was made to use space in a temporary tablespace with no files.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Add files to the tablespace using ADD TEMPFILE command.</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-25153" rel="tag">ora-25153</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-44649092855102590282009-02-18T01:27:00.000-08:002009-02-18T01:29:37.130-08:00ORA-21780<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-21780</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-21780</u></td><td valign="top">:</td>
<td>Maximum number of object durations exceeded.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>This typically happens if there is infinite recursion in the PL/SQL function that is being executed.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>User should alter the recursion condition in order to prevent infinite recursion.</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-21780" rel="tag">ora-21780</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-15369732438920160762009-02-18T01:26:00.000-08:002009-02-18T01:27:01.334-08:00ORA-14074<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-14074</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-14074</u></td><td valign="top">:</td>
<td>Partition bound must collate higher than that of the last partition</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>Partition bound specified in ALTER TABLE ADD PARTITION statement
did not collate higher than that of the table"s last partition, which is illegal.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Ensure that the partition bound of the partition to be added collates
higher than that of the table"s last partition.</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-14074" rel="tag">ora-14074</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-32744698231894471422009-02-18T01:24:00.000-08:002009-02-18T01:25:36.559-08:00ORA-38029<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-38029</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-38029</u></td><td valign="top">:</td>
<td>Object statistics are locked</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>An attept was made to modify optimizer statistics of the object.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Unlock statistics with the DBMS_STATS.UNLOCK_TABLE_STATS
procedure on base table(s). Retry the operation if it is okay to update statistics.</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-38029" rel="tag">ora-38029</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-58678163771591948802008-11-07T10:16:00.000-08:002008-11-07T10:16:00.545-08:00ORA-06431<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-06431</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-06431</u></td><td valign="top">:</td>
<td>Ssaio: Invalid Block number</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>The file block number is out of range of the file. The additional
information returns the block number.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Verify that the block number is correct. Run dbfsize and check if the block
number is in that range. Contact your Oracle Customer Support Representative.</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-06431" rel="tag">ora-06431</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-44104356453649865092008-11-05T10:43:00.000-08:002008-11-05T10:46:46.630-08:00ORA-00997<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-00997</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-00997</u></td><td valign="top">:</td>
<td>TNS:no listener</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>A value of datatype LONG was used in a function or in a DISTINCT, WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. A LONG value can only be used in a SELECT clause.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Remove the LONG value from the function or clause</td></tr>
<tr><td align="center" colspan="3" class="oraerrdef"><br><u>More Information</u></td></tr>
<tr><td colspan="3">LONG datatypes cannot be used for Insert with selects or CTAS (create table as select)<br>
<br>
The ORA-00997 error is due to a know restriction where you cannot do an insert with select or Create table as select involving tables with LONG datatypes. We can however do the data transfer using the COPY command. Here's an example:<br>
<br>
-- You can set long to any large value as long as it is larger than the max length of any -- long column in the table. Exception is that sqlplus commands cannot handle a long<br>
-- greater than 64k. The long column will always be truncated at 64k.<br>
set long 2000000000<br>
-- commit after one batch of recordS<br>
set copycommit 1<br>
-- 100 records per batch<br>
set arraysize 100<br>
<br>
-- copy is a SQL*Plus command and needs the continuation character "-" for multiple lines.<br>
<br>
SQL> copy from REMOTE_USER/REMOTE_USER_PASSWORD@remotedb -<br>
insert testtab using select * from testtab<br>
Source:<a href="http://www.orafaq.com/forum/t/55560/0/">http://www.orafaq.com/forum/t/55560/0/</a><br>
<br>
Related Link:<br>
<a href="http://www.orafaq.com/forum/t/55560/0/">http://www.orafaq.com/forum/t/55560/0/</a><br>
<a href="http://www.lazydba.com/oracle/0__39635.html">http://www.lazydba.com/oracle/0__39635.html</a><br>
<a href="http://www.experts-exchange.com/Database/Oracle/Product_Info/Q_23801529.html">http://www.experts-exchange.com/Database/Oracle/Product_Info/Q_23801529.html</a><br>
<a href="http://www.experts-exchange.com/Databases/Oracle/Q_20920426.html">http://www.experts-exchange.com/Databases/Oracle/Q_20920426.html</a></td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-00997" rel="tag">ora-00997</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-63556226999674098162008-11-05T10:14:00.000-08:002008-11-05T10:15:35.592-08:00ORA-06421<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-06421</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-06421</u></td><td valign="top">:</td>
<td>NETCMN: Error detected in the read-in data</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>Error found during recomputation of checksum or CRC.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Possible hardware failures of communication nodes. Contact system
administrator immediately.</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-06421" rel="tag">ora-06421</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-28350941032365704102008-11-05T10:12:00.001-08:002008-11-05T10:12:52.605-08:00ORA-06407<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-06407</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-06407</u></td><td valign="top">:</td>
<td>NETCMN: unable to set up break handling environment</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>Error occurred while attempting to set up asynchronous handlers for
in-coming, out-of-band break messages.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Contact your customer support representative.</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-06407" rel="tag">ora-06407</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-9061149306860644112008-11-05T10:10:00.000-08:002008-11-05T10:11:12.548-08:00ORA-06406<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-06406</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-06406</u></td><td valign="top">:</td>
<td>NETCMN: error sending break message</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>Error occurred while attempting to send a break message.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Contact your customer support representative.</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-06406" rel="tag">ora-06406</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-7108534305095861129.post-51747792165335143112008-11-05T10:09:00.000-08:002008-11-05T10:10:13.814-08:00ORA-06405<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-06405</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-06405</u></td><td valign="top">:</td>
<td>NETCMN: reset protocol error</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>Unable to reset out of break state.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Contact your customer support representative</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-06405" rel="tag">ora-06405</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-77464295153824857722008-11-05T10:07:00.000-08:002008-11-05T10:08:55.031-08:00ORA-06404<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-06404</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-06404</u></td><td valign="top">:</td>
<td>NETCMN: invalid login (connect) string</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>Syntax error in login string.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Correct string and re-submit.</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-06404" rel="tag">ora-06404</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-15286870285537927812008-11-04T10:29:00.000-08:002008-11-05T10:43:32.197-08:00ORA-12541<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-12541</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-12541</u></td><td valign="top">:</td>
<td>TNS:no listener</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>he connection request could not be completed because the listener is not
running.
of connect identifier used was a net service name then the net service name could
not be found in a naming method repository, or the repository could not be located
or reached.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Ensure that the supplied destination address matches one of the
addresses used by the listener - compare the TNSNAMES.ORA entry with the
appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go by
way of an Interchange). Start the listener on the remote machine.
- Verify that a TNSNAMES.ORA file exists and is in the proper directory and is
accessible.
- Check that the net service name used as the connect identifier exists in the
TNSNAMES.ORA file.
- Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file.
Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA
file may make it unusable.
9-2 Oracle Database Error Messages
- If you are using directory naming:
- Verify that "LDAP" is listed as one of the values of the NAMES.DIRETORY_
PATH parameter in the Oracle Net profile (SQLNET.ORA).
- Verify that the LDAP directory server is up and that it is accessible.
- Verify that the net service name or database name used as the connect identifier
is configured in the directory.
- Verify that the default context being used is correct by specifying a fully qualified
net service name or a full LDAP DN as the connect identifier
- If you are using easy connect naming:
- Verify that "EZCONNECT" is listed as one of the values of the
NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).
- Make sure the host, port and service name specified are correct.
- Try enclosing the connect identifier in quote marks. See the Oracle Net Services
Administrators Guide or the Oracle operating system specific guide for more
information on naming.</td></tr>
<tr><td align="center" colspan="3" class="oraerrdef"><br><u>More Information</u></td></tr>
<tr><td colspan="3">1. Check your tnsname using "tnsping" command on client side:<br>
tnsping "your oracle service"<br>
2. Check database listener (server side) if the specific service or SID is on<br>
lsnrctl status</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-12541" rel="tag">ora-12541</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-31593235381987271942008-11-04T10:13:00.000-08:002008-11-05T10:14:29.035-08:00ORA-06420<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-06420</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-06420</u></td><td valign="top">:</td>
<td>NETCMN: SID lookup failure</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>From the remote host"s server: the database SID, specified in the login
(connect) string, was not recognized.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Add the appropriate SID entry to the CONFIG.ORA or oratab file on the
remote host (restarting the remote server may be needed).</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-06420" rel="tag">ora-06420</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-10922445028564233692008-11-03T10:20:00.000-08:002008-11-05T10:23:34.627-08:00ORA-02063<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-02063</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-02063</u></td><td valign="top">:</td>
<td>preceding stringstring from stringstring</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>an Oracle error was received from a remote database link.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>refer to the preceding error message(s)</td></tr>
<tr><td align="center" colspan="3" class="oraerrdef"><br><u>More Information</u></td></tr>
<tr><td colspan="3"> When the error is generated at the remote database it is accompanied with an<br>
ORA-2063. In this case the parameter distributed_transactions must be increased<br>
at the remote database.<br>
<br>
If there is no ORA-2063 the parameter distributed_transactions must be<br>
increased at the local database.<br>
<br>
In a distributed environment, if a select is issued in a session without the<br>
SET TRANSACTION READ ONLY command, the select query is considered a<br>
distributed transaction.<br>
<br>
If the parameter distributed_transactions is set too low, this too will result in an ORA-2042 and ORA-2063<br>
<br>
<br>
It is important to note that ORA-02063 typically appears with ORA-02042<br><br><a href="http://www.dba-oracle.com/t_ora_02063_preceding_stringstring_from_stringstring.htm">http://www.dba-oracle.com/t_ora_02063_preceding_stringstring_from_stringstring.htm</a></td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-02063" rel="tag">ora-02063</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-65634742589750632212008-11-01T10:28:00.000-07:002011-03-22T13:35:20.799-07:00ORA-12154<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0">
<tbody>
<tr><td align="center"><u>ORA-12154</u></td></tr>
<tr><td><table><tbody>
<tr><td class="oraerrdef" valign="top">ORA-12154</td><td valign="top">:</td>
<td>TNS:could not resolve the connect identifier specified</td>
</tr>
<tr><td class="oraerrdef" valign="top"><u>Cause</u></td><td valign="top">:</td>
<td>A connection to a database or other service was requested using a connect
identifier, and the connect identifier specified could not be resolved into a connect
descriptor using one of the naming methods configured. For example, if the type
of connect identifier used was a net service name then the net service name could
not be found in a naming method repository, or the repository could not be located
or reached.</td>
</tr>
<tr><td class="oraerrdef" valign="top"><u>Action</u></td><td valign="top">:</td>
<td><ul><u><b>
If you are using local naming (TNSNAMES.ORA file):
</b></u>
<li>Make sure that "TNSNAMES" is listed as one of the values of the
NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA)</li>
<li>Verify that a TNSNAMES.ORA file exists and is in the proper directory and is
accessible.</li>
<li>Check that the net service name used as the connect identifier exists in the
TNSNAMES.ORA file.</li>
<li>Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file.
Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA
file may make it unusable.</li>
<b>
9-2 Oracle Database Error Messages</b><br /><u><b>
If you are using directory naming:
</b></u>
<li>Verify that "LDAP" is listed as one of the values of the NAMES.DIRETORY_
PATH parameter in the Oracle Net profile (SQLNET.ORA).</li>
<li>Verify that the LDAP directory server is up and that it is accessible.</li>
<li>Verify that the net service name or database name used as the connect identifier
is configured in the directory.</li>
<li>Verify that the default context being used is correct by specifying a fully qualified
net service name or a full LDAP DN as the connect identifier</li>
<u><b>
If you are using easy connect naming:
</b></u>
<li>Verify that "EZCONNECT" is listed as one of the values of the
NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).</li>
<li>Make sure the host, port and service name specified are correct.</li>
<li>Try enclosing the connect identifier in quote marks. See the Oracle Net Services
Administrators Guide or the Oracle operating system specific guide for more</li>
information on naming.
</ul>
</td></tr>
</tbody></table>
</td></tr>
</tbody></table>
<br />
<br />
<br />
<br />
Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-12154" rel="tag">ora-12154</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-4415774662606110572008-09-11T02:56:00.000-07:002008-09-11T02:57:30.858-07:00ORA-04084<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-04084</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-04084</u></td><td valign="top">:</td>
<td>Cannot change NEW values for this trigger type</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td> New trigger variables can only be changed in before row insert or update triggers.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td> Change the trigger type or remove the variable reference.</td></tr>
<tr><td align="center" colspan="3" class="oraerrdef"><br><u>More Information</u></td></tr>
<tr><td colspan="3">you many try to asign new value to :new.column on after insert or update trigger, which you could do only on before insert or update trigger</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-04084" rel="tag">ora-04084</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-34972278851188774962008-09-09T21:02:00.001-07:002008-09-09T21:02:48.087-07:00ORA-00984<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-00984</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-00984</u></td><td valign="top">:</td>
<td>Column not allowed here</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>A column name was used in an expression where it is not permitted, such as in the VALUES clause of an INSERT statement.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Check the syntax of the statement and use column names only where appropriate.</td></tr>
<tr><td align="center" colspan="3" class="oraerrdef"><br><u>More Information</u></td></tr>
<tr><td colspan="3">I once used to have this problem, it appeard that the variable I used on values section and the one on declare section was not the same (I.e. vnumber and vnummer)</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-00984" rel="tag">ora-00984</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-86842421410034784902008-07-29T23:13:00.000-07:002008-07-29T23:16:48.777-07:00ORA-29339<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-29339</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-29339</u></td><td valign="top">:</td>
<td>Tablespace block size string does not match configured block sizes</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>The block size of the tablespace to be plugged in or created does not match the block sizes configured in the database</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Configure the appropriate cache for the block size of this tablespace using one of the various (db_2k_cache_size, db_4k_cache_size, db_8k_cache_size, db_16k_cache_size, db_32K_cache_size) parameters.</td></tr>
<tr><td align="center" colspan="3" class="oraerrdef"><br><u>More Information</u></td></tr>
<tr><td colspan="3">checking your oracle db_block_size<br>
<br>
show parameter db_block_size;<br>
<br>
if you are doing the data importing make sure the source database db_block_size is equal to the destination database db_block_size</td></tr>
</tbody></table>
</td></tr></tbody></table><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-29339" rel="tag">ora-29339</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-49565419838352150892008-07-29T21:10:00.001-07:002008-07-29T21:10:58.494-07:00ORA-12505<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-12505</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-12505</u></td><td valign="top">:</td>
<td>TNS:listener does not currently know of SID given in connect</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>The listener received a request to establish a connection to a database or
other service. The connect descriptor received by the listener specified a SID for an
instance (usually a database instance) that either has not yet dynamically
registered with the listener or has not been statically configured for the listener.
This may be a temporary condition such as after the listener has started, but before
the database instance has registered with the listener.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>- Wait a moment and try to connect a second time.<br>
- Check which instances are currently known by the listener by executing: lsnrctl services <listener name><br>
- Check that the SID parameter in the connect descriptor specifies an instance known by the listener.<br>
- Check for an event in the listener.log file.<br></td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-12505" rel="tag">ora-12505</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-86315953321739954602008-07-29T20:47:00.000-07:002008-07-29T20:54:10.839-07:00ORA-00054<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-00054</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-00054</u></td><td valign="top">:</td>
<td>Resource busy and acquire with NOWAIT specified</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>Resource interested is busy.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>Retry if necessary</td></tr>
<tr><td align="center" colspan="3" class="oraerrdef"><br><u>More Information</u></td></tr>
<tr><td colspan="3">If you administer a busy database you will see this error from time to time. It is nothing to worry about, but it can be quite annoying when it stops you from doing something.<br>
<br>
It simply means that session has a lock on an object that your session is trying to update (or lock). More specifically, your session has asked for a lock on the same object, but has specified the 'nowait' clause. The nowait clause, upon finding something locked, returns an error, rather than waiting for the lock to be released.<br><br>http://www.shutdownabort.com/errors/ORA-00054.php</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-00054" rel="tag">ora-00054</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-7108534305095861129.post-70150448675450097172008-07-29T20:39:00.001-07:002008-07-29T20:41:11.813-07:00ORA-00205<table border="1" bordercolor="#0000ff" cellpadding="10" cellspacing="0" width="100%">
<tbody>
<tr><td align="center"><u>ORA-00205</u></td></tr>
<tr><td><table><tbody>
<tr><td valign="top" class="oraerrdef">ORA-00205</u></td><td valign="top">:</td>
<td>Error in identifying control file, check alert log for more info</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Cause</u></td><td valign="top">:</td>
<td>The system cannot find the control file. The filename and the size of the file do not match the list of the control files that it holds.</td>
</tr>
<tr><td valign="top" class="oraerrdef"><u>Action</u></td><td valign="top">:</td>
<td>If the system can't find the control file, then the database can't be mounted. Find the file and put it in the path, as specified in the SPFILE/INITSID.ORA file's CONTROL_FILES parameter else check the CONTROL_FILES parameter of the SPFILE/INITSID.ORA file. Check if you have referenced the correct file.<br>
You can find this by executing:<br>
SHOW PARAMETERS control_files<br>
<br>
or:<br>
<br>
SELECT VALUE
FROM V$PARAMETER
WHERE NAME = 'control_files'
/
<br>
Check that ALL controlfiles, found using the select above, are online and that they are the same files that the system created at cold start time.<br>
<br>
If you cannot find the control file, then start the instance without mounting the database and use the CREATE CONTROLFILE statement to create a new control file. After creating the control file, shut the database. Now add this control file to the SPFILE/INIT.ORA and then start the database. <br>.</td></tr>
<tr><td align="center" colspan="3" class="oraerrdef"><br><u>More Information</u></td></tr>
<tr><td colspan="3"><br><br>http://www.orafaq.com/wiki/ORA-00205</td></tr>
</tbody></table>
</td></tr></tbody></table><br><br><br/><br/>Tags: <span class="tags"><a href="http://technorati.com/blogs/tag/ora-00205" rel="tag">ora-00205</a>,<a href="http://technorati.com/blogs/tag/ora-error" rel="tag">ora-error</a>,<a href="http://technorati.com/blogs/tag/oralce+error" rel="tag">oracle error</a>,<a href="http://technorati.com/blogs/tag/oracle+code" rel="tag">oracle code</a>,<a href="http://technorati.com/blogs/tag/ora+error+code" rel="tag">ora error code</a></span>Unknownnoreply@blogger.com0