ArcSDE Operating system authentication

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

Release 9.3

http://webhelp.esri.com/arcgisserver/9.3/java/geodatabases/using_wi-29016506.htm

SQL Server Catalog Views

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 Servers Catalog Views
Change Tracking Catalog Views	Messages (For Errors) Catalog Views
CLR Assembly Catalog Views	Object Catalog Views
Databases and Files Catalog Views	Partition Function Catalog Views
Database Mail Views	Policy-Based Management Views
Database Mirroring Catalog Views	Resource Governor Catalog Views
Data Collector Views	Scalar Types Catalog Views
Data Spaces	Schemas Catalog Views
Endpoints Catalog Views	Security Catalog Views
Extended Events Catalog Views	Service Broker Catalog Views
Extended Properties Catalog Views	Server-wide Configuration Catalog Views
FileTable Catalog Views	XML Schemas (XML Type System) Catalog Views
Full-Text Search and Semantic Search Catalog Views

ORA-16038 ORA-19809 ORA-00312

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             385878488 bytes
Database Buffers          603979776 bytes
Redo Buffers               18923520 bytes
Database mounted.

ORA-16038: log 3 sequence# 42 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1: '/u02/oradata/DB/redo03.log'

Solution: 

To solve ORA-19809 error, increase the value of db_recovery_file_dest_size parameter. And start the database:

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=3G SCOPE=BOTH;

SQL> shutdown abort

SQL> startup