Knight Talks Tech

Learn tech-related stuff

  • ORA-00600: internal error code

    When shutting down the database, I encountered the following: SQL> shutdown immediate Database closed. Database dismounted. ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], [] CAUSE. The cause of the error is that there are still objects in the library cache when the database shutdowns. The database is fine; there is…

  • Determine Processor and Memory Information in Solaris

    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 to hear that it is…

  • 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 with you… 1) List the…

  • 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 what I do, I didn’t…

  • 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: password information changed for

  • 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 files in the directory, including…

  • 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 Bow” -g 100 timb -u…

  • 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 any installed options, this may…

  • 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 prstat is as follows: prstat…

  • 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 around to no avail. It…

Got any book recommendations?

Get In Touch