Oluseyi
2014-02-28 09:45:38
The illegal character for me was <>.
Erik
2013-07-09 10:36:09
On Windows installations, the external table source file cannot be located on a drive mounted as a directory. If c:\app\oracle\exports\EXPORT.LOG is your source file and drive E: is also mapped to c:\app\oracle\exports, you cannot use the mapped directory. Instead you must use E:\EXPORT.LOG as the location for your source file.
Andrew Reid
2013-05-22 21:32:17
Here is an example to show how you might get this error:
http://international-dba.blogspot.co.uk/2013/04/ora-08176-set-transaction-read-only.html
Marian
2013-05-12 05:28:38
Tnx very usefull. It work for me
2013-05-04 18:43:36
what to do for a solution
EROX
2013-04-28 03:01:27
Thanks
DANIELA
2013-04-03 12:32:17
How can I use command line -k ? I'm on a unix platform and I don't know how to use "-k" command line.
Leonardo
2013-03-27 13:52:45
Can you post a correct example in creating table space?
Ajay
2013-03-22 05:14:16
Excellent post..!! Very Helpful.. Thank you so much..
Jose fonseca
2013-03-08 19:56:42
Puede tambien tomar la propiedad del campo de la tabla ;
Ejemplo :
declare
nCampo_01 NOMBRE_TABLA.CAMPO_01%TYPE

Este ejemplo es para evitar que no se confunda los tipos de datos.
ejemplo 2 :

FUNCTION test_val (cCodCia POLIZACT.CODCIA%TYPE , cCodOper TRANS_CONTA_BLE1.CODOPER%TYPE , nNumOper TRANS_CONTA_BLE1.NumOper%TYPE)
RETURN VARCHAR2 IS



krunal
2013-03-04 20:19:28
how can i open oracle database in asp.net?
mallikharjuna
2013-03-04 10:31:20
i have faced the issue in runinstaller for doing CRS/ASM upgradation

PRIF-30: Network information in OCR profile needs to be synced with GPnP profile.

How do I syn with GPnP
Nejat
2013-02-28 17:05:34
Hi all,
while i'm installing oracle db on linux using virtualbox is displays this error:
"Insufficient disk space on this volume for the selected Oracle home"

but when i partition the hard disk i gave 20GB and i put nothing on them.
How can it be insuficient?

I'm new for oracle pls help.

Thanx.
Sakthi
2013-02-27 06:36:54
What is the correct syntax for ORA-02237?
Sakthi
2013-02-27 06:35:47
What is the correct syntax?
Karen
2012-12-28 13:56:26
That is a useless comment (admin: how ironic)
pecas_costa_rica
2012-12-19 19:15:23
Hey you are a genious. Thank you very much!.
vikneswaran
2012-11-15 08:02:55
it is simple thing.. please open the user account then make never modify.. it will work.....
Wlyp
2012-11-04 15:25:47
alter system set encryption wallet close identified by "<Wallet_password>"
-
2012-10-25 10:19:57
and on Linux

Disable The Iptables Firewall

--> chkconfig iptables off

/etc/selinux/config

--> SELINUX=disabled
SELINUXTYPE=targeted

reboot (init 6)
varsha
2012-10-18 11:07:31
sqlplus /nolog
conn sys as sysdba
ALTER USER USER_NAME ACCOUNT UNLOCK


Andrew Reid
2012-10-16 21:12:12
Here is a simple worked example:

http://international-dba.blogspot.co.uk/2012/10/ora-02382.html
Nt
2012-09-13 18:36:17
Thanks a lot, it helped

I had declared one of my parameters as IN parameter in body and not given IN in specification
Rgarza26
2012-09-05 22:43:04
Viva Nilofer !
Theo
2012-08-10 08:51:54
Very explanatory
Bala Venkata sai
2012-08-07 17:43:29
Great Help Nilofer.. Thanks you very much....
now its working !!
but how to make it permenent..?
and how to connect in command prompt..?
bill
2012-07-04 01:51:43
thanks!
Jonathan Camilleri
2012-06-17 18:02:48
I am trying to create an administrative password with the following masks, amongst others, however, I still get the same error, and, cannot proceed:
anaa$aaaa (9 chars including $)
Anaa$aaaannnn

A means A-Z
a means a-z
n means 0-9
$ is the literal

Any ideas?
Aniruddh Tiwari
2012-05-23 14:52:29
add one more to the list.

PARALLEL_ENABLED.

Spec did not had this but body did.
Like this
FUNCTION Find_dirty_word
(
i_source_field IN VARCHAR2
)
RETURN VARCHAR2
PARALLEL_ENABLED
AS

Once i take it off it executes successfully. Hope this will help someone.
alf
2012-05-17 08:43:17
great!
vinod
2012-05-16 08:10:15
Thanx, nilofer it worked
yoeiottr
2012-05-08 22:48:20
Hello! gcabdea interesting gcabdea site! I'm really like it! Very, very gcabdea good!
QUEENY
2012-04-05 07:26:20
Oh my God.. yes it really saved my time.. :)
oc
2012-04-04 13:44:06
Note that if you're passing defining an OUT (or IN OUT) parameter, then your java type must be an array i.e. have [] after it.

I.e.

PROCEDURE hello(
o_errorcode OUT NUMBER,
)
AS
LANGUAGE JAVA NAME 'com.EntryPoint.method(
java.lang.Long )';

Throws this error.
The java.long.Long should be java.lang.Long[]

i.e.
PROCEDURE hello(
o_errorcode OUT NUMBER,
)
AS
LANGUAGE JAVA NAME 'com.EntryPoint.method(
java.lang.Long[] )';
Captain Obvious
2012-03-23 23:41:36
Thank you.
Oz
2012-03-21 15:34:05
Test
sunic
2012-01-27 08:52:45
thaaakkkssss to nilofer..

it's work for mee.. :)

iwopyeyt
2012-01-20 09:38:49
Hello! eegbabd interesting eegbabd site! I'm really like it! Very, very eegbabd good!
amir
2012-01-17 11:32:47
reuse_dumpfiles=y
Alex
2012-01-11 16:31:20
But if you need that location ?
CjcarrilloG
2012-01-09 18:47:12
solucion a IMP-00013: only a DBA can import a file exported by another DBA

a mi me funciono dandole estos privilegios:

SQL>GRANT AQ_ADMINISTRATOR_ROLE TO ROYAL WITH ADMIN OPTION;
SQL>GRANT MGMT_USER TO ROYAL;
SQL>GRANT DBA TO ROYAL WITH ADMIN OPTION;
SQL>ALTER USER ROYAL DEFAULT ROLE ALL;

Si no te convence darle estos privilegios a tu usuario, despues de acabada la importación se los puedes quitar.

saludos.
Deepak
2012-01-09 11:12:13
Nice tip...
Thank you
santosh
2012-01-08 03:13:12
can anybody tell me how to resolve this problem... pls...
scavenger
2012-01-03 10:18:57
FALSE

you got to create a pfile from the spfile, then edit the pfile, then restart the database with startup pfile='...' then create spfile from pfile, then restart again normally
serach it
2011-12-22 05:43:21
If you have the solution then plzz., post it...
Marco
2011-12-21 17:18:23
Thanks!!!!!
RK
2011-12-16 12:11:35
I m wondering it is working very good for me too.Very simple steps to follow and before this i tried more but no luck.Not i m good and my DB opened.But i cannt able to see my tables which was in dropped TS.

SQL> select count(*) from test_new;
select count(*) from test_new
*
ERROR at line 1:
ORA-00376: file 4 cannot be read at this time
ORA-01111: name for data file 4 is unknown - rename to correct file
ORA-01110: data file 4:
'C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\MISSING00004'

looking Help here.

Thanks
RK

Raju
2011-12-01 15:19:57
Just Look into the below points
1)Name of procedure;
2)Number of parameters;
3)Name of parameters;
4)Type of parameters;
5)Order of parameters


krusnik
2011-11-29 14:45:35
oh sorry the error code is :ORA-01033 ORACLE initialization or shutdown in progress
krusnik
2011-11-29 14:41:25
I had the same problem too but solved it by doing this
In the past I've had many problems uninstalling all Oracle products from Windows systems. Here's my last resort method:

Uninstall all Oracle components using the Oracle Universal Installer (OUI).
Run regedit.exe and delete the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE key. This contains registry entires for all Oracle products.
Delete any references to Oracle services left behind in the following part of the registry:
HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Ora*
It should be pretty obvious which ones relate to Oracle.
Reboot your machine.
Delete the "C:\Oracle" directory, or whatever directory is your ORACLE_BASE.
Delete the "C:\Program Files\Oracle" directory.
Empty the contents of your "c:\temp" directory.
Empty your recycle bin.

At this point your machine will be as clean of Oracle components as it can be without a complete OS reinstall.

Remember, manually editing your registry can be very destructive and force an OS reinstall so only do it as a last resort.



BUT I HAVE ONE PROBLEM FOR WHICH I HAD TO REINSTALL N LOST ALL MY PROJECTS THE ERROR IS ORA-01300 : SHUTTING DOWN OR INSTALLING THAT ALSO WHEN MY PROJECT WAS ALMOST DONE ANY HELP PLZ SUGGEST
OPraveen
2011-11-17 18:19:58
Merge don't like any functions being used those are deterministic. Look at any functions used in the query and function definition. If the function as "deterministic", it don't like it.
prathap
2011-11-17 10:31:08
i didnt get any clear cut idea on this error.can you please explain brefly....
elkhodairy
2011-11-15 14:39:07
many thanks, it works with me now
Frank
2011-11-10 17:51:11
hello,
thank you for the steps but i get stuck on the recovery opening bit i get this error below
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\SYSTEM01.DBF'

i have tried to recover the file from old backups but it still gives me that error

please help, will be greatfull
Pratap
2011-10-15 05:23:21
do check the order in which the parameters are defined in spec and body.
my order of the parameters were different and so i was getting this error.
Tim
2011-10-14 21:26:16
I've recently encountered this error with ODP.NET. I blogged about it here http://timscyclingblog.wordpress.com/2011/10/14/oracle-odp-net-is-the-devil/ I hope this might be of use to you.
Tim
2011-10-14 21:23:37
I've recently encountered this error with ODP.NET. I blogged about it here http://timscyclingblog.wordpress.com/2011/10/14/oracle-odp-net-is-the-devil/ I hope this might be of use to you.
Threepwood
2011-10-14 13:40:21
Edit your sqlnet.ora and add/modify the following line :

tnsping.trace_level = admin

You may get the following error when re-executing tnsping :

...
NL-00511: error opening trace file <OracleHome>\network\trace\tnsping.trc
NL-00508 cannot open trace file
...

Just create the missing directory and the trace file will be available.
ranjan
2011-09-28 11:20:20
not enough data
Orauser
2011-09-27 10:49:43
This is not of any use - I can find this code and its oracle description everywhere, I was expecting to see more information about how to resolve this problem.
error-free
2011-09-20 06:38:56
Thanks, this helps. :-)
Anonimous
2011-09-20 06:16:32
El problema que tienes cove es que las ip´s virtuales tienen que estar abajo, ya que van a ser las que arranque el servicio.
Dave
2011-09-15 08:34:46
Check you don't have an order by on your select
Chandra Manandhar
2011-09-15 03:03:09
Good tips.
Obendan
2011-09-03 12:43:41
Hey guys this should work. Just follow these steps
1. Go to start and type sqlplus
2. Right click on sqlplus and click on "Run as administrator"
CHEERS TO YOU ALL
Arun
2011-08-27 16:31:44
Thanks a lot. The same issue was resolved for me too. :-)))
Ella
2011-08-17 13:39:18
It works great. Thanks
gundsambuu
2011-08-17 00:54:37
[INS-35075] The specified SID is already in use

I catch this error when installing an oracle.
What I do.
please HELP me
jeevan
2011-08-16 17:37:35
Please mention the examples,so that people will understand better....
JJJJ
2011-08-03 23:07:54
Que idiotas lo que pusieron no ayuda en ni ma...s
Santhosh
2011-08-02 22:14:29
Thanks You explained clearly it worked!
Setty
2011-07-25 11:24:20
Thanks.. Great Help.

There was a spelling mistake
Sudeep Shakya
2011-07-25 10:10:49
i try to connect oracle 11g using jDeveloper but unfortunately
the error is time zone problem
can i get some help
pagal
2011-07-25 08:36:43
VEry very funny...hahahah
v dint kno tht...
marc anthony
2011-07-19 07:10:41
thank u for your help.
ı solved my problem thanks to your site.
Kodero
2011-07-14 09:46:24
Worked for me too on Ubuntu 10.04 server editionn....
billy
2011-06-30 13:16:45
how
Poornima
2011-06-23 05:51:45
THANk you very much
Renan Malke Stigliani
2011-06-13 13:10:38
Just got this error using EXTRACT(SECOND FROM (date1 - date2)), where date1 and date2 were both date, changing it to timestamp solved the problem.
krishb4u
2011-06-09 05:23:07
This is due to oracle client version problem

Upgrade the client to 9.2.0.8 or above

or don't user direct load

metedor
2011-06-06 10:46:10
vaya mierda sitio
Nahum
2011-06-02 22:34:52
Gracias ho gran Maestro ....

has ayudado a un buen número de princiapiantes en database

eres un Genio y un Sabio !

Mil gracias por tu sabuduría !!!!
ankur
2011-05-24 06:59:48
hi nilofer ,

