Configuring Clients for Environments with Both Shared and Dedicated Servers

If a shared server is configured on the server side, and a client connection request arrives when no dispatchers are registered, then the request is processed by a dedicated server process. If you want a particular client always to use a dispatcher, then configure (SERVER=shared) in the CONNECT_DATA section of the connect descriptor. For example:

sales=
(DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
  (CONNECT_DATA=
     (SERVICE_NAME=sales.us.example.com)
     (SERVER=shared)))

If the (SERVER=shared) attribute is configured and a dispatcher is not available, then the client connection request is rejected, and a message is sent to the client.

If the database is configured for a shared server and a particular client requires a dedicated server, then you can configure the client to use a dedicated server in one of the following ways:

• You can configure a network service name with a connect descriptor that contains (SERVER=dedicated) in the CONNECT_DATA section. For example:
  sales=
  (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))
    (CONNECT_DATA=
       (SERVICE_NAME=sales.us.example.com)
       (SERVER=dedicated)))
• You can configure the client profile file, sqlnet.ora, with USE_DEDICATED_SERVER=on. This adds (SERVER=dedicated) to the CONNECT_DATA section of the connect descriptor the client uses.
  Note:
  If USE_DEDICATED_SERVER is set to ON, then existing (SERVER=value) entries in connect descriptors are overwritten with (SERVER=dedicated).

Select object tablespace

select * from dba_segments

where owner = 'FCCHOST'

and lower(segment_name) like '%fc_%'

Privilege

select text from USER_SOURCE

where name = 'REMOVE_EMP'

order by line; 

-Check privilege granted to users

SELECT * FROM DBA_SYS_PRIVS A

JOIN DBA_ROLE_PRIVS B

ON (A.GRANTEE=B.GRANTEE

and A.GRANTEE='SAK')

If you want more than just direct table grants (e.g., grants via roles, system privileges such as select any table, etc.), here are some additional queries:

System privileges for a user:

SELECT PRIVILEGE
  FROM sys.dba_sys_privs
 WHERE grantee = 'SAK'
UNION
SELECT PRIVILEGE
  FROM dba_role_privs rp JOIN role_sys_privs rsp ON (rp.granted_role = rsp.role)
 WHERE rp.grantee = 'SAK'
 ORDER BY 1;

Direct grants to tables/views:

SELECT owner, table_name, select_priv, insert_priv, delete_priv, update_priv, references_priv, alter_priv, index_priv
  FROM table_privileges
 WHERE grantee = <theUser>
 ORDER BY owner, table_name;

Indirect grants to tables/views:

SELECT DISTINCT owner, table_name, PRIVILEGE
  FROM dba_role_privs rp JOIN role_tab_privs rtp ON (rp.granted_role = rtp.role)
 WHERE rp.grantee = <theUser>
 ORDER BY owner, table_name;

Pasted from <http://stackoverflow.com/questions/1298473/how-can-i-list-all-grants-a-user-received>

24down vote

Assuming you want to list grants on all objects a particular user has received: select * from all_tab_privs_recd where grantee = 'SAK'

Pasted from <http://stackoverflow.com/questions/1298473/how-can-i-list-all-grants-a-user-received>

select distinct 'GRANT '||privilege||' ON '||OWNER||'.'||TABLE_NAME||' TO '||RP.GRANTEE
from DBA_ROLE_PRIVS RP join ROLE_TAB_PRIVS RTP
on (RP.GRANTED_ROLE = RTP.role) 
where (OWNER in ('SAK') --Change User Name
   OR RP.GRANTEE in ('SAK')) --Change User Name
and RP.GRANTEE not in ('SYS', 'SYSTEM')
;

Kill rman

Kill rman

Friday, August 10, 2018

4:30 AM

SQL> select b.sid, b.serial#, a.spid, b.client_info
from v$process a, v$session b
where a.addr=b.paddr and client_info like 'rman%';

SQL> alter system kill session '592,12' immediate;

Virtual Private Database (VPD) Demo.

Security is very important in today technology world. for example in the company, the CEO doesn't want the employees working in the Department 20 see the salary of the employees working in Department 10. especially End Of Year..hehe..you know that. So in this demo I will show you how to implement the Virtual Private Database(VPD) in Oracle Database. using this method we can restrict the condition and archive this goal. I will create a policy to let the employees to see only his/her own Department Data(Deptno 20).

1. Before apply the policy

2. Creating the policy function.

3. Creating the security policy. (on user sys)

4. Verifying the policy

We can see that user can see only data of Department num 20.

5. To drop the policy

EXECUTE dbms_rls.drop_policy('HR','EMPLOYEES','EMP_DEPT_20');

DB init.ora for Flexcube

init.ora parameter recommendation for Flexcube:

FCUAT12.__data_transfer_cache_size=0

FCUAT12.__db_cache_size=9797894144

FCUAT12.__java_pool_size=67108864

FCUAT12.__large_pool_size=268435456

FCUAT12.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

FCUAT12.__pga_aggregate_target=4160749568

FCUAT12.__sga_target=12482248704

FCUAT12.__shared_io_pool_size=536870912

FCUAT12.__shared_pool_size=1677721600

FCUAT12.__streams_pool_size=0

*._allow_level_without_connect_by=TRUE

*.audit_file_dest='/u01/app/oracle/admin/FCUAT12/adump'

*.audit_trail='db'

*.compatible='12.1.0.2.0'

*.control_files='/data/oratest/FCUAT12/control01.ctl','/data/fast_recovery_area/FCUAT12/control02.ctl'

*.cursor_sharing='FORCE'

*.db_block_size=8192

*.db_cache_advice='OFF'

*.db_domain=''

*.db_name='FCUAT12'

*.db_recovery_file_dest='/data/fast_recovery_area'

*.db_recovery_file_dest_size=4560m

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=FCUAT12XDB)'

*.fast_start_mttr_target=300

*.job_queue_processes=16

*.log_buffer=115343360

*.memory_max_target=16642998272

*.memory_target=16642998272

*.nls_date_format='DD-MON-RRRR'

*.open_cursors=5000

*.optimizer_dynamic_sampling=1

*.optimizer_index_caching=90

*.optimizer_index_cost_adj=90

*.parallel_adaptive_multi_user=FALSE

*.parallel_max_servers=32

*.pga_aggregate_limit=0

*.pga_aggregate_target=3960m

*.plsql_code_type='NATIVE'

*.plsql_optimize_level=2

*.processes=550

*.remote_dependencies_mode='SIGNATURE'

*.remote_login_passwordfile='EXCLUSIVE'

*.session_cached_cursors=400

*.sga_target=11881m

*.skip_unusable_indexes=FALSE

*.undo_retention=1800

*.undo_tablespace='UNDOTBS1'

*.utl_file_dir='*'

TFA (Trace File Analyzer)

Topics Include:

++Decrease the number of Reactive issues with Single Instance and RAC ++Promote Best Practices ++Maintain a “healthy” RAC Environment ++SR turnaround time reduced and quicker resolution when dealing with Reactive Types of Issues