AWS Redshift and Oracle impersonate another user (requires superuser permissions) with set session authorization
set session authorization ‘username’; SET SESSION AUTHORIZATION – Amazon Redshift BTW – you can do this with Oracle too I believe with:
Month: September 2021
Alias to SQLcl on linux (and more) is now “sql”
In otherwords say you want to login as sysdba then you just do this: sql / as sysdba And you get the following:
Running oracle-database-preinstall-21c on a RHEL 8 or CentOS 8 Linux flavor
With Oracle Linux 8 you just run – because the package comes with # dnf install -y oracle-database-preinstall-21c and then If you want optionally # yum update -y But for non-Oracle dialects like RHEL 8 or CentOS 8 you can download and bang the package in as follows – saves a lot of time curl …
Running oracle-database-preinstall-21c on a RHEL 8 or CentOS 8 Linux flavor Read More »
Setting DISPLAY environment variable syntax changes with Gnome
Centos8 Gnome DISPLAY is set like this: export DISPLAY=:0 In other words normally for xWindows you do something like this to set your DISPLAY variable prior to running an xApp like: export DISPLAY=<machine-name>:0.0 With Gnome the syntax is: export DISPLAY=:0 All other common version of setting display do not work on Gnome. One other tip – it …
Setting DISPLAY environment variable syntax changes with Gnome Read More »
XWindows didn’t get installed on your RHEL 8/7 (or clone centos etc). Then do this
BTW if XWindows is not loaded on your linux app for RHEL or clones you can go here, download the RPM and do a yum install like this: Another oddity – with Centos8 Gnome DISPLAY is set like this: export DISPLAY=:0 In other words normally for xWindows you do something like this to set your …
XWindows didn’t get installed on your RHEL 8/7 (or clone centos etc). Then do this Read More »
xhost has changed with RHEL 8 “xhost +” as “root” returns a “cannot open display” try this instead
Looks like you cannot run xhost as root When I run it from my admin account that has sudo – it “xhost +” works BTW if XWindows is not loaded on your linux app for RHEL or clones you can go here, download the RPM and do a yum install like this:
Reset Oracle Password and Unlock account if necessary
Make sure the account is not locked or expired. SQL> select username, account_status, lock_date, expiry_date from dba_users where username = ‘TESTUSER1’; USERNAME ACCOUNT_STATUS TESTUSER1 LOCKED… Reset and unlock SQL> alter user TESTUSER1 account unlock; User altered. SQL> alter user TESTUSER1 identified by ‘MyNewPw#0721’; User altered. And here is a link to something that will generate …
Reset Oracle Password and Unlock account if necessary Read More »