i am also facing the same problem and has administrator rights too
what is the solution for this
thanks
shanmugam
2011-05-23 09:29:01
Thanks .. this one resolved my issue.
Craig
2011-05-06 12:29:32
Possible action: Check your local / global environment variables for ORACLE_HOME directory, maybe there is the wrong directory set.
Chol
2011-05-05 13:39:30
¿Qué pá, qué estáis de cachondeo?
Jose
2011-05-02 18:56:55
Gracias desde Colombia me ayudo a resolver mi problema
santha
2011-04-27 19:02:11
PLS-00306 wrong number or type of arguments in call to procedure_name.
GIRISH
2011-04-27 11:01:51
thanks a lot...i got the solution
Jim
2011-04-26 15:51:31
Stupid answer. What is NEXT TIME
Ajith
2011-04-23 08:58:42
Appreciate this great blog. It worked for me too.
dafna
2011-04-21 07:56:58
thanks alot.

i have been stack this past few days with this puzzling situation.
did not think it was a bug


Md Anoarul Islam
2011-04-11 04:55:13
Very good solution, it was looking for this last couple of days.

Thanks a lot....
-
2011-04-09 10:07:47
-
ghanem258
2011-03-31 19:43:09
run form not run error 18126
21312412
2011-03-27 20:31:09
STU;ebqgesbjabg
Irfan Khan
2011-03-27 08:43:03

Cause: If you enable automatic SGA Management by setting SGA_Target >0 and
if you are using db_block_buffers(Obsolete parameter) in your init.ora.
Startup of Database fails with ORA-00824 Error

solution uncomment the db_block_buffers parameter in init.ora file
Payal
2011-03-17 20:15:54
It so much to the point, thanks for posting. It helped me at the 11th hour. :)
Firas
2011-03-17 16:29:44
start oracle enterprise manager
expand schema
go to ur schema
click on tables
right click on the table and click view/edit
go to storage tab
under space usage
change the values
percentage free 20
percentage used 40
Formido
2011-03-14 16:44:27
I ran into this error when I ommited to 'escape' the quotes and breckets on the unix prompt.

exclude=TABLE:"in ('table_name')"

should be:

exclude=TABLE:\"in \(\'table_name\'\)\"
Winning
2011-03-11 15:06:32
WOW, changing "Can" to "Do" (ignoring the typo) in the error message to the action is incredibly helpful. I was stumped on this issue, but not anymore.
Christoph Kradolfer
2011-03-10 05:27:18
Recommended action: very clever!
Joe Bloe
2011-03-07 23:18:50
What a lame-o non answer.
Ezhilan K
2011-03-06 06:50:14
Thank you. It is working now..
naeem
2011-03-05 18:49:10
useless description. we need solution
ChriDDel
2011-03-02 12:22:12
On partitioned tables use this

alter table TableName
move partition PartitionName
nocompress;

alter table TableName nocompress;
srini
2011-02-24 22:10:38
Thanks saratchandrag,

Its working fine!!!
Thanks a lot.
mary
2011-02-23 06:58:40
correct the error
Kunjal
2011-02-22 10:41:22
How to create tablespace where database is in MOUNT mode. As its giving error of SMON, database will not remain open and no tablespace operations permitted in MOUNT.
kumar
2011-02-18 05:03:07
if you cant answer close this BS!!!!!
Jeferson Kasper
2011-02-15 14:00:10
When the table have a numeric (like integer) field, you can cast by using to_char() to avoid problems. In some databases, developers use large "string" fields to store numeric values, and when you need to read these values and to some calcs, the api´s will raise overflow excepetions, in my case, i where using delphi 6 with oracle 11g and zeos 6.6.1

select idproduct, barCode from product;

Do:
select to_char(idproduto), to_char(barCode) from product;
vids
2011-02-14 15:43:28
Hey mine was mis-spelt too. thanks for the help.
PurpleLight
2011-02-03 12:33:06
@Abdul Malik - You need to put commas between the columns you select after the FROM clause.

@manikandan - You need to enclose the part after add in parenthesis
alter table department add
(
foreign key department (dept_id)
references
employee (dept_id)
);

This error shows up when you don't use parentheses and commas properly.
PurpleLight
2011-02-03 12:24:25
Its a very simple fix.
The error appears when VARCHAR2 isn't given a length. Specify a length and the error will be solved.
JAMES
2011-02-03 08:45:48
STUPID... RESULT
tom
2011-01-31 19:46:14
that a stuff answer i ever read.
manjujain
2011-01-29 11:27:32
after editing also am not getting the answer
Marcelo
2011-01-20 14:07:34
the problem is there again an again. It doesnt work that solution.
Lion
2011-01-20 12:36:34
Good One Sir...
adanat
2011-01-20 09:54:52
this was amaizingly dumb
Dara Fann
2011-01-19 21:30:42
or...
SELECT * FROM all_tab_privs;

then login as the grantor and revoke

or..have the grantor login

Admin
2011-01-19 14:38:25
The following sh(1) script can be used to setup password-less ssh.

#!/bin/sh
# go into .ssh directory in home directory of user that wants to run command
cd ~/.ssh
# generate a pair of RSA keys (if they don't already exist)
test -f id_rsa || ssh-keygen -t rsa -f id_rsa
# append the public half to authorized_keys file for this user on other server
cat id_rsa.pub | ssh "$@" 'cat >> .ssh/authorized_keys; chmod 644 .ssh/authorized_keys'

Example usage:

Login in as the user who needs password-less access, and login to the account trying to be accessed. At the command prompt:

oracle$ sshnopw oracle@otherserver

When prompted for a pass phrase it is important to just hit return (leave it blank) otherwise a pass phrase will still be required to connect. Also accept the host key.

From now on, when logged in as oracle, ssh oracle@otherserver should not prompt for a password.
Anthony
2011-01-18 08:36:46
What if the day of the week is simply not of the correct language?
For instance, my PLSQL stored procedure use a literral "MONDAY" but my language is set in french.
I tried to modify nls_language and nls_date_language but seems to have no effect.

Any idea?
Hisham ORA
2011-01-17 13:16:13
thank you for info
Mukesh
2011-01-11 11:12:35
Just choose different installation path and give it a shot..
ABC
2010-12-28 11:05:26
I know as much. wats the point . HAve a solution ????
Admin
2010-12-14 09:26:10
You need to look at any other errors around this one to determine the cause.
LazyPLSQLDvlpr
2010-12-13 16:19:22
Thank you guys for making my debug easy. I needed these suggestions.
Ngoc Thanh
2010-12-07 07:05:09
Your file can be incorrupt. you should be check export's file. file can be incorrupt via transfer by ftp
Richard Peter
2010-12-06 19:27:35
Wow...That was the "best" solution to a problem human beings have seen in eons.
THANKS FOR NOTHING!
quoc an tran
2010-12-01 11:48:13
INS-20803
SKumar
2010-11-25 17:50:05
Great tips. This solve the problem.
Thanks.
Jamil Ahsan
2010-11-23 21:37:05
A great post. here is some more detail:

1. alter database backup controlfile to trace noresetlogs;
2. shutdowm immediate
3. startup nomount;
4. create control file from trace file which we created in step one. To do so go to /udump directory and using vi editor open most latest trace log...Copy control file info from Startup mount till what oracle locale is used. then create an empty file using touch controlfile.sql file and paste copied data from trace file. Now we have a controlfile in text format created from trace file
5. rename all original control files to something.
6. startup mount
7. @path to controlfile.sql (ignore if says ORA-01081: cannot start already-running ORACLE - shut it down first) at the end it should say file created successfully.
8. recover database
9. alter database open (Thats it...it should open successfully)
10. To make sure all is good....shutdown immediate
11. startup
111
2010-11-23 16:51:13
I AGREE
raoule
2010-11-16 22:21:23
thanks a lot !
I love you (kiss)
Epictetus
2010-11-09 13:18:02
Great post thanks - I could have spent hours trying to troubleshoot a spelling error if I hadnt checked here first!
Marcel
2010-11-08 16:31:28
Hello,

Solved my problem also.

Great Job.
Michael
2010-11-07 11:46:20
Oh thanks u had EXACTLY the same issue :)
Steve
2010-11-05 12:11:54
genius
syed umer
2010-11-03 09:39:09
asalam walaikum
JAHZAK ALLAH(THANKS ALOT)
Bejjanky Naresh
2010-10-28 23:56:24
Please suggest how to enable at database level, though we have changed the two parameters disk_asynch_io = true,
filesystemio_options = asynch.
Crap
2010-10-20 14:05:52
That os not a help, do not cut paste from somewhere on your website
muthu
2010-10-19 11:52:14
it is working. thank you.
Tony Sykes
2010-10-12 09:06:59
Not very meaningfull description.
What is meant by position?
What is meant by descripter?
Penny
2010-10-05 20:54:58
It's easy i was serching for this answer. Thanks =D
BlaFoo
2010-10-04 11:12:04
Was haben wir gelacht ...
James
2010-09-29 03:33:10
Extactly, why don't you try to provide some help
mani.S
2010-09-28 09:49:30
hey seshu, ,thank u,, its working now
prakash
2010-09-19 10:49:12
ur genious man....
Thaks a lot... !
Luanna
2010-09-17 21:58:53
I'm so glad I saw this post before exerting a lot of time trying to find the problem. It was the misspelling of a variable, so my trouble-shooting time was less than 5 minutes because of this post.
Oracle Starter
2010-09-15 21:25:04
This site is just a waste. If some one comes here just get away.
Joe Schmoe
2010-09-10 22:45:01
Wow, That was sooooo helpful. NOT
Anees
2010-09-07 15:41:35
user the following command

CREATE TABLE sales_composite (region_id NUMBER(5),region_name VARCHAR2(30),sales_amount NUMBER(10),
sales_date DATE)
PARTITION BY RANGE(sales_date)
SUBPARTITION BY HASH(region_id)
SUBPARTITIONS 4
(PARTITION q1 VALUES LESS THAN (TO_DATE('01/04/2007', 'DD/MM/YYYY')),
PARTITION q3 VALUES LESS THAN (TO_DATE('01/09/2007', 'DD/MM/YYYY')),
PARTITION q4 VALUES LESS THAN (TO_DATE('01/01/2007', 'DD/MM/YYYY'))
);
Robert
2010-09-06 15:49:09
This isn't very helpful, it should provide the correct syntax.
Shahzad
2010-09-03 21:04:20
"02/07/2008 15:50:09 by Rajesh
I had declared the fucntion in the body but was getting the error because my return type in spec was number and in the body was integer"
I encountered exactly same thing and fixed it after seeing your post and debugging for almost an hour.
vivek
2010-09-02 18:47:42
hi i am also following d same steps but this error occur
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

pls help me
Felipe
2010-09-01 11:33:41
Thanks

This solution worked for me!
tkeb
2010-08-26 22:30:51
Check out this link to find obsolete parameters. http://www.oraclekonsulent.dk/en/index.php?blog_id=114

To find deprecated parameters issue the following SQL: select name from v$parameter where isdeprecated = 'TRUE';

Then look in your pfile for a matching parameter.
parkour
2010-08-25 09:52:41
Thanks.
Gunjan
2010-08-25 07:48:32
Please provide an appropriate solution.
Dara Fann
2010-08-24 13:15:46
Oracle SQL has extensions for specialized features such as Oracle*Text and Oracle SQL has a "contains" clause for finding specific strings within an Oracle*Text index.



Oracle Text works with traditional data columns and also with XML, MS-Word docs and Adobe PDF files that are stored within Oracle. Oracle Text has several index types:



CTXCAT Indexes - A CTXCAT index is best for smaller text fragments that must be indexed along with other standard relational data (VARCHAR2).



WHERE CATSEARCH(text_column, 'ipod')> 0;


CONTEXT Indexes - The CONTEXT index type is used to index large amounts of text such as Word, PDF, XML, HTML or plain text documents.



WHERE CONTAINS(test_column, 'ipod', 1) > 0


CTXRULE Indexes - A CTXRULE index can be used to build document classification applications.



See my notes here on using Oracle Text indexes.


Using the CONTAINS clause


The Oracle documentation for the contains clause notes the basic syntax:



CONTAINS(
[schema.]column,
text_query VARCHAR2
[,label NUMBER])
RETURN NUMBER;

Oracle gives this example of invoking the SQL contains clause:

CREATE TABLE accumtbl
(id NUMBER, text VARCHAR2(4000) );

