Assignment Solution @ Assignment Help on Fiverr.com
1.Command to Kill Inactive Session SELECT * FROM v$session WHERE status =’INACTIVE’; select ‘alter system kill session ”’ ||sid|| ‘,’ ||serial#|| ”’ immediate;’ as insess from v$session where status=’INACTIVE’; commit; select ‘alter system kill session ”’ ||sid|| ‘,’ ||serial#|| ”’ immediate;’ from v$session where status=’INACTIVE’ and program is null and module is null;…
1. Unlock for an Account alter user fel account unlock; grant connect, resource to fel;
Please use the Account that have Oracle permission 1. Export exp fel/fel@FEL FULL=Y FILE= FullExport.dmp OR expdp fel/fel directory=data_pump_dir dumpfile=export.dmp nologfile=y tables=fel.mytable OR expdp fel/fel@FEL directory=data_pump_dir dumpfile=export.dmp nologfile=y schemas=fel 2. Inport imp fel/fel@FEL FULL=Y FILE=FullExport.dmp OR impdp fel/fel@fel directory=data_pump_dir dumpfile=FullExport.dmp logfile=imp.log table_exists_action=replace OR impdp fel/fel@FEL dumpfile=FullExport.dmp nologfile=y schemas=fel remap_schema= fel:fel32
1.The number of sessions the database was configured to allow SELECT name, value FROM v$parameter WHERE name = ‘sessions’; 2. The number of sessions currently active SELECT COUNT(*) FROM v$session
I. Oracle Listener Configuration File Location in Linux 1. $OracleHome/network/admin OR 2. /opt/oracle/network/admin II. Files to Configure 1. listener.ora LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myora.prestobear.com)(PORT = 1521)) ) ) +HOST = myora.prestobear.com We can put the host…
set verify off; drop user “FEL” cascade; — Create tablespace FEL if not exist CREATE USER FEL IDENTIFIED BY FEL default tablespace FEL temporary tablespace TEMP QUOTA UNLIMITED ON FEL; — Grant the whole DB to user FEL GRANT DBA TO “FEL”; — Remember to commit; commit;
— Create a role name CREATE ROLE role111; — Assign permissions to a role GRANT CREATE session, CREATE table, CREATE view, CREATE procedure, CREATE synonym, ALTER table, ALTER view, ALTER procedure,ALTER synonym, DROP table, DROP view, DROP procedure, DROP synonym, TO role111; — Grant role to a user called XXX GRANT role111 TO…
1.Shutdown Oracle DB Instance shutdown abort OR shutdown immediate
1.Show the current user sho user 2.To see all the privilege that we can grant to a role/user select * from system_privilege_map 3.Delete a User drop user FEL cascade; exit;