alter system set open_cursors=3900 sid='ORC1'  SCOPE=BOTH;

alter profile default limit password_life_time unlimited failed_login_attempts unlimited;

ALTER PROFILE default LIMIT IDLE_TIME unlimited;


--DROP TABLESPACE marina INCLUDING CONTENTS AND DATAFILES;
create tablespace marina DATAFILE 'marina01.dbf' SIZE 3000M AUTOEXTEND ON;


alter system set processes = 1500 scope=spfile;
ALTER SYSTEM SET sessions=1248 SCOPE=SPFILE;

create directory dumpdmp as 'C:\irm\dmp';



SELECT s.sid, s.serial#, s.status, p.spid
 FROM v$session s, v$process p
WHERE s.username = 'MARINA'
and p.addr(+) = s.paddr;

--ALTER SYSTEM KILL SESSION '7, 39';

alter session set "_ORACLE_SCRIPT"=true;
drop user marina cascade;
create user marina identified by marina default tablespace marina temporary tablespace temp;
grant dba to marina;


update s_nastavitve set vrednost='http://127.0.0.1:18080/' where naziv='GlobalApplicationServerAddress' ;  
update s_nastavitve set vrednost='http://127.0.0.1:18080/' where naziv='MMService' ;  
update s_nastavitve set vrednost='https://127.0.0.1:18443/' where naziv='MMWebAppAddress';