INSERT INTO accumtbl VALUES
( 1, 'the little dog played with the big dog
while the other dog ate the dog food');
INSERT INTO accumtbl values
(2, 'the cat played with the dog');

CREATE INDEX
accumtbl_idx ON accumtbl (text)
indextype is ctxsys.context;

PROMPT dog ACCUM cat

SELECT
SCORE(10)
FROM
accumtbl
WHERE
CONTAINS (text, 'dog ACCUM cat', 10) > 0;


The Oracle Text SQL Operator documentation notes:

"The following example searches for all documents in the in the text column that contain the word oracle. The score for each row is selected with the SCORE operator using a label of 1:

SELECT
SCORE(1),
title
from
newsindex
WHERE
CONTAINS(text, 'oracle', 1) > 0;


The CONTAINS operator must be followed by an expression such as > 0, which specifies that the score value calculated must be greater than zero for the row to be selected.

When the SCORE operator is called (for example, in a SELECT clause), the CONTAINS clause must reference the score label value as in the following example:

SELECT
SCORE(1),
title
from
newsindex
WHERE
CONTAINS(text, 'oracle', 1) > 0
ORDER BY
SCORE(1) DESC;


A Verma
2010-08-16 13:16:15
Nice help provided. Thanks
Andrew de Ridder
2010-08-16 04:01:23
Well thats very dry and witty, but not at all useful.
Lakshmi
2010-08-05 14:07:26
Thanks a lot!!
Tom
2010-08-04 22:26:28
Seriously? Why do you even bother putting such a page up?
Rui
2010-07-30 14:20:40
This is the only thing that worked for me on Oracle 10g:

ALTER TABLE <TABLE_NAME> Move Nocompress;
ALTER TABLE <TABLE_NAME> Drop Column <COLUMN_NAME>;
ALTER TABLE <TABLE_NAME> compress;
Sandeep
2010-07-27 19:38:59
Thanks It works. Had similar problem with PL SQL developer
shashanka
2010-07-26 07:14:50
f u c k o f f
Sye Agha
2010-07-23 11:28:07
how to get rid of this error while installing oracle 11g. Even i hve tried every type of password but still geting the same error. kinldy provide an example of this.
Binyam form addis ababa
2010-07-19 07:24:33
thank you very much. i got the solution for my problem
pat
2010-07-09 14:09:21
it did not work for me
Andy D.
2010-07-08 15:10:11
Let me know if you were able to solve this. I maybe able to help.

Thanks,
Andy D.
http://www.FranklinFaces.com
Andy D.
2010-07-08 15:09:37
Let me know if you were able to solve this. I maybe able to help.

Thanks,
Andy D.
http://www.FranklinFaces.com
Farookh Mohammed
2010-07-08 06:51:07
VVVVVVVVVVVVVVV. Thank's for this info.
Harsha
2010-06-29 15:00:53
Thanks a lot!!!
this worked for us...
Gabskh
2010-06-28 10:16:43
This error may occur in mknod imp if ther is no space at the destination of pipe
JC
2010-06-24 20:30:52
Wow. informative
seshu
2010-06-24 19:35:45
hi friends try this
SQL> startup mount force;
ORACLE instance started.

Total System Global Area 2097152000 bytes
Fixed Size 1268460 bytes
Variable Size 704644372 bytes
Database Buffers 1375731712 bytes
Redo Buffers 15507456 bytes
Database mounted.
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

SQL> alter database open;

Database altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 2097152000 bytes
Fixed Size 1268460 bytes
Variable Size 704644372 bytes
Database Buffers 1375731712 bytes
Redo Buffers 15507456 bytes
Database mounted.
SQL>
SQL>
SQL>
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

seshu
2010-06-24 18:49:24
i followed the action that specified but i am getting same error is there any other solution for this ?
Sandeep
2010-06-23 09:48:30
Thanks..for the suggestion
emeka
2010-06-22 13:31:48
create table staffs (
staff_id integer constraint staffs_uq unique key,
first_name varchar2(12),
last_name varchar2(12),
sex varchar2(3),
dob date,
mar_stat varchar2(8),
salary number,
job_id varchar2
);
pls wats wrong with this query
Roberto
2010-06-17 13:47:59
Esta usando Loop, cuidado talvez aja a necessidade de limpar o array a cada loop.
PIerro
2010-06-17 07:53:09
Looool actually they do jsut like any DBA. which are all communists !!! :) (just kidding, but that is exactly the kind of answer we get from our dba's !!!)
Jahldor
2010-06-13 21:02:34
Bilmasalarin chochogimga yozasanlami?
Yuriy
2010-06-10 12:09:23
It's not so bad. Our very expensive product sometimes provides a user by 'very informative' call stack.
Gediminas
2010-06-07 14:33:35
I have a problem too, but it's a bit different.

INSERT INTO PROJEKTAI (Nr, Pavadinimas, Svarba, Pradzia, Trukme)
VALUES (Projektai_Vykdytojai_Nr.NEXTVAL,'Studentu apskaita','Maza','01/01/2005', 12)
Error report:
SQL Error: ORA-01830: date format picture ends before converting entire input string
peter.s
2010-06-07 03:40:34
great tip this fixed my problem
/tmp has a .oracle dir also
Alex.Betin
2010-06-02 14:27:52
This link might help:
http://oracleappstechnology.blogspot.com/2009/02/lrm-00123-invalid-character-0-found-in.html
SFF
2010-05-31 15:24:04
THIS IS NOT PROPER SOLUTION
Datapumpman
2010-05-30 05:51:14
What kind of answer is that?
viswam
2010-05-27 05:10:51
how to solve the above problem
Chris
2010-05-25 15:43:50
My variable type was mentioned varchar in body instead of varchar2 which caused this problem. Thanks for your help.
Kase
2010-05-19 16:35:45
I got this exact error on my application after running a offline backup.

To resolve this we had to shutdown the application and then reboot the database server. When we brought back up the applicaiton the error cleared.
tom
2010-05-19 11:10:13
sys cant flash bak his tables?..
i can flash bak a dropped user table,bt once sys dropped any table it cant flashbak.
showin that file does not exists in recyclebin

o/p
SQL> flashback table aju to before drop;
flashback table aju to before drop
*
ERROR at line 1:
ORA-38305: object not in RECYCLE BIN
rita
2010-05-13 10:17:43
Thanks,It's really worked for me. great job.
Admin
2010-05-08 12:58:22
Use the More Info >> link to find out More Info
Sri
2010-05-07 16:56:18
Idiot of Highest grade
Pablo
2010-05-05 18:51:25
I got ORA-01866 in Oracle Containers for J2EE 10g (10.1.3.4.0) in production environmente

but when I am Using ADF in JDeveloper 10.1.3.4 I don't get this error in Development Environment

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
mike
2010-05-05 13:34:39
very helpful; I never would have guessed
V
2010-05-05 10:01:55
What about wrong charset?
Joumdanisatioo
2010-05-04 19:11:06
Thanks, Would you please tell me the steps I have to do to solve this problem, I'm using Windows 7
mona
2010-04-30 21:47:56
thanks omar ,its work
tmv
2010-04-28 21:04:42
Increasing orastack oracle.exe from 500k to 1mg resolved our channel errors.
User
2010-04-28 16:07:08
Big help
NewBie
2010-04-28 09:17:44
Please, for concrete example.
My
2010-04-27 19:14:49
Agreed! What is the point of wasting disk space storing a page this anyway?
ankit sharma
2010-04-23 04:50:32
please give solid and correct answer
Khan
2010-04-17 20:23:21
ya, Ravi told u very right.
who doesnt know how much days in a month. give proper solution.
nobody
2010-04-13 14:52:37
I've got a solution for this:
Implement the feature!
nobody
2010-04-13 14:51:42
very useful information!
Vaibhav
2010-04-09 14:16:21
You are using a variable which is not null terminated ('\0'). Check your code, if you are using strcpy then before that you have to null terminate the string which you want to copy.
Dhanya Sreekanth
2010-04-08 05:12:31
So many times I got this error and I got confused how yo solve it.Thank you soooo much for the help
Oz
2010-04-03 13:04:32
Try http://www.dbasupport.com/forums/showthread.php?t=45995
Ranjay
2010-03-26 15:58:36
Thanks alot.

This is the best solution you have given.

You are great.

Thanks
Magnus
2010-03-24 14:48:30
Thanks for the BULK COLLECT INTO tips; it solved my problem.
Joe
2010-03-11 15:43:26
Great help. One of my parameters was spelled differently in the header. I changed it and the package compiled.
Abhi
2010-03-11 09:27:01
Is this any kind of joke ?
Ion
2010-02-28 17:01:21
Simply awesome , after googling for more than 2 hours this solution fixed my issue ....
THANKS A ZILLION !!!!!!!
Oz
2010-02-24 22:07:33
lsnrctl is the program found in $ORACLE_HOME/bin that is used to control (start/stop etc) the oracle listener.
Right Said Fred
2010-02-23 19:36:32
I'd like to know what LSNRCTL means.
vikas
2010-02-23 04:22:56
stop listener
delete /tmp/.oracle
restart listener
huichobeto
2010-02-16 17:44:51
No es necesario que coloques esos errores, si yo quisiera la descripción checo el alert, o los trace....
seria mejor poner la solución
None
2010-02-12 21:19:45
worthless information...
Jamie Ibrio
2010-02-12 15:45:22
Your explanation is a statement of the error, not an explanation of it.
krishna kumar
2010-02-11 11:14:54
Hi friend this web site really help me to solve my related problem.
SWAMY CHINNAM
2010-02-11 08:05:44
ALTER TABLE TABLE_NAME RENAME COLUMN OLD_NAME TO NEW_NAME; I GAVE THIS QUERY BUT IT GAGE ERROR,WHAT DID DO THE MISTAKE.
Chandra Kishore Kovuru
2010-02-10 10:03:28
When I faced this problem, I checked for all procedures status in user_objects, to my surprise I found two packages with the same name one in valid state and another in invalid state. When I dropped the package both of them got dropped and later created the package the problem was resolved.
fantasticvibs
2010-02-10 09:05:01
Thx a ton Nilofer... worked for me too... was about to reinstall oracle.
Derek Asamoah
2010-02-09 17:58:31
Another suggestion is to check parameters and return types in the body to confirm they match the declaration.
YO
2010-02-09 17:43:01
Poner solucion, gracias
Fabio Gemesio
2010-02-09 10:10:09
Add the called function in the specification...
Satish
2010-02-09 04:14:27
Thanks again Nilofar, it worked for me too. I have Windows 7
Vijay
2010-02-08 06:44:08
Thanks, it worked..
Shlooks
2010-02-07 16:26:33
USER_A : SOME_TABLE
USER_B : SOME VIEW AS SELECT * FROM USER_A.SOME_TABLE
USER_C : Should select from USER_B.SOME_VIEW

Because USER_C needs to read from USER_A, the "middle" user, USER_B must granted with "grant option" as:
GRANT SELECT ON USER_A.SOME_TABLE to USER_B WITH GRANT OPTION;
Manu
2010-02-06 23:14:31
Yes, this solution is useless, even the same error appears if you login again and run catproc.sql
ovey
2010-02-06 02:01:10
Nice post... You are a DBA master... :)
Ben
2010-02-06 01:50:26
I need help I'm a new DBA can anybody tell me how to create a controlfile from a trace file
avinash
2010-02-05 06:21:38
create table avi
(
myname char(10) NOT NULL,
myroll integer NOT NULL, primary key,
myclass integer DEFAULT = '12',
);
error is ORA-00906: missing left parenthesis
how do i rectify it.??????/
plz help me
pooja wankhede
2010-02-04 09:02:00

please tell me the solution for this type of error
Mike
2010-01-26 07:58:31
The problem is; 'Smith' isn't a dba and shouldn't be allowed anywhere near an Oracle database under any circumstances, especially not for money.
aakanksha
2010-01-24 06:50:23
Can you please tell how to recover forom this error,??
Raj
2010-01-20 15:54:52
Can you please provide more details on this
Varun
2010-01-20 02:13:43
Great Help Nilofer.. Thanks.. It worked !!
Bibi
2010-01-18 16:35:56
I confirms, it helps me soooo much !!!
rac setup
2010-01-15 00:27:25
This error sucks.
edward
2010-01-14 00:26:39
I pecified datafile. On script created by enterprise manager console. and I get this error.
what
2010-01-13 17:26:19
What's and interval type?
Nilofer
2010-01-13 12:33:48
Check if the user running the command has Administrative access. If running on Vista, select the .exe and use "Run as Administrator" option
Wayne Champlin
2010-01-11 19:57:45
I found that a user had tried to start the listener (and the database) as an unauthorized user. I went to /var/tmp/.oracle and made sure that that directory was owned by oracle:dba and so were all the files in that directory. What I found were files owned by that user who had attempted to start the listener.
Ahmed Samir
2010-01-05 20:07:04
very nice
nabin
2009-12-28 21:33:39
plz someone comment on the issue, i have exact same problem.
Pyfsmsmn
2009-12-25 10:07:54
It's serious
dheeraj
2009-12-22 15:09:21
Hi can you please let me know the syntax for the 4th command "create controlfile from trace file". Thanks in advance.
philippeko
2009-12-15 11:58:32
change the name of your table or another object of your DB.

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2170326695312#14061139459426
Developer too
2009-12-11 15:43:39
Youre right man, this is one of the most stupid error messages i ever saw. But thanks for the oracle solution "you should avoid this operation" - even better than the error itself.
skl
2009-12-10 17:59:33
cool
aakanksha
2009-12-09 10:21:33
can u plz provide more information on how to rectify this error instead of waiting for synchronisation
Useless
2009-12-06 20:10:58
The action to be performed is quite vague!!
Some One
2009-11-26 14:25:44
There is an article on the Oracle website "How to pass LOBs as parameters from Java to a Database Stored Procedure" which says we can pass larger params than 32K but actually I could not get it to work... I also used the "SetBigStringTryClob" connection param method. Does not work either.
ncarco
2009-11-12 09:38:00
This error can be experienced when trying to store select into results into varray. Try doing a select with bulk collect into instead.
Ram Gupta
2009-10-29 14:29:46
Hi I m getting this kind of error. How i resolve this
Nagaraj
2009-10-23 06:31:48
Hi Guys
I have used below command for copying the table from other than default space;
SQL> copy from TST03 to TST03Temp tablespace PSAPPD1NEW;
Enter FROM password:
SP2-0519: FROM string missing Oracle Net @database specification
still it is not working.
BBB
2009-10-14 19:44:33
Good explanation.......
kanchan
2009-10-08 09:38:10
try this:
sql>alter database datafile 2 offline drop;
sql>alter database open;
Christine
2009-10-06 14:35:11
So simple and yet so perfect. THANK YOU SO MUCH!
vladimir mitreski
2009-10-06 14:24:52
Thank you very much for the tip, I'll never would have think of that :(
suresh kumar
2009-10-06 06:29:04
i have 38gb ram out of 13gb free and swap 20gb free outof 24gb. but still i m getting the same errors when i try to check the listener status

