Blogspot - bingluo.blogspot.com - Spatial DBA - Oracle and ArcSDE
General Information:
Latest News:
ArcSDE Operating system authentication 25 Jun 2013 | 11:29 pm
Operating system authentication Release 9.3 http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/operati1778508573.htm Using Windows-authenticated users or groups in SQL Server Rel...
SQL Server Catalog Views 20 Jun 2013 | 01:18 am
Link: http://msdn.microsoft.com/en-us/library/ms174365.aspx The catalog views in SQL Server have been organized into the following categories: AlwaysOn Availability Group Catalog Views Linked Serve...
ORA-16038 ORA-19809 ORA-00312 11 Jun 2013 | 12:57 am
Got the error when starting an Oracle database: SQL> startup ORACLE instance started. Total System Global Area 1010827264 bytes Fixed Size 2045480 bytes Variable Size 38...
Server Performance and Activity Monitoring How-to Topics 6 Dec 2012 | 03:47 am
SQL Server performance info: http://msdn.microsoft.com/en-us/library/ms191511(v=sql.90).aspx
SQL Server SYNONYM 29 Nov 2012 | 12:55 am
First introduced in SQL Server 2005. SQL Server SYNONYM's can be very useful and can be created for Tables Views Assembly Stored Procedures, Table Valued Functions, Aggregations SQL Scalar Functi...
Remote Diagnostic Agent (RDA) 28 Nov 2012 | 05:10 am
1. Remote Diagnostic Agent (RDA) is a command-line diagnostic tool that is executed by an engine written in the Perl programming language. RDA provides a unified package of support diagnostics tools a...
Oracle changePerm.sh script in versions 9.2.0.8, Oracle 10g 27 Nov 2012 | 10:49 pm
changePerm.sh is a script that allows users that do not belong to the "dba" group to access and execute files in the ORACLE_HOME directory. The script is located in the ORACLE_HOME/install directory ...
EXCEL tips 30 Oct 2012 | 10:57 pm
1. How to enter soft break in EXCEL ALT+ENTER 2. How to fill an Excel column with consecutive numbers without typing each one separately? Put 1 in the first row, first column. Put 2 in the 2nd row, ...
Oracle Database Automatic Startup and Shutdown on UNIX 27 Oct 2012 | 01:42 am
Reference: http://www.oracle-base.com/articles/linux/automating-database-startup-and-shutdown-on-linux.php Automating Shutdown and Startup (11.2) Automating Shutdown and Startup (10.2) Automating S...
Oracle 10gR2 and RMAN duplicate and errors: ORA-19870, ORA-19505, ORA-27037 26 Oct 2012 | 11:53 pm
When coping backup files from target database server to auxiliary database server, then trying to duplicate a database on a new server using Oracle RMAN 10gR2, the following error occurred: channel O...
