damorgan wrote:An open port is not what makes a network insecure. It is what application protocol is used, what service is listening on that port, and how that service is configured.
There is no need to invoke a shell script ... you can send the email using UTL_SMTP which is a fully documented built-in package assuming your network is so insecure that the required port is open.
oracle version 188.8.131.52
os version solaris 10.
i want to configure my oracle 11g database to send output of shell script to email address after every 30minuts.
my script is
col spoolname new_value spoolname
select 'health_'||to_char(sysdate, 'yymmddhh24miss') spoolname from dual;
prompt**---------------Database General Information-------------------------------**
SELECT DBID "DATABASE_ID", NAME "DB_NAME", LOG_MODE, OPEN_MODE, RESETLOGS_TIME FROM V$DATABASE;
SELECT instance_name, status, to_char(startup_time,'DD-MON-YYYY HH24:MI:SS') "DB Startup Time"
column "Host Name" format a15;
989399 wrote:Patience, Grasshopper
989399 wrote:I have no idea what it means to "look strike".
You are looking very strike DBA. :)
actully in start i just loaded a shell script and want to email output of it but when i recive replies as i said before i am new in oracle world so that replay was above my level so wn,t undestand than for simplicity i just copy tow commands from scripts and any body tell me step by step procedure how to email output of above mention statments thats why i change my statments to make thing easy for me to undestand. hope you got my msg.. now if you can tell me step by step procdure than i will be realy thankfull.You might want to get your keyboard checked out. There seem to be a lot of keys that are malfunctioning.