lsnrctl status hsPREFCNTR

LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 06-OCT-2009 02:26:12

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=hsPREFCNTR))
TNS-01114: LSNRCTL could not perform local OS authentication with the listener
TNS-01115: OS error 22 creating shared memory segment of 129 bytes with key 3933386278
akeel101@hotmail.com
2009-09-28 08:41:05
Rama is a DBA in a banking firm. She administers an Oracle 9i R2 database on a Windows Server. She stores all the user data in the USERS tablespace, index data in the INDEXES tablespace, and undo data in the UNDOTBS tablespace. In addition, she has other tablespaces to store data for various banking applications. Since the database operates 24*7, she has an automated procedure to take online backups every night. In addition, she takes an export once a month of all the important tables in the database.
On Monday morning, due to a media failure, all the data files that belong to the tablespace UNDOTBS was lost. It was the beginning of the week and a lot of applications needed to be run against the database, so she decided to do an online recovery. Once she took the datafile offline and opened the database, she tried to select from a user table and got the following error:
ORA-00376 : file 2 cannot be read at this time
(File 2 happens to be one of the datafiles that belong to the tablespace UNDOTBS)
How would you perform a recovery ? write down the required instructions
akeel101@hotmail.com
2009-09-28 08:35:54
II.1. One afternoon a disk crashed, losing the SYSTEM tablespace residing on the disk. As this happened at the peak processing time, Smith had to keep the down time to a minimum and open the database as soon as possible. He wanted to start the database first and then restore the datafile that was lost, so he took the SYSTEM data file offline. When he tried to open the database he got the following error:
ORA-01147 : SYSTEM tablespace file 1 is offline
Write down the steps you would perform to recover your database
dennis.meinert@jpmchase.com
2009-09-22 17:15:34
I had a TNSNAMES entry that worked followed by another that didn't. The working entry started in column 1 and the following entry started in column 3. The TNSNAMES adapter concatenated the (correct) ADDRESS with the next ADDRESS and gagged. I moved the following entry from col 3 to col 1 and both work. TNS Ping Utility for 32-bit Windows: Version 10.1.0.4.2
K
2009-09-21 15:24:02
OR it exists in another schema and you need to grant execute permission on it
ion belciug
2009-09-18 09:03:54
what if not possible ?!
Fake
2009-09-17 18:15:39
What you meant with the step 4?
abdalla
2009-09-14 12:29:59
ERROR at line 1:
ORA-01465: invalid hex number
abdalla
2009-09-14 12:27:52
SQL> update personal_biomatric set PHOTO='C:/ab.jpg';
update personal_biomatric set PHOTO='C:/ab.jpg'
ahtesham
2009-09-13 10:33:45
thanks for the tip, it helped me solve my problem.
veasna
2009-09-07 07:12:43
alter systems set dispatchers = “(PRO=TCP)(DIS=4)(PRO=IPC)(DIS=3)”;
Gus @ Wipro
2009-09-02 17:58:41
You should check:

1)Name of parameters;
2)Type of parameters;
3)Order of parameters
prashant
2009-09-02 17:00:58
short and accurate solution.
ㅜㅜ
2009-09-01 10:25:35
ㅜㅜ
Munir
2009-08-26 03:52:29
My dear give the solution.
I think needs to execute some procedure. Where is procedure? rdbms/admin folder?
Ulh_K
2009-08-22 06:43:15
I have also faced similar error alongwith other error messages. The problem was there were two password files in DBS directory. It was resolved after removing one which was not required.
Rick
2009-08-20 19:00:35
And if it is the right user, then what?
Santosh Khandualo
2009-08-12 06:15:21
Run Below command
====
alter system set RESOURCE_LIMIT=true scope=both;
alter profile sesslimit limit sessions_per_user 100;
alter user sa profile sesslimit;
=====
Tony
2009-08-11 21:44:21
I lost half a day's work but thanks to this I don't have to lose a whole day's worth of data! This solution rocks!
Carol
2009-08-07 17:36:26
FIX: check that the parameter CURSOR_SHARING='EXACT'. Oracle will sometimes mis-interpret the field length on date format returns.
Jorbson
2009-08-06 23:34:04
TABLES=(
A linha nao pode ultrapassar 3490 caracters.)
Jorbson
2009-08-06 23:33:22
TABLES=(
A linha não pode ultrapassar 3490 caracters.)
Larry
2009-07-30 18:35:16
Can we be more vague with the solution?
shailender
2009-07-21 19:37:20
good
Dúh
2009-07-20 11:55:07
Oracle does have some stupid error codes but this one definately takes the cake!!!
Bryan Lajoie
2009-07-17 13:47:51
Perfect.

I appreciate this post.

Solved my issue, and I not understand the reason for the error.

-Bryan
adcosta
2009-07-17 13:28:00
If u r using pl/sql dev go to tools > Preferences
Debugger and uncheck add debug information when compiling
venkat
2009-07-16 07:17:25
not a straight solution.
Martijn
2009-07-15 10:14:26
Good stuff. I ran into the ORA-01113, ORA-01610 and the likes, but managed to save my database. You saved my day. Thanx.
JJ
2009-07-01 14:49:07
TIP:
Check /var/tmp/.oracle
Abdal-Malik Khan
2009-06-30 17:03:04
A quicky is to take the datafile offline and then recreate the datafile.
Ravi
2009-06-18 04:39:47
That we also know to give date beween ragne 1-31 or 1-30.given proper solution or keep quit.
Cameron
2009-06-15 02:20:14
Thank You! Your post solved my exact problem. I've been trying to solve this for 3 days. I appreciate your help.
Jörg Altegoer, Germany
2009-06-04 17:26:38
That's the solution - thanks to Titi Ala'ilima!
Craig
2009-06-04 12:53:17
This one stumped me for some time and I finally found that I was using the old column name in the ORDER BY field of the forms developer. This allows for compile, but fails on execution of query.
Cezar B.
2009-05-21 08:31:06
The solution that worked in my case:
-- execute this in the publisher schema
begin
dbms_cdc_publish.alter_change_set(
change_set_name => 'your_change_set_name',
enable_capture => 'Y') ;
end;
This is a bug in 11g
2009-04-29 20:30:44
Cause
The cause of this problem was identified and verified as unpublished Bug 6844512

The abstract of the bug being "11G DB SYSTEM PARAMETER LOG_ARCHIVE_DEST_N: QUOTA_SIZE PREVENTS DB MOUNT"

This bug is currently being worked upon by the development interface.


Solution
Monitor the referenced bug via metalink for a permanent fix as the development interface is currently working on the same.

Meanwhile consider implementing the steps mentioned below as a workaround until the fix for the referenced bug is made available :

a. SQL> create pfile from spfile;

b. Edit the pfile with log_archive_dest_n set without specifying the quota_size

c. Save the pfile

d. SQL> create spfile from pfile

e. SQL> startup

Marius Dreyer
2009-04-29 07:24:59
I've added <-Duser.timezone=UTC> as part of Java run option on project level and error went away.
Thanks!
Titi Ala'ilima
2009-04-14 15:48:17
If you have this problem with impdp, try adding "transform=OID:n" to your list of options.
RMAN-04005
2009-04-10 04:02:20
error from target database
ORA-00020
2009-04-10 04:01:34
maximum number of processes (%s) exceeded
Hmm
2009-04-09 15:13:52
Yes, seriously, this isn't that useful. I can see I have an illegal reference. I just don't know which it is. Telling me to remove it doesn't help when I don't know what to remove.
anupam
2009-03-27 14:43:03
date format picture ends before converting entire input string
Falco Tinunculus
2009-03-24 12:10:28
You may also solve ORA-31626 in the same manner, despite the fact that the message appears parametrically oposed.
Gerami
2009-03-17 07:08:44
Using Toad, I had defined a sort order on a VIEW based on a certain column in the database. Subsequently, that column was dropped and the VIEW script suitably modified to remove reference to the dropped column. However, I had forgotten to remove that column entry in the Filter/Sort option.

As a result, though the VIEW script compiled correctly, it gave a 'run time error' ORA-00904 while trying to display the data in the view.

(Wasted several hours trying to figure that one out!!!)
Kumar Thakkar
2009-03-05 19:11:02
you need to verify if in the given recordset the value of the column specified as first argument to SYS_CONNECT_BY_PATH there is already the same character specified as separator.

In other words, say you wrote something like:

SYS_CONNECT_BY_PATH(item_name,'\');

the function call will raise an exception if there is any record where item_name contains already a backslash character.
R.POPULAIRE
2009-03-04 09:23:24
You may trying to insert a value like '0000-01-01 00:00:00' in a date field of your table.
arshad ahmed
2009-03-02 04:54:05
hi

my problem from data export from *.dat file to oracle 10g database KUP-04021: field formatting error for field COUNTRY_CODE
Josué Monteiro Viana
2009-02-26 15:24:44
Hello,

Since you can not simply turn a column into a empty one (normally) I suggest you the following procedure:

1 - Add a temp column in the end of your table:
alter table your_table add (col_temp varchar(300))
2 – Copy the values of your official column to the new one:
update your_table set col_temp = TO_CHAR(your_official_column_name)
3 – Set your official column to null:
update your_table set your_official_column_name = NULL
4 – Adjust your official column with the usual alter table:
Alter table your_table modify your_official_column_name number(X,Y);
OBS: X,Y = Precision scale
5 – Copy the values back to the original column:
update your_table set your_official_column_name = TO_NUMBER(col_temp)
6 – Drop the temporary column:
alter table your_table drop column col_temp

Good lock :)
Josué Monteiro Viana

solution
2009-02-25 11:50:00
insert first values to this column before set it to not null!
Peter
2009-02-19 19:09:03
You have to be kidding me. WTF is that for an explanation!?!?
saratchandrag@gmail.com
2009-02-14 14:04:47
In the Project Properties-> Run/Debug , set the java options as -Duser.timezone=UTC for both the Model and UI project.
John
2009-01-31 10:55:28
It worked, in my case. Thanks
default
2009-01-29 02:03:34
default manager_id = 80;
Zorro
2009-01-28 13:14:38
W2K3 Server
I had a Statically configured server connection -which uses
C:\oracle\10g_AS_R2\forms\server\formsweb.cfg
The instance name reference was incorrect
otherparams=conn=instance_name
sss
2009-01-27 00:22:35
<connectionStrings>
<add name="TestDB" connectionString="server=subbu;uid=scott;password=tiger;" providerName="System.Data.OracleClient"/>
</connectionStrings>
sss
2009-01-26 20:59:36
Database db = DatabaseFactory.CreateDatabase("TestDB");
DbCommand cmd = db.GetStoredProcCommand("TEST.UPDATEEMP");
db.AddInParameter(cmd, "pnEmpid", DbType.Int32, textBox1.Text);
db.AddInParameter(cmd, "pnEMPName", DbType.String, textBox2.Text);

//DataSet ds = new DataSet();
//ds = db.ExecuteDataSet(cmd);

db.ExecuteNonQuery(cmd);

MessageBox.Show("Updated");
sss
2009-01-26 20:59:10
Database db = DatabaseFactory.CreateDatabase("TestDB");
DbCommand cmd = db.GetStoredProcCommand("TEST.DELETEEMP");
db.AddInParameter(cmd, "pnEmpid", DbType.Int32, textBox1.Text);

db.ExecuteNonQuery(cmd);

MessageBox.Show("Deleted");
sss
2009-01-26 20:58:15
using Microsoft.Practices.EnterpriseLibrary.Data;
Database db = DatabaseFactory.CreateDatabase("TestDB");
DbCommand cmd = db.GetStoredProcCommand("TEST.ADDEMP");
db.AddInParameter(cmd, "pnEmpid", DbType.Int32, textBox1.Text);
db.AddInParameter(cmd, "pnEMPName", DbType.String, textBox2.Text);
db.AddInParameter(cmd, "pdHireDate", DbType.Date, dateTimePicker1.Value);

db.ExecuteNonQuery(cmd);

MessageBox.Show("Inserted");
sss
2009-01-26 20:42:50
CREATE OR REPLACE PACKAGE TEST
AS

PROCEDURE ADDEMP(
pnEmpid IN NUMBER,
pnEMPName IN VARCHAR,
pdHireDate IN DATE
);

PROCEDURE DELETEEMP(
pnEmpid IN NUMBER
);

PROCEDURE UPDATEEMP(
pnEmpid IN NUMBER,
pnEMPName IN VARCHAR
);

END TEST;
/

sss
2009-01-26 20:05:09
CREATE OR REPLACE PACKAGE BODY TEST
AS

PROCEDURE ADDEMP(
pnEmpid IN NUMBER,
pnEMPName IN VARCHAR,
pdHireDate IN DATE
) AS
BEGIN
INSERT INTO EMP (EMPNO, ENAME, SAL, HIREDATE) VALUES (pnEmpid, pnEMPName, 2100, pdHireDate);
COMMIT;
END;

