Doris keeps telling people that I work in computers, thinking I fix PCs.  Then she remembered that I was a Computer Programmer.  In actual fact, I haven’t been a programmer for the last eight years.  So, here you are darling, I have found a pretty general overview of what my day entails:
DBA Daily Checklist
Don’t worry […]

Posted in General, Oracle 2 Comments »

When you attempt to shrink a datafile, you will recieve an error stating that there is data beyond the requested resize value:
 alter database datafile ‘c:\oradata\rjtest\system01.dbf’ resize 1m
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value
What would be helpful is if we could determine the high watermark of a datafile before we issued […]

Posted in Oracle No Comments »

To change the report server name shown in the Application Server Enterprise Manager edit :
$ORACLE_HOME/sysman/emd/targets.xml (Parameter DISPLAY_NAME, Server, and IASInternalName)
$ORACLE_HOME/reports/conf/rwservlet.properties (Parameter SERVER=<Servername>)
$ORACLE_HOME/reports/config/reportsConfig.properties (Parameter Reports_Server_Name)

Posted in Oracle No Comments »

I always forget the format for connecting to databases via JDBC (for SQLDeveloper etc), so here it is:
jdbc:oracle:thin:@hostname:port:oracle-sid

Posted in Oracle No Comments »