- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Wanted: Good oracle scripts.
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2003 08:19 AM
тАО01-20-2003 08:19 AM
10 points for attachments, 5 points for anything longer than 10 lines that isn't an attachement.
Only tested scripts please.
Make sure if your scripts have user id and password in them that you change them please.
Extra points(make it a two post) for any script that can read password out of an encrypted file that only the dba user(usually oracle) has access to. The point of that specific issue is to have scripts that can get password from a file that isn't plain text.
If you recommend some kind of encryption software not found in the OS, please provide a link and detailed installation instructions.
P
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2003 08:39 AM
тАО01-20-2003 08:39 AM
Re: Wanted: Good oracle scripts.
This is a script to switch the logs to the archive directory in order to backup them.
Regards,
Justo.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2003 08:41 AM
тАО01-20-2003 08:41 AM
Re: Wanted: Good oracle scripts.
This is the second part needed in order to use the switch script.
Regards,
Justo.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2003 08:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2003 08:59 AM
тАО01-20-2003 08:59 AM
Re: Wanted: Good oracle scripts.
Used for SAP and non-SAP Oracle Database rehosts, well bedded in.
Share and Enjoy! Ian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2003 10:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2003 10:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-20-2003 11:07 PM
тАО01-20-2003 11:07 PM
Re: Wanted: Good oracle scripts.
Here they are. (Refer attachements)
For more scripts on oracle Database administration please refer this metalink.http://metalink.oracle.com/metalink/plsql/ml2_gui.startup
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-21-2003 03:03 AM
тАО01-21-2003 03:03 AM
Re: Wanted: Good oracle scripts.
Please allow me to contribute the one i like most:
Filename: alerts.ksh
Description: Automatic monitoring of the production database's ALERT LOG file for exceptions.
Running it as the Oracle User, reschedules daily execution of script - morning, evening and night everyday (uses at)
Makes monitoring of the Alert log easy task!
Hope this helps!
Best Regards
Yogeeraj
PS. Don't forget to modify lines:
a. DBA1='myname@mymailserver.mu'
b. SID=pfs
to suit your own enviroment
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-21-2003 09:20 AM
тАО01-21-2003 09:20 AM
Re: Wanted: Good oracle scripts.
You must set utl_file_dir in your init file.
Change database owner to meet your requirement.
Jean-Luc