PROCEDURE DELETEEMP(
pnEmpid IN NUMBER
) AS
BEGIN
DELETE FROM EMP WHERE EMPNO = pnEmpid;
COMMIT;
END;

PROCEDURE UPDATEEMP(
pnEmpid IN NUMBER,
pnEMPName IN VARCHAR
) AS
BEGIN
UPDATE EMP SET ENAME = pnEMPName WHERE EMPNO = pnEmpid;
COMMIT;
END;

END TEST;
/
mamun
2009-01-24 18:13:40
what month between 1 and 12
hatim
2009-01-13 10:41:27
Errors in file /export/home/oracle/product/db/10.2.0.3/admin/crmbo/bdump/crmbo_s
mon_10051.trc:
ORA-00600: internal error code, arguments: [4097], [], [], [], [], [], [], []
Tue Jan 13 09:17:31 2009
Errors in file /export/home/oracle/product/db/10.2.0.3/admin/crmbo/bdump/crmbo_p
mon_10039.trc:
ORA-00474: SMON process terminated with error
Tue Jan 13 09:17:31 2009
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 10039
~
if u find this kind of error then

create undo tablespace 2
assign tablespace 2 to database
drop tablesapce 1 and again create tablesapce 1
then finally assign one to database.
then drop tablespace 2.

if wehis procedure folow this procedure there is no need to make changes in parameter file.
judichi
2009-01-07 23:09:57
Pinche error tan mamon neta que ORACLE son puras mamadas de software y toda la bola de pendejos que le suigen el cuento a la mercadotecnia de estos productos ... ORacle y sus pinches errores y parches y updates .. hay no mames .... mejor me dedico a otra cosa .. hevos a todos
suresh
2008-12-30 00:49:16
hi i could not able to export the schema
oduru@csgb.gov.tr
2008-12-25 10:30:36
i got ORA-01882: timezone region not found error
when i use ADF in JDeveloper 11g.
i didn't get this error when i didn't use ADF in JDeveloper 11g.
vk
2008-12-24 20:05:11
Thanks for this info. It helped me to avoid the warning while compiling my procedure
dhanasekar
2008-12-22 11:15:19
Thank you thats a valuable suggestiom
Sultan Mahmud
2008-12-20 09:48:18
No cennction between developers and Oracle DB
Some
2008-12-17 09:16:38
Worked right a way, great tip...
dba
2008-12-12 16:08:30
very good solution loved it
malsoor
2008-12-08 10:57:48
I have given the following query
alter table tablename change oldcolumnnname to newcolumnname; but it has given partition or subpartition keyword is missing
Error-Code
2008-12-03 17:36:27
This site sucks!... first and last time I search something here
Murugan
2008-12-03 07:05:25
How can i reproduce this issue
asdasf
2008-12-02 11:22:41
chetha vedava
shakil
2008-10-23 14:13:59
Dash u all. u dont knw the answer and saying see documentation.. no need to say this
Saravanan.
2008-10-18 22:23:24
What a nice explanation. It is very helpful.
sreeraj
2008-10-12 07:55:03
wat a bad description it is automatically comes with database tools
bryan
2008-10-09 21:33:11
Check to see if the restore you are asking for is from a previous incarnation. If so you must reset the database incarnation before doing the restore.
Shweta
2008-10-06 15:27:16
How could i increase varray size? should i need to declare another type?
Ray Wurlod
2008-09-29 02:34:35
It seems that this condition can reliably be generated by "successfully" loading 0 rows into the table using sqlldr (direct) in APPEND mode.
PJ
2008-09-25 11:14:33
Check firewall settings - open port 1521 (or whatever port you are using for the service)
konezero
2008-09-18 20:02:04
This was the most useless description....ever.
Lungy
2008-09-11 08:00:14
I got this error when tried to run "set ORACLE_SID=ESKOM" the reason I was running that command is that when I tried to run "connect /as sysdba" is got error ORA-12560.
aa
2008-09-10 15:39:49
Thank you !
Slinky
2008-09-09 16:52:31
AAAAARRRRRGGGGGGGGGHHHHHH!!!!
leo
2008-08-28 06:54:51
great steps....

been looking for this for ages, finally did it within 5 minutes...

had a problem understanding step 4. Actually it's just copy and paste what's inside the latest .trc file inside udump directory starting from CREATE CONTROLFILE ......

thanks so much for the guide, really helpful...
Tomik
2008-08-22 13:40:21
Check NLS_LANG in your connection. If it is not american/english it can cause such errors. Try the same with AMERICAN_AMERICA.WE8MSWIN1252 if you work on Win.
RaviKiran
2008-08-07 12:32:33
This information is ok, but some problem is ther if some one got the other problem in this what we can be down.
arc
2008-08-05 13:11:04
alter system set log_archive_dest='archlv/logs'
yrene
2008-08-05 12:42:11
en una actualizacion, considerar que los tipos de datos de las nuevas variales deben ser iguales a la de los campos que se desean actualizar
A mi daba este error justamente por eso
Benno
2008-08-05 12:17:57
Hey, this is of great help

You get an error message "this doesn't work" and
you suggest "make it work".

No explanation, no help nothing - bah
Bhaskar
2008-08-05 10:55:46
How to solve th problem
John Gentry
2008-08-03 17:46:25
Note that the behavior has changed as of Oracle 10g: http://escuelle.blogspot.com/2008/05/ora-22835.html.
Sunny
2008-07-29 20:22:25
Thank you very much. It took me some time to figure it out. It was a grant issue wasted so much time on this error. Anyways Thanks
jimbo
2008-07-25 22:02:13
It'd be nice if this "obsoleted" parameter were actually IN the Alert log. I'm guessing in 10g its the log_archive_start parameter. Any takers?
dschulenberg
2008-07-24 20:06:56
This procedure just saved our test instance :) Thanks
Roger
2008-07-21 16:35:03
That explanation is like a mechanic telling you "you can fix your knuter valve by taking the mchamistam and dropjawing it on the bearing muffler".
Harry
2008-07-18 06:49:17
Could also be a DNS hosts issue. sometimes a.host.in.here may resolve to multiple IP addresses in which case it becomes too long for oracle to handle.
David
2008-07-17 15:14:22
More info of this error in spanish here: http://www.orasite.com/errores/ORA-06502.html
suresh kumar
2008-07-17 11:22:26
add standby redolog file in your standby database you also check errors no redo standby database in alert log of physical standby database.
mandarbailur
2008-07-16 14:08:10
Increase undo_retention parameter value or set undo_retention as GUARANTEED. In this later case new transaction may fail at cost of retaining undo data.
Ellision
2008-07-11 11:49:44
Great solution , Your suggestion gave me big relief I just "corrected the error" and it worked he he he
Hal
2008-07-08 19:20:43
I am also getting that error because of a bad synonym point to a function in another set of tables. If the function is not seen, this error occurs.
Rajesh
2008-07-02 14:50:09
I had declared the fucntion in the body but was getting the error because my return type in spec was number and in the body was integer
Oguzhan
2008-07-01 13:55:53
I had the same runtime error from the following line:
:1 := sys_cmp.pkg_change.get_history( p_action => :2, 1 );
changed the line to the following and cleared the error:
:1 := sys_cmp.pkg_change.get_history( p_action => :2, p_nrows => 1 );
Kavish Jha
2008-07-01 06:03:11
So If u are using bulk bind,then u have to INSERT into the table as a whole. I can't be selective.
FORALL i IN 1..l_table.COUNT
INSERT INTO s
VALUES l_table(i);
But this will work on 11g.
In 11g, you should find that that FORALL implementation restriction has been lifted, i.e. you can reference the fields.
Colm
2008-06-27 15:16:54
This solution is completely useless.
Pablo
2008-06-24 13:52:01
Is must better, say an example witch sintaxis for enable row movement on the table
me
2008-06-23 14:20:13
thanks, I would not guess without your help...
DBA
2008-06-10 08:02:12
how do we allocate?
sorted
2008-06-05 08:52:59
ok so here is how I solved the issue. I was having this error only when running a backup archivelog all command.

When I read the oracle manual for the error it provided this information:

ORA-19715: invalid format string for generated name
Cause: A restricted format or undefined format was used incorrectly.
Action: Change the format specified in the additional information by removing the restricted format.

A bit more than what is here.

It turns out that oracle does not manage your backup files if you are using any of the format parameters because the backup is not then managed by oracle. And I guess (as I am no dba) that it needs to manage the archivelog backups.

If anyone is out there who can provide a better understanding then please do so.
annoying
2008-06-05 08:41:55
It pi$$es me off all these site requoting the manual but not adding any vaule.

So I have this error and cannot understand how to solve it!
Wifey Mc Beatey
2008-06-04 14:22:23
To avoid this error when adding a column is to add a column without a DEFAULT value (it can be done afterwards)
To avoid this error when dropping a column is to perform a SET UNUSED of the desired column "ALTER TABLE table SET UNUSED COLUMN column" and to follow with a "ALTER TABLE Table DROP UNUSED COLUMNS"
Hugo Matos
2008-06-02 19:00:20
I dont understand what you want to say.
can you give me one exemplo?
imp-00031
2008-05-30 08:58:25
plz give solution
Victor
2008-05-28 22:18:37
ORA-31202: DBMS_LDAP: Sizelimit exceeded

Este error viene provocado por una limitacion del Active Directory, ya que por defecto no puede devolver mas de un numero maximo de resultados en una consulta SEARCH.

Una posible solucion es recorrer mediante 2 bucles las letras del alfabeto y hacer consultas que empiecen por cada una de estas letras. En esta direccion podeis ver un ejemplo: http://hoterder.blogspot.com/2008/05/dbmsldap-obtener-todos-los-usuarios-del.html
ei03062@FEUP
2008-05-26 18:30:18
Check whether the subprogram specification in the package specification has all the subprogram parameters.
Jean-Yves
2008-05-22 12:54:06
Same error if the passwd file (orapwSID) not exist on the standby database.
Hemant Pande
2008-05-14 10:59:27
The one of the reason is archive destination is full so check and remove all the applied archivlog from the Standby.
jahanzeb khan
2008-05-13 23:23:08
when i use after database shutdown or startup sya than i use
jahanzeb khan
2008-05-13 23:21:54
this is the rite statement alter database set db_name
Faraz Bari
2008-05-13 11:22:07
whenever you update oracle version or migration you need to relink libobk file for this following command will work

ln -s /usr/lib/libobk64.a $ORACLE_HOME/lib/libobk.a
purushotham
2008-05-13 06:40:45
conn / as sysdba
Connected.
SQL> grant imp_full_database,exp_full_database to scott;
Ben
2008-05-06 15:13:07
Don't look only the spelling of the procedure name but also the spelling of all parameters.
diyarbakır
2008-05-03 19:19:53
mehmet,tatar
Ahmad
2008-04-30 13:26:49
thanks
bknox
2008-04-28 13:13:14
It worked. Thank you very much Aman!
VERONICA
2008-04-19 20:40:03
AMAN FELICITACIONES, GRACIAS A TU AYUDA PUDE RECUPERAR LA BASE DE DATOS.
debdeep
2008-04-14 10:20:17
One more cause is there, sometime if Listner Control(while trying to execute Listner Command after importing any new dump to your DBe.g.; lsnrctl start)is already running then this error can occur.
Ian
2008-04-08 12:37:45
I've just go this error and found that the problem was I was trying to recreate the control files for a 10g oracle database using 9i oracle software - something I'd overlooked!
wolk
2008-04-08 07:56:31
hove can I fix the problem ...?
Steve Ewing
2008-04-08 01:37:08
To FIND the parent table use
select table_name from all_tables
where iot_name = <name you were using>
senthil
2008-04-07 10:54:59
how to set device for current session. pls reply me
pandu
2008-03-31 22:31:07
u can get it back if u use drop command only, if u delete data using delete command u cannot flashback it.
Sameer Kulkarni
2008-03-28 14:51:54
Close any session in which you have connected to the database that has the dblink, reconnect and try
Alno
2008-03-28 13:34:55
Check if LD_LIBRARY_PATH contains $ORACLE_HOME/lib

The error message may happen even if LD_LIBRARY_PATH is correctly configured, though.
Sastry
2008-03-26 09:22:29
How?
subrat
2008-03-19 13:53:19
Hi,
If the data type is declared as ONLY NUMBER type for exp.
EmpNo NUMBER;
then what's the maximum size we can declare or how to overcome this problem.

Please advice me. Appreciate ur help.

