Problem in oracle 11g

Dear All,





I was testing jchem cartridge in oracle 11g, but i am not able to configure cartridge for different users.





I have successfully done all operations mentioned in documentation along with loadjava option with a small correction in online documentation. I am getting error "not a valid function or procedure name" for user assigned with JCC_BASIC_ROLE.





I also used the privman.sql process described in "http://www.chemaxon.com/forum/viewpost17119.html&highlight=oracle+11g#17119"





My System is Linux X86_64 with oracle 11g 64-bit, Java Latest Version 64-bit and jchem being the latest version.





Regards,





Dayam

Dear Dayam,





What did you do when you got this error message?





Thanks


Peter

I got this message during the installation check process after installing cartridge for users with role JCC_BASIC_ROLE as described in documentation.





When Jchem cartridge was installed in JCHEM oracle account, the alert that oracle raised was of "46 object(s) are invalid in the JCHEM schema". I selected all the invalid objects and recompiled them without any problem.





I am able to pass the installation verification in JCHEM owner but not in users with assigned role "JCC_BASIC_ROLE".





I have checked for user whether he has the execute privelages on objects from jchem and he does have them.





Thanks and Regards,





Dayam

Please, could you post the entire output of the test.sh script?





Thanks


Peter

Please find below the output of test.sh script.





********************START OF OUTPUT**************





$ ./test.sh jchem/jchem123





SQL*Plus: Release 11.1.0.6.0 - Production on Thu Nov 13 2008





Copyright (c) 1982, 2007, Oracle. All rights reserved.





Enter user-name:


Connected to:


Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production


With the Partitioning, OLAP, Data Mining and Real Application Testing options





SQL> INFO: JDBC driver version: 10.2.0.1.0





JCHEM_CORE_PKG.GETENVIRONMENT()


--------------------------------------------------------------------------------





Oracle environment:


Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production


PL/SQL Release 11.1.0.6.0 - Production


CORE 11.1.0.6.0 Production


TNS for Linux: Version 11.1.0.6.0 - Production


NLSRTL Version 11.1.0.6.0 - Production





JChem Server environment:


Java VM vendor: Sun Microsystems Inc.


Java version: 1.6.0_10


Java VM version: 11.0-b15





JCHEM_CORE_PKG.GETENVIRONMENT()


--------------------------------------------------------------------------------





JChem version: 5.1.3


JChem Index version: 50103


JDBC driver version: 10.2.0.1.0








Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64


bit Production


With the Partitioning, OLAP, Data Mining and Real Application Testing options





********************END OF OUTPUT**************





Regards,





Dayam

Thanks Dayam. I meant the output which contains the "not a valid function or procedure name" error message. Could you, please, post it as well?





Thanks


Peter

Dear Peter,





The following is the output for the user account assigned with JCC_BASIC_ROLE





*****************************START************************************************





$ ./test.sh database/oradata123





SQL*Plus: Release 11.1.0.6.0 - Production on Thu Nov 13 2008





Copyright (c) 1982, 2007, Oracle. All rights reserved.





Enter user-name:


Connected to:


Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production


With the Partitioning, OLAP, Data Mining and Real Application Testing options





SQL> select jchem_core_pkg.getenvironment() from dual


*


ERROR at line 1:


ORA-00904: "JCHEM_CORE_PKG"."GETENVIRONMENT": invalid identifier








Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64


bit Production


With the Partitioning, OLAP, Data Mining and Real Application Testing options





*****************************END************************************************





Below one is the use_password function error for user with JCC_BASIC_ROLE assigned.





SQL> call jchem_core_pkg.use_password('jchem123');


call jchem_core_pkg.use_password('jchem123')


*


ERROR at line 1:


ORA-06576: not a valid function or procedure name





Thanks and Regards,





Dayam

Dear Dayam,





Do you have a public synonym for the JCHEM.JCHEM_CORE_PKG package?





Thanks


Peter

Dear Peter,





I don't have any public synonyms under user JCHEM (cartridge owner). I also don't have any synonyms for JCHEM in all_synonyms table.





I did run the command described in documentation "call privman_pkg.public_syns_for_jcobjs('JCHEM');" under JCHEM account in oracle.





Did i do anything wrong?





Thanks a lot for your efforts.





Thanks and Regards,





Dayam

Dear Dayam,





Has JChem CREATE PUBLIC SYNONYMS privilege? (Probably not.) You have to execute call jchem_core_pkg.use_password('ciril'); as someone having that privilege (e.g. SYSTEM).





Thanks


Peter

Dear Peter,





Yes, you are right that JCHEM doesn't have CREATE PUBLIC SYNONYM privilege. Now i am able to assign the JCC_BASIC_ROLE to different users after assigning the JCHEM owner the mentioned privilege.





Thanks a lot for your help.





My suggestion is to add the "CREATE PUBLIC SYNONYM" privilege option in documentation (http://www.chemaxon.com/jchem/doc/admin/cartridge.html#icart) as it doesn't mention the same.





Thank you for your help.





Regards,





Dayam