I have been asked to support oracle, I have started self learning and had some corporate training as well. In this post, I am sharing how to build VM and install oracle database in your desktop or laptop. Install and build VMware workstation in your laptop Build new VM by installing CentOS or Linux Copy the DB software and install DB binaries Create a oracle database Create a listener Connect the database by putty and SQL developer How to Install Linux on VMware workstation 1&2 Install VMware work station On the OS part — install OS later option– 40 GB disk size VM –Store virtual machine in single file– Click customize…
-
-
Lost Administrator SA password SQL server 2012
There are many blog posts talking about, how to recover “SysAdmin” password in case if it’s lost OR the server is new to you and no idea that has own and access to it. In my case the second option J In my opinion, it’s very easy to work on GUI instead of command line CMD 🙂 I used a SSMS. Steps: 1. Stop the SQL server agent 2. Take the SQL server in single user mode, earlier version, it’s a bit hard All programs –> SQL server 2012 –> Configuration Tools –> SQL server configuration manager Stop the agent and take the SQL server into single user mode.…
-
An application error occurred on the server running on SQL server
Recently one of my application website went down. I checked all the basic connectivity troubleshooting and seem everything was looking and working fine. Finally, I found the problem with the browser service but that’s also in running state. Error from the event viewer: The quick solution is rebooting the SQL browser (Start –>All programs–>Microsoft SQL server 200X–>Configuration tools –>SQL server configuration Manager) without rebooting SQL service. I searched and found a couple of MS links (KB-2526552 And SQLBrowser Unable to start) but, I did not apply it. I used another way that is also a permanent fix. Troubleshooting ways and a permanent fix: For me it’s…
-
Create and setup a SQL clustering on your Desktop or Laptop
How to create and setup a SQL clustering on your Desktop or Laptop I thought to write this post after I discussed in a forum. SQL clustering is a bit complicated one. I mean most of the DBAs are not configured or tested it, because we don’t get a chance to do or to learn SQL clustering. Also it needs bit knowledge from out of SQL (Windows AD, Network and Storage (SAN)). In this post, I will give you an idea how to configure SQL failover clustering to yourself. We are doing everything in virtual environment (Single machine) the same you can do physically but you need all in…
-
Login failed for [SQLSTATE 28000] (Error 18456) the step failed
Login failed for [SQLSTATE 28000] (Error 18456) the step failed When you query the data from another SQL server (Linked server) and SQL server & agent service is run as a domain user. You may get the error following error message in your job history. Error: Executed as user: Domain\XXX.Service. Login failed for user ‘ SSBF\SQL.Service ‘. [SQLSTATE 28000] (Error 18456). The step failed. Solution: Step 1: Check the source SQL server agent logon service account name All programs –> SQL server 2008 –> Configuration Tools –> SQL server configuration manager. Go to the SQL server agent –> properties –> Check the logon tab and find the account name.…