Thanks,
Subrat
Sensbachtal
2008-03-17 18:01:55
Just wanted to say Hello to everyone.
Much to read and learn here, I'm sure I will enjoy !
AMZAD
2008-03-17 08:42:36
Add ORACLE comment for error code PLS-00905
Naveed Ali
2008-03-14 11:32:54
Thanks For Help I m having this error on my domain and i found it over here.. Thanks Again
Keith AM Adlam
2008-03-11 20:13:32
I have seen problems with views on spatial tables when the view is used by a schema other than the owning schema. The spatial index does not appear to be visible via the view. We are running 10g R2. Granting MERGE ANY VIEW priv to the schema using the view appears to correct the issue. I would like to find out more about this issue.
STudent
2008-03-11 16:12:01
ok thats a little obvious isn't it? a simpleton could of rearranged a sentance for me instead of telling me an answer
tinbergen
2008-03-05 17:08:36
sans blague ?
Andy
2008-03-05 09:48:55
there will be the restriction of the number of used set in the pfile/sfile .. as (RESTRICTION = TRUE).
Yogesh Tuwer
2008-03-04 07:29:16
Hello Sir
I will Import *.dmp File Which is coming From My client To solve then Problem i will mot understand how i will import it Please help Me
send me replay at tuwer2557@yahoo.com
Hüsnü ªensoy
2008-02-29 17:57:02
In case that you see this error during a datapump export/import, be sure that resource manager idle wait parameter on the current schedule is not too low.
YO
2008-02-27 19:53:12
Papanatas, que corcho es una Policy Function
SREENU
2008-02-27 07:22:28
IT IS NOT SUFFICIENT FOR PROBLEM IN IMP-00019
Freeman
2008-02-27 02:30:42
You make my day!
qwert
2008-02-26 15:29:31
because isqlplus requires enabled cookies...think, and then ask!
xy
2008-02-26 15:26:58
Note: This is NOT a support forum so please dont ask for help. Use the Search FAQ button on the previous page for further assistance.

btw, learn reading...
SULAIMAN
2008-02-23 08:51:52
PLEEASE HOW TO RECOMPILE THE LIBRARY UNIT..??
Baba
2008-02-23 06:05:34
This error occurs on a perticular node of oracle db setup on window2003 platform in RAC setup.
Errors in file d:\oracle\product\10.2.0\admin\edmsorac\bdump\instance2_lmd0_4504.trc:
ORA-27508: IPC error sending a message
ORA-27300: OS system dependent operation:IPCSOCK_Send failed with status: 10055
ORA-27301: OS failure message: An operation on a socket could not be performed because the system lacked suffi
ORA-27302: failure occurred at: send_3
brijesh
2008-02-22 06:59:37
when i rum isqlplus i have some problem SP2-0915: Cookies may have been disabled
why ?
Livedba
2008-02-17 14:44:11
check out the following to resolve this error

http://orcl-experts.info/index.php?name=FAQ&id_cat=5
bilal
2008-02-13 12:32:14
ORA-00906: missing left parenthesis im facing the error and i need solution.

thanks
Dba
2008-02-12 10:44:32
please give good sugestions
grc
2008-01-31 07:05:57
yup, just increase the varray size..
omar muhaisen
2008-01-25 18:15:50
check if the path of udump,cdump,udump as first step
Gouda
2008-01-24 18:52:34
Once this error occurs, even the subsequent INSERT statements into the table with column on which the text index exists, also FAILS !!!

The details of the error I am getting from Oracle is as follows:

OracleException ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate
ORA-20000: Oracle Text error:
DRG-10602: failed to queue DML change to column STREAMCONTENT for primary key AAAFB+AAAAAAAohAAG
DRG-50857: oracle error in drekqkd(execute k_stmt)
ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate
ORA-20000: Oracle Text error:
DRG-10602: failed to queue DML change to column STREAMCONTENT for pri
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 700
Robert
2008-01-17 22:49:03
c'est de la merde
ora-39008
2008-01-12 10:53:09
actully i make a dump file from the other database and now i want to imp it into another database
Dave
2008-01-11 10:21:48
I forgot to put the negative sign in front of the number so that's why I got this error.
aaa
2008-01-10 10:34:12
how view current user
rajeshcse45@gmail.com
2008-01-07 17:15:51
i need the solution for sp2-0110.i am using oracle 10.2 version in windows vista.i am waiting for your reply asap.thanks
wesam
2008-01-06 11:26:59
if i have database archivelog
alter database archivelog;
but after execute command print the Error
ORA-00265: instance recovery required, cannot set ARCHIVELOG
marlon
2008-01-06 02:28:04
Yo no se nada
Pratap
2008-01-03 13:16:09
I think some files are correpted
SYED
2007-12-30 11:15:43
Increase the varray limit
ADISWORKER
2007-12-19 14:32:33
This error can occur when you create a view and one of the tables that you use in the select query is not in your schema.
Glenn
2007-12-11 21:48:00
This is just a verbatim quote from Oracle's manual. Is is possible to add some value and explain things that the manual does not, like what could be wrong with the standby redo logs that would cause this error?
adam
2007-12-10 22:43:16
To use a clob in the ext table, you can explicitly set the length to char(50000):
CREATE TABLE test_EXT
(
col1 char(13)
,col2 clob
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY test_dir
ACCESS PARAMETERS
( records delimited by newline
DATE_CACHE 3000
load when (col1 != BLANK)
discardfile test_dir: 'test.dsc'
badfile test_dir:'test.bad'
logfile test_dir:'test.log'
fields terminated BY '~' OPTIONALLY ENCLOSED BY '"'
missing field VALUES are NULL
(
col1 char(13)
,col2 char(50000)
)
)
LOCATION (test_dir:'test.txt')
)
REJECT LIMIT UNLIMITED
NOPARALLEL
NOMONITORING;
baskaran.v
2007-12-07 12:39:52
Might be log directory is missing
Ameet Patel
2007-12-06 08:06:01
This error is generated at the time of startup,solution is just go and restart your Oracle service with the name =OracelService(DB_Name) this will restart ur database no need to start the database
Austin
2007-12-02 01:22:45
In my case the problem turned out to be that I was trying to use direct path which only works between similar versions of oracle. I need to use conventional path to resolve the issue. To do that I simply needed to remove the direct=true parameter from the sqlldr command line.
Austin
2007-11-30 14:30:50
I got this trying to use 8.1.5 sqlldr against a version 10g database.
NEHA
2007-11-28 11:28:40
TABLE HAS ALREADY GOT THAT VALUE,CHECK IN THE DATABASE.
Kevin Meade
2007-11-26 15:54:41
Related errors are ORA-01403 and ORA-06502.
Here is some code to demonstrate.

SQL> declare
2 type t_a is table of number index by binary_integer;
3 a_a t_a;
4 v1 number;
5 begin
6 v1 := a_a(2);
7 end;
8 /
declare
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 6

We attempted above to access an non-existent element in our associative array. This gives no_data_found error. Sometimes a bit of consternation for pl/sql newbies as this is not intuitive.

SQL> declare
2 type t_a is table of number index by binary_integer;
3 a_a t_a;
4 v1 number;
5 begin
6 v1 := a_a(null);
7 end;
8 /
declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at line 6

The error message is not very good, but the code shows what it means. We tried to lookup an element in our associative array, using a null value as the index. This is usually a coding error, or a insufficient understanding of the underlying data from whence index values are comming.
DP Agrawl
2007-11-21 12:57:22
ORA-29538: Java not installed
ORA-06512: at "index_search", line 1
ORA-06512: at line 1

i am facing this problem with my server.
can you please help....
I all ready installed java here.
ora
2007-11-20 18:56:59
greate page super help did not believe the error message was accurate
Mike
2007-11-19 18:41:04
Make sure after you have recreated any views, that the triggers get recreated also.
EWaz ALi Haidari
2007-11-18 10:09:40
Really helpful ..

helped me a alot ...

thanks
dahiri zakaria
2007-11-09 11:43:34
I have a Problem ORA-32103
if you can help me please
arvychile
2007-11-08 22:07:04
Now being serious...you should try this link;
http://forums.oracle.com/forums/thread.jspa?threadID=317043&tstart=60

It might help you
arvychile
2007-11-08 22:05:14
I'm surprised by the way you provide solutions men...

It's like the joke about Fidel Castro saying "In Cuba no one goes to bed without eating

A woman at the front row whispers "hey, pssst!!...Fidel...I haven't eat since last week"

Fidel: Don't go to bed then!!
dailv
2007-11-08 12:08:20
ds
boo
2007-11-02 02:36:13
worst solution ever.
santosh
2007-11-01 06:12:32
i'm also facing the same error though sorted out with all recommeded solutions. please guide, santosh.rk@gmail.com
AMEY PARKAR
2007-10-31 14:43:31
HELP ME WID DIS;
ERROR AT LINE 2 (ORA-02165)
Kailas Tile
2007-10-30 13:30:08
what a waste of time !!!
Manoranjan
2007-10-30 07:46:44
getting error while executing the script


CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE CACHED TABLE JENA_SYS_STMT(SUBJ VARCHAR(250) NOT NULL,PROP VARCHAR(250) NOT NULL,OBJ VARCHAR(250) NOT NULL,GRAPHID INTEGER)
CREATE INDEX JENA_IXSP ON JENA_SYS_STMT(SUBJ,PROP)
CREATE INDEX JENA_IXO ON JENA_SYS_STMT(OBJ)
CREATE CACHED TABLE JENA_LONG_LIT(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,HEAD VARCHAR(250) NOT NULL,CHKSUM BIGINT,TAIL VARCHAR)
CREATE UNIQUE INDEX JENA_IXLIT ON JENA_LONG_LIT(HEAD,CHKSUM)
CREATE CACHED TABLE JENA_LONG_URI(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,HEAD VARCHAR(250) NOT NULL,CHKSUM BIGINT,TAIL VARCHAR)
CREATE UNIQUE INDEX JENA_IXURI ON JENA_LONG_URI(HEAD,CHKSUM)
CREATE CACHED TABLE JENA_PREFIX(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,HEAD VARCHAR(250) NOT NULL,CHKSUM BIGINT,TAIL VARCHAR)
CREATE UNIQUE INDEX JENA_IXBND ON JENA_PREFIX(HEAD,CHKSUM)
CREATE CACHED TABLE JENA_GRAPH(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,NAME VARCHAR(1024))
CREATE CACHED TABLE JENA_G0T0_REIF(SUBJ VARCHAR(250),PROP VARCHAR(250),OBJ VARCHAR(250),GRAPHID INTEGER,STMT VARCHAR(250) NOT NULL,HASTYPE CHAR(1) NOT NULL)
CREATE UNIQUE INDEX JENA_G0T0_REIF_IXSTMT ON JENA_G0T0_REIF(STMT,HASTYPE)
CREATE INDEX JENA_G0T0_REIF_IXSP ON JENA_G0T0_REIF(SUBJ,PROP)
CREATE INDEX JENA_G0T0_REIF_IXO ON JENA_G0T0_REIF(OBJ)
CREATE CACHED TABLE JENA_G0T1_STMT(SUBJ VARCHAR(250) NOT NULL,PROP VARCHAR(250) NOT NULL,OBJ VARCHAR(250) NOT NULL,GRAPHID INTEGER)
CREATE INDEX JENA_G0T1_STMT_IXSP ON JENA_G0T1_STMT(SUBJ,PROP)
CREATE INDEX JENA_G0T1_STMT_IXO ON JENA_G0T1_STMT(OBJ)
SET TABLE JENA_SYS_STMT INDEX'3256 4648 3456 0'
SET TABLE JENA_GRAPH INDEX'9416 1'
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20
Developer
2007-10-26 06:41:57
Now that was helpful!!!!!! what duration? what operation? give me a break!!! what a shitty post!
Hari
2007-10-22 10:09:17
Check with SID is reflectin in any of the oracle directories or not pl.
shutdown immediate;
startup restrict
shutdown
Austin
2007-10-21 11:37:47
The following post on oracle forums describes how to correct this error:

http://forums.oracle.com/forums/thread.jspa?messageID=2146346
sam
2007-10-17 12:52:06
Excelent man!! Thank you
Neeraj
2007-10-17 10:32:27
how i use this select statement

select * from dharmesh where address2= '45"'" HP';

reply me on neeraj_khandelwal@rediffmail.com
another dba
2007-10-16 08:20:46
If you are using OWB i found this In metalink:

The information in this article applies to:
Oracle Warehouse Builder - Version: 9.2.0.2 to 9.2.0.3
This problem can occur on any platform.

Errors
ORA-30926

Symptoms
OWB mappings that MERGE dimension data intermittently fail with ORA-32906. Mappings fail over to row-based mode and then complete. Rerunning the mapping or running in another environment with same data works successfully.
Cause
The root cause may be that you have a target table without a constraint. You may have tables without constraints and as long as their match criteria results into a single row for each load action. In the event the match results into multiple target rows being selected, your error could occur. Even though we don't mandate a constraint on the target, target update and delete match conditions need to result into a single target row, or else you may hit:

- incorrect runtime auditing results (if he doesn't use MERGE)
- runtime error 30926 (if he does use MERGE)
Fix
2 possible workarounds:

Right click on your warehouse module and goto 'configure'.
Expand Generation Preferences and choose PL/SQL GenerationMode.
Change that from Oracle 9i to Oracle 8i.
(This is seperate from what you see in location properties.)
Run the mapping code in row-based-target-only this should generate update/insert instead of merge statements.

-or-

Remove the parallel hint that OWB sets as a default mapping property. .
Dba_pass
2007-10-16 08:16:10
I found this, can be help some budy:

When performing a merge statement, the table to be merged had multiple
records with the same key used for matching. While this is ok for
records to be inserted into the target table, Oracle doesn't like this
on the update portion of the statement. The solution is to remove the
duplicate or pick a matching key that is truely unique.
diosa
2007-10-14 22:45:26
no lo puedo instalar gracias
Besutitte
2007-10-08 10:21:54
hi,
good site :) Whish you good luck!
creadiofefori
2007-10-05 21:59:25
May be im a mourner may be i deserve to do something else.
Need to feel the sense.
Balaji
2007-10-05 11:01:50
Actually what do you mean by TYPE?
Could you please make me clear.
Georg
2007-10-05 06:10:48
Perfect solution from AMAN. We had an unusable CURRENT Redo-Log-File. This Redo-Log-File even blocked the system during automatic crash recovery.
RAMESH
2007-10-04 09:06:19
WITHOUT USING REFCURSOR HOW TO OUT THE RECORDS MORE THAN ONE COLUMN AND ROW.

