From MOS, search for patch 13390677 (it’s a full install) p13390677_112040_platform_1of7.zip (Oracle Database, including Oracle RAC components) p13390677_112040_platform_2of7.zip (Oracle Database, including Oracle RAC components)
sqlplus username/pwd@//host[:port]/service prompt for password: sqlplus username@\”//host/[:port]/service\”
Solve the svchost 100% cpu issue om Windows 7 SP1 I installed all these: IE11-Windows6.1-x64-en-us.exe Windows6.1-KB3020369-x64.msu Windows6.1-KB3102810-x64.msu windows6.1-kb3125574-v4-x64_2dafb1d203c8964239af3048b5dd4b1264cd93b9.msu Windows6.1-KB3179573-x64.msu windows6.1-kb3197868-x64_b07be176e165c11b9ccbcf03d014b2aef9a514b6.msu windows6.1-KB976932-X64.exe After this, the problem still occurred. Then: 19.12.2016 12:55 30’659’457 Windows6.1-KB3172605-x64.msu https://support.microsoft.com/en-us/kb/3172605 July 2016…
To update Windows – when you have all updates to execute, the Windows Updater can get stuck (with 100% cpu) – seems to be doing nothing, then fails. Use this instead: Windows Updater
Get a list of diskroups – bash shell diskgroups=$(sqlplus -s -L / as sysdba << EOF set pages 0 feedback off select listagg (name, ' ') within group (order by name) from v\$asm_diskgroup; EOF )…
c:\> wmic computersystem get model,name,manufacturer,systemtype
Display filenames only: grep -l dba *.trc (lowercase letter l as switch) Display filenames and matches grep -H dba *.trc Recursively find files and executes grep on each: find . -name “*.trc*” -exec -l dba…
Determine connections that have been idle for more than a certain amount of time (be aware that last_call_et also shows number of seconds active also) Examples — Connections idle for > 60 minutes select s.sid,s.serial#,s.username,s.status,…
SELECT s.sid, s.serial#, s.username, s.osuser, p.spid “Linux process id”, s.machine, p.terminal, s.program FROM v$session s, v$process p WHERE s.paddr = p.addr; — Get Linux processes that have no related session(s) select inst_id, spid, program from…