DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, May 31, 2016

LOAD JAVA FILES TO THE DB USER

[oracle@localhost jlib]$ loadjava -user HR mail.jar

Password:
********                                                                                                                                                              
[oracle@localhost jlib]$ !sq
sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 28 14:35:20 2016

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options



SQL>  begin dbms_java.grant_permission( 'HR', 'SYS:java.net.SocketPermission','localhost:PORT','connect,resolve');end;
  2  /

PL/SQL procedure successfully completed.

SQL> BEGIN dbms_java.grant_permission( 'HR','SYS:java.net.SocketPermission', 'zpop.hybridzimbra.com', 'resolve' );end;
  2  /

PL/SQL procedure successfully completed.

1 comment:

Sridevi K said...


Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.