I HAVE TRIED BUT IT THROWS AN ERROR
PLS-00382: expression is of wrong type..

BELOW IS THE PROGRAM..


CREATE OR REPLACE FUNCTION fast_func1 (p_array_size IN PLS_INTEGER )
RETURN VARCHAR2
IS

l_data_TAB R_TYPE_TAB;

CURSOR c IS
SELECT *
FROM w_comm_baskets;

BEGIN
SELECT CAST (MULTISET(SELECT *
FROM w_comm_baskets) AS R_TYPE_TAB)
INTO l_data_TAB
FROM DUAL;

RETURN L_data_TAB;

END fast_func1;

csnyiri@freesoft.hu
2007-10-01 13:27:23
ORA-12996: cannot drop system-generated virtual column
Austin
2007-09-30 18:51:19
It is telling you that there is an underlying HTTP error. You need to look at the HTTP error message and resolve that to resolve this error.
Gaurav Shah
2007-09-28 14:34:59
Have a look at this great Action

Action
Fix the HTTP client error and retry the HTTP request

Stupid!!!!!!!
Rajesh Kaul
2007-09-28 14:33:32
How the hell can you post such solutions?? We know that we need to fix the issue and try, we dont have to visit such crap sites as this.
bugsrurdY
2007-09-07 23:21:03
ORANJESTAD, Aruba - Felix rapidly strengthened into a dangerous Category 5 hurricane and churned through the Caribbean Sea on a path toward Central America, where forecasters said it could make landfall as “potentially catastrophic” storm.
Felix was packing winds of up to 165 mph as it headed west, according to the U.S. National Hurricane Center. It was projected to skirt Honduras’ coastline on Tuesday before slamming into Belize on Wednesday.
“As it stands, we’re still thinking that it will be a potentially catastrophic system in the early portions of this week, Tuesday evening, possibly affecting Honduras and then toward the coast of Belize,” said Dave Roberts, a hurricane specialist at the center in Miami.
Shree
2007-09-07 20:25:26
Thanks.
Marco
2007-09-05 16:02:06
Yes, but how to load correct mapping in order to be able to wqrinte into a Ms SqlServer image datatype ?
Djalma-www.teiko.com.br
2007-09-04 12:25:02
This error can this related the sintax of the nomenclature of the columns!
Consider that the command is it case sensitive!!!!
oracle error 30200
2007-09-04 06:20:00
error while data loading
Abdul Wahab
2007-09-04 06:11:42
I am followed the action command 'shutdown and startup mount again and also before i set the parameter in the init.ora also, but still getting the same error 'ORA - 00265, Instance Recovery Required, Cannot Set Archivelog
hi-techdoctor.com
2007-08-27 16:11:59
Hi,
just user resetlogs option and u wil be fine.
Jagadeesh
2007-08-23 16:24:10
Some times the number field when anchored with the table type may not work properly
example:
TYPE TYP_DIV_MILES_I IS TABLE OF CSTDIF.DIV_MILES_I%TYPE
This does not work
Change it to

TYPE TYP_DIV_MILES_I IS TABLE OF VARCHAR2(5)
INDEX BY BINARY_INTEGER;
Prajeeth
2007-08-21 18:19:04
this website tries to copy the contents of http://ora-14037.ora-code.com/
Make these error messages more understandable rather than re-inventing wheel.
Prajeeth
Juan Pérez
2007-08-20 21:30:32
Oiga no sean payasos, respondan con una solución.
rajesh
2007-08-09 13:37:05
*
ERROR at line 1:
ORA-03251: Cannot issue this command on SYSTEM tablespace
ORA-06512: at "SYS.DBMS_SPACE_ADMIN", line 0
ORA-06512: at line 1

im getting this error
piuljdvvxq
2007-08-03 17:34:40
Hello! Good Site! Thanks you! ghszhbnrzu
mhgpxwqgjf
2007-08-03 02:09:21
Hello! Good Site! Thanks you! zlqlzjacrlhipz
aman
2007-08-02 06:14:48
fuddu
Rod Smalt
2007-08-01 12:11:25
This tells me absolutely nothing. Supposedly, the MAKE_REF() function allows one to create a valid OID from a primary key object table reference. I've tried that, and STILL get this very uninformative error.
sameera
2007-08-01 11:51:57
how to avoid this error
roberto
2007-07-25 16:35:39
I got this warning in this instrucion where myfield in ('A', 'B', 'C')

MYFILED is defined as nvarchar2(50 char).
¿how can i do to solve this problem?

regards
Tom Stock
2007-07-24 18:18:35
These are not the only possible reasons - I've given all possible permissions to the folders / subfolders, no wallet currently exists, yet it still gives the same error.
Monami Sharma
2007-07-20 21:54:12
I have seen this error code for a an element with value containin '&' in it.
Mumak
2007-07-18 16:29:30
This "help" don't help me!!!!
MK
2007-07-18 14:40:45
HADİ YA
Dhina
2007-07-12 11:34:13
Solution is Fine..
Better if its provided further details
Ex: How to enable the trace
Jiri Klimos
2007-07-10 07:00:02
It seems to be a bug in RMAN for VMS. We have the same error. You can also see the coresponding message in the alert log. Something like:
ORA-19512: file search failed
ORA-27036: translation error, unable to expand file name
%SYSTEM-?-NOMSG, Message number 00001EB7 - %NONAME-?-NOMSG, Message number 00000006
Control autobackup written to DISK device
handle 'cc_bckdisk1:[bck_databases.][avxn]avxn_bcks_ctl_c-4251179673-20070709-00.bck'

I thing RMAN tries to find if the target file exist but it finishes the backup succesfully.

If it causes some problems for you, I think you have to create new TAR on metalink.
Eddy
2007-06-27 10:08:21
The proposed action is obvious and of no use for this error message, so please place proper help (how to find the proper timezone) or remove.
filobus
2007-06-19 12:23:18
Tried "alter session close database link" but returned the following error:
ORA-02080: database link is in use
loay
2007-06-18 11:17:54
i think this error appears when an incompatible types is recognized by the compiler!
Sri Ganesh Dumpala
2007-06-16 20:49:44
Status of the PUBLIC Synonym for the table may be 'INVALID'.Check and change the same.

The Error:"java.sql.SQLException: ORA-04045: errors during recompilation/revalidation : synonym translation no longer valid"
Paul Perdiguero
2007-06-12 02:00:13
This problem can not be fixed with a recovery database, only with the original files or change the control's file. Bye... Paul.
aga
2007-06-01 13:39:02
You probably have a corrupt tnsnames.ora file. be sure it just have text characters.If you are working on a linux system then edit this file with a linux editor. If you are working on a windows system then edit this file with a windows editor, in order to have a clean content.
A common problem is when copying a tnsnames.ora file from windows to linux, it probably have \r\n instead of \n causing this problem.
mtm
2007-05-31 09:08:49
very good!
Dave
2007-05-29 13:59:13
It looks like even switching off Compression on the table doesn't fix the problem
Amritesh
2007-05-25 13:05:11
How i can solve this problem
Anara
2007-05-24 06:12:20
What does this mean? permanent error:string...i don't understand anything
laxminarayan!!
2007-05-22 05:52:49
If dnt know soln dnt post
Serretti
2007-05-21 20:41:14
soluction error exp - 00093???
Unsatisfied
2007-05-17 12:11:33
Useless information !
Zaid
2007-05-16 10:09:38
The insert command works fine, but when trying to update on the other database the error message pops up... what is the reason???
rahul
2007-05-15 09:11:44
select courtno userno,substr(judge_name,1,25) Judge,substr(desg_desc,1,25) Desg,count(idno) total from case_master,court_judge
where
court_judge.court_code = courtno
and courtno is not null
and courtno not in ('400','401','757')
and dealing_type !='X'
and
filing_date between &a+numtoyminterval(-3,'YEAR') and &a
group by courtno,judge_name,desg_desc
order by courtno
SAM
2007-05-10 07:24:56
THIS SOLUTION WILL NEVER BE SOLVED IN TOAD
sunny
2007-05-09 04:39:13
please do give some examples to make your self more clearified.
Raghu
2007-05-07 10:49:52
To avoid this error and to get the things done for moment, drop all the existing indexes on the tables and then re-create them so that these indexes can be created at the datafile which is not corrupted. Oracle while creating indexes will make sure to have these indexes possibly in an area which is not corrupted.

Edgar Durão
2007-05-04 15:03:30
Works like a charm. I've done a Windows tcp/ip stack reset with netsh claering all my hosts file, so the domain name was not being resolved.
Sukhi
2007-05-03 06:44:13
I am sorry, right command is here.

allocate channel for maintenance type disk;
Sukhi
2007-05-03 06:38:20
if you are scheduling backup with oracle grid control, then remove mentioned commands from backup script.

allocate maintainence channel type disk;
release channel;

SURESH HEGDE
2007-05-03 06:13:55
I am getting this error in file [ORACLE10GR2.ADMIN.SMS.UDUMP]PARROT_SMS_FG_ORACLE_019.TRC
*** 2007-05-02 01:27:05.523

*** ACTION NAME:(0000033 STARTED16) 2007-05-02 01:27:05.462

*** MODULE NAME:(backup full datafile) 2007-05-02 01:27:05.462

*** SERVICE NAME:() 2007-05-02 01:27:05.462

*** SESSION ID:(155.102) 2007-05-02 01:27:05.462
ORA-19512: file search failed
ORA-27036: translation error, unable to expand file name
%SYSTEM-?-NOMSG, Message number 00001EB7 - %NONAME-?-NOMSG, Message number 00000006

