urgent request!!!!!!! Post: 302206587

Sponsored Content

Operating Systems Solaris urgent request!!!!!!! Post 302206587 by trantuananh24hg on Wednesday 18th of June 2008 04:48:11 AM

06-18-2008

Registered User

Quote:

Originally Posted by Haasini

Hi,

I want to know shell script and pl/sql script for database monitoring to get alerts when users executing sql on production.

Please help me out ----------------

Thanks
Haasini

Sorry all for the marginal post!

1/ Tell me what's about your kind of Oracle Server? Shared Server or Dedicated Server? Trace_sql and generate the log_file whenever the server uses Dedicated because of many reason, but the main is one Dedicated Server's process reserve one session.

2/ If you simply want to get the alertSID.ora, put it in your environment, and open it by vi editor, you need:
- Identify $ORACLE_HOME$
- Get the exactly path, example /u02/app/oracle/product/10.2.0/admin/ORCL/udump/xxx.trc
- Write a sh script, open it in your environment.

trantuananh24hg

View Public Profile for trantuananh24hg

Find all posts by trantuananh24hg

5 More Discussions You Might Find Interesting

1. HP-UX

URGENT HELP REQUEST!!!!Connection problem between HP3000 and HP9000

Hi, I am facing some problem in connecting the database(allbase) present on HP3000 through pro c programmin language that is being executed from HP 9000 machine could any one of you please help me!!! when i run the code on HP9000 machine it is connecting to database(access the local host)...

2. UNIX for Dummies Questions & Answers

urgent request

While executing a ksh file with a input parameter in background like the following bash-2.03$nohup fil.ksh 4 & the nohup session is stopped. The same ksh file while executed like bash-2.03$fil.ksh 4 works fine. I am trying the above in Solaris 5.8 in bash shell. Please let me...

3. Emergency UNIX and Linux Support

Urgent request "remove all packages with dpkg"

Hi, this might sound somewhat weird, but I need a command to remove all packages on my machine with dpkg. I know dpkg -l will list all packages, but the troublemaker isn't on the list, and the problems started as I updated the program :wall:. Thanks in advance, I REALLY appreciate it :b:

4. Shell Programming and Scripting

Urgent request to consider:Search specific name in a file and fetch specific entries

Hi all, I have 2 files, One file contain data like this FHIT CS CHRM1 PDE3A PDE3B HSP90AA1 PTK2 HTR1A ESR1 PARP1 PLA2G1B These names are mentioned in the second file(Please see attached second file) as # Drug_Target_X_Gene_Name:(Where X can be any number (1-1000)

5. Shell Programming and Scripting

URGENT Reading a file and assessing the syntax shell script URGENT

I am trying to write a shell script which takes an input file as an arguement in the terminal e.g. bash shellscriptname.sh input.txt. I would like for the file to be read line by line each time checking if the .txt file contains certain words or letters(validating the syntax). If the line being...

LEARN ABOUT CENTOS

upgradednformat

UPGRADEDNFORMAT(8)					      System Manager's Manual						UPGRADEDNFORMAT(8)

NAME

       upgradednformat - Directory Server script for upgrading the DN format

SYNOPSIS

       upgradednformat -n backendname -a database_directory [-Z serverID] [-N] [-h]

DESCRIPTION

       Updates older-style DN syntaxes to RFC 4514-style DN syntaxes for migrated databases.  This is usually needed after migrating from an older
       version of Directory Server.  This script must be run while the server is stopped.

OPTIONS

       A summary of options is included below:

       -n Backend Name
	      The name of the LDBM database to reindex.  Example: userRoot

       -a Database directory
	      The full path to the database directory.

       -Z Server Identifier
	      The server ID of the Directory Server instance.  If there is only one instance on the system, this option can be skipped.

       -N     Only checks whether any DNs in the database need to be updated.

       -h
	      Display the usage.

EXAMPLE

       upgradednformat -n userRoot -a /var/lib/dirsrv/slapd-instance2/db -Z instance2

DIAGNOSTICS

       Exit status is zero if no errors occur.	Errors result in a non-zero exit status and a diagnostic message being written to standard error.

AUTHOR

       upgradednformat was written by the 389 Project.

REPORTING BUGS

       Report bugs to http://bugzilla.redhat.com.

COPYRIGHT

       Copyright (C) 2013 Red Hat, Inc.

								    Mar 5, 2013 						UPGRADEDNFORMAT(8)