List all crons and database links with scripts

I’m currently listing all interfaces – database links and cron jobs – into excel, and used these two scripts to automate the process. Shell script to list all crons (note that this assumes crons in /etc/cron.d run as root): for fle in `ls /var/spool/cron/* | grep -v tmp` do echo $fle =============== grep -v ‘^#’ […]

Read More List all crons and database links with scripts
February 14, 2012

Easy connect database links

Saves modifying tnsnames.ora: create database link mylink connect to myuser identified by mypassword using ‘//myserver/mydatabase’ ; Note that passwords are case sensitive from 11g. This means 10g->11g links need uppercase passwords.

Read More Easy connect database links
November 16, 2010