please help...
Luca
2007-05-01 09:02:38
What a stupid and unhelpful description.
Perhaps some indication of WHAT you can't do would have been better?
Ewoud Joustra
2007-04-24 07:44:56
DGMGRL> ENABLE CONFIGURATION
Arun Gowda
2007-04-24 05:17:37
Please Relice the only one problem
this one code list provide the this email address
arun.santu@gmail.com
Manikandan
2007-04-20 07:48:08
CREATE TABLE sales_composite (region_id NUMBER(5),region_name VARCHAR2(30),sales_amount NUMBER(10),
2 sales_date DATE)
3 PARTITION BY RANGE(sales_date)
4 SUBPARTITION BY HASH(region_id)
5 SUBPARTITIONS 4
6 (PARTITION q1 VALUES LESS THAN (TO_DATE('01/04/2007', 'DD/MM/YYYY'),
7 PARTITION q2 VALUES LESS THAN (TO_DATE('01/07/2007', 'DD/MM/YYYY'),
8 PARTITION q3 VALUES LESS THAN (TO_DATE('01/09/2007', 'DD/MM/YYYY'),
9 PARTITION q4 VALUES LESS THAN (TO_DATE('01/01/2007', 'DD/MM/YYYY'));
PARTITION q2 VALUES LESS THAN (TO_DATE('01/07/2007', 'DD/MM/YYYY'),
*
ERROR at line 7:
ORA-14017: partition bound list contains too many elements

SURESH HEGDE
2007-04-20 06:13:48
Please explain more on this...
Thanks,
ORA-02404
2007-04-18 09:57:10
specified plan table not found
Brijesh
2007-04-17 20:31:57
Solution:

Check dba_2pc_pending table, you will see there is 1 row returned
with same local_tran_id as above: 3.65.429 , the status is collecting.

Remove the pending transaction by:

execute dbma_transaction.purge_lost_db_entry('3.65.429 ');

It should fix the error.


For some reason, the distributed transaction did not finish properly,
it ended with "collecting" status. The reco process tried to recover
the transaction periodicly but failed, thus error logged into alert log
and trace file. The best way to clean it is using above command.

=========================================================

Before you begin, make note of the local transaction ID, <local_tran_id>, from
the error message reported.

1. Determine if you can attempt a commit or rollback of this
transaction. You can do the following select to help determine what
action to take:

SQL> select state, tran_comment, advice from dba_2pc_pending
where local_tran_id = '8.17.443822';

Review the TRAN_COMMENT column as this could give more information
as to the origin of the transaction or what type of transaction it was.

Review the ADVICE column as well. Many applications prescribe advice
about whether to force commit or force rollback the distributed
transaction upon failure.

2. Commit or rollback the transaction.

To commit:

SQL> commit force '<local_tran_id>';

To rollback:

SQL> rollback force '<local_tran_id>';



WARNING: Step 3 (purge_lost_db_entry) and Step 4 should ONLY be used
when the other database is lost or has been recreated.
Any other use may leave the other database in an unrecoverable or
inconsistent state.
Vitaliy.Litenko@comarch.com
2007-04-13 11:22:44
I'm using SUN 5.9, in TNS names I've got
(PROTOCOL = TCP), network adapter has fun. But I still have this error.
manikandan
2007-04-12 13:47:24

SQL> alter table department add
2 foreign key department (dept_id)
3 references
4 employee (dept_id);
foreign key department (dept_id)
*
ERROR at line 2:
ORA-00906: missing left parenthesis
manikandan
2007-04-12 13:42:05
alter table department add
foreign key department (dept_id)
references
employee (dept_id);
Ammar Sajd
2007-04-10 19:57:56
The error is in the tnsnames.ora
hstest =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = AMMAR)(PORT = 1521))
(CONNECT_DATA =
(SID=hs_testing)
)
(hs=ok)
)

Make sure that you close the CONNECT_DATA Parenthesis before you add the (hs=ok)
The error was generated what the (hs=ok) is place directly after the SID as in
(SID=hs_testing)(hs=ok)

Ammar Sajdi
www.e-ammar.com
oraclejo.blogspot.com
nazarian
2007-04-10 15:59:43
You can also get this error if the schema you are working at does not have some of the tables in your query.
hafiz
2007-04-08 08:58:52
how to : Recompile the library unit for this version of PL/SQL.
Ricardo, Brazil
2007-04-03 14:10:23
I am getting this error for an invalid type. "No need to perform this operation" does not apply to my case.
Daavid
2007-04-02 03:10:22
You can also get this error if the database identifier is not correct. (In my case it was not aware of the fully qualified name.)
isehwurscht
2007-03-27 19:16:42
works thanks
Austin
2007-03-26 14:11:18
From: http://www.oracle.com/technology/products/text/x/10g_tech_overview.html

"The ODCI interface does not allow partitioned indexes to be rebuilt. You can use replace metadata on individual partitions to, for instance, change the sync interval. But you can't alter index rebuild for the overall index -- you'll get the error ORA-14086: a partitioned index may not be rebuilt as a whole. However, we have a PL/SQL procedure which works around ODCI. Just call it with the index name and the parameters string, like this:


exec ctx_ddl.replace_index_metadata('myidx','replace metadata lexer rlex');"
oracledba
2007-03-24 06:03:15
clear the trace files in bdump and udump to fix the problem
Nitin
2007-03-23 07:26:34
Is there any disadvantage in using WITH ROWID to resolve this problem.
João
2007-03-22 18:24:17
Nossa GRANDE ajuda a ação rss
Dave Argent
2007-03-20 13:37:17
Thats the worst help I've ever been given next to microsoft help documentation. Apauling.
spaxx
2007-03-20 11:23:29
absolutely hopeless and unhelpful
Szilos Gábor
2007-03-14 12:51:51
Use

alter session close database link <linkname>

to close before dropping the database link.
A. Wellwisher
2007-03-13 12:14:37
Not a lot of use really...
Ricky
2007-03-08 02:54:09
Good!
It help me solve the problem
Carol
2007-03-07 04:58:48
This solution was perfect. Thank You.. database up and running.
laporte
2007-02-26 13:09:53
can also occur on create database statement
Your "definition"
2007-02-24 19:27:46
Your "definition", without specific is really dumb ass one.
Aman
2007-02-23 19:43:33
if your database is in noarchivelog...or you have also lost your archive file..then this is solution..
1.alter database backup controlfile to trace noresetlogs;

2.shut immediate;

3.startup nomount;

4.create controlfile from trace file...just copy paste (which is automatically comes into udump)

5.recover database;

6.alter database open

try this n leave comment ...is it working
venkat
2007-02-09 05:23:05
How to increase MIN extends and Max extends
yogi
2007-01-30 10:24:38
This is absolutely wrong. Please check this link for right answer
http://www.halfcooked.com/mt/archives/000936.html
Deepak Kharb
2007-01-18 08:55:34
Duplicate vertices in polygon causes ORA-13356
DEv
2007-01-03 16:32:34
This will help you out :-)
http://www.dbasupport.com/forums/showthread.php?threadid=34300&highlight=ORA14074
DEv
2007-01-03 16:19:42
Agree, was the action computer generated ??
Si
2006-12-06 14:57:15
Very helpful!
While Adding Data file i have got the following errors
2006-12-04 12:20:32
ORA-00376: file 7 cannot be read at this time.
ORA-01110: data file 7: 'D:\ORACLE\ORADATA\TEST\DATA\ACC01.DBF'
Help Needed...

Austin
2006-11-17 12:02:19
I got this error trying to connect to oracle without using the TNSNAME syntax and not having ORACLE_SID defined.

i.e. I had omitted the @<tnsname> from the login as in

sqlplus system/manager@tnsname

This error is output because oracle is looking for ORACLE_SID when not using the @tnsname syntax and ORACLE_SID was not set.
Austin
2006-11-17 12:02:17
I got this error on the primary server and it is complaining about the standby server. It turned out that dataguard was not running on the standby even though I thought I had told it to run.

The log file $ORACLE_HOME/admin/$ORACLE_SID/bdump/drc$ORACLE_SID.log file confirmed that it was not running.

It turned out that I had not created an spfile for the database:

create spfile from pfile='$ORACLE_HOME/dbs/init$ORACLE_SID.ora';

shutdown and restart the database. Now set the dg_broker_start = true

alter system set dg_broker_start = true;

this will bring up the dataguard broker. In my case this setting hadnt stuck between shutdown / startup because I wasnt using an spfile.
Austin
2006-11-17 12:02:16
show configutation in dgmgrl was listing this as a problem with our dataguard setup. After checking the dataguard broker log files ($ORACLE_HOME/admin/<sid>/bdump/drc*.log) on both the primary and standby databases, I noticed the standby was complaining it could not contact the primary.

Using lsnrctl status on the primary showed that the listener was not running.

Used lsnrctl start to start the listener to correct the problem.
SA
2006-11-08 08:21:56
EXP-00019 failed to process parameters, type 'EXP HELP=Y' for help

Varun Yagain
2006-09-25 09:28:36
I notice that ORA-21560 is produced if you pass the value directly into the dbms_lob.write() call. Assigning it to a variable and passing this variable to dbms_lob.write() seems to solve it!
x
2006-09-14 22:06:02
Thanks for stating the obvious. Might I recommend doing more than simply regurgitating the original error message.
joe blow
2006-08-24 18:21:26
syntax weenies?
Austin
2006-08-15 14:10:27
I got this error with the following command:

create configuration 'My_DR' as
primary database is 'PRIMARY'
connect identifier is 'PRIMARY';

show parameter db_unique_name showed that the database unique name was not infact PRIMARY, hence the error.

To change the db_unique_name of your database, do the following (where PRIMARY is the unique name and INSTANCE is the SID):

oracle$ export ORACLE_SID=INSTANCE
oracle$ sqlplus "/ as sysdba"
SQL> create pfile from spfile;
SQL> shutdown;
SQL> quit;
oracle$ vi $ORACLE_HOME/dbs/initINSTANCE.ora
( add or edit the following line )
*.db_unique_name = 'PRIMARY'
:wq!
oracle$ rm $ORACLE_HOME/dbs/spfileINSTANCE.ora
oracle$ sqlplus "/ as sysdba"
SQL> startup nomount;
SQL> create spfile from pfile;
SQL> alter database mount;
SQL> alter database open;
SQL> quit;
Austin
2006-08-15 13:49:58
I got this issueing the following command in dgmgrl:

remove configuration;

The reason for the error is that no configuration existed, so it could not remove it.

Action required: None, ignore the error / dont issue the command.
Chris Clark
2006-07-21 12:19:50
This is completely useless.
Admin
2006-07-15 10:50:50
Ofcourse it is. Its an error reference. The extra knowledge comes from the link to the Oracle FAQ and also from these comments where people can add their wisdom and experiences of a particular error.
Hans Werner Körtgen
2006-07-13 15:10:24
This error will always occur when one looks for a table which was dropped without dropping its synonyms, f.i. with a construct like:
vsel := 'select count(*) from ' || vrec.tab_name ;
execute immediate vsel into vzahl ;
-- It took me some time to find it out --
John
2006-07-05 08:34:49
what is the max length ?
Rupesh
2006-06-29 06:22:19
This is just copy paste of what oracle people are saying.Go more in detail and give cleare solutions.
Mahaveer Jain
2006-03-01 09:54:41

i think it means you need to issue
shutdown immediate on svrmgr prompt

or you may need to resize your SGA (shared_pool
Buffer_pool.....in initSID.ora)
Mind Reader
2006-02-27 05:46:24
Just like an IBM manually. "You have an error, correct it and resubmit". Oh, so informative, who needs an Oracle Metalink account when you guys have all the answers!
venkat
2006-02-07 09:55:05
got this error while upgradding from 9.2.0.5 to 9.2.0.7 and runninght catpatch.sql
2006-02-01 14:13:42
run{
allocate channel t1 type disk;
backup database format 'c:\backup\test%t%s';
release channel t1 ;
}
ksrsrao@yahoo.com
2006-01-26 20:41:57
ora -01678 log_file_conver_name
Neil O Connor
2006-01-16 01:43:53
I'm sorry, but this really must be one of the most useless cause and actions descriptions that I've ever seen. Surely! somebody can come up with more helpful descriptions of the cause and action rather than just paraphrasing the error message?
Sergio
2006-01-10 09:28:14
How Repopulate the locator by issuing a SELECT statement and retry the operation.

I´m use Oracle 8.17 over Unix and exceute the select using the folowing Visual Basic Code


Dim oraXML As OraClob
Dim vOraClob As OraClob
Dim AmountRead As Long
Dim AmountInsert As Long
Dim buffer As Variant

On Error GoTo errortrap

OpenConn DNS

'Se definen los parametros del procedure.
OraDatabase.Parameters.Add "v_XmlToBeSend", Empty, ORAPARM_INPUT
OraDatabase.Parameters("v_XmlToBeSend").serverType = ORATYPE_CLOB
OraDatabase.Parameters.Add "v_ResponseXml", Empty, ORAPARM_OUTPUT
OraDatabase.Parameters("v_ResponseXml").serverType = ORATYPE_CLOB

Set vOraClob = OraDatabase.CreateTempClob(False)


' Aqui se debe cargar el xml.
vOraClob.Write (xml_in)

OraDatabase.Parameters("v_XmlToBeSend").Value = vOraClob

'Execute de procedure'
AmountInsert = OraDatabase.ExecuteSQL("BEGIN " + SPName + "(:v_XmlToBeSend,:v_ResponseXml); END;")

'Get del xml de respuesta
Set oraXML = OraDatabase.Parameters("v_ResponseXml").Value

'Read entire CLOB value, xml_out must be a Variant,
'buffer contendra el xml de respuesta
AmountRead = oraXML.Read(xml_out)


OraDatabase.Parameters.Remove ("v_ResponseXml")
OraDatabase.Parameters.Remove ("v_XmlToBeSend")

Set vOraClob = Nothing

CloseConn

They you help me?
Dg
2005-12-29 12:28:24
¡Hi!

what happens if index already exists?
he is the interesting thing!
Hemant (Software Engineer)
2005-12-29 03:30:01
hi this is Hemant. I am also in trouble from error ORA-02315 so please help me
praim sankar
2005-12-28 08:48:32
see metalink note:
331657.1
Chandan Singh
2005-12-09 03:17:48
I am facing the same problem with segment management manual
ZhangKM
2005-12-06 21:28:56
Excese me
I just want to know how to set agent SID.Is there anybody can give a sample to me.Thanks very much.
Oracle saver
2005-12-06 00:56:14
Very helpful website...please don't stop some funny things like this
Paul
2005-11-29 13:13:00
I corrected the error just like you said and it worked!!
Gabor Szilos
2005-11-18 09:49:23
It is also thrown when you create a join bitmap index and you put a table name twice in the FROM clause which is not allowed.
Satyajit
2005-11-17 09:41:54
Really your solution is of great help. I was tensed. it gave me relief. i laughed a lot.
GSR
2005-11-09 23:45:18
Can any one tell which parameter decides the Max no.of HTTP connections that can be open from the database??
Chandra
2005-11-09 06:31:12
Every where it is given the same thing. Can somebody explain with some examples;
Phil
2005-11-08 12:10:16
Would be helpful if I knew what a grant option was...
Abdul Malik
2005-11-07 23:21:57
ORA-00907: missing right parenthesis

insert into m1 (SELECT * FROM x1 a WHERE EXISTS (SELECT * FROM x2 b WHERE a.id= b.id AND a.name=b.name not in (select * from m1 )));

can anyone tell me what is wrong with this simple query;
tc dba
2005-11-07 09:17:36
Definitely. Rerun the CATHS.SQL script on the Oracle server.

The CATHS.SQL script can be found in the $ORACLE_HOME/rdbms/admin directory. Please run the script as SYS.

Ricardo
2005-11-01 13:22:10
What is wrong ?
Amar
2005-10-26 12:49:08
I am not under-standing how do i do that in TOAD
ORA-02310
2005-10-25 05:33:32
exceeded maximum number of allowable columns in table
Henry
2005-10-18 22:36:05
Usually this error is caused by the LVM or storage layer.
Admin
2005-10-16 02:23:56
The action text was incomplete, this has now been corrected.
SupEr
2005-10-01 06:11:40
Me ferrei com esse erro
Kaunal
2005-09-23 04:06:22
can any body give Solution for the error
email id: kaunalgandhi@yahoo.com
mario
2005-09-20 23:36:17
which actions i have to perform after met an ORA-30357 error?
Rajasekhar
2005-09-20 01:44:12
when we give the log files invalid not in C:\oracle\ora92\revudu\redolog01.log not in oradata folder that time this error arise. to prevent this make sure keep in C:\Oracle\oradata\mvsl.log.
abhishek
2005-09-19 07:13:34
What is the meaning of the Cause.

the Code is running fine in Oracle 8/8i.

the problem occurs with Oracle 9i.

pls send me the description of cause at.

vishnoi_abhishek@yahoo.co.in


Dave
2005-09-16 05:34:54
doesnt make sense, especially since it often occurs with indexes for which the given modify command doesnt work