How can I find out how much RAM is installed in my Solaris server? How do I know how many CPUs/cores are in my Solaris server? These are two questions you may have asked yourself maybe out of curiosity or perhaps to provide information to colleagues. Well, you’ll be relieved Continue Reading
John
SnipIT No 3: Using “find” in Solaris: Part 1
SnipIT is a series of short blogs containing useful information in an easily digestible format. find is a useful command in Solaris although it may not always be a straight forward matter using it to get what you want. I have two examples which I use regularly and thought I’d share them Continue Reading
Creating an Oracle Scheduler Job
I had a requirement recently to truncate a table as our applicaition provider had identified this as the cause of an issue some of our users were experiencing. Fine, but this had to be done when the system was not being used and unfortunately, as much as I love doing Continue Reading
SnipIT No 2: Lock/Unlock User Account in Solaris
SnipIT is a series of short blogs containing useful information in an easily digestible format. When logged in as root you can lock and unlock a user account with the passwd command. Lock an Account passwd -l Unlock an Account passwd -u Confirmation of either change is then shown: passwd: Continue Reading
SnipIT No 1: Checking Permissions in Solaris
SnipIT is a series of short blogs containing useful information in an easily digestible format. First up; How to check permissions of files and folders in Solaris. This may seem obvious to some but to new-comers it should prove useful. File Permissions ls -al The a option lists all the Continue Reading
Basic User Administration in Solaris
Here are some pointers on performing basic user administration in Solaris, e.g. adding and removing/deleting a user. The commands useradd, usermod and userdel are available from /usr/sbin when logged in as a user with root privileges. To Add a User useradd -u 1001 -d /export/home/timb -m -s /bin/bash -c “Tim Continue Reading
What version of Oracle is installed?
It may seem like a strange thing for a DBA to have to find out as the assumption may be that the DBA already knows or can recall all the instances and version numbers installed instantly from memory, but if one needed to find out the version of Oracle and Continue Reading
Finding what processes are running
Brief blog on finding out what processes are running, info taken from man. To find out what processes are running, use the prstat utility from the command line. There are a number of options which you can make use of depending on what you what to see. The useage of Continue Reading
Oracle Enterprise Manager DB Console Unavailable
We had this problem a good few weeks ago – we were happily using OEM DB Console and then all of a sudden it was unavailable! The URL was the same and there was nothing that had changed to our knowledge. Several of us here spent some time and looked Continue Reading
DR and Backup/Recovery
I will looking into Data Guard, RMAN and RAC amongst other things and will put any interesting findings here which may prove useful. A couple of sites that I’m reading into right now are: Setting up Oracle DataGuard for 10g by advait Creating a Physical Standby Database – Oracle Documentation