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.
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.
May 31, 2016 | 26 views
-
Comments
-
One Reply to “LOAD JAVA FILES TO THE DB USER”
Leave a Reply
- May 31, 2016 | 26 views
-
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.