f



unix shell script

Hi all,

I am in need of a shell script which will cat all the audit files into
one log and then email.

Thanks.
Muddu

0
8/23/2006 10:22:41 PM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

2 Replies
900 Views

Similar Articles

[PageSpeed] 49

"muddu" <mudassar.dba@gmail.com> wrote in message 
news:1156371761.252866.267670@b28g2000cwb.googlegroups.com...
> Hi all,
>
> I am in need of a shell script which will cat all the audit files into
> one log and then email.
>

"cat *.aud" will merge all files together. You can redirect it to a file 
and/or email. 


0
email55 (608)
8/24/2006 12:36:37 AM
Thank you very much for your hint.
Regards.
Muddu

Bob Jones wrote:
> "muddu" <mudassar.dba@gmail.com> wrote in message
> news:1156371761.252866.267670@b28g2000cwb.googlegroups.com...
> > Hi all,
> >
> > I am in need of a shell script which will cat all the audit files into
> > one log and then email.
> >
>
> "cat *.aud" will merge all files together. You can redirect it to a file
> and/or email.

0
8/24/2006 1:25:35 PM
Reply:

Similar Artilces:

How to write shell script to export oracle 8.1.6 database to import oracle 10g database
Hi, I am trying to write or understand the conj process for export the data from oracle 8i to oracle 10g database. I have constraint that the previous loaded data into oracle10g should not be deleted or replace by newly imported database. Regards Nikhil ...

US-TX-Austin: Oracle/Sybase DBA, UNIX shell scripting, SQL Server, ODBC; 3M (45313657602)
US-TX-Austin: Oracle/Sybase DBA, UNIX shell scripting, SQL Server, ODBC; 3M (45313657602) ========================================================================================= Position: Oracle/Sybase DBA Reference: SMC01591 Location: Austin TX Duration: 3M Skills: Solid Oracle Database Administrator skills Knowledge of Unix shell scripting SQL Server knowledge. Bachelor's degree and 3-4 years experience Oracle database administration in a production environment. Exp using Unix OS c...

US-TX-Austin: Oracle/Sybase DBA, UNIX shell scripting, SQL Server, ODBC; 3M (45312938075)
US-TX-Austin: Oracle/Sybase DBA, UNIX shell scripting, SQL Server, ODBC; 3M (45312938075) ========================================================================================= Position: Oracle/Sybase DBA Reference: SMC01591 Location: Austin TX Duration: 3M Skills: Solid Oracle Database Administrator skills Knowledge of Unix shell scripting SQL Server knowledge. Bachelor's degree and 3-4 years experience Oracle database administration in a production environment. Exp using Unix OS c...

US-TX-Austin: Oracle/Sybase DBA, UNIX shell scripting, SQL Server, ODBC; 3M (45313514407)
US-TX-Austin: Oracle/Sybase DBA, UNIX shell scripting, SQL Server, ODBC; 3M (45313514407) ========================================================================================= Position: Oracle/Sybase DBA Reference: SMC01591 Location: Austin TX Duration: 3M Skills: Solid Oracle Database Administrator skills Knowledge of Unix shell scripting SQL Server knowledge. Bachelor's degree and 3-4 years experience Oracle database administration in a production environment. Exp using Unix OS commands and Windows OS commands to access database instances. Exp resolving database security, data integrity, and software performance issues. Knowledge of ODBC drivers for Windows. Skill in database management and optimization tools to manage, monitor, and improve performance. Ability to work professionally with external vendors to resolve database or application software problems. Ability to develop, implement and follow documented and standard operating procedures. Ability to establish and maintain effective relations with users, team members, and managers. General knowledge of database design concepts. General knowledge of application and database security contr...

US-TX-Austin: Oracle/Sybase DBA, UNIX shell scripting, SQL Server, ODBC; 3M (45312938075)
US-TX-Austin: Oracle/Sybase DBA, UNIX shell scripting, SQL Server, ODBC; 3M (45312938075) ========================================================================================= Position: Oracle/Sybase DBA Reference: SMC01591 Location: Austin TX Duration: 3M Skills: Solid Oracle Database Administrator skills Knowledge of Unix shell scripting SQL Server knowledge. Bachelor's degree and 3-4 years experience Oracle database administration in a production environment. Exp using Unix OS c...

