OraFAQ Forum: Unix » ORA-29907: specified operator does not exist

Home » Infrastructure » Unix » ORA-29907: specified operator does not exist

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-29907: specified operator does not exist [message #253438]

Mon, 23 July 2007 23:28

rana_99cse
Messages: 3
Registered: July 2007

Junior Member

i am using Solaris 5.8 and Oracle 9i.
problem is that when i create a database with DBCA command, during creating database an error show in the window
"ORA-29907: specified operator does not exist". that time i select ignore option, then finish installation. after installation, i check the database and its ok.
So that ORA-29907 error create any problem? if cerate problem, then how o resolve it?

Attachment: oracle.bmp
(Size: 102.21KB, Downloaded 1597 times)

Report message to a moderator

Re: ORA-29907: specified operator does not exist [message #253439 is a reply to message #253438]

Mon, 23 July 2007 23:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>"ORA-29907: specified operator does not exist".

I don't agree.
Too bad you decided not to use CUT & PASTE
Only you might know what really,really happened.

oerr ora 29907
29907, 00000, "found duplicate labels in primary invocations"
// *Cause: There are multiple primary invocations of operators with
// the same number as the label.
// *Action: Use distinct labels in primary invocations.

You're On Your Own (YOYO)!

Report message to a moderator

Re: ORA-29907: specified operator does not exist [message #253460 is a reply to message #253438]

Tue, 24 July 2007 01:08

Michel Cadot
Messages: 68785
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Make you sure all your environment variables point to the same Oracle home.

Regards
Michel

Report message to a moderator

Re: ORA-29907: specified operator does not exist [message #253508 is a reply to message #253460]

Tue, 24 July 2007 02:42

rana_99cse
Messages: 3
Registered: July 2007

Junior Member

here is the oracle env output.

bash-2.03$ env
PWD=/export/home/oracle
TZ=GMT+6
ORACLE_SID=ora92
HZ=100
HOSTNAME=smscsrv01
LD_LIBRARY_PATH=/export/home/oracle/product/9.2/lib32:/export/home/oracle/product/9.2/lib:/lib:/usr/lib:/usr/local/lib
CLASSPATH=/export/home/oracle/product/9.2/JRE:/export/home/oracle/product/9.2/jlib:/export/home/oracle/product/9.2/rdbms
/jlib:/export/home/oracle/product/9.2/network/jlib
MACHTYPE=sparc-sun-solaris
ORACLE_BASE=/export/home/oracle
ORACLE_HOME=/export/home/oracle/product/9.2
DISPLAY=10.2.4.26:0.0
LOGNAME=oracle
SHLVL=1
ORA_NLS33=/export/home/oracle/product/9.2/ocommon/nls/admin/data
SHELL=/usr/bin/bash
HOSTTYPE=sparc
OSTYPE=solaris
HOME=/export/home/oracle
TERM=vt100
PATH=/export/home/oracle/product/9.2/bin:/usr/j2se/bin:/usr/bin:/etc:/usr/sbin:/usr/lbin:/usr/ucb:/export/home/oracle/bi
n:/usr/bin/X11:/sbin
NLS_LANG=American_America.US7ASCII
_=/usr/bin/env

Report message to a moderator

Re: ORA-29907: specified operator does not exist [message #253529 is a reply to message #253508]

Tue, 24 July 2007 03:23

Michel Cadot
Messages: 68785
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

LD_LIBRARY_PATH=/export/home/oracle/product/9.2/lib32:/export/home/oracle/product/9.2/lib

Why 32-bit libraries are before 64-bit?
Why both are named? You use either 32-bit or 64-bit not both.

Regards
Michel

Report message to a moderator

Re: ORA-29907: specified operator does not exist [message #254067 is a reply to message #253529]

Wed, 25 July 2007 12:19

rana_99cse
Messages: 3
Registered: July 2007

Junior Member

So what i need to do? chenge the PATH to like following:

LD_LIBRARY_PATH=/export/home/oracle/product/9.2/lib:/lib:/usr/lib:/usr/local/lib

Then is this solve the problem?

Thanks
Rana

Report message to a moderator

Re: ORA-29907: specified operator does not exist [message #254069 is a reply to message #254067]

Wed, 25 July 2007 12:24

Michel Cadot
Messages: 68785
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Who knows? Try it!

Regards
Michel

Report message to a moderator

Previous Topic:	Installation
Next Topic:	Need help with if statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 16 20:20:31 CDT 2026