OraFAQ Forum: JDeveloper, Java & XML » user_java

Home » Developer & Programmer » JDeveloper, Java & XML » user_java_policy table not available

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

user_java_policy table not available [message #393023]

Fri, 20 March 2009 01:01

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

 this is my production DB.
IND> select banner from v$version
  2  ;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

5 rows selected.

At my local DB(TESTING)
to avoid the following ERROR

ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.security.AccessControlException: the Permission (java.net.SocketPermission
x.x.x.x:xxxx connect,resolve) has not been granted to schema. The
PL/SQL to grant this is dbms_java.grant_permission( 'schema',
'SYS:java.net.SocketPermission', 'x.x.x.x:xxxx', 'connect,resolve' )
ORA-06512: at "schema.procedurename", line 1
ORA-06512: at line 1

call dbms_java.set_output(1000);

and
i am granting permission to that schema

call dbms_java.grant_permission('schema','java.net.SocketPermission','x.x.x.x:xxxx','connect,resolve');

At my TEsting DB USER_JAVA_POLICY Table available.

IND> desc user_java_policy
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 KIND                                               VARCHAR2(8)
 GRANTEE_NAME                              NOT NULL VARCHAR2(30)
 TYPE_SCHEMA                               NOT NULL VARCHAR2(30)
 TYPE_NAME                                          VARCHAR2(4000)
 NAME                                               VARCHAR2(4000)
 ACTION                                             VARCHAR2(4000)
 ENABLED                                            VARCHAR2(8)
 SEQ                                                NUMBER

but in my production DB

IND>  desc user_java_policy
ERROR:
ORA-04043: object user_java_policy does not exist

i need to deploy the code to the production DB .....wthout the permission ,'java.net.SocketPermission' error will occur so i need to grant the permission. but there is no such table lke user_java_policy to view which permissions are granted to specific user.

to get that view do i need to run any kind of script,or is it generated automatically whenever i grant the permissions directly.
need your suggestion.

thanks & regards
Sriram

[Updated on: Fri, 20 March 2009 01:41]

Report message to a moderator

Re: user_java_policy table not available [message #393034 is a reply to message #393023]

Fri, 20 March 2009 01:39

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

Senior Member
Account Moderator

Did you install Java?

select * from v$option where lower(parameter) like '%java%';

Regards
Michel

Report message to a moderator

Re: user_java_policy table not available [message #393037 is a reply to message #393034]

Fri, 20 March 2009 02:01

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Thank Michel for your fast reply.here the option.

IND> select * from v$option where lower(parameter) like '%java%';

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Java
TRUE


1 row selected.
IND> desc user_java_policy
ERROR:
ORA-04043: object user_java_policy does not exist


IND> desc dba_java_policy
ERROR:
ORA-04043: object dba_java_policy does not exist

Thanks
Sriram

Report message to a moderator

Re: user_java_policy table not available [message #393038 is a reply to message #393037]

Fri, 20 March 2009 02:08

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

Senior Member
Account Moderator

select comp_id, status, version from dba_registry where comp_id like '%JAVA%';

desc sys.user_java_policy

Regards
Michel

[Updated on: Fri, 20 March 2009 02:09]

Report message to a moderator

Re: user_java_policy table not available [message #393043 is a reply to message #393038]

Fri, 20 March 2009 02:16

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

IND> select comp_id, status, version from dba_registry where comp_id like '%JAVA%';

no rows selected

IND> desc sys.user_java_policy
ERROR:
ORA-04043: object sys.user_java_policy does not exist

this is from my local DB.

IND> select comp_id, status, version from dba_registry where comp_id like '%JAVA%';

COMP_ID                        STATUS      VERSION
------------------------------ ----------- ------------------------------
JAVAVM                         VALID       10.2.0.1.0
CATJAVA                        VALID       10.2.0.1.0

IND> select * from v$option where lower(parameter) like '%java%';

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Java
TRUE

IND> desc sys.user_java_policy
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 KIND                                               VARCHAR2(8)
 GRANTEE_NAME                              NOT NULL VARCHAR2(30)
 TYPE_SCHEMA                               NOT NULL VARCHAR2(30)
 TYPE_NAME                                          VARCHAR2(4000)
 NAME                                               VARCHAR2(4000)
 ACTION                                             VARCHAR2(4000)
 ENABLED                                            VARCHAR2(8)
 SEQ                                                NUMBER

thanks & regards
Sriram

[Updated on: Fri, 20 March 2009 02:34]

Report message to a moderator

Re: user_java_policy table not available [message #393049 is a reply to message #393043]

Fri, 20 March 2009 02:38

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Any updates?
thanks
Sriram

Report message to a moderator

Re: user_java_policy table not available [message #393055 is a reply to message #393049]

Fri, 20 March 2009 03:13

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

Senior Member
Account Moderator

ramoradba wrote on Fri, 20 March 2009 08:38

Any updates?
thanks
Sriram

I'm not here JUST to answer you, I also have a real work and a life outside OraFAQ.
Just wait or hire a consultant to answer IMMEDIATLY to your questions.

Your Java option was not installed correctly if you have no rows in dba_registry. Reexecute catjava.sql.

Regards
Michel

Report message to a moderator

Re: user_java_policy table not available [message #393057 is a reply to message #393055]

Fri, 20 March 2009 03:27

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

I'm not here JUST to answer you, I also have a real work and a life outside OraFAQ.
Just wait or hire a consultant to answer IMMEDIATLY to your questions.

i know that Michel.but i am posting my topic for the last 3 hours..whenever i click on preview button or apply changes the page hanged.atlast it`s directed to the forum correctly.

and i am really sorry for troubling you...my intension is just to intimate you & have the solution for the error

Quote:

Any updates?

i mean shall i have to run any scripts
and i got the answer

Quote:

Reexecute catjava.sql.

thanks & regards
Sriram.

Report message to a moderator