DBA CENTRALS

Administration

  • Home
  • Installation »
    • Mssql
    • Oracle
  • Architecture »
    • Mssql
    • Oracle
  • Administration »
    • Mssql
    • Oracle
  • Backup & Recovery »
    • Mssql
    • Oracle
  • High Availability »
    • Mssql »
      • Log Shipping
      • Mirroring
      • Replication
      • Always On
    • Oracle »
      • RAC
  • SQL Commands »
    • Mssql
    • Oracle
  • Emerging DBA's

MSSQL Administration


➤ How to shrink temp db file

➤ How to recover database from suspect mode in 2008 & above

➤ How to recover database from suspect mode in 2000

➤ Datafile & log file movement

➤ Login Scripts for SQL SERVER 2000

➤ Login Scripts for SQL SERVER 2005

➤ Login Scripts for SQL SERVER 2008 & above

➤ Cannot initialize the data source object of ole db provider "microsoft.ace.oledb.12.0" for linked server

➤ A network-related or instance-specific error occurred while establishing a connection to SQL Server

Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Home
Subscribe to: Posts (Atom)

Pages

  • SQL Architecture
  • Oracle Administration
  • MSSQL Administration
  • MS SQL BACKUP & RECOVERY
  • SQL Commands
  • Oracle Commands

Search This Blog

Blog Archive

  • March 2018 (1)
  • December 2017 (2)
  • November 2017 (4)
  • September 2017 (2)
  • August 2017 (7)
  • July 2017 (35)

Popular Posts

  • ORA-17503: ksfdopn:2 Failed to open file +DATA/dbname/spfiledb.ora
    Issue: PRCR-1013 : Failed to start resource ora.DBname.db PRCR-1064 : Failed to start resource ora.DBname.db on node servername CRS-501...
  • Oracle RAC Error: CRS-2805: Unable to start 'ora.LISTENER.lsnr' because it has a 'hard' dependency on resource type 'ora.cluster_vip_net2.type' and no resource of that type can satisfy the dependency_part1
    Issue :-  LISTENER is not running on one of RAC node. After attempting to restart throws below error. [ora12c@RAC2 ~]$ srvctl start list...
  • ORA-01565: error in identifying file '+DATA/DB_NAME/spfileDB_NAME.ora'
    ISSUE :-  SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATA/DB_NAME/spf...
  • The listener supports no services
    ISSUE:- Many times we encountered an issue where the database listener was unable to connect to DB service although the associated databa...
  • OPATCHAUTO-72050 :- The result of cluvfy command contain EFAIL NODE_STATUS::server2:EFAIL
    ISSUE:- Failed: Verifying shared storage accessibility Version of exectask could not be retrieved from node "server2" Check...
  • How to take export backup or create multiple dump file on multiple file system
    Oracle's Export utility (expdp) is a useful part of an overall backup strategy.   Consider 300GB as database size , if we do not have F...
  • Mirrored databases are disconnected after you restart the database mirror in SQL Server
    Issue:-  Mirrored databases are disconnected after restart of SQL instance due to  Server Hang ,  You end the process of the SQL Serve...
  • ORA-00600: internal error code, arguments: [pesldl03_MMap: errno 1 errmsg Operation not permitted
    Issue : ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 1 with process name "DW00" prematurely ter...
  • CRS-6706: Oracle Clusterware Release patch level ('mmmmm') does not match Software patch level ('nnnnn'). Oracle Clusterware cannot be started
    Error:- [ora12c@Server1~]$ sudo /rdbms/app/12.1.0.2/grid/bin/crsctl start crs CRS-6706: Oracle Clusterware Release patch level ('100...
  • Physical architecture of SQL server
    Components:      ➣   Page      ➣   Extents      ➣   Table / Index     ➣   Database File      ➣   Database File Group      ➣   Tran...
Picture Window theme. Powered by Blogger.