US-TX-Austin: Oracle/Sybase DBA, UNIX shell scripting, SQL Server, ODBC; 3M (45313657602)
US-TX-Austin: Oracle/Sybase DBA, UNIX shell scripting, SQL Server, ODBC; 3M (45313657602) ========================================================================================= Position: Oracle/Sybase DBA Reference: SMC01591 Location: Austin TX Duration: 3M Skills: Solid Oracle Database Administrator skills Knowledge of Unix shell scripting SQL Server knowledge. Bachelor's degree and 3-4 years experience Oracle database administration in a production environment. Exp using Unix OS commands and Windows OS commands to access database instances. Exp resolving database security, data integrity, and software performance issues. Knowledge of ODBC drivers for Windows. Skill in database management and optimization tools to manage, monitor, and improve performance. Ability to work professionally with external vendors to resolve database or application software problems. Ability to develop, implement and follow documented and standard operating procedures. Ability to establish and maintain effective relations with users, team members, and managers. General knowledge of database design concepts. General knowledge of application and database security controls and auditing control req...

US-TX-Austin: Oracle/Sybase DBA, UNIX shell scripting, SQL Server, ODBC; 3M (45313657602)
US-TX-Austin: Oracle/Sybase DBA, UNIX shell scripting, SQL Server, ODBC; 3M (45313657602) ========================================================================================= Position: Oracle/Sybase DBA Reference: SMC01591 Location: Austin TX Duration: 3M Skills: Solid Oracle Database Administrator skills Knowledge of Unix shell scripting SQL Server knowledge. Bachelor's degree and 3-4 years experience Oracle database administration in a production environment. Exp using Unix OS c...

US-TX-Austin: Oracle/Sybase DBA, UNIX shell scripting, SQL Server, ODBC; 3M (45313532408)
US-TX-Austin: Oracle/Sybase DBA, UNIX shell scripting, SQL Server, ODBC; 3M (45313532408) ========================================================================================= Position: Oracle/Sybase DBA Reference: SMC01591 Location: Austin TX Duration: 3M Skills: Solid Oracle Database Administrator skills Knowledge of Unix shell scripting SQL Server knowledge. Bachelor's degree and 3-4 years experience Oracle database administration in a production environment. Exp using Unix OS c...

Unix shell script
Hi All, I understand oracle runs on windows evnviroment, and we have differet enviroment from windows os to interact with oracle, like toad, sql plus and etc. I am observing that many people are talking oracle with unix shell script. I really dont understand what we will do oracle with unix shell script. Can someone who involed on this oracle and unix shell script environment throw some relationship between this two. Thank you very much Cooltami "Cooltami" <cooltami@gmail.com> writes: > Can someone who involed on this oracle and unix shell script > environment ...

Shell script Backup Server Oracle Linux
I have programmed a shell script to do the backup to server Oracle on linux system. Here it is the script '-- #!/bin/sh set ORACLE_HOME=/usr/oracle/9.0/ export ORACLE_HOME echo "The backup is beginning" /usr/app/oracle/9.2/bin/exp system/oraclesystem full=y file=/home/oracle/exp/dati.dmp log=/home/oracle/exp/datilog.txt tar -cvf /dev/st0 exp echo "backup ended, have a nice day" --- I used a crontab to the the backup every day at 5.00 AM. But every day, the script do not run and the mail corresponding says --- Message 206 not found; No message file for product=RDBMS, facility=EXP: Release 9.2.0.4.0 - Production on Mon Jul 4 03:12:00 2005 Copyright (c) 1982, 2002, Oracle Invalid format of Export utility name Verify that ORACLE_HOME is properly set Export terminated unsuccessfully EXP-00000: Message 0 not found; No message file for product=RDBMS, facility=EXPexp/ exp/datilog.txt exp/dati.dmp exp/dati.dmp.gz exp/dati310505.dmp exp/dati.dmpgz backup finito, have a nice day -- Any hints? Regards. ALEX magicalex@inwind.it (hal9000) wrote in news:1h1bcvm.19tpebg1vf60a4N%magicalex@inwind.it: > I have programmed a shell script to do the backup to server Oracle on > linux system. > Here it is the script > '-- > #!/bin/sh > set ORACLE_HOME=/usr/oracle/9.0/ > export ORACLE_HOME > echo "The backup is beginning" > /usr/app/oracle/9.2/bin/exp system/oraclesystem full=y > f...

