DBA Unix commands | symbol is for combine and filter the results like we use in Power Shell pipe out. R is for recursive & grep command is used to search text ps -ef |grep pmon – Get the running user process. ps -ef |grep smon – Get the running user process. Disk related commands: # df -h {-m,-k} -- Disk free # du -h /opt -- Disk usage for Particular mount point disk # pwd -present working directory # cd /opt - change directory # ls - list the files and folders -l -long list like a windows properties -lt - long list with time -ltr - long list…
-
-
Install oracle 11g on redhat centos vmware on laptop -01
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…