Skip to content

phpMyAdmin – allow remote access to phpMyAdmin

To allow access to phpMyAdmin on a server from a remote browser, edit the file: /etc/httpd/conf.d/phpMyAdmin.conf and add lines as follows (example allow remote access from 192.168.1.107) # phpMyAdmin – Web based MySQL browser written… 

Oracle – RAC

Oracle RAC Links Oracle FAQ – RAC Interconnect Grid Infrastructure Installation Guide Configuring Networks for Oracle Grid Infrastructure and Oracle RAC Oracle RAC and Clusterware Interconnect Virtual Local Area Networks (VLANs)

Linux – cpu info

lscpu Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: Little Endian CPU(s): 12 On-line CPU(s) list: 0-11 Thread(s) per core: 2 Core(s) per socket: 6 Socket(s): 1 NUMA node(s): 1 Vendor ID: GenuineIntel CPU family:… 

Oracle – Data Pump

expdp “\/ as sysdba\” SCHEMAS=xyz,abc ….. FLASHBACK_TIME=systimestamp SQL> select current_scn from v$database; expdp “\/ as sysdba\” SCHEMAS=xyz,abc ….. FLASHBACK_SCN=nnnnnnnnnn where nnnnnnnnnn = current_scn from the previous query

Oracle – Remove / Detach Home from Oracle Inventory

Must be done from an installed runInstaller (not from distribution) oracle@server1: ./runInstaller -silent -detachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME=”/oracle/product/112_64/ORCL” Starting Oracle Universal Installer… Checking swap space: must be greater than 500 MB. Actual 10111 MB Passed The… 

Oracle – Quick Check using Scripts

Not exhaustive select * from v$sga_target_advice select * from v$pga_target_advice select * from v$shared_pool_advice — Dictionary Cache Hit Ratio SELECT (1 – (Sum(getmisses)/(Sum(gets) + Sum(getmisses)))) * 100 FROM v$rowcache; — ———————– — Library Cache Hit…