Oracle DBA Tips
"All about Oracle Database Administration!"
Search OracleDbaTips.com
Enter your search terms
Submit search form
http://www.oracledbatips.com
Web
Oracle DBA Tips
UNIX Tips
ESRI ArcSDE Tips
Canada DBA Jobs
Spatial DBA Blog: Oracle and ArcSDE
Oracle Database Administration
Database Administration
ALTER DATABASE DATAFILE - Resize a Datafile
Calculate Oracle database size and used storage
Change a user's password temporally in Oracle
create spfile from pfile and create pfile from spfile
Change Oracle database between Standard Edition and Enterprise Edition
Cloning database and ORA-01194 and ORA-01547
How to change Oracle hidden parameters
How to clone an Oracle database from a cold backup
How to DROP a Datafile from a Tablespace
How to Rename or Move Datafiles and Logfiles
How to Switch between ARCHIVELOG and NOARCHIVELOG
How to shrink UNDO tablespace size?
Oracle 10g SGA views
Oracle Database Startup and Shutdown
Oracle Server Architecture on UNIX and NT
Using ACCOUNT_STATUS Column in DBA_USERS
RMAN (Recovery Manager)
Clone Database from a RMAN Cold backup
How to Unregister Target Database from RMAN Recovery Catalog in Oracle 10G?
Oracle 11gR2 RMAN new feature: Duplicate without connecting to target database and catalog
Oracle Database Backup and Recovery Scenarios
RMAN compression
RMAN duplicate failed with ORA-19870 ORA-19505 ORA-27037
RMAN errors when resync RMAN catalog: RMAN-20033, RMAN-03009, RMAN-00571, RMAN-00571
RMAN Recovery catalog
Top 10 Oracle Database Backup and Recovery best practices
Using RMAN to duplicate database and error ora-01547, ora-01152, ora-01110
DBA Reference
Endianness and operating systems
Oracle Data Dictionary Views
Oracle database behaviour change information for DBA
Oracle Database Components and Schemas
Oracle Database Troubleshooting and Tuning Views
Oracle dynamic performance views
Oracle dynamic performance views for database statistics
Oracle initialization parameters
Oracle PGA Monitoring Views
Oracle server alerts views
Oracle Tablespace Data Dictionary Views
Quick Reference to Auditing Information
Oracle 11g
DBA_USERS_WITH_DEFPWD
DBA_USERS and password in Oracle 11g
Oracle 11g: About TRM Trace Files
Oracle 11g: Automatic Diagnostic Repository (ADR)
Oracle 11g: ORA-700 Soft Internal Errors
Oracle 11g New Feature - Case Sensitive Passwords and Strong User Authentication
Oracle 11g New Feature - Database Core
Oracle 11g New Feature - Easier Recovery from Loss of SPFILE
Oracle 11g New Feature - Read-Only Tables
Oracle 11g New Feature - Temporary Tablespace ONLINE Shrink
Oracle 11gR2 Install (Non-RAC): New Changes With All New 11.2 Installer
Oracle 11gR2 RMAN new feature: Duplicate without connecting to target database and catalog
Oracle Utilities
Oracle utility - orapwd
Oracle utility - STATSPACK
Oracle Errors and Troubleshooting
Oracle error messages
ORA-00020: maximum number of processes (string) exceeded
ORA-00201: control file version string incompatible with ORACLE version string
ORA-00490: PSP process terminated with error
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose]
ORA-01033: ORACLE initialization or shutdown in progress
ORA-01078: failure in processing system parameters
ORA-01157: cannot identify/lock data file string - see DBWR trace file
ORA-29278: SMTP transient error: 421 Service not available
Oracle Data Dictionary Views
AUDIT_ACTIONS
Oracle dynamic performance views
v$database
V$PROCESS
UNIX
UNIX command reference
Common UNIX Commands Available on Most UNIX Platforms
Unix Commands on Different OS
UNIX command - alias, unalias
UNIX command - apropos
UNIX command - at, batch
UNIX command - date
UNIX command - df
UNIX command - du
UNIX command - gzip, gunzip, gzcat
UNIX command - id
UNIX command - last
UNIX command - mailx
UNIX command - mkdir
UNIX command - mpstat
UNIX command - sar
UNIX command - scp
UNIX command - tee
UNIX command - uname
UNIX command - vmstat
UNIX tasks
How to determine a Solaris OS is 32 bits or 64 bits by using isainfo
How to determine the size of an Oracle process on UNIX
How to set up exclude_list files on NetBackup clients
How to set up SSH for no password on UNIX database servers
Setting up exclude_list file on NetBackup clients
UNIX commands for Oracle DBA
UNIX commands used to gather system resource information
UNIX Data Gathering Tools for Operating Statistics
UNIX directory structure
ESRI ArcSDE
ArcSDE Tasks and Commands
An example of spatial index tuning in ArcSDE 9.1
ArcSDE Administration Commands
ArcSDE Administration Commands - sdemon
ArcSDE Administration Commands - sdelayer
ArcSDE Administration Commands - sdetable
ArcSDE Administration Commands - sdeexport
ArcSDE Administration Commands - sdeconfig
ArcSDE Administration Commands - sdedbtune
ArcSDE Administration Commands - sdeimport
ArcSDE Administration Commands - sde2shp
ArcSDE Administration Commands - sde2tbl
ArcSDE Administration Commands - tbl2sde
ArcSDE Administration Commands - shp2sde
ArcSDE Administration Commands - sdexinfo
ArcSDE Notes
ESRI Links
Geometry validation rules in Oracle Spatial
How to Edit DBTUNE table
How to Load spatial data between layers with different spatial columns
How to obtain information about the geometry of the features in a layer
Upgrading an ArcSDE geodatabase from 9.1 to 9.3
Using sdelayer to obtain ArcSDE geometry information
ArcSDE Error Codes
ArcSDE Exit Codes
ArcSDE error codes (0 to -20)
ArcSDE error codes (-21 to -40)
ArcSDE error codes (-41 to -60)
ArcSDE error codes (-61 to -80)
ArcSDE error codes (-81 to -100)
ArcSDE error codes (-101 to -120)
ArcSDE error codes (-121 to -140)
ArcSDE error codes (-141 to -160)
ArcSDE error codes (-161 to -180)
ArcSDE error codes (-181 to -200)
ArcSDE error codes (-201 to -220)
ArcSDE error codes (-221 to -240)
ArcSDE error codes (-241 to -260)
ArcSDE error codes (-261 to -280)
ArcSDE error codes (-281 to -300)
ArcSDE error codes (-301 to -320)
ArcSDE error codes (-321 to -340)
ArcSDE error codes (-341 to -360)
ArcSDE error codes (-361 to -380)
ArcSDE error codes (-381 to -400)
ArcSDE error codes (-401 to -444)
ArcSDE error codes (-1000 to -1018)
Return codes introduced in ArcSDE 9.3
Legal Notice:
Oracle DBA Tips website(http://www.oracledbatips.com) is provided as is, and is for informational purposes only. Please use the vendor's support and your own judgement before applying what you read on this website.
©2010 http://www.oracledbatips.com All Rights Reserved.