Switching to a different Schema ( connect to another user, run a query as another user)

Say you are logged in as SYS or SYSTEM and want to run a query as another user but don’t have that password. Here is one way to switch or see that schema’s objects without prefixing schema name. ALTER SESSION SET CURRENT_SCHEMA = <schema name>; i.e. alter session set current_schema=scott; select * from emp;  

RHEL 6 Manually Creating A Logical Volume And Auto Mounting It As an Ext4 file system

RHEL 6 Manually Creating A Logical Volume And Auto Mounting It As Ext4 for a device that has been added to your VM and not previously used. The device should already be allocated and should show up with no other “fdisk’ed” devices on it – for this example (see my By The Way note immediately…

I forgot the URL to Oracle Enterprise Manager / OEM 13c – one way to find it – emctl status oms -details

I forgot the URL to OEM – one way to find it – along with many the other related ports, homes, logs. It is under “Console URL:” below. export OMS_HOME=/u01/app/oracle/middleware $OMS_HOME/bin/emctl status oms -details Oracle Enterprise Manager Cloud Control 13c Release 2 Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved. Enter Enterprise Manager Root…