BCP MS SQL Server data from unix shell script
hi, I need to retrieve data from a table from MS SQL database and then populate sybase database tables from the same. The procedure i thought of is: - 1. BCP MS SQL data onto a flat file. 2. Read that flat file and BCP in again into Sybase table. Now all this processing shall take place through a shell script. Prior to BCP i created a DSN for connecting to the MS SQL database When i run the BCP command seperately from a command prompt it runs fine and generates a flat file form the table too. The i also BCPed in the flat file into sybase table which too went fine. But the same procedure wont work from a shell script. If i try to invoke the bcp command from a unix promt it wont connect to the MS SQL database which i thought it wont, as per my knowledge Microsoft hasnt come up with a driver for connecting its SQL server from unix. Can anybody suggest as to how shall one BCP MS SQL data within a shell script or for that matter even a perl script? Rohan I don't know how much data you have to port - if it's a lot, then the following is going to take a long time. MS SQL comes with a tool - SQL Server Enterprise Manager. Look up in the tool bar and find the little "magic wand" with stars - the microtext reads "Run a Wizard". Click it. This brings up the "select wizard" popup window that has an entry "Data Transformation Services". Click it. This expands into two entries DTS Export Wiza...

oracle sql query via Unix C shell script
Hi, I would like to call a sql query in Unix C shell script. It is just a simple call, 1) Connect to the oracle database by userid/password@db1, 2) Select to_char(sysdate,'yyyymmdd') from dual 3) Output the "date" result from 2) into the shell script variable Anyone can give me some suggestions? Very appreciated! utmielili wrote ... > Hi, > I would like to call a sql query in Unix C shell script. > It is just a simple call, > 1) Connect to the oracle database by userid/password@db1, > 2) Select to_char(sysdate,'yyyymmdd') from dual > 3) Output th...

Calling external Unix Shell Script and pass a Parameter from Database Trigger
Hi everyone, Summary: I am having a problem passing a value of a plsql variable to an external Unix shell script using extproc. I am using the Oracle suggested method of creating and executing external procedures via extproc by creating an Oracle Library, function and a small C program along with tnsnames.ora and listener.ora modifications. Everything works great as outlined, except that I can't seem to pass a variable from my database trigger routine to the shell script I am calling. Here is the trigger code: ------------------ Database Trigger-------------------------------------------------- CREATE OR REPLACE TRIGGER capture_locked_users AFTER SERVERERROR ON DATABASE DECLARE v_current_user varchar(60); BEGIN IF (is_servererror (28000)) THEN v_current_user := SYS_CONTEXT('USERENV','CURRENT_USER'); shell('/home/oracle/bin/alert_locked_users.sh v_current_user'); END IF; END capture_locked_users; ------------------------------------------------------------------------------------------------ Here is the C code shell.c that is compiled and shared with Oracle as the "shell_lib" library. ----------------- Shell.c ------------------------- #include<stdio.h> #include<stdlib.h> #include<string.h> void sh(char *command) { int num; num = system(command); } -------------------------------------------------------- Here is the Oracle function that interacts with the share library: ---...

moving oracle database server into a new server
Hi all I will be moving oracle from one Solaris server into another Solaris server, the IP address and box name will be changed. Oracle version is 8.1.7 and O/S is 5.8 on both servers ( just different O/S patch). Does any one know what I need to do in order to get oracle up and running again on the new server. I know that I will need to change the tnsnames.ora and listner.ora, but is there anything else that I need to do? Thanks Teresa Teresa wrote: > Hi all > > I will be moving oracle from one Solaris server into another Solaris > server, the IP address and box name will be changed. Oracle version is > 8.1.7 and O/S is 5.8 on both servers ( just different O/S patch). > Does any one know what I need to do in order to get oracle up and > running again on the new server. I know that I will need to change the > tnsnames.ora and listner.ora, but is there anything else that I need > to do? > > Thanks > Teresa When I do this with windows boxes I either: #1 Install oracle on the new box, create a new database and export/import from old db to new db #2 Copy datafiles, init, sqlnet, tns.. etc over from coldbackup or shutdown old_database, startup nomount and recreate the controlfile to fit new environment. #3 Restore from online backup of old_database and apply redo logs, again recreating the controlfile to fit the new env. (I usually only do this for "practice" and for creating a development copy of a prod db) #2 ...

