
alter system set open_cursors = 300 scope=spfile;
alter system set undo_retention=10800 scope=spfile;
alter system set open_links=10 scope=spfile;
ALTER SYSTEM SET optimizer_index_cost_adj=100 SCOPE=spfile;
ALTER SYSTEM SET optimizer_index_caching=90 SCOPE=spfile;
alter system set "_optim_peek_user_binds" = false scope=spfile;
alter system set JOB_QUEUE_PROCESSES = 20 scope=spfile;
alter system set remote_dependencies_mode=signature scope=spfile;
alter system set global_names = false scope=spfile;
alter system set db_securefile=PERMITTED scope=both;


alter profile default limit password_life_time UNLIMITED;
alter profile default limit failed_login_attempts UNLIMITED;
alter profile default limit password_reuse_time UNLIMITED;
alter profile default limit password_lock_time UNLIMITED;
alter profile default limit password_grace_time UNLIMITED;



create directory backup_dir as '/u02/backup';
create directory dpdir as '/u02/datapump';
grant read,write on directory backup_dir to public;
grant read,write on directory dpdir to public;

BEGIN
 DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
    acl          => 'iii_acl.xml', 
    description  => 'Dozvola pristupa (III)',
    principal    => 'PUBLIC', 
    is_grant     => TRUE,     
    privilege    => 'connect'
  );
 DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE (
     acl             => 'iii_acl.xml',
     principal       => 'PUBLIC',
     is_grant        => TRUE,
     privilege       => 'resolve'
  );
  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
        acl=> 'iii_acl.xml',
        host => '*'
   );
  COMMIT;  
END;
/






