I would like a Unix shell script that would run the SQL below to run via a cron job every hour.
SELECT TYPE, STATUS, HIGH_SCN FROM V$LOGSTDBY;
no rows selected
If the query returns, "no rows selected" then I know for sure that Data Gurad has stopped. If the query returns, "no rows selected" , then I would like an e-mail trigerred to inform the DBAs that Data Guard has stopped.
Working with Network Access Control Lists in Oracle 11g (part 1)
Part 2: http://www.e-e.com/A_9074.html
So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.