Home » Developer & Programmer » JDeveloper, Java & XML » user_java_policy table not available
user_java_policy table not available [message #393023] Fri, 20 March 2009 01:01 Go to next message
ramoradba
Messages: 2456
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you install Java?

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

Regards
Michel
Re: user_java_policy table not available [message #393037 is a reply to message #393034] Fri, 20 March 2009 02:01 Go to previous messageGo to next message
ramoradba
Messages: 2456
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
Re: user_java_policy table not available [message #393038 is a reply to message #393037] Fri, 20 March 2009 02:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
ramoradba
Messages: 2456
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 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Any updates?
thanks
Sriram
Re: user_java_policy table not available [message #393055 is a reply to message #393049] Fri, 20 March 2009 03:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: user_java_policy table not available [message #393057 is a reply to message #393055] Fri, 20 March 2009 03:27 Go to previous messageGo to next message
ramoradba
Messages: 2456
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.
Re: user_java_policy table not available [message #393206 is a reply to message #393057] Fri, 20 March 2009 13:47 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Is there any other method to know which & what are the permissions granted to the specified URL(i mean IP)

Thanks & regards
Sriram
Previous Topic: How to attach Change control document in the JDeveloper
Next Topic: how to get sum in matrix report
Goto Forum:
  


Current Time: Fri Mar 29 07:46:05 CDT 2024