Fulltext results:
- Cleanup Packages @info:linux:debian
- ed (but not purged) packages with this command: <code bash> dpkg --get-selections | grep 'deinstall$' </code> You can feed this list directly to aptitude to purge the packages: <code bash> aptitude purge $(dpkg --get-selections | grep 'deinstall$' | cut -f1) </code> ===== Remove Orphans ===== If a packages is in
- localeadm @info:solaris
- o mount it (insert your path in the first line. <code bash> ISOIMG="/share/iso/sol-10-u8-ga-sparc-dvd.i... OFIDEV=${LOFIDEV} mount -F hsfs ${LOFIDEV} /mnt </code> Note: If you're using the bourne shell (instead... xamples ===== ==== List Installed Locales ==== <code bash> localeadm -lc </code> Example output: <code> Checking for installed packages. This could take a
- Mercurial
- s ==== Ignore ''.DS_Store'' and ''._*'' files: <code> (^|/)\._[^/]+$ (^|/)\.DS_Store$ </code> ==== NetBeans ==== These expressions exclude the directories... n the top directory, but not in subdirectories: <code> ^build$ ^dist$ ^nbproject/private$ </code> Only in the second level directory, but not in subdirector
- MacPorts @info:mac
- = ===== List Ports ===== list requested ports: <code bash> port echo requested | cut -d ' ' -f 1 | uniq </code> list installed ports: <code bash> port -qv installed </code> ===== Housekeeping ===== When ports are updated, the old port is onl
- jps - Java Virtual Machine Process Status Tool @info:java
- more examples: List all java processes: ''jps'' <code> 55719 hourglass.jar 51299 jEdit 51610 Main 56026 Jps </code> Long listing: ''jps -l'' <code> 55719 /Users/andreas/.my/pkg/hourglass-0.6.1/lib/hourglass.jar 51299 ... 56042 sun.tools.jps.Jps 51610 org.netbeans.Main </code> List arguments: ''jps -m'' <code> 55719 hourgla
- Setting the Timezone @info:linux:debian
- etc/timezone''. ===== Check the Timezone ===== <code bash> cat /etc/timezone </code> Example: <code> # cat /etc/timezone Europe/London </code> ===== Set the Timezone ===== You can use ''vi'': <code b
- Oracle: Recovery Manager @info:oracle
- ager ====== ===== Start Recovery Manager ===== <code bash> rman target / </code> ===== Delete Archive Logs ===== Delete all archive logs but keep the last 45 days: <code sql> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> To remove archive logs older than 3 days withou
- Oracle: SPFile and PFiles @info:oracle
- o a PFile, just enter the following in SQLplus: <code sql> CREATE PFILE FROM SPFILE; </code> It will create a PFile ''${ORACLE_HOME}/dbs/init${ORACLE_SID}.o... path to the PFile instead of ${PATH_TO_PFILE}. <code sql> SHUTDOWN IMMEDIATE; STARTUP NOMOUNT PFILE='$... ' CREATE SPFILE FROM PFILE; SHUTDOWN IMMEDIATE; </code> If your PFile is located at ''/db/oracle/config
- Disable a Service @info:linux:debian
- Disable a Service ====== To disable a service: <code bash> service <service> stop update-rc.d <service> enable|disable </code> With ''systemd'' (starting with Debian 8): <code bash> systemctl disable <service> </code> To (re)enable a service: <code bash> update-rc.d <service>
- Virtual Network Visualization @info:solaris
- tual Wire Demo Tool]]. ===== dladm2dot.pl ===== <code perl> #! /usr/bin/perl $STYLE{'etherstub'} = "sh... = \"$2\"; }\n"; } } close INPUT; print "}\n"; </code> ===== Example ===== {{ dladm2dot.png|Example's Result}} === Input === == dladm show-link == <code> LINK CLASS MTU STATE OVER e1000g... 0 isc2 vnic 9000 up isc_net0 </code> == dladm show-linkprop -o link,value -p zone ==
- Compare directories @info:script
- ach of the directories, generate a digest file: <code bash> find DIR -type f -exec shasum {} + | LC_ALL=C sort -d -k 2 > shasums.txt </code> It's important to use ''LC_ALL=C'' and the opti... After that, you can diff the two shasums.txt: <code bash> diff shasums1.txt shasums2.txt </code> Or you use Meld as graphical diff tool: <code bash> meld
- Oracle: Resize Instance @info:oracle
- First, change the [[spfile_and_pfiles|SPFile]]: <code sql> ALTER SYSTEM SET pga_aggregate_target = 2G S... ALTER SYSTEM SET sga_target = 6G SCOPE=SPFILE; </code> Then, (optionally) export the SPFile to a PFile: <code sql> CREATE PFILE FROM SPFILE; </code> Finally, reboot the instance to activate the change: <code sql
- Oracle: List Accounts with Objects @info:oracle
- objects (like tables), you can query them with: <code sql> SELECT DISTINCT OWNER FROM DBA_OBJECTS ORDER BY OWNER; </code> If you want to list all accounts, you can query them with: <code sql> SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME; </code> Or, if you only want the DBAs: <code sql> SELE
- MySQL: Create User @info:mysql:user
- ySQL: Create User ====== ==== Create User ==== <code sql> CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}'; </code> ==== Create User and Database ==== * Usually, ''{user}'' == ''{db}'' <code sql> CREATE USER '{user}'@'%' IDENTIFIED BY '{pas... ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; </code> Simpler Alternative: <code sql> CREATE DATABAS
- rmdir for OSX @info:mac
- ctories from the command line quite complicated: <code bash> $ rmdir test rmdir: test: Directory not empty $ rm test/.DS_Store $ /bin/rmdir test </code> I wrote a small bash function to remove directo... together with the contained ''.DS_Store'' file: <code bash> rmdir() { for d in "$@" do f="${d%/}/.DS_S... fi /bin/rmdir "${d}" || ls -al "${d}" done } </code> With this function you can remove the directory