US-TX-Troy: DATABASE ADMIN., Oracle 9i , PL/SQL, UNIX scripting; 10M (45354357604)
US-TX-Troy: DATABASE ADMIN., Oracle 9i , PL/SQL, UNIX scripting; 10M (45354357604) ================================================================================== Position: DATABASE ADMIN. Reference: ZYD00119 Location: Troy TX Duration: 10M Skills: Oracle 9i DBAs with strong PL/SQL skills to write stored procedures, triggers and packages. UNIX scripting skills are mandatory. Please send your current resume in confidence to JGoolsby@Eurosoft-Inc.com ..45354357604. ...

US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45287957609)
US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45287957609) ========================================================================================= Position: SQL Server Database Admin Reference: SMC01150 Location: San Antonio TX Duration: C-P Skills: 5 + years IT experience, 3 + years Database Administration and Architecture with SQL Server. Unix scripting, data warehouse, data modeling, data standards, development and management, data dictionary maintenance and data administration. ...

US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45287057605)
US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45287057605) ========================================================================================= Position: SQL Server Database Admin Reference: SMC01150 Location: San Antonio TX Duration: C-P Skills: 5 + years IT experience, 3 + years Database Administration and Architecture with SQL Server. Unix scripting, data warehouse, data modeling, data standards, development and management, data dictionary maintenance and data administration. SQL queries, and stored procedures. Good understanding of applications. MS Certification as a Solutions Developer or DBA. AIX and IBM data warehouse management strongly desired. Visual Basic, .NET, and/or XML. Please send your current resume in confidence to <staffing@eurosoft-inc.com> ..45287057605. ...

US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45287357605)
US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45287357605) ========================================================================================= Position: SQL Server Database Admin Reference: SMC01150 Location: San Antonio TX Duration: C-P Skills: 5 + years IT experience, 3 + years Database Administration and Architecture with SQL Server. Unix scripting, data warehouse, data modeling, data standards, development and management, data dictionary maintenance and data administration. SQL queries, and stored procedures. Good understanding of applications. MS Certification as a Solutions Developer or DBA. AIX and IBM data warehouse management strongly desired. Visual Basic, .NET, and/or XML. Please send your current resume in confidence to <staffing@eurosoft-inc.com> ..45287357605. ...

US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45287332603)
US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45287332603) ========================================================================================= Position: SQL Server Database Admin Reference: SMC01150 Location: San Antonio TX Duration: C-P Skills: 5 + years IT experience, 3 + years Database Administration and Architecture with SQL Server. Unix scripting, data warehouse, data modeling, data standards, development and management, data dictionary maintenance and data administration. ...

US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45286757609)
US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45286757609) ========================================================================================= Position: SQL Server Database Admin Reference: SMC01150 Location: San Antonio TX Duration: C-P Skills: 5 + years IT experience, 3 + years Database Administration and Architecture with SQL Server. Unix scripting, data warehouse, data modeling, data standards, development and management, data dictionary maintenance and data administration. SQL queries, and stored procedures. Good understanding of applications. MS Certification as a Solutions Developer or DBA. AIX and IBM data warehouse management strongly desired. Visual Basic, .NET, and/or XML. Please send your current resume in confidence to <staffing@eurosoft-inc.com> ..45286757609. ...

US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45285257606)
US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45285257606) ========================================================================================= Position: SQL Server Database Admin Reference: SMC01150 Location: San Antonio TX Duration: C-P Skills: 5 + years IT experience, 3 + years Database Administration and Architecture with SQL Server. Unix scripting, data warehouse, data modeling, data standards, development and management, data dictionary maintenance and data administration. SQL queries, and stored procedures. Good understanding of applications. MS Certification as a Solutions Developer or DBA. AIX and IBM data warehouse management strongly desired. Visual Basic, .NET, and/or XML. Please send your current resume in confidence to <staffing@eurosoft-inc.com> ..45285257606. ...

