Category Archives: Database links

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 … Continue reading

Posted in Database links, Scripts | Leave a comment

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.

Posted in Database links | Leave a comment