
-- alter system set processes = 320 scope=spfile; -- CDB$ROOT  Po defaultu je 320,ne treba mijenjati
-- alter system set sessions = 375 scope=spfile; Po defaultu je 540, ne treba mijenjati

-- Da ne bi pretjerali kod kreiranja PDB-a pa da zeznemo licencna prava
alter system set max_pdbs=3 scope=spfile;
alter system set audit_trail = os scope=spfile;
alter system set FILESYSTEMIO_OPTIONS=SETALL scope=spfile;
alter database force logging;  


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';
grant read,write on directory backup_dir 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;
/