US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45287057605)
US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45287057605) ========================================================================================= Position: SQL Server Database Admin Reference: SMC01150 Location: San Antonio TX Duration: C-P Skills: 5 + years IT experience, 3 + years Database Administration and Architecture with SQL Server. Unix scripting, data warehouse, data modeling, data standards, development and management, data dictionary maintenance and data administration. ...

US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45287032427)
US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45287032427) ========================================================================================= Position: SQL Server Database Admin Reference: SMC01150 Location: San Antonio TX Duration: C-P Skills: 5 + years IT experience, 3 + years Database Administration and Architecture with SQL Server. Unix scripting, data warehouse, data modeling, data standards, development and management, data dictionary maintenance and data admin...

US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45287057605)
US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45287057605) ========================================================================================= Position: SQL Server Database Admin Reference: SMC01150 Location: San Antonio TX Duration: C-P Skills: 5 + years IT experience, 3 + years Database Administration and Architecture with SQL Server. Unix scripting, data warehouse, data modeling, data standards, development and management, data dictionary maintenance and data admin...

US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45287632409)
US-TX-San Antonio: SQL Server Database Admin, UNIX scripting, VB, .NET, XML (45287632409) ========================================================================================= Position: SQL Server Database Admin Reference: SMC01150 Location: San Antonio TX Duration: C-P Skills: 5 + years IT experience, 3 + years Database Administration and Architecture with SQL Server. Unix scripting, data warehouse, data modeling, data standards, development and management, data dictionary maintenance and data administration. SQL queries, and stored procedures. Good understanding of applications. MS Certification as a Solutions Developer or DBA. AIX and IBM data warehouse management strongly desired. Visual Basic, .NET, and/or XML. Please send your current resume in confidence to <staffing@eurosoft-inc.com> ..45287632409. ...

Web resources about - unix shell script - comp.databases.oracle.server

Seal script - Wikipedia, the free encyclopedia
Seal script ( simplified Chinese : 篆书 ; traditional Chinese : 篆書 ; pinyin : zhuànshū ) is an ancient style of Chinese calligraphy . It evolved ...

Super Tuesday played according to script - now everything changes
Hillary Clinton can now position herself as the grown-up in the room for the general election, while Donald Trump is setting himself up for a ...

I’ve Just Read The Pilot Script To DC Comics And NBC’s New Comedy, Powerless (UPDATE)
Emily, Del, Jackie, Teddy... UPDATE: Script scans excerpts removed, at the request of Asad Kazi of Warner Bros. Entertainment Inc. So that's ...

UnitedHealth Takes on CVS, Express Scripts With Drugs Deal
UnitedHealth Group Inc.’s OptumRx unit struck an agreement to ease customers’ access to drugs through Walgreens Boots Alliance Inc.’s drugstores, ...

‘Cannonball Run’ Revs Anew; Etan Cohen To Script, Helm ‘Cannonball’
EXCLUSIVE : Warner Bros has acquired the rights to the Cannonball Run franchise and set Tropic Thunder scribe Etan J. Cohen to write and direct ...

Dope Scenes Ben Affleck Probably Added To The Batman v Superman Script
... of the upcoming film Batman v Superman: Dawn of Justice , spent some time during the shooting of the film making last-minute edits to the script. ...

Commitment Is Ben Affleck Rewriting The Script For “Batman v Superman” While Dressed As Batman
If I've learned anything about Ben Affleck, it's that when he does something, he goes all in. When Ben Affleck decided to cheat on his wife, ...

'Game of Thrones': Jon Snow death script pages revealed - EW.com
It’s the moment that broke the hearts of fans around the world: The Night’s Watch betraying and murdering their Lord Commander (Kit Harington) ...

Script Analysis: Robert Carlock On Writing "Whiskey Tango Foxtrot"
Tina Fey's writing partner on adapting journalist Kim Barker's memoir, The Taliban Shuffle: Strange Days in Afghanistan and Pakistan . Though ...

Script For A Perfect Job Interview
Here's a script of a manager (Brittany) interviewing a job candidate (Gustavo) in a non-scripted, conversational way. Could you start interviewing ...

Resources last updated: 3/20/2016 1:25:05 AM