Quick Learn | FAQ's | Technical Solutions

# User master table, consist of firstname, lastname, email etc. select  * from spt_identity # Entitlement select * from spt_identity_entitlement # Roles select * from spt_bundle # Application table details like HR, Finance, PAM application etc. select * from  spt_application # Managed attributes details like type entitlement, group etc. select * from  spt_managed_attribute # Profiles related table select * from  spt_profile select * from  spt_profile_constraints select * from spt_bundle # Request manage access table select * from spt_identity_request_item # Access request table - with completion status, requester, approver etc. select * from  spt_identity_request # Plugin listing table select * from  spt_plugin # Password policies select * from  spt_password_policy # Capabilities select * from  spt_capability select * from  spt_capability_rights select * from  spt_capability_children # Request Details SQL SELECT  SPT_IDE...

Run below queries to check the Inactive sessions in Oracle database. Login from "sys as SYSDBA" option from any client tool(SQL developer) --Below command use to keep password life unlimited, Password won't expire ALTER PROFILE DEFAULT limit password_life_time UNLIMITED; --Increase the process and job queue process values show parameter process; show parameter spfile; show con_name; alter system set PROCESSES=1000 scope = spfile; alter system set job_queue_processes=500 scope = spfile;

Run below queries to check the Inactive sessions in Oracle database. Login from " sys as Sysdba " option from any client tool(SQL developer) select username, program, count(1) as "Inactive_Count" from v$session where status='INACTIVE' group by username, program; select status, count(1) from v$session group by status; SELECT count(sess.process), sess.status, sess.username, sess.schemaname FROM v$session sess, v$sql sql WHERE sql.sql_id(+) = sess.sql_id AND sess.type = 'USER' GROUP BY sess.status, sess.username, sess.schemaname; SELECT sess.*, sql.sql_text FROM v$session sess, v$sql sql WHERE sql.sql_id(+) = sess.sql_id AND sess.type = 'USER'; select p.username "OSUSERNAME", p.terminal,p.program, s.username "DBUSERNAME",s.command,s.status, s.server,s.process,s.machine,s.port,s.terminal,s.program, s.sid,s.serial#,p.spid FROM v$session s,v$process p WHERE p.addr=s.paddr and s.status='INACTIVE' order by 1,4;

STOP Database Service Navigate to database home path e.g. cd /home/oracle/app/oracle/product/12.2.0/dbhome_1/bin ./sqlplus "sys/Password as SYSDBA" SQL> shutdown immediate; STOP Database(DB) listener service ./lsnrctl stop ./lsnrctl status ps -ef | grep java Check there should not be any JAVA processes are running… START Database Service Once unix machine is started back in running mode… START (In below sequence only) cd /home/oracle/app/oracle/product/12.2.0/dbhome_1/bin Check listener services are running or not! ./lsnrctl start ./lsnrctl status Login to DB as sysdba ./sqlplus "sys/Password as SYSDBA" SQL> startup; ORACLE instance started. Total System Global Area     6241124352 bytes Fixed Size                              8634512 bytes Variable Size                         1258295152 bytes Database Buffers    ...

Oracle Identity Manager (OIM) 12c Installation Prerequisites: The Oracle Identity Manager software includes the following: 1] Oracle's Java Development Kit (JDK) 1.8 (jdk-8u311-linux-x64.tar.gz) 2]  Fusion Middleware 12.2.1.4.0 3]  SOA Suite 12.2.1.4.0 4] Oracle Identity and Access Management  12.2.1.4.0 What Do You Need? For completing Oracle IDM Setup you will need, Environment as below: Oracle Enterprise Linux 6 or similar, with access to the Internet At least 8GB RAM (16GB recommended) An Oracle Database Enterprise Edition 12 or superior installed and running. Note: Installing a Database for Identity and Access Management (IDM) Suite provides instructions on how to install an Oracle Database that is suitable for Oracle Identity and Access Management Suite. oracle and root user credentials SYS database user credentials Basic understanding of Linux An Oracle Technology Network (OTN) account OIM-11g PS3 Installation Steps: Just for reference https://www.oracle.com/webfol...