Home » Infrastructure » Unix » ORA-29907: specified operator does not exist
ORA-29907: specified operator does not exist [message #253438] Mon, 23 July 2007 23:28 Go to next message
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 1430 times)
Re: ORA-29907: specified operator does not exist [message #253439 is a reply to message #253438] Mon, 23 July 2007 23:38 Go to previous messageGo to next message
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)!
Re: ORA-29907: specified operator does not exist [message #253460 is a reply to message #253438] Tue, 24 July 2007 01:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
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
Re: ORA-29907: specified operator does not exist [message #253508 is a reply to message #253460] Tue, 24 July 2007 02:42 Go to previous messageGo to next message
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
Re: ORA-29907: specified operator does not exist [message #253529 is a reply to message #253508] Tue, 24 July 2007 03:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
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

Re: ORA-29907: specified operator does not exist [message #254067 is a reply to message #253529] Wed, 25 July 2007 12:19 Go to previous messageGo to next message
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


Re: ORA-29907: specified operator does not exist [message #254069 is a reply to message #254067] Wed, 25 July 2007 12:24 Go to previous message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Who knows? Try it!

Regards
Michel
Previous Topic: Installation
Next Topic: Need help with if statement
Goto Forum:
  


Current Time: Thu Dec 12 07:33:33 CST 2024