You may experience the following error. When a developer installed oracle client and tested the visual studio BIDS packages ask you to fix this. We know the MS only has a visual studio BIDS 32 bit. Recently, It asked in the forum, I had managed Oracle sometimes and had same kinda issue couple more times–> https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6b6efab4-c26f-45cd-aca6-4ba3d53f13a4/the-oraoledboracle1-provider-is-not-registered-on-the-local-machine?forum=sqlintegrationservices How can we find which bit of oracle installed on: How to Tell if Oracle Client is 32 or 64 bit installed on Windows Errors: 1) Test connection failed because of an error in initializing provider. Oracle client and networking components were not found.These components are supplied by Oracle Corporation and are part of the…
-
-
How to use configure Ola Hallengren SQL server Maintenance script
Ola Hallengren Maintenance Plan Deployment Many of DBAs already started using the Ola hallengren’s maintenance plan script. It is a free script replacing traditional GUI maintenance plan. It is very good script for all type and variety of database, application and size. He is a Microsoft award winner for his maintenance plan script. Here is the steps, how to use effectively for many servers. You can use a CMS if you registered it or one be one. Here is what, I have customized it, you need to change the DB name and backup path in all the script, copy it notepad use Ctrl+H and replace it. Run the 1_MaintenanceSolution – Change the…
-
Reading execution plan sql server use of Plan Explorer
Plan Explorer I recently started using this. Since it was licensed earlier, now it’s free. This is an awesome tool for query performance tuning. SQL Server Sentry Plan Explorer is the free tool given to SQL community you can download here https://www.sentryone.com/plan-explorer click download plan explorer button with right bit. It will not ask you much for download. Plan Explorer really makes DBAs job easier, this will help to read the bigger execution plans quickly and which code block taken more time duration, even if it’s 1000 lines code. Once you have installed, open the tool click file –> new and on command text ” select * from sysobjects o…
-
FCB::Open failed: Could not open file number 2. OS error: 3(The system cannot find the path specified.).
Troubleshooting steps to do when we cannot start SQL service and receive this alert. Run –> eventvwr –> windows log –> system and filter the errors and read one by one. You can get a hint that what is the real issue. OR open the SQL server errorlog and read. — Search this on my computer ‘ERRORLOG” The description for Event ID 7024 from source Service Control Manager cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display…
-
Load SQL error log to a table
SQL server error log load to a table There are cases, we need a SQL server error log load to a table for troubleshooting. Since there will be a more informational message and logon enabled etc. Here is the script to load and read. -- create table use dba go -- drop table [tbl_errorlog_from_Nov_16_2018] create table [tbl_errorlog_from_Nov_16_2018] ( loaddate datetime, info varchar(20), text varchar(max)) -- load error log from 0 to 6 numbers default insert into [tbl_errorlog_from_Nov_16_2018] exec master..sp_readerrorlog 0 -- select errorlog select * from [tbl_errorlog_from_Nov_16_2018] --where text like '%memory%' -- delete unwanted information delete from [tbl_errorlog_from_Nov_16_2018] where text like 'Login%' delete from [tbl_errorlog_from_Nov_16_2018] where text like '%Error: 18456%' delete…