Database Administration
DBA Guidelines and Procedures
We would like to share what we have learned with you, so browse our documentatin pages and if you find anything that you can use, you are welcome to it, as long as you be sure to give James Madison University the credit for it.
Disclaimer: Information contained on these pages reflects the way we do things here at JMU, may not be current, and may not necessarily be suitable for your particular installation. Do NOT use anything you do not understand!
- DBA Guidelines:
- DBA2001 Roles and Responsibilities of Oracle DBA
- DBA2002 Database Backup and Recovery
- DBA2003 Database Management Standards
- DBA2004 Database/Development Standards
- DBA2005 Data Ownership and Dissemination
- DBA2006 Maintaining Database Software
- DBA2007 Oracle Data Base Monitoring
- DBA2008 Data Modeling Concepts
- DBA2009 PeopleSoft Move to Production Request (PeopleTools 5 and 6)
- DBA2009.5 PeopleSoft Move to Production Request (PeopleTools 7)
- DBA2010 Request for Services
- DBA2011 PeopleSoft Database Role Monitoring
- DBA2012 PeopleSoft/Oracle Database Links
- DBA Procedures:
- DBA3001 Changing the Sysadm Password
- DBA3002 Notes on Oracle Browser 2.0 Extended version
- DBA3003 Starting Up and Shutting Down PS Scheduler
- DBA3004 Shutting Down and Starting a Database
- DBA3005 Killing a User's Session (manually)
- DBA3006 Checking Which Databases are Up and Running
- DBA3007 Copying Databases (manually creating scripts)
- DBA3008 Check Status of Systems
- DBA3009 JMU/PeopleSoft Upgrade Methodology
- DBA3010 Steps to Perform HR PeopleSoft Upgrade
- DBA3011 Scripts Available for Defrag
- DBA3012 Scripts for Copying/Moving a Database
- DBA3013 Kill an Oracle User Session
- DBA3014 Changes necessary for Application Server startup/shutdown
- DBA3015 Create a new PeopleSoft Web Server interface from and existing one
- DBA3016 Automated Oracle Database Data File Layout Generation
- DBA3017 AXIS VANDH Download from Pinnacle
- DBA3018 Creating, Starting, and Stopping TUXEDO processes
- DBA3019 Starting Patrol
- DBA3020 Secure Copy (scp)
- DBA3021 Compiling SQRs in the EMPAC System
- DBA3022 Oracle 8 Backups and Users Needed
- DBA3023 EMPAC Profiles and Directory Structure
- DBA3024 General EMPAC Things to Know
- DBA3025 Oracle Trace - Enabling and Disabling
- DBA3026 Setting Up Exports in Windows 2000
- DBA3027 Copy Database to New Server with Source Database Up
- DBA3028 Duplicating a Database in Oracle 8i
- DBA3029 Generic Steps for Recreating a PeopleSoft Environment
- DBA3030 Oracle 8.1.6 Installation and Migration
- DBA Scripts:
- DBA4001 DBA Scripts